SAP ABAP Table FVD_LOAN_CALCULATION_QUERY_MES (Proxy Structure (Generated))

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CML (Application Component) Loans Management
     ⤷ FVVD_IN_PROXY (Package) XI Proxies FS-CML/Global: Inbound Layer

Basic Data

Table Category	INTTAB	Structure
Structure	FVD_LOAN_CALCULATION_QUERY_MES	Table Relationship Diagram
Short Description	Proxy Structure (Generated)

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	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
2	MESSAGE_HEADER	☐	FVD_BUSINESS_DOCUMENT_MESSAGE2		STRU	0	0
3	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
4	ID	☐	FVD_BUSINESS_DOCUMENT_MESSAGE3		STRU	0	0
5	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
6	SCHEME_ID	☐			CHAR	60	0
7	SCHEME_AGENCY_ID	☐			CHAR	60	0
8	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐			CHAR	3	0
9	VALUE	☐	FVD_BUSINESS_DOCUMENT_MESSAGE		CHAR	35	0	Proxy Data Element (Generated)
10	REFERENCE_ID	☐	FVD_BUSINESS_DOCUMENT_MESSAGE3		STRU	0	0
11	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
12	SCHEME_ID	☐			CHAR	60	0
13	SCHEME_AGENCY_ID	☐			CHAR	60	0
14	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐			CHAR	3	0
15	VALUE	☐	FVD_BUSINESS_DOCUMENT_MESSAGE		CHAR	35	0	Proxy Data Element (Generated)
16	CREATION_DATE_TIME	☐	FVD_DATE_TIME		STRG	0	0	Proxy Data Element (Generated)
17	SENDER_PARTY	☐	FVD_BUSINESS_DOCUMENT_MESSAGE1		STRU	0	0
18	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
19	INTERNAL_ID	☐	FVD_PARTY_INTERNAL_ID		STRU	0	0
20	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
21	SCHEME_ID	☐			CHAR	60	0
22	SCHEME_AGENCY_ID	☐			CHAR	60	0
23	VALUE	☐	FVD_PARTY_INTERNAL_IDCONTENT		CHAR	32	0	Proxy Data Element (Generated)
24	STANDARD_ID	☐	FVD_PARTY_STANDARD_ID_TAB		TTYP	0	0
25	CONTACT_PERSON	☐	FVD_CONTACT_PERSON		STRU	0	0
26	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
27	INTERNAL_ID	☐	FVD_CONTACT_PERSON_INTERNAL_I1		STRU	0	0
28	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
29	SCHEME_ID	☐			CHAR	60	0
30	SCHEME_AGENCY_ID	☐			CHAR	60	0
31	VALUE	☐	FVD_CONTACT_PERSON_INTERNAL_ID		CHAR	32	0	Proxy Data Element (Generated)
32	BUYER_ID	☐	FVD_CONTACT_PERSON_PARTY_ID		CHAR	60	0	Proxy Data Element (Generated)
33	SELLER_ID	☐	FVD_CONTACT_PERSON_PARTY_ID		CHAR	60	0	Proxy Data Element (Generated)
34	PRODUCT_RECIPIENT_ID	☐	FVD_CONTACT_PERSON_PARTY_ID		CHAR	60	0	Proxy Data Element (Generated)
35	VENDOR_ID	☐	FVD_CONTACT_PERSON_PARTY_ID		CHAR	60	0	Proxy Data Element (Generated)
36	BILL_TO_ID	☐	FVD_CONTACT_PERSON_PARTY_ID		CHAR	60	0	Proxy Data Element (Generated)
37	BILL_FROM_ID	☐	FVD_CONTACT_PERSON_PARTY_ID		CHAR	60	0	Proxy Data Element (Generated)
38	BIDDER_ID	☐	FVD_CONTACT_PERSON_PARTY_ID		CHAR	60	0	Proxy Data Element (Generated)
39	ADDRESS	☐	FVD_ADDRESS		STRU	0	0
40	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
41	ORGANISATION_FORMATTED_NAME	☐	FVD_ADDRESS_ORGANISATION_F_TAB		TTYP	0	0
42	PERSON_NAME	☐	FVD_PERSON_NAME		STRU	0	0
43	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
44	FORMATTED_NAME	☐			CHAR	80	0
45	LEGAL_NAME	☐			CHAR	80	0
46	GIVEN_NAME	☐	FVD_PERSON_NAME_GIVEN_NAME_TAB		TTYP	0	0
47	PREFERRED_GIVEN_NAME	☐			CHAR	40	0
48	MIDDLE_NAME	☐	FVD_PERSON_NAME_MIDDLE_NAM_TAB		TTYP	0	0
49	FAMILY	☐	FVD_PERSON_NAME_FAMILY_TAB		TTYP	0	0
50	AFFIX	☐	FVD_PERSON_NAME_AFFIX_TAB		TTYP	0	0
51	FUNCTIONAL_TITLE_NAME	☐			CHAR	40	0
52	DEPARTMENT_NAME	☐			CHAR	40	0
53	OFFICE	☐	FVD_ADDRESS_OFFICE		STRU	0	0
54	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
55	BUILDING_ID	☐			CHAR	10	0
56	FLOOR_ID	☐			CHAR	10	0
57	ROOM_ID	☐			CHAR	10	0
58	INHOUSE_MAIL_ID	☐			CHAR	10	0
59	CORRESPONDENCE_SHORT_NAME	☐			CHAR	10	0
60	PHYSICAL_ADDRESS	☐	FVD_ADDRESS_PHYSICAL_ADDRESS		STRU	0	0
61	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
62	COUNTRY_CODE	☐	FVD_COUNTRY_CODE		CHAR	3	0	Proxy Data Element (Generated)
63	REGION_CODE	☐	FVD_REGION_CODE		STRU	0	0
64	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
65	LIST_ID	☐			CHAR	60	0
66	LIST_VERSION_ID	☐			CHAR	15	0
67	LIST_AGENCY_ID	☐			CHAR	60	0
68	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
69	LIST_AGENCY_SCHEME_AGENCY_ID	☐			CHAR	3	0
70	VALUE	☐			STRG	0	0
71	STREET_POSTAL_CODE	☐			CHAR	10	0
72	POBOX_POSTAL_CODE	☐			CHAR	10	0
73	COMPANY_POSTAL_CODE	☐			CHAR	10	0
74	CITY_NAME	☐			CHAR	40	0
75	ADDITIONAL_CITY_NAME	☐			CHAR	40	0
76	DISTRICT_NAME	☐			CHAR	40	0
77	POBOX_ID	☐			CHAR	10	0
78	POBOX_INDICATOR	☐			CHAR	5	0
79	POBOX_COUNTRY_CODE	☐	FVD_COUNTRY_CODE		CHAR	3	0	Proxy Data Element (Generated)
80	POBOX_REGION_CODE	☐	FVD_REGION_CODE		STRU	0	0
81	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
82	LIST_ID	☐			CHAR	60	0
83	LIST_VERSION_ID	☐			CHAR	15	0
84	LIST_AGENCY_ID	☐			CHAR	60	0
85	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
86	LIST_AGENCY_SCHEME_AGENCY_ID	☐			CHAR	3	0
87	VALUE	☐			STRG	0	0
88	POBOX_CITY_NAME	☐			CHAR	40	0
89	STREET_NAME	☐			CHAR	60	0
90	STREET_PREFIX_NAME	☐	FVD_ADDRESS_STREET_PREFIX__TAB		TTYP	0	0
91	STREET_SUFFIX_NAME	☐	FVD_ADDRESS_STREET_SUFFIX__TAB		TTYP	0	0
92	HOUSE_ID	☐			CHAR	10	0
93	ADDITIONAL_HOUSE_ID	☐			CHAR	10	0
94	BUILDING_ID	☐			CHAR	20	0
95	FLOOR_ID	☐			CHAR	10	0
96	ROOM_ID	☐			CHAR	10	0
97	CARE_OF_NAME	☐			CHAR	40	0
98	DESCRIPTION	☐	FVD_DESCRIPTION_TAB		TTYP	0	0
99	TAX_JURISDICTION_CODE	☐	FVD_TAX_JURISDICTION_CODE		STRU	0	0
100	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
101	LIST_ID	☐			CHAR	60	0
102	LIST_VERSION_ID	☐			CHAR	15	0
103	LIST_AGENCY_ID	☐			CHAR	60	0
104	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
105	LIST_AGENCY_SCHEME_AGENCY_ID	☐			CHAR	3	0
106	VALUE	☐	FVD_TAX_JURISDICTION_CODE_CONT		CHAR	15	0	Proxy Data Element (Generated)
107	TIME_ZONE_DIFFERENCE_VALUE	☐	FVD_TIME_ZONE_DIFFERENCE_VALUE		DEC	4	2	Proxy Data Element (Generated)
108	GEO_COORDINATES	☐	FVD_GEO_COORDINATES		STRU	0	0
109	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
110	LATITUDE_MEASURE	☐	FVD_MEASURE		STRU	0	0
111	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
112	UNIT_CODE	☐			CHAR	3	0
113	VALUE	☐			STRG	0	0
114	LONGITUDE_MEASURE	☐	FVD_MEASURE		STRU	0	0
115	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
116	UNIT_CODE	☐			CHAR	3	0
117	VALUE	☐			STRG	0	0
118	COMMUNICATION	☐	FVD_ADDRESS_COMMUNICATION		STRU	0	0
119	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
120	CORRESPONDENCE_LANGUAGE_CODE	☐	FVD_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (Generated)
121	TELEPHONE	☐	FVD_ADDRESS_TELEPHONE_TAB		TTYP	0	0
122	MOBILE_PHONE	☐	FVD_ADDRESS_MOBILE_PHONE_TAB		TTYP	0	0
123	FACSIMILE	☐	FVD_ADDRESS_FACSIMILE_TAB		TTYP	0	0
124	EMAIL	☐	FVD_ADDRESS_EMAIL_TAB		TTYP	0	0
125	WEB	☐	FVD_ADDRESS_WEB_TAB		TTYP	0	0
126	RECIPIENT_PARTY	☐	FVD_BUSINESS_DOCUMENT_MESS_TAB		TTYP	0	0
127	LOAN_CALCULATION_QUERY	☐	FVD_LOAN_CALCULATION_QUERY		STRU	0	0
128	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
129	LOAN_KEY_FIGURE_TYPE_CODE	☐	FVD_LOAN_KEY_FIGURE_TYPE_C_TAB		TTYP	0	0
130	MATURITY_PERIOD	☐	FVD_DATE_PERIOD		STRU	0	0
131	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
132	START_DATE	☐	FVD_DATE		DATS	8	0	Proxy Data Element (Generated)
133	END_DATE	☐	FVD_DATE		DATS	8	0	Proxy Data Element (Generated)
134	DURATION	☐	FVD_DURATION		STRG	0	0	Proxy Data Element (Generated)
135	FIXED_INTEREST_PERIOD	☐	FVD_DATE_PERIOD		STRU	0	0
136	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
137	START_DATE	☐	FVD_DATE		DATS	8	0	Proxy Data Element (Generated)
138	END_DATE	☐	FVD_DATE		DATS	8	0	Proxy Data Element (Generated)
139	DURATION	☐	FVD_DURATION		STRG	0	0	Proxy Data Element (Generated)
140	AMOUNT	☐	FVD_AMOUNT		STRU	0	0
141	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
142	CURRENCY_CODE	☐			CHAR	3	0
143	VALUE	☐	FVD_AMOUNT_CONTENT		DEC	28	6	Proxy Data Element (Generated)
144	EFFECTIVE_YIELD_CALCULATION_M	☐	FVD_EFFECTIVE_YIELD_CALCULATIO		CHAR	2	0	Proxy Data Element (Generated)
145	DISAGIO_PERCENT	☐	FVD_DISAGIO_PERCENT		DEC	6	3	Proxy Data Element (Generated)
146	DISAGIO_DEDUCTION_EVENT_TYPE	☐	FVD_DISAGIO_DEDUCTION_EVENT_TY		CHAR	2	0	Proxy Data Element (Generated)
147	PRODUCT_CATEGORY	☐	FVD_BUSINESS_TRANSACTION_DOCUM		STRU	0	0
148	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
149	INTERNAL_ID	☐	FVD_PRODUCT_CATEGORY_INTERNAL1		STRU	0	0
150	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
151	SCHEME_ID	☐			CHAR	60	0
152	SCHEME_AGENCY_ID	☐			CHAR	60	0
153	VALUE	☐	FVD_PRODUCT_CATEGORY_INTERNAL		CHAR	40	0	Proxy Data Element (Generated)
154	STANDARD_ID	☐	FVD_PRODUCT_CATEGORY_STAND_TAB		TTYP	0	0
155	BUYER_ID	☐	FVD_PRODUCT_CATEGORY_PARTY_ID		CHAR	40	0	Proxy Data Element (Generated)
156	SELLER_ID	☐	FVD_PRODUCT_CATEGORY_PARTY_ID		CHAR	40	0	Proxy Data Element (Generated)
157	PRODUCT_RECIPIENT_ID	☐	FVD_PRODUCT_CATEGORY_PARTY_ID		CHAR	40	0	Proxy Data Element (Generated)
158	VENDOR_ID	☐	FVD_PRODUCT_CATEGORY_PARTY_ID		CHAR	40	0	Proxy Data Element (Generated)
159	MANUFACTURER_ID	☐	FVD_PRODUCT_CATEGORY_PARTY_ID		CHAR	40	0	Proxy Data Element (Generated)
160	BILL_TO_ID	☐	FVD_PRODUCT_CATEGORY_PARTY_ID		CHAR	40	0	Proxy Data Element (Generated)
161	BILL_FROM_ID	☐	FVD_PRODUCT_CATEGORY_PARTY_ID		CHAR	40	0	Proxy Data Element (Generated)
162	BIDDER_ID	☐	FVD_PRODUCT_CATEGORY_PARTY_ID		CHAR	40	0	Proxy Data Element (Generated)
163	PRODUCT	☐	FVD_BUSINESS_TRANSACTION_DOCU1		STRU	0	0
164	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
165	INTERNAL_ID	☐	FVD_PRODUCT_INTERNAL_ID		STRU	0	0
166	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
167	SCHEME_ID	☐			CHAR	60	0
168	SCHEME_AGENCY_ID	☐			CHAR	60	0
169	VALUE	☐	FVD_PRODUCT_INTERNAL_IDCONTENT		CHAR	60	0	Proxy Data Element (Generated)
170	STANDARD_ID	☐	FVD_PRODUCT_STANDARD_ID_TAB		TTYP	0	0
171	BUYER_ID	☐	FVD_PRODUCT_PARTY_ID		CHAR	60	0	Proxy Data Element (Generated)
172	SELLER_ID	☐	FVD_PRODUCT_PARTY_ID		CHAR	60	0	Proxy Data Element (Generated)
173	PRODUCT_RECIPIENT_ID	☐	FVD_PRODUCT_PARTY_ID		CHAR	60	0	Proxy Data Element (Generated)
174	VENDOR_ID	☐	FVD_PRODUCT_PARTY_ID		CHAR	60	0	Proxy Data Element (Generated)
175	MANUFACTURER_ID	☐	FVD_PRODUCT_PARTY_ID		CHAR	60	0	Proxy Data Element (Generated)
176	BILL_TO_ID	☐	FVD_PRODUCT_PARTY_ID		CHAR	60	0	Proxy Data Element (Generated)
177	BILL_FROM_ID	☐	FVD_PRODUCT_PARTY_ID		CHAR	60	0	Proxy Data Element (Generated)
178	BIDDER_ID	☐	FVD_PRODUCT_PARTY_ID		CHAR	60	0	Proxy Data Element (Generated)
179	TYPE_CODE	☐	FVD_PRODUCT_TYPE_CODE		CHAR	2	0	Proxy Data Element (Generated)
180	NOTE	☐	FVD_NOTE		STRU	0	0
181	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
182	LANGUAGE_CODE	☐			CHAR	9	0
183	VALUE	☐			STRG	0	0
184	LOAN_INTEREST_CONDITION	☐	FVD_LOAN_INTEREST_CONDITIO_TAB		TTYP	0	0
185	LOAN_AMORTIZEMENT_CONDITION	☐	FVD_LOAN_AMORTIZEMENT_COND_TAB		TTYP	0	0
186	LOAN_FEE_CONDITION	☐	FVD_LOAN_FEE_CONDITION_TAB		TTYP	0	0

History

Last changed by/on	SAP	20130529
SAP Release Created in	600