SAP SD tables and fields

[Former Member]

Hi All,

any one can please guide me ,how to find SD tables and fields.what are all we need .

Thanks & Regards

Ramesh chandra

[Former Member]

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

FOR FINDING THE TABLES AND FIELDS SELECT THE FIELD PRESS F1 AND GO TO TECHNICAL DATA FIND THE TABLES AND FIELDNAME

[Former Member]

hi

refer to the link below u can get all the details of the tables..

http://www.erpgenie.com/sap/abap/tables.htm

in sap system goto SE11 and give the table Name and select display..

u can get better idea of all the available fields..

reward if useful

thanx.. Naren

[Former Member]

hi

SALES AND DISTRIBUTION TABLES AND MANDATORY FIELDS

TABLES/MAND.

FIELDS DESCRIPTION

KNA1 CUSTOMER MASTER GENERAL DATA

MANDT CLIENT

KUNNR CUSTOMER NUMBER

KNB1 CUSTOMER MASTER COMPANY CODE

MANDT CLIENT

KUNNR CUSTOMER NUMBER

BUKRS COMPANY CODE

KNVP CUSTOMER MASTER PARTNER FUNCTIONS

MANDT CLIENT

KUNNR CUSTOMER NUMBER

VK0RG SALES ORGANISATION

VTWEG DISTRIBUTION CHANNEL

SPART DIVISION

PARVW PARTNER FUNCTIONS

PARZA PARTNER COUNTER

KNVV CUSTOMER MASTER SALES DATA

MANDT CLIENT

KUNNR CUSTOMER NUMBER

VK0RG SALES ORGANISATION

VTWEG DISTRIBUTION CHANNEL

SPART DIVISION

KNVK CUSTOMER MASTER CONTACT PARTNER

MANDT CLIENT

PARNR NUMBER OF THE CONTACT PERSON

KNVD CUSTOMER MASTER RECORD SALES REQUEST FORM

MANDT CLIENT

KUNNR CUSTOMER NUMBER

VK0RG SALES ORGANISATION

VTWEG DISTRIBUTION CHANNEL

SPART DIVISION

DOCTP OUTPUT TYPE

SPRAS MESSAGE LANGUAGE

KNB5 CUSTOMER MASTER DUNNING DATA

MANDT CLIENT

KUNNR CUSTOMER NUMBER

BUKRS COMPANY CODE

MABER DUNNING AREA

KNVS CUSTOMER MASTER SHIPPING DATA

MANDT CLIENT

KUNNR CUSTOMER NUMBER

VSTEL SHIPPING POINT / RECEIVING POINT

SALES AND DISTRIBUTION TABLES AND MANDATORY FIELDS Page 2

KNVA CUSTOMER MASTER LOADING POINT

MANDT CLIENT

KUNNR CUSTOMER NUMBER

ABLAD UNLOADING POINT

KNMTK CUSTOMER MASTER INFO RECORD HEADER TABLE

MANDT CLIENT

VK0RG SALES ORGANISATION

VTWEG DISTRIBUTION CHANNEL

KUNNR CUSTOMER NUMBER

KNMT CUSTOMER MASTER INFO RECORD TABLE

MANDT CLIENT

VK0RG SALES ORGANISATION

VTWEG DISTRIBUTION CHANNEL

KUNNR CUSTOMER NUMBER

MATNR MATERIAL NUMBER DESCRIPTION

KNKK

CUSTOMER MASTER CREDIT MANAGEMENT CONTROL AREA

DATA

MANDT CLIENT

KUNNR CUSTOMER NUMBER

KKBER CREDIT CONTROL AREA

KNKA CUSTOMER MASTER CREDIT MANAGEMENT CENTRAL DATA

MANDT CLIENT

KUNNR CUSTOMER NUMBER

VBAK SALES DOCUMENT HEADER DATA

MANDT CLIENT

VBELN SALES DOCUMENT

VBUK SALES DOCUMENT HEADER STATUS AND ITEM DATA

MANDT CLIENT

VBELN SALES DOCUMENT

VBKA SALES ACTIVITIES

MANDT CLIENT

VBELN SALES DOCUMENT

VBFA SALES DOCUMENT FLOW

MANDT CLIENT

VBELV PRECEDING SALES DOCUMENT

POSNV PRECEDING ITEM OF SALES DOCUMENT

