SAP ABAP Table TC38A (Shift sequence)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       CR (Package) R/3 Application development: PP Resources
Basic Data
Table Category TRANSP    Transparent table 
Transparent table TC38A   Table Relationship Diagram
Short Description Shift sequence    
Delivery and Maintenance
Pool/cluster      
Delivery Class C   Customizing table, maintenance only by cust., not SAP import 
Data Browser/Table View Maintenance X   Display/Maintenance Allowed 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client T000
2 SCHGRUP SCHGRUP SCHGRUP CHAR 2   0   Grouping for Shift Definitions and Shift Sequences TC39A
3 SPROG SCHPROG SCHPROG CHAR 4   0   Key for the shift sequence  
4 SCHNR SCHICHTNR NUM01 NUMC 1   0   Shift number of the available capacity  
5 TPROG1 KAPTPROG KAPTPROG CHAR 4   0   Shift definition TC37A
6 TPROG2 KAPTPROG KAPTPROG CHAR 4   0   Shift definition TC37A
7 TPROG3 KAPTPROG KAPTPROG CHAR 4   0   Shift definition TC37A
8 TPROG4 KAPTPROG KAPTPROG CHAR 4   0   Shift definition TC37A
9 TPROG5 KAPTPROG KAPTPROG CHAR 4   0   Shift definition TC37A
10 TPROG6 KAPTPROG KAPTPROG CHAR 4   0   Shift definition TC37A
11 TPROG7 KAPTPROG KAPTPROG CHAR 4   0   Shift definition TC37A
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 TC38A MANDT T000 MANDT KEY 1 CN
2 TC38A SCHGRUP TC39A SCHGRUP 1 CN
3 TC38A TPROG1 TC37A KAPTPROG REF C CN
4 TC38A TPROG2 TC37A KAPTPROG REF C CN
5 TC38A TPROG3 TC37A KAPTPROG REF C CN
6 TC38A TPROG4 TC37A KAPTPROG REF C CN
7 TC38A TPROG5 TC37A KAPTPROG REF C CN
8 TC38A TPROG6 TC37A KAPTPROG REF C CN
9 TC38A TPROG7 TC37A KAPTPROG REF C CN
History
Last changed by/on SAP  20041209 
SAP Release Created in