SAP Table BAPISHELFHD
Header data for planogram
BAPISHELFHD (Header data for planogram) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link BAPISHELFHD to other SAP tables.
BAPISHELFHD table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| LAYOUT_MOD | Layout Module | LAYGR | TWML | CHAR | 10 | 0 | ||||||
| LAYMOD_DESC | Layout module description | LAYMOD_DESC | CHAR | 40 | 0 | |||||||
| CUSTOMER_SITE | Customer Number for Plant | LOCNR | KNA1 | CHAR | 10 | 0 | ||||||
| PLANT | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||||||
| LANGU | Language Key | SPRAS | T002 | LANG | 1 | 0 | ||||||
| LANGU_ISO | 2-Character SAP Language Code | LAISO | CHAR | 2 | 0 | |||||||
| SHELF_OPT_PROFILE | Space management profile | SSOPT_PRO | TWSSO | CHAR | 4 | 0 | ||||||
| PURCH_ORG | Purchasing Organization | EKORG | T024E | CHAR | 4 | 0 | ||||||
| SALESORG | Sales Organization | VKORG | TVKO | CHAR | 4 | 0 | ||||||
| DISTR_CHAN | Distribution Channel | VTWEG | TVTW | CHAR | 2 | 0 | ||||||
| LAYOUT | Layout | LAYVAR | TWGV | CHAR | 10 | 0 | ||||||
| LAY_DOC_PATH | Path for layout documents | LAYDOCPATH | CHAR | 140 | 0 | |||||||
| AREA | Layout area number | LAYPOSNR | TWGLV | NUMC | 10 | 0 | ||||||
| PRICE_DATE | Key date for price determination | PRICE_DATE | DATS | 8 | 0 | |||||||
| PERIOD_NUM | Number of periods for reading business volume data | PERIOD_NUM | NUMC | 2 | 0 | |||||||
| PERIOD_TYPE | Period category for reading business volume data | PERIOD_TYPE | CHAR | 6 | 0 | |||||||
| LAYMOD_VER | Layout Module Version | LAYMOD_VER | NUMC | 4 | 0 | |||||||
| LM_DATE_FR | Validity start date of a layout module version | LM_DATE_FR | DATS | 8 | 0 | |||||||
| LM_DATE_TO | Validity end date of a layout module version | LM_DATE_TO | DATS | 8 | 0 | |||||||
| LMOD_STAT | Status of a layout module version | LMOD_STAT | CHAR | 2 | 0 |
Possible values
|
||||||
| ASSORTMENT | Assortment | ASORT | CHAR | 10 | 0 | |||||||
| LAYMOD_VAR | Variant for Layout Module Version | LAYMOD_VAR | CHAR | 4 | 0 | |||||||
| DOCUMENT_NUMBER | Document number | DOKNR | CHAR | 25 | 0 | |||||||
BAPISHELFHD foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| BAPISHELFHD | AREA | SYST | MANDT | TWGLV | Layout Area | MANDT |
| BAPISHELFHD | AREA | BAPISHELFHD | LAYOUT | TWGLV | Layout Area | LAYVR |
| BAPISHELFHD | AREA | BAPISHELFHD | AREA | TWGLV | Layout Area | SORTF |
| BAPISHELFHD | CUSTOMER_SITE | SYST | MANDT | KNA1 | General Data in Customer Master | MANDT |
| BAPISHELFHD | CUSTOMER_SITE | BAPISHELFHD | CUSTOMER_SITE | KNA1 | General Data in Customer Master | KUNNR |
| BAPISHELFHD | DISTR_CHAN | BAPISHELFHD | DISTR_CHAN | TVTW | Organizational Unit: Distribution Channels | VTWEG |
| BAPISHELFHD | DISTR_CHAN | SYST | MANDT | TVTW | Organizational Unit: Distribution Channels | MANDT |
| BAPISHELFHD | LANGU | BAPISHELFHD | LANGU | T002 | Language Keys (Component BC-I18) | SPRAS |
| BAPISHELFHD | LAYOUT | BAPISHELFHD | LAYOUT | TWGV | Layout | LAYVR |
| BAPISHELFHD | LAYOUT | SYST | MANDT | TWGV | Layout | MANDT |
| BAPISHELFHD | LAYOUT_MOD | SYST | MANDT | TWML | Layout module | MANDT |
| BAPISHELFHD | LAYOUT_MOD | BAPISHELFHD | LAYOUT_MOD | TWML | Layout module | LAYGR |
| BAPISHELFHD | PLANT | SYST | MANDT | T001W | Plants/Branches | MANDT |
| BAPISHELFHD | PLANT | BAPISHELFHD | PLANT | T001W | Plants/Branches | WERKS |
| BAPISHELFHD | PURCH_ORG | SYST | MANDT | T024E | Purchasing Organizations | MANDT |
| BAPISHELFHD | PURCH_ORG | BAPISHELFHD | PURCH_ORG | T024E | Purchasing Organizations | EKORG |
| BAPISHELFHD | SALESORG | SYST | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
| BAPISHELFHD | SALESORG | BAPISHELFHD | SALESORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| BAPISHELFHD | SHELF_OPT_PROFILE | SYST | MANDT | TWSSO | Space management profile | MANDT |
| BAPISHELFHD | SHELF_OPT_PROFILE | BAPISHELFHD | SHELF_OPT_PROFILE | TWSSO | Space management profile | SSOPT_PRO |
