SD Flow

[Former Member]

Hi all,

I am looking for SAP SD dataflow and the regarding DataSources along with the tables.I request all my fellow members to help me in this.

Regards

Sanyo D Francis

[Former Member · Accepted solution]

Hi Sanyo,

Pls find the SD tables below.

Master data tables:

Customer master(CMR): KNA1 General Data

KNB1 Customer Master u2013 Co. Code Data (payment method, reconciliation acct)

KNB4 Customer Payment History

KNB5 Customer Master u2013 Dunning info

KNBK Customer Master Bank Data

KNKA Customer Master Credit Mgmt.

KNKK Customer Master Credit Control Area Data (credit limits)

KNVV Sales Area Data (terms, order probability)

KNVI Customer Master Tax Indicator

KNVP Partner Function key

KNVD Output type

KNVS Customer Master Ship Data

KLPA Customer/Vendor Link

Material master tables(MMR):

MARA u2013 Material Master: General

MAKT u2013 Material Master: Short description

MARM u2013 Material Master: Conversion factors

MVKE u2013 Material Master: Sales <Sales Org, Distr Ch>

MLAN u2013 Material Master: Sales <Country>

MAEX u2013 Material Master: Export Licenses

MARC u2013 Material Master: Plant <Plant>

MBEW u2013 Material Master: Valuation

MLGN u2013 Material Master: WM Inventory

MLGT u2013 Material Master: WM Inventory type

MVER u2013 Material Master: Consumption <Plant>

DVER u2013 Material Master: Consumption <MRP Area>

MAPR u2013 Material Master: Forecast

MARD u2013 Material Master: Storage Location

MCH1 u2013 Material Master: X Plant Batches

MCHA u2013 Material Master: Batches

MCHB u2013 Material Master: Batch Stock

MARCH - Material Master C Segment: History

MARDH - Material Master Storage Location Segment: History

MBEWH - Material Valuation: History

MCHBH - Batch Stocks: History

MKOLH - Special Stocks from Vendor: History

MSCAH - Sales Order Stock at Vendor: History

MSKAH - Sales Order Stock: History

MSKUH - Special Stocks at Customer: History

MSLBH - Special Stocks at Vendor: History

MSPRH - Project Stock: History

MSSAH - Total Sales Order Stocks: History

MSSQH - Total Project Stocks: History

Customer Material Information(CMIR):

KNMTK - Customer Material Information: Header

KNMT - Customer Material Information: Item

Bill of Materials (BOM):

MAST - Material

EQST - Equipment

KDST u2013 Sales Order

DOST - Document

STST - Standard Object

TPST u2013 Functional location

STKO u2013 BOM: Header

STZU u2013 STL data

STAS u2013 BOM: Item selection

STOP u2013 BOM: Item data

STPU u2013 BOM: Sub items

Sales Activities & Sales Document (Header):

VBUK u2013 Header Status / Admin data

VBUV u2013 Incompletion log

VBPA u2013 Partner functions

SADR - Address

VBFA u2013 Document flow

VBAK u2013 Sales document: header

VBKD u2013 Sales document: Business data

VAKPA u2013 Partner index

VEDA - Contract

VBKA u2013 Sales Activity document

NAST u2013 Output

JSTO u2013 PP Status

STXH u2013 Text: header

STXL u2013 Text: Lines

Sales document (Item):

VBUP u2013 Item status

VBAP - Sales document: Item data

VBKD - Sales document: Business data

VEBA - Contract

VBLB u2013 Forecast

VBEP - Sales document: Schedule line

VBBE u2013 Individual requirement

VBBS u2013 Summary requirements

VBUV u2013 Incompletion log

VBFA u2013 Document flow

VBPA u2013 Partner functions

JSTO u2013 PP Status

NAST u2013 Output

STXH u2013 Text: Header

STXL u2013 Text: Lines

KONV u2013 Conditions

General:

AGR_USERS - Assignment of roles to users

CDHDR & CDPOS - Change history of master data and documents

TSTC - SAP Transaction Codes, maintained via transaction sm01

NAST - Message status

Shipping:

LIKP - delivery header

LIPS - Delivery item

LINK - inventory document header (WM)

LINP - inventory document item (WM)

VTTK - shipment header

VTTP - shipment item

VTTS - Stage of shipment

VTFA - shipment document flow

VTPA - shipping partner

LTAK - transfer order header

LTAP - transfer order item

VEKP - handling unit header

VEPO - handling unit item

Billing Document:

VBRK Billing Document Header

VBRP Billing Document Item

Regards,

Krishna.

[Former Member · Accepted solution]

Hi. One minor correction to Krishna's list. Table for BOM items (components) is STPO, not STOP. This list is very useful. Thank you for posting it.

Edited by: David Petrick on Aug 6, 2009 2:12 PM

[Former Member]

Thank you all for your valuable answers.

Best Regards

Sanyo

[sarthak_mohantysd]

Hello Sanyo,

Please use the search option and then let me know if you don't find the information related to "SAP SD dataflow with tables".

Regards,

SARTHAK

[Former Member]

Hi sanyo,

Have a look at this links

http://www.sap-img.com/general/sap-r3-tables.htm

SAP MM, SD, FI, PS, PP, PM, HR, System Tables download this file using above link.

http://www.sap-img.com/sap-sd/important-tables-for-sap-sd.htm

Thanks,

Swamy H P

[Former Member]

Dear Sanyo,

In a sale order, SD document flow - i.e., to find what are all the subsequent process has done on the sale order - you can use the path Environment -> Document Flow in Sale order(VA02/VA03).

Table which stores the document flow information is VBFA.

Some other tables for your information:

VBAK: Sales Doc. Header Information

VBAP: Sales Doc. Item Information

VBEP: Sales Doc. Schedule line info

VBKD: Sales Doc. Business Data

VBFA: Document Flow

LIKP: Delivery header

LIPS: Delivery Item

VBRK: Billing Header

VBRP: Billing Item

KONV: Condition Table

VBUK: Header Status

VBUP: Item Status

STXH: Text Object Header

STXL: Text Object lines

Hope it may help you.

Thanks,

Venkatesh.S.P

[Former Member]

hi

First make a search in the forum if u dont find the suitable answers then post a thread

IF u meAN by SD sales order cycle flow then it will be

Sales order (VBAK, VBAP,VBEP)

delivery (LIKP, LIPS)

Billing (VBRK, VBRP)

VBFA table for Document flow

customer master KNA1,KNVV,KNKK

material master MARA, MARC,MVKE

regards