SAP Table Relations - Abap

1 SAP Table Relationsversion byChristopher Solomonwithcontributions byvarious SAP ProfessionalsTable KeyLink KeyOne-to-OneOne-to-ManyOneOneOneManySAP Table Name( Table Description)SAP Field Name (Field Description)Useful FieldsSAP Table InformationHow to use this document?SAP Field Name (Field Description)SAP Table Name( Table Description)Transparent TableCluster TableThis document displays and describes the relationships and links between the various SAP database tables. These relationships aredisplayed graphically as described below:Master Data TablesCEPC = Profit Center Master Data TableCSKS = Cost Center MasterKNA1 = Cutomer Master (General Data)LFA1 = Vendor Master (General Data)MARA = Material Master (General Data)SKB1 = G/L Account Master (Company Code)T001W = Plants/BranchesT001 = Company CodesSAP - FI/COFinancialAccountingSpecial PurposeLedgerControllingAccountsPayableG eneralLedgerAccountsReceivableReconcilla tion LedgerCustomLedgerProfit CenterAccountingCost CenterAccountingTables.

2 BSADBSASBSEGBSESBSIKBSIS FI/COTable MappingAll FIdocumentsClosed itemsOpen ItemsClosed itemsClosed itemsOpen ItemsOpen ItemsDuplicate InvoicesVBLNRLFC1(Vendor master (transaction figures))Vendor (LIFNR)Company Code (BUKRS)Fiscal Year (GJAHR)KNC1(Customer master (trans figures))Customer (KUNNR)Company Code (BUKRS)Fiscal Year (GJAHR)BSAS(Accounting: Secondary index for G/Laccounts (cleared items))Company Code (BUKRS)G/L Account (HKONT)Clearing Date (AUGDT)Clearing Doc (AUGBL)Allocation No (ZUONR)Fiscal Year (GJAHR)Document No (BELNR)Line Items (BUZEI)BSIP(Index for vendor validation of doubledocuments)Company Code (BUKRS)Vendor (LIFNR)Currency (WAERS)Document Date (BLDAT)Reference Doc (WRBTR)Amount (WRBTR)Document No (BELNR)Fiscal Year (GJAHR)Line Items (BUZEI)BSIK(Accounting: Secondary index forvendors)Company Code (BUKRS)Vendor (LIFNR)Special G/L Trans (UMSKS)Special G/L Ind (UMSKZ)Clearing Date (AUGDT)Clearing Doc (AUGBL)Allocation No (ZUONR)Fiscal Year (GJAHR)Document No (BELNR)Line Items (BUZEI)BSAK(Accounting.)

3 Secondary index forvendors (cleared items))Company Code (BUKRS)Vendor (LIFNR)Special G/L Trans (UMSKS)Special G/L Ind (UMSKZ)Clearing Date (AUGDT)Clearing Doc (AUGBL)Allocation No (ZUONR)Fiscal Year (GJAHR)Document No (BELNR)Line Items (BUZEI)BVOR(Intercompany posting procedures)Intercompany No (BVORG)Company Code (BUKRS)Fiscal Year (GJAHR)Document No (BELNR)PAYR(Payment transfer medium file)Paying Company (ZBUKR)House Bank (HBKID)Account (HKTID)Payment Method (ZLSCH)Check No (CHECKT)BSAD(Accounting: Secondary index forcustomers (cleared items))Company Code (BUKRS)Customer (KUNNR)Special G/L Trans (UMSKS)Special G/L Ind (UMSKZ)Clearing Date (AUGDT)Clearing Doc (AUGBL)Allocation No (ZUONR)Fiscal Year (GJAHR)Document No (BELNR)Line Items (BUZEI)BKPF(Accounting document header)Company Code (BUKRS)Document No (BELNR)Fiscal Year (GJAHR)BSEG(Accounting document segment)Company Code (BUKRS)Document No (BELNR)Fiscal Year (GJAHR)Line Item (BUZEI)BSISC ompany Code (BUKRS)G/L Account (HKONT)Clearing Date (AUGDT)Clearing Doc (AUGBL)Allocation No (ZUONR)Fiscal Year (GJAHR)Document No (BELNR)Line Items (BUZEI)BSID(Accounting.

4 Secondary index forcustomers)Company Code (BUKRS)Customer (KUNNR)Special G/L Trans (UMSKS)Special G/L Ind (UMSKZ)Clearing Date (AUGDT)Clearing Doc (AUGBL)Allocation No (ZUONR)Fiscal Year (GJAHR)Document No (BELNR)Line Items (BUZEI)All FI documentsOne time accountsTax documentsFinancial AccountingPhysicalLogicalBKPF(Accounting document header)Company CodeDocument NoFiscal YearBSECBSEDBSEGBSESBSETC ompany CodeDocument NoFiscal YearLine ItemCompany CodeDocument NoFiscal YearLine ItemBKPF(Accounting document header)Company CodeDocument NoFiscal YearCompany CodeDocument NoFiscal YearLine ItemBSEG(Accounting documentsegment)BSEC(One-time account datadocument segment)BSET(Tax data documentsegment)RFBLG(Cluster for accountingdocument)SAP FI/COProfit CenterAccountingROBJNRCOBJNRCost CenterAccountingSpecial Purpose LedgerCOBJNRROBJNR_____Example of a CustomLedgerReconcillationLedgerROBJNRSA P FI/COZZGLOO bject (OBJNR)ZZGLTL edger(RLDNR)Record Type (RRCTY)Version (RVERS)Fiscal Year (GJAHR)Object (ROBJNR)Object (SOBJNR)Currency (RTCUR)UOM (RUNIT)Debit/Credit Ind (DRCRX)Period (RPMAX)ZZGLOR ecord No (GL_SIRID)COFIT(Totals records - reconciliation ledger)Ledger(RLDNR)Record Type (RRCTY)Version (RVERS)Fiscal Year (GJAHR)Object (ROBJNR)Object (COBJNR)Object (SOBJNR)Currency (RTCUR)UOM (RUNIT)Debit/Credit Ind (DRCRX)Period (RPMAX)

