Thursday, 28 November 2013

IMPORTANT TABLES


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

                                
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
    
                              
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  
Other important table
JEST System Status with object number TJ02 System status description.
MRP Related  
MDKP   Header Data for MRP Document MDTB   MRP Table
MDVL   Planning file entry for long term planning
MDVM   Enry in MRP file
PBVPV  Material Index for consumption of planning
REUL   Material stock transfer reservation index
SAFK  Run schedule master data

No comments:

Post a Comment