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.)