SAP Table T5W15
Job to SOC Code Allocation (South Africa)
T5W15 (Job to SOC Code Allocation (South Africa)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link T5W15 to other SAP tables.
T5W15 table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||||||||
STELL | Job | STELL | T513 | NUMC | 8 | 0 | ||||||||||||||||||||
ENDDA | End Date | ENDDA | DATS | 8 | 0 | |||||||||||||||||||||
BEGDA | Start Date | BEGDA | DATS | 8 | 0 | |||||||||||||||||||||
OCCAT | Occupational Category Employment Equity | P16_OCCAT | CHAR | 4 | 0 |
Possible values
|
||||||||||||||||||||
SOCCD | Reserved field/unused field of length 4 | NUSED4 | CHAR | 4 | 0 | |||||||||||||||||||||
SOCCL | Standard Occupational Category Code (South Africa) | P16_SOC7 | T5W17 | CHAR | 7 | 0 | ||||||||||||||||||||
JOBTY | Job/Function Type | P16_JOBTY | NUMC | 2 | 0 |
Possible values
|
||||||||||||||||||||
OFOCD | OFO Code | P16_OFOCD | T5WOT | NUMC | 6 | 0 | ||||||||||||||||||||
OCIDX | Alternative Title Index | P16_OCIDX | T5WOCT | NUMC | 10 | 0 | ||||||||||||||||||||
SLEVEL | Skill Levels (OFO South Africa) | P16_SLEVEL | NUMC | 2 | 0 |
T5W15 foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
T5W15 | MANDT | T5W15 | MANDT | T000 | Clients | MANDT |
T5W15 | OCIDX | T5W15 | MANDT | T5WOCT | Alternative Title / Specialization (South Africa) | MANDT |
T5W15 | OCIDX | * | T5WOCT | Alternative Title / Specialization (South Africa) | SPRSL | |
T5W15 | OCIDX | T5W15 | OCIDX | T5WOCT | Alternative Title / Specialization (South Africa) | OCIDX |
T5W15 | OCIDX | * | T5WOCT | Alternative Title / Specialization (South Africa) | ENDDA | |
T5W15 | OFOCD | T5W15 | MANDT | T5WOT | OFO Codes Descriptions (South Africa) | MANDT |
T5W15 | OFOCD | * | T5WOT | OFO Codes Descriptions (South Africa) | SPRSL | |
T5W15 | OFOCD | T5W15 | OFOCD | T5WOT | OFO Codes Descriptions (South Africa) | OFOCD |
T5W15 | OFOCD | * | T5WOT | OFO Codes Descriptions (South Africa) | ENDDA | |
T5W15 | SOCCL | * | T5W17 | SOC Codes (South Africa) | ENDDA | |
T5W15 | SOCCL | T5W15 | MANDT | T5W17 | SOC Codes (South Africa) | MANDT |
T5W15 | SOCCL | T5W15 | SOCCL | T5W17 | SOC Codes (South Africa) | SOCCL |
T5W15 | STELL | T5W15 | MANDT | T513 | Jobs | MANDT |
T5W15 | STELL | T5W15 | STELL | T513 | Jobs | STELL |
T5W15 | STELL | * | T513 | Jobs | ENDDA |