Skip to Content
author's profile photo Former Member
Former Member

Master Data Management

Hello,

Please help me with SD tables and how it relates from sales to distribution. I mean flow of sales and distribution.

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 22, 2008 at 06:27 PM

    Hi Azzu,

    Just trying to understand your question.

    You want all the tables that undergoes few set of operations when we execute complete SD cycle. Is that ryt?

    Infact I am also not an expert on this area.

    But can provide you with following link. No idea if its useful.

    [http://help.sap.com/saphelp_erp60_sp/helpdata/en/92/df293581dc1f79e10000009b38f889/frameset.htm]

    Regards,

    Amol.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 23, 2008 at 06:03 AM

    Heii,

    for this share me your Email Id.

    Deepak

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 23, 2008 at 07:24 AM

    Hi,

    Here are some of SD Tables

    Customers

    KNA1 General Data

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

    KNB4 Customer Payment History

    KNB5 Customer Master – 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

    Sales Documents VBAKUK VBAK + VBUK

    VBUK Header Status and Administrative Data

    VBAK Sales Document - Header Data

    VBKD Sales Document - Business Data

    VBUP Item Status

    VBAP Sales Document - Item Data

    VBPA Partners

    VBFA Document Flow

    VBEP Sales Document Schedule Line

    VBBE Sales Requirements: Individual Records

    SD Delivery Document

    LIPS Delivery Document item data, includes referencing PO

    LIKP Delivery Document Header data

    Billing Document

    VBRK Billing Document Header

    VBRP Billing Document Item

    SD Shipping Unit

    VEKP Shipping Unit Item (Content)

    VEPO Shipping Unit Header

    Regards

    Nisha

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 23, 2008 at 07:30 AM

    Heii,

    In Addition to nisha's answer

    you can follow

    SD Customer Master Tables Link

    Customers

    KNA1 General Data

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

    KNB4 Customer Payment History

    KNB5 Customer Master – 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

    Sales Documents VBAKUK VBAK + VBUK

    VBUK Header Status and Administrative Data

    VBAK Sales Document - Header Data

    VBKD Sales Document - Business Data

    VBUP Item Status

    VBAP Sales Document - Item Data

    VBPA Partners

    VBFA Document Flow

    VBEP Sales Document Schedule Line

    VBBE Sales Requirements: Individual Records

    SD Delivery Docume

    LIPS Delivery Document item data, includes referencing PO

    LIKP Delivery Document Header data

    Billing Document

    VBRK Billing Document Header

    VBRP Billing Document Item

    SD Shipping Unit

    VEKP Shipping Unit Item (Content)

    VEPO Shipping Unit Header

    Config tables (normally begin with "T")

    Name Description Uses

    T001 Client table

    T002 Languages

    T005 Region (Country)

    TCURR Currency and exchange rates

    TVAK Order type

    TVSB Shipping condition

    TVAGT Rejected reason for order line

    Tables in SAP

    Just a list of tables that come in handy.

    Sales orders

    Name Description Uses

    LIKP Shipped Lines header

    LIPS Shipped Lines detail

    VBAK Order header Every order (unless archiving)

    VBAP Table fields Every line item (unless archiving)

    VBBE Open sales order line items Great file, but be careful. Contents don't reflect orders that do not affect purchasing (go figure).

    VBEP Schedule line item

    VBFA Document flow Let's you move from order to shipping document to invoice.

    VBUK Order status

    VBUP Line item detail status

    VBFK Invoicing header

    VBFP Invoicing detail

    Material Management

    Name Description Uses

    MARA Inventory Master

    MARC Plant Data

    MARD Current Inventory

    MAKT Descriptions

    MBEW Material Valuation

    T179 Product Hierarchy

    MVKE Sales data (materials)

    MKPF Material document Status code 'R' in VBFA

    Purchasing

    Name Description Uses

    EINA Purchasing inforecord by MATNR/LIFNR contains things like vendor material number and access key for EINE

    EINE Purchasing inforecord detail Contains minimum purchase, group, currency

    EKPO Purchase orders

    EKET Scheduled lines

    EKES Vendor confirmed lines

    Forecasting

    Name Description Uses

    MAPR

    PROP

    PROW

    Classification

    Name Description Uses

    KSSK Material number to class

    KLAS Class description

    KSML Characteristic name

    CABN/CABNT Characteristic name description

    CAWN/CAWNT Characteristic name

    AUSP Numeric values

    Name Description Uses

    CAUFV Service order header

    AFPO Service order line Holds items that will create "reservations"

    RESB SM Reservations Materials needed for line

    System tables

    Name Description Uses

    DD02T Table texts

    DD03L Table fields Lists the fields in a table

    DD04T Data element texts

    USR02 Valid user names

    Other tables

    Name Description Uses

    STXH Text header

    STXL Text detail

    SAP MM Tables

    ________________________________________

    Materials

    MARA - Material Master: General data

    MAKT - Material Master: Description

    MARM - Material Master: Unit of Measure

    MAPE - Material master: Export control file

    MARC - Material master: Plant data

    MARD - Material master: Storage location

    MAST - Material link to BOM

    MBEW - Material valuation

    MLGN – Material Master: WM Inventory

    MLGT – Material Master: WM Inventory type

    MDIP - Material: MRP profiles (field contents)

    MKOP - Consignment price segment (old versions of SAP)

    EBEW - Valuation of sales order stock

    QBEW - Valuation of project stock

    MVER – Material Master: Consumption <Plant>

    DVER – Material Master: Consumption <MRP Area>

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

    MLAN - Material Master: Tax indicator

    MARC - Material Master: Plant data

    MAPR – Material Master: Forecast

    MARD – Material Master: Storage Location

    MCH1 – Material Master: X Plant Batches

    MCHA – Material Master: Batches

    MCHB – Material Master: Batch Stock

    MDMA - MRP Area data

    DBVM - MRP Planning File Entry: MRP Area

    MOFF - Outstanding Material Master Records (Maintenance status)

    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

    Vendors

    LFA1 - Vendor Master: General data

    LFB1 - Vendor Master: Company data

    LFM1 - Vendor Master: Purchasing Data (Purchasing organization)

    LFM2 - Vendor Master: Purchasing Data (Plant, Vendor sub-range)

    Purchasing

    EBAN - Purchase requisition: items

    EBKN - Purchase Requisition: account assignment

    STXH - SAPScript Text Header

    STXL - SAPScript Text Lines

    EKKO - Purchasing document header

    EKPO - Purchasing Document: Item

    EKET - Purchasing Document: Delivery Schedules

    MDBS - Material View of Order Item/Schedule Line (good to find open PO's)

    EKKN - Account assignment in purchasing document

    EORD - Purchasing Source List

    EIPA - Order price history record

    EKAB - Release documentation

    EKBE - Purchasing document history

    EKBZ - Purchasing document history: delivery costs

    EKPB - "Material to be provided" item in purchasing document

    ESKL - Account assignment specification for service line

    ESKN - Account assignment in service package

    ESLH - Service package header data

    ESLL - Lines in service package

    ESSR - Service entry sheet header data

    ESUC - External services management: Unplanned limits for contract item

    ESUH - External services management: unplanned service limits header data

    ESUP - External services management: unplanned limits for service packages

    ESUS - External services management: Unplanned limits for service types

    EINA - Purchase Info Record: General

    EINE - Purchasing info record: purchasing organization data

    KONP - Condition Item

    KONH - Condition Header

    Inventory Management

    ISEG - Physical inventory document items

    MKPF - Material document: Header

    MSEG - Material document: item

    RKPF - Reservation: Header

    RESB - Reservation: Item

    Invoice Verification

    BSIM - Secondary index: documents for material

    MYMFT - FIFO results table

    MYML - LIFO material layer

    MYMLM - LIFO material layer (monthly)

    MYMP - LIFO period stocks, single material

    MYMP1 - Receipt data LIFO/FIFO valuation

    MYPL - LIFO pool layer

    MYPLM - LIFO pool layer (monthly)

    RBCO - Document item, incoming invoice account assignment

    RBDIFFKO - Invoice Verification: conditions

    RBDIFFME - Invoice Verification: quantity differences

    RBDRSEG - Invoice Verification batch: invoice document items

    RBKP - Document header: incoming invoice

    RBKPB - Invoice document header (batch invoice verification)

    RBTX - Taxes:incoming invoice

    RBVD - Invoice document: summarization data

    RBVDMAT - Invoice Verification: summarization data, material

    RBWT - Withholding tax:incoming invoice

    RKWA - Consignment withdrawals

    RSEG - Document item, incoming invoice

    Customising and other master data

    MDLV - MRP Areas

    MDLG - MRP Areas - Storage Locations

    MDLW - MRP Areas - Plants

    MDLL - MRP Areas - Subcontractor

    T023 - Material Groups

    T024 - Purchasing groups

    T030 - Standard Accounts Table (Automatic Account Determination)

    T156 - Movement Type

    T156T - Movement Type: Text

    AUSP - Release Procedure: Strategy values (cl20n, cl24n)

    AGR_USERS - Assignment of roles to users

    CDHDR & CDPOS - Change history of master data and documents

    EDID4 - EDI information

    TSTC - SAP Transaction Codes, lock/unlock: sm01, created: se93

    TSTCT - Transaction codes TEXT

    NAST - Message status

    Material Master Data:


    ----


    ----

    Table

    Description


    ----


    ----

    Materials

    MARA

    General Data, material type, group,

    configurable & batch ind.

    MAKT

    Short Texts, descriptions

    MARM

    Conversion Factors

    MVKE

    Sales Org, distribution channel

    MLAN

    Sales data, tax indicator, tax

    MARC

    classification

    MBEW

    Plant Planning Data

    MLGN

    Valuation Data

    MLGT

    Warehouse Management Inventory Data

    MVER

    Warehouse Management Storage Type

    MAPR

    Data

    MARD

    Consumption Data

    MCHA

    Pointer for Forecast Data

    MCHB

    Storage location data with stock

    balances

    Batches

    Batch Stocks


    ----


    ----

    Hope this might help you.Please reward if you find it useful.

    Rgds,

    Deepak

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 09:19 AM

    please help me and answer the question is how and what tables are updating in SD if we complete any sales order successfully.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.