SAP ABAP Table PRP_PLNSETTYPE_01P_ALV (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 | PRP_PLNSETTYPE_01P_ALV | 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 | .INCLUDE | 0 | 0 | Products Attribute for Planogram PPR | |||||
2 | OBJECT_KEY | COMT_BSP_OBJECTKEY | CHAR | 100 | 0 | Object Key | |||
3 | .INCLUDE | 0 | 0 | PPR Product References, Products: Detail UI | |||||
4 | .INCLUDE | 0 | 0 | Administration fields for the PPR interaction layer | |||||
5 | GUID | CRMT_PRP_GUID | SYSUUID | RAW | 16 | 0 | Internal, Unique Identifier for PPR Objects | ||
6 | HANDLE | CRMT_PRP_HANDLE | NUMC | 10 | 0 | Handle | |||
7 | ITEM_NO | CRMT_PRP_PROD_NO | NUMC10 | NUMC | 10 | 0 | Number for Arranging PPR Products Within the same Item | ||
8 | PROCESSING_MODE | CRMT_MODE | CRM_MODE | CHAR | 1 | 0 | Processing Mode of Transaction | ||
9 | TYPE | CRMT_PRP_REFERENCE_TYPE | CRM_PRP_REFERENCE_TYPE | CHAR | 2 | 0 | Reference Type of the PPR | * | |
10 | PRODUCT_TYPE | COMT_PRODUCT_TYPE | COM_PRODUCT_TYPE | CHAR | 2 | 0 | Product Type | COMC_PR_TYPE | |
11 | PRODUCT_TYPE_TEXT | COMT_PR_TYPE_DESC | TEXT40 | CHAR | 40 | 0 | Product Type Description | ||
12 | PRODUCT_GUID | COMT_PRODUCT_GUID | SYSUUID | RAW | 16 | 0 | Internal Unique ID of Product | ||
13 | PRODUCT_ID | COMT_ALTID_VALUE_UI | COM_ALTID_VALUE_SHORT | CHAR | 54 | 0 | Value of a Product ID or Individual Object | ||
14 | PRODUCT_ID_TYPE | COMT_ALTID_TYPE | CHAR16 | CHAR | 16 | 0 | ID Type for Alternative IDs | ||
15 | PRODUCT_ID_TYPE_TEXT | COMT_ALTID_TYPE_TEXT | COMT_TXT40 | CHAR | 40 | 0 | Description of Alternative ID Type | ||
16 | ID_TYPE_PROFILE | COMT_ALTID_PROFILE | COMT_ALTID_PROFILE | CHAR | 30 | 0 | Profile for Alternative IDs | ||
17 | CONFIG | COMT_PRODUCT_CONFIGURABLE | COM_PRODUCT_CONFIGURABLE | CHAR | 1 | 0 | Determines Whether a Product Is Configurable | * | |
18 | SHORT_TEXT | COMT_PRSHTEXTX | PRSHTEXT40 | CHAR | 40 | 0 | Product Description | ||
19 | LOGSYS | COMT_LOGSYS | LOGSYS | CHAR | 10 | 0 | Original System | * | |
20 | .INCLUDE | 0 | 0 | Listing Validity Period on Item Level | |||||
21 | LISTED_FROM | CRMT_PRP_DATE_VALID_FROM | DATE | DATS | 8 | 0 | Start Date of Validity Period | ||
22 | LISTED_TO | CRMT_PRP_DATE_VALID_TO | DATE | DATS | 8 | 0 | End Date of Validity Period | ||
23 | .INCLUDE | 0 | 0 | Fields for Dynamic Navigation Targets in the PC-UI | |||||
24 | CRM_OBJECT_TYPE | CRMT_PRT_OTYPE | CRMT_PRT_OTYPE | CHAR | 20 | 0 | Object Type for Navigation | * | |
25 | CRM_NAV_METHOD | CRMT_PRT_MTD | CRMT_PRT_MTD | CHAR | 20 | 0 | Method for Navigation | * | |
26 | NAV_OBJECT_KEY | CRMT_BSP_OBJECTKEY | CHAR | 100 | 0 | Object Key | |||
27 | .INCLUDE | 0 | 0 | Products Attribute for Planogram PPR | |||||
28 | BREIT | ACT_BREIT | ACT_BREIT | QUAN | 13 | 0 | Width of the Product or of the Packaging | ||
29 | BREIT_U | ACT_BREIT_U | MEINS | UNIT | 3 | 0 | Width of the Product or of the Packaging | * | |
30 | BREIT_DESC | COMT_ATTR_VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Description of Single Value | ||
31 | BRGEW | ACT_BRGEW | ACT_BRGEW | QUAN | 15 | 3 | Gross Weight | ||
32 | BRGEW_U | ACT_BRGEW_U | MEINS | UNIT | 3 | 0 | Gross Weight | * | |
33 | BRGEW_DESC | COMT_ATTR_VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Description of Single Value | ||
34 | VOLUM | ACT_VOLUM | ACT_VOLUM | QUAN | 15 | 0 | Volume | ||
35 | VOLUM_U | ACT_VOLUM_U | MEINS | UNIT | 3 | 0 | Volume | * | |
36 | VOLUM_DESC | COMT_ATTR_VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Description of Single Value | ||
37 | VOLEH | ACT_VOLEH | MEINS | UNIT | 3 | 0 | Unit for the Volume | * | |
38 | VOLEH_DESC | COMT_ATTR_VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Description of Single Value | ||
39 | NROFSAM | ACT_NROFSAM | ACT_NROFSAM | QUAN | 4 | 0 | Number of samples | ||
40 | NROFSAM_U | ACT_NROFSAM_U | MEINS | UNIT | 3 | 0 | Number of samples | * | |
41 | NROFSAM_DESC | COMT_ATTR_VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Description of Single Value | ||
42 | STATUS | ACT_PRDS_STATUS | ACT_PRDS_STATUS | CHAR | 3 | 0 | Status of documented product | ||
43 | STATUS_DESC | COMT_ATTR_VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Description of Single Value | ||
44 | SAMTOBESENT | ACT_SAMTOBESENT | ACT_SAMTOBESENT | CHAR | 1 | 0 | Product Request | ||
45 | SAMTOBESENT_DESC | COMT_ATTR_VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Description of Single Value | ||
46 | SAMRETURN | ACT_SAMRETURN | ACT_SAMRETURN | CHAR | 1 | 0 | Flag for Returns | ||
47 | SAMRETURN_DESC | COMT_ATTR_VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Description of Single Value | ||
48 | DISCUSS | ACT_DISCUSS | ACT_DISCUSS | CHAR | 1 | 0 | Discussed | ||
49 | DISCUSS_DESC | COMT_ATTR_VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Description of Single Value | ||
50 | HOEHE | ACT_HOEHE | ACT_HOEHE | QUAN | 13 | 0 | Height of the Product or of the Packaging | ||
51 | HOEHE_U | ACT_HOEHE_U | MEINS | UNIT | 3 | 0 | Height of the Product or of the Packagin | * | |
52 | HOEHE_DESC | COMT_ATTR_VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Description of Single Value | ||
53 | PRAVA | ACT_PRAVA | CRM_ACT_PROD_AVAILABLE_AFTER | CHAR | 3 | 0 | Product available after visit at checkou | * | |
54 | PRAVA_DESC | COMT_ATTR_VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Description of Single Value | ||
55 | PRAVB | ACT_PRAVB | CRM_ACT_PROD_AVAILABLE_BEFORE | CHAR | 3 | 0 | Product available before Visit at check | * | |
56 | PRAVB_DESC | COMT_ATTR_VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Description of Single Value | ||
57 | RESREAS | ACT_RESREAS | CRM_ACT_KVRESF | CHAR | 1 | 0 | Result Reason | * | |
58 | RESREAS_DESC | COMT_ATTR_VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Description of Single Value | ||
59 | STOCK | ACT_KV_STOCK | ACT_KV_STOCK | DEC | 6 | 0 | Number of Products in stocks | ||
60 | STOCK_DESC | COMT_ATTR_VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Description of Single Value | ||
61 | ACT_RESULT | ACT_KV_RESULT | CRM_ACT_KVRESF | CHAR | 1 | 0 | Result | * | |
62 | ACT_RESULT_DESC | COMT_ATTR_VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Description of Single Value | ||
63 | PANZ | ACT_KV_ZPANZ | ACT_KV_ZPANZ | DEC | 3 | 0 | Number of Second placements | ||
64 | PANZ_DESC | COMT_ATTR_VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Description of Single Value | ||
65 | PAVA | ACT_KV_ZPAVA | CRM_ACT_SDPMT | CHAR | 1 | 0 | Second Placement Available | * | |
66 | PAVA_DESC | COMT_ATTR_VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Description of Single Value | ||
67 | NRPSHF | ACT_NRPSHF | ACT_NRPSHF | DEC | 6 | 0 | Number of Products on Promotion Shelf | ||
68 | NRPSHF_DESC | COMT_ATTR_VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Description of Single Value | ||
69 | POSVER | ACT_POSVER | CRM_ACT_VERTICAL_POS_IN_SHELF | CHAR | 3 | 0 | vertical position in shelf | * | |
70 | POSVER_DESC | COMT_ATTR_VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Description of Single Value | ||
71 | POSHOR | ACT_POSHOR | CRM_ACT_HORIZONT_POS_IN_SHELF | CHAR | 3 | 0 | horizontal position in shelf | * | |
72 | POSHOR_DESC | COMT_ATTR_VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Description of Single Value | ||
73 | NROFFAC | ACT_NROFFAC | ACT_NROFFAC | DEC | 4 | 0 | Number of facings | ||
74 | NROFFAC_DESC | COMT_ATTR_VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Description of Single Value | ||
75 | FACLEN | ACT_FACLEN | ACT_FACLEN | DEC | 6 | 0 | Length of Facing | ||
76 | FACLEN_DESC | COMT_ATTR_VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Description of Single Value | ||
77 | FACWID | ACT_FACWID | ACT_FACWID | DEC | 6 | 0 | Width of Facing | ||
78 | FACWID_DESC | COMT_ATTR_VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Description of Single Value | ||
79 | FACDEP | ACT_FACDEP | ACT_FACDEP | DEC | 6 | 2 | Depth of Facing | ||
80 | FACDEP_DESC | COMT_ATTR_VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Description of Single Value | ||
81 | ACT_FACUNIT | ACT_FACUNIT | MEINS | UNIT | 3 | 0 | Units of Measure for the Product | * | |
82 | ACT_FACUNIT_DESC | COMT_ATTR_VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Description of Single Value | ||
83 | ACT_SPRICE | ACT_SPRICE | ACT_SPRICE | CURR | 23 | 2 | Sales Price in store | ||
84 | ACT_SPRICE_C | ACT_SPRICE_C | WAERS | CUKY | 5 | 0 | Sales Price in store | * | |
85 | ACT_SPRICE_DESC | COMT_ATTR_VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Description of Single Value | ||
86 | ACT_OPRICE | ACT_OPRICE | ACT_OPRICE | CURR | 23 | 2 | Order Price in store | ||
87 | ACT_OPRICE_C | ACT_OPRICE_C | WAERS | CUKY | 5 | 0 | Order Price in store | * | |
88 | ACT_OPRICE_DESC | COMT_ATTR_VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Description of Single Value | ||
89 | ACT_APRICE | ACT_APRICE | ACT_APRICE | CURR | 23 | 2 | Promotion Price in Store | ||
90 | ACT_APRICE_C | ACT_APRICE_C | WAERS | CUKY | 5 | 0 | Promotion Price in Store | * | |
91 | ACT_APRICE_DESC | COMT_ATTR_VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Description of Single Value | ||
92 | ACT_LBVAL | ACT_LBVAL | ACT_LBVAL | DEC | 15 | 2 | Value of Samples | ||
93 | ACT_LBVAL_DESC | COMT_ATTR_VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Description of Single Value | ||
94 | SPTSK | SPTSK | SPTSK | DEC | 8 | 3 | Special task centre Sht | ||
95 | SPTSK_DESC | COMT_ATTR_VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Description of Single Value | ||
96 | LISTING_FEE | LISTING_FEE | LISTING_FEE | CURR | 12 | 2 | Listing Fee | ||
97 | LISTING_FEE_C | LISTING_FEE_C | WAERS | CUKY | 5 | 0 | Listing Fee | * | |
98 | LISTING_FEE_DESC | COMT_ATTR_VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Description of Single Value | ||
99 | EDAY_LOW_PRICE | ACT_EDAY_LOW_PRICE | ACT_EDAY_LOW_PRICE | CURR | 12 | 2 | Everyday Low Price | ||
100 | EDAY_LOW_PRICE_C | ACT_EDAY_LOW_PRICE_C | WAERS | CUKY | 5 | 0 | Everyday Low Price | * | |
101 | EDAY_LOW_PRICE_DESC | COMT_ATTR_VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Description of Single Value | ||
102 | SENDSTA | ACT_SENDSTA | ACT_SENDSTA | CHAR | 1 | 0 | Send Status | ||
103 | SENDSTA_DESC | COMT_ATTR_VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Description of Single Value | ||
104 | BATCH_ID | ACT_BATCH_ID | ACT_BATCH_ID | CHAR | 10 | 0 | Batch ID | ||
105 | BATCH_ID_DESC | COMT_ATTR_VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Description of Single Value | ||
106 | PRDHA | ACT_PRDHA | ACT_PRDHA | CHAR | 20 | 0 | Product hierarchy | ||
107 | PRDHA_DESC | COMT_ATTR_VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Description of Single Value | ||
108 | .INCLUDE | 0 | 0 | ||||||
109 | CELL | LVC_T_STYL | TTYP | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | PRP_PLNSETTYPE_01P_ALV | PRODUCT_TYPE | COMC_PR_TYPE | PRODUCT_TYPE | KEY | 1 | 1 |
History
Last changed by/on | SAP | 20050627 |
SAP Release Created in | 500 |