SAP table T5DBY (Construction Pay Data Center Numbers / SFP Data Medium)
SAP table T5DBY has 4 primary key fields being MANDT,ZVKAS,RZNUM,RZDAT.
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 | |
| ZVKAS | Social Fund | CHAR | 2 | 0 | T5DBA | P01B_ZVKAS | |
| RZNUM | Data Center Number for Construction Industry Social Fund | CHAR | 8 | 0 | P01B_RZNUM | ||
| RZDAT | Creation Date of Data Medium | DATS | 8 | 0 | P01B_RZDAT | ||
| ENDDA | End date of data selection period | DATS | 8 | 0 | PNPENDDA | ||
| BEGDA | Start date of data selection period | DATS | 8 | 0 | PNPBEGDA | ||
| XABKR | Payroll Area for Determining Time Period | CHAR | 2 | 0 | * | PNPXABKR | |
| PABRJ | Payroll year for determining time period | NUMC | 4 | 0 | PNPPABRJ | ||
| PABRP | Payroll period for determining time period | NUMC | 2 | 0 | PNPPABRP | ||
| RZADR | Return Address for Data Center Number (Social Fund Cons.Ind) | CHAR | 36 | 0 | P01B_RZADR | ||
| DATUM | System Date | DATS | 8 | 0 | SYDATUM | ||
| UZEIT | System Time | TIMS | 6 | 0 | SYUZEIT | ||
| UNAME | User Name | CHAR | 12 | 0 | SYUNAME | ||
| REPID | ABAP Program: Current Master Program | CHAR | 40 | 0 | * | SYREPID |
T5DBY foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T5DBY | ZVKAS | T5DBA | Social Funds in the Building Sector | MANDT |
| 0 T5DBY | ZVKAS | T5DBA | Social Funds in the Building Sector | ZVKAS |
| 0 T5DBY | ZVKAS | T5DBA | Social Funds in the Building Sector | ENDDA |