SAP SD Tables

SAP Sales and Distribution 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

Materials    

                  MARA    Material Master: General
                  MARC    Material Master: Plant
                  MAKT     Material Master: Short description
                  MARM    Material Master: Conversion factors
                  MVKE     Material Master: Sales
                  MLAN     Material Master: Sales
                  MAEX     Material Master: Export Licenses
                  MBEW    Material Master: Valuation
                  MLGN     Material Master: WM Inventory
                  MLGT     Material Master: WM Inventory type
                  MVER     Material Master: Consumption
                  DVER     Material Master: Consumption
                  MAPR     Material Master: Forecast
                  MARD     Material Master: Storage Location
                  MCH1     Material Master: X Plant Batches
                  MCHA     Material Master: Batches
                  MCHB     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