SAP ABAP Table CRMT_PRP_PROD_IH_DU (Partner/Product Ranges: Prod. Refs. History; Database Update)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM-MD-PPR (Application Component) Partner/Product Range
     CRM_PRP_PRODUCTS (Package) Partner/Product Ranges (PPRs): Products
Basic Data
Table Category INTTAB    Structure 
Structure CRMT_PRP_PROD_IH_DU   Table Relationship Diagram
Short Description Partner/Product Ranges: Prod. Refs. History; Database Update    
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   Partner/Product Ranges(PPRs): Produc Refs.; Database Update  
2 .INCLUDE       0   0   PPR Product References plus Extension Fields  
3 .INCLUDE       0   0   Partner/Product Range Item-Product Assignment  
4 .INCLUDE       0   0   PRP products: primary key fields  
5 CLIENT MANDT MANDT CLNT 3   0   Client *
6 GUID CRMT_PRP_GUID SYSUUID RAW 16   0   Internal, Unique Identifier for PPR Objects  
7 .INCLUDE       0   0   PRP products: fields manipulated externally  
8 TYPE CRMT_PRP_REFERENCE_TYPE CRM_PRP_REFERENCE_TYPE CHAR 2   0   Reference Type of the PPR CRMC_PRP_REFTYP
9 .INCLUDE       0   0   PRP products: fields manipulated internally  
10 PRODUCT_REF_GUID COMT_PRODUCT_GUID SYSUUID RAW 16   0   Internal Unique ID of Product  
11 PARENT_GUID CRMT_PRP_GUID SYSUUID RAW 16   0   Internal, Unique Identifier for PPR Objects  
12 READ_EXTENSIONS CRMT_PRP_PROD_I_EXTENSIONS CRM_BOOLEAN CHAR 1   0   PPRs: Product Reference has Extensions  
13 EXT_AVAILABLE CRMT_PRP_EXT_AVAILABLE CRM_BOOLEAN CHAR 1   0   Flag to label, if a PPR Obj. Ext. (EXT_H,EXT_I) is available  
14 VP_AVAILABLE CRMT_PRP_PROD_VAL_PERIOD CRM_BOOLEAN CHAR 1   0   Flag to label if a product entry has an own validity period  
15 PROP_RELEVANT CRMT_PRP_PRD_PROPOSAL CRM_BOOLEAN CHAR 1   0   Relevant for Item Proposal (Valid Only for Listing)  
16 .INCLUDE       0   0   Partner/Product Ranges (PPRs): Administrative Data  
17 VALID_FROM COMT_VALID_FROM BCOS_TSTMP DEC 15   0   Valid From (Time Stamp)  
18 VALID_TO COMT_VALID_TO BCOS_TSTMP DEC 15   0   Valid To (Time Stamp)  
19 UPNAME COMT_UPNAME UNAME CHAR 12   0   Name of the User Who Last Changed the Set  
20 HISTEX COMT_HISTEX COM_BOOLEAN CHAR 1   0   History Exists  
21 NUMBER_INT CRMT_PRP_PROD_NO NUMC10 NUMC 10   0   Number for Arranging PPR Products Within the same Item  
22 SETTYPE_ID CRMT_PRP_SETTYPE_ID CHAR16 CHAR 16   0   PPR Set Type ID for PPR Object Extensions  
23 .INCLUDE       0   0   PPR product ref extension: fields manipulated externally  
24 BC_PRODUCT_DESCR COMT_PRSHTEXTX PRSHTEXT40 CHAR 40   0   Product Description  
25 BC_CAT_ID CHAR20 CHAR20 CHAR 20   0   Char 20  
26 BC_CAT_ITEM_ID CHAR40 CHAR40 CHAR 40   0   Character field of length 40  
27 BC_SUPPL_PROD_ID CRMT_ITEM_DESCR_PARTNER PRSHTEXT40 CHAR 40   0   Product Number of Business Partner  
28 PCAT_CTY_GUID COMT_PCAT_CTY_GUID SYSUUID RAW 16   0   GUID of a Product Catalog Area  
29 .INCLUDE       0   0   PRP products for BCs: fields manipulated internally  
30 CATEGORY_GUID COMT_PRODUCT_GUID SYSUUID RAW 16   0   Internal Unique ID of Product  
31 .INCLUDE       0   0   PPR rules: fields manipulated externally  
32 RULE_ID CRMT_PRP_RULE_ID CHAR8 CHAR 8   0   Identifier for a Partner/Product Range (PPR) Rule  
33 .INCLUDE       0   0   PPR rules: fields manipulated internally  
34 RULE_TYPE CRMT_PRP_RULE_TYPE CRM_PRP_RULE_TYPE CHAR 2   0   PPR Rule Type  
35 PARAMETER_ID CRMT_PRP_PARAMETER_ID CHAR8 CHAR 8   0   ID for PPR Rule Parameter  
36 .INCLUDE       0   0   Structure for Non-Existing ID Fields  
37 NON_EXISTING_ID1 COMT_ALTID_VALUE_UI COM_ALTID_VALUE_SHORT CHAR 54   0   Value of a Product ID or Individual Object  
38 NON_EXISTING_ID2 COMT_ALTID_VALUE_UI COM_ALTID_VALUE_SHORT CHAR 54   0   Value of a Product ID or Individual Object  
39 NON_EXISTING_ID3 COMT_ALTID_VALUE_UI COM_ALTID_VALUE_SHORT CHAR 54   0   Value of a Product ID or Individual Object  
40 NON_EXISTING_ID4 COMT_ALTID_VALUE_UI COM_ALTID_VALUE_SHORT CHAR 54   0   Value of a Product ID or Individual Object  
41 .INCLUDE       0   0   PPR Validity Period for Prod.: Fields Manipulated Externally  
42 LISTED_FROM CRMT_PRP_TS_LOW BCOS_TSTMP DEC 15   0   PPR Validity Period: Start Date  
43 LISTED_TO CRMT_PRP_TS_HIGH BCOS_TSTMP DEC 15   0   PPR Validity Period: End Date  
44 CONF_PROD_GUID COMT_PRODUCT_GUID SYSUUID RAW 16   0   Internal Unique ID of Product  
45 CONF_PROD_ID COMT_PRODUCT_ID COM_PRODUCT_ID CHAR 40   0   Product ID  
46 .INCLUDE       0   0   Two coomon fields for PPR history tables  
47 ANCESTOR_GUID CRMT_PRP_GUID SYSUUID RAW 16   0   Internal, Unique Identifier for PPR Objects  
48 UPDATE_TYPE UPDATE_TYPE UPDATE_TYPE CHAR 1   0   Type of Change  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CRMT_PRP_PROD_IH_DU TYPE CRMC_PRP_REFTYP REFERENCE_TYPE KEY C CN
History
Last changed by/on SAP  20100421 
SAP Release Created in 30A