Sap Tables x2z31

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 Table

Cluster Table

SAP Table Name (Table Description)

SAP Table Information

SAP Field Name (Field Description)

SAP Field Name (Field Description)

Useful Fields

Link Key One-to-One One

One One-to-Many

One

SAP Table Name (Table Description)

Many

Master Data Tables

CEPC = Profit Center Master Data Table CSKS = Cost Center Master KNA1 = Cutomer Master (General Data) LFA1 = Vendor Master (General Data) MARA = Material Master (General Data) SKB1 = G/L Master (Company Code) T001W = Plants/Branches T001 = Company Codes

SAP - FI/CO

s Payable

Reconcillation Ledger

General Ledger

Financial ing

Special Purpose Ledger

Custom Ledger s Receivable Controlling

Profit Center ing

Tables: BSAD BSAS BSEG BSES BSIK BSIS

Cost Center ing

FI/CO Table Mapping

PAYR (Payment transfer medium file) Paying Company (ZBUKR) House Bank (HBKID) (HKTID) Payment Method (ZLSCH) Check No (CHECKT)

BVOR (Intercompany posting procedures) Intercompany No (BVORG) Company Code (BUKRS) Fiscal Year (GJAHR) Document No (BELNR)

VBLNR BKPF (ing document header) Company Code (BUKRS) Document No (BELNR) Fiscal Year (GJAHR) All FI documents

BSAD (ing: Secondary index for customers (cleared items)) 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 (BUZEI)

BSIP (Index for vendor validation of double documents) Company Code (BUKRS) Vendor (LIFNR) Currency (WAERS) Document Date (BLDAT) Duplicate Invoices Reference Doc (WRBTR) Amount (WRBTR) Document No (BELNR) Fiscal Year (GJAHR) Line Items (BUZEI)

Closed items

Open Items BSID (ing: Secondary index for customers) 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 (BUZEI)

Open Items

BSEG (ing document segment) Company Code (BUKRS) Document No (BELNR) Fiscal Year (GJAHR) Line Item (BUZEI)

Open Items

BSIS Company Code (BUKRS) G/L (HKONT) Clearing Date (AUGDT) Clearing Doc (AUGBL) Allocation No (ZUONR) Fiscal Year (GJAHR) Document No (BELNR) Line Items (BUZEI)

Closed items

Closed items

BSIK (ing: 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 (BUZEI)

BSAK (ing: 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 (BUZEI)

BSAS (ing: Secondary index for G/L s (cleared items)) Company Code (BUKRS) G/L (HKONT) Clearing Date (AUGDT) Clearing Doc (AUGBL) Allocation No (ZUONR) Fiscal Year (GJAHR) Document No (BELNR) Line Items (BUZEI)

KNC1 (Customer master (trans figures)) Customer (KUNNR) Company Code (BUKRS) Fiscal Year (GJAHR)

LFC1 (Vendor master (transaction figures)) Vendor (LIFNR) Company Code (BUKRS) Fiscal Year (GJAHR)

SAP FI/CO Financial ing

RFBLG (Cluster for ing document)

BKPF (ing document header) Company Code Document No Fiscal Year

BSEC BSED BSEG BSES BSET

Physical

BSEG (ing document segment)

A

BKPF (ing document header) Company Code Document No Fiscal Year

F ll

I

do

c

um

en

ts

One time s

Ta

x

do

cu

m

en

Company Code Document No Fiscal Year Line Item

BSEC (One-time data document segment) Company Code Document No Fiscal Year Line Item

ts BSET (Tax data document segment) Company Code Document No Fiscal Year Line Item

Logical

SAP FI/CO Special Purpose Ledger

Controlling Profit Center ing

GLPCA (EC-PCA: Actual Line Items) Record No (GL_SIRID)

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)

Example of a Custom Ledger ZZGLO

ROBJNR

COBJNR

Object (OBJNR) ROBJNR

GLPCO (EC-PCA: Object Table for Assignment Elements) Object (OBJNR)

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)

ZZGLO Record No (GL_SIRID) GLPCC (EC-PCA: Transaction Attributes) Object (OBJNR)