5 COFIO2(Transaction-dependent fields forreconciliation ledger)Object (OBJNR)COFIO1(Object Table for ReconciliationLedger COFIT)Object (OBJNR)COSP(CO Object: Cost Totals - ExternalPostings)Ledger (LEDNR)Object (J_OBJNR)Fiscal Year (GJAHR)Value Type (WRTTP)Version (VERSN)Cost Element (KSTAR)CO Key (HRKFT)CO Trans (VRGNG)Trading Part ID (VBUND)Trading Part BA (PARGB)Debit/Credit Ind (BEKNZ)Currency (TWAER)Period Block (PERBL)COEP(CO object: period-related line items)Controlling Area (KOKRS)Document No (BELNR)Line Item (BUZEI)COBKC ontrolling Area (KOKRS)Document No (BELNR)GLPCA(EC-PCA: Actual Line Items)Record No (GL_SIRID)GLPCO(EC-PCA: Object Table for AccountAssignment Elements)Object (OBJNR)GLPCT(EC-PCA: Totals Table )Ledger(RLDNR)Record Type (RRCTY)Plan Version (RVERS)Fiscal Year (GJAHR)Object (ROBJNR)Object (COBJNR)Object (SOBJNR)Currency (RTCUR)UOM (RUNIT)Debit/Credit Ind (DRCRX)Period (RPMAX)GLPCC(EC-PCA: Transaction Attributes)Object (OBJNR)ControllingAccounts PayableVendor Master DataCompany Code DataGeneral DataPurchasing DataLFM1(Vendor master record purchasingorganization data)Vendor No (LIFNR)Purch Org (EKORG)LFM2(Vendor Master Record.)

6 PurchasingData)Vendor No (LIFNR)Purch Org (EKORG)Sub-range (LTSNR)Plant (WERKS)LFA1(Vendor master (general section))Vendor No (LIFNR)LFB1(Vendor master (company code))Vendor No (LIFNR)Company Code (BUKRS)LFBK(Vendor master (bank details))Vendor No (LIFNR)Bank Cntry (BANKS)Bank Key (BANKL)Bank Acc (BANKN)LFB5(Vendor master (dunning data))Vendor No (LIFNR)Company Code (BUKRS)Dunning Area (MABER)SAP FI/COAccounts ReceivableCustomer Master DataCompany Code DataGeneral DataSales Area DataSAP FI/COKNA1(General Data in Customer Master)Customer No (KUNNR)KNB1(Customer master (company code))Customer No (KUNNR)Company Code (BUKRS)KNB5(Customer master (dunning data))Customer No (KUNNR)Company Code (BUKRS)Dunning Area (MABER)KNVP(Customer Master Partner Functions)Customer No (KUNNR)Sales Org (VKORG)Distribution Ch (VTWEG)Division (SPART)Partner Function (PARVW)Partner Counter (PARZA)KNVV(Customer Master Sales Data)Customer No (KUNNR)Sales Org (VKORG)Distribution Ch (VTWEG)Division (SPART)KNVD(Customer master record salesrequest form)Customer No (KUNNR)Sales Org (VKORG)Distribution Ch (VTWEG)Division (SPART)Output Type (NA_KSCHL)Mess Language (SPRAS)Master DataCost CenterProfit CenterGeneral LedgerCost ElemetSAP FI/COCEPC(Profit center master data Table )Profit Center (PRCTR)Valid to Date (DATBI)Controlling Area (KOKRS)CEPCT(Texts for Profit Center Master Data)

