SAP table reference

TC38A

Shift sequence

Explore another table

Enter a table code or keyword to continue exploring.

Explore the structure, fields and relationships of SAP table TC38A.

SAP table TC38A has 4 primary key fields: MANDT,SCHGRUP,SPROG,SCHNR.

When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.

/ Fields

TC38A fields.

11 fields
FieldDescriptionData typeLengthDecimalsCheck tableData element
Key MANDT ClientCLNT30 T000 MANDT
Key SCHGRUP Grouping for Shift Definitions and Shift SequencesCHAR20 TC39A SCHGRUP
Key SPROG Key for the Shift SequenceCHAR40 SCHPROG
Key SCHNR Shift Number of an Available CapacityNUMC10 SCHICHTNR
TPROG1 Shift DefinitionCHAR40 TC37A KAPTPROG
TPROG2 Shift DefinitionCHAR40 TC37A KAPTPROG
TPROG3 Shift DefinitionCHAR40 TC37A KAPTPROG
TPROG4 Shift DefinitionCHAR40 TC37A KAPTPROG
TPROG5 Shift DefinitionCHAR40 TC37A KAPTPROG
TPROG6 Shift DefinitionCHAR40 TC37A KAPTPROG
TPROG7 Shift DefinitionCHAR40 TC37A KAPTPROG
/ Relationships

TC38A relationships.

23 relationships
TableFieldCheck tableDescriptionCheck field
TC38ASCHGRUPTC39AGrouping shift definitions and shift sequencesMANDT
TC38ASCHGRUPTC39AGrouping shift definitions and shift sequencesSCHGRUP
TC38ATPROG1TC37AShift definitionMANDT
TC38ATPROG1TC37AShift definitionKAPTPROG
TC38ATPROG1TC37AShift definitionENDDA
TC38ATPROG2TC37AShift definitionMANDT
TC38ATPROG2TC37AShift definitionKAPTPROG
TC38ATPROG2TC37AShift definitionENDDA
TC38ATPROG3TC37AShift definitionMANDT
TC38ATPROG3TC37AShift definitionKAPTPROG
TC38ATPROG3TC37AShift definitionENDDA
TC38ATPROG4TC37AShift definitionMANDT
TC38ATPROG4TC37AShift definitionKAPTPROG
TC38ATPROG4TC37AShift definitionENDDA
TC38ATPROG5TC37AShift definitionMANDT
TC38ATPROG5TC37AShift definitionKAPTPROG
TC38ATPROG5TC37AShift definitionENDDA
TC38ATPROG6TC37AShift definitionMANDT
TC38ATPROG6TC37AShift definitionKAPTPROG
TC38ATPROG6TC37AShift definitionENDDA
TC38ATPROG7TC37AShift definitionMANDT
TC38ATPROG7TC37AShift definitionKAPTPROG
TC38ATPROG7TC37AShift definitionENDDA
Back to SAP tables