________________________________________________________ Cost Center ing COSP (CO Object: Cost Totals - External Postings) 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) Period Block (PERBL)

COEP (CO object: period-related line items) Controlling Area (KOKRS) Document No (BELNR) Line Item (BUZEI)

COBK Controlling Area (KOKRS) Document No (BELNR)

Reconcillation Ledger COFIT (Totals records - 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)

CO

BJ

NR

COFIO2 (Transaction-dependent fields for reconciliation ledger) Object (OBJNR)

ROBJNR

COFIO1 (Object Table for Reconciliation Ledger COFIT) Object (OBJNR)

SAP FI/CO s Payable

Vendor Master Data

Purchasing Data

LFM1 (Vendor master record purchasing organization data) Vendor No (LIFNR) Purch Org (EKORG)

LFM2 (Vendor Master Record: Purchasing Data) Vendor No (LIFNR) Purch Org (EKORG) Sub-range (LTSNR) Plant (WERKS)

General Data

Company Code Data

LFA1 (Vendor master (general section)) Vendor No (LIFNR)

LFB1 (Vendor master (company code)) Vendor No (LIFNR) Company Code (BUKRS)

LFBK (Vendor master (bank details)) Vendor No (LIFNR) Bank Cntry (BANKS) Bank Key (BANKL) Bank Acc (BANKN)

LFB5 (Vendor master (dunning data)) Vendor No (LIFNR) Company Code (BUKRS) Dunning Area (MABER)

SAP FI/CO s Receivable

Customer Master Data

Sales Area Data

General Data

Company Code Data

KNVP (Customer Master Partner Functions) Customer No (KUNNR) Sales Org (VKORG) Distribution Ch (VTWEG) Division (SPART) Partner Function (PARVW) Partner Counter (PARZA)

KNA1 (General Data in Customer Master)

KNB1 (Customer master (company code))

Customer No (KUNNR)

Customer No (KUNNR) Company Code (BUKRS)

KNVV (Customer Master Sales Data) Customer No (KUNNR) Sales Org (VKORG) Distribution Ch (VTWEG) Division (SPART)

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)

KNB5 (Customer master (dunning data)) Customer No (KUNNR) Company Code (BUKRS) Dunning Area (MABER)

SAP FI/CO Master Data Cost Elemet

Profit Center

Cost Center

CEPC (Profit center master data table) Profit Center (PRCTR) Valid to Date (DATBI) Controlling Area (KOKRS)

CSKS (Cost center master) Controlling Area (KOKRS) Cost Center (KOSTL) Valid to Date (DATBI)

CSKA (Cost elements (data dependent on chart of s)) COA (KTOPL) Cost Element (KSTAR)

CSKB (Cost elements (data dependent on controlling area)) Controlling Area (KOKRS) COA (KTOPL) Cost Element (KSTAR) Valid to Date (DATBI) CEPCT (Texts for Profit Center Master Data) Language (SPRAS) Profit Center (PRCTR) Valid to Date (DATBI) Controlling Area (KOKRS)

CSKT (Cost Center Texts) Language (SPRAS) Controlling Area (KOKRS) Cost Center (KOSTL) Valid to Date (DATBI)

CSKU (Cost Element Texts) Language (SPRAS) COA (KTOPL) Cost Element (KSTAR)

General Ledger

SKB1 (G/L master (company code)) Company Code (BUKRS) G/L (SAKNR)

SKA1 (G/L s master (chart of s)) COA (KTOPL) G/L (SAKNR)

SKAT (G/L master record (chart of s: description)) Language (SPRAS) COA (KTOPL) G/L (SAKNR)

SAP - Materials Management

Purchasing

Materials Management

Invoice Verification

Tables: EKKO EKPO KNMT MAKT

Materials Management

Financial ing

s Payable

KNMT (Customer-Material Info Record Data Table) makt-matnr = knmt-matnr and makt-spras = sy-langu

MAKT (Material Description)

EKKO (Purchasing Doc Header)

MDKP (MRP Header)

MDKP-DTNUM = MDTB-DTNUM EKPO-EBELN = EKKO-EBELN

EKPO (Purchasing Doc Item)

MDTB (MRP Detail)

MM Table Mapping

