Sap基本表關(guān)系

1、SAP Table Relatio ns version 1.0.0 compiled by Christopher Solomon with contributions by various SAP Professio nals This 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 are Trans

2、 pare nt Table SAP Table Nam e (Table Descripti on) SAP Field Name (Field Descriptio n) Table Key Cluster Table SAP Table In formation SAP Table Nam e (Table Descripti on) Useful Fields SAP Field Name (Field Descriptio n) I託J Li nk Key On e-to-One One One On e-to-Ma ny One Many CEPC = Profit Ce nter

3、 Master Data Table CSKS = Cost Center Master KNA1 = 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 nches T001 = Compa ny Codes SAP - FI/CO Tables : BSAD BSAS BSEG BSES BSIK BSIS

4、Accounts Receivable Accounts Payable Financial Special Purpose Accounting . / Ledger Controlling Reconcillatio Custom Ledge Profit Center Accounting FI/CO Table Mapp ing Duplicate I A Closed items BVOR (Intercom pany posting procedures) BSAD (Accounting: Secondary index for custom ers (cleared item

5、s) 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 (BUZE I) BSID (Accounting: Secondary index for custom ers) Company Code (BUKRS) Customer (KUN

6、NR) 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) LFC1 Intercompany No (BVORG) Company Code (BUKRS) Fiscal Year (GJAHR) Document No (BELNR) KNC1 (Custom er m aster (trans

7、fig Customer (KUNNR) Company Code (BUKRS) Fiscal Year (GJAHR) r VBLNR PAYR (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 vendo

8、r validation of double docum ents) BSIK (Accounting: Secondary index for 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 (A

9、ccounting: Secondary index for vendors (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 (BUZE I) BSIS Company Code (BUKRS) G/L Acco

10、unt (HKONT) Clearing Date (AUGDT) Clearing Doc (AUGBL) BSAS (Accounting: Secondary index for G/L accounts (cleared items) Open Items Company Code (BUKRS) Vendor (LIFNR) Currency (WAERS) Document Date (BLDAT) Reference Doc (WRBTR) Amount (WRBTR) Document No (BELNR) Fiscal Year (GJAHR) Line Items (BUZ

11、E I) Company Code (BUKRS) G/L Account (HKONT) Clearing Date (AUGDT) Clearing Doc (AUGBL) Closed items Company Code (BUKRS) Document No (BELNR) Fiscal Year (GJAHR) Line Item (BUZEI) Open Items | Company Code (BUKRS) Document No (BELNR) Fiscal Year (GJAHR) Closed items Open Items SAP FI/CO Finan cial

12、Acco un ti ng BKPF (Acco unting docume nt header) Compa ny Code Docume nt No Fiscal Year RFBLG (Cluster for acco un ti ng docume nt) ,a|F BSEC BSED BSEG BSES BSET Physical BKPF (Acco unting docume nt header) Compa ny Code Docume nt No Fiscal Year One time acco unts cume e Compa ny Code Docume nt No

13、Fiscal Year Line Item BSEG (Acco unting docume nt segme nt) BSEC (On e-time acco unt data document segme nt) Company Code Document No Fiscal Year Line Item Logical BSET (Tax data docume nt segme nt) Compa ny Code Docume nt No Fiscal Year Line Item Con trolli ng Profit Cen ter Acco un ti ng GLPCT (EC

14、-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) ROBJNR SAP FI/CO Special Purpose Ledger GLPCA (EC-PCA: Actual Line Items) Record No (GL_

15、SIRID) Example of a Custom Ledger GLPCO (EC-PCA: Obj ect Table for Account Assignment Elements) Object (OBJNR) COBJNR GLPCC (EC-PCA: Transaction Attributes) Object (OBJNR) d ZZGLO Object (OBJNR) ROBJNR ZZGLO Record No (GL_SIRID) ZZGLT Ledger(RLDNR) Record Type (RRCTY) Version (RVERS) Fiscal Year (GJ

16、AHR) Object (ROBJNR) Object (SOBJNR) Currency (RTCUR) UOM (RUNIT) Debit/Credit Ind (DRCRX) Period (RPMAX) 7 Cost Ce nter Acco un ti ng COSP (CO Obj ect: Cost Totals - External Postings) Ledger (LEDNR) Object (J_OBJNR) Fiscal Year (GJAHR) Value Type (WRTTP) Version (VERSN) Cost Element (KSTAR) CO Key

17、 (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) Controlling Area (KOKRS) Document No (BELNR) Line Item (BUZEI) COBK Controlling Area (KOKRS) Rec on cillati on Ledger COFIT (Totals records

18、 - 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) ROBJNR / COFIO2 (Transaction-dependent fields for reconciliation ledger) Object (OBJNR)

19、 J O R |COFIO1 (Object Table for Reconciliation Ledger COFIT) Object (OBJNR) Purchas ing Data LFM1 (Vendor master record purchasing organization data) Vendor No (LIFNR) Purch Org (EKORG) -1 / LFM2 (Vendor Master Record: Purchasing Data) Vendor No (LIFNR) Purch Org (EKORG) Sub-range (LTSNR) Plant (WE

20、RKS) SAP FI/CO Acco unts Payable Ven dor M aster Data Gen eral Data LFA1 (Vendor master (general section) Vendor No (LIFNR) LFBK (Vendor master (bank details) Vendor No (LIFNR) Bank Cntry (BANKS) Bank Key (BANKL) Bank Acc (BANKN) Compa ny Code Data LFB1 (Vendor master (company code) Vendor No (LIFNR

21、) Company Code (BUKRS) LFB5 (Vendor master (dunning data) Vendor No (LIFNR) Company Code (BUKRS) Dunning Area (MABER) Sales Area Data KNVP (Custom er Master Partner Functions) Customer No (KUNNR) Sales Org (VKORG) Distribution Ch (VTWE G) Division (SPART) Partner Function (PARVW) Partner Counter (PA

22、RZA) KNVV (Custom er Master Sales Data) Customer No (KUNNR) Sales Org (VKORG) Distribution Ch (VTWE G) Division (SPART) KNVD (Custom er m aster record sales request form ) Customer No (KUNNR) Sales Org (VKORG) Distribution Ch (VTWE G) Division (SPART) Output Type (NA_KSCHL) SAP FI/CO Acco unts Recei

23、vable Customer Master Data Gen eral Data Compa ny Code Data KNA1 (General Data in Custom er Master) Customer No (KUNNR) KNB1 (Custom er m aster (com Customer No (KUNNR) Company Code (BUKRS) pany code) KNB5 (Custom er m aster (dunning data) Customer No (KUNNR) Company Code (BUKRS) Dunning Area (MABER

24、) Profit Cen ter CEPC (Profit center m aster data table) Profit Center (P RCTR) Valid to Date (DATBI) Controlling Area (KOKRS) 1 CEPCT (Texts for Profit Center Master Data) Language (SPRAS) Profit Center (P RCTR) Valid to Date (DATBI) Controlling Area (KOKRS) -J Gen eral Ledger Cost Cen ter SAP FI/C

25、O Master Data CSKS (Cost center m aster) 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 Elemet CSKA (Cost elem ents (data dependent on chart of accounts) COA (KTO

26、PL) 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) SKB1 SKA1 SKAT (G/L account master (company code) Ff (G/L acc

27、ounts m aster (chart of (G/L account master record (chart of Company 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 nt L X Purchasing Materials Management Financial Accountin

28、g Accounts Payable SAP MM - Purchasing Purchasing Requisition STXH (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 nt Assig nm ent) Purchasi ng

29、 Req (BANFN) Item (BNFPO) 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 ng 1 5X0曲 Purchase Orders S011 (PURCH: Purch. Group Statistics) S012 (PURCHIS: Purchasing Stati

30、stics) Purchasing Doc (EBELN) Item (EBELP) Delivery Schedule (ETENR) EKET (Delivery Schedules) ent in Purchasing EINE (Purchasing Info Record: Purchasing Organization Data) Info Record (INFNR) Purchasing Org (EKORG) Info Record Type (ESOKZ) Plant (WEKS) EKPO (Purchasing Docum ent Item ) Purchasing D

31、oc (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) P

32、urchasing Group (EKGRP) Vendor No (LIFNR) 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

33、 (LAND1) EKKO (Purchasing Docum ent Header) Purchasing Doc (EBELN) EORD (Purchasing Source List) Material No (MATNR) Plant (WERKS) Source List No (ZEORD) SAP MM - Purchasing Goods Receipt MSEG (Docum ent Segm ent: Material) MKPF (Header: Material Docum ent) Document No (MBLNR) Fiscal Year (MJAHR) EK

34、BE (History of Purchasing Docum ent) Purchasing Doc (EBELN) Item (EBELP) Account Assign (ZE KKN) Trans Type (VGABE ) Fiscal Year (MJAHR) Document No (MBLNR) Line Item (ZEILE) Document No (MBLNR) Fiscal Year (MJAHR) Line Item (ZEILE) MVER (Material consum ption) Material NO (MATNR) Plant (WERKS) Fisc

35、al Year (GJAHR) Period (P ERKZ) Follow -on Records (ZAHLR) S031 (Statistics: Movem ents for current stocks) Statistics (SSOUR) Version (VRSIO) Month (SPMON) Day (SPTAG) Week (SPWOC) Posting Period (SPBUP) Plant (WERKS) Material No (MATNR) Storage Loc (LGORT) S011 (PURCHIS: Purchasing Group Statistic

36、s) Statistics (SSOUR) Version (VRSIO) Month (SPMON) Day (SPTAG) Week (SPWOC) Posting Period (SPBUP) Purchasing Org (EKORG) Purchasing Group (EKGRP) Vendor No (LIFNR) S013 (PURCHIS: Statistics for Vendor Evaluation) Statistics (SSOUR) Version (VRSIO) Month (SPMON) Day (SPTAG) Week (SPWOC) Posting Per

37、iod (SPBUP) Purchasing Org (EKORG) Purchasing Group (EKGRP) Vendor No (LIFNR) Material No (MATNR) Plant (WERKS) Info Record Cat (ESOKZ) Info Record (INFNR) SAP MM - Master Data Basic Data Acco un ti ng Data MBEW (Material Valuati on) Material No (MATNR) Valuation Area (BWKE Y) Valuation Type (BWTAR)

38、 SAP MM - Purchas ing Purchas ing Info Record A017 (Material Info Record (Plant-Specific) Application (KAPPL) Condition Type (KSCHL) Vendor (LIFNR) Material No (MATNR) Purchasing Org (EKORG) Plant (WERKS) Info Record Category (ESOKZ) Validity (DATBI) SAP - Project Pla nning Project Planning PROJ (Pr

39、oject Defin iti on) PRPS-PSPHI = PROJ-PSPNR PRPS-PSPNR = PRTE-POSNR and PRPS-PSPHI= PRTE-PSPHI and PRPS-PSPHI= PRHIS-PSPHI PRHIS (Proj. Hierarchy for WBS Eleme nt) PSTX-PRTXTKY = PP Table Mapp ing SAP PP - Project Planning PROJECTS Project and WBS eleme nt nu mbers have a doma in with a conv ersion

40、fun cti on module which con verts it from 8 numc in put to 24 char on output. PROJ (Project defi niti on) Project Number (PSPNR) Project Name (PSPID) - PRPS (WBS (Work Breakdow n Structure) Elem ent Master Data) Project Number (PSPHI) WBS Eleme nt Number (PSPNR) WBS Name (POSID) PRTX (PS Texts (WBS)

41、 WBS Eleme nt Number (PRPSPNR) Text Ide ntifier (PRTXTKY) PRHIS (Sta ndard WBS, Edges (Hierarchy poi nters) Project Number (PSPHI) WBS Eleme nt Number (POSNR) PSTX (PS Texts (Header) Text Ide ntifier (PRTXTKY) PS text description (PSTXTTI) PSTT SAP - Sales and Distribution Billing Tables : KONV LIKP

42、 LIPS VBAK VBAP VBBE VBEH VBEP VBFA VBLB VBLK VBPA VBRK Finacial Accounting Accounts Receivable VBRP VBUK Materials Mgmt. Material Master Sales/Order Docume nt Shippi ng/Delivery Docume nt VBBE VBLB VBLK VBPA (Part ner Table) VBAK VBRK VTTP VAPMA by Material) VBRP VBKD VBEP Lin es) VTTK-TKNUM = VTTP

43、 -TKNUM VBRK-VBELN = VBRP-VBELN VBBE-VBELN= VBAK-VBELN i i i i i VBLB-VBELN= VBAK-VBELN LIPS-VBELN = LIKP-VBELN VEPO-VENUM = VEKP-VENUM VBPA-VBELN= VBAK-VBELN VBPA-POSNR= VBAP-POSNR VBPA-VBELN : LIPS-VGBEL LIPS-VBELN = VBRP-VGBEL LIPS-POSNR= VBRP-VGPOS VBRK-KNUMV = KONV-KNUMV (SD In dex: Order Items

44、 (Sales uireme nts) (Sales Doc: Busin ess Data) VBAK-VBELN = VBAP-VBELN VAKPA (SD In dex: Order by tner Function VTTP -VBE LN LIKP-VBELN illi ng: Item data) (Sales Doc:Header) (Shipme nt Item) (Sales Doc:Delivery Header) VBFA (Doc. Flow) LIPS (Sales Doc:Deliv( Items) VBKD-VBELN = VBAP-VBELN and VBKD

45、-POSNR = VBAP-POSNR LIPS-VGBEL = VBAP-VBELN and LIPS-VGPOS = VBAP-POSNR VBEP -VBELN = VBAP-VBELN and VBAP-POSNR = VBEP -POSNR (Release Order Data) (Billi ng: Header data) (SD:Delivery Note Header) (Sales Doc:Schedule KONV (Co ndition Table) VTTK (Shipme nt Header) VEKP (SD Doc:Shippi ng Un it Header

46、) VBAP (Sales Doc:Item Info) vbelv = preceedi ng docume nt vbeln = subseque nt doc VEPO (SD Doc:Shippi ng Item content) VKDFS (SD In dex: illi ng In itiator) VEPVG (Delivery Due In dex)丿 11 VBEP-VBELN VBAK-VBELN I ! i VBELN POSNR ETENR 1 VEPO-VBELN = LIKP-VBELN VEPO-VBELN = VBLK-VBELN / LIKP VBUK vb

47、eln = docume nt nu mber illing Document VBSK (Collective P for a Sales D Header) VBSS (Collective Pr Sales Docum VKDFS (SD In dex Billing Initiat NAST (Message Sta VRPMA (SD In dex Billing Items Material) VRKPA (SD In dex Bills by Part Function) (STXD SAPscript text file (TDNAME) Language (TDSPRAS)

48、VBAK A VBKD (Sales Docum ent : Business Sales doc (VBELN) Item (POSNR) VAKPA (SD lndex:Order by Partner Function) Partner No (KUNDE) Partner Function (PARVW) Sales Org (VKORG) Trans Group (T RVOG) Document Date (AUDAT) Sales Office (VKBUR) Sales Group (VKGRP) Distribution Channel (VTWEG) Division (S

49、PART) Document Type (AUART) Customer PO No (BSTNK) Sold-to-Party (KUNNR) User Name (E RNAM) Sales Ord (VBELN) VKDFS (SD Index:Billing Initiator) Billing Cat (FKTYP) Sales Org (VKORG) Billing Date (FKDAT) Customer (KUNNR) Billing Type (FKART) Country (LLAND) Sales doc (VBELN) SAP SD - Sales Tables (S

50、ales Docum ent : Schedule Lines) Sales doc (VBELN) Item (POSNR) Schedle Line (E TENR) VAPMA (SD Index:Order Item s by Material) Material No (MATNR) Sales Org (VKORG) Trans Group (T RVOG) Document Date (AUDAT) Distribution Channel (VTWEG) Division (SPART) Document Type (AUART) Sold-to-Party (KUNNR) S

51、ales Office (VKBUR) Sales Group (VKGRP) Customer PO No (BSTNK) User Name (E RNAM) Sales Ord (VBELN) Item (POSNR) VBFA (Sales Docum ent Flow ) Preceding Sales Doc (VBELV) Preceding Item (P OSNV) Subsequent Sales doc (VBELN Subsequent Item (POSNN) Document Cat (VBTYP_N) LIPS-VGPOS = VBAP-POSNR Data) (

52、Sales Docum ent :Header) Sales doc (VBELN) VBUP (Item Status) Sales doc (VBELN) Item (POSNR) Sales doc (VBELN) Item (POSNR) VBEP STXH (STXD SAPscript text file header) STXL l Sales doc (VBELN) VBAP (Sales Docum ent : Item Info) To Shipping through L IPS l_l PS-VGBEL = VBAP-VBELN and Texts (TDOBJECT)

53、 Text Name (TDNAME) Text Id 仃 DID) Language (TDSPRAS) VBUK (Header Status) (RELID) Texts (TDC Text Name Text Id (TD (SRTF2) SAP SD - Shipping Tables VTTP (Shipm ent Item ) Delivery Doc Number(VBELN) Shipme nt Number (TKNUM) Shipme nt Item (TPNUM) VBLK (SD:Delivery Note Header) Delivery Docume nt Num

54、ber (VBELN) |VTTP-VBELN = _ _ _ VTTK-TKNUM = VTTP-TKNUM LIKP-VBELN III VBUP (Item Status) VTFA (Shipm ent Doc. Flow ) Shipme nt Number (TKNUM) Preceedi ng Doc. (VBELV) VTTK (Shipm ent Header) Shipme nt Number (TKNUM) LIKP (Sales Doc:Delivery Header) Delivery Docume nt Number (VBELN) VBUK (Header Sta

55、tus) Delivery doc (VBELN) L_ -J VBLK-VBELN = LIKP-VBELN VEPO (SD Doc:Shippi ng Ite Delivery Docume nt Nu Delivery Item (P OSNR) Shippi ng Unit Number Shippi ng Unit Item (VE VEPO-V VEKP- VBFA (Sales Docum ent Flow ) Precedi ng Sales Doc (VBELV) Precedi ng Item (P OSNV) Subseque nt Sales doc (VBELN)

56、Subseque nt Item (POSNN) Docume nt Cat (VBTYP_N) Deliverydoc (VBELN) Item (POSNR) From Sales through V BAP LIPS LIPS-VBELN = LIKP-VBELN VEPO-VBELN = LIPS-VBELN and VEPO-POSNR = LIPS-POSNR VEKP (SD Doc:Shippi Shippi ng Un it Nu SAP SD - Billing Tables Grouped Delivery (SAMMG) ent Flow Billing Cat (FK

57、TYP) Sales Org (VKORG) Billing Date (FKDAT) Customer (KUNNR) Billing Type (FKART) Country (LLAND) Sales doc (VBELN) Grouped Delivery (SAMMG) Sales doc (VBELN) VKDFS (SD Index: Billing Initiator) Material No (MATNR) Sales Org (VKORG) Billing Date (FKDAT) Distribution Channel (VTWEG) Billing Type (FKA

58、RT) Payer (KUNNR) Sold-to-Party (KUNNR) SD Doc Cat (VBTYP ) User Name (E RNAM) Billing Doc (VBELN) Item (POSNR) VBFA (Sales Docum VBSK (Collective Processing for a Sales Docum ent Header) VBSS (Collective Processing: Sale Docum ents) From Shipping through LIPS VBRP-VGBEL = LIPS-VBELN Application (KA

59、PPL) Object (OBJKY) Output Type (KSCHL) Language (SPRAS) Mess P artner (PARNR) Partner Func (P ARVW) Date (E RDAT) Time (ERUHR) VRPMA (SD Index: Billing Item s per Material) NAST (Billing: Header Data) VRKPA (Sales Index: Bills by Partner Functions) Partner No (KUNDE) Partner Function (PARVW) Sales

60、Org (VKORG) Billing Date (FKDAT) Distribution Channel (VTWEG) Billing Type (FKART) Payer (KUNNR) Sold-to-Party (KUNNR) SD Doc Cat (VBTYP ) User Name (E RNAM) Billing Doc (VBELN) VBRP (Billing: Item Data) Billing doc (VBELN) Item (POSNR) VBUK (Header Status) Sales doc (VBELN) ) and VBRP-VGPOS = LIPS-