SAP ABAP Table PLNSETTYPE_MV (Products Attribute for Planogram PPR)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-MSA-ACT (Application Component) Activity
⤷ CRMXIF_PLANOGRAM (Package) XIF Interface for Planogram Data
⤷ CRM-MSA-ACT (Application Component) Activity
⤷ CRMXIF_PLANOGRAM (Package) XIF Interface for Planogram Data
Basic Data
Table Category | INTTAB | Structure |
Structure | PLNSETTYPE_MV | Table Relationship Diagram |
Short Description | Products Attribute for Planogram PPR |
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 | BREIT | ACT_BREIT | ACT_BREIT | QUAN | 13 | 0 | Width of the Product or of the Packaging | ||
2 | BREIT_U | ACT_BREIT_U | MEINS | UNIT | 3 | 0 | Width of the Product or of the Packaging | T006 | |
3 | BRGEW | ACT_BRGEW | ACT_BRGEW | QUAN | 15 | 3 | Gross Weight | ||
4 | BRGEW_U | ACT_BRGEW_U | MEINS | UNIT | 3 | 0 | Gross Weight | T006 | |
5 | VOLUM | ACT_VOLUM | ACT_VOLUM | QUAN | 15 | 0 | Volume | ||
6 | VOLUM_U | ACT_VOLUM_U | MEINS | UNIT | 3 | 0 | Volume | T006 | |
7 | VOLEH | ACT_VOLEH | MEINS | UNIT | 3 | 0 | Unit for the Volume | T006 | |
8 | NROFSAM | ACT_NROFSAM | ACT_NROFSAM | QUAN | 4 | 0 | Number of samples | ||
9 | NROFSAM_U | ACT_NROFSAM_U | MEINS | UNIT | 3 | 0 | Number of samples | T006 | |
10 | STATUS | ACT_PRDS_STATUS | ACT_PRDS_STATUS | CHAR | 3 | 0 | Status of documented product | ||
11 | SAMTOBESENT | ACT_SAMTOBESENT | ACT_SAMTOBESENT | CHAR | 1 | 0 | Product Request | ||
12 | SAMRETURN | ACT_SAMRETURN | ACT_SAMRETURN | CHAR | 1 | 0 | Flag for Returns | ||
13 | DISCUSS | ACT_DISCUSS | ACT_DISCUSS | CHAR | 1 | 0 | Discussed | ||
14 | HOEHE | ACT_HOEHE | ACT_HOEHE | QUAN | 13 | 0 | Height of the Product or of the Packaging | ||
15 | HOEHE_U | ACT_HOEHE_U | MEINS | UNIT | 3 | 0 | Height of the Product or of the Packagin | T006 | |
16 | PRAVA | ACT_PRAVA | CRM_ACT_PROD_AVAILABLE_AFTER | CHAR | 3 | 0 | Product available after visit at checkou | * | |
17 | PRAVB | ACT_PRAVB | CRM_ACT_PROD_AVAILABLE_BEFORE | CHAR | 3 | 0 | Product available before Visit at check | * | |
18 | RESREAS | ACT_RESREAS | CRM_ACT_KVRESF | CHAR | 1 | 0 | Result Reason | * | |
19 | STOCK | ACT_KV_STOCK | ACT_KV_STOCK | DEC | 6 | 0 | Number of Products in stocks | ||
20 | ACT_RESULT | ACT_KV_RESULT | CRM_ACT_KVRESF | CHAR | 1 | 0 | Result | * | |
21 | PANZ | ACT_KV_ZPANZ | ACT_KV_ZPANZ | DEC | 3 | 0 | Number of Second placements | ||
22 | PAVA | ACT_KV_ZPAVA | CRM_ACT_SDPMT | CHAR | 1 | 0 | Second Placement Available | * | |
23 | NRPSHF | ACT_NRPSHF | ACT_NRPSHF | DEC | 6 | 0 | Number of Products on Promotion Shelf | ||
24 | POSVER | ACT_POSVER | CRM_ACT_VERTICAL_POS_IN_SHELF | CHAR | 3 | 0 | vertical position in shelf | * | |
25 | POSHOR | ACT_POSHOR | CRM_ACT_HORIZONT_POS_IN_SHELF | CHAR | 3 | 0 | horizontal position in shelf | * | |
26 | NROFFAC | ACT_NROFFAC | ACT_NROFFAC | DEC | 4 | 0 | Number of facings | ||
27 | FACLEN | ACT_FACLEN | ACT_FACLEN | DEC | 6 | 0 | Length of Facing | ||
28 | FACWID | ACT_FACWID | ACT_FACWID | DEC | 6 | 0 | Width of Facing | ||
29 | FACDEP | ACT_FACDEP | ACT_FACDEP | DEC | 6 | 2 | Depth of Facing | ||
30 | ACT_FACUNIT | ACT_FACUNIT | MEINS | UNIT | 3 | 0 | Units of Measure for the Product | T006 | |
31 | ACT_SPRICE | ACT_SPRICE | ACT_SPRICE | CURR | 23 | 2 | Sales Price in store | ||
32 | ACT_SPRICE_C | ACT_SPRICE_C | WAERS | CUKY | 5 | 0 | Sales Price in store | TCURC | |
33 | ACT_OPRICE | ACT_OPRICE | ACT_OPRICE | CURR | 23 | 2 | Order Price in store | ||
34 | ACT_OPRICE_C | ACT_OPRICE_C | WAERS | CUKY | 5 | 0 | Order Price in store | TCURC | |
35 | ACT_APRICE | ACT_APRICE | ACT_APRICE | CURR | 23 | 2 | Promotion Price in Store | ||
36 | ACT_APRICE_C | ACT_APRICE_C | WAERS | CUKY | 5 | 0 | Promotion Price in Store | TCURC | |
37 | ACT_LBVAL | ACT_LBVAL | ACT_LBVAL | DEC | 15 | 2 | Value of Samples | ||
38 | SPTSK | SPTSK | SPTSK | DEC | 8 | 3 | Special task centre Sht | ||
39 | LISTING_FEE | LISTING_FEE | LISTING_FEE | CURR | 12 | 2 | Listing Fee | ||
40 | LISTING_FEE_C | LISTING_FEE_C | WAERS | CUKY | 5 | 0 | Listing Fee | TCURC | |
41 | EDAY_LOW_PRICE | ACT_EDAY_LOW_PRICE | ACT_EDAY_LOW_PRICE | CURR | 12 | 2 | Everyday Low Price | ||
42 | EDAY_LOW_PRICE_C | ACT_EDAY_LOW_PRICE_C | WAERS | CUKY | 5 | 0 | Everyday Low Price | TCURC | |
43 | SENDSTA | ACT_SENDSTA | ACT_SENDSTA | CHAR | 1 | 0 | Send Status | ||
44 | BATCH_ID | ACT_BATCH_ID | ACT_BATCH_ID | CHAR | 10 | 0 | Batch ID | ||
45 | PRDHA | ACT_PRDHA | ACT_PRDHA | CHAR | 20 | 0 | Product hierarchy |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | PLNSETTYPE_MV | ACT_APRICE_C | TCURC | WAERS | |||
2 | PLNSETTYPE_MV | ACT_FACUNIT | T006 | MSEHI | |||
3 | PLNSETTYPE_MV | ACT_OPRICE_C | TCURC | WAERS | |||
4 | PLNSETTYPE_MV | ACT_SPRICE_C | TCURC | WAERS | |||
5 | PLNSETTYPE_MV | BREIT_U | T006 | MSEHI | |||
6 | PLNSETTYPE_MV | BRGEW_U | T006 | MSEHI | |||
7 | PLNSETTYPE_MV | EDAY_LOW_PRICE_C | TCURC | WAERS | |||
8 | PLNSETTYPE_MV | HOEHE_U | T006 | MSEHI | |||
9 | PLNSETTYPE_MV | LISTING_FEE_C | TCURC | WAERS | |||
10 | PLNSETTYPE_MV | NROFSAM_U | T006 | MSEHI | |||
11 | PLNSETTYPE_MV | VOLEH | T006 | MSEHI | |||
12 | PLNSETTYPE_MV | VOLUM_U | T006 | MSEHI |
History
Last changed by/on | SAP | 20050311 |
SAP Release Created in | 500 |