tables fields

[Former Member]

hi sd gurus,

could u just elobaorate on sd tables and fields relevance...how r tables interlikd with each other

regards

vivek

[Former Member · Accepted solution]

hi

the data which we enter is stored in tables and by interlinking the fields from different tables whih are jhaving the same fields in common

[Former Member]

<b>SD</b>

KNA1 Customer master -global

KNVP Customer master-partners

KNVV Customer master - Sales Orgn

KNMT Cust-Material info record

KNB1 company code and customer no

LIKP SD Deliveries-Header Data

LIPS SD-Deliveries-item data

VAKPA Sales Orders by Partner Function

VAPMA Sales index - Order - Materials

VBAK Sales Doc-Header

VBAP Sales Doc-line items

VBBE Sales Doc-individual records

VBBS Sales Doc-totals records

VBEP Sales Doc-schedule lines

VBFA Sales Doc -flow

VBKD Sales doc - Business data

VBPA Sales doc - Partners

VBRK Billing Doc - Header

VBRP Billing Doc - Item

VBUK Sales doc Header status

VBUP Sales doc Item status

VBUV Sales doc - incompletion log

VEPVG Delivery due index

VKDFS Billing initiator index

VLPMA SD Index: Delivery Itms by Material

VRKPA Sales Index: Bills by Partner

VRPMA SD Index: Billing Itms per Material

KONV,KONP,KONH value of condn type

XD99 mass change customer master

TTXOB,TTXIT text tables

SER01-KUNDI & EQUI serial no ITOB - SERNR.

J_1JEXCDTL excise details (line itemswise)

J_1IEXCHDR excise details header

TNAPR output type and prgm

T683S Pricing procedure and Condn Type

<b>Material Master</b>

MAKT Material descriptions

MARA Mat Master-general data

MARC Mat Master-C segment

MARD Mat Master-storage locn segment

MARM Material - Units of measure

MBEW MAterial valuation

MLGN Material data for WH

MLVSV MARAMARCMLGN

MOFF Mat Master -Outstanding views

MSTA Material master Sales Area

MVER Material Consumption

MVKE Material master Sales Area

MLAN Tax classification

<b>Accounting documents</b>

BKPF Acctg doc-header

BSAD Accts-customer Cleared items

BSAK Accts-vendor Cleared items

BSAS Accts-G/L accts Cleared items

BSEG Acctg doc-segment

BSID Accts-customer Open items

BSIK Accts-vendor Open items

BSIS Accts-G/L accts Open items

Regards,

Rajesh Banka

Reward suitable points.

• How to give points: Mark your thread as a question while creating it. In the answers you get, you can assign the points by clicking on the stars to the left. You also get a point yourself for rewarding (one per thread).

[Former Member]

The link below will give a clear picture of tables & the table-fields that help linking different tables.

Link: http://www.sap-img.com/

Topic: Free ABAP eBook Download

SAP MM, SD, FI, PS, PP, PM, HR, System Tables

Regards,

Rajesh Banka

Reward suitable points.

• How to give points: Mark your thread as a question while creating it. In the answers you get, you can assign the points by clicking on the stars to the left. You also get a point yourself for rewarding (one per thread).

[Former Member]

Hi Vivek,

Wat ever the data you entered in the front in respective Fields and save the data, that will be get stored in the Respective tables backend.

Please Find below tables Related to SD.

T.code : SE11 / SE16

Enter the Table Name : VBAK and Display

here you can find the Field Names for this Table.

SD TABLES:

Important Tables for SAP SD

Sales and Distribution:

Customers : Table Description

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

Material Master:

MARA Material master

MAKT Material text

MARC Material per plant / stock

MVKE Material master, sales data

MARD Storage location / stock

MSKA Sales order stock

MSPR Project stock

MARM Units of measure

MEAN International article number

PGMI Planning material

PROP Forecast parameters

MAPR Link MARC <=> PROP

MBEW Material valuation

MVER Material consumption

MLGN Material / Warehouse number

MLGT Material / Storage type

MPRP Forecast profiles

MDTB MRP table

MDKP Header data for MRP document

MLAN Tax data material master

MTQSS Material master view: QM

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

VBKA Sales activities

VBFA Sales Document Flow

Logical databases: AAV, AKV, ARV, VFV

Sales requirements

VBBE Sales Requirements: Individual Records

VBBS Sales Requirement Totals Record

SD Delivery Documents:

LIPS Delivery Document item data, includes referencing PO

LIKP Delivery Document Header data

Shipping:

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)

VTFA Flow shipping documents

Billing Document:

VBRK Billing Document Header

VBRP Billing Document Item

SD Shipping Unit VEKP Shipping Unit Item (Content)

VEPO Shipping Unit Header.

Pricing:

KONAIND Index: Groups of Conditions/Header Record Conditions

KOND Conditions (Data)

KOND3 Conditions: Campaign Determination - Data Part

KONDD Material Substitution - Data Division

KONDDP Conditions: Additional Materials for Material Determination

KONDH Conditions: Batch Strategy - Data Division

KONDI Conditions: Data part for certificates

KONDIND General Document Index for Conditions

KONDN Conditions: Free goods - Data section

KONDNS Conditions: Free goods determination - scales

KONDP Conditions: Packing Object Data Section

KONDR Conditions: Derivation strategy - data part

KONDRPR Conditions: Derivation strategy - recipient item data

KONDRPS Conditions: Derivation strategy - sender item data

KONDV Conditions: Data part for certificates

KONH Conditions (Header)

KONM Conditions (1-Dimensional Quantity Scale)

KONP Conditions (Item)

KONV Conditions (Transaction Data)

KONW Conditions (1-Dimensional Value Scale)

KOTN900 LSI Free Goods Condition Table

KONV Conditions for Transaction Data

KONP Conditions for Items

LIKP Delivery Header Data

LIPS Delivery: Item data

VBAK Sales Document: Header Data

VBAP Sales Document: Item Data

VBBE Sales Requirements: Individual Records

VBEH Schedule line history

VBEP Sales Document: Schedule Line Data

VBFA Sales Document Flow

VBLB Sales document: Release order data

VBLK SD Document: Delivery Note Header

VBPA Sales Document: Partner

VBRK Billing: Header Data

VBRP Billing: Item Data

VBUK Sales Document: Header Status and Administrative Data

VBUP Sales Document: Item Status

VEKP Handling Unit - Header Table

VEPO Packing: Handling Unit Item (Contents)

VEPVG Delivery Due Index

Bill of Material:

MAST Material to BOM Link

EQST Equipment to BOM Link

STAS BOMs header

STKO BOM header

STPN BOM follow-Up control

STPO BOM item

STPU BOM sub-item

STST Standard BOM link

STVB Bills of material - Serialization of posting

STZU Permanent BOM data

Please Reward If Really helpful,

Thanks and Regards,

Sateesh.Kandula

[Former Member]

HI Vivek,

Check the following link

http://www.erpgenie.com/abap/tables_sd.htm

Regards

Nadarajah Pratheb

[Former Member]

send a test mail can send detailed doc

[Former Member]

hi my mail id is sriramvivek@yahoo.co.in