Sap Tables

Sap Tables SAP Table Relations version 1.0.0 compiled by Christopher Solomon with contributions by various SAP Professionals How to use this document? This document displays and describes the relationships and links between the various SAP database tables. These relationships are displayed graphically as described below: Table Key Transparent TableCluster Table SAP Table NameSAP Table NameSAP Table Information(Table Description)(Table Description) SAP Field Name (Field Description)SAP Field Name (Field Description)Useful Fields Link Key One-to-One OneOne One-to-Many OneMany Master Data Tables CEPC = Profit Center Master Data TableCSKS = Cost Center Master KNA1 = Cutomer Master (General Data)LFA1 = Vendor Master (General Data)MARA = Material Master (General Data)SKB1 = G/L Account Master (Company Code)T001W = Plants/Branches T001 = Company Codes SAP - FI/CO Accounts Payable Reconcillation Ledger GeneralFinancialSpecial Purpose LedgerAccountingLedger Custom Ledger Accounts Receivable Controlling Profit CenterCost Center AccountingAccountingTables: BSAD BSAS BSEG BSES BSIK BSIS FI/CO Table Mapping BSIPPAYRBVOR(Index for vendor validation of double(Payment transfer medium file)(Intercompany posting procedures)documents)Paying Company (ZBUKR)Intercompany No (BVORG)Company Code (BUKRS)House Bank (HBKID)Company Code (BUKRS)Vendor (LIFNR)Account (HKTID)Fiscal Year (GJAHR)Currency (WAERS)Payment Method (ZLSCH)Document No (BELNR)Document Date (BLDAT)Check No (CHECKT)Duplicate InvoicesReference Doc (WRBTR) Amount (WRBTR) Document No (BELNR)VBLNRFiscal Year (GJAHR) Line Items (BUZEI)BKPF (Accounting document header) BSADCompany Code (BUKRS)BSIK(Accounting: Secondary index forDocument No (BELNR)(Accounting: Secondary index forcustomers (cleared items))Fiscal Year (GJAHR)vendors)Company Code (BUKRS)Company Code (BUKRS)Customer (KUNNR)Vendor (LIFNR)Special G/L Trans (UMSKS)Special G/L Trans (UMSKS)Closed itemsSpecial G/L Ind (UMSKZ)Open ItemsSpecial G/L Ind (UMSKZ)All FIClearing Date (AUGDT)documentsClearing Date (AUGDT)Clearing Doc (AUGBL)Clearing Doc (AUGBL)Allocation No (ZUONR)Allocation No (ZUONR)Fiscal Year (GJAHR)BSEGFiscal Year (GJAHR)Document No (BELNR)(Accounting document segment)Document No (BELNR)Line Items (BUZEI)Company Code (BUKRS)Line Items (BUZEI)Document No (BELNR) Fiscal Year (GJAHR) Line Item (BUZEI)Closed itemsBSAKOpen Items(Accounting: Secondary index forBSIDvendors (cleared items))(Accounting: Secondary index forCompany Code (BUKRS)customers)Vendor (LIFNR)Company Code (BUKRS)Special G/L Trans (UMSKS)Customer (KUNNR)Special G/L Ind (UMSKZ)Special G/L Trans (UMSKS)Clearing Date (AUGDT)Closed itemsSpecial G/L Ind (UMSKZ)Clearing Doc (AUGBL)Open ItemsClearing Date (AUGDT)Allocation No (ZUONR)Clearing Doc (AUGBL)Fiscal Year (GJAHR)Allocation No (ZUONR)Document No (BELNR)Fiscal Year (GJAHR)Line Items (BUZEI)Document No (BELNR) Line Items (BUZEI)KNC1 (Customer master (trans figures))BSASCustomer (KUNNR) BSIS(Accounting: Secondary index for G/LCompany Code (BUKRS)accounts (cleared items))Fiscal Year (GJAHR) Company Code (BUKRS)Company Code (BUKRS) G/L Account (HKONT)G/L Account (HKONT) Clearing Date (AUGDT)Clearing Date (AUGDT) Clearing Doc (AUGBL)Clearing Doc (AUGBL)LFC1Allocation No (ZUONR)Allocation No (ZUONR)(Vendor master (transaction figures))Fiscal Year (GJAHR)Fiscal Year (GJAHR)Vendor (LIFNR)Document No (BELNR)Document No (BELNR)Company Code (BUKRS)Line Items (BUZEI)Line Items (BUZEI)Fiscal Year (GJAHR) SAP FI/COFinancial Accounting RFBLGBKPF(Cluster for accounting(Accounting document header)document)Company CodeBSECDocument NoBSEDFiscal YearPhysicalBSEGBSESBSET BSEG(Accounting documentsegment) Company CodeDocument NoFiscal YearLine Item All FI documents BSECBKPF(One-time account dataOne time accounts(Accounting document header)document segment)Company CodeCompany CodeLogicalDocument NoDocument NoTax documentsFiscal YearFiscal YearLine Item BSET(Tax data documentsegment) Company CodeDocument NoFiscal YearLine Item SAP FI/CO Special Purpose LedgerControlling Profit CenterGLPCA (EC-PCA: Actual Line Items)AccountingExample of a Custom Record No (GL_SIRID)Ledger GLPCTZZGLO(EC-PCA: Totals Table) Ledger(RLDNR)ROBJNRObject (OBJNR)Record Type (RRCTY)ROBJNRGLPCOPlan Version (RVERS)(EC-PCA: Object Table for AccountFiscal Year (GJAHR)ZZGLTAssignment Elements)Object (ROBJNR)Object (OBJNR)COBJNRObject (COBJNR)Ledger(RLDNR)Object (SOBJNR)Record Type (RRCTY)Currency (RTCUR)Version (RVERS)ZZGLOUOM (RUNIT)Fiscal Year (GJAHR)Debit/Credit Ind (DRCRX)Object (ROBJNR)Period (RPMAX)Record No (GL_SIRID)Object (SOBJNR)GLPCCCurrency (RTCUR)(EC-PCA: Transaction Attributes)UOM (RUNIT) Debit/Credit Ind (DRCRX)Object (OBJNR)Period (RPMAX) ________________________________________________________ COEPCOFIO2Cost CenterReconcillation(CO object: period-related line items)(Transaction-dependent fields forAccountingLedgerreconciliation ledger)Controlling Area (KOKRS)Object (OBJNR)Document No (BELNR)COBJNRCOSPCOFITLine Item (BUZEI)(CO Object: Cost Totals - External(Totals records - reconciliation ledger)Postings) Ledger (LEDNR)Ledger(RLDNR)Object (J_OBJNR)Record Type (RRCTY)Fiscal Year (GJAHR)Version (RVERS)Value Type (WRTTP)Fiscal Year (GJAHR)ROBJNRVersion (VERSN)Object (ROBJNR)Cost Element (KSTAR)Object (COBJNR) CO Key (HRKFT)Object (SOBJNR)CO Trans (VRGNG)Currency (RTCUR)COFIO1Trading Part ID (VBUND)UOM (RUNIT)(Object Table for ReconciliationTrading Part BA (PARGB)COBKDebit/Credit Ind (DRCRX)Ledger COFIT)Debit/Credit Ind (BEKNZ)Period (RPMAX)Object (OBJNR)Currency (TWAER)Controlling Area (KOKRS)Period Block (PERBL)Document No (BELNR) SAP FI/CO Accounts Payable Vendor Master Data General DataPurchasing DataCompany Code DataLFM1LFA1LFB1(Vendor master record purchasing(Vendor master (general section))(Vendor master (company code))organization data)Vendor No (LIFNR)Vendor No (LIFNR)Vendor No (LIFNR)Company Code (BUKRS)Purch Org (EKORG) LFM2LFBKLFB5(Vendor Master Record: Purchasing(Vendor master (bank details))(Vendor master (dunning data))Data)Vendor No (LIFNR)Vendor No (LIFNR)Vendor No (LIFNR)Bank Cntry (BANKS)Purch Org (EKORG)Company Code (BUKRS)Bank Key (BANKL)Sub-range (LTSNR)Dunning Area (MABER)Bank Acc (BANKN)Plant (WERKS) SAP FI/CO Accounts Receivable Customer Master Data Company Code DataSales Area DataGeneral DataKNVP (Customer Master Partner Functions) Customer No (KUNNR) Sales Org (VKORG)KNA1KNB1Distribution Ch (VTWEG)(General Data in Customer Master)(Customer master (company code))Division (SPART)Customer No (KUNNR)Customer No (KUNNR)Partner Function (PARVW)Company Code (BUKRS)Partner Counter (PARZA) KNVV (Customer Master Sales Data) Customer No (KUNNR)KNB5Sales Org (VKORG)(Customer master (dunning data))Distribution Ch (VTWEG)Customer No (KUNNR)Division (SPART)Company Code (BUKRS) Dunning Area (MABER) KNVD (Customer master record sales request form) Customer No (KUNNR) Sales Org (VKORG) Distribution Ch (VTWEG) Division (SPART) Output Type (NA_KSCHL) Mess Language (SPRAS) SAP FI/CO Master Data Cost ElemetProfit CenterCost Center CSKA (Cost elements (data dependent onCEPCchart of accounts))CSKS(Profit center master data table)COA (KTOPL)(Cost center master)Cost Element (KSTAR)Profit Center (PRCTR)Controlling Area (KOKRS)Valid to Date (DATBI)Cost Center (KOSTL)Controlling Area (KOKRS)Valid to Date (DATBI) CSKB (Cost elements (data dependent on controlling area)) Controlling Area (KOKRS) COA (KTOPL) Cost Element (KSTAR) Valid to Date (DATBI)CEPCTCSKT (Texts for Profit Center Master Data)(Cost Center Texts) CSKULanguage (SPRAS)Language (SPRAS)(Cost Element Texts)Profit Center (PRCTR)Controlling Area (KOKRS) Valid to Date (DATBI)Cost Center (KOSTL)Language (SPRAS)Controlling Area (KOKRS)Valid to Date (DATBI)COA (KTOPL) Cost Element (KSTAR) General Ledger SKB1SKA1SKAT (G/L account master (company code))(G/L accounts master (chart of(G/L account master record (chart of accounts))accounts: description))Company Code (BUKRS)COA (KTOPL)Language (SPRAS)G/L Account (SAKNR)G/L Account (SAKNR)COA (KTOPL) G/L Account (SAKNR) SAP - Materials Management Purchasing Materials ManagementMaterials ManagementFinancial AccountingAccounts Payable Invoice Verification Tables: EKKO EKPO KNMT MAKT KNMT (Customer-Material Info Record Data Table) makt-matnr = knmt-matnr and makt-spras = sy-langu MAKT (Material Description) MDKP (MRP Header)EKKO (Purchasing Doc Header) MDKP-DTNUM = MDTB-DTNUM EKPO-EBELN = EKKO-EBELN MDTB (MRP Detail) EKPO (Purchasing Doc Item) MM Table Mapping SAP MM - Purchasing Purchasing Requisition EBKNSTXHEBAN(Purchase Requisition Account(STXD SAPscript text file header)(Purchase Requisition)Assignment)Texts (TDOBJECT)Purchasing Req (BANFN)Purchasing Req (BANFN)Text Name (TDNAME)Item (BNFPO)Item (BNFPO)Text Id (TDID)Preg Account Assignment (ZEBKN) Language (TDSPRAS) STXL (STXD SAPscript text file lines)) (RELID) Texts (TDOBJECT) Text Name (TDNAME) Text Id (TDID) Language (TDSPRAS) (SRTF2) SAP MM - Purchasing Purchase Orders S011S012 (PURCH: Purch. Group Statistics)(PURCHIS: Purchasing Statistics)EINEStatistics (SSOUR)Statistics (SSOUR)(Purchasing Info Record: PurchasingVersion (VRSIO)Version (VRSIO)Organization Data)Month (SPMON)Month (SPMON)Info Record (INFNR)Day (SPTAG)Day (SPTAG)Purchasing Org (EKORG)Week (SPWOC)Week (SPWOC)Info Record Type (ESOKZ)Posting Period (SPBUP)Posting Period (SPBUP)Plant (WEKS)Purchasing Org (EKORG)Purchasing Org (EKORG) Purchasing Group (EKGRP)Purchasing Group (EKGRP) Vendor No (LIFNR)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) EKPOEINA (Purchasing Document Item)(Purch Info Record: General Data) Purchasing Doc (EBELN)Info Record (INFNR) Item (EBELP) EKKN (Account Assignment in Purchasing Document) Purchasing Doc (EBELN) Item (EBELP) Account Assignment (ZEKKN) EKKOEORD (Purchasing Document Header)(Purchasing Source List) Purchasing Doc (EBELN)Material No (MATNR) Plant (WERKS) Source List No (ZEORD) SAP MM - Purchasing Goods Receipt S011 (PURCHIS: Purchasing Group Statistics) Statistics (SSOUR) Version (VRSIO)MKPFMSEGMonth (SPMON)(Header: Material Document)(Document Segment: Material)Day (SPTAG) Document No (MBLNR)Document No (MBLNR)Week (SPWOC) Fiscal Year (MJAHR)Fiscal Year (MJAHR)Posting Period (SPBUP)Line Item (ZEILE)Purchasing Org (EKORG) Purchasing Group (EKGRP) Vendor No (LIFNR) S013 (PURCHIS: Statistics for Vendor Evaluation) Statistics (SSOUR)S031Version (VRSIO)EKBE(Statistics: Movements for currentMonth (SPMON)MVER(History of Purchasing Document)stocks)Day (SPTAG)(Material consumption)Week (SPWOC)Purchasing Doc (EBELN)Statistics (SSOUR)Material NO (MATNR)Posting Period (SPBUP)Item (EBELP)Version (VRSIO)Plant (WERKS)Purchasing Org (EKORG)Account Assign (ZEKKN)Month (SPMON)Fiscal Year (GJAHR)Purchasing Group (EKGRP)Trans Type (VGABE)Day (SPTAG)Period (PERKZ)Vendor No (LIFNR)Fiscal Year (MJAHR)Week (SPWOC)Follow-on Records (ZAHLR)Material No (MATNR) Document No (MBLNR)Posting Period (SPBUP)Plant (WERKS)Line Item (ZEILE)Plant (WERKS)Info Record Cat (ESOKZ)Material No (MATNR)Info Record (INFNR)Storage Loc (LGORT) SAP MM - Master Data Basic DataAccounting DataPurchasing Data MAKTMARC(Material Descriptions)(Material Master: C Segment) Material No (MATNR)Material No (MATNR) Language (SPRAS)Plant (WERKS) MARAMBEW(Material Master: General Data)(Material Valuation)Material No (MATNR)Material No (MATNR) Valuation Area (BWKEY) Valuation Type (BWTAR)MARMMLAN(Units of Measure)(Tax Classification: Material)Material No (MATNR)Material No (MATNR)UOM (MEINH) Country (ALAND) SAP MM - Purchasing Purchasing Info Record KONPKONH (Conditions (Item))(Conditions (Header)) Condition No (KNUMH)Condition No (KNUMH) Seq No (KOPOS) EINAEINE (Purchasing Info Record: General(Purchasing Info Record: Purchasing Data)Organization Data) Info Record (INFNR)Info Record (INFNR) Purchasing Org (EKORG) Info Record Type (ESOKZ) Plant (WERKS) 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 Planning Project Planning PROJ (Project Definition) PRPS-PSPHI = PROJ-PSPNR PRPS-PSPNR =PRTEPRTE-POSNRPRPSPRTXPRTX-PRPSPNR =and(Schedule Data for(WBS Elements)PRTE-POSNR(Texts(WBS))PRPS-PSPHI=Proj. Item)PRTE-PSPHI PRTX-PRTXTKY = PSTX-PRTXTKYPRPS-PSPNR = PRHIS-POSNR and PRPS-PSPHI=PSTXPRHIS-PSPHI(Project Texts (Header)) PRHIS (Proj. Hierarchy forPSTX-PRTXTKY =WBS Element)PSTT-PRTXTKY PSTT (Project Texts) PP Table Mapping SAP PP - Project Planning PROJECTS Project and WBS element numbers have a domain with a conversion function module which converts it from 8 numc input to 24 char on output.PROJ (Project definition) Project Number (PSPNR) Project Name (PSPID) PRTE (Scheduling Data for Project Item) Project Number (PSPHI)PRPSWBS Element Number (POSNR)(WBS (Work Breakdown Structure) Element Master Data)) Project Number (PSPHI) WBS Element Number (PSPNR) WBS Name (POSID)PRTX (PS Texts (WBS)) WBS Element Number (PRPSPNR) Text Identifier (PRTXTKY) PRHIS (Standard WBS, Edges (Hierarchy pointers)) Project Number (PSPHI) PSTXWBS Element Number (POSNR) (PS Texts (Header)) Text Identifier (PRTXTKY) PS text description (PSTXTTI) PSTT (PS texts (description)) Text Identifier (PRTXTKY) PS text: Description(PTKTEXT) SAP - Sales and Distribution SalesFinacial AccountingAccounts Receivable ShippingSales and Distribution Materials Mgmt.Material MasterBilling Tables: KONV LIKP LIPS VBAK VBAP VBBE VBEH VBEP VBFA VBLB VBLK VBPA VBRK VBRP VBUK VBUP VEKP VEPO VEPVG Sales/Order DocumentShipping/Delivery DocumentBilling Document VBLBVBBEVBLKVEPO(Release Order(SalesVBSK(SD:Delivery Note(SD Doc:ShippingData)Requirements)(Collective Proc.Header)Item content)KONVfor a Sales Doc(Condition Table)Header)VBLB-VBELN=VEPO-VBELN =VEPO-VENUM =VBAK-VBELNVBBE-VBELN=LIKP-VBELNVEKP-VENUMVBPAVEPO-VBELN =VBAK-VBELNVBRK-KNUMV =(Partner Table)VBLK-VBELNKONV-KNUMVVEKPVBSS(SD Doc:ShippingLIKP(Collective Proc.:VBPA-VBELN=Unit Header)(SalesSales Documents)VBAK-VBELNVBAKVBPA-POSNR=Doc:Delivery(SalesVBAP-POSNRVTTP-VBELN =Header)Doc:Header)VKDFSLIKP-VBELNVBAK-VBELN =VBRK(SD Index:VBAP-VBELN(Billing: HeaderBilling Initiator)VTTPdata)VEPVG(Shipment Item)(Delivery DueVBAPIndex)(Sales Doc:ItemVBPA-VBELN =LIPS-VBELN =VTTK-TKNUM =Info)NASTLIPS-VGBELVBEP-VBELN =LIKP-VBELNVTTP-TKNUMVBAK-VBELNVKDFS(Message Status)(SD Index: Billing Initiator)VTTKVBRK-VBELN =VBEP-VBELN =VBRP-VBELN(Shipment Header)LIPS-VGBEL =VBAP-VBELNVBKD-VBELN =VRPMAVBAP-VBELNandVBAP-VBELN(SD Index:VAPMAandVBAP-POSNR =andBilling Items perLIPS-VGPOS =(SD Index:VBEP-POSNRVBKD-POSNR =LIPSMaterial)VBAP-POSNRVBAP-POSNROrder Items(SalesLIPS-VBELN =by Material)VBRP-VGBELDoc:DeliveryVRKPAVBRPLIPS-POSNR=Items)(SD Index:VBRP-VGPOSVBKD(Billing: Item data)VBEPBills by PartnerVAKPA(Sales Doc:(SalesFunction)(SD Index:Business Data)Doc:ScheduleOrder by Lines)Partner Function)VBFAvbelv = preceeding document (Doc. Flow)vbeln = subsequent docVBELN POSNR ETENRVBUKvbeln = document number(Header Status)SD VBEHTable Mapping(Schedule LineVBUPvbeln = document numberHistory)(Item Status));use with VBAP and LIPs SAP SD - Sales TablesVKDFSSTXL(SD Index:Billing Initiator)(STXD SAPscript text file lines)Billing Cat (FKTYP)(RELID)Sales Org (VKORG)STXHTexts (TDOBJECT)Billing Date (FKDAT)(STXD SAPscript text file header)Text Name (TDNAME)Customer (KUNNR)Texts (TDOBJECT)Text Id (TDID)Billing Type (FKART)Text Name (TDNAME)Language (TDSPRAS)Country (LLAND)Text Id (TDID)(SRTF2)Sales doc (VBELN)VBUKLanguage (TDSPRAS)(Header Status) Sales doc (VBELN)VAPMA (SD Index:Order Items by Material) Material No (MATNR) Sales Org (VKORG)VBFATrans Group (TRVOG)(Sales Document Flow)Document Date (AUDAT)VBAKPreceding Sales Doc (VBELV)Distribution Channel (VTWEG)(Sales Document :Header)Preceding Item (POSNV)Division (SPART)Sales doc (VBELN)Subsequent Sales doc (VBELN)Document Type (AUART)VBUPSubsequent Item (POSNN)Sold-to-Party (KUNNR)(Item Status)Document Cat (VBTYP_N)Sales Office (VKBUR)Sales doc (VBELN)Sales Group (VKGRP)Item (POSNR)Customer PO No (BSTNK) User Name (ERNAM) Sales Ord (VBELN) Item (POSNR) To Shipping through LIPS LIPS-VGBEL = VBAP-VBELNVAKPAVBAPand(SD Index:Order by Partner Function)(Sales Document : Item Info)LIPS-VGPOS = VBAP-POSNR Sales doc (VBELN)Partner No (KUNDE)Item (POSNR)Partner Function (PARVW) Sales Org (VKORG) Trans Group (TRVOG) Document Date (AUDAT) Sales Office (VKBUR) Sales Group (VKGRP)VBKDDistribution Channel (VTWEG)VBEP(Sales Document : Business Data)Division (SPART)(Sales Document : Schedule Lines)Sales doc (VBELN)Document Type (AUART)Sales doc (VBELN)Item (POSNR)Customer PO No (BSTNK)Item (POSNR)Sold-to-Party (KUNNR) Schedle Line (ETENR)User Name (ERNAM) Sales Ord (VBELN) VBEHVBPA (Schedule Line History)(Sales Document :Partner) Sales doc (VBELN)Sales doc (VBELN) Item (POSNR)Item (POSNR) Schedle Line (ETENR)Partner Function (PARVW) SAP SD - Shipping TablesVTTP (Shipment Item)VBLK Delivery Doc Number(VBELN)(SD:Delivery Note Header)Shipment Number (TKNUM)Delivery Document Number (VBELN)Shipment Item (TPNUM) VTTP-VBELN =VTTK-TKNUM =LIKP-VBELNVTTP-TKNUM VBLK-VBELN =VEPOLIKP-VBELNVTTK(SD Doc:Shipping Item content)(Shipment Header)Delivery Document Number (VBELN) Shipment Number (TKNUM)Delivery Item (POSNR)LIKPShipping Unit Number (VENUM)(Sales Doc:Delivery Header)Shipping Unit Item (VEPOS)Delivery Document Number (VBELN)VTFA (Shipment Doc. Flow)VEPO-VENUM = VEKP-VENUMShipment Number (TKNUM)VBUKPreceeding Doc. (VBELV)(Header Status) VEPO-VBELN =Delivery doc (VBELN)LIPS-VBELNVEKPand(SD Doc:Shipping Unit Header)VEPO-POSNR = LIPS-POSNRShipping Unit Number(VENUM)VBFALIPS-VBELN = (Sales Document Flow)LIKP-VBELN Preceding Sales Doc (VBELV) VBUPPreceding Item (POSNV) (Item Status)Subsequent Sales doc (VBELN) Subsequent Item (POSNN)Deliverydoc (VBELN)Document Cat (VBTYP_N)Item (POSNR) LIPSFrom Sales through VBAP(Sales Doc:Delivery Items)To Biling through VBRPLIPS-VGBEL = VBAP-VBELN VBRP-VGBEL = LIPS-VBELNandDelivery Document Number (VBELN)andLIPS-VGPOS = VBAP-POSNRItem (POSNR)VBRP-VGPOS = LIPS-POSNR SAP SD - Billing Tables VBSKVBSSVKDFSVRKPA(Collective Processing for a Sales(Collective Processing: Sales(SD Index: Billing Initiator)(Sales Index: Bills by PartnerDocument Header)Documents)Functions)Billing Cat (FKTYP)Grouped Delivery (SAMMG)Grouped Delivery (SAMMG)Partner No (KUNDE)Sales Org (VKORG)Sales doc (VBELN)Partner Function (PARVW)Billing Date (FKDAT)Sales Org (VKORG)Customer (KUNNR)Billing Date (FKDAT)Billing Type (FKART)Distribution Channel (VTWEG)Country (LLAND)Billing Type (FKART)Sales doc (VBELN)Payer (KUNNR) Sold-to-Party (KUNNR) SD Doc Cat (VBTYP) User Name (ERNAM)NASTBilling Doc (VBELN)(Billing: Header Data) Application (KAPPL) Object (OBJKY) Output Type (KSCHL)VBRKLanguage (SPRAS)(Billing: Header Data)VRPMAMess Partner (PARNR)Billing doc (VBELN)(SD Index: Billing Items per Material)Partner Func (PARVW) Date (ERDAT)Material No (MATNR)Time (ERUHR)Sales Org (VKORG) Billing Date (FKDAT) Distribution Channel (VTWEG) Billing Type (FKART) Payer (KUNNR) Sold-to-Party (KUNNR)VBUKSD Doc Cat (VBTYP)(Header Status)User Name (ERNAM)Sales doc (VBELN)Billing Doc (VBELN) Item (POSNR) VBRP (Billing: Item Data) Billing doc (VBELN) Item (POSNR) VBFAFrom Shipping through LIPS(Sales Document Flow)VBRP-VGBEL = LIPS-VBELN andPreceding Sales Doc (VBELV) VBRP-VGPOS = LIPS-POSNRPreceding Item (POSNV) Subsequent Sales doc (VBELN) Subsequent Item (POSNN)VBUPDocument Cat (VBTYP_N)(Sales Document: Item Status) Sales doc (VBELN) Item (POSNR) SAP SD - Links to FI Tables Customer Master Data Company Code DataSales Area DataGeneral Data KNVP(Customer Master Partner Functions) Customer No (KUNNR)KNA1KNB1Sales Org (VKORG)(General Data in Customer Master)(Customer master (company code))Distribution Ch (VTWEG)Division (SPART)Customer No (KUNNR)Customer No (KUNNR)Partner Function (PARVW)Company Code (BUKRS)Partner Counter (PARZA) KNVV(Customer Master Sales Data)KNB5Customer No (KUNNR)(Customer master (dunning data))Sales Org (VKORG)Distribution Ch (VTWEG)Customer No (KUNNR)Division (SPART)Companu Code (BUKRS)Dunning Area (MABER)KNVD(Customer master record salesrequest form) Customer No (KUNNR)Sales Org (VKORG)Distribution Ch (VTWEG) Division (SPART)Output Type ( SAP SD - Links to MM Tables Material Master Data Sales DataBasic DataSales Text DataMARCMAKT(Material Master: C Segment)(Material Descriptions)Material No (MATNR)Material No (MATNR)Plant (WERKS)Language (SPRAS) STXH (STXD SAPscript text file header)MVKETexts (TDOBJECT)(Material Master: Sales Data)Text Name (TDNAME)Material No (MATNR)Text Id (TDID)Sales Org (VKORG)Language (TDSPRAS)Distribution Chan (VTWEG)MARAProduct Hierarchy (PRODH)(Material Master: General Data) Material No (MATNR) T179 (Materials: Product Hierarchies) Product Hierarchy (PRODH) STXL*use to ge text for hiearchy levels(STXD SAPscript text file lines) (RELID)MARMTexts (TDOBJECT)(Units of Measure)Text Name (TDNAME)MLANText Id (TDID)Material No (MATNR)(Tax Classification: Material)Language (TDSPRAS)UOM (MEINH) (SRTF2)Material No (MATNR) Country (ALAND) Contributions by HRMaster DataFI/CO Jim Lewis (Whittman-Hart, inc.)Michael Rhodes (MedPartners, inc.) SDMMPPPaul Evans (Whittman-Hart, inc.)Jim Lewis (Whittman-Hart, inc.)Krishna Prasad (Whittman-Hart, inc.)Michael Rhodes (MedPartners, inc.)Russ Smith (Benteler) Michael Rhodes (MedPartners, inc.)