SAP ABAP Table PRP_PLNSETTYPE_01O_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_01O_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 Header Ext. Sales Organisational Data
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_ORG_H_NO	NUMC10	NUMC	10	0	Number for arranging PPR Organisational Data Entries
8	TYPE	☐	CRMT_PRP_REFERENCE_TYPE	CRM_PRP_REFERENCE_TYPE	CHAR	2	0	Reference Type of the PPR	*
9	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
10	SALES_OFFICE	☐	CRMT_SALES_OFFICE	HROBJEC_14	CHAR	14	0	Sales Office
11	SALES_GROUP	☐	CRMT_SALES_GROUP	HROBJEC_14	CHAR	14	0	Sales Group
12	SALES_ORG_RESP	☐	CRMT_PRP_SALES_ORG_RESP	HROBJEC_14	CHAR	14	0	Responsible Organisational Unit (Sales)
13	DIS_CHANNEL	☐	CRMT_PRP_DIS_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
14	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
15	PROCESSING_MODE	☐	CRMT_MODE	CRM_MODE	CHAR	1	0	Processing Mode of Transaction
16	DELETED_FLAG	☐	CRMT_PRP_DELETED_FLAG	CRM_BOOLEAN	CHAR	1	0	Indicator whether the object is marked for deletion
17	SALES_ORG_SHORT	☐	CRMT_SALES_ORG_SHORT	TEXT12	CHAR	12	0	Sales Organization: Description of Department
18	SALES_ORG_DSCR	☐	CRMT_SALES_ORG_DESC	CRMT_SALES_ORG_DESC	CHAR	40	0	Sales Organization Description
19	SALES_OFFICE_DSCR	☐	CRMT_PRP_SALES_OFFICE_SHORT	TEXT40	CHAR	40	0	Sales Office
20	SALES_GROUP_DSCR	☐	CRMT_PRP_SALES_GROUP_SHORT	TEXT40	CHAR	40	0	Sales Group
21	SALES_ORG_RESP_DSCR	☐	CRMT_PRP_SALES_ORG_RESP_SHORT	TEXT40	CHAR	40	0	Responsible Organizational Unit (Sales)
22	DIS_CHANNEL_DSCR	☐	CRMT_BSP_PROD_DISTR_CHAN_TEXT	TEXT40	CHAR	40	0	Short Text distribution channel
23	DIVISION_DSCR	☐	CRMT_DIVISION_DESC	CRMT_DIVISION_DESC	CHAR	40	0	Division Description
24	.INCLUDE	☐				0	0	Products Attribute for Planogram PPR
25	BREIT	☐	ACT_BREIT	ACT_BREIT	QUAN	13	0	Width of the Product or of the Packaging
26	BREIT_U	☐	ACT_BREIT_U	MEINS	UNIT	3	0	Width of the Product or of the Packaging	*
27	BREIT_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
28	BRGEW	☐	ACT_BRGEW	ACT_BRGEW	QUAN	15	3	Gross Weight
29	BRGEW_U	☐	ACT_BRGEW_U	MEINS	UNIT	3	0	Gross Weight	*
30	BRGEW_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
31	VOLUM	☐	ACT_VOLUM	ACT_VOLUM	QUAN	15	0	Volume
32	VOLUM_U	☐	ACT_VOLUM_U	MEINS	UNIT	3	0	Volume	*
33	VOLUM_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
34	VOLEH	☐	ACT_VOLEH	MEINS	UNIT	3	0	Unit for the Volume	*
35	VOLEH_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
36	NROFSAM	☐	ACT_NROFSAM	ACT_NROFSAM	QUAN	4	0	Number of samples
37	NROFSAM_U	☐	ACT_NROFSAM_U	MEINS	UNIT	3	0	Number of samples	*
38	NROFSAM_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
39	STATUS	☐	ACT_PRDS_STATUS	ACT_PRDS_STATUS	CHAR	3	0	Status of documented product
40	STATUS_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
41	SAMTOBESENT	☐	ACT_SAMTOBESENT	ACT_SAMTOBESENT	CHAR	1	0	Product Request
42	SAMTOBESENT_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
43	SAMRETURN	☐	ACT_SAMRETURN	ACT_SAMRETURN	CHAR	1	0	Flag for Returns
44	SAMRETURN_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
45	DISCUSS	☐	ACT_DISCUSS	ACT_DISCUSS	CHAR	1	0	Discussed
46	DISCUSS_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
47	HOEHE	☐	ACT_HOEHE	ACT_HOEHE	QUAN	13	0	Height of the Product or of the Packaging
48	HOEHE_U	☐	ACT_HOEHE_U	MEINS	UNIT	3	0	Height of the Product or of the Packagin	*
49	HOEHE_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
50	PRAVA	☐	ACT_PRAVA	CRM_ACT_PROD_AVAILABLE_AFTER	CHAR	3	0	Product available after visit at checkou	*
51	PRAVA_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
52	PRAVB	☐	ACT_PRAVB	CRM_ACT_PROD_AVAILABLE_BEFORE	CHAR	3	0	Product available before Visit at check	*
53	PRAVB_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
54	RESREAS	☐	ACT_RESREAS	CRM_ACT_KVRESF	CHAR	1	0	Result Reason	*
55	RESREAS_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
56	STOCK	☐	ACT_KV_STOCK	ACT_KV_STOCK	DEC	6	0	Number of Products in stocks
57	STOCK_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
58	ACT_RESULT	☐	ACT_KV_RESULT	CRM_ACT_KVRESF	CHAR	1	0	Result	*
59	ACT_RESULT_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
60	PANZ	☐	ACT_KV_ZPANZ	ACT_KV_ZPANZ	DEC	3	0	Number of Second placements
61	PANZ_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
62	PAVA	☐	ACT_KV_ZPAVA	CRM_ACT_SDPMT	CHAR	1	0	Second Placement Available	*
63	PAVA_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
64	NRPSHF	☐	ACT_NRPSHF	ACT_NRPSHF	DEC	6	0	Number of Products on Promotion Shelf
65	NRPSHF_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
66	POSVER	☐	ACT_POSVER	CRM_ACT_VERTICAL_POS_IN_SHELF	CHAR	3	0	vertical position in shelf	*
67	POSVER_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
68	POSHOR	☐	ACT_POSHOR	CRM_ACT_HORIZONT_POS_IN_SHELF	CHAR	3	0	horizontal position in shelf	*
69	POSHOR_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
70	NROFFAC	☐	ACT_NROFFAC	ACT_NROFFAC	DEC	4	0	Number of facings
71	NROFFAC_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
72	FACLEN	☐	ACT_FACLEN	ACT_FACLEN	DEC	6	0	Length of Facing
73	FACLEN_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
74	FACWID	☐	ACT_FACWID	ACT_FACWID	DEC	6	0	Width of Facing
75	FACWID_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
76	FACDEP	☐	ACT_FACDEP	ACT_FACDEP	DEC	6	2	Depth of Facing
77	FACDEP_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
78	ACT_FACUNIT	☐	ACT_FACUNIT	MEINS	UNIT	3	0	Units of Measure for the Product	*
79	ACT_FACUNIT_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
80	ACT_SPRICE	☐	ACT_SPRICE	ACT_SPRICE	CURR	23	2	Sales Price in store
81	ACT_SPRICE_C	☐	ACT_SPRICE_C	WAERS	CUKY	5	0	Sales Price in store	*
82	ACT_SPRICE_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
83	ACT_OPRICE	☐	ACT_OPRICE	ACT_OPRICE	CURR	23	2	Order Price in store
84	ACT_OPRICE_C	☐	ACT_OPRICE_C	WAERS	CUKY	5	0	Order Price in store	*
85	ACT_OPRICE_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
86	ACT_APRICE	☐	ACT_APRICE	ACT_APRICE	CURR	23	2	Promotion Price in Store
87	ACT_APRICE_C	☐	ACT_APRICE_C	WAERS	CUKY	5	0	Promotion Price in Store	*
88	ACT_APRICE_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
89	ACT_LBVAL	☐	ACT_LBVAL	ACT_LBVAL	DEC	15	2	Value of Samples
90	ACT_LBVAL_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
91	SPTSK	☐	SPTSK	SPTSK	DEC	8	3	Special task centre Sht
92	SPTSK_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
93	LISTING_FEE	☐	LISTING_FEE	LISTING_FEE	CURR	12	2	Listing Fee
94	LISTING_FEE_C	☐	LISTING_FEE_C	WAERS	CUKY	5	0	Listing Fee	*
95	LISTING_FEE_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
96	EDAY_LOW_PRICE	☐	ACT_EDAY_LOW_PRICE	ACT_EDAY_LOW_PRICE	CURR	12	2	Everyday Low Price
97	EDAY_LOW_PRICE_C	☐	ACT_EDAY_LOW_PRICE_C	WAERS	CUKY	5	0	Everyday Low Price	*
98	EDAY_LOW_PRICE_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
99	SENDSTA	☐	ACT_SENDSTA	ACT_SENDSTA	CHAR	1	0	Send Status
100	SENDSTA_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
101	BATCH_ID	☐	ACT_BATCH_ID	ACT_BATCH_ID	CHAR	10	0	Batch ID
102	BATCH_ID_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
103	PRDHA	☐	ACT_PRDHA	ACT_PRDHA	CHAR	20	0	Product hierarchy
104	PRDHA_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
105	.INCLUDE	☐				0	0
106	CELL	☐	LVC_T_STYL		TTYP	0	0

History

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