SAP ABAP Table PRP_PLNSETTYPE_EXT_UI (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_EXT_UI	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	BREIT_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
4	BRGEW	☐	ACT_BRGEW	ACT_BRGEW	QUAN	15	3	Gross Weight
5	BRGEW_U	☐	ACT_BRGEW_U	MEINS	UNIT	3	0	Gross Weight	T006
6	BRGEW_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
7	VOLUM	☐	ACT_VOLUM	ACT_VOLUM	QUAN	15	0	Volume
8	VOLUM_U	☐	ACT_VOLUM_U	MEINS	UNIT	3	0	Volume	T006
9	VOLUM_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
10	VOLEH	☐	ACT_VOLEH	MEINS	UNIT	3	0	Unit for the Volume	*
11	VOLEH_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
12	NROFSAM	☐	ACT_NROFSAM	ACT_NROFSAM	QUAN	4	0	Number of samples
13	NROFSAM_U	☐	ACT_NROFSAM_U	MEINS	UNIT	3	0	Number of samples	T006
14	NROFSAM_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
15	STATUS	☐	ACT_PRDS_STATUS	ACT_PRDS_STATUS	CHAR	3	0	Status of documented product
16	STATUS_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
17	SAMTOBESENT	☐	ACT_SAMTOBESENT	ACT_SAMTOBESENT	CHAR	1	0	Product Request
18	SAMTOBESENT_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
19	SAMRETURN	☐	ACT_SAMRETURN	ACT_SAMRETURN	CHAR	1	0	Flag for Returns
20	SAMRETURN_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
21	DISCUSS	☐	ACT_DISCUSS	ACT_DISCUSS	CHAR	1	0	Discussed
22	DISCUSS_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
23	HOEHE	☐	ACT_HOEHE	ACT_HOEHE	QUAN	13	0	Height of the Product or of the Packaging
24	HOEHE_U	☐	ACT_HOEHE_U	MEINS	UNIT	3	0	Height of the Product or of the Packagin	T006
25	HOEHE_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
26	PRAVA	☐	ACT_PRAVA	CRM_ACT_PROD_AVAILABLE_AFTER	CHAR	3	0	Product available after visit at checkou	*
27	PRAVA_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
28	PRAVB	☐	ACT_PRAVB	CRM_ACT_PROD_AVAILABLE_BEFORE	CHAR	3	0	Product available before Visit at check	*
29	PRAVB_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
30	RESREAS	☐	ACT_RESREAS	CRM_ACT_KVRESF	CHAR	1	0	Result Reason	*
31	RESREAS_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
32	STOCK	☐	ACT_KV_STOCK	ACT_KV_STOCK	DEC	6	0	Number of Products in stocks
33	STOCK_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
34	ACT_RESULT	☐	ACT_KV_RESULT	CRM_ACT_KVRESF	CHAR	1	0	Result	*
35	ACT_RESULT_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
36	PANZ	☐	ACT_KV_ZPANZ	ACT_KV_ZPANZ	DEC	3	0	Number of Second placements
37	PANZ_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
38	PAVA	☐	ACT_KV_ZPAVA	CRM_ACT_SDPMT	CHAR	1	0	Second Placement Available	*
39	PAVA_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
40	NRPSHF	☐	ACT_NRPSHF	ACT_NRPSHF	DEC	6	0	Number of Products on Promotion Shelf
41	NRPSHF_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
42	POSVER	☐	ACT_POSVER	CRM_ACT_VERTICAL_POS_IN_SHELF	CHAR	3	0	vertical position in shelf	*
43	POSVER_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
44	POSHOR	☐	ACT_POSHOR	CRM_ACT_HORIZONT_POS_IN_SHELF	CHAR	3	0	horizontal position in shelf	*
45	POSHOR_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
46	NROFFAC	☐	ACT_NROFFAC	ACT_NROFFAC	DEC	4	0	Number of facings
47	NROFFAC_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
48	FACLEN	☐	ACT_FACLEN	ACT_FACLEN	DEC	6	0	Length of Facing
49	FACLEN_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
50	FACWID	☐	ACT_FACWID	ACT_FACWID	DEC	6	0	Width of Facing
51	FACWID_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
52	FACDEP	☐	ACT_FACDEP	ACT_FACDEP	DEC	6	2	Depth of Facing
53	FACDEP_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
54	ACT_FACUNIT	☐	ACT_FACUNIT	MEINS	UNIT	3	0	Units of Measure for the Product	*
55	ACT_FACUNIT_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
56	ACT_SPRICE	☐	ACT_SPRICE	ACT_SPRICE	CURR	23	2	Sales Price in store
57	ACT_SPRICE_C	☐	ACT_SPRICE_C	WAERS	CUKY	5	0	Sales Price in store	TCURC
58	ACT_SPRICE_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
59	ACT_OPRICE	☐	ACT_OPRICE	ACT_OPRICE	CURR	23	2	Order Price in store
60	ACT_OPRICE_C	☐	ACT_OPRICE_C	WAERS	CUKY	5	0	Order Price in store	TCURC
61	ACT_OPRICE_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
62	ACT_APRICE	☐	ACT_APRICE	ACT_APRICE	CURR	23	2	Promotion Price in Store
63	ACT_APRICE_C	☐	ACT_APRICE_C	WAERS	CUKY	5	0	Promotion Price in Store	TCURC
64	ACT_APRICE_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
65	ACT_LBVAL	☐	ACT_LBVAL	ACT_LBVAL	DEC	15	2	Value of Samples
66	ACT_LBVAL_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
67	SPTSK	☐	SPTSK	SPTSK	DEC	8	3	Special task centre Sht
68	SPTSK_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
69	LISTING_FEE	☐	LISTING_FEE	LISTING_FEE	CURR	12	2	Listing Fee
70	LISTING_FEE_C	☐	LISTING_FEE_C	WAERS	CUKY	5	0	Listing Fee	TCURC
71	LISTING_FEE_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
72	EDAY_LOW_PRICE	☐	ACT_EDAY_LOW_PRICE	ACT_EDAY_LOW_PRICE	CURR	12	2	Everyday Low Price
73	EDAY_LOW_PRICE_C	☐	ACT_EDAY_LOW_PRICE_C	WAERS	CUKY	5	0	Everyday Low Price	TCURC
74	EDAY_LOW_PRICE_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
75	SENDSTA	☐	ACT_SENDSTA	ACT_SENDSTA	CHAR	1	0	Send Status
76	SENDSTA_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
77	BATCH_ID	☐	ACT_BATCH_ID	ACT_BATCH_ID	CHAR	10	0	Batch ID
78	BATCH_ID_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
79	PRDHA	☐	ACT_PRDHA	ACT_PRDHA	CHAR	20	0	Product hierarchy
80	PRDHA_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
81	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PRP_PLNSETTYPE_EXT_UI	ACT_APRICE_C	TCURC	WAERS
2	PRP_PLNSETTYPE_EXT_UI	ACT_OPRICE_C	TCURC	WAERS
3	PRP_PLNSETTYPE_EXT_UI	ACT_SPRICE_C	TCURC	WAERS
4	PRP_PLNSETTYPE_EXT_UI	BREIT_U	T006	MSEHI
5	PRP_PLNSETTYPE_EXT_UI	BRGEW_U	T006	MSEHI
6	PRP_PLNSETTYPE_EXT_UI	EDAY_LOW_PRICE_C	TCURC	WAERS
7	PRP_PLNSETTYPE_EXT_UI	HOEHE_U	T006	MSEHI
8	PRP_PLNSETTYPE_EXT_UI	LISTING_FEE_C	TCURC	WAERS
9	PRP_PLNSETTYPE_EXT_UI	NROFSAM_U	T006	MSEHI
10	PRP_PLNSETTYPE_EXT_UI	VOLUM_U	T006	MSEHI

History

Last changed by/on	SAP	20050311
SAP Release Created in	500