SAP table WBBP_SORT (List structure WBBP with additional fields for sorting)

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
ATTYP Material Category CHAR 2 0 ATTYP
Product
00 Single material
01 Generic material
02 Variant
10 Sales set
11 Prepack
12 Display
20 Material group material
21 Hierarchy material
22 Group material
30 Material group reference material
SATNR Cross-Plant Configurable Material CHAR 40 0 * SATNR
ABTNR Department number CHAR 4 0 * ABTNR
LAYVR Layout CHAR 10 0 * LAYVAR
LNLGV Sequence no. of layout area in layout NUMC 10 0 LNLGV
LAYGR Layout Module CHAR 10 0 LAYGR
LMVER Version of a Layout Module (Alphanumerical) CHAR 4 0 LAYMOD_VER_ALPHA
LMVAR Variant for Layout Module Version CHAR 4 0 * LAYMOD_VAR
SORF1 Sort sequence number in layout module NUMC 10 0 SORF1
FACIN Number of materials placed next to one another QUAN 13 3 FACING
SHELF Shelf Section NUMC 10 0 SHELF_NO
MEVOR Placement number of a material in a layout NUMC 4 0 MEVOR
MELAY Unit of Measure for Display UNIT 3 0 * MEINH
HPLGR Indicator: Main layout module CHAR 1 0 HPLGR
ASL_VNO Assortment list version no. NUMC 6 0 * BBVERSNR
ASL_GNO Assortment list group no. NUMC 10 0 * BBGNO
ASL_PNO Sequence number of item in assortment list INT4 10 0 * BBRNO
ASL_DATE Change valid from DATS 8 0 BB_GUELTAB

WBBP_SORT foreign key relationships

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