SAP ABAP Table PLNSETTYPEH (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	TRANSP	Transparent table
Transparent table	PLNSETTYPEH	Table Relationship Diagram
Short Description	Products Attribute for Planogram PPR

Delivery and Maintenance

Pool/cluster
Delivery Class	S	System table, maint. only by SAP, change = modification
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	PPR Object Extensions: Primary Key Fields
2	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
3	GUID	☑	CRMT_PRP_GUID	SYSUUID	RAW	16	0	Internal, Unique Identifier for PPR Objects
4	.INCLUDE	☐				0	0	PPR Obj. Ext. History: DB-Tab. Fields Manipulated Internally
5	OBJECT_NAME	☐	CRMT_PRP_OBJECT_NAME	CRM_PRP_OBJECTNAME	CHAR	30	0	PPR Object Name	*
6	TYPE	☐	CRMT_PRP_REFERENCE_TYPE	CRM_PRP_REFERENCE_TYPE	CHAR	2	0	Reference Type of the PPR	*
7	PARENT_GUID	☐	CRMT_PRP_GUID	SYSUUID	RAW	16	0	Internal, Unique Identifier for PPR Objects
8	.INCLUDE	☐				0	0	Partner/Product Range (PPR): Admin. Data for History Tables
9	VALID_FROM	☐	COMT_VALID_FROM	BCOS_TSTMP	DEC	15	0	Valid From (Time Stamp)
10	VALID_TO	☐	COMT_VALID_TO	BCOS_TSTMP	DEC	15	0	Valid To (Time Stamp)
11	UPNAME	☐	COMT_UPNAME	UNAME	CHAR	12	0	Name of the User Who Last Changed the Set
12	ANCESTOR_GUID	☐	CRMT_PRP_GUID	SYSUUID	RAW	16	0	Internal, Unique Identifier for PPR Objects
13	UPDATE_TYPE	☐	UPDATE_TYPE	UPDATE_TYPE	CHAR	1	0	Type of Change
14	.INCLUDE	☐				0	0	Products Attribute for Planogram PPR
15	BREIT	☐	ACT_BREIT	ACT_BREIT	QUAN	13	0	Width of the Product or of the Packaging
16	BREIT_U	☐	ACT_BREIT_U	MEINS	UNIT	3	0	Width of the Product or of the Packaging	*
17	BRGEW	☐	ACT_BRGEW	ACT_BRGEW	QUAN	15	3	Gross Weight
18	BRGEW_U	☐	ACT_BRGEW_U	MEINS	UNIT	3	0	Gross Weight	*
19	VOLUM	☐	ACT_VOLUM	ACT_VOLUM	QUAN	15	0	Volume
20	VOLUM_U	☐	ACT_VOLUM_U	MEINS	UNIT	3	0	Volume	*
21	VOLEH	☐	ACT_VOLEH	MEINS	UNIT	3	0	Unit for the Volume	*
22	NROFSAM	☐	ACT_NROFSAM	ACT_NROFSAM	QUAN	4	0	Number of samples
23	NROFSAM_U	☐	ACT_NROFSAM_U	MEINS	UNIT	3	0	Number of samples	*
24	STATUS	☐	ACT_PRDS_STATUS	ACT_PRDS_STATUS	CHAR	3	0	Status of documented product
25	SAMTOBESENT	☐	ACT_SAMTOBESENT	ACT_SAMTOBESENT	CHAR	1	0	Product Request
26	SAMRETURN	☐	ACT_SAMRETURN	ACT_SAMRETURN	CHAR	1	0	Flag for Returns
27	DISCUSS	☐	ACT_DISCUSS	ACT_DISCUSS	CHAR	1	0	Discussed
28	HOEHE	☐	ACT_HOEHE	ACT_HOEHE	QUAN	13	0	Height of the Product or of the Packaging
29	HOEHE_U	☐	ACT_HOEHE_U	MEINS	UNIT	3	0	Height of the Product or of the Packagin	*
30	PRAVA	☐	ACT_PRAVA	CRM_ACT_PROD_AVAILABLE_AFTER	CHAR	3	0	Product available after visit at checkou	*
31	PRAVB	☐	ACT_PRAVB	CRM_ACT_PROD_AVAILABLE_BEFORE	CHAR	3	0	Product available before Visit at check	*
32	RESREAS	☐	ACT_RESREAS	CRM_ACT_KVRESF	CHAR	1	0	Result Reason	*
33	STOCK	☐	ACT_KV_STOCK	ACT_KV_STOCK	DEC	6	0	Number of Products in stocks
34	ACT_RESULT	☐	ACT_KV_RESULT	CRM_ACT_KVRESF	CHAR	1	0	Result	*
35	PANZ	☐	ACT_KV_ZPANZ	ACT_KV_ZPANZ	DEC	3	0	Number of Second placements
36	PAVA	☐	ACT_KV_ZPAVA	CRM_ACT_SDPMT	CHAR	1	0	Second Placement Available	*
37	NRPSHF	☐	ACT_NRPSHF	ACT_NRPSHF	DEC	6	0	Number of Products on Promotion Shelf
38	POSVER	☐	ACT_POSVER	CRM_ACT_VERTICAL_POS_IN_SHELF	CHAR	3	0	vertical position in shelf	*
39	POSHOR	☐	ACT_POSHOR	CRM_ACT_HORIZONT_POS_IN_SHELF	CHAR	3	0	horizontal position in shelf	*
40	NROFFAC	☐	ACT_NROFFAC	ACT_NROFFAC	DEC	4	0	Number of facings
41	FACLEN	☐	ACT_FACLEN	ACT_FACLEN	DEC	6	0	Length of Facing
42	FACWID	☐	ACT_FACWID	ACT_FACWID	DEC	6	0	Width of Facing
43	FACDEP	☐	ACT_FACDEP	ACT_FACDEP	DEC	6	2	Depth of Facing
44	ACT_FACUNIT	☐	ACT_FACUNIT	MEINS	UNIT	3	0	Units of Measure for the Product	*
45	ACT_SPRICE	☐	ACT_SPRICE	ACT_SPRICE	CURR	23	2	Sales Price in store
46	ACT_SPRICE_C	☐	ACT_SPRICE_C	WAERS	CUKY	5	0	Sales Price in store	*
47	ACT_OPRICE	☐	ACT_OPRICE	ACT_OPRICE	CURR	23	2	Order Price in store
48	ACT_OPRICE_C	☐	ACT_OPRICE_C	WAERS	CUKY	5	0	Order Price in store	*
49	ACT_APRICE	☐	ACT_APRICE	ACT_APRICE	CURR	23	2	Promotion Price in Store
50	ACT_APRICE_C	☐	ACT_APRICE_C	WAERS	CUKY	5	0	Promotion Price in Store	*
51	ACT_LBVAL	☐	ACT_LBVAL	ACT_LBVAL	DEC	15	2	Value of Samples
52	SPTSK	☐	SPTSK	SPTSK	DEC	8	3	Special task centre Sht
53	LISTING_FEE	☐	LISTING_FEE	LISTING_FEE	CURR	12	2	Listing Fee
54	LISTING_FEE_C	☐	LISTING_FEE_C	WAERS	CUKY	5	0	Listing Fee	*
55	EDAY_LOW_PRICE	☐	ACT_EDAY_LOW_PRICE	ACT_EDAY_LOW_PRICE	CURR	12	2	Everyday Low Price
56	EDAY_LOW_PRICE_C	☐	ACT_EDAY_LOW_PRICE_C	WAERS	CUKY	5	0	Everyday Low Price	*
57	SENDSTA	☐	ACT_SENDSTA	ACT_SENDSTA	CHAR	1	0	Send Status
58	BATCH_ID	☐	ACT_BATCH_ID	ACT_BATCH_ID	CHAR	10	0	Batch ID
59	PRDHA	☐	ACT_PRDHA	ACT_PRDHA	CHAR	20	0	Product hierarchy
60	.INCLUDE	☐				0	0

History

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