MM,SD,PP,FI,CO等幾個模塊常用的table

1、SAP Table Relationsversion 1.0.0compiled byChristopher Solomonwithcontributions by歷nous SAP ProfessionalsThis document displays and descnbes the relationships and links between the nous SAP database tables These relations displayed graphically as described below:Table KeyCluster TableTransparent Tab

2、leLink KeyOne-to-OneOne OneMaster 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 = Plant s/BranchesT001 = Compary Codes

3、SAP - FI/COFI/COTable MappingBVOR(Intejxom pany posting procedures htercompany Nc (BVORG) Corrpany Code (BUKRS) Ftscal Year (GJAHR) Document No (BiNR)PAYR(Payment transfer medium file)Ptymg Company (ZBUKR)House Bank (HBKD)Account (HKTD)Payment Method (ZLSCH) Check No (CHECKT)/lBSEG (Accounting docum

4、ent segment)BSAD (Accounting: Secondary index for customers (cleared items) Conpany Code (BUKRS) Customer (KUNNR)Special G/L Trans (UMSKS) Special G4_ hd . UMSKZ) Clearing Date (AUGOT) during Doc (AUGBL) Allocation No (ZUONR) Ascal Year (GJAHR) Document No (BB-NR) bne Items (BUZB)BSID (Accounting: S

5、econdary index for customers)Company Code (BUKRS)Customer (KUNNR)Special G/L Trans (UMSKS)Special G/L M .UMSKZ)Oearing Date (AUGOTJGearing Doc (AUGBL)Allocabon No (ZUONR) Fiscal Year (GJAHR) Document No (BELNR) Line Kerns (BUZB)Cbsed items/ ttmsVBLNRBKPF (Accounting document header) Conpany Code (BU

6、KRS) Document No (BdNR) Fiscal Year (GJAHR)Company Code (BUKRS) Document No (BB-NR) Fiscal Year (GJAHR) Lfie tern (BUZB)BSISCompany Code (BUKRS) G/L Account (FKONT)BSIP(Index for vendor validation of doub e documents)Conpany Code (BUKRS)Vendor (LFNR)Currtncy (WASS)Document Date (BLDAT)Dupiicate invo

7、ices Merence Doc (WRBTR)Amount (WRBTR)Document No (BB-NR) Fiscei Year (GJAHR) Lin« Ums (BUZB)ternssed itemsClosed itemBSIK (Accounting: Secondary index for vendors)Conpany Code (BUKRS)Vendor (LFNR)Specal G/L Tr«ns (UMSKS) Spec al G/L hd (IA6KZ) Gearing Date (AUGDT) Oeanng Doc (AUGBL) A loc

8、ation No (ZUONR) Fiscal Year (GJAHR) Document No (BB.NR) Lint Urra (BUZB)BSAK(Accounting: Secondary index forvendors (cleared items) C<xv(Miny Code (BUKRS) Vendor (LIFNR)Specel G/L Trans (UMSKS) Spec al aL hd (UMSKZ) Oeamg Date (AUGDT) Oearr>9 Doe (AUGBL) A location No (ZUOh«) Fiscal Year

9、 (GJAHR) Document No (BB.NR) Line Rems (BUZB)BSAS (Accounting: Secondary index for accounts (cleared items) Conpany Code (BUKRS) G/L Account (bKONT)KNC1 (Customer Customtr (K Company Co Fiscal Year (Financial AccountingControllingProfit Center AccountingGLPCT (EC-PCA: Totals Table) Ledgef(RLDNR)Reco

10、rd Type (RRCTY) Plan Version (RVERS) Fiscal Year(GJAHR) Object (ROBJNR) Object (COBJNR) Object (SOBJNR) Currency (RTCUR) UOM (RUNIT) DebiVCredit Ind (DRCRX) P«nod (RPMAX)LPCAC-PCA: Actual Line Items)Record No (GL_SIRID)BJNRCOBJNRSAP FI/COGLPCO(EC-PCA: Object Table for Account Assignment Element

11、s)Object (OBJNR)Special Purpose LedgerExample of a Custom LedgerGLPCC(EC-PCA: Transaction Attributes)Object (OBJNR)ZZGLTLedgertRLDNR) Record Typt (RRCTY) Version (RVERS) Fiscal Year(GJAHR)Object (ROBJNR)Object (SOBJNR) Currency (RTCUR) UOM (RUNIT)DebiVCredit Ind (D (RPMAX)Cost Center AccountingCOSP(

12、CO Object: Cost Totals - ExternalPosting*)Ledger (LEDNR)Object (J.OBJNR)Fiscal Year(GJAHR)Value Type (WRTTP)Verson (VERSN)Com Element (KSTAR)CO Key (HRKFT)CO Trans (VRGNG)Trading Part ID (VBUND)COEP(CO object: period*lated line itemsControlling (KOKRS)Document No (BELNR)Line Item (BUZEI)Reconciliati

13、on LedgerCOFIT(Totals records - reconciliation ledgeCOFIO2 (Transaction-dependent fields for reconciliation ledger)Object (OBJNR)Ledger(RLDNR) Record Type (RRCTY) Version (RVERS) Fiscal Year(GJAHR) Object (ROBJNR) Object (COBJNR) Object (SOBJNR) Currwncy (RTCUR) UOM (RUNIT)ROBJNRSAP FI/COAccounts Pa

14、yableVendor Master DataPurchasing DataGeneral DataCompany Code DataLFM1(Vendor master record purchasing organization data)Vendor No (LIFNR)Purch Ofg (EKORG)LFA1(Vendor master (geneQl section)Vendor No (LIFNR)/LFB1一、(Vendor mWr (company code)：Vendor No (LIFNR)Company Code (BUKRS)LFRK(Vendor (bank deU

15、ils)Vendor o LIFNR iBank Cntry (6ANKS)Bank Key (BANKL)Bank Acc LFB5(Vendor master (dunning daU)>Vtndof No (LIFNRr"Company Code (BUKRS)Dunning Area (MABER)/LFM2(Vendor Master Record: PurchA5in(DM"Vendor No (LIFNR)-Purch Ofg (EKORG)Sutwange (LTSNR)PUnt (WERKS) 、Accounts ReceivableCustomer

16、 Master DataSales Area DataKNVP (Customer Master Partner Function0Customer No (KUNNR)Sales Org (VKORG)Dstr力ution Ch (VTWEG)vision (SPART)Partner Function (PARVW)Partner Counter (PARZA_General DataCompany CockKNA1(General Data in Customer Master)Customer No (KUttJR)二 KNB1、(Customer master (coKNVV(Cus

17、tomer Master Sales Data)Customer No (KUNNR)Sales Org (VKORG)Dstribubon Ch (VTWEG)Drviscn (SPART)"'I/KNVD (Customer master record sales request form)Customer No (KUNNR) Sales Og (VKORG) Dstrution Ch (VTWEG)Custorrer No (KUNNR)Company Code (BUKRS)KNB5 (Cu«tom»r m(du Customer No (KUN

18、NR) Company Code (BUKRS) Ounning Area (ASB田)Profit CenterCEPC(Profit center master data table)ftofit Center (PRCTR) Veld to Date (DATBI) Controlling Arn (KOKRS)/K CEPCT(T”ts for Profit C，nt，r 8tdLangua0e(SPRAS)FYofit Center (PRCTR)Valid to Date (DATBI)Controlling Ares (KOKRS) _General LedgerCost Cen

19、terMaster Datacsks(Cost center master)Controling Area (KOKRS) Cost Center (KOSTL) Valid to Date (DATBI)CSKT(Cost T,xts)Language (SPRAS)Controling Area (KOKRS) Cost Center (KOSTL) Valid to Date (DATBI)Cost Ele metCSKACost elements (data dependf chart of accounts)COA (KTOPL)Cost Element (KSTAR)CSKU(Co

20、st Element Texts)Language (SPRAS)COA (KTOPL)Cost Bement (KSTAR)SAP三；hvoce /VerificationTables:EKKOEKPOKNMTMateriais Management-Materials ManagementFinancial Accountngmakt-moitnr r makt-spras MAKT(Material丫V Description)KNMT (Customer-MatenalX Info Record Data ； / J Table) J! knmt-m®tnr*d =sy-la

21、ngu/EKKO(Purchasing Doc |KHeader)/ 0<PO.ffiBLN» BOCdEBEN / EKPO (Purchasing Doc ： (Item) JSAP MM - PurchasingPurchasing RequisitionSTXH(STXD SAPscript text file header)Texts (TDOBJECT)Text Name (TDNAME)Text Id (TDD)Language (TDSPRAS)EBAN (Purchase Requisition)Purchasing Req (BANFN) hem(BNFPO

22、)EBKN1(Purchase Requisition Assignment)Rjrchasng Req (BANFN) Hem (BNFPO)Reg Account Assignmer小STXL(STXD SAPscript text file lines)(RB.D?Texts (TDOBJECT)Text Name (TDNAME)Tftwt idSAP MM - PurchasingPurchase OrdersS011(PURCH: Purch. Group Statistics)SUMbcMSSOUR)Version (VRSO)Month (SPMON)Day (SPTAG)We

23、ek (SPWOC)Posting Period (SPBUP)Purchasing Org (BCORG)Purchasing Group (B<GRP)Vendor No (LIFNR)8012(PURCHIS: Purchasing Statistics)Stistics (SSOUR) Versbn (VRSIO) Month (SPMON) Day (SPTAG) Week (SPWOC) Anting Rwiod (SPBUP) Purchasing Org (B(ORG) PUrchasng Group (EKGRP) Wtenal No (MA1NR) Ptent (WH

24、KS)Wo Record Category (ESOKZ) MftttrwJ Group (MATKL) Wo Record (NFNR) Country (LAND1)BNE (Purchasing In Organization D hfo Record (NR Rjrchasing Org hfo Record Typ4 Rant (WB<S)(Purchasing Document Header)EKET (Delivery Schedules)Purchasing Doc (田ELN) tem (EBELP)Dt»ry Schedule (ETB4R)BCKN(Acc

25、ount Assignment in Purchas Document)Purchasing Doc (田ELN) tern (EBELP) Account AsstfjnmeHt (ZEKKN)0<PO(Purchasing Document Item)Purchasing Doc (田Item (EBELP)SNA (Purch Info Rei Mo Record (NRIeord(Purchasing S<SAP MM - PurchasingGoods ReceiptS011(PURCHIS: Pun Statistics)_ Statistics (SS<X Ve

26、rsion (VRSO Month (SPMON) Dey (SPTAG) W.k (SPWOC)(!一(History of Purchasing Document)S031 (Statistics: Movements for current stocks)Document No (MBLNR) Fiscal Year (AUAHR) Une Hem (ZELE)S013 (PURCHIS: Stat Evaluation)MSEG (Document Segment: Material)MKPF(Header: Material Document)Document No (NBLhR)F

27、iscal Year (MJAHR)Rjrchasing Groi Vendor No (LIFbPurchasng Doc (EBELN) tern (田HP)Account Assign (ZBCKN)Trans Type (VGABE) Fiscal Year (MJAHR)MV田 (Material consumption)Kteterial NO (MATNR) Rant (WH«S) Fscal Year (GJAHR) Period (PERKZ)Follow -on Records (ZAUR)Statisbcs (SSOUR) Version (VRSO) Mont

28、h (SPMON) Day (SPTAG) Week (SPWOC)Statistics (SS<X Version (VRSO Month (SPMON) Dey (SPTAG) Week (SPWOC) Posting PerKxi (! ftjrcbasing Org Purchasing Groi Vendor No (LIFb Motargl Nn / MA'AccoiMBV (Material Valuati Material No (MATN Valuation Area (B Valuation Type (B、Purchasing Info RecordKONP

29、 (Conditions (item) Cond £nNoO<N5M Seq No (KOPOS)KONH (Conditions (Header) Condition 面KNUMHj-BNA(Purchasing Info Record: General 23)hfo RtcodCtNR)BNE(Purchasing Inh Organization Dj E。Record (NFN ftjrchasing Org (I Wo Record Type Rant (WKKS)A017 (Material Info R1 Appbcabon (KAPF Condition Typ

30、e (K Vendor (LFhR) Material No (MMT ftjrchasing Org (E Rant (WERKS) Wo Record Cate( Validity (DATBI)SAP - Project PlanningPRTX-PRPSPNR- PRTE-POSNRPSTX-PRTXTKYZ PRTE (Schedule Data for 、Proj. Item)PSTX-PRTXTKY « PSTT-PRTXTKYSAPSates end OstributionShippinglables:KONV LIKP LIPS VBAK VBAP VBBE VBE

31、H VBEP VBFA VBLB VBLKVBPA VBRK-Sales and DistributionVBFA(Doc. Flow)belv= preceeding document <)ein = subsequent docSales/Order DocumentVEPOLPS-VBa.N = VBRP-VGBEL LPS-POSNR= VBRP-VGPOS(SD Doc:Shipp(ng Unit Header)VEPO-VENUM- VB<P-VBWMVBAK(Sales Doc:Header)VTTP-VBa.N = LKP-VBB.NVTTK(Shipment He

32、ader)VBRP(Billing: Item data：VBPA (Partner Table)VTTP (Shipment Item)KP(Sales Dx:Deli«fyHeader) /VBRK-KNUh*/ = KONVKNUNWVBPA-VBELM- VBAK-VBELN VBF*-POSNR» VBAP-POSh«VUKDVIU KAVBEP(SalesDoc ScheduleLiVffO-VBELN - LKP-VBaNVBELNPOSNRShipping/Delivery Document(SalesRequirements)(Release O

33、rderData)SD:Dehery NoteVBLB-V VBAK-VBELNVBAK-VBELNHeader)(SDDoc:Shi Item con(SD Index: Billing Initiator)(SD Index: Order Items by Material)VBEP-VBELN- VBAK-VBELNVG(Delivery Due Index)VBSVBB.N = VBAP.VBB.N andVBAP-POSNR- VBSPOSNRVBAK-VBB.NVBAP-VBa.NVEPO-VBa.N = VBLK-VBELNSD IndexOrder byVBAP(Sales D

34、ociltemInfo)VBKD-VBB_N =VBAP-VBELNndVBKD-POSNR =VBAP-POSNRSales Doc:Business Data)VBPA-VBa.N =LPS-VGBa.LPS-VGBB.=VBAP-VBB.NndLPS-VGTOS = VBAP-POSWLPS-VBa.N = LKP-VBELNLIPS(SalesDoc:DelieryItems)VTTK-TKNUM = VTTR-TKNUMTable)VBRKVBHN = VBRP-VBH.NSAP SD - Sales TablesSTXL (STXD SAIAVAKPA(SD lndex:Order

35、 by Partner FunctionSTXH (STXD SAPscript text file header)Texts (TDOBJGCT) Text Name (TDNAME) Text Id (TOO) Language (TDSPRAS)VBUK (Header Status) Sales doc (VBHJ4)VBAK (Sales Document :Header)Sales doc (VBH.N)VAPMA(SD lndex:Order Items by Material)(RB.O) Texts (TDC Text Name Text id(TD Language(SRT

36、F2)VBFA (Sjiles Docu Preceding Sa Preceding Kti Subsequent I Subsequent I Document CaTo Shppng thrcxighLIPS LPS-VGBB. = VBAP-VBELNnd LPS-VGPOS = VBAP-POSNRVBUP (hem Status) Sales doc (VBELN) Km (POSNR)VBAP(Sales Document : Item Info)Sales doc (VBH.N) Um (POSNR)(Sales Document : ESales doc (VBB-N) te

37、m (POSNR)VBEP(Sales Document : Schedule Lines)Sates doc (VBELN) hem (POSNR)ScKdlt Line (ETBR)-rVKDFS (SD lndex:Billing Initiator) BiingCat(FKTYP) Sakes Org (VKORG) BMg Date (FKDAT) Customer (KUNNR) BiIng Tyx (FKART) Country (LLAND) Sakes doc (VBB.N)Material No (MAM) Sales Org (VKORG) Trans Group (TR

38、VOG) Document Date (AUCAT) Distribution Channel (VTWEG) Division (SPART) Document Type (AUART) SoM-to-Party (KUWR) Sakes Office (VKEUR) Sales Group (VKGRP) Customer PO No (3STNK) User Name (HV4AM) Sakes Ord (VBB.N) tern (POSNR)Partner No (KUNDE)Partner Function(PARVW) Sales Org (VKORG)Trans Group (T

39、ROG) Document Date (AUDAT) Sales Office (VKBUR) Sales Group (VKGRP) Ostrbuton Channel (VTWEG) Division (SPART) Document Type (AUART) Customer PO No(BSTNK) Sold-to-Pfirty (KUNNR) User Nome (田NAM)Salts Ord (VBaN)-一SAP SD - Shipping TablesVTTP(Shipment Item)Delivery Doc Numbef(VBELN)Shipment Number (TK

40、NUM)Shipment tem (TPNUM)VTTK-7KNUM = VTTP-TKNUMVBLK (SD:Delivery Note Header)Delivery Document Number (VBQ.N)VTTP-VBELN-LKdVBHNVTTK(Shipment Header)Shpment Number (TKNUM)VBLK-VBELN = LIKP-VBa.NVHOVBa>N = LPS-VBELN andVEPO-POSNR = LPS POSNRVEKP(SD Doc:ShapingLPS-VBS.N = LIKP-VBELNVTFA (Shipment Do

41、c. Flow)VBUK (Header Status) Defcvefy doc (VBELN)VBFA (Sales Document Flow)LIKP(Sales Doc:Delivery Header)Delivery Document Number (VBB.N)Shpment Number (TKNUM)Preceedrg Doc. (VBQ.V)Preceding Sales Doc (VBB.V)Preceding Item(POSNV) Subsequent Sales doc (VBB.N) Subsequent ltem(POSK4) Document Cat (VBT

42、YP.N)VBUP (Item Status)Deivefydoc (VBELN) tem (POSNR)VEPO (SD Pou:ShipK Delivery Docun Delivery lem(F Shipping Unit N Shipping Uhit KtSAP SD-Billing TablesVRKPA(Sales Index: BKIs by Partner Functions)Partner No (KUNDE)Partner Function (PARVW)Sales Org (VKORG)Bdmg Date (FKDAT)Dtstribubon Channel (VTWEG)BAng Type (FKART)P«yc (KUNNR)Sold-to-Party (KUNNR)SDDocCat(VBlYP) User Name(HNAM) Bdmg Doc(Sales DeGrouped d Sales doc (VBSS (Collective DocumentVBUK (Header Status) Sates doc (VBELN)VBSK (Collective Mrocessing for a bales Document Header) Grouped DeIrvery (SAMKX3)VKDFS (SD Index: Bill