VBELN SUBSEQUENT SALES DOCUMENT

POSNN SUBSEQUENT ITEM OF SALES DOCUMENT

VBTYP N DOCUMENT CATEGORY OF SUBSEQUENT DOCUMENT

VBPA SALES DOCUMENT PARTNERS

MANDT CLIENT

VBELN SALES DOCUMENT

POSNR ITEM NUMBER OF SALES DOCUMENT

PARVW PARTNER FUNCTION

SALES AND DISTRIBUTION TABLES AND MANDATORY FIELDS Page 3

VBUV SALES DOCUMENT INCOMPLETION LOG

MANDT CLIENT

VBELN SALES DOCUMENT

POSNR ITEM NUMBER OF SALES DOCUMENT

ETENR SCHEDULE LINE

PARVW PARTNER FUNCTION

TDID TEXT ID

TBNAM TABLE FOR DOCUMENT IN SD

FDNAM DOCUMENT FIELD NAME

NAST MESSAGE STATUS

MANDT CLIENT

KAPPL APPLICATION FOR MESSAGE CONDITIONS

OBJKY OBJECT KEY

KSCHL MESSAGE TYPE

SPRAS MESSAGE LANGUAGE

PARNR MESSAGE PARTNER

PARVW PARTNER FUNCTIONS

ERDAT DATE WHEN STATUS RECORD CREATED

ERUHR TIME WHEN STATUS RECORD CREATED

VBKD SALES DOCUMENT BUSINESS DATA

MANDT CLIENT

VBELN SALES DOCUMENT

POSNR ITEM NUMBER OF SALES DOCUMENT

VBUP SALES DOCUMENT ITEM STATUS

MANDT CLIENT

VBELN SALES DOCUMENT

POSNR ITEM NUMBER OF SALES DOCUMENT

VBAP SALES DOCUMENT ITEM DATA

MANDT CLIENT

VBELN SALES DOCUMENT

POSNR ITEM NUMBER OF SALES DOCUMENT

VBEP SALES DOCUMENT SCHEDULE LINE DATA

MANDT CLIENT

VBELN SALES DOCUMENT

POSNR ITEM NUMBER OF SALES DOCUMENT

ETENR SCHEDULE LINE

KONV CONDITION (TRANSACTION DATA )

MANDT CLIENT

KNUMV DOCUMENT CONDITION NUMBER

KPOSN CONDITION ITEM NUMBER

STUNR STEP NUMBER

ZAEHK CONDITION COUNTER

KONH CONDITION HEADER

MANDT CLIENT

KNUMH CONDITION RECORD NOS

SALES AND DISTRIBUTION TABLES AND MANDATORY FIELDS Page 4

KONA REBATE AGREEMENTS

MANDT CLIENT

KNUMA AGREEMENT

KONP CONDITION (ITEM)

MANDT CLIENT

KNUMH CONDITION RECORD NOS

KOPOS SEQUENTIAL NO OF THE CONDITION

KONM CONDITIONS ( ONE DIMENTIONAL QTY SCALE)

MANDT CLIENT

KNUMH CONDITION RECORD NOS

KOPOS SEQUENTIAL NO OF THE CONDITION

KLFN1 CURRENT NO OF LINE SCALE

KONW CONDITIONS ( ONE DIMENTIONAL VALUE SCALE)

MANDT CLIENT

KNUMH CONDITION RECORD NOS

KOPOS SEQUENTIAL NO OF THE CONDITION

KLFN1 CURRENT NO OF LINE SCALE

LIKP DELIVERY HEADER DATA

MANDT CLIENT

VBELN DELIVERY DOCUMENT

LIPS DELIVERY ITEM DATA

MANDT CLIENT

VBELN DELIVERY DOCUMENT

POSNR DELIVERY ITEM

VEKP HANDLING UNIT : HEADER TABLE

MANDT CLIENT

VENUM INTERNAL HANDLING UNIT NUMBER

VEPO PACKING : HANDLING UNIT ITEM (CONTENTS)

MANDT CLIENT

VENUM INTERNAL HANDLING UNIT NUMBER

VEPOS HANDLING UNIT ITEM

EIKP FOREIGN TRADE : EXPORT / IMPORT HEADER DATA

MANDT CLIENT

EXNUM NO. OF THE FOREIGN TRADE DATA IN MM & SD