SAP MM - Purchasing Purchasing Requisition

STXH (STXD SAPscript text file header)

EBAN (Purchase Requisition)

Texts (TDOBJECT) Text Name (TDNAME) Text Id (TDID) Language (TDSPRAS)

Purchasing Req (BANFN) Item (BNFPO)

STXL (STXD SAPscript text file lines)) (RELID) Texts (TDOBJECT) Text Name (TDNAME) Text Id (TDID) Language (TDSPRAS) (SRTF2)

EBKN (Purchase Requisition Assignment) Purchasing Req (BANFN) Item (BNFPO) Preg Assignment (ZEBKN)

SAP MM - Purchasing Purchase Orders S011 (PURCH: Purch. Group Statistics)

S012 (PURCHIS: Purchasing Statistics)

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 Period (SPBUP) Purchasing Org (EKORG) Purchasing Group (EKGRP) Material No (MATNR) Plant (WERKS) Info Record Category (ESOKZ) Material Group (MATKL) Info Record (INFNR) Country (LAND1)

EINE (Purchasing Info Record: Purchasing Organization Data) Info Record (INFNR) Purchasing Org (EKORG) Info Record Type (ESOKZ) Plant (WEKS)

EKET (Delivery Schedules) Purchasing Doc (EBELN) Item (EBELP) Delivery Schedule (ETENR) EKPO (Purchasing Document Item) Purchasing Doc (EBELN) Item (EBELP)

EINA (Purch Info Record: General Data) Info Record (INFNR)

EKKO (Purchasing Document Header) Purchasing Doc (EBELN)

EORD (Purchasing Source List) Material No (MATNR) Plant (WERKS) Source List No (ZEORD)

EKKN ( Assignment in Purchasing Document) Purchasing Doc (EBELN) Item (EBELP) Assignment (ZEKKN)

SAP MM - Purchasing Goods Receipt

MKPF (Header: Material Document)

MSEG (Document Segment: Material)

Document No (MBLNR) Fiscal Year (MJAHR)

Document No (MBLNR) Fiscal Year (MJAHR) Line Item (ZEILE)

EKBE (History of Purchasing Document)

MVER (Material consumption)

Purchasing Doc (EBELN) Item (EBELP) Assign (ZEKKN) Trans Type (VGABE) Fiscal Year (MJAHR) Document No (MBLNR) Line Item (ZEILE)

Material NO (MATNR) Plant (WERKS) Fiscal Year (GJAHR) Period (PERKZ) Follow-on Records (ZAHLR)

S011 (PURCHIS: Purchasing Group Statistics) Statistics (SSOUR) Version (VRSIO) Month (SPMON) Day (SPTAG) Week (SPWOC) Posting Period (SPBUP) Purchasing Org (EKORG) Purchasing Group (EKGRP) Vendor No (LIFNR)

S031 (Statistics: Movements for current stocks) Statistics (SSOUR) Version (VRSIO) Month (SPMON) Day (SPTAG) Week (SPWOC) Posting Period (SPBUP) Plant (WERKS) Material No (MATNR) Storage Loc (LGORT)

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) Vendor No (LIFNR) Material No (MATNR) Plant (WERKS) Info Record Cat (ESOKZ) Info Record (INFNR)

SAP MM - Master Data

Purchasing Data

Basic Data

MARC (Material Master: C Segment)

MAKT (Material Descriptions)

Material No (MATNR) Plant (WERKS)

Material No (MATNR) Language (SPRAS)

MLAN (Tax Classification: Material) Material No (MATNR) Country (ALAND)

ing Data

MARA (Material Master: General Data)

MBEW (Material Valuation)

Material No (MATNR)

Material No (MATNR) Valuation Area (BWKEY) Valuation Type (BWTAR)

MARM (Units of Measure) Material No (MATNR) UOM (MEINH)

SAP MM - Purchasing

Purchasing Info Record

KONP (Conditions (Item))

KONH (Conditions (Header))

Condition No (KNUMH) Seq No (KOPOS)

Condition No (KNUMH)

EINA (Purchasing Info Record: General Data)

