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

Thursday, 13 October 2011

SAP Other Important Tables


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


1.1      Human resources

1.2      Settings

T582A                           Infotypes: Customer-Specific Settings

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

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

SAP Project System Tables


1      Project system (PS)

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

1.2      Equipment

EQUI                                        Equipment master data
EQKT                                       Equipment short text
EQUZ                                       Equipment time segment



2      Plant maintenance (PM)

IHPA                             Plant Maintenance: Partners
OBJK                           Plant Maintenance Object List
            ILOA                             PM Object Location and Account Assignment
AFIH                             Maintenance order header

SAP Production Planning Tables


1      Production Planning (PP)

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

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

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

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

1.5      Planned orders

                PLAF                                                      Planned orders

1.6      KANBAN

            PKPS                                       Kanban identification, control cycle
            PKHD                                       Kanban control cycle (header data)
            PKER                                       Error log for Kanban containers

1.7      Reservations

                RESB                                                     Material reservations
            RKPF                                       header

1.8      Capacity planning

KBKO                                       Header record for capacity requirements
KBED                                       Capacity requirements records
KBEZ                                       Add. data for table KBED (for indiv. capacities/splits)

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