SAP table T5ITPC (CAF table)
SAP table T5ITPC has 3 primary key fields being MANDT,COFIS,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 | |
| COFIS | Tax number of the fiscal office (CAF) that provided support | CHAR | 16 | 0 | P15_COFIS | ||
| ENDDA | End Date | DATS | 8 | 0 | ENDDA | ||
| BEGDA | Start Date | DATS | 8 | 0 | BEGDA | ||
| DENOM | Description | CHAR | 60 | 0 | P15_DENOM | ||
| IDCAF | CAAF ID number | NUMC | 5 | 0 | P15_IDCAF | ||
| CITTA | City | CHAR | 25 | 0 | ORT01 | ||
| PROVI | Region (State, Province, County) | CHAR | 3 | 0 | T005S | REGIO | |
| CAVPO | Postal Code | CHAR | 10 | 0 | PSTLZ | ||
| INDIR | Street and House Number | CHAR | 35 | 0 | STRAS_GP | ||
| TELEF | Telephone number | CHAR | 14 | 0 | TELEF | ||
| TLFFX | Fax Number | CHAR | 25 | 0 | FAXNR | ||
| DATA | Form data archiving date | DATS | 8 | 0 | P15_DATAA | ||
| DATAR | Archiving date adjustment data | DATS | 8 | 0 | P15_DATAR |
T5ITPC foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T5ITPC | PROVI | T005S | Taxes: Region (Province) Key | LAND1 |