EINE (Purchasing Info Record: Purchasing 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 (WBS Elements)

PRPS-PSPNR = PRTE-POSNR and PRPS-PSPHI= PRTE-PSPHI

PRTE (Schedule Data for Proj. Item)

PRTX-PRPSPNR = PRTE-POSNR

PRTX (Texts(WBS))

PRTX-PRTXTKY = PSTX-PRTXTKY

PRPS-PSPNR = PRHIS-POSNR and PRPS-PSPHI= PRHIS-PSPHI

PSTX (Project Texts (Header)) PRHIS (Proj. Hierarchy for WBS Element)

PSTX-PRTXTKY = 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) PRPS (WBS (Work Breakdown Structure) Element Master Data))

Project Number (PSPHI) WBS Element Number (POSNR)

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) WBS Element Number (POSNR)

PSTX (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

Sales Finacial ing

Shipping

s Receivable

Sales and Distribution

Materials Mgmt. Billing

Tables: KONV LIKP LIPS VBAK VBAP VBBE VBEH VBEP VBFA VBLB VBLK VBPA VBRK VBRP VBUK VBUP VEKP VEPO VEPVG

Material Master

Sales/Order Document

VBBE (Sales Requirements)

Shipping/Delivery Document

VBLB (Release Order Data)

VBBE-VBELN= VBAK-VBELN

VBLB-VBELN= VBAK-VBELN

VBPA (Partner Table)

VBPA-VBELN= VBAK-VBELN VBPA-POSNR= VBAP-POSNR

VBAK (Sales Doc:Header)

VBLK (SD:Delivery Note Header)

VEPO (SD Doc:Shipping Item content)

VEPO-VBELN = LIKP-VBELN VEPO-VBELN = VBLK-VBELN

VKDFS (SD Index: Billing Initiator) VAPMA (SD Index: Order Items by Material)

VAKPA (SD Index: Order by Partner Function)

VBEP-VBELN = VBAK-VBELN

VBEP-VBELN = VBAP-VBELN and VBAP-POSNR = VBEP-POSNR

VBEP (Sales Doc:Schedule Lines) VBELN POSNR ETENR

VBEH (Schedule Line History)

VBKD-VBELN = VBAP-VBELN and VBKD-POSNR = VBAP-POSNR

KONV (Condition Table)

VEPO-VENUM = VEKP-VENUM

VEKP (SD Doc:Shipping Unit Header)

LIKP-VBELN

VBAP (Sales Doc:Item Info)

VBSK (Collective Proc. for a Sales Doc Header)

VBRK-KNUMV = KONV-KNUMV

VBSS (Collective Proc.: Sales Documents)

LIKP (Sales Doc:Delivery VTTP-VBELN = Header)

VBAK-VBELN = VBAP-VBELN

VEPVG (Delivery Due Index)

Billing Document

VTTP (Shipment Item) VBPA-VBELN = LIPS-VGBEL

LIPS-VBELN = LIKP-VBELN

LIPS-VGBEL = VBAP-VBELN and LIPS-VGPOS = VBAP-POSNR

VBKD (Sales Doc: Business Data)

VKDFS (SD Index: Billing Initiator)

VBRK (Billing: Header data)

VTTK-TKNUM = VTTP-TKNUM

VTTK (Shipment Header)

LIPS (Sales Doc:Delivery Items)

LIPS-VBELN = VBRP-VGBEL LIPS-POSNR= VBRP-VGPOS

NAST (Message Status) VBRK-VBELN = VBRP-VBELN

VRPMA (SD Index: Billing Items per Material)

VBRP (Billing: Item data)

VBFA (Doc. Flow)

vbelv = preceeding document vbeln = subsequent doc

VBUK (Header Status)

vbeln = document number

VBUP (Item Status))

vbeln = document number ;use with VBAP and LIPs

VRKPA (SD Index: Bills by Partner Function)

SD Table Mapping

SAP SD - Sales Tables VKDFS (SD Index:Billing Initiator) Billing Cat (FKTYP) Sales Org (VKORG) Billing Date (FKDAT) Customer (KUNNR) Billing Type (FKART) Country (LLAND) Sales doc (VBELN)

STXL (STXD SAPscript text file lines)

