10 Replies Latest reply: Jul 18, 2007 11:14 AM by Dasari Narendra RSS

SAP SD tables and fields

venkata ramesh chandra chowdary
Currently Being Moderated

Hi All,

 

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

 

Thanks & Regards

Ramesh chandra

  • Re: SAP SD tables and fields
    konda reddy
    Currently Being Moderated

    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

  • Re: SAP SD tables and fields
    Dittakavi Srinivas
    Currently Being Moderated

    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

  • Re: SAP SD tables and fields
    Rajesh Banka
    Currently Being Moderated

    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.

  • Re: SAP SD tables and fields
    Currently Being Moderated

    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

  • Re: SAP SD tables and fields
    Navaneetha Krishnan
    Currently Being Moderated

    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.

  • Re: SAP SD tables and fields
    hemavathy murali
    Currently Being Moderated

    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

  • Re: SAP SD tables and fields
    Currently Being Moderated

    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

  • Re: SAP SD tables and fields
    Rakesh Singh Chauhan
    Currently Being Moderated

    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

  • Re: SAP SD tables and fields
    prashanth gaddam
    Currently Being Moderated

    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

  • Re: SAP SD tables and fields
    Dasari Narendra
    Currently Being Moderated

    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

Actions

Incoming Links