SAP ABAP Table PZA_LABREL1 (ALV structure for Labour Relations reporting I)
Hierarchy
☛
SAP_HRCZA (Software Component) Sub component SAP_HRCZA of SAP_HR
⤷ PA-PA-ZA (Application Component) South Africa
⤷ PB16 (Package) Human resources department master data: South Africa
⤷ PA-PA-ZA (Application Component) South Africa
⤷ PB16 (Package) Human resources department master data: South Africa
Basic Data
Table Category | INTTAB | Structure |
Structure | PZA_LABREL1 | Table Relationship Diagram |
Short Description | ALV structure for Labour Relations reporting I |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | LRTYP | P16_LRTYP | SUBTY_591A | CHAR | 4 | 0 | Labour Relations Type | * | |
2 | STEXT | SBTTX | TEXT40 | CHAR | 40 | 0 | Name of Subtype | ||
3 | CASNR | P16_LRCASNR | P16_LRCASNR | NUMC | 12 | 0 | Case Number (Labour Relations ZA) | ||
4 | PERNR | PERNR_D | PERNR | NUMC | 8 | 0 | Personnel Number | ||
5 | NACHN | NACHN | NACHN | CHAR | 25 | 0 | Last Name | ||
6 | INITS | INITS | TEXT10 | CHAR | 10 | 0 | Initials | ||
7 | STATU | P16_LRSTAT | P16_LRSTAT | NUMC | 3 | 0 | Status/Level of Labour Relations Intervention | * | |
8 | STATD | P16_LRDESCM | TEXT50 | CHAR | 50 | 0 | Description | ||
9 | REASN | P16_LRREAS | P16_LRREAS | NUMC | 3 | 0 | Reason for / Nature of Labour Relations intervention | * | |
10 | REASD | P16_LRDESCM | TEXT50 | CHAR | 50 | 0 | Description | ||
11 | DATEP | P16_LRDATEP | DATS | 8 | 0 | Actual date of act/omission/misconduct | |||
12 | OUTCK | P16_LROUCT | P16_LROUCT | NUMC | 3 | 0 | Outcome of Labour Relations Intervention | * | |
13 | OUTCD | P16_LRDESCM | TEXT50 | CHAR | 50 | 0 | Description | ||
14 | .INCLUDE | 0 | 0 | HR Master Record: Infotype 0001 (Org. Assignment) | |||||
15 | .INCLUDE | 0 | 0 | HR Master Record: Infotype 0001 (Org. Assignment) | |||||
16 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
17 | WERKS | PERSA | PERSA | CHAR | 4 | 0 | Personnel Area | T500P | |
18 | PERSG | PERSG | PERSG | CHAR | 1 | 0 | Employee Group | T501 | |
19 | PERSK | PERSK | PERSK | CHAR | 2 | 0 | Employee Subgroup | T503K | |
20 | VDSK1 | VDSK1 | VDSK1 | CHAR | 14 | 0 | Organizational Key | T527O | |
21 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | TGSB | |
22 | BTRTL | BTRTL | BTRTL | CHAR | 4 | 0 | Personnel Subarea | T001P | |
23 | JUPER | JUPER | JUPER | CHAR | 4 | 0 | Legal Person | ||
24 | ABKRS | ABKRS | ABKRS | CHAR | 2 | 0 | Payroll Area | T549A | |
25 | ANSVH | ANSVH | ANSVH | CHAR | 2 | 0 | Work Contract | T542A | |
26 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | CSKS | |
27 | ORGEH | ORGEH | ORGEH | NUMC | 8 | 0 | Organizational Unit | T527X | |
28 | PLANS | PLANS | PLANS | NUMC | 8 | 0 | Position | T528B | |
29 | STELL | STELL | STELL | NUMC | 8 | 0 | Job | T513 | |
30 | MSTBR | MSTBR | MSTBR | CHAR | 8 | 0 | Supervisor Area | ||
31 | SACHA | SACHA | SACHA | CHAR | 3 | 0 | Payroll Administrator | T526 | |
32 | SACHP | SACHP | SACHA | CHAR | 3 | 0 | Administrator for HR Master Data | T526 | |
33 | SACHZ | SACHZ | SACHA | CHAR | 3 | 0 | Administrator for Time Recording | T526 | |
34 | SNAME | SMNAM | CHAR30 | CHAR | 30 | 0 | Employee's Name (Sortable by LAST NAME FIRST NAME) | ||
35 | ENAME | EMNAM | TEXT40 | CHAR | 40 | 0 | Formatted Name of Employee or Applicant | ||
36 | OTYPE | OTYPE | OTYPE | CHAR | 2 | 0 | Object Type | T778O | |
37 | SBMOD | SBMOD | CHAR4 | CHAR | 4 | 0 | Administrator Group | ||
38 | KOKRS | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | TKA01 | |
39 | FISTL | FISTL | FISTL | CHAR | 16 | 0 | Funds Center | * | |
40 | GEBER | BP_GEBER | BP_GEBER | CHAR | 10 | 0 | Fund | * | |
41 | FKBER | FKBER | FKBER | CHAR | 16 | 0 | Functional Area | * | |
42 | GRANT_NBR | GM_GRANT_NBR | GM_GRANT_NBR | CHAR | 20 | 0 | Grant | ||
43 | SGMNT | FB_SEGMENT | FB_SEGMENT | CHAR | 10 | 0 | Segment for Segmental Reporting | * | |
44 | .INCLUDE | 0 | 0 | ||||||
45 | TOTAL | P16_EECNT | DEC | 15 | 0 | Number of Employees/Cases | |||
46 | LIGHT | LVC_EXLED | CHAR1 | CHAR | 1 | 0 | ALV control: Exception as LED | ||
47 | OCCAT | P16_OCCAT | P16_OCCAT | CHAR | 4 | 0 | Occupational Category Employment Equity | ||
48 | OCTXT | P16_OCTXT | DDTEXT | CHAR | 60 | 0 | Description of Occupational Category | ||
49 | OCLEV | P16_OCLEV | P16_OCLEV | CHAR | 4 | 0 | Occupation Level Employment equity | ||
50 | OLTXT | P16_OLTXT | DDTEXT | CHAR | 60 | 0 | Description of Occupational Level | ||
51 | GESCH | GESCH | GESCH | CHAR | 1 | 0 | Gender Key | ||
52 | PERMS | P16_PERM | P16_PERM | CHAR | 1 | 0 | Permanent - (Equity) | ||
53 | NATSL | NATSL | LAND1 | CHAR | 3 | 0 | Nationality | * | |
54 | JOBTY | P16_JOBTY | P16_JOBTY | NUMC | 2 | 0 | Job/Function Type | ||
55 | DISAB | P16_DISAB | XFELD | CHAR | 1 | 0 | Disability | ||
56 | AFRIC | P16_AFRIC | DEC | 15 | 0 | Counter . Employees designated ethnic group is African | |||
57 | COLOU | P16_COLOU | DEC | 15 | 0 | Desgnated ethnic group Coloured Employment Equity | |||
58 | INDIA | P16_INDIA | DEC | 15 | 0 | Counter . Employees designated ethnic group is Indian | |||
59 | WHITE | P16_WHITE | DEC | 15 | 0 | Counter . Employees designated ethnic group is White | |||
60 | BEGDA | BEGDA | DATUM | DATS | 8 | 0 | Start Date | ||
61 | ENDDA | ENDDA | DATUM | DATS | 8 | 0 | End Date | ||
62 | PLNTX | STEXT | TEXT40 | CHAR | 40 | 0 | Object Name | ||
63 | ORGTX | STEXT | TEXT40 | CHAR | 40 | 0 | Object Name |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | PZA_LABREL1 | ABKRS | T549A | ABKRS | |||
2 | PZA_LABREL1 | ANSVH | T542A | ANSVH | |||
3 | PZA_LABREL1 | BTRTL | T001P | BTRTL | |||
4 | PZA_LABREL1 | BUKRS | T001 | BUKRS | |||
5 | PZA_LABREL1 | GSBER | TGSB | GSBER | |||
6 | PZA_LABREL1 | KOKRS | TKA01 | KOKRS | |||
7 | PZA_LABREL1 | KOSTL | CSKS | KOSTL | |||
8 | PZA_LABREL1 | ORGEH | T527X | ORGEH | |||
9 | PZA_LABREL1 | OTYPE | T778O | OTYPE | |||
10 | PZA_LABREL1 | PERSG | T501 | PERSG | |||
11 | PZA_LABREL1 | PERSK | T503K | PERSK | |||
12 | PZA_LABREL1 | PLANS | T528B | PLANS | |||
13 | PZA_LABREL1 | SACHA | T526 | SACHX | |||
14 | PZA_LABREL1 | SACHP | T526 | SACHX | |||
15 | PZA_LABREL1 | SACHZ | T526 | SACHX | |||
16 | PZA_LABREL1 | STELL | T513 | STELL | |||
17 | PZA_LABREL1 | VDSK1 | T527O | ORGKY | |||
18 | PZA_LABREL1 | WERKS | T500P | PERSA |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 600 |