SAP ABAP View CRMV_PROD_FIN05H (View: Changes to Principal History)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM-LAM-MD-FPR (Application Component) Financing Product
     CRM_PRODUCT_FINANCE (Package) Product Master Financial
Basic Data
View Type D Database View 
Database View CRMV_PROD_FIN05H  
Short Description View: Changes to Principal History    
Root table CRM_PROD_FIN05H   Changes to Principal 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 CRM_PROD_FIN05H CRM_PROD_FIN05H
2 COMM_PR_FRG_ROD  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 CRM_PROD_FIN05H CLIENT JL EQ 0 0
2 COMM_PR_FRG_ROD CLIENT JR EQ AND 0 0
3 CRM_PROD_FIN05H FRG_GUID JL EQ 0 0
4 COMM_PR_FRG_ROD FRAGMENT_GUID JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 * CRM_PROD_FIN05H *    
2 CLIENT CRM_PROD_FIN05H CLIENT   MANDT Client
3 FRG_GUID CRM_PROD_FIN05H FRG_GUID   COMT_FRG_GUID Set GUID
4 VALID_TO CRM_PROD_FIN05H VALID_TO   COMT_VALID_TO Valid To (Time Stamp)
5 VALID_FROM CRM_PROD_FIN05H VALID_FROM   COMT_VALID_FROM Valid From (Time Stamp)
6 UPNAME CRM_PROD_FIN05H UPNAME   COMT_UPNAME Name of the User Who Last Changed the Set
7 CFLOW_TYPE_01 CRM_PROD_FIN05H CFLOW_TYPE_01   CRMT_CFLOWTYPE01 Flow Category
8 NO_OF_PERIODS_01 CRM_PROD_FIN05H NO_OF_PERIODS_01   CRMT_FIN_PERIODS01 Number of Periods in Billing Plan
9 PAYMENT_FREQU_01 CRM_PROD_FIN05H PAYMENT_FREQU_01   CRMT_FIN_PAYMENTFR01 Payment Frequency
10 PAYMENT_FORM_01 CRM_PROD_FIN05H PAYMENT_FORM_01   CRMT_FIN_PAYMENTFO01 Payment Form
11 PERCENTAGE_01 CRM_PROD_FIN05H PERCENTAGE_01   CRMT_FINPROD_PROZ01 Percentage Rate
12 RATE_PER_X_01 CRM_PROD_FIN05H RATE_PER_X_01   CRMT_FIN_RATEPERX01 Rate per x
13 TIMERU_FROM_01 CRM_PROD_FIN05H TIMERU_FROM_01   CRMT_FIN_TIMERU_FR01 Date Rule From
14 TIMERU_TO_01 CRM_PROD_FIN05H TIMERU_TO_01   CRMT_FIN_TIMERU_TO01 Date Rule To
15 SETTL_TO_01 CRM_PROD_FIN05H SETTL_TO_01   CRMT_FIN_SETTL_TO_01 To Date
16 FIX_01 CRM_PROD_FIN05H FIX_01   CRMT_FINPROD_FIX01 Fixing
17 DATE_UPD_01 CRM_PROD_FIN05H DATE_UPD_01   CRMT_FIN_DATE_UPD_01 No Date Update
18 CFLOW_TYPE_02 CRM_PROD_FIN05H CFLOW_TYPE_02   CRMT_CFLOWTYPE02 Flow Category
19 NO_OF_PERIODS_02 CRM_PROD_FIN05H NO_OF_PERIODS_02   CRMT_FIN_PERIODS02 Number of Periods in Billing Plan
20 PAYMENT_FREQU_02 CRM_PROD_FIN05H PAYMENT_FREQU_02   CRMT_FIN_PAYMENTFR02 Payment Frequency
21 PAYMENT_FORM_02 CRM_PROD_FIN05H PAYMENT_FORM_02   CRMT_FIN_PAYMENTFO02 Payment Form
22 PERCENTAGE_02 CRM_PROD_FIN05H PERCENTAGE_02   CRMT_FINPROD_PROZ02 Percentage Rate
23 RATE_PER_X_02 CRM_PROD_FIN05H RATE_PER_X_02   CRMT_FIN_RATEPERX02 Rate per x
24 TIMERU_FROM_02 CRM_PROD_FIN05H TIMERU_FROM_02   CRMT_FIN_TIMERU_FR02 Date Rule From
25 TIMERU_TO_02 CRM_PROD_FIN05H TIMERU_TO_02   CRMT_FIN_TIMERU_TO02 Date Rule To
26 SETTL_TO_02 CRM_PROD_FIN05H SETTL_TO_02   CRMT_FIN_SETTL_TO_02 To Date
27 FIX_02 CRM_PROD_FIN05H FIX_02   CRMT_FINPROD_FIX02 Fixing
28 DATE_UPD_02 CRM_PROD_FIN05H DATE_UPD_02   CRMT_FIN_DATE_UPD_02 No Date Update
29 CFLOW_TYPE_03 CRM_PROD_FIN05H CFLOW_TYPE_03   CRMT_CFLOWTYPE03 Flow Category
30 NO_OF_PERIODS_03 CRM_PROD_FIN05H NO_OF_PERIODS_03   CRMT_FIN_PERIODS03 Number of Periods in Billing Plan
31 PAYMENT_FREQU_03 CRM_PROD_FIN05H PAYMENT_FREQU_03   CRMT_FIN_PAYMENTFR03 Payment Frequency
32 PAYMENT_FORM_03 CRM_PROD_FIN05H PAYMENT_FORM_03   CRMT_FIN_PAYMENTFO03 Payment Form
33 PERCENTAGE_03 CRM_PROD_FIN05H PERCENTAGE_03   CRMT_FINPROD_PROZ03 Percentage Rate
34 RATE_PER_X_03 CRM_PROD_FIN05H RATE_PER_X_03   CRMT_FIN_RATEPERX03 Rate per x
35 TIMERU_FROM_03 CRM_PROD_FIN05H TIMERU_FROM_03   CRMT_FIN_TIMERU_FR03 Date Rule From
36 TIMERU_TO_03 CRM_PROD_FIN05H TIMERU_TO_03   CRMT_FIN_TIMERU_TO03 Date Rule To
37 SETTL_TO_03 CRM_PROD_FIN05H SETTL_TO_03   CRMT_FIN_SETTL_TO_03 To Date
38 FIX_03 CRM_PROD_FIN05H FIX_03   CRMT_FINPROD_FIX03 Fixing
39 DATE_UPD_03 CRM_PROD_FIN05H DATE_UPD_03   CRMT_FIN_DATE_UPD_03 No Date Update
40 CFLOW_TYPE_04 CRM_PROD_FIN05H CFLOW_TYPE_04   CRMT_CFLOWTYPE04 Flow Category
41 NO_OF_PERIODS_04 CRM_PROD_FIN05H NO_OF_PERIODS_04   CRMT_FIN_PERIODS04 Number of Periods in Billing Plan
42 PAYMENT_FREQU_04 CRM_PROD_FIN05H PAYMENT_FREQU_04   CRMT_FIN_PAYMENTFR04 Payment Frequency
43 PAYMENT_FORM_04 CRM_PROD_FIN05H PAYMENT_FORM_04   CRMT_FIN_PAYMENTFO04 Payment Form
44 PERCENTAGE_04 CRM_PROD_FIN05H PERCENTAGE_04   CRMT_FINPROD_PROZ04 Percentage Rate
45 RATE_PER_X_04 CRM_PROD_FIN05H RATE_PER_X_04   CRMT_FIN_RATEPERX04 Rate per x
46 TIMERU_FROM_04 CRM_PROD_FIN05H TIMERU_FROM_04   CRMT_FIN_TIMERU_FR04 Date Rule From
47 TIMERU_TO_04 CRM_PROD_FIN05H TIMERU_TO_04   CRMT_FIN_TIMERU_TO04 Date Rule To
48 SETTL_TO_04 CRM_PROD_FIN05H SETTL_TO_04   CRMT_FIN_SETTL_TO_04 To Date
49 FIX_04 CRM_PROD_FIN05H FIX_04   CRMT_FINPROD_FIX04 Fixing
50 DATE_UPD_04 CRM_PROD_FIN05H DATE_UPD_04   CRMT_FIN_DATE_UPD_04 No Date Update
51 CFLOW_TYPE_05 CRM_PROD_FIN05H CFLOW_TYPE_05   CRMT_CFLOWTYPE05 Flow Category
52 NO_OF_PERIODS_05 CRM_PROD_FIN05H NO_OF_PERIODS_05   CRMT_FIN_PERIODS05 Number of Periods in Billing Plan
53 PAYMENT_FREQU_05 CRM_PROD_FIN05H PAYMENT_FREQU_05   CRMT_FIN_PAYMENTFR05 Payment Frequency
54 PAYMENT_FORM_05 CRM_PROD_FIN05H PAYMENT_FORM_05   CRMT_FIN_PAYMENTFO05 Payment Form
55 PERCENTAGE_05 CRM_PROD_FIN05H PERCENTAGE_05   CRMT_FINPROD_PROZ05 Percentage Rate
56 RATE_PER_X_05 CRM_PROD_FIN05H RATE_PER_X_05   CRMT_FIN_RATEPERX05 Rate per x
57 TIMERU_FROM_05 CRM_PROD_FIN05H TIMERU_FROM_05   CRMT_FIN_TIMERU_FR05 Date Rule From
58 TIMERU_TO_05 CRM_PROD_FIN05H TIMERU_TO_05   CRMT_FIN_TIMERU_TO05 Date Rule To
59 SETTL_TO_05 CRM_PROD_FIN05H SETTL_TO_05   CRMT_FIN_SETTL_TO_05 To Date
60 FIX_05 CRM_PROD_FIN05H FIX_05   CRMT_FINPROD_FIX05 Fixing
61 DATE_UPD_05 CRM_PROD_FIN05H DATE_UPD_05   CRMT_FIN_DATE_UPD_05 No Date Update
62 CFLOW_TYPE_06 CRM_PROD_FIN05H CFLOW_TYPE_06   CRMT_CFLOWTYPE06 Flow Category
63 NO_OF_PERIODS_06 CRM_PROD_FIN05H NO_OF_PERIODS_06   CRMT_FIN_PERIODS06 Number of Periods in Billing Plan
64 PAYMENT_FREQU_06 CRM_PROD_FIN05H PAYMENT_FREQU_06   CRMT_FIN_PAYMENTFR06 Payment Frequency
65 PAYMENT_FORM_06 CRM_PROD_FIN05H PAYMENT_FORM_06   CRMT_FIN_PAYMENTFO06 Payment Form
66 PERCENTAGE_06 CRM_PROD_FIN05H PERCENTAGE_06   CRMT_FINPROD_PROZ06 Percentage Rate
67 RATE_PER_X_06 CRM_PROD_FIN05H RATE_PER_X_06   CRMT_FIN_RATEPERX06 Rate per x
68 TIMERU_FROM_06 CRM_PROD_FIN05H TIMERU_FROM_06   CRMT_FIN_TIMERU_FR06 Date Rule From
69 TIMERU_TO_06 CRM_PROD_FIN05H TIMERU_TO_06   CRMT_FIN_TIMERU_TO06 Date Rule To
70 SETTL_TO_06 CRM_PROD_FIN05H SETTL_TO_06   CRMT_FIN_SETTL_TO_06 To Date
71 FIX_06 CRM_PROD_FIN05H FIX_06   CRMT_FINPROD_FIX06 Fixing
72 DATE_UPD_06 CRM_PROD_FIN05H DATE_UPD_06   CRMT_FIN_DATE_UPD_06 No Date Update
73 PRODUCT_GUID COMM_PR_FRG_ROD PRODUCT_GUID   COMT_PRODUCT_GUID Internal Unique ID of Product
74 FRAGMENT_TYPE COMM_PR_FRG_ROD FRAGMENT_TYPE   COMT_FRGTYPE_GUID Internal Key of a Set Type
75 SALES_ORG COMM_PR_FRG_ROD SALES_ORG   CRMT_SALES_ORG Sales Organization ID
76 DISTR_CHAN COMM_PR_FRG_ROD DISTR_CHAN   CRMT_DISTRIBUTION_CHANNEL Distribution Channel
                 
Maintenance Status
Access
  read only
  read and change
  Time-dependent views: like U, validity data like ' '
  read, change, delete and insert
Delivery Class      
Data Browser/Table View Maintenance    Display/Maintenance Allowed with Restrictions  
History
Last changed by/on SAP  20130604 
SAP Release Created in 30A