EIPO FOREIGN TRADE : EXPORT / IMPORT ITEM DATA

MANDT CLIENT

EXNUM NO. OF THE FOREIGN TRADE DATA IN MM & SD

EXPOS INTERNAL ITEM NO. FOR F.TRADE DATA IN MM & SD

VTTK SHIPMENT HEADER

MANDT CLIENT

TKNUM SHIPMENT NUMBER

SALES AND DISTRIBUTION TABLES AND MANDATORY FIELDS Page 5

VTTP SHIPMENT ITEM

MANDT CLIENT

TKNUM SHIPMENT NUMBER

TPNUM SHIPMENT ITEM

VTTS STAGE OF SHIPMENT

MANDT CLIENT

TKNUM SHIPMENT NUMBER

TSNUM STAGE OF SHIPMENT NUMBER

VTSP STAGE OF SHIPMENT / ITEM ALLOCATION

MANDT CLIENT

TKNUM SHIPMENT NUMBER

TSNUM STAGE OF SHIPMENT NUMBER

TPNUM SHIPMENT ITEM

VTPA SHIPPING PARTNER

MANDT CLIENT

VBELN SD DOCUMENT

POSNR DELIVERY ITEM

PARVW PARTNER FUNCTIONS

VTFA SHIPMENT DOCUMENT FLOW

MANDT CLIENT

TKNUM SHIPMENT NUMBER

VBELV PRECEDING SALES DOCUMENT

POSNV PRECEDING ITEM OF SALES DOCUMENT

VBELN SUBSEQUENT SALES DOCUMENT

POSNN SUBSEQUENT ITEM OF SALES DOCUMENT

VBTYP V DOCUMENT CATEGORY OF PRECEDING DOCUMENT

VBTYP N DOCUMENT CATEGORY OF SUBSEQUENT DOCUMENT

VBRK BILLING DOCUMENT HEADER DATA

MANDT CLIENT

VBELN SD DOCUMENT DOCUMENT

VBRP BILLING DOCUMENT ITEM DATA

MANDT CLIENT

VBELN SD DOCUMENT DOCUMENT

POSNR BILLING ITEM

SD FLOW AND THE MAIN TABLES AFFECTED

PRESALES ACTIVITY

ENQUIRY TRANSACTION CODE : VA11

KNA1 CUSTOMER MASTER GENERAL DATA

KNB1 CUSTOMER MASTER COMPANY CODE

KNVV CUSTOMER MASTER SALES DATA

KNVS CUSTOMER MASTER SHIPPING DATA

VBAK SALES DOCUMENT HEADER DATA

QUOTATION TRANSACTION CODE : VA21

KNA1 CUSTOMER MASTER GENERAL DATA

KNB1 CUSTOMER MASTER COMPANY CODE

KNVV CUSTOMER MASTER SALES DATA

VBAP SALES DOCUMENT ITEM DATA

VBAK SALES DOCUMENT HEADER DATA

SCHEDULING

AGREEMENT TRANSACTION CODE : VA31

KNVP CUSTOMER MASTER PARTNER FUNCTIONS

KNMT CUSTOMER MASTER INFO RECORD TABLE

KNKK CUSTOMER MASTER CREDIT MANAGEMENT CONTROL AREA DATA

KNKA CUSTOMER MASTER CREDIT MANAGEMENT CENTRAL DATA

VBEP SALES DOCUMENT SCHEDULE LINE DATA

CONTRACT TRANSACTION CODE : VA41

KNVP CUSTOMER MASTER PARTNER FUNCTIONS

KNMT CUSTOMER MASTER INFO RECORD TABLE

KNKK CUSTOMER MASTER CREDIT MANAGEMENT CONTROL AREA DATA

KNKA CUSTOMER MASTER CREDIT MANAGEMENT CENTRAL DATA

S116 CUSTOMER ANALYSIS

SALES ORDER PROCESSING

SALES ORDER TRANSACTION CODE : VA01

VBAK SALES DOCUMENT HEADER DATA

VBUK SALES DOCUMENT HEADER STATUS AND ITEM DATA

VBKD SALES DOCUMET BUSINESS DATA

VBUP SALES DOCUMENT ITEM STATUS

VBAP SALES DOCUMENT ITEM DATA

VBEP SALES DOCUMENT SCHEDULE LINE DATA

VBFA SALES DOCUMENT FLOW

