SAP ABAP Table SRS_PDC_SO_DISPDATA_ITEM (Retail Store Store Order: MRP Data)
Hierarchy
☛
EA-RETAIL (Software Component) SAP Enterprise Extension Retail
⤷ LO-SRS (Application Component) SAP Retail Store
⤷ WOST (Package) SAP Retail Store: Internet Application Components
⤷ LO-SRS (Application Component) SAP Retail Store
⤷ WOST (Package) SAP Retail Store: Internet Application Components
Basic Data
Table Category | INTTAB | Structure |
Structure | SRS_PDC_SO_DISPDATA_ITEM | Table Relationship Diagram |
Short Description | Retail Store Store Order: MRP Data |
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 | GROUP_HEADER | WSAO_DISP_GROUP_NAME | CHAR | 40 | 0 | Name (Heading) for Customer-Specific Material Group | |||
2 | PROPOSAL_QNT | SRS_PDC_PROPOSAL | MENG13 | QUAN | 13 | 3 | Quantity proposal | ||
3 | STOCK | SRS_PDC_STOCK | MENG13 | QUAN | 13 | 3 | Current Stock | ||
4 | RECEIPTS | SRS_PDC_RECEIPTS | MENG13 | QUAN | 13 | 3 | Expected Goods Receipt Quantity | ||
5 | .INCLUDE | 0 | 0 | Item structure for assortment list business object | |||||
6 | GROUP_NO | BBGNO | AL_GROUP_NO | NUMC | 10 | 0 | Assortment list group no. | WBBL | |
7 | POSITION_NO | BBRNO | BBRNO | INT4 | 10 | 0 | Sequence number of item in assortment list | WBBP | |
8 | MATERIAL | MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
9 | EAN_UPC | EAN11 | EAN11 | CHAR | 18 | 0 | International Article Number (EAN/UPC) | ||
10 | VEND_MAT | BB_LIFARTN | CHAR22 | CHAR | 22 | 0 | Material no. of vendor | ||
11 | TEXT_20 | BB_ARTTXT | TEXT20 | CHAR | 20 | 0 | Material text (abbrev. for the assortment list output) | ||
12 | TEXT_30 | BB_TXT30 | TEXT30 | CHAR | 30 | 0 | Material text, length 30 (reduced for AL output) | ||
13 | TEXT_40_UOM | BB_MAKTM | TEXT40 | CHAR | 40 | 0 | Material description, unit of measure | ||
14 | PO_UNIT | BSTME | MEINS | UNIT | 3 | 0 | Order unit | T006 | |
15 | PO_UNIT_ISO | ISOCD_BSTME | ISOCD_UNIT | CHAR | 3 | 0 | ISO code for order unit | T006I | |
16 | SALES_UNIT | VRKME | MEINS | UNIT | 3 | 0 | Sales unit | T006 | |
17 | SALES_UNIT_ISO | ISOCD_VRKME | ISOCD_UNIT | CHAR | 3 | 0 | ISO code for sales unit | T006I | |
18 | BASE_UOM | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
19 | BASE_UOM_ISO | ISOCD_UNIT | ISOCD_UNIT | CHAR | 3 | 0 | ISO code for unit of measurement | T006I | |
20 | FACTOR_UNIT_CON | BB_FACTR | CHAR6 | CHAR | 6 | 0 | Conversion factor for order Un to sales Un for astmt. list | ||
21 | SALES_PRICE_10 | BB_PRICE | CHAR10 | CHAR | 10 | 0 | Sales price for assortment list output (10 characters) | ||
22 | SALES_PRICE | BB_VKP | BAPICURR | DEC | 23 | 4 | Sales price for assortment list output via BAPI | ||
23 | PURCHASE_PRICE_10 | SL_EKPNN10 | CHAR10 | CHAR | 10 | 0 | Purchase Price for Assortment List Output (10 Characters) | ||
24 | PURCHASE_PRICE | BB_EKP | BAPICURR | DEC | 23 | 4 | Purchase price for assortment list output via BAPI | ||
25 | CURRENCY | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
26 | CURRENCY_ISO | ISOCD | ISOCD | CHAR | 3 | 0 | ISO currency code | ||
27 | MATERIAL_COMMENT | COMMNT | TEXT10 | CHAR | 10 | 0 | Comments on a material in the assortment list | ||
28 | CONF_MATL | SATNR | MATNR | CHAR | 18 | 0 | Cross-Plant Configurable Material | MARA | |
29 | MATL_CAT | ATTYP | ATTYP | CHAR | 2 | 0 | Material Category | ||
30 | MRP_TYPE | DISMM | DISMM | CHAR | 2 | 0 | MRP Type | T438A | |
31 | ORDER_FLAG | KNZBB | XFELD | CHAR | 1 | 0 | ID: replenishable | ||
32 | SAFETY_STK | EISBE | MENG13 | QUAN | 13 | 3 | Safety stock | ||
33 | REORDER_PT | MINBE | MENG13 | QUAN | 13 | 3 | Reorder point | ||
34 | MAX_STOCK | MABST | MENG13 | QUAN | 13 | 3 | Maximum stock level | ||
35 | FOLLOW_UP | NFMAT | MATNR | CHAR | 18 | 0 | Follow-up material | MARA | |
36 | EFF_O_DAY | BB_ERSAB | DATUM | DATS | 8 | 0 | Expir. date | ||
37 | MIN_PO_QTY | MINBM | MENG13 | QUAN | 13 | 3 | Minimum Purchase Order Quantity | ||
38 | PLND_DELRY | PLIFZ | DEC3 | DEC | 3 | 0 | Planned delivery time in days | ||
39 | SUPPL_FROM | BB_LIFAB | DATUM | DATS | 8 | 0 | Available for delivery from | ||
40 | SUPPL_TO | BB_LIFBI | DATUM | DATS | 8 | 0 | Available for delivery until | ||
41 | PROMOTION_DIST | BB_AKTION | XFELD | CHAR | 1 | 0 | Promotion indicator Y/N | ||
42 | PROMOTION_NO | WAKTION | WAKTION | CHAR | 10 | 0 | Promotion | WAKH | |
43 | PROMOTION_FROM | BB_AKTAB | DATUM | DATS | 8 | 0 | On sale, promotion from | ||
44 | PROMOTION_TO | BB_AKTBIS | DATUM | DATS | 8 | 0 | On sale, promotion to | ||
45 | EARLIEST_RP_DATE | BB_FBDAT | DATUM | DATS | 8 | 0 | Earliest order date with vendor | ||
46 | LATEST_RP_DATE | BB_A_SBDAT | DATUM | DATS | 8 | 0 | Latest order date with vendor | ||
47 | VALID_FROM | BB_GUELTAB | DATUM | DATS | 8 | 0 | Change valid from | ||
48 | CONF_MATL_EXTERNAL | MGV_CONF_MATL_EXTERNAL | MATNR_EXT | CHAR | 40 | 0 | Long Material Number for CONF_MATL field | ||
49 | CONF_MATL_GUID | MGV_CONF_MATL_GUID | MATNR_EGUID | CHAR | 32 | 0 | External GUID for CONF_MATL Field | ||
50 | CONF_MATL_VERSION | MGV_CONF_MATL_VERSION | MATNR_VERS | CHAR | 10 | 0 | Version Number for Field CONF_MATL | ||
51 | FOLLOW_UP_EXTERNAL | MGV_FOLLOW_UP_EXTERNAL | MATNR_EXT | CHAR | 40 | 0 | Long Material Number for field FOLLOW_UP | ||
52 | FOLLOW_UP_GUID | MGV_FOLLOW_UP_GUID | MATNR_EGUID | CHAR | 32 | 0 | External GUID for FOLLOW_UP Field | ||
53 | FOLLOW_UP_VERSION | MGV_FOLLOW_UP_VERSION | MATNR_VERS | CHAR | 10 | 0 | Version Number for FOLLOW_UP Field | ||
54 | MATERIAL_EXTERNAL | MGV_MATERIAL_EXTERNAL | MATNR_EXT | CHAR | 40 | 0 | Long Material Number for MATERIAL Field | ||
55 | MATERIAL_GUID | MGV_MATERIAL_GUID | MATNR_EGUID | CHAR | 32 | 0 | External GUID for MATERIAL Field | ||
56 | 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 | SRS_PDC_SO_DISPDATA_ITEM | BASE_UOM | T006 | MSEHI | KEY | 1 | CN |
2 | SRS_PDC_SO_DISPDATA_ITEM | BASE_UOM_ISO | T006I | ISOCODE | KEY | 1 | CN |
3 | SRS_PDC_SO_DISPDATA_ITEM | CONF_MATL | MARA | MATNR | KEY | 1 | CN |
4 | SRS_PDC_SO_DISPDATA_ITEM | CURRENCY | TCURC | WAERS | KEY | 1 | CN |
5 | SRS_PDC_SO_DISPDATA_ITEM | FOLLOW_UP | MARA | MATNR | KEY | 1 | CN |
6 | SRS_PDC_SO_DISPDATA_ITEM | GROUP_NO | WBBL | BBGNO | KEY | 1 | CN |
7 | SRS_PDC_SO_DISPDATA_ITEM | MATERIAL | MARA | MATNR | KEY | 1 | CN |
8 | SRS_PDC_SO_DISPDATA_ITEM | MRP_TYPE | T438A | DISMM | KEY | 1 | CN |
9 | SRS_PDC_SO_DISPDATA_ITEM | POSITION_NO | WBBP | BBRNO | KEY | 1 | CN |
10 | SRS_PDC_SO_DISPDATA_ITEM | PO_UNIT | T006 | MSEHI | KEY | 1 | CN |
11 | SRS_PDC_SO_DISPDATA_ITEM | PO_UNIT_ISO | T006I | ISOCODE | KEY | 1 | CN |
12 | SRS_PDC_SO_DISPDATA_ITEM | PROMOTION_NO | WAKH | AKTNR | KEY | 1 | CN |
13 | SRS_PDC_SO_DISPDATA_ITEM | SALES_UNIT | T006 | MSEHI | KEY | 1 | CN |
14 | SRS_PDC_SO_DISPDATA_ITEM | SALES_UNIT_ISO | T006I | ISOCODE | KEY | 1 | CN |
History
Last changed by/on | SAP | 20040114 |
SAP Release Created in | 110 |