SAP ABAP Table BAPISHELFMAT (Material data for planogram)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-MD-PCT (Application Component) Product Catalog
⤷ WLAY (Package) Layout and Space Management
⤷ CRM-MD-PCT (Application Component) Product Catalog
⤷ WLAY (Package) Layout and Space Management
Basic Data
Table Category | INTTAB | Structure |
Structure | BAPISHELFMAT | Table Relationship Diagram |
Short Description | Material data for planogram |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MATERIAL | MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
2 | MATL_DESC | MAKTX | TEXT40 | CHAR | 40 | 0 | Material description | ||
3 | MULT_PLACE | MULT_PLACE | XFELD | CHAR | 1 | 0 | Indicates multiple placement | ||
4 | UNIT | MEINH | MEINS | UNIT | 3 | 0 | Unit of Measure for Display | T006 | |
5 | UNIT_ISO | ISOCD_UNIT | ISOCD_UNIT | CHAR | 3 | 0 | ISO code for unit of measurement | T006I | |
6 | EAN_UPC | EAN11 | EAN11 | CHAR | 18 | 0 | International Article Number (EAN/UPC) | ||
7 | MATL_CAT | ATTYP | ATTYP | CHAR | 2 | 0 | Material Category | ||
8 | MATL_GROUP | MATKL | MATKL | CHAR | 9 | 0 | Material Group | T023 | |
9 | HEIGHT | HOEHE | MENG13 | QUAN | 13 | 3 | Height | ||
10 | WIDTH | BREIT | MENG13 | QUAN | 13 | 3 | Width | ||
11 | LENGTH | LAENG | MENG13 | QUAN | 13 | 3 | Length | ||
12 | UNIT_DIM | MEABM | MEINS | UNIT | 3 | 0 | Unit of Dimension for Length/Width/Height | T006 | |
13 | UNIT_DIM_ISO | MEABM_ISO | ISOCD_UNIT | CHAR | 3 | 0 | Unit for length/breadth/height in ISO code | T006I | |
14 | SORT_SEQ | SORF1 | NUMC10 | NUMC | 10 | 0 | Sort sequence number in layout module | ||
15 | SHELF_BOARD_NUMBER | SHELF_NO | NUMC10 | NUMC | 10 | 0 | Shelf Section | ||
16 | FACING | FACING | MENG13 | QUAN | 13 | 3 | Number of materials placed next to one another | ||
17 | QUANTITIES | MCW_BSTMNG | MENGV15_3 | QUAN | 15 | 3 | Stock quantity in base unit of measure | ||
18 | SALES | MCW_UMSMNG | MENGV15_3 | QUAN | 15 | 3 | Sales quantity in base unit of measure | ||
19 | MOVEMENT | MCW_UMSGVP | WERTV10 | CURR | 19 | 2 | Sales at retail with tax | ||
20 | NET_NET_PURCHASE_PRICE | BAPI_NET_NET_PURCHASE_PRICE | BAPICURR | DEC | 23 | 4 | Purchase price (net/net) | ||
21 | PRICING_CURRENCY | KAWAER | WAERS | CUKY | 5 | 0 | Sales Pricing: Pricing Currency | TCURC | |
22 | PRICING_CURRENCY_ISO | ISOCD | ISOCD | CHAR | 3 | 0 | ISO currency code | ||
23 | CURRENT_SALES_PRICE | BAPI_CURRENT_SALES_PRICE | BAPICURR | DEC | 23 | 4 | Current Final Price | ||
24 | SALES_CURRENCY | VWAER | WAERS | CUKY | 5 | 0 | Sales currency | TCURC | |
25 | SALES_CURRENCY_ISO | ISOCD | ISOCD | CHAR | 3 | 0 | ISO currency code | ||
26 | SALES_P_UNIT | VRKPE | DEC5 | DEC | 5 | 0 | Sales price unit | ||
27 | SALES_UNIT | VRKME | MEINS | UNIT | 3 | 0 | Sales unit | T006 | |
28 | SALES_UNIT_ISO | VRKME_ISO | ISOCD_UNIT | CHAR | 3 | 0 | Sales unit in ISO code | T006I | |
29 | VENDOR | ELIFN | LIFNR | CHAR | 10 | 0 | Vendor's account number | LFA1 | |
30 | PRE_VENDOR | KOLIF | LIFNR | CHAR | 10 | 0 | Prior Vendor | LFA1 | |
31 | CONF_MATL | SATNR | MATNR | CHAR | 18 | 0 | Cross-Plant Configurable Material | MARA | |
32 | MULT_COUNT | MULT_COUNT | UMBSZ | DEC | 5 | 0 | No. of placements for materials with multiple placements | ||
33 | FRONT | FACING_VERT | MENG13 | QUAN | 13 | 3 | Number of materials positioned over one another | ||
34 | SHELF_QUANTITY_MAX | SHF_QNT_MAX | MENG13 | QUAN | 13 | 3 | Maximum shelf quantity | ||
35 | SHELF_QUANTITY_OPT | SHF_QNT_OPT | MENG13 | QUAN | 13 | 3 | Optimum shelf quantity | ||
36 | PRES_QNT | PRES_QNT | MENG13 | QUAN | 13 | 3 | Presentation quantity | ||
37 | LAYMOD_NUM | LAYMOD_NUM | NUMC6 | NUMC | 6 | 0 | Sequence number in the layout module | ||
38 | LAYMOD_VAR | LAYMOD_VAR | LAYMOD_VAR | CHAR | 4 | 0 | Variant for Layout Module Version | * | |
39 | EXCLUSION | EX_FLAG | EX_FLAG | CHAR | 1 | 0 | Exclusion Flag | ||
40 | CONF_MATL_EXTERNAL | MGV_CONF_MATL_EXTERNAL | MATNR_EXT | CHAR | 40 | 0 | Long Material Number for CONF_MATL field | ||
41 | CONF_MATL_GUID | MGV_CONF_MATL_GUID | MATNR_EGUID | CHAR | 32 | 0 | External GUID for CONF_MATL Field | ||
42 | CONF_MATL_VERSION | MGV_CONF_MATL_VERSION | MATNR_VERS | CHAR | 10 | 0 | Version Number for Field CONF_MATL | ||
43 | MATERIAL_EXTERNAL | MGV_MATERIAL_EXTERNAL | MATNR_EXT | CHAR | 40 | 0 | Long Material Number for MATERIAL Field | ||
44 | MATERIAL_GUID | MGV_MATERIAL_GUID | MATNR_EGUID | CHAR | 32 | 0 | External GUID for MATERIAL Field | ||
45 | MATERIAL_VERSION | MGV_MATERIAL_VERSION | MATNR_VERS | CHAR | 10 | 0 | Version Number for MATERIAL Field |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | BAPISHELFMAT | CONF_MATL | MARA | MATNR | KEY | 1 | CN |
2 | BAPISHELFMAT | MATERIAL | MARA | MATNR | KEY | 1 | CN |
3 | BAPISHELFMAT | MATL_GROUP | T023 | MATKL | KEY | 1 | CN |
4 | BAPISHELFMAT | PRE_VENDOR | LFA1 | LIFNR | KEY | 1 | CN |
5 | BAPISHELFMAT | PRICING_CURRENCY | TCURC | WAERS | KEY | 1 | CN |
6 | BAPISHELFMAT | SALES_CURRENCY | TCURC | WAERS | KEY | 1 | CN |
7 | BAPISHELFMAT | SALES_UNIT | T006 | MSEHI | KEY | 1 | CN |
8 | BAPISHELFMAT | SALES_UNIT_ISO | T006I | ISOCODE | KEY | 1 | CN |
9 | BAPISHELFMAT | UNIT | T006 | MSEHI | KEY | 1 | CN |
10 | BAPISHELFMAT | UNIT_DIM | T006 | MSEHI | KEY | 1 | CN |
11 | BAPISHELFMAT | UNIT_DIM_ISO | T006I | ISOCODE | KEY | 1 | CN |
12 | BAPISHELFMAT | UNIT_ISO | T006I | ISOCODE | KEY | 1 | CN |
13 | BAPISHELFMAT | VENDOR | LFA1 | LIFNR | KEY | 1 | CN |
History
Last changed by/on | SAP | 20100310 |
SAP Release Created in |