SAP ABAP Table PRP_PLNSETTYPE_72P_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_72P_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 Key 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 Product Catalog Area  
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_PROD_NO NUMC10 NUMC 10   0   Number for Arranging PPR Products 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 PCAT_HDR_ID COMT_PCAT_ID COM_PCAT_OBJECTID CHAR 30   0   Product Catalog Number  
10 PCAT_HDR_ID_TEXT COMT_DESCRIPTION TEXT40 CHAR 40   0   Description  
11 PCAT_TYPE COMT_PCAT_TYPE COM_PCAT_TYPE CHAR 4   0   Catalog Type COMC_PCAT_TP
12 PCAT_TYPE_TEXT COMT_DESCRIPTION TEXT40 CHAR 40   0   Description  
13 PCAT_CTY COMT_PCAT_CTY_ID COM_PCAT_OBJECTID CHAR 30   0   Catalog Area Number  
14 PCAT_CTY_TEXT COMT_DESCRIPTION TEXT40 CHAR 40   0   Description  
15 PCAT_CTY_GUID COMT_PCAT_GUID SYSUUID RAW 16   0   Object GUID  
16 .INCLUDE       0   0   Products Attribute for Planogram PPR  
17 BREIT ACT_BREIT ACT_BREIT QUAN 13   0   Width of the Product or of the Packaging  
18 BREIT_U ACT_BREIT_U MEINS UNIT 3   0   Width of the Product or of the Packaging *
19 BREIT_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
20 BRGEW ACT_BRGEW ACT_BRGEW QUAN 15   3   Gross Weight  
21 BRGEW_U ACT_BRGEW_U MEINS UNIT 3   0   Gross Weight *
22 BRGEW_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
23 VOLUM ACT_VOLUM ACT_VOLUM QUAN 15   0   Volume  
24 VOLUM_U ACT_VOLUM_U MEINS UNIT 3   0   Volume *
25 VOLUM_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
26 VOLEH ACT_VOLEH MEINS UNIT 3   0   Unit for the Volume *
27 VOLEH_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
28 NROFSAM ACT_NROFSAM ACT_NROFSAM QUAN 4   0   Number of samples  
29 NROFSAM_U ACT_NROFSAM_U MEINS UNIT 3   0   Number of samples *
30 NROFSAM_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
31 STATUS ACT_PRDS_STATUS ACT_PRDS_STATUS CHAR 3   0   Status of documented product  
32 STATUS_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
33 SAMTOBESENT ACT_SAMTOBESENT ACT_SAMTOBESENT CHAR 1   0   Product Request  
34 SAMTOBESENT_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
35 SAMRETURN ACT_SAMRETURN ACT_SAMRETURN CHAR 1   0   Flag for Returns  
36 SAMRETURN_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
37 DISCUSS ACT_DISCUSS ACT_DISCUSS CHAR 1   0   Discussed  
38 DISCUSS_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
39 HOEHE ACT_HOEHE ACT_HOEHE QUAN 13   0   Height of the Product or of the Packaging  
40 HOEHE_U ACT_HOEHE_U MEINS UNIT 3   0   Height of the Product or of the Packagin *
41 HOEHE_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
42 PRAVA ACT_PRAVA CRM_ACT_PROD_AVAILABLE_AFTER CHAR 3   0   Product available after visit at checkou *
43 PRAVA_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
44 PRAVB ACT_PRAVB CRM_ACT_PROD_AVAILABLE_BEFORE CHAR 3   0   Product available before Visit at check *
45 PRAVB_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
46 RESREAS ACT_RESREAS CRM_ACT_KVRESF CHAR 1   0   Result Reason *
47 RESREAS_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
48 STOCK ACT_KV_STOCK ACT_KV_STOCK DEC 6   0   Number of Products in stocks  
49 STOCK_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
50 ACT_RESULT ACT_KV_RESULT CRM_ACT_KVRESF CHAR 1   0   Result *
51 ACT_RESULT_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
52 PANZ ACT_KV_ZPANZ ACT_KV_ZPANZ DEC 3   0   Number of Second placements  
53 PANZ_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
54 PAVA ACT_KV_ZPAVA CRM_ACT_SDPMT CHAR 1   0   Second Placement Available *
55 PAVA_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
56 NRPSHF ACT_NRPSHF ACT_NRPSHF DEC 6   0   Number of Products on Promotion Shelf  
57 NRPSHF_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
58 POSVER ACT_POSVER CRM_ACT_VERTICAL_POS_IN_SHELF CHAR 3   0   vertical position in shelf *
59 POSVER_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
60 POSHOR ACT_POSHOR CRM_ACT_HORIZONT_POS_IN_SHELF CHAR 3   0   horizontal position in shelf *
61 POSHOR_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
62 NROFFAC ACT_NROFFAC ACT_NROFFAC DEC 4   0   Number of facings  
63 NROFFAC_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
64 FACLEN ACT_FACLEN ACT_FACLEN DEC 6   0   Length of Facing  
65 FACLEN_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
66 FACWID ACT_FACWID ACT_FACWID DEC 6   0   Width of Facing  
67 FACWID_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
68 FACDEP ACT_FACDEP ACT_FACDEP DEC 6   2   Depth of Facing  
69 FACDEP_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
70 ACT_FACUNIT ACT_FACUNIT MEINS UNIT 3   0   Units of Measure for the Product *
71 ACT_FACUNIT_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
72 ACT_SPRICE ACT_SPRICE ACT_SPRICE CURR 23   2   Sales Price in store  
73 ACT_SPRICE_C ACT_SPRICE_C WAERS CUKY 5   0   Sales Price in store *
74 ACT_SPRICE_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
75 ACT_OPRICE ACT_OPRICE ACT_OPRICE CURR 23   2   Order Price in store  
76 ACT_OPRICE_C ACT_OPRICE_C WAERS CUKY 5   0   Order Price in store *
77 ACT_OPRICE_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
78 ACT_APRICE ACT_APRICE ACT_APRICE CURR 23   2   Promotion Price in Store  
79 ACT_APRICE_C ACT_APRICE_C WAERS CUKY 5   0   Promotion Price in Store *
80 ACT_APRICE_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
81 ACT_LBVAL ACT_LBVAL ACT_LBVAL DEC 15   2   Value of Samples  
82 ACT_LBVAL_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
83 SPTSK SPTSK SPTSK DEC 8   3   Special task centre Sht  
84 SPTSK_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
85 LISTING_FEE LISTING_FEE LISTING_FEE CURR 12   2   Listing Fee  
86 LISTING_FEE_C LISTING_FEE_C WAERS CUKY 5   0   Listing Fee *
87 LISTING_FEE_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
88 EDAY_LOW_PRICE ACT_EDAY_LOW_PRICE ACT_EDAY_LOW_PRICE CURR 12   2   Everyday Low Price  
89 EDAY_LOW_PRICE_C ACT_EDAY_LOW_PRICE_C WAERS CUKY 5   0   Everyday Low Price *
90 EDAY_LOW_PRICE_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
91 SENDSTA ACT_SENDSTA ACT_SENDSTA CHAR 1   0   Send Status  
92 SENDSTA_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
93 BATCH_ID ACT_BATCH_ID ACT_BATCH_ID CHAR 10   0   Batch ID  
94 BATCH_ID_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
95 PRDHA ACT_PRDHA ACT_PRDHA CHAR 20   0   Product hierarchy  
96 PRDHA_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
97 .INCLUDE       0   0    
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 PRP_PLNSETTYPE_72P_UI PCAT_TYPE COMC_PCAT_TP CLIENT REF 1 CN
History
Last changed by/on SAP  20050311 
SAP Release Created in 500