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