Texts (TDOBJECT) Text Name (TDNAME) Text Id (TDID) Language (TDSPRAS)

VAKPA (SD Index:Order by Partner Function) Partner No (KUNDE) Partner Function (PARVW) Sales Org (VKORG) Trans Group (TRVOG) 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) Name (ERNAM) Sales Ord (VBELN)

VBUK (Header Status) Sales doc (VBELN)

VAPMA (SD Index:Order Items by Material) Material No (MATNR) Sales Org (VKORG) Trans Group (TRVOG) 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) Name (ERNAM) Sales Ord (VBELN) Item (POSNR)

(RELID) Texts (TDOBJECT) Text Name (TDNAME) Text Id (TDID) Language (TDSPRAS) (SRTF2)

STXH (STXD SAPscript text file header)

VBFA (Sales Document Flow) VBAK (Sales Document :Header) Sales doc (VBELN)

VBAP (Sales Document : Item Info)

Preceding Sales Doc (VBELV) Preceding Item (POSNV) Subsequent Sales doc (VBELN) Subsequent Item (POSNN) Document Cat (VBTYP_N)

VBUP (Item Status) Sales doc (VBELN) Item (POSNR)

To Shipping through LIPS LIPS-VGBEL = VBAP-VBELN and LIPS-VGPOS = VBAP-POSNR

Sales doc (VBELN) Item (POSNR)

VBKD (Sales Document : Business Data)

VBEP (Sales Document : Schedule Lines)

Sales doc (VBELN) Item (POSNR)

Sales doc (VBELN) Item (POSNR) Schedle Line (ETENR)

VBEH (Schedule Line History) Sales doc (VBELN) Item (POSNR) Schedle Line (ETENR)

VBPA (Sales Document :Partner) Sales doc (VBELN) Item (POSNR) Partner Function (PARVW)

SAP SD - Shipping Tables VTTP (Shipment Item) Delivery Doc Number(VBELN) Shipment Number (TKNUM) Shipment Item (TPNUM)

VBLK (SD:Delivery Note Header) Delivery Document Number (VBELN) VTTP-VBELN = LIKP-VBELN

VTTK-TKNUM = VTTP-TKNUM

VBLK-VBELN = LIKP-VBELN

VTTK (Shipment Header) Shipment Number (TKNUM)

VEPO (SD Doc:Shipping Item content) Delivery Document Number (VBELN) Delivery Item (POSNR) Shipping Unit Number (VENUM) Shipping Unit Item (VEPOS)

LIKP (Sales Doc:Delivery Header) Delivery Document Number (VBELN)

VTFA (Shipment Doc. Flow) Shipment Number (TKNUM) Preceeding Doc. (VBELV)

VEPO-VENUM = VEKP-VENUM

VBUK (Header Status) Delivery doc (VBELN)

VBFA (Sales Document Flow)

LIPS-VBELN = LIKP-VBELN

Preceding Sales Doc (VBELV) Preceding Item (POSNV) Subsequent Sales doc (VBELN) Subsequent Item (POSNN) Document Cat (VBTYP_N)

VEPO-VBELN = LIPS-VBELN and VEPO-POSNR = LIPS-POSNR

VEKP (SD Doc:Shipping Unit Header) Shipping Unit Number(VENUM)

VBUP (Item Status) Deliverydoc (VBELN) Item (POSNR)

From Sales throughVBAP LIPS-VGBEL = VBAP-VBELN and LIPS-VGPOS = VBAP-POSNR

LIPS (Sales Doc:Delivery Items) Delivery Document Number (VBELN) Item (POSNR)

To Biling through VBRP VBRP-VGBEL = LIPS-VBELN and VBRP-VGPOS = LIPS-POSNR

SAP SD - Billing Tables

VRKPA (Sales Index: Bills by Partner Functions) Partner No (KUNDE) Partner Function (PARVW) Sales Org (VKORG) Billing Date (FKDAT) Distribution Channel (VTWEG) Billing Type (FKART) Payer (KUNNR) Sold-to-Party (KUNNR) SD Doc Cat (VBTYP) Name (ERNAM) Billing Doc (VBELN)

VRPMA (SD Index: Billing Items per Material)

