SAP table WBBL (Assort. list control break)

SAP table WBBL has 5 primary key fields being MANDT,LOCNR,BBTYP,VERSNR,BBGNO.

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
VERSNR Assortment list version no. NUMC 6 0 WBBH BBVERSNR
BBGNO Assortment list group no. NUMC 10 0 BBGNO
BSORT Sorting Procedure in Assortment List CHAR 1 0 BSORT
1 Department, layout area
2 Layout area
3 Supplier, supplier sub-range, material number
4 Supplier, material group, material number
5 Department, material group, material number
6 Material group, material no.
9 Other (user exit)
PGNUM Page number in assortment list (not used) NUMC 5 0 PGNUM
LAYGR Layout Module CHAR 10 0 TWML LAYGR
LTEXT Assortment list group description CHAR 20 0 BB_LAYGRTX
LAYVR Layout CHAR 10 0 TWGV LAYVAR
LNGLV Layout area number NUMC 10 0 LAYPOSNR
LBTXT Layout description CHAR 20 0 BB_LAYVRTX
ABTNR Department number CHAR 4 0 TSAB ABTNR
ABTTX Description for a group of assortment list groups CHAR 20 0 ABTTX
LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
LTSNR Supplier Subrange CHAR 6 0 WYT1 LTSNR
MATKL Material Group CHAR 9 0 T023 MATKL

WBBL foreign key relationships

Table Field Check Table Check Field
0 WBBL ABTNR TSAB Contact persons: standard departments MANDT
0 WBBL ABTNR TSAB Contact persons: standard departments ABTNR
1 WBBL BBTYP TWBB Assortment list type MANDT
0 WBBL LAYGR TWML Layout module MANDT
0 WBBL LAYGR TWML Layout module LAYGR
1 WBBL LAYVR TWGV Layout MANDT
1 WBBL LAYVR TWGV Layout LAYVR
0 WBBL LIFNR LFA1 Supplier Master (General Section) MANDT
0 WBBL LIFNR LFA1 Supplier Master (General Section) LIFNR
1 WBBL LOCNR KNA1 General Data in Customer Master MANDT
1 WBBL LOCNR KNA1 General Data in Customer Master KUNNR
0 WBBL LTSNR WYT1 Vendor Subrange MANDT
0 WBBL LTSNR WYT1 Vendor Subrange LIFNR
0 WBBL LTSNR WYT1 Vendor Subrange LTSNR
1 WBBL MANDT T000 Clients MANDT
0 WBBL MATKL T023 Material Groups MATKL
1 WBBL VERSNR WBBH Assortment list header MANDT
1 WBBL VERSNR WBBH Assortment list header LOCNR
1 WBBL VERSNR WBBH Assortment list header BBTYP