1、BC Tables in SAPdf003701e4c8cf58f983a0c70fcc471d.pdf Page 1 2020/1/281TABLES IN SAP1 CUSTOMISING31.1 GENERAL SETTINGS .31.1.1 Countries.31.1.2 Currency .31.1.3 Unit of measure.31.1.4 Calendar functions31.2 ENTERPRISE STRUCTURE .31.2.1 Definition 31.2.2 Assignment31.3 FINANCIAL ACCOUNTING.41.3.1 Comp
2、any code.41.3.2 Fi document 41.4 NOT CATEGORIZED 42 BASIC DATA / ADMINISTRATION 52.1 WORKBENCH RELATED TABLES.52.1.1 Data dictionary tables 52.1.2 Workbench 52.2 ADMINISTRATION 52.2.1 User administration 52.2.2 Batch input queue .52.2.3 Job processing 52.2.4 Spool .52.2.5 Runtime errors 62.2.6 Messa
3、ge control62.2.7 EDI62.2.8 Change documents62.2.9 Reporting tree table 62.2.10 LIS structure/control tables 63 MASTER DATA :.73.1 MATERIAL MASTER : .73.1.1 Basic data text (sap script) .73.1.2 Batches73.2 CUSTOMER MASTER DATA .73.3 VENDOR.73.4 CUSTOMER MATERIAL INFO RECORD 83.5 BANK DATA .84 CHARACT
4、ERISTICS : 94.1 CHARACTERISTICS :.94.2 CLASS TYPES AND OBJECTS : .94.3 LINKS :.95 FI/CO :105.1 FI :.105.1.1 Master data.105.1.2 Accounting documents / indices.105.1.3 Payment run105.2 CO :.105.2.1 Cost center master data 105.2.2 Cost center accounting .106 SALES AND DISTRIBUTION (SD) : 116.1 SALES O
5、RDER :.116.2 BILLING DOCUMENT : 11BC Tables in SAPdf003701e4c8cf58f983a0c70fcc471d.pdf Page 2 2020/1/2826.3 SHIPPING :116.4 DELIVERY :116.5 PRICING : .116.6 CONTRACTS : .117 MATERIAL MANAGEMENT (MM) :127.1 MATERIAL DOCUMENT 127.2 PURCHASING128 WAREHOUSE MANAGEMENT (WM) : .138.1 TRANSFER REQUIREMENT1
6、38.2 TRANSFER ORDER 138.3 MASTER DATA - STOCK POSITIONS 138.4 INVENTORY DOCUMENTS IN WM 139 QUALITY MANAGEMENT (QM) :149.1 INSPECTION LOT / INFO RECORD.149.2 QUALITY NOTIFICATION 149.3 CERTIFICATE PROFILE1410 PRODUCTION PLANNING (PP) 1510.1 WORK CENTER.1510.2 ROUTINGS/OPERATIONS.1510.3 BILL OF MATER
7、IAL.1510.4 PRODUCTION ORDERS1510.5 PLANNED ORDERS1610.6 KANBAN .1610.7 RESERVATIONS1610.8 CAPACITY PLANNING.1610.9 PLANNED INDEPENDENT REQUIREMENTS.1611 PROJECT SYSTEM (PS) 1711.1 BASIC DATA.1711.2 EQUIPMENT .1712 PLANT MAINTENANCE (PM) .1712.1 HUMAN RESOURCES 1812.2 SETTINGS.1812.3 MASTER DATA .181
8、2.4 INFOTYPES.18BC Tables in SAPdf003701e4c8cf58f983a0c70fcc471d.pdf Page 3 2020/1/2831 Customising 1.1 General settings1.1.1 Countries T005 Countries1.1.2 Currency TCURC Currency codesTCURR WisselkoersenTCURT Currency nameTCURX Decimal places for currencies.1.1.3 Unit of measure T006 Units of measu
9、re1.1.4 Calendar functionsT247 Month namesTFACD Factory calendar definitionT015M Month namesTTZZ Time zonesTTZD Summer time rulesTTZDF Summer time rules (fixed annual dates)TTZDV Summer time rules (variable dates)TTZDT Summer time rules textsTTZ5 Assign Time Tones to CountriesTTZ5S Assign time zones
10、 to regions1.2 Enterprise structure 1.2.1 DefinitionFI T880 CompanyT001 Company codeCO TKA01 Controlling areaLO T001W Plant / sales organisationT499S LocationsTSPA DivisionSD TVKO Sales organisation / company codeTVTW Distribution channelTVBUR Sales officeTVKBT Sales office textTVKGR Sales groupTVGR
11、T Sales group text T171T Sales district textMM T001L Storage locationsT024E Purchasing organizationT3001 Warehouse numberTVST Shipping pointTVLA Loading pointTTDS Transportation1.2.2 AssignmentCO TKA02 Assign company code to controlling areaLO T001K Assign plant (valuation area) to company codeBC Ta
12、bles in SAPdf003701e4c8cf58f983a0c70fcc471d.pdf Page 4 2020/1/284SD TVKO Sales organisation / company codeTVKOV Distribution channel / sales organisationTVKOS Division to sales organizationTVTA Sales ariaTVKBZ Sales office to sales areaTVBVK Sales group to sales officeTVKWZ Plants to sales organizat
13、ionMM T024E Purchasing organization / company codeT024W Plant to Purchase organization T001K Link plant ( = valuation area) / company codeTVSWZ Shipping point to plantT320 Assignment MM Storage Location to WM Warehouse1.3 Financial accounting1.3.1 Company codeT004 Chart of accountsT077S Account grou
14、p (g/l accounts)T009 Fiscal year variantsT880 Global company dataT014 Credit control area1.3.2 Fi documentT010O Posting period variantT010P Posting Period Variant NamesT001B Permitted Posting PeriodsT003 Document typesT012 House banks1.4 Not categorizedT007a Tax keysT134 Material typesT179 Materials
15、: Product HierarchiesT179T Materials: Product hierarchies: TextsTJ02T Status textTINC Customer incotermsTVFK Billing doc typesT390 PM: Shop papers for print controlBC Tables in SAPdf003701e4c8cf58f983a0c70fcc471d.pdf Page 5 2020/1/2852 Basic data / administration2.1 Workbench related tables2.1.1 Dat
16、a dictionary tablesDD02L Tables in SAPDD02T Tables descriptionDD03L Field names in SAPDD03T Field description in SAP2.1.2 WorkbenchTADIR Directory of R/3 Repository ObjectsTRDIR System table TRDIRTFDIR Function ModuleTLIBG Person responsible for function classTLIBT Function Group Short TextsTFTIT Fu
17、nction Module Short TextTSTC Transaction codes in SAPTSTCT Transaction codes textsT100 Message text (vb e000)VARID Variant dataD020T Screen textsTDEVC Development classTDEVCT Texts for development classes2.2 Administration2.2.1 User administrationUSR01 User masterUSR02 Logon dataUSR03 User address d
18、ataUSR04 User master authorizationsUSR11 User Master Texts for Profiles (USR10)UST12 User master: AuthorizationsUSR12 User master authorization valuesUSR13 Short Texts for AuthorizationsUSR40 Prohibited passwordsTOBJ ObjectsTOBC Authorization Object ClassesTPRPROF Profile Name for Activity GroupDEVA
19、CCESS Table for development user2.2.2 Batch input queueAPQD DATA DEFINITION QueueAPQI Queue info definition 2.2.3 Job processingTBTCO Job status overview tableTBTCP Batch job step overview2.2.4 SpoolTSP02 Spool: Print requestsBC Tables in SAPdf003701e4c8cf58f983a0c70fcc471d.pdf Page 6 2020/1/2862.2.
20、5 Runtime errorsSNAP Runtime errors2.2.6 Message controlTNAPR Processing programs for outputNAST Message status NACH Printer determination2.2.7 EDIEDIDC Control recordEDIDD Data recordEDID2 Data record 3.0 VersionEDIDS EDI status recordEDPAR Convert External Internal Partner NumberEDPVW EDI partner
21、typesEDPI1 EDI partner profile inboundEDPO1/2/3 EDI partner profile outbound2.2.8 Change documentsCDHDR Change document headerCDPOS Change document positionenJCDS Change Documents for System/User Statuses (Table JEST)2.2.9 Reporting tree tableSERPTREE Reporting: tree structure2.2.10 LIS structure/co
22、ntrol tablesTMC4 Global Control Elements: LIS Info StructureBC Tables in SAPdf003701e4c8cf58f983a0c70fcc471d.pdf Page 7 2020/1/2873 MASTER DATA :3.1 Material master :MARA Material masterMAKT Material textMARC Material per plant / stockMVKE Material master, sales dataMARD Storage location / stockMSKA
23、 Sales order stockMSPR Project stockMARM Units of measureMEAN International article numberPGMI Planning materialPROP Forecast parametersMAPR Link MARC PROPMBEW Material valuationMVER Material consumptionMLGN Material / Warehouse numberMLGT Material / Storage typeMPRP Forecast profilesMDTB MRP tableM
24、DKP Header data for MRP documentMLAN Tax data material masterMTQSS Material master view: QM3.1.1 Basic data text (sap script)STXB SAPscript: Texts in non-SAPscript formatSTXH STXD SAPscript text file headerSTXL STXD SAPscript text file lines3.1.2 Batches MCHA BatchesMCH1 BatchesMCHB Stock : batches3
25、.2 Customer master dataKNA1 Customer masterKNB1 Customer / companyKNVV Customer sales dataKNBK Bank detailsKNVH Customer hierarchyKNVP Customer partnersKNVS Shipment data for customerKNVK Contact personsKNVI Customer master tax indicator3.3 VendorLFA1 Vendor masterLFB1 Vendor per company codeLFB5 Ve
26、ndor dunning dataLFM1 Purchasing organisation dataLFM2 Purchasing dataLFBK Bank detailsBC Tables in SAPdf003701e4c8cf58f983a0c70fcc471d.pdf Page 8 2020/1/2883.4 Customer material info recordKNMT Customer material info record3.5 Bank dataBNKA Master bank dataBC Tables in SAPdf003701e4c8cf58f983a0c70f
27、cc471d.pdf Page 9 2020/1/2894 Characteristics :4.1 Characteristics :CABN Characteristics ( o.a. batch/vendor)CABNT Characteristics descriptionCAWN Characteristics ( o.a. material)CAWNT Characteristics descriptionAUSP Characteristic Values4.2 Class types and objects :TCLAO Several class types for obj
28、ectTCLA Class types ( vb. lfa1 = v10 en 010)TCLAT Class type textTCLT Classifiable objectsTCLC Classification status4.3 Links :INOB Link between Internal Number and ObjectKLAH Class header data KSSK Allocation Table: Object (vb.matnr) to Class KSML Characteristics for a class (internal number)BC Tab
29、les in SAPdf003701e4c8cf58f983a0c70fcc471d.pdf Page 10 2020/1/28105 FI/CO :5.1 FI :5.1.1 Master dataSKA1 AccountsBNKA Bank master record5.1.2 Accounting documents / indicesBKPF Accounting documentsBSEG item levelBSID Accounting: Secondary index for customers BSIK Accounting: Secondary index for vend
30、ors BSIM Secondary Index, Documents for Material BSIP Index for vendor validation of double documents BSIS Accounting: Secondary index for G/L accountsBSAD Accounting: Index for customers (cleared items) BSAK Accounting: Index for vendors (cleared items) BSAS Accounting: Index for G/L accounts (clea
31、red items)5.1.3 Payment runREGUH Settlement data from payment programREGUP Processed items from payment program5.2 CO :TKA01 Controlling areasTKA02 Controlling area assignmentKEKO Product-costing headerKEPH Cost components for cost of goods manuf.KALO Costing objectsKANZ Sales order items - costing
32、objects5.2.1 Cost center master dataCSKS Cost Center Master DataCSKT Cost center textsCRCO Assignment of Work Center to Cost Center5.2.2 Cost center accountingCOSP CO Object: Cost Totals for External PostingsCOEP CO Object: Line Items (by Period). COBK CO Object: Document headerCOST CO Object: Price
33、 TotalsBC Tables in SAPdf003701e4c8cf58f983a0c70fcc471d.pdf Page 11 2020/1/28116 Sales and Distribution (SD) :VBFA Document flow (alg.)VTFA Flow shipping documents6.1 Sales order :VBAK Header dataVBAP Item dataVBPA Partners in sales orderVBKD Sales district dataVBEP Data related to line items, deliv
34、ery lines6.2 Billing document :VBRK header dataVBRP Item data6.3 Shipping :VTTK Shipment headerVTTP Shipment itemVTTS Stage in transportVTSP Stage in transport per shipment itemVTPA Shipment partnersVEKP Handling Unit - Header TableVEPO Packing: Handling Unit Item (Contents)6.4 Delivery :LIKP Delive
35、ry headerLIPS Delivery item6.5 Pricing :KONH Conditions headerKONP Conditions itemsKONV Procedure ( billing doc or sales order)KOND6.6 contracts :VEDA Contract dataBC Tables in SAPdf003701e4c8cf58f983a0c70fcc471d.pdf Page 12 2020/1/28127 Material Management (MM) :7.1 Material documentMKPF material d
36、ocumentMSEG material document (item level)7.2 PurchasingEKKO Purchase documentEKPO Purchase document (item level)EKPV Shipping-Specific Data on Stock Tfr. for Purch. Doc. ItemEKET Delivery scheduleVETVG Delivery Due Index for Stock TransferEKES Order Acceptance/Fulfillment ConfirmationsEKKN Account
37、assignment in purchasingEKAN Vendor address purchasingEKPA Partner functionsEIPO Item export / import dataEINA Purchase info record (main data)EINE Purchase info record (organisational data)EORD Source listEBAN Purchase requisitionEBKN Purchase Requisition Account AssignmentBC Tables in SAPdf003701e
38、4c8cf58f983a0c70fcc471d.pdf Page 13 2020/1/28138 Warehouse Management (WM) :8.1 Transfer requirementLTBK Transfer requirement - headerLTBP Transfer requirement - item8.2 Transfer orderLTAK Transfer order - headerLTAP Transfer order - item8.3 Master data - stock positionsLQUA Quants8.4 Inventory docu
39、ments in WMLINK Inventory document headerLINP Inventory document itemLINV Inventory data per quantBC Tables in SAPdf003701e4c8cf58f983a0c70fcc471d.pdf Page 14 2020/1/28149 Quality Management (QM) : 9.1 Inspection lot / info recordQALS Inspection lot recordQAMB Link inspection lot - material document
40、QAVE Inspection usage decision QDPS Inspection stagesQMAT Inspection type - material parametersQINF Inspection info record (vendor - material)QDQL Quality levelQDPS Inspection stages9.2 Quality notificationTQ80 Notification typesQMEL Quality notificationQMFE Quality notification itemsQMUR Quality no
41、tification causesQMSM Quality notification tasksQMMA Quality notification activitiesQMIH Quality message - maintenance data excerpt9.3 Certificate profileQCVMT Certificate profile characteristic level: textsQCVM Certificate profile characteristic levelQCVK Certificate profile headerBC Tables in SAPd
42、f003701e4c8cf58f983a0c70fcc471d.pdf Page 15 2020/1/281510 Production Planning (PP)10.1 Work centerCRHH Work center hierarchy()CRHS Hierarchy structureCRHD Work center headerCRTX Text for the Work Center or Production Resource/ToolCRCO Assignment of Work Center to Cost CenterKAKO Capacity Header Segm
43、entCRCA Work Center Capacity AllocationTC24 Person responsible for the workcenter10.2 Routings/operationsMAPL Allocation of task lists to materialsPLAS Task list - selection of operations/activitiesPLFH Task list - production resources/toolsPLFL Task list - sequencesPLKO Task list - headerPLKZ Task
44、list: main headerPLPH Phases / suboperationsPLPO Task list operation / activityPLPR Log collector for tasklistsPLMZ Allocation of BOM - items to operations10.3 Bill of materialSTKO BOM - headerSTPO BOM - itemSTAS BOMs - Item SelectionSTPN BOMs - follow-up controlSTPU BOM - sub-itemSTZU Permanent BOM
45、 dataPLMZ Allocation of BOM - items to operationsMAST Material to BOM linkKDST Sales order to BOM link10.4 Production ordersAUFK Production order headersAFIH Maintenance order headerAUFM Goods movement for prod. orderAFKO Order header data PP ordersAFPO Order itemRESB Order componentenAFVC Order ope
46、rationsAFVV Quantities/dates/values in the operationAFVU User fields of the operationAFFL Work order sequenceAFFH PRT assignment data for the work order(routing)JSTO Status profileJEST Object statusAFRU Order completion confirmationsPRTs voor production ordersAFFH PRT assignment data for the work or
47、derCRVD_A Link of PRT to DocumentDRAW Document Info RecordTDWA Document TypesTDWD Data Carrier/Network NodesBC Tables in SAPdf003701e4c8cf58f983a0c70fcc471d.pdf Page 16 2020/1/2816TDWE Data Carrier Type10.5 Planned ordersPLAF Planned orders10.6 KANBANPKPS Kanban identification, control cyclePKHD Kan
48、ban control cycle (header data)PKER Error log for Kanban containers10.7 ReservationsRESB Material reservationsRKPF header10.8 Capacity planningKBKO Header record for capacity requirementsKBED Capacity requirements recordsKBEZ Add. data for table KBED (for indiv. capacities/splits)10.9 Planned indepe
49、ndent requirementsPBIM Independent requirements for materialPBED Independent requirement dataPBHI Independent requirement historyPBIV Independent requirement indexPBIC Independent requirement index for customer req.BC Tables in SAPdf003701e4c8cf58f983a0c70fcc471d.pdf Page 17 2020/1/281711 Project system (PS)11.1 Basic dataPRHI Work Breakdown Structure, Edges (Hierarchy Pointer)PROJ Project definitionPRPS WBS (Work Breakdown Structure) Element Master DataRPSCO Project info datab
