SAP ABAP View CRMV_PROD_FIN05 (View: Changes to Principal)
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_FIN05  
Short Description View: Changes to Principal    
Root table CRM_PROD_FIN05   Changes to Principal 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 CRM_PROD_FIN05 CRM_PROD_FIN05
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_FIN05 CLIENT JL EQ 0 0
2 COMM_PR_FRG_ROD CLIENT JR EQ AND 0 0
3 CRM_PROD_FIN05 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_FIN05 *    
2 CLIENT CRM_PROD_FIN05 CLIENT   MANDT Client
3 FRG_GUID CRM_PROD_FIN05 FRG_GUID   COMT_FRG_GUID Set GUID
4 VALID_FROM CRM_PROD_FIN05 VALID_FROM   COMT_VALID_FROM Valid From (Time Stamp)
5 VALID_TO CRM_PROD_FIN05 VALID_TO   COMT_VALID_TO Valid To (Time Stamp)
6 UPNAME CRM_PROD_FIN05 UPNAME   COMT_UPNAME Name of the User Who Last Changed the Set
7 HISTEX CRM_PROD_FIN05 HISTEX   COMT_HISTEX History Exists
8 LOGSYS CRM_PROD_FIN05 LOGSYS   COMT_LOGSYS Original System
9 CFLOW_TYPE_01 CRM_PROD_FIN05 CFLOW_TYPE_01   CRMT_CFLOWTYPE01 Flow Category
10 NO_OF_PERIODS_01 CRM_PROD_FIN05 NO_OF_PERIODS_01   CRMT_FIN_PERIODS01 Number of Periods in Billing Plan
11 PAYMENT_FREQU_01 CRM_PROD_FIN05 PAYMENT_FREQU_01   CRMT_FIN_PAYMENTFR01 Payment Frequency
12 PAYMENT_FORM_01 CRM_PROD_FIN05 PAYMENT_FORM_01   CRMT_FIN_PAYMENTFO01 Payment Form
13 PERCENTAGE_01 CRM_PROD_FIN05 PERCENTAGE_01   CRMT_FINPROD_PROZ01 Percentage Rate
14 RATE_PER_X_01 CRM_PROD_FIN05 RATE_PER_X_01   CRMT_FIN_RATEPERX01 Rate per x
15 TIMERU_FROM_01 CRM_PROD_FIN05 TIMERU_FROM_01   CRMT_FIN_TIMERU_FR01 Date Rule From
16 TIMERU_TO_01 CRM_PROD_FIN05 TIMERU_TO_01   CRMT_FIN_TIMERU_TO01 Date Rule To
17 SETTL_TO_01 CRM_PROD_FIN05 SETTL_TO_01   CRMT_FIN_SETTL_TO_01 To Date
18 FIX_01 CRM_PROD_FIN05 FIX_01   CRMT_FINPROD_FIX01 Fixing
19 DATE_UPD_01 CRM_PROD_FIN05 DATE_UPD_01   CRMT_FIN_DATE_UPD_01 No Date Update
20 CFLOW_TYPE_02 CRM_PROD_FIN05 CFLOW_TYPE_02   CRMT_CFLOWTYPE02 Flow Category
21 NO_OF_PERIODS_02 CRM_PROD_FIN05 NO_OF_PERIODS_02   CRMT_FIN_PERIODS02 Number of Periods in Billing Plan
22 PAYMENT_FREQU_02 CRM_PROD_FIN05 PAYMENT_FREQU_02   CRMT_FIN_PAYMENTFR02 Payment Frequency
23 PAYMENT_FORM_02 CRM_PROD_FIN05 PAYMENT_FORM_02   CRMT_FIN_PAYMENTFO02 Payment Form
24 PERCENTAGE_02 CRM_PROD_FIN05 PERCENTAGE_02   CRMT_FINPROD_PROZ02 Percentage Rate
25 RATE_PER_X_02 CRM_PROD_FIN05 RATE_PER_X_02   CRMT_FIN_RATEPERX02 Rate per x
26 TIMERU_FROM_02 CRM_PROD_FIN05 TIMERU_FROM_02   CRMT_FIN_TIMERU_FR02 Date Rule From
27 TIMERU_TO_02 CRM_PROD_FIN05 TIMERU_TO_02   CRMT_FIN_TIMERU_TO02 Date Rule To
28 SETTL_TO_02 CRM_PROD_FIN05 SETTL_TO_02   CRMT_FIN_SETTL_TO_02 To Date
29 FIX_02 CRM_PROD_FIN05 FIX_02   CRMT_FINPROD_FIX02 Fixing
30 DATE_UPD_02 CRM_PROD_FIN05 DATE_UPD_02   CRMT_FIN_DATE_UPD_02 No Date Update
31 CFLOW_TYPE_03 CRM_PROD_FIN05 CFLOW_TYPE_03   CRMT_CFLOWTYPE03 Flow Category
32 NO_OF_PERIODS_03 CRM_PROD_FIN05 NO_OF_PERIODS_03   CRMT_FIN_PERIODS03 Number of Periods in Billing Plan
33 PAYMENT_FREQU_03 CRM_PROD_FIN05 PAYMENT_FREQU_03   CRMT_FIN_PAYMENTFR03 Payment Frequency
34 PAYMENT_FORM_03 CRM_PROD_FIN05 PAYMENT_FORM_03   CRMT_FIN_PAYMENTFO03 Payment Form
35 PERCENTAGE_03 CRM_PROD_FIN05 PERCENTAGE_03   CRMT_FINPROD_PROZ03 Percentage Rate
36 RATE_PER_X_03 CRM_PROD_FIN05 RATE_PER_X_03   CRMT_FIN_RATEPERX03 Rate per x
37 TIMERU_FROM_03 CRM_PROD_FIN05 TIMERU_FROM_03   CRMT_FIN_TIMERU_FR03 Date Rule From
38 TIMERU_TO_03 CRM_PROD_FIN05 TIMERU_TO_03   CRMT_FIN_TIMERU_TO03 Date Rule To
39 SETTL_TO_03 CRM_PROD_FIN05 SETTL_TO_03   CRMT_FIN_SETTL_TO_03 To Date
40 FIX_03 CRM_PROD_FIN05 FIX_03   CRMT_FINPROD_FIX03 Fixing
41 DATE_UPD_03 CRM_PROD_FIN05 DATE_UPD_03   CRMT_FIN_DATE_UPD_03 No Date Update
42 CFLOW_TYPE_04 CRM_PROD_FIN05 CFLOW_TYPE_04   CRMT_CFLOWTYPE04 Flow Category
43 NO_OF_PERIODS_04 CRM_PROD_FIN05 NO_OF_PERIODS_04   CRMT_FIN_PERIODS04 Number of Periods in Billing Plan
44 PAYMENT_FREQU_04 CRM_PROD_FIN05 PAYMENT_FREQU_04   CRMT_FIN_PAYMENTFR04 Payment Frequency
45 PAYMENT_FORM_04 CRM_PROD_FIN05 PAYMENT_FORM_04   CRMT_FIN_PAYMENTFO04 Payment Form
46 PERCENTAGE_04 CRM_PROD_FIN05 PERCENTAGE_04   CRMT_FINPROD_PROZ04 Percentage Rate
47 RATE_PER_X_04 CRM_PROD_FIN05 RATE_PER_X_04   CRMT_FIN_RATEPERX04 Rate per x
48 TIMERU_FROM_04 CRM_PROD_FIN05 TIMERU_FROM_04   CRMT_FIN_TIMERU_FR04 Date Rule From
49 TIMERU_TO_04 CRM_PROD_FIN05 TIMERU_TO_04   CRMT_FIN_TIMERU_TO04 Date Rule To
50 SETTL_TO_04 CRM_PROD_FIN05 SETTL_TO_04   CRMT_FIN_SETTL_TO_04 To Date
51 FIX_04 CRM_PROD_FIN05 FIX_04   CRMT_FINPROD_FIX04 Fixing
52 DATE_UPD_04 CRM_PROD_FIN05 DATE_UPD_04   CRMT_FIN_DATE_UPD_04 No Date Update
53 CFLOW_TYPE_05 CRM_PROD_FIN05 CFLOW_TYPE_05   CRMT_CFLOWTYPE05 Flow Category
54 NO_OF_PERIODS_05 CRM_PROD_FIN05 NO_OF_PERIODS_05   CRMT_FIN_PERIODS05 Number of Periods in Billing Plan
55 PAYMENT_FREQU_05 CRM_PROD_FIN05 PAYMENT_FREQU_05   CRMT_FIN_PAYMENTFR05 Payment Frequency
56 PAYMENT_FORM_05 CRM_PROD_FIN05 PAYMENT_FORM_05   CRMT_FIN_PAYMENTFO05 Payment Form
57 PERCENTAGE_05 CRM_PROD_FIN05 PERCENTAGE_05   CRMT_FINPROD_PROZ05 Percentage Rate
58 RATE_PER_X_05 CRM_PROD_FIN05 RATE_PER_X_05   CRMT_FIN_RATEPERX05 Rate per x
59 TIMERU_FROM_05 CRM_PROD_FIN05 TIMERU_FROM_05   CRMT_FIN_TIMERU_FR05 Date Rule From
60 TIMERU_TO_05 CRM_PROD_FIN05 TIMERU_TO_05   CRMT_FIN_TIMERU_TO05 Date Rule To
61 SETTL_TO_05 CRM_PROD_FIN05 SETTL_TO_05   CRMT_FIN_SETTL_TO_05 To Date
62 FIX_05 CRM_PROD_FIN05 FIX_05   CRMT_FINPROD_FIX05 Fixing
63 DATE_UPD_05 CRM_PROD_FIN05 DATE_UPD_05   CRMT_FIN_DATE_UPD_05 No Date Update
64 CFLOW_TYPE_06 CRM_PROD_FIN05 CFLOW_TYPE_06   CRMT_CFLOWTYPE06 Flow Category
65 NO_OF_PERIODS_06 CRM_PROD_FIN05 NO_OF_PERIODS_06   CRMT_FIN_PERIODS06 Number of Periods in Billing Plan
66 PAYMENT_FREQU_06 CRM_PROD_FIN05 PAYMENT_FREQU_06   CRMT_FIN_PAYMENTFR06 Payment Frequency
67 PAYMENT_FORM_06 CRM_PROD_FIN05 PAYMENT_FORM_06   CRMT_FIN_PAYMENTFO06 Payment Form
68 PERCENTAGE_06 CRM_PROD_FIN05 PERCENTAGE_06   CRMT_FINPROD_PROZ06 Percentage Rate
69 RATE_PER_X_06 CRM_PROD_FIN05 RATE_PER_X_06   CRMT_FIN_RATEPERX06 Rate per x
70 TIMERU_FROM_06 CRM_PROD_FIN05 TIMERU_FROM_06   CRMT_FIN_TIMERU_FR06 Date Rule From
71 TIMERU_TO_06 CRM_PROD_FIN05 TIMERU_TO_06   CRMT_FIN_TIMERU_TO06 Date Rule To
72 SETTL_TO_06 CRM_PROD_FIN05 SETTL_TO_06   CRMT_FIN_SETTL_TO_06 To Date
73 FIX_06 CRM_PROD_FIN05 FIX_06   CRMT_FINPROD_FIX06 Fixing
74 DATE_UPD_06 CRM_PROD_FIN05 DATE_UPD_06   CRMT_FIN_DATE_UPD_06 No Date Update
75 PRODUCT_GUID COMM_PR_FRG_ROD PRODUCT_GUID   COMT_PRODUCT_GUID Internal Unique ID of Product
76 FRAGMENT_TYPE COMM_PR_FRG_ROD FRAGMENT_TYPE   COMT_FRGTYPE_GUID Internal Key of a Set Type
77 SALES_ORG COMM_PR_FRG_ROD SALES_ORG   CRMT_SALES_ORG Sales Organization ID
78 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