SAP table WBBH (Assortment list header)

SAP table WBBH has 4 primary key fields being MANDT,LOCNR,BBTYP,VERSNR.

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 for Plant CHAR 10 0 KNA1 LOCNR
BBTYP Assortment List Type CHAR 1 0 TWBB BBTYP
VERSNR Assortment list version no. NUMC 6 0 BBVERSNR
VERSAB Assortment list version valid from DATS 8 0 VERSAB
VERSBI Assortment list version valid to DATS 8 0 VERSBI
KNZVV Version category, assortment list CHAR 1 0 KNZVV
A Manual request
M Merged version
U Change version
X Full version
VKORG Sales Organization CHAR 4 0 TVKO VKORG
VTWEG Distribution Channel CHAR 2 0 TVTW VTWEG
VNRLV Version no. of last full version NUMC 4 0 VNRLV
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
VERVER Assortment list version sent on DATS 8 0 VERVER
NAME1 Name CHAR 30 0 NAME1
NAME2 Name 2 CHAR 30 0 NAME2
STRAS Street and House Number CHAR 30 0 STRAS
PFACH PO Box CHAR 10 0 PFACH
PSTL2 P.O. Box Postal Code CHAR 10 0 PSTL2
PSTLZ Postal Code CHAR 10 0 PSTLZ
ORT01 City CHAR 25 0 ORT01
SPRAS Language Key LANG 1 0 T002 SPRAS
BBTEXT Description of assortment list type CHAR 20 0 BBTEXT
DLDNR POS Outbound Log NUMC 14 0 WDLS DLDNR
GESST IDoc creation status CHAR 1 0 GESST
E Errors exist
H Notes exist
I Terminated
W Warning messages exist
X Error-free
BBSTR Structure of assortment list data line CHAR 30 0 * BBSTR
LABPR Processing ID, shelf-edge labeling CHAR 1 0 LABPR
No items flagged for shelf-edge labeling
A Items have been checked and selected
X Items have already been processed
PLTYP Price List Type CHAR 2 0 T189 PLTYP
ERZZT Time created TIMS 6 0 ERZZT
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)

WBBH foreign key relationships

Table Field Check Table Check Field
0 WBBH BBTYP TWBB Assortment list type MANDT
1 WBBH DLDNR WDLS POS outbound log: Status of data preparation MANDT
0 WBBH LOCNR KNA1 General Data in Customer Master MANDT
0 WBBH LOCNR KNA1 General Data in Customer Master KUNNR
1 WBBH MANDT T000 Clients MANDT
0 WBBH PLTYP T189 Conditions: Price List Types MANDT
0 WBBH PLTYP T189 Conditions: Price List Types PLTYP
1 WBBH SPRAS T002 Language Keys (Component BC-I18) SPRAS
0 WBBH VKORG TVKO Organizational Unit: Sales Organizations MANDT
0 WBBH VKORG TVKO Organizational Unit: Sales Organizations VKORG
1 WBBH VTWEG TVTW Organizational Unit: Distribution Channels MANDT
1 WBBH VTWEG TVTW Organizational Unit: Distribution Channels VTWEG