Skip to Content
avatar image
Former Member

learn sd


i need to learn sd, the tables the relation any information will help.


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 08, 2007 at 04:12 AM

    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


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


    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 07, 2007 at 07:07 PM

    Hi Shnya,

    Check this link which has graphical relationship among SD tables



    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 07, 2007 at 07:28 PM


    pl check these important tables in SD :

    Sales and Distribution:

    Table Description

    Customers 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

    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

    SD Delivery DocumeLIPS Delivery Document item data, includes referencing PO

    LIKP Delivery Document Header data

    Billing Document VBRK Billing Document Header

    VBRP Billing Document Item

    SD Shipping Unit VEKP Shipping Unit Item (Content)

    VEPO Shipping Unit Header


    Sadhu Kishore

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 08, 2007 at 06:30 AM

    Dear Shyna tal,

    Hey I would suggest you to please go thorugh the following link.

    Hope this helps you.

    Do award points if you found them useful.



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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 08, 2007 at 06:41 AM


    Topic: Free ABAP eBook Download

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


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

    Add comment
    10|10000 characters needed characters exceeded