Tuesday, April 7, 2009

SAP Tutorial - Part 7 - SAP Tables - Part 2

Human Resources Tables/Infotypes

CATSCO Cross-Application Time Sheet (CATS)- Transfer to CO

CATSDB CATS- Database Table for Time Sheet

CATSHR Cross-Application Time Sheet (CATS)- Transfer to HR

CATSMM Cross-Application Time Sheet (CATS)- Transfer to MM

CATSPM Cross-Application Time Sheet (CATS)- Transfer to PM/CS

CATSPS Cross-Application Time Sheet (CATS)- Transfer to PS

CSKS Cost Center Master Data

CSKT Cost Center Texts

PCL1 HR Cluster 1

PCL2 HR Cluster 2

T001P Personnel Area/Subarea

T001T Company code-dependent texts

T500L Personnel Country Grouping

T500P Personnel Areas

T502T Marital Status Designators

T503 Employee Group/Subgroup

T503T Employee Subgroup Names

T508A Work Schedule Rules

T510 Pay Scale Groups

T510A Pay Scale Types

T510F Assign Pay Scale --- Currency

T510W Pay Scale - Period Parameter Assignment

T511 Wage Types

T512T Wage Type Texts

T512W Wage Type Valuation

T512Z Permissibility of Wage Types per Infotype

T527X Organizational Units

T528T Position Texts

T529T Personnel Action Texts

T529U Status Values

T530 Reasons for Actions

T530T Reason for Action Texts

T549A Payroll Accounting Areas

T549Q Payroll Periods

T550A Daily Work Schedule

T550S Daily Work Schedule Texts

T551S Period Work Schedule Texts

T552A Monthly Work Schedule

T554C Absence Valuation

T554S Attendance and Absence Types

T554T Attendance and Absence Texts

T558B Payroll Account Transfer- Payroll Periods

T569V Control Records

T5K8C Transfer ext. payroll results into Canadian specific tables

T74FA Benefit insurance plan

T74FC Benefits Insurance Coverage Rule

HRP1000 Infotype 1000 DB Table (Objects)

HRP1001 Infotype 1001 DB Table (Relationships)

HRP1002 Infotype 1002 DB Table

HRP1003 Infotype 1003 DB Table

HRP1004 Infotype 1004 DB table



Project Systems Tables

IMAK Appropriation requests - general data

IMAV Appropriation request variant

IMPR Investment Program Positions

IMPU Texts for cap. inv. program positions

IMTP Investment programs

IMZO Assignment Table- CO Object - Capital Investment Prog.Pos.

PMCO Cost structure of maintenance order

PRHI Work Breakdown Structure, Edges (Hierarchy Pointer)

PROJ Project definition

PRPS WBS (Work Breakdown Structure) Element Master Data



Production Planning Tables

MAST Material BOM

STKO BOM Header

STPO BOM Positions (detail)

MAPL Assignment of Task Lists to Materials

PLKO Routing Group Header

PLSO Routing Group Sequence

PLPO Routing Group Operations

AFKO Production Order Header

AFPO Production Order Position (details)



System Tables

ADCP Person/Address assignment (central address administration)

ADIRACCESS Table to store keys for TADIR objects

ADR2 Telephone numbers (central address admin.)

ADRP Persons (central address administration)

APQD DATA DEFINITION Queue

APQI Queue info definition

D010SINF ABAP- Information about ABAP program source code

E071 Change and Transport System- Object Entries of Requests/Tasks

E07T Change and Transport System- Short Texts for Requests/Tasks

ENLFDIR Additional Attributes for Function Modules

INDX System table INDX

NAST Message Status

STXH STXD SAPscript text file header

T005 Countries

T005S Taxes- Region (Province) Key

T005U Taxes- Region Key- Texts

T006 Units of Measurement

T015M Names of the months

T247 Month name and short text

T777A Building Addresses

TADIR Directory of Repository Objects

TBTCO Job status overview table

TBTCP Batch job step overview

TFDIR Function Module

TFTIT Function Module Short Text

TSP03L Spool- Long device names

TSTC SAP Transaction Codes

TSTCT Transaction Code Texts

TUTYP User Types in Current Price List in SAP System

TUZUS Special versions

TVARV Table of variables in selection criteria

TVDIR View Directory

US930 Data Relevant to Measurement for User Master Record

USR01 User master record (runtime data)

USR02 Logon data

USR04 User master authorizations

USR06 Additional Data per User

USR14 Surchargeable Language Versions per User

USR21 Assign user name address key

ARCH_OBJ Objects for archiving and reorganization

BTCUED Description of user event IDs for background processing

BTXSUPB BSI- Upgrade-Information

CCCFLOW Client Copy Control Flow

DBSTATC DB Optimizer Control (Statistics Creation)

DEVACCESS Table for development users

DEVL OBSOLETE- Do not use (See TCETRAL)

E070 Change and Transport System- Header of Requests/Tasks

E070L CTS- Index for Assigning Numbers to Requests/Tasks

INSTVERS Documentation for installation Status and History

PAT03 Patch Directory

SDBAC DBA Action Table

T100 Messages

TAPLT Program Application Long Texts

TASYS OBSOLETE- Do not use, see TCEDELI

TDEVC Development Classes

TEMSE Temp Sequential table.

TLOCK Change and Transport System- Lock Table

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

TNAST Printed output control table

TPFET Table of profile parameters

TPFHT Profile header, administration data for profiles in DB

TPROT Table contains all DD tables to be logged

TRBAT Communication Table for Transport Control

TRDIRT Title texts for programs in TRDIR

TRESN Table of Naming Conventions in ABAP Workbench

TRJOB Job ID for Coordinating Batch-ABAP/UNIX for Transports

TSP03C Spool- Device Description Extension

TST03 TemSe data

TSYST OBSOLETE- Do not use (see TCESYST)

TWSYS OBSOLETE- Do not use (See TCETRAL)

USOBT Relation transaction - authorization object

USR03 User address data

USR05 User Master Parameter ID

USR12 User master authorization values

USR40 Table for illegal passwords

USR41 User master- Additional data

UST04 User masters

VARIT Variant texts

VARID Variant directory

D010TAB Table for Use Report---Tables

DD02L SAP tables

DD02T R/3 DD- SAP table texts

DD03L Table Fields

DD03T DD- Texts for fields (language dependent)

EDIDC IDOC Control Records

EDIDOT Short description of IDoc types

EDID2 IDOC segments (version 3.1)

EDID4 IDOC segments (version 4.6)

EDSEA EDI- Table of all segments of current release

VRSX2 Central Table for Version Management (Report Source)

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

CDPOS Change document items

CDHDR Change document header

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

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

T588M Infotype Screen Control

No comments: