Sap基本表关系

《Sap基本表关系》由会员分享，可在线阅读，更多相关《Sap基本表关系（49页珍藏版）》请在装配图网上搜索。

1、SAP Table Relatio ns 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 par

2、e 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

3、CEPC = Profit Ce nter 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

4、 BSAS BSEG BSES BSIK BSIS \ Accounts Receivable Accounts Payable Financial Special Purpose Accounting \ ..■■■■ \ / Ledger Controlling Reconcillatio Custom Ledge Profit Center Accounting

5、 FI/CO Table Mapp ing Duplicate I A Closed items BVOR (Intercom pany posting procedures) BSAD (Accounting: Secondary index for custom ers (cleared item s)) Company Code (BUKRS) Customer (KUNNR) Special G/L Trans (UMSKS) Special G/L Ind (UMSKZ) Clearing Date (AUGDT) Clearing Doc (AUGB

6、L) 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 (UMSKZ) Clearing Date (AUGDT) Clearing Doc (AUGBL) Allocation No (ZUONR) Fiscal Ye

7、ar (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 fig Customer (KUNNR) Company Code (BUKRS) Fiscal Year (GJAHR) r VBLNR PAYR (Paym ent transfer m edium file) Paying Com

8、pany (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 for vendors) Company Code (BUKRS) Ve

9、ndor (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) Vendor (LIFNR) Special

10、 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 Account (HKONT) Clearing Date (AUGDT) Clearing Doc (AUGBL) BSAS (Accounting: Secondary index for G

11、/L accounts (cleared item s)) 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 (BUZE I) Company Code (BUKRS) G/L Account (HKONT) Clearing Date (AUGDT) Clearing Doc (AUGBL)

12、 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 Acco un ti ng BKPF (Acco unting docume nt header) Compa ny Code Docu

13、me 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 Fiscal Year Line Item BSEG (Acco

14、 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

15、 Con trolli ng Profit Cen ter Acco un ti ng 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) ROBJNR SAP FI/CO Spe

16、cial Purpose Ledger GLPCA (EC-PCA: Actual Line Items) Record No (GL_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) ROBJ

17、NR ZZGLO Record No (GL_SIRID) ZZGLT Ledger(RLDNR) Record Type (RRCTY) Version (RVERS) Fiscal Year (GJAHR) 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)

18、 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) Controllin

19、g Area (KOKRS) Document No (BELNR) Line Item (BUZEI) COBK Controlling Area (KOKRS) Rec on cillati on Ledger COFIT (Totals records - reconciliation ledger) Ledger(RLDNR) Record Type (RRCTY) Version (RVERS) Fiscal Year (GJAHR) Object (ROBJNR) Object (COBJNR) Object (SOBJNR) Currency (RTCUR) U

20、OM (RUNIT) Debit/Credit Ind (DRCRX) Period (RPMAX) ROBJNR / COFIO2 (Transaction-dependent fields for reconciliation ledger) Object (OBJNR) J O R |COFIO1 (Object Table for Reconciliation Ledger COFIT) Object (OBJNR)

21、 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 (WERKS) SAP FI/CO

22、 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

23、(LIFNR) 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 (

24、VKORG) Distribution 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) KNVD (Custom er m aster record sales request form ) Customer No (KUNNR) Sales Org

25、 (VKORG) Distribution Ch (VTWE G) Division (SPART) Output Type (NA_KSCHL) SAP FI/CO Acco unts Receivable 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

26、 (BUKRS) pany code)) KNB5 (Custom er m aster (dunning data)) Customer No (KUNNR) Company Code (BUKRS) Dunning Area (MABER) Profit Cen ter CEPC (Profit center m aster data table) Profit Center

27、 (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/CO Master Data CSKS (Cost cen

28、ter 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 (KTOPL)

29、 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 m aster (com pa

30、ny code)) —Ff (G/L accounts m aster (chart of (G/L account m aster 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)

31、 SAP - Materials Man ageme nt L X Purchasing Materials Management Financial Accounting Accounts Payable

32、 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

33、) Item (BNFPO) EBKN (Purchase Requisiti on Accou nt Assig nm ent) Purchasi ng 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) SA

34、P MM - Purchasi ng 1 5X^0^ 曲 Purchase Orders S011 (PURCH: Purch. Group Statistics) S012 (PURCHIS: Purchasing Statistics) Purchasing Doc (EBELN) Item (EBELP) Delivery Schedule (ETENR) EKET (Delivery Schedules) ent in Purchasing EINE (Purchasing Info Record: Purchasing Organ

35、ization Data) Info Record (INFNR) Purchasing Org (EKORG) Info Record Type (ESOKZ) Plant (WEKS) EKPO (Purchasing Docum ent Item ) Purchasing Doc (EBELN) Item (EBELP) EINA (Purch Info Record: General Data) Info Record (INFNR) EKKN (Account Assignm Docum ent) Purchasing Doc (EBELN) I

36、tem (EBELP) Account Assignment (ZEKKN) Statistics (SSOUR) Version (VRSIO) Month (SPMON) Day (SPTAG) Week (SPWOC) Posting Period (SPBUP) Purchasing Org (EKORG) Purchasing Group (EKGRP) Vendor No (LIFNR) Statistics (SSOUR) Version (VRSIO) Month (SPMON) Day (SPTAG) Week (SPWOC) Posting Peri

37、od (SPBUP) Purchasing Org (EKORG) Purchasing Group (EKGRP) Material No (MATNR) Plant (WERKS) Info Record Category (ESOKZ) Material Group (MATKL) Info Record (INFNR) Country (LAND1) EKKO (Purchasing Docum ent Header) Purchasing Doc (EBELN) EORD (Purchasing Source List) Material No (M

38、ATNR) 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) EKBE (History of Purchasing Docum ent) Purchasing Doc (EBELN) Item (EBELP) Account Assign

