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