SAP ABAP Table PRP_PLNSETTYPE_02P_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

Basic Data

Table Category	INTTAB	Structure
Structure	PRP_PLNSETTYPE_02P_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	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 Category
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	HIERARCHY_ID	COMT_HIERARCHY_ID	COM_HIERARCHY_ID	CHAR	10	0	Category Hierarchy ID
11	HIERARCHY_GUID	COMT_HIERARCHY_GUID	SYSUUID	RAW	16	0	Category Hierarchy GUID
12	HIERARCHY_TEXT	COMT_HIERARCHY_TEXT	TEXT40	CHAR	40	0	Category Hierarchy Description
13	CATEGORY_GUID	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
14	CATEGORY_ID	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
15	CATEGORY_TEXT	COMT_CATEGORY_TEXT	TEXT80	CHAR	80	0	Category Description
16	.INCLUDE				0	0	Listing Validity Period on Item Level
17	LISTED_FROM	CRMT_PRP_DATE_VALID_FROM	DATE	DATS	8	0	Start Date of Validity Period
18	LISTED_TO	CRMT_PRP_DATE_VALID_TO	DATE	DATS	8	0	End Date of Validity Period
19	.INCLUDE				0	0	Products Attribute for Planogram PPR
20	BREIT	ACT_BREIT	ACT_BREIT	QUAN	13	0	Width of the Product or of the Packaging
21	BREIT_U	ACT_BREIT_U	MEINS	UNIT	3	0	Width of the Product or of the Packaging	*
22	BREIT_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
23	BRGEW	ACT_BRGEW	ACT_BRGEW	QUAN	15	3	Gross Weight
24	BRGEW_U	ACT_BRGEW_U	MEINS	UNIT	3	0	Gross Weight	*
25	BRGEW_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
26	VOLUM	ACT_VOLUM	ACT_VOLUM	QUAN	15	0	Volume
27	VOLUM_U	ACT_VOLUM_U	MEINS	UNIT	3	0	Volume	*
28	VOLUM_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
29	VOLEH	ACT_VOLEH	MEINS	UNIT	3	0	Unit for the Volume	*
30	VOLEH_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
31	NROFSAM	ACT_NROFSAM	ACT_NROFSAM	QUAN	4	0	Number of samples
32	NROFSAM_U	ACT_NROFSAM_U	MEINS	UNIT	3	0	Number of samples	*
33	NROFSAM_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
34	STATUS	ACT_PRDS_STATUS	ACT_PRDS_STATUS	CHAR	3	0	Status of documented product
35	STATUS_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
36	SAMTOBESENT	ACT_SAMTOBESENT	ACT_SAMTOBESENT	CHAR	1	0	Product Request
37	SAMTOBESENT_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
38	SAMRETURN	ACT_SAMRETURN	ACT_SAMRETURN	CHAR	1	0	Flag for Returns
39	SAMRETURN_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
40	DISCUSS	ACT_DISCUSS	ACT_DISCUSS	CHAR	1	0	Discussed
41	DISCUSS_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
42	HOEHE	ACT_HOEHE	ACT_HOEHE	QUAN	13	0	Height of the Product or of the Packaging
43	HOEHE_U	ACT_HOEHE_U	MEINS	UNIT	3	0	Height of the Product or of the Packagin	*
44	HOEHE_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
45	PRAVA	ACT_PRAVA	CRM_ACT_PROD_AVAILABLE_AFTER	CHAR	3	0	Product available after visit at checkou	*
46	PRAVA_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
47	PRAVB	ACT_PRAVB	CRM_ACT_PROD_AVAILABLE_BEFORE	CHAR	3	0	Product available before Visit at check	*
48	PRAVB_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
49	RESREAS	ACT_RESREAS	CRM_ACT_KVRESF	CHAR	1	0	Result Reason	*
50	RESREAS_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
51	STOCK	ACT_KV_STOCK	ACT_KV_STOCK	DEC	6	0	Number of Products in stocks
52	STOCK_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
53	ACT_RESULT	ACT_KV_RESULT	CRM_ACT_KVRESF	CHAR	1	0	Result	*
54	ACT_RESULT_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
55	PANZ	ACT_KV_ZPANZ	ACT_KV_ZPANZ	DEC	3	0	Number of Second placements
56	PANZ_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
57	PAVA	ACT_KV_ZPAVA	CRM_ACT_SDPMT	CHAR	1	0	Second Placement Available	*
58	PAVA_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
59	NRPSHF	ACT_NRPSHF	ACT_NRPSHF	DEC	6	0	Number of Products on Promotion Shelf
60	NRPSHF_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
61	POSVER	ACT_POSVER	CRM_ACT_VERTICAL_POS_IN_SHELF	CHAR	3	0	vertical position in shelf	*
62	POSVER_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
63	POSHOR	ACT_POSHOR	CRM_ACT_HORIZONT_POS_IN_SHELF	CHAR	3	0	horizontal position in shelf	*
64	POSHOR_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
65	NROFFAC	ACT_NROFFAC	ACT_NROFFAC	DEC	4	0	Number of facings
66	NROFFAC_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
67	FACLEN	ACT_FACLEN	ACT_FACLEN	DEC	6	0	Length of Facing
68	FACLEN_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
69	FACWID	ACT_FACWID	ACT_FACWID	DEC	6	0	Width of Facing
70	FACWID_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
71	FACDEP	ACT_FACDEP	ACT_FACDEP	DEC	6	2	Depth of Facing
72	FACDEP_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
73	ACT_FACUNIT	ACT_FACUNIT	MEINS	UNIT	3	0	Units of Measure for the Product	*
74	ACT_FACUNIT_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
75	ACT_SPRICE	ACT_SPRICE	ACT_SPRICE	CURR	23	2	Sales Price in store
76	ACT_SPRICE_C	ACT_SPRICE_C	WAERS	CUKY	5	0	Sales Price in store	*
77	ACT_SPRICE_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
78	ACT_OPRICE	ACT_OPRICE	ACT_OPRICE	CURR	23	2	Order Price in store
79	ACT_OPRICE_C	ACT_OPRICE_C	WAERS	CUKY	5	0	Order Price in store	*
80	ACT_OPRICE_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
81	ACT_APRICE	ACT_APRICE	ACT_APRICE	CURR	23	2	Promotion Price in Store
82	ACT_APRICE_C	ACT_APRICE_C	WAERS	CUKY	5	0	Promotion Price in Store	*
83	ACT_APRICE_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
84	ACT_LBVAL	ACT_LBVAL	ACT_LBVAL	DEC	15	2	Value of Samples
85	ACT_LBVAL_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
86	SPTSK	SPTSK	SPTSK	DEC	8	3	Special task centre Sht
87	SPTSK_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
88	LISTING_FEE	LISTING_FEE	LISTING_FEE	CURR	12	2	Listing Fee
89	LISTING_FEE_C	LISTING_FEE_C	WAERS	CUKY	5	0	Listing Fee	*
90	LISTING_FEE_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
91	EDAY_LOW_PRICE	ACT_EDAY_LOW_PRICE	ACT_EDAY_LOW_PRICE	CURR	12	2	Everyday Low Price
92	EDAY_LOW_PRICE_C	ACT_EDAY_LOW_PRICE_C	WAERS	CUKY	5	0	Everyday Low Price	*
93	EDAY_LOW_PRICE_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
94	SENDSTA	ACT_SENDSTA	ACT_SENDSTA	CHAR	1	0	Send Status
95	SENDSTA_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
96	BATCH_ID	ACT_BATCH_ID	ACT_BATCH_ID	CHAR	10	0	Batch ID
97	BATCH_ID_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
98	PRDHA	ACT_PRDHA	ACT_PRDHA	CHAR	20	0	Product hierarchy
99	PRDHA_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
100	.INCLUDE				0	0
101	CELL	LVC_T_STYL		TTYP	0	0