SAP ABAP Table PRP_PLNSETTYPE_03B_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_03B_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	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	OBJECT_KEY	COMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
2	.INCLUDE				0	0	PPR Business Partner (BUPA) Reference: BUPA Hierarchy (BUHI)
3	.INCLUDE				0	0	Administration fields for the PPR interaction layer
4	GUID	CRMT_PRP_GUID	SYSUUID	RAW	16	0	Internal, Unique Identifier for PPR Objects
5	HANDLE	CRMT_PRP_HANDLE		NUMC	10	0	Handle
6	ITEM_NO	CRMT_PRP_BUPA_NO	NUMC10	NUMC	10	0	Number for arranging PPR BUPAs within the same Item
7	TYPE	CRMT_PRP_REFERENCE_TYPE	CRM_PRP_REFERENCE_TYPE	CHAR	2	0	Reference Type of the PPR	*
8	PROCESSING_MODE	CRMT_MODE	CRM_MODE	CHAR	1	0	Processing Mode of Transaction
9	BUPA_REF_GUID	CRMT_PRP_GUID	SYSUUID	RAW	16	0	Internal, Unique Identifier for PPR Objects
10	BUHI_TYPE	CRM_PRP_BP_HIERARCHY_TYPE		CHAR	2	0	Hierarchy Category of BP Group Hierarchy
11	BUHI_TYPE_GUID	BU_HIERARCHY_TYPE_GUID	SYSUUID	RAW	16	0	GUID for Hierarchy Category of BP Group Hierarchy
12	BUHI_TYPE_TEXT	BU_HIERARCHY_TYPE_DESCRIPTION	BU_TEXT40	CHAR	40	0	Description of Hierarchy Category
13	NODE_SEARCH	BU_NODE_SEARCH_TERM		CHAR	20	0	Hierarchy Node ID
14	NODE_TEXT	CRMT_PRP_BPH_NODE_DESCRIPTION	CHAR255	CHAR	255	0	Description of a BP Hierarchy Node and Hierarchy Tree
15	NODE_GUID	BU_NODE_GUID	SYSUUID	RAW	16	0	GUID of Hierarchy Node
16	TREE_GUID	BU_TREE_GUID	SYSUUID	RAW	16	0	GUID of Hierarchy Tree
17	TREE_SEARCH	BU_TREE_SEARCH_TERM		CHAR	20	0	Hierarchy Tree ID
18	TREE_DESC	BU_TREE_DESCRIPTION	BU_TEXT40	CHAR	40	0	Description of Hierarchy Tree
19	NODE_GUID_PCUI_F4	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
20	.INCLUDE				0	0	Products Attribute for Planogram PPR
21	BREIT	ACT_BREIT	ACT_BREIT	QUAN	13	0	Width of the Product or of the Packaging
22	BREIT_U	ACT_BREIT_U	MEINS	UNIT	3	0	Width of the Product or of the Packaging	*
23	BREIT_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
24	BRGEW	ACT_BRGEW	ACT_BRGEW	QUAN	15	3	Gross Weight
25	BRGEW_U	ACT_BRGEW_U	MEINS	UNIT	3	0	Gross Weight	*
26	BRGEW_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
27	VOLUM	ACT_VOLUM	ACT_VOLUM	QUAN	15	0	Volume
28	VOLUM_U	ACT_VOLUM_U	MEINS	UNIT	3	0	Volume	*
29	VOLUM_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
30	VOLEH	ACT_VOLEH	MEINS	UNIT	3	0	Unit for the Volume	*
31	VOLEH_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
32	NROFSAM	ACT_NROFSAM	ACT_NROFSAM	QUAN	4	0	Number of samples
33	NROFSAM_U	ACT_NROFSAM_U	MEINS	UNIT	3	0	Number of samples	*
34	NROFSAM_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
35	STATUS	ACT_PRDS_STATUS	ACT_PRDS_STATUS	CHAR	3	0	Status of documented product
36	STATUS_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
37	SAMTOBESENT	ACT_SAMTOBESENT	ACT_SAMTOBESENT	CHAR	1	0	Product Request
38	SAMTOBESENT_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
39	SAMRETURN	ACT_SAMRETURN	ACT_SAMRETURN	CHAR	1	0	Flag for Returns
40	SAMRETURN_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
41	DISCUSS	ACT_DISCUSS	ACT_DISCUSS	CHAR	1	0	Discussed
42	DISCUSS_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
43	HOEHE	ACT_HOEHE	ACT_HOEHE	QUAN	13	0	Height of the Product or of the Packaging
44	HOEHE_U	ACT_HOEHE_U	MEINS	UNIT	3	0	Height of the Product or of the Packagin	*
45	HOEHE_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
46	PRAVA	ACT_PRAVA	CRM_ACT_PROD_AVAILABLE_AFTER	CHAR	3	0	Product available after visit at checkou	*
47	PRAVA_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
48	PRAVB	ACT_PRAVB	CRM_ACT_PROD_AVAILABLE_BEFORE	CHAR	3	0	Product available before Visit at check	*
49	PRAVB_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
50	RESREAS	ACT_RESREAS	CRM_ACT_KVRESF	CHAR	1	0	Result Reason	*
51	RESREAS_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
52	STOCK	ACT_KV_STOCK	ACT_KV_STOCK	DEC	6	0	Number of Products in stocks
53	STOCK_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
54	ACT_RESULT	ACT_KV_RESULT	CRM_ACT_KVRESF	CHAR	1	0	Result	*
55	ACT_RESULT_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
56	PANZ	ACT_KV_ZPANZ	ACT_KV_ZPANZ	DEC	3	0	Number of Second placements
57	PANZ_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
58	PAVA	ACT_KV_ZPAVA	CRM_ACT_SDPMT	CHAR	1	0	Second Placement Available	*
59	PAVA_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
60	NRPSHF	ACT_NRPSHF	ACT_NRPSHF	DEC	6	0	Number of Products on Promotion Shelf
61	NRPSHF_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
62	POSVER	ACT_POSVER	CRM_ACT_VERTICAL_POS_IN_SHELF	CHAR	3	0	vertical position in shelf	*
63	POSVER_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
64	POSHOR	ACT_POSHOR	CRM_ACT_HORIZONT_POS_IN_SHELF	CHAR	3	0	horizontal position in shelf	*
65	POSHOR_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
66	NROFFAC	ACT_NROFFAC	ACT_NROFFAC	DEC	4	0	Number of facings
67	NROFFAC_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
68	FACLEN	ACT_FACLEN	ACT_FACLEN	DEC	6	0	Length of Facing
69	FACLEN_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
70	FACWID	ACT_FACWID	ACT_FACWID	DEC	6	0	Width of Facing
71	FACWID_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
72	FACDEP	ACT_FACDEP	ACT_FACDEP	DEC	6	2	Depth of Facing
73	FACDEP_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
74	ACT_FACUNIT	ACT_FACUNIT	MEINS	UNIT	3	0	Units of Measure for the Product	*
75	ACT_FACUNIT_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
76	ACT_SPRICE	ACT_SPRICE	ACT_SPRICE	CURR	23	2	Sales Price in store
77	ACT_SPRICE_C	ACT_SPRICE_C	WAERS	CUKY	5	0	Sales Price in store	*
78	ACT_SPRICE_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
79	ACT_OPRICE	ACT_OPRICE	ACT_OPRICE	CURR	23	2	Order Price in store
80	ACT_OPRICE_C	ACT_OPRICE_C	WAERS	CUKY	5	0	Order Price in store	*
81	ACT_OPRICE_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
82	ACT_APRICE	ACT_APRICE	ACT_APRICE	CURR	23	2	Promotion Price in Store
83	ACT_APRICE_C	ACT_APRICE_C	WAERS	CUKY	5	0	Promotion Price in Store	*
84	ACT_APRICE_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
85	ACT_LBVAL	ACT_LBVAL	ACT_LBVAL	DEC	15	2	Value of Samples
86	ACT_LBVAL_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
87	SPTSK	SPTSK	SPTSK	DEC	8	3	Special task centre Sht
88	SPTSK_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
89	LISTING_FEE	LISTING_FEE	LISTING_FEE	CURR	12	2	Listing Fee
90	LISTING_FEE_C	LISTING_FEE_C	WAERS	CUKY	5	0	Listing Fee	*
91	LISTING_FEE_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
92	EDAY_LOW_PRICE	ACT_EDAY_LOW_PRICE	ACT_EDAY_LOW_PRICE	CURR	12	2	Everyday Low Price
93	EDAY_LOW_PRICE_C	ACT_EDAY_LOW_PRICE_C	WAERS	CUKY	5	0	Everyday Low Price	*
94	EDAY_LOW_PRICE_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
95	SENDSTA	ACT_SENDSTA	ACT_SENDSTA	CHAR	1	0	Send Status
96	SENDSTA_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
97	BATCH_ID	ACT_BATCH_ID	ACT_BATCH_ID	CHAR	10	0	Batch ID
98	BATCH_ID_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
99	PRDHA	ACT_PRDHA	ACT_PRDHA	CHAR	20	0	Product hierarchy
100	PRDHA_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
101	.INCLUDE				0	0