SAP Table

T005S Taxes: Region (Province) Key

SAP table T005S has 3 primary key fields being MANDT,LAND1,BLAND.

If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.

/ Fields

T005S columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 T000 MANDT
KeyLAND1 Country/Region Key CHAR 3 0 T005 LAND1
KeyBLAND Region (State, Province, County) CHAR 3 0 REGIO
FPRCD Provincial Tax Code CHAR 3 0 FPRCD
HERBL State of manufacture CHAR 2 0 HERBL
/ Relationships

T005S foreign keys.

Table Field Check Table Description Check Field
T005S LAND1 T005 Countries MANDT
T005S LAND1 T005 Countries LAND1
T005S MANDT T000 Clients MANDT
Back to SAP tables