Search all SAP sites

Saturday, April 11, 2009

Sales and Distribution - Tables

Customers

KNA1 – Customer master: General

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)
KNVK – Contact persons
KNVV – Customer master: Sales areas
KNVA – Unloading point
KNVI – Tax indicators
KNVP – Partner functions
KNVD - Documents
KNVL - Licenses
KNVS - Customer master: Shipping
KNVH – Customer Master: Hierarchies
KLPA  – Customer/Vendor Link

Materials

MARA – Material Master: General
MAKT – Material Master: Short description
MARM – Material Master: Conversion factors
MVKE – Material Master: Sales
MLAN – Material Master: Sales
MAEX – Material Master: Export Licenses
MARC – Material Master: Plant
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


Customer Material Information

KNMTK - Customer Material Information: Header
KNMT - Customer Material Information: Item

Bill of Materials (BOM)

MAST - Material
EQST - Equipment
KDST – Sales Order
DOST - Document
STST - Standard Object
TPST – Functional location
STKO – BOM: Header
STZU – STL data
STAS – BOM: Item selection
STOP – BOM: Item data
STPU – BOM: Sub items


Sales Activities & Sales Document (Header)

VBUK – Header Status / Admin data
VBUV – Incompletion log
VBPA – Partner functions
SADR - Address
VBFA – Document flow
VBAK – Sales document: header
VBKD – Sales document: Business data
VAKPA – Partner index
VEDA - Contract
VBKA – Sales Activity document
NAST – Output
JSTO – PP Status
STXH – Text: header
STXL – Text: Lines

VBAK   Sales Document - Header Data

VBKD   Sales Document - Business Data

VBUP   Item Status

VBEP   Sales Document Schedule Line

VBBE   Sales Requirements: Individual Records



Sales document (Item)

VBUP – Item status
VBAP - Sales document: Item data
VBKD - Sales document: Business data
VEBA - Contract
VBLB – Forecast
VBEP - Sales document: Schedule line
VBBE – Individual requirement
VBBS – Summary requirements
VBUV – Incompletion log
VBFA – Document flow
VBPA – Partner functions
JSTO – PP Status
NAST – Output
STXH – Text: Header
STXL – Text: Lines
KONV – Conditions

SD Delivery Docs
 

 

LIPS   Delivery Document item data, includes referencing PO                 

LIKP   Delivery Document Header data

 

Billing Document 

 

VBRK   Billing Document Header                 

VBRP   Billing Document Item


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

 

SD Shipping Unit 

 

VEKP   Shipping Unit Item (Content)

VEPO   Shipping Unit Header

1 comment:

  1. Hi,Thanks for helping me with the informative post about Sales and Distribution-Tables as it providing info all about different SD tables.Visit now SAP SD Online Training in Hyderabad if you are looking to learn SAP SD skills.

    ReplyDelete

top