SAP Table

T001S Accounting Clerks

SAP table T001S has 3 primary key fields being MANDT,BUKRS,BUSAB.

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

T001S columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 T000 MANDT
KeyBUKRS Company Code CHAR 4 0 T001 BUKRS
KeyBUSAB Accounting Clerk Abbreviation CHAR 2 0 BUSAB
SNAME Name of Accounting Clerk CHAR 30 0 SNAME_001S
USNAM Name of SAP Office User CHAR 12 0 FI_USR_NAM
/ Relationships

T001S foreign keys.

Table Field Check Table Description Check Field
T001S BUKRS T001 Company Codes BUKRS
T001S MANDT T000 Clients MANDT