SAP ABAP Table PRP_PLNSETTYPE_EXT (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	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	BRGEW	☐	ACT_BRGEW	ACT_BRGEW	QUAN	15	3	Gross Weight
4	BRGEW_U	☐	ACT_BRGEW_U	MEINS	UNIT	3	0	Gross Weight	T006
5	VOLUM	☐	ACT_VOLUM	ACT_VOLUM	QUAN	15	0	Volume
6	VOLUM_U	☐	ACT_VOLUM_U	MEINS	UNIT	3	0	Volume	T006
7	VOLEH	☐	ACT_VOLEH	MEINS	UNIT	3	0	Unit for the Volume	T006
8	NROFSAM	☐	ACT_NROFSAM	ACT_NROFSAM	QUAN	4	0	Number of samples
9	NROFSAM_U	☐	ACT_NROFSAM_U	MEINS	UNIT	3	0	Number of samples	T006
10	STATUS	☐	ACT_PRDS_STATUS	ACT_PRDS_STATUS	CHAR	3	0	Status of documented product
11	SAMTOBESENT	☐	ACT_SAMTOBESENT	ACT_SAMTOBESENT	CHAR	1	0	Product Request
12	SAMRETURN	☐	ACT_SAMRETURN	ACT_SAMRETURN	CHAR	1	0	Flag for Returns
13	DISCUSS	☐	ACT_DISCUSS	ACT_DISCUSS	CHAR	1	0	Discussed
14	HOEHE	☐	ACT_HOEHE	ACT_HOEHE	QUAN	13	0	Height of the Product or of the Packaging
15	HOEHE_U	☐	ACT_HOEHE_U	MEINS	UNIT	3	0	Height of the Product or of the Packagin	T006
16	PRAVA	☐	ACT_PRAVA	CRM_ACT_PROD_AVAILABLE_AFTER	CHAR	3	0	Product available after visit at checkou	*
17	PRAVB	☐	ACT_PRAVB	CRM_ACT_PROD_AVAILABLE_BEFORE	CHAR	3	0	Product available before Visit at check	*
18	RESREAS	☐	ACT_RESREAS	CRM_ACT_KVRESF	CHAR	1	0	Result Reason	*
19	STOCK	☐	ACT_KV_STOCK	ACT_KV_STOCK	DEC	6	0	Number of Products in stocks
20	ACT_RESULT	☐	ACT_KV_RESULT	CRM_ACT_KVRESF	CHAR	1	0	Result	*
21	PANZ	☐	ACT_KV_ZPANZ	ACT_KV_ZPANZ	DEC	3	0	Number of Second placements
22	PAVA	☐	ACT_KV_ZPAVA	CRM_ACT_SDPMT	CHAR	1	0	Second Placement Available	*
23	NRPSHF	☐	ACT_NRPSHF	ACT_NRPSHF	DEC	6	0	Number of Products on Promotion Shelf
24	POSVER	☐	ACT_POSVER	CRM_ACT_VERTICAL_POS_IN_SHELF	CHAR	3	0	vertical position in shelf	*
25	POSHOR	☐	ACT_POSHOR	CRM_ACT_HORIZONT_POS_IN_SHELF	CHAR	3	0	horizontal position in shelf	*
26	NROFFAC	☐	ACT_NROFFAC	ACT_NROFFAC	DEC	4	0	Number of facings
27	FACLEN	☐	ACT_FACLEN	ACT_FACLEN	DEC	6	0	Length of Facing
28	FACWID	☐	ACT_FACWID	ACT_FACWID	DEC	6	0	Width of Facing
29	FACDEP	☐	ACT_FACDEP	ACT_FACDEP	DEC	6	2	Depth of Facing
30	ACT_FACUNIT	☐	ACT_FACUNIT	MEINS	UNIT	3	0	Units of Measure for the Product	T006
31	ACT_SPRICE	☐	ACT_SPRICE	ACT_SPRICE	CURR	23	2	Sales Price in store
32	ACT_SPRICE_C	☐	ACT_SPRICE_C	WAERS	CUKY	5	0	Sales Price in store	TCURC
33	ACT_OPRICE	☐	ACT_OPRICE	ACT_OPRICE	CURR	23	2	Order Price in store
34	ACT_OPRICE_C	☐	ACT_OPRICE_C	WAERS	CUKY	5	0	Order Price in store	TCURC
35	ACT_APRICE	☐	ACT_APRICE	ACT_APRICE	CURR	23	2	Promotion Price in Store
36	ACT_APRICE_C	☐	ACT_APRICE_C	WAERS	CUKY	5	0	Promotion Price in Store	TCURC
37	ACT_LBVAL	☐	ACT_LBVAL	ACT_LBVAL	DEC	15	2	Value of Samples
38	SPTSK	☐	SPTSK	SPTSK	DEC	8	3	Special task centre Sht
39	LISTING_FEE	☐	LISTING_FEE	LISTING_FEE	CURR	12	2	Listing Fee
40	LISTING_FEE_C	☐	LISTING_FEE_C	WAERS	CUKY	5	0	Listing Fee	TCURC
41	EDAY_LOW_PRICE	☐	ACT_EDAY_LOW_PRICE	ACT_EDAY_LOW_PRICE	CURR	12	2	Everyday Low Price
42	EDAY_LOW_PRICE_C	☐	ACT_EDAY_LOW_PRICE_C	WAERS	CUKY	5	0	Everyday Low Price	TCURC
43	SENDSTA	☐	ACT_SENDSTA	ACT_SENDSTA	CHAR	1	0	Send Status
44	BATCH_ID	☐	ACT_BATCH_ID	ACT_BATCH_ID	CHAR	10	0	Batch ID
45	PRDHA	☐	ACT_PRDHA	ACT_PRDHA	CHAR	20	0	Product hierarchy
46	.INCLUDE	☐				0	0

Foreign Keys

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

History

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