SAP table T5UTV (Unemployment Insurance Work Sites/NC-9901 Locations)

SAP table T5UTV has 5 primary key fields being MANDT,TXCMP,TAXAU,WKSIT,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
TXCMP Tax company CHAR 4 0 T5UTL TXCMP
TAXAU Tax authority CHAR 4 0 T5UTZ TAXAT
WKSIT Worksite CHAR 2 0 WKSIT
ENDDA End Date DATS 8 0 ENDDA
BEGDA Start Date DATS 8 0 BEGDA
LTEXT Description CHAR 30 0 DESC30
ADRES Address Text (Name, Street, City, Tel. No.) CHAR 40 0 ADRTX
STRAS Street and House Number CHAR 30 0 STRAS
ORT01 City CHAR 25 0 ORT01
STATE Region (State, Province, County) CHAR 3 0 T005S REGIO
ZIPCD Postal Code CHAR 10 0 PSTLZ_HR
TELNR Telephone Number CHAR 14 0 TELNR
REPUN Worksite Reporting Unit Number NUMC 5 0 P10_REPUN
NCLOC NC9901 Location Code CHAR 9 0 P10_NCLOC
NCSTA HR-US: NC-9901 Status CHAR 1 0 P10_NCSTA
1 In operation
2 Idle or inactive(but still owned)
3 Closed
4 Sold or leased to another operator
5 Other
NCACT HR-US: NC-9901 Major Activity CHAR 2 0 T5UMA P10_NCACT

T5UTV foreign key relationships

Table Field Check Table Check Field
0 T5UTV NCACT T5UMA HR-US: NC-9901 Major Activity Code Check Table MACODE
1 T5UTV STATE T005S Taxes: Region (Province) Key LAND1