VBPA SALES DOCUMENT PARTNERS

SADR ADDRESS

NAST MESSAGE STATUS

KONV CONDITION (TRANSACTION DATA )

STXH TEXTS - HEADER

STXL TEXTS - LINES

VBUV INCOMPLETION LOG

SD FLOW AND THE MAIN TABLES AFFECTED Page

2

PRICING

CONDITIONS TRANSACTION CODE : VK31, VK34,

KONH CONDITION HEADER

KONA REBATE AGREEMENTS

KONP CONDITION (ITEM)

KONM CONDITIONS ( ONE DIMENTIONAL QTY SCALE)

KONW CONDITIONS ( ONE DIMENTIONAL VALUE SCALE)

DELIVERY

DELIVERY TRANSACTION CODE : VL01

VBUK SALES DOCUMENT HEADER STATUS AND ITEM DATA

VBUP SALES DOCUMENT ITEM STATUS

LIKP DELIVERY HEADER DATA

LIPS DELIVERY ITEM DATA

VBFA SALES DOCUMENT FLOW

VBPA SALES DOCUMENT PARTNERS

NAST MESSAGE STATUS

VEKP HANDLING UNIT : HEADER TABLE

VEPO PACKING : HANDLING UNIT ITEM (CONTENTS)

SADR ADDRESS

STXH TEXTS - HEADER

STXL TEXTS - LINES

SHIPMENT

SHIPMENT TRANSACTION CODE : VT01

LIKP DELIVERY HEADER DATA

VTTK SHIPMENT HEADER

VEKP HANDLING UNIT : HEADER TABLE

LIPS DELIVERY ITEM DATA

VTTP SHIPMENT ITEM

VTTS STAGE OF SHIPMENT

VEPO PACKING : HANDLING UNIT ITEM (CONTENTS)

VBFA SALES DOCUMENT FLOW

VTSP STAGE OF SHIPMENT / ITEM ALLOCATION

VTPA SHIPPING PARTNER

VTFA SHIPMENT DOCUMENT FLOW

BILLING

BILLING TRANSACTION CODE : VF01

VBUK SALES DOCUMENT HEADER STATUS AND ITEM DATA

VBRK BILLING DOCUMENT HEADER DATA

VBRP BILLING DOCUMENT ITEM DATA

VBPA SALES DOCUMENT PARTNERS

SADR ADDRESS

VBFA SALES DOCUMENT FLOW

KONV CONDITIONS

NAST MESSAGE STATUS

STXH TEXTS - HEADER

STXL TEXTS - LINES

[Former Member]

Hi,

Please refer to the website:

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

Hope this helps you.

Do award points if you found them useful.

Regards,

Rakesh

P.S. you can send me a mail at my mail id rakeshsinghchauhan@gmail.com for any specific details

[Former Member]

1 Customising

1.1 General settings

1.1.1 Countries

T005 Countries

1.1.2 Currency

TCURC Currency codes

TCURR Wisselkoersen

TCURT Currency name

TCURX Decimal places for currencies.

1.1.3 Unit of measure

T006 Units of measure

1.1.4 Calendar functions

T247 Month names

TFACD Factory calendar definition

T015M Month names

TTZZ Time zones

TTZD Summer time rules

TTZDF Summer time rules (fixed annual dates)

TTZDV Summer time rules (variable dates)

TTZDT Summer time rules texts

TTZ5 Assign Time Tones to Countries

TTZ5S Assign time zones to regions

1.2 Enterprise structure

1.2.1 Definition

FI T880 Company

T001 Company code

CO TKA01 Controlling area

LO T001W Plant / sales organisation

T499S Locations

TSPA Division

SD TVKO Sales organisation / company code

TVTW Distribution channel

TVBUR Sales office

TVKBT Sales office text

TVKGR Sales group

TVGRT Sales group text

T171T Sales district text

MM T001L Storage locations

T024E Purchasing organization

T3001 Warehouse number

TVST Shipping point

TVLA Loading point

TTDS Transportation

1.2.2 Assignment

CO TKA02 Assign company code to controlling area

LO T001K Assign plant (valuation area) to company code

SD TVKO Sales organisation / company code

TVKOV Distribution channel / sales organisation

TVKOS Division to sales organization

TVTA Sales aria

TVKBZ Sales office to sales area

TVBVK Sales group to sales office

