SAP Tables-6 (SD)

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

SAP Tables-5 (Fico)

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

SAP Tables-4

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)

SAP Tables-3

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                            SAP script: Texts in non-SAP script format

                STXH                                     STXD SAP script text file header

            STXL                            STXD SAP script 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 organization 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

SAP Tables-2

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 positioned

            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

SAP Tables-1

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