SAP table WBBP (Assortment list item)

SAP table WBBP has 6 primary key fields being MANDT,LOCNR,BBTYP,MATNR,VERSNR,BBRNO.

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
LOCNR Customer Number CHAR 10 0 KNA1 KUNNR
BBTYP Assortment List Type CHAR 1 0 TWBB BBTYP
MATNR Material Number CHAR 40 0 MARA MATNR
VERSNR Assortment list version no. NUMC 6 0 WBBH BBVERSNR
BBRNO Sequence number of item in assortment list INT4 10 0 BBRNO
EAN11 International Article Number (EAN/UPC) CHAR 18 0 EAN11
EANTP Category of International Article Number (EAN) CHAR 2 0 TNTP NUMTP
BBGNO Assortment list group no. NUMC 10 0 WBBL BBGNO
PGNUM Page number in assortment list (not used) NUMC 5 0 PGNUM
AENTP Change category CHAR 1 0 AENTP
empty
C updated
W Selected
LABRL ID: relevant for labeling CHAR 1 0 LABRL
BBLIN Assortment list data line long CHAR 250 0 BBLINL
GROUP1 Assortment List: Grouping Field 1 CHAR 10 0 GROUP1
GROUP2 Assortment List: Grouping Field 2 CHAR 10 0 GROUP2

WBBP foreign key relationships

Table Field Check Table Check Field
0 WBBP BBGNO WBBL Assort. list control break MANDT
0 WBBP BBGNO WBBL Assort. list control break LOCNR
0 WBBP BBGNO WBBL Assort. list control break BBTYP
0 WBBP BBGNO WBBL Assort. list control break VERSNR
0 WBBP BBGNO WBBL Assort. list control break BBGNO
1 WBBP BBTYP TWBB Assortment list type MANDT
0 WBBP EANTP TNTP International Article Number (EAN) Categories MANDT
0 WBBP EANTP TNTP International Article Number (EAN) Categories NUMTP
1 WBBP LOCNR KNA1 General Data in Customer Master MANDT
1 WBBP LOCNR KNA1 General Data in Customer Master KUNNR
0 WBBP MANDT T000 Clients MANDT
1 WBBP MATNR MARA General Material Data MANDT
1 WBBP MATNR MARA General Material Data MATNR
0 WBBP VERSNR WBBH Assortment list header MANDT
0 WBBP VERSNR WBBH Assortment list header LOCNR
0 WBBP VERSNR WBBH Assortment list header BBTYP