TVKWZ Plants to sales organization

MM T024E Purchasing organization / company code

T024W Plant to Purchase organization

T001K Link plant ( = valuation area) / company code

TVSWZ Shipping point to plant

T320 Assignment MM Storage Location to WM Warehouse

1.3 Financial accounting

1.3.1 Company code

T004 Chart of accounts

T077S Account group (g/l accounts)

T009 Fiscal year variants

T880 Global company data

T014 Credit control area

1.3.2 Fi document

T010O Posting period variant

T010P Posting Period Variant Names

T001B Permitted Posting Periods

T003 Document types

T012 House banks

1.4 Not categorized

T007a Tax keys

T134 Material types

T179 Materials: Product Hierarchies

T179T Materials: Product hierarchies: Texts

TJ02T Status text

TINC Customer incoterms

TVFK Billing doc types

T390 PM: Shop papers for print control

2 Basic data / administration

2.1 Workbench related tables

2.1.1 Data dictionary tables

DD02L Tables in SAP

DD02T Tables description

DD03L Field names in SAP

DD03T Field description in SAP

2.1.2 Workbench

TADIR Directory of R/3 Repository Objects

TRDIR System table TRDIR

TFDIR Function Module

TLIBG Person responsible for function class

TLIBT Function Group Short Texts

TFTIT Function Module Short Text

TSTC Transaction codes in SAP

TSTCT Transaction codes texts

T100 Message text (vb e000)

VARID Variant data

D020T Screen texts

TDEVC Development class

TDEVCT Texts for development classes

2.2 Administration

2.2.1 User administration

USR01 User master

USR02 Logon data

USR03 User address data

USR04 User master authorizations

USR11 User Master Texts for Profiles (USR10)

UST12 User master: Authorizations

USR12 User master authorization values

USR13 Short Texts for Authorizations

USR40 Prohibited passwords

TOBJ Objects

TOBC Authorization Object Classes

TPRPROF Profile Name for Activity Group

DEVACCESS Table for development user

2.2.2 Batch input queue

APQD DATA DEFINITION Queue

APQI Queue info definition

2.2.3 Job processing

TBTCO Job status overview table

TBTCP Batch job step overview

2.2.4 Spool

TSP02 Spool: Print requests

2.2.5 Runtime errors

SNAP Runtime errors

2.2.6 Message control

TNAPR Processing programs for output

NAST Message status

NACH Printer determination

2.2.7 EDI

EDIDC Control record

EDIDD Data record

EDID2 Data record 3.0 Version

EDIDS EDI status record

EDPAR Convert External < > Internal Partner Number

EDPVW EDI partner types

EDPI1 EDI partner profile inbound

EDPO1/2/3 EDI partner profile outbound

2.2.8 Change documents

CDHDR Change document header

CDPOS Change document positionen

JCDS Change Documents for System/User Statuses (Table JEST)

2.2.9 Reporting tree table

SERPTREE Reporting: tree structure

2.2.10 LIS structure/control tables

TMC4 Global Control Elements: LIS Info Structure

3 MASTER DATA :

3.1 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

3.1.1 Basic data text (sap script)

STXB SAPscript: Texts in non-SAPscript format

STXH STXD SAPscript text file header

STXL STXD SAPscript text file lines

3.1.2 Batches

MCHA Batches

MCH1 Batches

MCHB Stock : batches

3.2 Customer master data

KNA1 Customer master

KNB1 Customer / company

KNVV Customer sales data

KNBK Bank details

KNVH Customer hierarchy

KNVP Customer partners

KNVS Shipment data for customer

KNVK Contact persons

KNVI Customer master tax indicator

3.3 Vendor

LFA1 Vendor master

LFB1 Vendor per company code

LFB5 Vendor dunning data

LFM1 Purchasing organisation data

LFM2 Purchasing data

LFBK Bank details

3.4 Customer – material info record

KNMT Customer material info record

3.5 Bank data

BNKA Master bank data

4 Characteristics :

4.1 Characteristics :

CABN Characteristics ( o.a. batch/vendor)

CABNT Characteristics description

CAWN Characteristics ( o.a. material)

CAWNT Characteristics description

AUSP Characteristic Values

4.2 Class types and objects :

TCLAO Several class types for object

TCLA Class types ( vb. lfa1 => v10 en 010)

TCLAT Class type text

