SAP table T5DBA (Social Funds in the Building Sector)
SAP table T5DBA has 3 primary key fields being MANDT,ZVKAS,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 | |
| ZVKAS | Social Fund | CHAR | 2 | 0 | P01B_ZVKAS | ||
| ENDDA | End Date | DATS | 8 | 0 | ENDDA | ||
| BEGDA | Start Date | DATS | 8 | 0 | BEGDA | ||
| ZVKN1 | Social Fund - Name (First Part) | CHAR | 30 | 0 | P01B_ZVKN1 | ||
| ZVKN2 | Social Fund - Name (Second Part) | CHAR | 30 | 0 | P01B_ZVKN2 | ||
| ZVKNN | Short Name of Social Fund | CHAR | 30 | 0 | P01B_ZVKNN | ||
| ZVKST | Street and House Number | CHAR | 30 | 0 | STRAS | ||
| ZVKPZ | Postal Code | CHAR | 10 | 0 | PSTLZ | ||
| ZVKO1 | City | CHAR | 25 | 0 | ORT01 | ||
| ZVKLD | Country/Region Key | CHAR | 3 | 0 | T005 | LAND1 | |
| RZNAG | Data Center Number for Company for Social Fund (R) | CHAR | 8 | 0 | P01B_BKRZA | ||
| ADRNR | Address | CHAR | 10 | 0 | * | ADRNR | |
| ANTXT | Text (30 Characters) | CHAR | 30 | 0 | TEXT30 |
T5DBA foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T5DBA | ZVKLD | T005 | Countries | MANDT |
| 0 T5DBA | ZVKLD | T005 | Countries | LAND1 |