SAP table T5B6B (Pay Scale Agreements (B))
SAP table T5B6B has 3 primary key fields being MANDT,BECAO,ENDDA.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| BECAO | Collective Agreement | CHAR | 4 | 0 | BECAO | ||
| ENDDA | End Date | DATS | 8 | 0 | ENDDA | ||
| BEGDA | Start Date | DATS | 8 | 0 | BEGDA | ||
| STAAT | Date federal announcement | DATS | 8 | 0 | STAAT | ||
| MINLT | Minimum age as stated in collective agreement | NUMC | 2 | 0 | MINLT | ||
| CAOAR | Collective agreement valid for workers | CHAR | 1 | 0 | CAOAR | ||
| CAOBD | Collective agreement valid for salaried employees | CHAR | 1 | 0 | CAOBD |