Sap基本表关系.docx

1、Sap基本表关系SAP Table Relatio nsversion 1.0.0compiled byChristopher Solomonwithcontributions byvarious SAP Professio nalsThis docume nt displays and describes the relati on ships and links betwee n the v displayed graphically as described below:arious SAP database tables. These relati on ships areTrans

2、pare nt TableSAP Table Nam e(Table Descripti on)SAP Field Name (Field Descriptio n)Table KeyCluster TableSAP Table In formationSAP Table Nam e (Table Descripti on)Useful FieldsSAP Field Name (Field Descriptio n)I託JLi nk KeyOn e-to-OneOne OneOn e-to-Ma nyOneManyCEPC = Profit Ce nter Master Data Table

3、 CSKS = Cost Center MasterKNA1 = Cutomer Master (Ge neral Data) LFA1 = Vendor Master (Ge neral Data)MARA = Material Master (Ge neral Data) SKB1 = G/L Account Master (Compa ny Code) T001W = Pla nts/Bra nchesT001 = Compa ny CodesSAP - FI/COTables : BSAD BSASBSEG BSES BSIK BSISAccounts ReceivableAccoun

4、ts PayableFinancialSpecial PurposeAccounting . /LedgerControllingReconcillatioCustomLedgeProfit Center AccountingFI/COTable Mapp ingDuplicate IAClosed itemsBVOR(Intercom pany posting procedures)BSAD(Accounting: Secondary index for custom ers (cleared item s)Company Code (BUKRS) Customer (KUNNR) Spec

5、ial 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 (BUZE I)BSID(Accounting: Secondary index for custom ers)Company Code (BUKRS) Customer (KUNNR) Special G/L Trans (UMSKS) Special G/L Ind (U

6、MSKZ) Clearing Date (AUGDT) Clearing Doc (AUGBL) Allocation No (ZUONR) Fiscal Year (GJAHR) Document No (BELNR) Line Items (BUZE I)LFC1Intercompany No (BVORG) Company Code (BUKRS) Fiscal Year (GJAHR) Document No (BELNR)KNC1(Custom er m aster (trans fig Customer (KUNNR)Company Code (BUKRS)Fiscal Year

7、(GJAHR)rVBLNRPAYR(Paym ent transfer m edium file) Paying Company (ZBUKR)House Bank (HBKID)Account (HKTID)Payment Method (ZLSCH)Check No (CHECKT)BKPF(Accounting docum ent header)BSEG(Accounting docum ent segm ent)BSIP(Index for vendor validation of double docum ents)BSIK(Accounting: Secondary index f

8、or vendors)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 (BUZE I)BSAK(Accounting: Secondary index for vendors (cleared item s)Company Code (BUKRS

9、) 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 (BUZE I)BSISCompany Code (BUKRS) G/L Account (HKONT) Clearing Date (AUGDT) Clearing Doc (AUGBL)BSAS(Accounting: Second

10、ary index for G/L accounts (cleared item s)Open ItemsCompany Code (BUKRS) Vendor (LIFNR) Currency (WAERS) Document Date (BLDAT) Reference Doc (WRBTR) Amount (WRBTR) Document No (BELNR) Fiscal Year (GJAHR) Line Items (BUZE I)Company Code (BUKRS) G/L Account (HKONT) Clearing Date (AUGDT) Clearing Doc

11、(AUGBL)Closed itemsCompany Code (BUKRS) Document No (BELNR) Fiscal Year (GJAHR) Line Item (BUZEI)Open Items |Company Code (BUKRS) Document No (BELNR) Fiscal Year (GJAHR)Closed itemsOpen ItemsSAP FI/COFinan cial Acco un ti ngBKPF(Acco unting docume nt header)Compa ny Code Docume nt No Fiscal YearRFBL

12、G(Cluster for acco un ti ng docume nt),a|FBSEC BSED BSEG BSES BSETPhysicalBKPF(Acco unting docume nt header)Compa ny CodeDocume nt NoFiscal YearOne time acco untscumeeCompa ny CodeDocume nt NoFiscal YearLine ItemBSEG(Acco unting docume nt segme nt)BSEC(On e-time acco unt data document segme nt)Compa

13、ny Code Document No Fiscal Year Line ItemLogicalBSET(Tax data docume nt segme nt)Compa ny Code Docume nt No Fiscal YearLine ItemCon trolli ngProfit Cen ter Acco un ti ngGLPCT(EC-PCA: Totals Table) Ledger(RLDNR)Record Type (RRCTY) Plan Version (RVERS) Fiscal Year (GJAHR) Object (ROBJNR) Object (COBJN

14、R) Object (SOBJNR) Currency (RTCUR) UOM (RUNIT) Debit/Credit Ind (DRCRX) Period (RPMAX)ROBJNRSAP FI/COSpecial Purpose LedgerGLPCA(EC-PCA: Actual Line Items)Record No (GL_SIRID)Example of a CustomLedgerGLPCO(EC-PCA: Obj ect Table for AccountAssignment Elements)Object (OBJNR)COBJNRGLPCC(EC-PCA: Transa

15、ction Attributes)Object (OBJNR) dZZGLOObject (OBJNR)ROBJNRZZGLORecord No (GL_SIRID)ZZGLTLedger(RLDNR) Record Type (RRCTY) Version (RVERS) Fiscal Year (GJAHR) Object (ROBJNR) Object (SOBJNR) Currency (RTCUR) UOM (RUNIT) Debit/Credit Ind (DRCRX) Period (RPMAX)7Cost Ce nter Acco un ti ngCOSP(CO Obj ect

16、: Cost Totals - External Postings)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)COEP(CO obj ect: period-related line items) Cont

17、rolling Area (KOKRS)Document No (BELNR)Line Item (BUZEI)COBKControlling Area (KOKRS)Rec on cillati onLedgerCOFIT(Totals records - reconciliation ledger)Ledger(RLDNR) Record Type (RRCTY) Version (RVERS) Fiscal Year (GJAHR) Object (ROBJNR) Object (COBJNR) Object (SOBJNR) Currency (RTCUR) UOM (RUNIT)De

18、bit/Credit Ind (DRCRX)Period (RPMAX)ROBJNR/COFIO2 (Transaction-dependent fields for reconciliation ledger)Object (OBJNR)JOR|COFIO1(Object Table for ReconciliationLedger COFIT)Object (OBJNR)Purchas ing DataLFM1(Vendor master record purchasing organization data)Vendor No (LIFNR)Purch Org (EKORG) -1/LF

19、M2(Vendor Master Record: PurchasingData)Vendor No (LIFNR) Purch Org (EKORG) Sub-range (LTSNR) Plant (WERKS)SAP FI/COAcco unts PayableVen dor M aster DataGen eral DataLFA1(Vendor master (general section)Vendor No (LIFNR)LFBK(Vendor master (bank details)Vendor No (LIFNR)Bank Cntry (BANKS)Bank Key (BAN

20、KL)Bank Acc (BANKN) Compa ny Code DataLFB1(Vendor master (company code)Vendor No (LIFNR)Company Code (BUKRS)LFB5(Vendor master (dunning data)Vendor No (LIFNR)Company Code (BUKRS)Dunning Area (MABER)Sales Area DataKNVP(Custom er Master Partner Functions)Customer No (KUNNR) Sales Org (VKORG) Distribut

21、ion Ch (VTWE G) Division (SPART) Partner Function (PARVW) Partner Counter (PARZA)KNVV(Custom er Master Sales Data)Customer No (KUNNR) Sales Org (VKORG) Distribution Ch (VTWE G) Division (SPART)SAP FI/COAcco unts ReceivableCustomer Master DataGen eral DataKNA1/ (General Data in Custom er Master)Custo

22、mer No (KUNNR)Compa ny Code DataKNB1(Custom er m aster (comCustomer No (KUNNR) Company Code (BUKRS)pany code)KNB5(Custom er m aster (dunning data)Customer No (KUNNR) Company Code (BUKRS) Dunning Area (MABER)KNVD(Custom er m aster record sales request form )Customer No (KUNNR)Sales Org (VKORG)Distrib

23、ution Ch (VTWE G)Division (SPART)Output Type (NA_KSCHL)Profit Cen terCEPC(Profit center master data table)Profit Center (PRCTR)Valid to Date (DATBI) Controlling Area (KOKRS) 1CEPCT(Texts for Profit Center Master Data)Language (SPRAS) Profit Center (P RCTR)Valid to Date (DATBI) Controlling Area (KOKR

24、S)-JGen eral LedgerCost Cen terSAP FI/COMaster DataCSKS(Cost center master)Controlling Area (KOKRS) Cost Center (KOSTL) Valid to Date (DATBI) 一/CSKT(Cost Center Texts)Language (SPRAS) Controlling Area (KOKRS) Cost Center (KOSTL) Valid to Date (DATBI)Cost ElemetCSKA(Cost elem ents (data dependent on

25、chart of accounts)COA (KTOPL)Cost Element (KSTAR)CSKU(Cost Elem ent Texts) Language (SPRAS)COA (KTOPL)Cost Element (KSTAR)CSKB(Cost elem ents (data dependent o controlling area)Controlling Area (KOKRS)COA (KTOPL)Cost Element (KSTAR)Valid to Date (DATBI)SKB1SKA1SKAT(G/L account m aster (com pany code

26、)Ff(G/L accounts master (chart of(G/L account m aster record (chart ofCompany Code (BUKRS)accounts)accounts: description)G/L Account (SAKNR)COA (KTOPL)G/L Account (SAKNR)Language (SPRAS)COA (KTOPL)G/l Account (SAKNR)SAP - Materials Man ageme ntL X PurchasingMaterials ManagementFinancial AccountingAc

27、counts PayableSAP MM - PurchasingPurchasing RequisitionSTXH(STXD SAPscript text file header)Texts (TDOBJECT)Text Name (TDNAME)Text Id (TDID)Lan guage (TDSPRAS)EBAN(Purchase Requisiti on)Purchasi ng Req (BANFN)Item (BNFPO)EBKN(Purchase Requisiti on Accou ntAssig nm ent)Purchasi ng Req (BANFN)Item (BN

28、FPO)Preg Accou nt Assig nmen t (ZEBKN)STXL(STXD SAPscript text file lin es)(RELID)Texts (TDOBJECT)Text Name (TDNAME)Text Id (TDID)Lan guage (TDSPRAS)(SRTF2)SAP MM - Purchasi ng15X0 曲Purchase OrdersS011(PURCH: Purch. Group Statistics)S012(PURCHIS: Purchasing Statistics)Purchasing Doc (EBELN)Item (EBE

29、LP)Delivery Schedule (ETENR)EKET(Delivery Schedules)ent in PurchasingEINE(Purchasing Info Record: Purchasing Organization Data)Info Record (INFNR)Purchasing Org (EKORG)Info Record Type (ESOKZ)Plant (WEKS)EKPO(Purchasing Document Item )Purchasing Doc (EBELN) Item (EBELP)EINA(Purch Info Record: General Data)Info Record (INFNR)EKKN(Account Assignm Docum ent)Purchasing Doc (EBELN)Item (EBELP)Account Assignment (ZEKKN)Statistics (SSOUR)Version (VRSIO)Month (SPMON)Day (SPTAG)Week (SPWOC)Posting Period (SPBUP) Purchasing Org (EKORG) Purchasing