TCLT Classifiable objects

TCLC Classification status

4.3 Links :

INOB Link between Internal Number and Object

KLAH Class header data

KSSK Allocation Table: Object (vb.matnr) to Class

KSML Characteristics for a class (internal number)

5 FI/CO :

5.1 FI :

5.1.1 Master data

SKA1 Accounts

BNKA Bank master record

5.1.2 Accounting documents // indices

BKPF Accounting documents

BSEG item level

BSID Accounting: Secondary index for customers

BSIK Accounting: Secondary index for vendors

BSIM Secondary Index, Documents for Material

BSIP Index for vendor validation of double documents

BSIS Accounting: Secondary index for G/L accounts

BSAD Accounting: Index for customers (cleared items)

BSAK Accounting: Index for vendors (cleared items)

BSAS Accounting: Index for G/L accounts (cleared items)

5.1.3 Payment run

REGUH Settlement data from payment program

REGUP Processed items from payment program

5.2 CO :

TKA01 Controlling areas

TKA02 Controlling area assignment

KEKO Product-costing header

KEPH Cost components for cost of goods manuf.

KALO Costing objects

KANZ Sales order items - costing objects

5.2.1 Cost center master data

CSKS Cost Center Master Data

CSKT Cost center texts

CRCO Assignment of Work Center to Cost Center

5.2.2 Cost center accounting

COSP CO Object: Cost Totals for External Postings

COEP CO Object: Line Items (by Period)

. COBK CO Object: Document header

COST CO Object: Price Totals

6 Sales and Distribution (SD) :

VBFA Document flow (alg.)

VTFA Flow shipping documents

6.1 Sales order :

VBAK Header data

VBAP Item data

VBPA Partners in sales order

VBKD Sales district data

VBEP Data related to line items, delivery lines

6.2 Billing document :

VBRK header data

VBRP Item data

6.3 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)

6.4 Delivery :

LIKP Delivery header

LIPS Delivery item

6.5 Pricing :

KONH Conditions header

KONP Conditions items

KONV Procedure ( billing doc or sales order)

KOND

6.6 contracts :

VEDA Contract data

7 Material Management (MM) :

7.1 Material document

MKPF material document

MSEG material document (item level)

7.2 Purchasing

EKKO Purchase document

EKPO Purchase document (item level)

EKPV Shipping-Specific Data on Stock Tfr. for Purch. Doc. Item

EKET Delivery schedule

VETVG Delivery Due Index for Stock Transfer

EKES Order Acceptance/Fulfillment Confirmations

EKKN Account assignment in purchasing

EKAN Vendor address purchasing

EKPA Partner functions

EIPO Item export / import data

EINA Purchase info record (main data)

EINE Purchase info record (organisational data)

EORD Source list

EBAN Purchase requisition

EBKN Purchase Requisition Account Assignment

8 Warehouse Management (WM) :

8.1 Transfer requirement

LTBK Transfer requirement - header

LTBP Transfer requirement - item

8.2 Transfer order

LTAK Transfer order - header

LTAP Transfer order - item

8.3 Master data - stock positions

LQUA Quants

8.4 Inventory documents in WM

LINK Inventory document header

LINP Inventory document item

LINV Inventory data per quant

9 Quality Management (QM) :

9.1 Inspection lot / info record

QALS Inspection lot record

QAMB Link inspection lot - material document

QAVE Inspection usage decision

QDPS Inspection stages

QMAT Inspection type - material parameters

QINF Inspection info record (vendor - material)

QDQL Quality level

QDPS Inspection stages

9.2 Quality notification

TQ80 Notification types

QMEL Quality notification

QMFE Quality notification – items

QMUR Quality notification – causes

QMSM Quality notification – tasks

QMMA Quality notification – activities

QMIH Quality message - maintenance data excerpt

9.3 Certificate profile

QCVMT Certificate profile characteristic level: texts

QCVM Certificate profile characteristic level

QCVK Certificate profile header

10 Production Planning (PP)

10.1 Work center

CRHH Work center hierarchy

CRHS Hierarchy structure

CRHD Work center header

CRTX Text for the Work Center or Production Resource/Tool

CRCO Assignment of Work Center to Cost Center

KAKO Capacity Header Segment

CRCA Work Center Capacity Allocation

TC24 Person responsible for the workcenter

10.2 Routings/operations

