SAP table T51T8 (Definitions of a tax form)
SAP table T51T8 has 4 primary key fields being MANDT,MOLGA,TXFRM,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 | |
| MOLGA | HCM Localization | CHAR | 2 | 0 | T500L | MOLGA | |
| TXFRM | Tax form | CHAR | 16 | 0 | TXFRM | ||
| ENDDA | End Date | DATS | 8 | 0 | ENDDA | ||
| BEGDA | Start Date | DATS | 8 | 0 | BEGDA | ||
| TMTOT | Time unit | CHAR | 1 | 0 | T51TC | TIMUN | |
| TIMUN | Time unit | CHAR | 1 | 0 | T51TC | TMUNR | |
| CORRN | Identification number | CHAR | 1 | 0 | T51TC | WGEID | |
| CRNFR | Tax form | CHAR | 16 | 0 | T51T8 | TXFRM | |
| P001X | Infotyp Org. Assignment required | CHAR | 1 | 0 | P001X | ||
| P002X | Personal Data required | CHAR | 1 | 0 | P002X | ||
| P006X | Infotype Address required | CHAR | 1 | 0 | P006X | ||
| CMPAD | Address of the tax company for tax reporter | CHAR | 1 | 0 | CMPAD | ||
| WKSAD | Address of worksite for tax reporter | CHAR | 1 | 0 | WKSAD | ||
| SCFRM | Layout set, which will be used for SAP Script output | CHAR | 16 | 0 | T51T8 | SCFRM | |
| MTFRM | Magnetic tape definitions, which will be used for tape rep. | CHAR | 16 | 0 | T51T8 | MTFRM | |
| TAXAU | Tax authority | CHAR | 4 | 0 | * | TAXAT | |
| FRMTY | Identifier of tax forms | CHAR | 1 | 0 | T51TC | FRMGR | |
| NPFLG | New page per new employee | CHAR | 1 | 0 | NPFLG | ||
| FPINT | Interface name | CHAR | 30 | 0 | FPINT |
T51T8 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T51T8 | CORRN | T51TC | Tax attributes | MANDT |
| 1 T51T8 | CRNFR | T51T8 | Definitions of a tax form | MANDT |
| 1 T51T8 | CRNFR | T51T8 | Definitions of a tax form | ENDDA |
| 0 T51T8 | FRMTY | T51TC | Tax attributes | MANDT |
| 1 T51T8 | MOLGA | T500L | Personnel Country Grouping | MOLGA |
| 0 T51T8 | MTFRM | T51T8 | Definitions of a tax form | MANDT |
| 0 T51T8 | MTFRM | T51T8 | Definitions of a tax form | ENDDA |
| 1 T51T8 | SCFRM | T51T8 | Definitions of a tax form | MANDT |
| 1 T51T8 | SCFRM | T51T8 | Definitions of a tax form | ENDDA |
| 0 T51T8 | TIMUN | T51TC | Tax attributes | MANDT |
| 1 T51T8 | TMTOT | T51TC | Tax attributes | MANDT |