SAP Table

TB001 BP groupings

SAP table TB001 has 2 primary key fields being MANDT,BU_GROUP.

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

TB001 columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 T000 MANDT
KeyBU_GROUP Business Partner Grouping CHAR 4 0 BU_GROUP
NRRNG BP Number Range CHAR 2 0 NRIV BU_NRRNG
XINST Standard Grouping for Internal Number Assignment CHAR 1 0 BU_XINST
XEXST Standard Grouping for External Number Assignment CHAR 1 0 BU_XEXST
XSUPPRESS Hide BP Grouping CHAR 1 0 BU_GROUP_SUPPRESS
KTOKD Customer Account Group CHAR 4 0 T077D KTOKD
/ Relationships

TB001 foreign keys.

Table Field Check Table Description Check Field
TB001 KTOKD T077D Customer account groups MANDT
TB001 NRRNG NRIV Number Range Intervals CLIENT
TB001 NRRNG NRIV Number Range Intervals SUBOBJECT
TB001 NRRNG NRIV Number Range Intervals NRRANGENR
TB001 NRRNG NRIV Number Range Intervals TOYEAR
Back to SAP tables