SAP Table

T005N Name formats

SAP table T005N has 3 primary key fields being MANDT,LAND1,NAMEFORMAT.

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

T005N 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
KeyNAMEFORMAT Name format key CHAR 2 0 AD_NAMFORM
/ Relationships

T005N foreign keys.

Table Field Check Table Description Check Field
T005N LAND1 T005 Countries MANDT
T005N LAND1 T005 Countries LAND1
T005N MANDT T000 Clients MANDT