Scrol

SAP Trainings contact sap.sreeram@gmail.com or 091-9916083157, 001-210-399-8414

Showing posts with label SAP Tables. Show all posts
Showing posts with label SAP Tables. Show all posts

SAP System Tables list


System Tables

Person/Address assignment (central address administration)

Table to store keys for TADIR objects

Telephone numbers (central address admin.)

Persons (central address administration)

DATA DEFINITION Queue

Queue info definition

ABAP- Information about ABAP program source code

Change and Transport System- Object Entries of Requests/Tasks

Change and Transport System- Short Texts for Requests/Tasks

Additional Attributes for Function Modules

System table INDX

Message Status

STXD SAPscript text file header

Countries

Taxes- Region (Province) Key

Taxes- Region Key- Texts

Units of Measurement

Names of the months

Month name and short text

Building Addresses

Directory of Repository Objects

Job status overview table

Batch job step overview

Function Module

Function Module Short Text

Spool- Long device names

SAP Transaction Codes

Transaction Code Texts

User Types in Current Price List in SAP System

Special versions

Table of variables in selection criteria

View Directory

Data Relevant to Measurement for User Master Record

User master record (runtime data)

Logon data

User master authorizations

Additional Data per User

Surchargeable Language Versions per User

Assign user name address key

Objects for archiving and reorganization

Description of user event IDs for background processing

BSI- Upgrade-Information

Client Copy Control Flow

DB Optimizer Control (Statistics Creation)

Table for development users

OBSOLETE- Do not use (See TCETRAL)

Change and Transport System- Header of Requests/Tasks

CTS- Index for Assigning Numbers to Requests/Tasks

Documentation for installation Status and History

Patch Directory

DBA Action Table

Messages

Program Application Long Texts

OBSOLETE- Do not use, see TCEDELI

Development Classes

Temp Sequential table.

Change and Transport System- Lock Table

Processing programs for output. Can be very handy to find the print program for a SAPScript.

Printed output control table

Table of profile parameters

Profile header, administration data for profiles in DB

Table contains all DD tables to be logged

Communication Table for Transport Control

Title texts for programs in TRDIR

Table of Naming Conventions in ABAP Workbench

Job ID for Coordinating Batch-ABAP/UNIX for Transports

Spool- Device Description Extension

TemSe data

OBSOLETE- Do not use (see TCESYST)

OBSOLETE- Do not use (See TCETRAL)

Relation transaction - authorization object

User address data

User Master Parameter ID

User master authorization values

Table for illegal passwords

User master- Additional data

User masters

Variant texts

Variant directory

Table for Use Report---Tables

SAP tables

R/3 DD- SAP table texts

Table Fields

DD- Texts for fields (language dependent)

IDOC Control Records

Short description of IDoc types

IDOC segments (version 3.1)

IDOC segments (version 4.6)

EDI- Table of all segments of current release

Central Table for Version Management (Report Source)

Can add parameters to the INSERT COMMAND (IC). Then, when you insert command, your info appears in the editor. Useful for comment blocks, common section of code, etc.

Change document items

Change document header

governs the foreground sequence of infotypes the system will use to prompt the user during online and batch processing. You will have to code your BDC to follow that sequence of creating infotypes.

governs the dynamic event processing that will only take place during online user inputs. For BDC's you will have to create separate BDC's to handle any infotypes that are inserted dynamically by this table.

Infotype Screen Control

SAP tables-12(PM)


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
SQ01                Abap query
EDMSG            ALE message type table

SAP Tables-11(PS)

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



SAP Tables-10(PP)

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.
                       
  

SAP Tables-9(QM)



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