39、(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) Fiscal Year (GJAHR) Period (P ERKZ) Follow -on Records (ZAHLR) S031 (Statistic

40、s: 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 Statistics) Statistics (SSOUR) Version (VRSIO) Month (SPMON) Day (SPTAG

41、) 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 Period (SPBUP) Purchasing Org (EKORG) Purchasing Group (EKGRP)

42、 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) Valua

43、tion Area (BWKE Y) Valuation Type (BWTAR) SAP MM - Purchas ing Purchas ing Info Record A017 (Material Info Record (Plant-Specific) Applicatio

44、n (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 (Project Defin iti on) PRPS-PSPHI = PROJ-PSPNR PRPS-PSPNR = PRTE-POSNR and PRPS-PSPHI=

45、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

46、 with a conv ersion 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 (PS

47、PNR) WBS Name (POSID) PRTX (PS Texts (WBS)) 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) P

48、STT SAP - Sales and Distribution Billing Tables : KONV LIKP LIPS VBAK VBAP VBBE VBEH VBEP VBFA VBLB VBLK VBPA VBRK Finacial Accounting Accounts Receivable VBRP VBUK Materials Mgmt. Material Master

49、 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 -TKNUM VBRK-VBELN = VBRP-VBELN VBBE-VBELN=

50、 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 (Sales uireme nts) (Sales Do

51、c: 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-POSNR = VBAP

52、-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

53、) 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

54、 = VBLK-VBELN / LIKP VBUK vbeln = 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)

55、 (STXD SAPscript text file (TDNAME) Language (TDSPRAS) VBAK A VBKD (Sales Docum ent : Business Sales doc (VBELN) Item (POSNR) VAKPA (SD lndex:Order by Partner Function) Partner No (KUNDE) Par

56、tner Function (PARVW) Sales Org (VKORG) Trans Group (T RVOG) Document Date (AUDAT) Sales Office (VKBUR) Sales Group (VKGRP) Distribution Channel (VTWEG) Division (SPART) Document Type (AUART) Customer PO No (BSTNK) Sold-to-Party (KUNNR) User Name (E RNAM) Sales Ord (VBELN) VKDFS (SD Index:Billin

57、g Initiator) Billing Cat (FKTYP) Sales Org (VKORG) Billing Date (FKDAT) Customer (KUNNR) Billing Type (FKART) Country (LLAND) Sales doc (VBELN) SAP SD - Sales Tables (Sales Docum ent : Schedule Lines) Sales doc (VBELN) Item (POSNR) Schedle Line (E TENR) VAPMA (SD Index:Order Item s by Materi

58、al) 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) Sales Office (VKBUR) Sales Group (VKGRP) Customer PO No (BSTNK) User Name (E RNAM) Sales Ord (VBELN) Item (POSNR) VBFA (S

59、ales 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) (Sales Docum ent :Header) Sales doc (VBELN) VBUP (Item Status) Sales doc (VBELN) Item (POSNR) Sales doc (VBELN)

60、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) Text Name (TDNAME) Text Id 仃 DID) Language (TDSPRAS) VBUK (Header Status) (RELID) Texts (TDC Text

61、 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 Number (VBELN) |VTTP-VBELN = _ _ _— VTTK-TKNUM = VTTP-TKNUM LIKP-VBELN III

62、 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 Status) Delivery doc (VBELN) L _ "~ -J VBLK-VBELN =

63、 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 (VBE LN) Subseque nt Item (POSNN) Docume nt

64、 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

65、 SAP SD - Billing Tables Grouped Delivery (SAMMG) ent Flow Billing Cat (FKTYP) 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) Sal

66、es 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) 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 (KAPPL) Object (OBJKY) Output Type (KSCHL) Language (SPRAS) Mess P artner (PARNR) Partner Func (P ARVW) Date (E R