SAP table T5R1A (Institution of Soc. Provident Funds SG)
SAP table T5R1A has 4 primary key fields being MANDT,SIGRP,SIOFC,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 | |
| SIGRP | Institution of soc. provident funds SG | CHAR | 2 | 0 | P25M_SIGRP | ||
| SIOFC | Social insurance branch office | CHAR | 6 | 0 | P25M_SIOFC | ||
| ENDDA | End Date | DATS | 8 | 0 | ENDDA | ||
| BEGDA | Start Date | DATS | 8 | 0 | BEGDA | ||
| SINAM | Corresponding address of inst. of social insurance or office | CHAR | 30 | 0 | P25M_SINAM | ||
| PSTLZ | Postal Code | CHAR | 10 | 0 | PSTLZ | ||
| STRAS | Street and House Number | CHAR | 30 | 0 | STRAS | ||
| LOCAT | 2nd Address Line | CHAR | 30 | 0 | LOCAT | ||
| ORT01 | City | CHAR | 25 | 0 | ORT01 | ||
| TELNR | Telephone Number | CHAR | 14 | 0 | TELNR | ||
| SIGNR | Company number | CHAR | 15 | 0 | P25M_SIGNR | ||
| LAND1 | Country/Region Key | CHAR | 3 | 0 | T005 | LAND1 | |
| BANKL | Bank Number | CHAR | 15 | 0 | BANKL | ||
| SIACC | Account number of social insurance | CHAR | 15 | 0 | P25M_SIACC |
T5R1A foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T5R1A | LAND1 | T005 | Countries | MANDT |
| 0 T5R1A | LAND1 | T005 | Countries | LAND1 |