7 Language (SPRAS)Profit Center (PRCTR)Valid to Date (DATBI)Controlling Area (KOKRS)CSKS(Cost center master)Controlling Area (KOKRS)Cost Center (KOSTL)Valid to Date (DATBI)CSKA(Cost elements (data dependent onchart of accounts))COA (KTOPL)Cost Element (KSTAR)CSKT(Cost Center Texts)Language (SPRAS)Controlling Area (KOKRS)Cost Center (KOSTL)Valid to Date (DATBI)CSKB(Cost elements (data dependent oncontrolling area))Controlling Area (KOKRS)COA (KTOPL)Cost Element (KSTAR)Valid to Date (DATBI)CSKU(Cost Element Texts)Language (SPRAS)COA (KTOPL)Cost Element (KSTAR)SKB1(G/L account master (company code))Company Code (BUKRS)G/L Account (SAKNR)SKA1(G/L accounts master (chart ofaccounts))COA (KTOPL)G/L Account (SAKNR)SKAT(G/L account master record (chart ofaccounts: description))Language (SPRAS)COA (KTOPL)G/L Account (SAKNR)SAP - Materials ManagementMaterials ManagementFinancial AccountingMaterials ManagementAccounts PayablePurchasingInvoiceVerificationTabl es.

8 EKKOEKPOKNMTMAKTMMT able MappingMAKT(MaterialDescription)KNMT(Cus tomer-MaterialInfo Record DataTable)makt-matnr = knmt-matnr andmakt-spras = sy-languEKKO(Purchasing DocHeader)EKPO(Purchasing DocItem)EKPO-EBELN =EKKO-EBELNMDKP(MRP Header)MDTB(MRP Detail)MDKP-DTNUM =MDTB-DTNUMP urchasing RequisitionSAP MM - PurchasingSTXH(STXD SAPscript text file header)Texts (TDOBJECT)Text Name (TDNAME)Text Id (TDID)Language (TDSPRAS)EBAN(Purchase Requisition)Purchasing Req (BANFN)Item (BNFPO)EBKN(Purchase Requisition AccountAssignment)Purchasing Req (BANFN)Item (BNFPO)Preg Account Assignment (ZEBKN)STXL(STXD SAPscript text file lines))(RELID)Texts (TDOBJECT)Text Name (TDNAME)Text Id (TDID)Language (TDSPRAS)(SRTF2)Purchase OrdersSAP MM - PurchasingS011(PURCH: Purch.

9 Group Statistics)Statistics (SSOUR)Version (VRSIO)Month (SPMON)Day (SPTAG)Week (SPWOC)Posting Period (SPBUP)Purchasing Org (EKORG)Purchasing Group (EKGRP)Vendor No (LIFNR)S012(PURCHIS: Purchasing Statistics)Statistics (SSOUR)Version (VRSIO)Month (SPMON)Day (SPTAG)Week (SPWOC)Posting Period (SPBUP)Purchasing Org (EKORG)Purchasing Group (EKGRP)Material No (MATNR)Plant (WERKS)Info Record Category (ESOKZ)Material Group (MATKL)Info Record (INFNR)Country (LAND1)EKET(Delivery Schedules)Purchasing Doc (EBELN)Item (EBELP)Delivery Schedule (ETENR)EKPO(Purchasing Document Item)Purchasing Doc (EBELN)Item (EBELP)EKKN(Account Assignment in PurchasingDocument)Purchasing Doc (EBELN)Item (EBELP)Account Assignment (ZEKKN)EKKO(Purchasing Document Header)Purchasing Doc (EBELN)EORD(Purchasing Source List)Material No (MATNR)Plant (WERKS)Source List No (ZEORD)EINA(Purch Info Record.

10 General Data)Info Record (INFNR)EINE(Purchasing Info Record: PurchasingOrganization Data)Info Record (INFNR)Purchasing Org (EKORG)Info Record Type (ESOKZ)Plant (WEKS)Goods ReceiptMKPF(Header: Material Document)Document No (MBLNR)Fiscal Year (MJAHR)SAP MM - PurchasingMSEG(Document Segment: Material)Document No (MBLNR)Fiscal Year (MJAHR)Line Item (ZEILE)EKBE(History of Purchasing Document)Purchasing Doc (EBELN)Item (EBELP)Account Assign (ZEKKN)Trans Type (VGABE)Fiscal Year (MJAHR)Document No (MBLNR)Line Item (ZEILE)MVER(Material consumption)Material NO (MATNR)Plant (WERKS)Fiscal Year (GJAHR)Period (PERKZ)Follow-on Records (ZAHLR)S011(PURCHIS: Purchasing GroupStatistics)Statistics (SSOUR)Version (VRSIO)Month (SPMON)Day (SPTAG)Week