SAP ABAP Table PRP_PLNSETTYPE_01T_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_01T_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 Time Stamp Date for the User Interface
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_TS_NO	NUMC10	NUMC	10	0	Number for arranging PPR Validity Periods within the same It
7	TYPE	CRMT_PRP_REFERENCE_TYPE	CRM_PRP_REFERENCE_TYPE	CHAR	2	0	Reference Type of the PPR	*
8	EXCLUSION	CRMT_PRP_TS_EXCL	CRM_BOOLEAN	CHAR	1	0	PPR Validity Period: Exclusion Flag
9	DATE_VALID_FROM	CRMT_PRP_DATE_VALID_FROM	DATE	DATS	8	0	Start Date of Validity Period
10	DATE_VALID_TO	CRMT_PRP_DATE_VALID_TO	DATE	DATS	8	0	End Date of Validity Period
11	TS_DATE_LOW	CRMT_PRP_DATE_LOW	TZTF_IO_FIELD	CHAR	26	0	Start Date of a PPR Item's Temporal Validity
12	TS_DATE_HIGH	CRMT_PRP_DATE_HIGH	TZTF_IO_FIELD	CHAR	26	0	End Date of a PPR Item's Temporal Validity
13	TS_DATE_LOW_TMP	CRMT_PRP_DATE_LOW	TZTF_IO_FIELD	CHAR	26	0	Start Date of a PPR Item's Temporal Validity
14	TS_DATE_HIGH_TMP	CRMT_PRP_DATE_HIGH	TZTF_IO_FIELD	CHAR	26	0	End Date of a PPR Item's Temporal Validity
15	PROCESSING_MODE	CRMT_MODE	CRM_MODE	CHAR	1	0	Processing Mode of Transaction
16	EXCL_F4_CHANGE	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
17	EXCL_F4_CHANGE_2	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
18	.INCLUDE				0	0	Products Attribute for Planogram PPR
19	BREIT	ACT_BREIT	ACT_BREIT	QUAN	13	0	Width of the Product or of the Packaging
20	BREIT_U	ACT_BREIT_U	MEINS	UNIT	3	0	Width of the Product or of the Packaging	*
21	BREIT_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
22	BRGEW	ACT_BRGEW	ACT_BRGEW	QUAN	15	3	Gross Weight
23	BRGEW_U	ACT_BRGEW_U	MEINS	UNIT	3	0	Gross Weight	*
24	BRGEW_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
25	VOLUM	ACT_VOLUM	ACT_VOLUM	QUAN	15	0	Volume
26	VOLUM_U	ACT_VOLUM_U	MEINS	UNIT	3	0	Volume	*
27	VOLUM_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
28	VOLEH	ACT_VOLEH	MEINS	UNIT	3	0	Unit for the Volume	*
29	VOLEH_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
30	NROFSAM	ACT_NROFSAM	ACT_NROFSAM	QUAN	4	0	Number of samples
31	NROFSAM_U	ACT_NROFSAM_U	MEINS	UNIT	3	0	Number of samples	*
32	NROFSAM_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
33	STATUS	ACT_PRDS_STATUS	ACT_PRDS_STATUS	CHAR	3	0	Status of documented product
34	STATUS_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
35	SAMTOBESENT	ACT_SAMTOBESENT	ACT_SAMTOBESENT	CHAR	1	0	Product Request
36	SAMTOBESENT_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
37	SAMRETURN	ACT_SAMRETURN	ACT_SAMRETURN	CHAR	1	0	Flag for Returns
38	SAMRETURN_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
39	DISCUSS	ACT_DISCUSS	ACT_DISCUSS	CHAR	1	0	Discussed
40	DISCUSS_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
41	HOEHE	ACT_HOEHE	ACT_HOEHE	QUAN	13	0	Height of the Product or of the Packaging
42	HOEHE_U	ACT_HOEHE_U	MEINS	UNIT	3	0	Height of the Product or of the Packagin	*
43	HOEHE_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
44	PRAVA	ACT_PRAVA	CRM_ACT_PROD_AVAILABLE_AFTER	CHAR	3	0	Product available after visit at checkou	*
45	PRAVA_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
46	PRAVB	ACT_PRAVB	CRM_ACT_PROD_AVAILABLE_BEFORE	CHAR	3	0	Product available before Visit at check	*
47	PRAVB_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
48	RESREAS	ACT_RESREAS	CRM_ACT_KVRESF	CHAR	1	0	Result Reason	*
49	RESREAS_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
50	STOCK	ACT_KV_STOCK	ACT_KV_STOCK	DEC	6	0	Number of Products in stocks
51	STOCK_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
52	ACT_RESULT	ACT_KV_RESULT	CRM_ACT_KVRESF	CHAR	1	0	Result	*
53	ACT_RESULT_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
54	PANZ	ACT_KV_ZPANZ	ACT_KV_ZPANZ	DEC	3	0	Number of Second placements
55	PANZ_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
56	PAVA	ACT_KV_ZPAVA	CRM_ACT_SDPMT	CHAR	1	0	Second Placement Available	*
57	PAVA_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
58	NRPSHF	ACT_NRPSHF	ACT_NRPSHF	DEC	6	0	Number of Products on Promotion Shelf
59	NRPSHF_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
60	POSVER	ACT_POSVER	CRM_ACT_VERTICAL_POS_IN_SHELF	CHAR	3	0	vertical position in shelf	*
61	POSVER_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
62	POSHOR	ACT_POSHOR	CRM_ACT_HORIZONT_POS_IN_SHELF	CHAR	3	0	horizontal position in shelf	*
63	POSHOR_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
64	NROFFAC	ACT_NROFFAC	ACT_NROFFAC	DEC	4	0	Number of facings
65	NROFFAC_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
66	FACLEN	ACT_FACLEN	ACT_FACLEN	DEC	6	0	Length of Facing
67	FACLEN_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
68	FACWID	ACT_FACWID	ACT_FACWID	DEC	6	0	Width of Facing
69	FACWID_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
70	FACDEP	ACT_FACDEP	ACT_FACDEP	DEC	6	2	Depth of Facing
71	FACDEP_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
72	ACT_FACUNIT	ACT_FACUNIT	MEINS	UNIT	3	0	Units of Measure for the Product	*
73	ACT_FACUNIT_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
74	ACT_SPRICE	ACT_SPRICE	ACT_SPRICE	CURR	23	2	Sales Price in store
75	ACT_SPRICE_C	ACT_SPRICE_C	WAERS	CUKY	5	0	Sales Price in store	*
76	ACT_SPRICE_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
77	ACT_OPRICE	ACT_OPRICE	ACT_OPRICE	CURR	23	2	Order Price in store
78	ACT_OPRICE_C	ACT_OPRICE_C	WAERS	CUKY	5	0	Order Price in store	*
79	ACT_OPRICE_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
80	ACT_APRICE	ACT_APRICE	ACT_APRICE	CURR	23	2	Promotion Price in Store
81	ACT_APRICE_C	ACT_APRICE_C	WAERS	CUKY	5	0	Promotion Price in Store	*
82	ACT_APRICE_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
83	ACT_LBVAL	ACT_LBVAL	ACT_LBVAL	DEC	15	2	Value of Samples
84	ACT_LBVAL_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
85	SPTSK	SPTSK	SPTSK	DEC	8	3	Special task centre Sht
86	SPTSK_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
87	LISTING_FEE	LISTING_FEE	LISTING_FEE	CURR	12	2	Listing Fee
88	LISTING_FEE_C	LISTING_FEE_C	WAERS	CUKY	5	0	Listing Fee	*
89	LISTING_FEE_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
90	EDAY_LOW_PRICE	ACT_EDAY_LOW_PRICE	ACT_EDAY_LOW_PRICE	CURR	12	2	Everyday Low Price
91	EDAY_LOW_PRICE_C	ACT_EDAY_LOW_PRICE_C	WAERS	CUKY	5	0	Everyday Low Price	*
92	EDAY_LOW_PRICE_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
93	SENDSTA	ACT_SENDSTA	ACT_SENDSTA	CHAR	1	0	Send Status
94	SENDSTA_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
95	BATCH_ID	ACT_BATCH_ID	ACT_BATCH_ID	CHAR	10	0	Batch ID
96	BATCH_ID_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
97	PRDHA	ACT_PRDHA	ACT_PRDHA	CHAR	20	0	Product hierarchy
98	PRDHA_DESC	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
99	.INCLUDE				0	0