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

History

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