SAP WBBH Assortment list header Table
Overview
WBBH is a standard SAP S/4HANA table that stores Assortment list header data. There are total 29 fields in the WBBH table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WBBH belongs to Assortment List (LO-RFM-IFC-AL) module and is located in the package IS-R: Assortment List (WBBC).
In addition, following links provide an overview of foreign key relationships, if any, that link WBBH to other SAP tables and standard CDS views available based on WBBH table in S/4HANA 2020.
Techincal Settings of WBBH
Below are technical details of the table WBBH
- Buffering switched on
- Single entries of table were buffered
- Storage type is Column Store
List of WBBH Fields
The following table gives you an overview of the fields available in WBBH
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| LOCNR | Customer Number for Plant | LOCNR | KNA1 | CHAR | 10 |
| BBTYP | Assortment List Type | BBTYP | TWBB | CHAR | 1 |
| VERSNR | Assortment list version no. | BBVERSNR | NUMC | 6 | |
| VERSAB | Assortment list version valid from | VERSAB | DATS | 8 | |
| VERSBI | Assortment list version valid to | VERSBI | DATS | 8 | |
| KNZVV | Version category assortment list | KNZVV | CHAR | 1 | |
| VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 |
| VTWEG | Distribution Channel | VTWEG | TVTW | CHAR | 2 |
| VNRLV | Version no. of last full version | VNRLV | NUMC | 4 | |
| ERDAT | Date on which the record was created | ERDAT | DATS | 8 | |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | |
| VERVER | Assortment list version sent on | VERVER | DATS | 8 | |
| NAME1 | Name | NAME1 | CHAR | 30 | |
| NAME2 | Name 2 | NAME2 | CHAR | 30 | |
| STRAS | Street and House Number | STRAS | CHAR | 30 | |
| PFACH | PO Box | PFACH | CHAR | 10 | |
| PSTL2 | P.O. Box Postal Code | PSTL2 | CHAR | 10 | |
| PSTLZ | Postal Code | PSTLZ | CHAR | 10 | |
| ORT01 | City | ORT01 | CHAR | 25 | |
| SPRAS | Language Key | SPRAS | T002 | LANG | 1 |
| BBTEXT | Description of assortment list type | BBTEXT | CHAR | 20 | |
| DLDNR | POS Outbound Log | DLDNR | WDLS | NUMC | 14 |
| GESST | IDoc creation status | GESST | CHAR | 1 | |
| BBSTR | Structure of assortment list data line | BBSTR | * | CHAR | 30 |
| LABPR | Processing ID shelf-edge labeling | LABPR | CHAR | 1 | |
| PLTYP | Price List Type | PLTYP | T189 | CHAR | 2 |
| ERZZT | Time created | ERZZT | TIMS | 6 | |
| BSORT | Sorting Procedure in Assortment List | BSORT | CHAR | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for WBBH
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WBBH | BBTYP | 1: CN | TWBB |
| WBBH | DLDNR | 1: CN | WDLS |
| WBBH | LOCNR | 1: CN | KNA1 |
| WBBH | MANDT | 1: CN | T000 |
| WBBH | PLTYP | 1: CN | T189 |
| WBBH | SPRAS | 1: CN | T002 |
| WBBH | VKORG | 1: CN | TVKO |
| WBBH | VTWEG | 1: CN | TVTW |