Header Ads

SAP SD related tables .

Sales Document
Table/Structure
Description
VBAK
Sales Document: Header Data
VBAP
Sales Document: Item Data
VBKD
Sales Document: Business Data/Sales district data
VBPA
Partners
VAKPA
Partner index
VBFA
Document Flow
VBEP
Sales Document: Schedule Line / Data related to line items, delivery lines
VBAKUK
Sales Document: Header and Status Data
VBUP
Sales Document: Item Status
VBUK
Header Status and Administrative Data
VBBE
Sales Requirements: Individual Records
VBBS
Summarized requirements
VBUV
Incompletion log
VBLB
Forecast delivery schedules
VMVA
Matchcodes
VEDA
Contract Data
VBKA
Sales activity

Logical Database

AK V
Sales documents

Delivery Documemt

Table/Structure
Description
LIKP
Delivery Document: Header data
LIPS
Delivery Document: Item data

Shipping

Table/Structure
Description
VTTK
Shipment header
VTTP
Shipment item
VTTS
Stage in transport
VTSP
Stage in transport per shipment item
VTPA
Shipment partners
VEKP
Handling Unit - Header Table
VEPO
Packing: Handling Unit Item - Contents

Billing Document

Table/Structure
Description
VBRK
Billing: Header data
VBRP
Billing: Item data

Customer Master

Table/Structure
Description
KNA1
Customer Master: General Data
KNB1
Customer Master: Company Code Data
KNB4
Customer Payment History
KNB5
Customer Master: Dunning data
KNBK
Customer Master: Bank Details
KNBW
Customer Master: Wwithholding tax types
KNKA
Customer Master: Credit Mgmt.
KNKK
Customer Master: Credit Control Area Data - credit limits
KNVA
Customer Master: Loading/Unloading Points
KNVD
Customer Master: Record sales request form/documents
KNVH
Customer Hierarchies
KNVI
Customer Master: Tax Indicator
KNVK
Customer Master: Contact Partner
KNVL
Customer Master: Licenses
KNVP
Customer Master: Partner Functions
KNVS
Customer Master: Shipping Data
KNVT
Customer Master: Record Texts for Sales
KNVV
Customer Master: Sales Data
KLPA
Customer/Vendor Link

Material Master

Table/Structure
Description
MARA
General Material Data
MVKE
Sales Data for Material
MARC
Plant Data for Material
MARD
Storage Location Data for Material
MAKT
Short texts
MARM
Conversion factors
MVKE
Sales data - for each sales organization and distribution channel
MLAN
Sales data - for each country
MAEX
Export licenses
MBEW
Valuation data
MLGN
Warehouse management inventory data
MLGT
Warehouse management inventory type data
MVER
Consumption data
MAPR
Pointers for forecast data
MCHA
Batches
MCH1
Cross-plant Batches
MCHB
Batch stocks
KNMTK
Header table - for increased performance
KNMT
Data table

Bill of Material (BOM)

Table/Structure
Description
MAST
Material assignment to BOM
EQST
Equipment assignment to BOM
KDST
Sales order assignment to BOM
DOST
Document assignment to BOM
STST
Standard object assignment to BOM
TPST
Functional location assignment to BOM
STKO
BOM header data
STZU
Time-independent STL data
STAS
BOM item selection
STPO
BOM item data
STPU
BOM sub-item data

Logical Database for Material Master

Table/Structure
Description
CKM
Material master
MSM
Material master

Pricing

Table/Structure
Description
KOMK
Pricing Communications: Header (Structure)
KOMP
Pricing Communication: Item (Structure)
KONV
Conditions: Transaction Data
KONP
Conditions: Item
KONH
Conditions: Header
KOND
Contracts
VEDA
Contract Data

Output

Table/Structure
Description
NAST
Output: Message Status

Text

Table/Structure
Description
STXH
Texts: Header
STXL
Texts: Line

Others

Table/Structure
Description
JSTO
PP status
SADR
Address
Powered by Blogger.