SAP table TE001 (Alloc. of Co. Code - Division)

SAP table TE001 has 3 primary key fields being MANDT,BUKRS,SPARTE.

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
BUKRS Company Code CHAR 4 0 T001 BUKRS
SPARTE Division CHAR 2 0 TSPA SPARTE
GEMFAKT Invoice Contracts Jointly (Mandatory Contracts) CHAR 1 0 E_GEMFAKT
1 Contract must be invoiced jointly with other contracts
2 Contract can be invoiced jointly with other contracts
3 Contract must not be invoiced with other contracts

TE001 foreign key relationships

Table Field Check Table Check Field
0 TE001 BUKRS T001 Company Codes BUKRS
1 TE001 SPARTE TSPA Organizational Unit: Sales Divisions MANDT
1 TE001 SPARTE TSPA Organizational Unit: Sales Divisions SPART