MAPL Allocation of task lists to materials

PLAS Task list - selection of operations/activities

PLFH Task list - production resources/tools

PLFL Task list - sequences

PLKO Task list - header

PLKZ Task list: main header

PLPH Phases / suboperations

PLPO Task list operation / activity

PLPR Log collector for tasklists

PLMZ Allocation of BOM - items to operations

10.3 Bill of material

STKO BOM - header

STPO BOM - item

STAS BOMs - Item Selection

STPN BOMs - follow-up control

STPU BOM - sub-item

STZU Permanent BOM data

PLMZ Allocation of BOM - items to operations

MAST Material to BOM link

KDST Sales order to BOM link

10.4 Production orders

AUFK Production order headers

AFIH Maintenance order header

AUFM Goods movement for prod. order

AFKO Order header data PP orders

AFPO Order item

RESB Order componenten

AFVC Order operations

AFVV Quantities/dates/values in the operation

AFVU User fields of the operation

AFFL Work order sequence

AFFH PRT assignment data for the work order(routing)

JSTO Status profile

JEST Object status

AFRU Order completion confirmations

PRT’s voor production orders

AFFH PRT assignment data for the work order

CRVD_A Link of PRT to Document

DRAW Document Info Record

TDWA Document Types

TDWD Data Carrier/Network Nodes

TDWE Data Carrier Type

10.5 Planned orders

PLAF Planned orders

10.6 KANBAN

PKPS Kanban identification, control cycle

PKHD Kanban control cycle (header data)

PKER Error log for Kanban containers

10.7 Reservations

RESB Material reservations

RKPF header

10.8 Capacity planning

KBKO Header record for capacity requirements

KBED Capacity requirements records

KBEZ Add. data for table KBED (for indiv. capacities/splits)

10.9 Planned independent requirements

PBIM Independent requirements for material

PBED Independent requirement data

PBHI Independent requirement history

PBIV Independent requirement index

PBIC Independent requirement index for customer req.

11 Project system (PS)

11.1 Basic data

PRHI Work Breakdown Structure, Edges (Hierarchy Pointer)

PROJ Project definition

PRPS WBS (Work Breakdown Structure) Element Master Data

RPSCO Project info database: Costs, revenues, finances

MSPR Project stock

11.2 Equipment

EQUI Equipment master data

EQKT Equipment short text

EQUZ Equipment time segment

12 Plant maintenance (PM)

IHPA Plant Maintenance: Partners

OBJK Plant Maintenance Object List

ILOA PM Object Location and Account Assignment

AFIH Maintenance order header

12.1 Human resources

12.2 Settings

T582A Infotypes: Customer-Specific Settings

12.3 Master data

T527X Organizational Units

T528T Position Texts

T554T Attendance and Absence Texts

T501 Employee group

T503 Employee group, subgroup

T503K Employee subgroup

T510N Pay Scales for Annual Salaries (NA)

T549A Payroll Accounting Areas

T750X Vacancy

12.4 Infotypes

PA0001 Org. Assignment

PA0002 Personal Data

PA0006 Addresses

PA0007 Planned Working Time

PA0016 Contract elements

PA0008 Basic pay

PA0105 Communications

PA1007 Vacancies

PA1035 Training

PA2001 Absences

[Former Member]

Hi

t.code-se84-to find table names using feild names

goto abap dictionary

then feilds

then table feilds

Give the feild name in the table

execute

hope this will help u

Reward points if useful

Regards

Hema

[former_member183879]

You can just put a search on SAP SD tables in google and get the PDF document which talks about the link b etween various tables.

Also you can download this from www.sap-img.com

Rwd if this helps.

[Former Member]

Hi

Here are some tables that are related for the SD

Customer Master: KNA1

KNB1

KNVV

material master: MARA

Sales Document: VBAK VBAP VBEP

Delivery Documents: LIKP LIPS

Billing Documents: VBRK VBRP

[Former Member]

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

Free ABAP eBook Download

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

Regards,

Rajesh Banka

Reward suitable points.

[Former Member]

HI Venkata,

You can go and press F1 and technical information on the field which you want to know, you will get table and field name intechnical info

In general to know sd tables go thr below links:

SD TABLES:

http://sap-img.com/sap-sd/link-between-sap-sd-mm-and-fi.htm

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

Reward points if it helps

Regards

Srini