SAP ABAP View CRMV_PROD_FIN04H (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_FIN04H
Short Description	View: Changes to Principal History
Root table	CRM_PROD_FIN04H	Changes to Principal

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CRM_PROD_FIN04H	CRM_PROD_FIN04H
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_FIN04H	CLIENT	JL	EQ				0	0
2	COMM_PR_FRG_ROD	CLIENT	JR	EQ			AND	0	0
3	CRM_PROD_FIN04H	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_FIN04H	*		☐		☐
2	CLIENT	CRM_PROD_FIN04H	CLIENT		☐	MANDT	☐	Client
3	FRG_GUID	CRM_PROD_FIN04H	FRG_GUID		☐	COMT_FRG_GUID	☐	Set GUID
4	VALID_TO	CRM_PROD_FIN04H	VALID_TO		☐	COMT_VALID_TO	☐	Valid To (Time Stamp)
5	VALID_FROM	CRM_PROD_FIN04H	VALID_FROM		☐	COMT_VALID_FROM	☐	Valid From (Time Stamp)
6	UPNAME	CRM_PROD_FIN04H	UPNAME		☐	COMT_UPNAME	☐	Name of the User Who Last Changed the Set
7	CASHFLOW_TYPE_01	CRM_PROD_FIN04H	CASHFLOW_TYPE_01		☐	CRMT_CFLOWTYPE01	☐	Flow Category
8	SPLIT_PERC_01	CRM_PROD_FIN04H	SPLIT_PERC_01		☐	CRMT_FINPROD_PROZ01	☐	Percentage Rate
9	RULE_SETTL_01	CRM_PROD_FIN04H	RULE_SETTL_01		☐	CRMT_FIN_TIMERUNA01	☐	Date Rule
10	OFFSET_VAL_01	CRM_PROD_FIN04H	OFFSET_VAL_01		☐	CRMT_FINPROD_OFFS01	☐	Offset
11	OFFSET_UNIT_01	CRM_PROD_FIN04H	OFFSET_UNIT_01		☐	CRMT_FINPROD_OFFSU01	☐	Offset Unit
12	FIN_VIEW_01	CRM_PROD_FIN04H	FIN_VIEW_01		☐	CRMT_FINPROD_VIEW01	☐	View
13	FIXING_01	CRM_PROD_FIN04H	FIXING_01		☐	CRMT_FINPROD_FIX01	☐	Fixing
14	CASHFLOW_TYPE_02	CRM_PROD_FIN04H	CASHFLOW_TYPE_02		☐	CRMT_CFLOWTYPE02	☐	Flow Category
15	SPLIT_PERC_02	CRM_PROD_FIN04H	SPLIT_PERC_02		☐	CRMT_FINPROD_PROZ02	☐	Percentage Rate
16	RULE_SETTL_02	CRM_PROD_FIN04H	RULE_SETTL_02		☐	CRMT_FIN_TIMERUNA02	☐	Date Rule
17	OFFSET_VAL_02	CRM_PROD_FIN04H	OFFSET_VAL_02		☐	CRMT_FINPROD_OFFS02	☐	Offset
18	OFFSET_UNIT_02	CRM_PROD_FIN04H	OFFSET_UNIT_02		☐	CRMT_FINPROD_OFFSU02	☐	Offset Unit
19	FIN_VIEW_02	CRM_PROD_FIN04H	FIN_VIEW_02		☐	CRMT_FINPROD_VIEW02	☐	View
20	FIXING_02	CRM_PROD_FIN04H	FIXING_02		☐	CRMT_FINPROD_FIX02	☐	Fixing
21	CASHFLOW_TYPE_03	CRM_PROD_FIN04H	CASHFLOW_TYPE_03		☐	CRMT_CFLOWTYPE03	☐	Flow Category
22	SPLIT_PERC_03	CRM_PROD_FIN04H	SPLIT_PERC_03		☐	CRMT_FINPROD_PROZ03	☐	Percentage Rate
23	RULE_SETTL_03	CRM_PROD_FIN04H	RULE_SETTL_03		☐	CRMT_FIN_TIMERUNA03	☐	Date Rule
24	OFFSET_VAL_03	CRM_PROD_FIN04H	OFFSET_VAL_03		☐	CRMT_FINPROD_OFFS03	☐	Offset
25	OFFSET_UNIT_03	CRM_PROD_FIN04H	OFFSET_UNIT_03		☐	CRMT_FINPROD_OFFSU03	☐	Offset Unit
26	FIN_VIEW_03	CRM_PROD_FIN04H	FIN_VIEW_03		☐	CRMT_FINPROD_VIEW03	☐	View
27	FIXING_03	CRM_PROD_FIN04H	FIXING_03		☐	CRMT_FINPROD_FIX03	☐	Fixing
28	CASHFLOW_TYPE_04	CRM_PROD_FIN04H	CASHFLOW_TYPE_04		☐	CRMT_CFLOWTYPE04	☐	Flow Category
29	SPLIT_PERC_04	CRM_PROD_FIN04H	SPLIT_PERC_04		☐	CRMT_FINPROD_PROZ04	☐	Percentage Rate
30	RULE_SETTL_04	CRM_PROD_FIN04H	RULE_SETTL_04		☐	CRMT_FIN_TIMERUNA04	☐	Date Rule
31	OFFSET_VAL_04	CRM_PROD_FIN04H	OFFSET_VAL_04		☐	CRMT_FINPROD_OFFS04	☐	Offset
32	OFFSET_UNIT_04	CRM_PROD_FIN04H	OFFSET_UNIT_04		☐	CRMT_FINPROD_OFFSU04	☐	Offset Unit
33	FIN_VIEW_04	CRM_PROD_FIN04H	FIN_VIEW_04		☐	CRMT_FINPROD_VIEW04	☐	View
34	FIXING_04	CRM_PROD_FIN04H	FIXING_04		☐	CRMT_FINPROD_FIX04	☐	Fixing
35	CASHFLOW_TYPE_05	CRM_PROD_FIN04H	CASHFLOW_TYPE_05		☐	CRMT_CFLOWTYPE05	☐	Flow Category
36	SPLIT_PERC_05	CRM_PROD_FIN04H	SPLIT_PERC_05		☐	CRMT_FINPROD_PROZ05	☐	Percentage Rate
37	RULE_SETTL_05	CRM_PROD_FIN04H	RULE_SETTL_05		☐	CRMT_FIN_TIMERUNA05	☐	Date Rule
38	OFFSET_VAL_05	CRM_PROD_FIN04H	OFFSET_VAL_05		☐	CRMT_FINPROD_OFFS05	☐	Offset
39	OFFSET_UNIT_05	CRM_PROD_FIN04H	OFFSET_UNIT_05		☐	CRMT_FINPROD_OFFSU05	☐	Offset Unit
40	FIN_VIEW_05	CRM_PROD_FIN04H	FIN_VIEW_05		☐	CRMT_FINPROD_VIEW05	☐	View
41	FIXING_05	CRM_PROD_FIN04H	FIXING_05		☐	CRMT_FINPROD_FIX05	☐	Fixing
42	CASHFLOW_TYPE_06	CRM_PROD_FIN04H	CASHFLOW_TYPE_06		☐	CRMT_CFLOWTYPE06	☐	Flow Category
43	SPLIT_PERC_06	CRM_PROD_FIN04H	SPLIT_PERC_06		☐	CRMT_FINPROD_PROZ06	☐	Percentage Rate
44	RULE_SETTL_06	CRM_PROD_FIN04H	RULE_SETTL_06		☐	CRMT_FIN_TIMERUNA06	☐	Date Rule
45	OFFSET_VAL_06	CRM_PROD_FIN04H	OFFSET_VAL_06		☐	CRMT_FINPROD_OFFS06	☐	Offset
46	OFFSET_UNIT_06	CRM_PROD_FIN04H	OFFSET_UNIT_06		☐	CRMT_FINPROD_OFFSU06	☐	Offset Unit
47	FIN_VIEW_06	CRM_PROD_FIN04H	FIN_VIEW_06		☐	CRMT_FINPROD_VIEW06	☐	View
48	FIXING_06	CRM_PROD_FIN04H	FIXING_06		☐	CRMT_FINPROD_FIX06	☐	Fixing
49	CASHFLOW_TYPE_07	CRM_PROD_FIN04H	CASHFLOW_TYPE_07		☐	CRMT_CFLOWTYPE07	☐	Flow Category
50	SPLIT_PERC_07	CRM_PROD_FIN04H	SPLIT_PERC_07		☐	CRMT_FINPROD_PROZ07	☐	Percentage Rate
51	RULE_SETTL_07	CRM_PROD_FIN04H	RULE_SETTL_07		☐	CRMT_FIN_TIMERUNA07	☐	Date Rule
52	OFFSET_VAL_07	CRM_PROD_FIN04H	OFFSET_VAL_07		☐	CRMT_FINPROD_OFFS07	☐	Offset
53	OFFSET_UNIT_07	CRM_PROD_FIN04H	OFFSET_UNIT_07		☐	CRMT_FINPROD_OFFSU07	☐	Offset Unit
54	FIN_VIEW_07	CRM_PROD_FIN04H	FIN_VIEW_07		☐	CRMT_FINPROD_VIEW07	☐	View
55	FIXING_07	CRM_PROD_FIN04H	FIXING_07		☐	CRMT_FINPROD_FIX07	☐	Fixing
56	CASHFLOW_TYPE_08	CRM_PROD_FIN04H	CASHFLOW_TYPE_08		☐	CRMT_CFLOWTYPE08	☐	Flow Category
57	SPLIT_PERC_08	CRM_PROD_FIN04H	SPLIT_PERC_08		☐	CRMT_FINPROD_PROZ08	☐	Percentage Rate
58	RULE_SETTL_08	CRM_PROD_FIN04H	RULE_SETTL_08		☐	CRMT_FIN_TIMERUNA08	☐	Date Rule
59	OFFSET_VAL_08	CRM_PROD_FIN04H	OFFSET_VAL_08		☐	CRMT_FINPROD_OFFS08	☐	Offset
60	OFFSET_UNIT_08	CRM_PROD_FIN04H	OFFSET_UNIT_08		☐	CRMT_FINPROD_OFFSU08	☐	Offset Unit
61	FIN_VIEW_08	CRM_PROD_FIN04H	FIN_VIEW_08		☐	CRMT_FINPROD_VIEW08	☐	View
62	FIXING_08	CRM_PROD_FIN04H	FIXING_08		☐	CRMT_FINPROD_FIX08	☐	Fixing
63	PRODUCT_GUID	COMM_PR_FRG_ROD	PRODUCT_GUID		☐	COMT_PRODUCT_GUID	☐	Internal Unique ID of Product
64	FRAGMENT_TYPE	COMM_PR_FRG_ROD	FRAGMENT_TYPE		☐	COMT_FRGTYPE_GUID	☐	Internal Key of a Set Type
65	SALES_ORG	COMM_PR_FRG_ROD	SALES_ORG		☐	CRMT_SALES_ORG	☐	Sales Organization ID
66	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