SAP ABAP Table PRP_PLNSETTYPE_01P_ALV (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_01P_ALV   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 .INCLUDE       0   0   Products Attribute for Planogram PPR  
2 OBJECT_KEY COMT_BSP_OBJECTKEY   CHAR 100   0   Object Key  
3 .INCLUDE       0   0   PPR Product References, Products: Detail UI  
4 .INCLUDE       0   0   Administration fields for the PPR interaction layer  
5 GUID CRMT_PRP_GUID SYSUUID RAW 16   0   Internal, Unique Identifier for PPR Objects  
6 HANDLE CRMT_PRP_HANDLE   NUMC 10   0   Handle  
7 ITEM_NO CRMT_PRP_PROD_NO NUMC10 NUMC 10   0   Number for Arranging PPR Products Within the same Item  
8 PROCESSING_MODE CRMT_MODE CRM_MODE CHAR 1   0   Processing Mode of Transaction  
9 TYPE CRMT_PRP_REFERENCE_TYPE CRM_PRP_REFERENCE_TYPE CHAR 2   0   Reference Type of the PPR *
10 PRODUCT_TYPE COMT_PRODUCT_TYPE COM_PRODUCT_TYPE CHAR 2   0   Product Type COMC_PR_TYPE
11 PRODUCT_TYPE_TEXT COMT_PR_TYPE_DESC TEXT40 CHAR 40   0   Product Type Description  
12 PRODUCT_GUID COMT_PRODUCT_GUID SYSUUID RAW 16   0   Internal Unique ID of Product  
13 PRODUCT_ID COMT_ALTID_VALUE_UI COM_ALTID_VALUE_SHORT CHAR 54   0   Value of a Product ID or Individual Object  
14 PRODUCT_ID_TYPE COMT_ALTID_TYPE CHAR16 CHAR 16   0   ID Type for Alternative IDs  
15 PRODUCT_ID_TYPE_TEXT COMT_ALTID_TYPE_TEXT COMT_TXT40 CHAR 40   0   Description of Alternative ID Type  
16 ID_TYPE_PROFILE COMT_ALTID_PROFILE COMT_ALTID_PROFILE CHAR 30   0   Profile for Alternative IDs  
17 CONFIG COMT_PRODUCT_CONFIGURABLE COM_PRODUCT_CONFIGURABLE CHAR 1   0   Determines Whether a Product Is Configurable *
18 SHORT_TEXT COMT_PRSHTEXTX PRSHTEXT40 CHAR 40   0   Product Description  
19 LOGSYS COMT_LOGSYS LOGSYS CHAR 10   0   Original System *
20 .INCLUDE       0   0   Listing Validity Period on Item Level  
21 LISTED_FROM CRMT_PRP_DATE_VALID_FROM DATE DATS 8   0   Start Date of Validity Period  
22 LISTED_TO CRMT_PRP_DATE_VALID_TO DATE DATS 8   0   End Date of Validity Period  
23 .INCLUDE       0   0   Fields for Dynamic Navigation Targets in the PC-UI  
24 CRM_OBJECT_TYPE CRMT_PRT_OTYPE CRMT_PRT_OTYPE CHAR 20   0   Object Type for Navigation *
25 CRM_NAV_METHOD CRMT_PRT_MTD CRMT_PRT_MTD CHAR 20   0   Method for Navigation *
26 NAV_OBJECT_KEY CRMT_BSP_OBJECTKEY   CHAR 100   0   Object Key  
27 .INCLUDE       0   0   Products Attribute for Planogram PPR  
28 BREIT ACT_BREIT ACT_BREIT QUAN 13   0   Width of the Product or of the Packaging  
29 BREIT_U ACT_BREIT_U MEINS UNIT 3   0   Width of the Product or of the Packaging *
30 BREIT_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
31 BRGEW ACT_BRGEW ACT_BRGEW QUAN 15   3   Gross Weight  
32 BRGEW_U ACT_BRGEW_U MEINS UNIT 3   0   Gross Weight *
33 BRGEW_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
34 VOLUM ACT_VOLUM ACT_VOLUM QUAN 15   0   Volume  
35 VOLUM_U ACT_VOLUM_U MEINS UNIT 3   0   Volume *
36 VOLUM_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
37 VOLEH ACT_VOLEH MEINS UNIT 3   0   Unit for the Volume *
38 VOLEH_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
39 NROFSAM ACT_NROFSAM ACT_NROFSAM QUAN 4   0   Number of samples  
40 NROFSAM_U ACT_NROFSAM_U MEINS UNIT 3   0   Number of samples *
41 NROFSAM_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
42 STATUS ACT_PRDS_STATUS ACT_PRDS_STATUS CHAR 3   0   Status of documented product  
43 STATUS_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
44 SAMTOBESENT ACT_SAMTOBESENT ACT_SAMTOBESENT CHAR 1   0   Product Request  
45 SAMTOBESENT_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
46 SAMRETURN ACT_SAMRETURN ACT_SAMRETURN CHAR 1   0   Flag for Returns  
47 SAMRETURN_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
48 DISCUSS ACT_DISCUSS ACT_DISCUSS CHAR 1   0   Discussed  
49 DISCUSS_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
50 HOEHE ACT_HOEHE ACT_HOEHE QUAN 13   0   Height of the Product or of the Packaging  
51 HOEHE_U ACT_HOEHE_U MEINS UNIT 3   0   Height of the Product or of the Packagin *
52 HOEHE_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
53 PRAVA ACT_PRAVA CRM_ACT_PROD_AVAILABLE_AFTER CHAR 3   0   Product available after visit at checkou *
54 PRAVA_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
55 PRAVB ACT_PRAVB CRM_ACT_PROD_AVAILABLE_BEFORE CHAR 3   0   Product available before Visit at check *
56 PRAVB_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
57 RESREAS ACT_RESREAS CRM_ACT_KVRESF CHAR 1   0   Result Reason *
58 RESREAS_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
59 STOCK ACT_KV_STOCK ACT_KV_STOCK DEC 6   0   Number of Products in stocks  
60 STOCK_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
61 ACT_RESULT ACT_KV_RESULT CRM_ACT_KVRESF CHAR 1   0   Result *
62 ACT_RESULT_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
63 PANZ ACT_KV_ZPANZ ACT_KV_ZPANZ DEC 3   0   Number of Second placements  
64 PANZ_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
65 PAVA ACT_KV_ZPAVA CRM_ACT_SDPMT CHAR 1   0   Second Placement Available *
66 PAVA_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
67 NRPSHF ACT_NRPSHF ACT_NRPSHF DEC 6   0   Number of Products on Promotion Shelf  
68 NRPSHF_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
69 POSVER ACT_POSVER CRM_ACT_VERTICAL_POS_IN_SHELF CHAR 3   0   vertical position in shelf *
70 POSVER_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
71 POSHOR ACT_POSHOR CRM_ACT_HORIZONT_POS_IN_SHELF CHAR 3   0   horizontal position in shelf *
72 POSHOR_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
73 NROFFAC ACT_NROFFAC ACT_NROFFAC DEC 4   0   Number of facings  
74 NROFFAC_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
75 FACLEN ACT_FACLEN ACT_FACLEN DEC 6   0   Length of Facing  
76 FACLEN_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
77 FACWID ACT_FACWID ACT_FACWID DEC 6   0   Width of Facing  
78 FACWID_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
79 FACDEP ACT_FACDEP ACT_FACDEP DEC 6   2   Depth of Facing  
80 FACDEP_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
81 ACT_FACUNIT ACT_FACUNIT MEINS UNIT 3   0   Units of Measure for the Product *
82 ACT_FACUNIT_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
83 ACT_SPRICE ACT_SPRICE ACT_SPRICE CURR 23   2   Sales Price in store  
84 ACT_SPRICE_C ACT_SPRICE_C WAERS CUKY 5   0   Sales Price in store *
85 ACT_SPRICE_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
86 ACT_OPRICE ACT_OPRICE ACT_OPRICE CURR 23   2   Order Price in store  
87 ACT_OPRICE_C ACT_OPRICE_C WAERS CUKY 5   0   Order Price in store *
88 ACT_OPRICE_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
89 ACT_APRICE ACT_APRICE ACT_APRICE CURR 23   2   Promotion Price in Store  
90 ACT_APRICE_C ACT_APRICE_C WAERS CUKY 5   0   Promotion Price in Store *
91 ACT_APRICE_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
92 ACT_LBVAL ACT_LBVAL ACT_LBVAL DEC 15   2   Value of Samples  
93 ACT_LBVAL_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
94 SPTSK SPTSK SPTSK DEC 8   3   Special task centre Sht  
95 SPTSK_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
96 LISTING_FEE LISTING_FEE LISTING_FEE CURR 12   2   Listing Fee  
97 LISTING_FEE_C LISTING_FEE_C WAERS CUKY 5   0   Listing Fee *
98 LISTING_FEE_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
99 EDAY_LOW_PRICE ACT_EDAY_LOW_PRICE ACT_EDAY_LOW_PRICE CURR 12   2   Everyday Low Price  
100 EDAY_LOW_PRICE_C ACT_EDAY_LOW_PRICE_C WAERS CUKY 5   0   Everyday Low Price *
101 EDAY_LOW_PRICE_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
102 SENDSTA ACT_SENDSTA ACT_SENDSTA CHAR 1   0   Send Status  
103 SENDSTA_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
104 BATCH_ID ACT_BATCH_ID ACT_BATCH_ID CHAR 10   0   Batch ID  
105 BATCH_ID_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
106 PRDHA ACT_PRDHA ACT_PRDHA CHAR 20   0   Product hierarchy  
107 PRDHA_DESC COMT_ATTR_VAL_TEXT DDTEXT CHAR 60   0   Description of Single Value  
108 .INCLUDE       0   0    
109 CELL LVC_T_STYL   TTYP 0   0    
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 PRP_PLNSETTYPE_01P_ALV PRODUCT_TYPE COMC_PR_TYPE PRODUCT_TYPE KEY 1 1
History
Last changed by/on SAP  20050627 
SAP Release Created in 500