VKDFS (SD Index: Billing Initiator) Billing Cat (FKTYP) Sales Org (VKORG) Billing Date (FKDAT) Customer (KUNNR) Billing Type (FKART) Country (LLAND) Sales doc (VBELN)

VBSK (Collective Processing for a Sales Document Header)

VBSS (Collective Processing: Sales Documents)

Grouped Delivery (SAMMG)

Grouped Delivery (SAMMG) Sales doc (VBELN)

NAST (Billing: Header Data) Application (KAPPL) Object (OBJKY) Output Type (KSCHL) Language (SPRAS) Mess Partner (PARNR) Partner Func (PARVW) Date (ERDAT) Time (ERUHR)

VBRK (Billing: Header Data) Billing doc (VBELN)

Material No (MATNR) Sales Org (VKORG) Billing Date (FKDAT) Distribution Channel (VTWEG) Billing Type (FKART) Payer (KUNNR) Sold-to-Party (KUNNR) SD Doc Cat (VBTYP) Name (ERNAM) Billing Doc (VBELN) Item (POSNR)

VBUK (Header Status) Sales doc (VBELN)

VBRP (Billing: Item Data) Billing doc (VBELN) Item (POSNR) VBFA (Sales Document Flow)

From Shipping through LIPS VBRP-VGBEL = LIPS-VBELN and VBRP-VGPOS = LIPS-POSNR VBUP (Sales Document: Item Status) Sales doc (VBELN) Item (POSNR)

Preceding Sales Doc (VBELV) Preceding Item (POSNV) Subsequent Sales doc (VBELN) Subsequent Item (POSNN) Document Cat (VBTYP_N)

SAP SD - Links to FI Tables

Customer Master Data

Sales Area Data

General Data

Company Code Data

KNVP (Customer Master Partner Functions) Customer No (KUNNR) Sales Org (VKORG) Distribution Ch (VTWEG) Division (SPART) Partner Function (PARVW) Partner Counter (PARZA)

KNVV (Customer Master Sales Data) Customer No (KUNNR) Sales Org (VKORG) Distribution Ch (VTWEG) Division (SPART)

KNVD (Customer master record sales request form) Customer No (KUNNR) Sales Org (VKORG) Distribution Ch (VTWEG) Division (SPART) Output Type (

KNA1 (General Data in Customer Master)

KNB1 (Customer master (company code))

Customer No (KUNNR)

Customer No (KUNNR) Company Code (BUKRS)

KNB5 (Customer master (dunning data)) Customer No (KUNNR) Companu Code (BUKRS) Dunning Area (MABER)

SAP SD - Links to MM Tables

Material Master Data

Sales Data MARC (Material Master: C Segment) Material No (MATNR) Plant (WERKS)

Basic Data

MAKT (Material Descriptions) Material No (MATNR) Language (SPRAS) STXH (STXD SAPscript text file header) Texts (TDOBJECT) Text Name (TDNAME) Text Id (TDID) Language (TDSPRAS)

MVKE (Material Master: Sales Data) Material No (MATNR) Sales Org (VKORG) Distribution Chan (VTWEG) Product Hierarchy (PRODH)

Sales Text Data

MARA (Material Master: General Data) Material No (MATNR)

T179 (Materials: Product Hierarchies) Product Hierarchy (PRODH) STXL (STXD SAPscript text file lines)

*use to ge text for hiearchy levels MARM (Units of Measure) MLAN (Tax Classification: Material) Material No (MATNR) Country (ALAND)

Material No (MATNR) UOM (MEINH)

(RELID) Texts (TDOBJECT) Text Name (TDNAME) Text Id (TDID) Language (TDSPRAS) (SRTF2)

Contributions by

Master Data Jim Lewis (Whittman-Hart, inc.)

MM Jim Lewis (Whittman-Hart, inc.) Michael Rhodes (MedPartners, inc.)

FI/CO

HR

Michael Rhodes (MedPartners, inc.)

PP

SD Paul Evans (Whittman-Hart, inc.) Krishna Prasad (Whittman-Hart, inc.) Russ Smith (Benteler) Michael Rhodes (MedPartners, inc.)