SAP ABAP Table CRMV_PROD_FIN05H (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure CRMV_PROD_FIN05H   Table Relationship Diagram
Short Description Generated Table for View    
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 CLIENT MANDT MANDT CLNT 3   0   Client  
2 FRG_GUID COMT_FRG_GUID SYSUUID RAW 16   0   Set GUID  
3 VALID_TO COMT_VALID_TO BCOS_TSTMP DEC 15   0   Valid To (Time Stamp)  
4 VALID_FROM COMT_VALID_FROM BCOS_TSTMP DEC 15   0   Valid From (Time Stamp)  
5 UPNAME COMT_UPNAME UNAME CHAR 12   0   Name of the User Who Last Changed the Set  
6 CFLOW_TYPE_01 CRMT_CFLOWTYPE01 CRMT_CASHFLOW_TYPE CHAR 4   0   Flow Category CRMC_CFTYPE
7 NO_OF_PERIODS_01 CRMT_FIN_PERIODS01   NUMC 5   0   Number of Periods in Billing Plan  
8 PAYMENT_FREQU_01 CRMT_FIN_PAYMENTFR01 CRMT_FIN_PAYMENTFR01 NUMC 2   0   Payment Frequency  
9 PAYMENT_FORM_01 CRMT_FIN_PAYMENTFO01 CRMT_PAYMENTFORM NUMC 1   0   Payment Form CRMC_PAYMFORM
10 PERCENTAGE_01 CRMT_FINPROD_PROZ01 DECV3_7 DEC 10   7   Percentage Rate  
11 RATE_PER_X_01 CRMT_FIN_RATEPERX01 CRMT_DECV7_10 DEC 17   10   Rate per x  
12 TIMERU_FROM_01 CRMT_FIN_TIMERU_FR01 TIMENAME CHAR 12   0   Date Rule From TIMERUNA
13 TIMERU_TO_01 CRMT_FIN_TIMERU_TO01 TIMENAME CHAR 12   0   Date Rule To TIMERUNA
14 SETTL_TO_01 CRMT_FIN_SETTL_TO_01   DATS 8   0   To Date  
15 FIX_01 CRMT_FINPROD_FIX01 CRMT_FINPROD_FIX01 NUMC 2   0   Fixing  
16 DATE_UPD_01 CRMT_FIN_DATE_UPD_01 CRMT_FIN_DATE_UPD_01 CHAR 1   0   No Date Update  
17 CFLOW_TYPE_02 CRMT_CFLOWTYPE02 CRMT_CASHFLOW_TYPE CHAR 4   0   Flow Category CRMC_CFTYPE
18 NO_OF_PERIODS_02 CRMT_FIN_PERIODS02   NUMC 5   0   Number of Periods in Billing Plan  
19 PAYMENT_FREQU_02 CRMT_FIN_PAYMENTFR02 CRMT_FIN_PAYMENTFR02 NUMC 2   0   Payment Frequency  
20 PAYMENT_FORM_02 CRMT_FIN_PAYMENTFO02 CRMT_PAYMENTFORM NUMC 1   0   Payment Form CRMC_PAYMFORM
21 PERCENTAGE_02 CRMT_FINPROD_PROZ02 DECV3_7 DEC 10   7   Percentage Rate  
22 RATE_PER_X_02 CRMT_FIN_RATEPERX02 CRMT_DECV7_10 DEC 17   10   Rate per x  
23 TIMERU_FROM_02 CRMT_FIN_TIMERU_FR02 TIMENAME CHAR 12   0   Date Rule From TIMERUNA
24 TIMERU_TO_02 CRMT_FIN_TIMERU_TO02 TIMENAME CHAR 12   0   Date Rule To TIMERUNA
25 SETTL_TO_02 CRMT_FIN_SETTL_TO_02   DATS 8   0   To Date  
26 FIX_02 CRMT_FINPROD_FIX02 CRMT_FINPROD_FIX02 NUMC 2   0   Fixing  
27 DATE_UPD_02 CRMT_FIN_DATE_UPD_02 CRMT_FIN_DATE_UPD_02 CHAR 1   0   No Date Update  
28 CFLOW_TYPE_03 CRMT_CFLOWTYPE03 CRMT_CASHFLOW_TYPE CHAR 4   0   Flow Category CRMC_CFTYPE
29 NO_OF_PERIODS_03 CRMT_FIN_PERIODS03   NUMC 5   0   Number of Periods in Billing Plan  
30 PAYMENT_FREQU_03 CRMT_FIN_PAYMENTFR03 CRMT_FIN_PAYMENTFR03 NUMC 2   0   Payment Frequency  
31 PAYMENT_FORM_03 CRMT_FIN_PAYMENTFO03 CRMT_PAYMENTFORM NUMC 1   0   Payment Form CRMC_PAYMFORM
32 PERCENTAGE_03 CRMT_FINPROD_PROZ03 DECV3_7 DEC 10   7   Percentage Rate  
33 RATE_PER_X_03 CRMT_FIN_RATEPERX03 CRMT_DECV7_10 DEC 17   10   Rate per x  
34 TIMERU_FROM_03 CRMT_FIN_TIMERU_FR03 TIMENAME CHAR 12   0   Date Rule From TIMERUNA
35 TIMERU_TO_03 CRMT_FIN_TIMERU_TO03 TIMENAME CHAR 12   0   Date Rule To TIMERUNA
36 SETTL_TO_03 CRMT_FIN_SETTL_TO_03   DATS 8   0   To Date  
37 FIX_03 CRMT_FINPROD_FIX03 CRMT_FINPROD_FIX03 NUMC 2   0   Fixing  
38 DATE_UPD_03 CRMT_FIN_DATE_UPD_03 CRMT_FIN_DATE_UPD_03 CHAR 1   0   No Date Update  
39 CFLOW_TYPE_04 CRMT_CFLOWTYPE04 CRMT_CASHFLOW_TYPE CHAR 4   0   Flow Category CRMC_CFTYPE
40 NO_OF_PERIODS_04 CRMT_FIN_PERIODS04   NUMC 5   0   Number of Periods in Billing Plan  
41 PAYMENT_FREQU_04 CRMT_FIN_PAYMENTFR04 CRMT_FIN_PAYMENTFR04 NUMC 2   0   Payment Frequency  
42 PAYMENT_FORM_04 CRMT_FIN_PAYMENTFO04 CRMT_PAYMENTFORM NUMC 1   0   Payment Form CRMC_PAYMFORM
43 PERCENTAGE_04 CRMT_FINPROD_PROZ04 DECV3_7 DEC 10   7   Percentage Rate  
44 RATE_PER_X_04 CRMT_FIN_RATEPERX04 CRMT_DECV7_10 DEC 17   10   Rate per x  
45 TIMERU_FROM_04 CRMT_FIN_TIMERU_FR04 TIMENAME CHAR 12   0   Date Rule From TIMERUNA
46 TIMERU_TO_04 CRMT_FIN_TIMERU_TO04 TIMENAME CHAR 12   0   Date Rule To TIMERUNA
47 SETTL_TO_04 CRMT_FIN_SETTL_TO_04   DATS 8   0   To Date  
48 FIX_04 CRMT_FINPROD_FIX04 CRMT_FINPROD_FIX04 NUMC 2   0   Fixing  
49 DATE_UPD_04 CRMT_FIN_DATE_UPD_04 CRMT_FIN_DATE_UPD_04 CHAR 1   0   No Date Update  
50 CFLOW_TYPE_05 CRMT_CFLOWTYPE05 CRMT_CASHFLOW_TYPE CHAR 4   0   Flow Category CRMC_CFTYPE
51 NO_OF_PERIODS_05 CRMT_FIN_PERIODS05   NUMC 5   0   Number of Periods in Billing Plan  
52 PAYMENT_FREQU_05 CRMT_FIN_PAYMENTFR05 CRMT_FIN_PAYMENTFR05 NUMC 2   0   Payment Frequency  
53 PAYMENT_FORM_05 CRMT_FIN_PAYMENTFO05 CRMT_PAYMENTFORM NUMC 1   0   Payment Form CRMC_PAYMFORM
54 PERCENTAGE_05 CRMT_FINPROD_PROZ05 DECV3_7 DEC 10   7   Percentage Rate  
55 RATE_PER_X_05 CRMT_FIN_RATEPERX05 CRMT_DECV7_10 DEC 17   10   Rate per x  
56 TIMERU_FROM_05 CRMT_FIN_TIMERU_FR05 TIMENAME CHAR 12   0   Date Rule From TIMERUNA
57 TIMERU_TO_05 CRMT_FIN_TIMERU_TO05 TIMENAME CHAR 12   0   Date Rule To TIMERUNA
58 SETTL_TO_05 CRMT_FIN_SETTL_TO_05   DATS 8   0   To Date  
59 FIX_05 CRMT_FINPROD_FIX05 CRMT_FINPROD_FIX05 NUMC 2   0   Fixing  
60 DATE_UPD_05 CRMT_FIN_DATE_UPD_05 CRMT_FIN_DATE_UPD_05 CHAR 1   0   No Date Update  
61 CFLOW_TYPE_06 CRMT_CFLOWTYPE06 CRMT_CASHFLOW_TYPE CHAR 4   0   Flow Category CRMC_CFTYPE
62 NO_OF_PERIODS_06 CRMT_FIN_PERIODS06   NUMC 5   0   Number of Periods in Billing Plan  
63 PAYMENT_FREQU_06 CRMT_FIN_PAYMENTFR06 CRMT_FIN_PAYMENTFR06 NUMC 2   0   Payment Frequency  
64 PAYMENT_FORM_06 CRMT_FIN_PAYMENTFO06 CRMT_PAYMENTFORM NUMC 1   0   Payment Form CRMC_PAYMFORM
65 PERCENTAGE_06 CRMT_FINPROD_PROZ06 DECV3_7 DEC 10   7   Percentage Rate  
66 RATE_PER_X_06 CRMT_FIN_RATEPERX06 CRMT_DECV7_10 DEC 17   10   Rate per x  
67 TIMERU_FROM_06 CRMT_FIN_TIMERU_FR06 TIMENAME CHAR 12   0   Date Rule From TIMERUNA
68 TIMERU_TO_06 CRMT_FIN_TIMERU_TO06 TIMENAME CHAR 12   0   Date Rule To TIMERUNA
69 SETTL_TO_06 CRMT_FIN_SETTL_TO_06   DATS 8   0   To Date  
70 FIX_06 CRMT_FINPROD_FIX06 CRMT_FINPROD_FIX06 NUMC 2   0   Fixing  
71 DATE_UPD_06 CRMT_FIN_DATE_UPD_06 CRMT_FIN_DATE_UPD_06 CHAR 1   0   No Date Update  
72 PRODUCT_GUID COMT_PRODUCT_GUID SYSUUID RAW 16   0   Internal Unique ID of Product  
73 FRAGMENT_TYPE COMT_FRGTYPE_GUID SYSUUID RAW 16   0   Internal Key of a Set Type  
74 SALES_ORG CRMT_SALES_ORG HROBJEC_14 CHAR 14   0   Sales Organization ID  
75 DISTR_CHAN CRMT_DISTRIBUTION_CHANNEL CRM_DISTRIBUTION_CHANNEL CHAR 2   0   Distribution Channel  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CRMV_PROD_FIN05H CFLOW_TYPE_01 CRMC_CFTYPE CASHFLOW_TYPE_CU    
2 CRMV_PROD_FIN05H CFLOW_TYPE_02 CRMC_CFTYPE CASHFLOW_TYPE_CU    
3 CRMV_PROD_FIN05H CFLOW_TYPE_03 CRMC_CFTYPE CASHFLOW_TYPE_CU    
4 CRMV_PROD_FIN05H CFLOW_TYPE_04 CRMC_CFTYPE CASHFLOW_TYPE_CU    
5 CRMV_PROD_FIN05H CFLOW_TYPE_05 CRMC_CFTYPE CASHFLOW_TYPE_CU    
6 CRMV_PROD_FIN05H CFLOW_TYPE_06 CRMC_CFTYPE CASHFLOW_TYPE_CU    
7 CRMV_PROD_FIN05H PAYMENT_FORM_01 CRMC_PAYMFORM PAYMFORM KEY 1 CN
8 CRMV_PROD_FIN05H PAYMENT_FORM_02 CRMC_PAYMFORM PAYMFORM KEY 1 CN
9 CRMV_PROD_FIN05H PAYMENT_FORM_03 CRMC_PAYMFORM PAYMFORM KEY 1 CN
10 CRMV_PROD_FIN05H PAYMENT_FORM_04 CRMC_PAYMFORM PAYMFORM KEY 1 CN
11 CRMV_PROD_FIN05H PAYMENT_FORM_05 CRMC_PAYMFORM PAYMFORM KEY 1 CN
12 CRMV_PROD_FIN05H PAYMENT_FORM_06 CRMC_PAYMFORM PAYMFORM KEY 1 CN
13 CRMV_PROD_FIN05H TIMERU_FROM_01 TIMERUNA RULE_NAME    
14 CRMV_PROD_FIN05H TIMERU_FROM_02 TIMERUNA RULE_NAME    
15 CRMV_PROD_FIN05H TIMERU_FROM_03 TIMERUNA RULE_NAME    
16 CRMV_PROD_FIN05H TIMERU_FROM_04 TIMERUNA RULE_NAME    
17 CRMV_PROD_FIN05H TIMERU_FROM_05 TIMERUNA RULE_NAME    
18 CRMV_PROD_FIN05H TIMERU_FROM_06 TIMERUNA RULE_NAME    
19 CRMV_PROD_FIN05H TIMERU_TO_01 TIMERUNA RULE_NAME    
20 CRMV_PROD_FIN05H TIMERU_TO_02 TIMERUNA RULE_NAME    
21 CRMV_PROD_FIN05H TIMERU_TO_03 TIMERUNA RULE_NAME    
22 CRMV_PROD_FIN05H TIMERU_TO_04 TIMERUNA RULE_NAME    
23 CRMV_PROD_FIN05H TIMERU_TO_05 TIMERUNA RULE_NAME    
24 CRMV_PROD_FIN05H TIMERU_TO_06 TIMERUNA RULE_NAME    
History
Last changed by/on SAP  20130604 
SAP Release Created in