SAP FVD_LOAN_CALCULATION_QUERY Proxy Struktur (generiert) Table data and field list

FVD_LOAN_CALCULATION_QUERY is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Proxy Struktur (generiert)" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_FVD_LOAN_CALCULATION_QUERY TYPE FVD_LOAN_CALCULATION_QUERY.

The FVD_LOAN_CALCULATION_QUERY table consists of various fields, each holding specific information or linking keys about Proxy Struktur (generiert) data available in SAP. These include LOAN_KEY_FIGURE_TYPE_CODE (), MATURITY_PERIOD (), CONTROLLER (), START_DATE (Proxy Datenelement (generiert))... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

FVD_LOAN_CALCULATION_QUERY structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP FVD_LOAN_CALCULATION_QUERY structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the FVD_LOAN_CALCULATION_QUERY table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
CONTROLLER 0
LOAN_KEY_FIGURE_TYPE_CODE 0
MATURITY_PERIOD 0
CONTROLLER 0
START_DATEProxy Datenelement (generiert) FVD_DATEDATS8
END_DATEProxy Datenelement (generiert) FVD_DATEDATS8
DURATIONProxy Datenelement (generiert) FVD_DURATIONSTRG0
FIXED_INTEREST_PERIOD 0
CONTROLLER 0
START_DATEProxy Datenelement (generiert) FVD_DATEDATS8
END_DATEProxy Datenelement (generiert) FVD_DATEDATS8
DURATIONProxy Datenelement (generiert) FVD_DURATIONSTRG0
AMOUNT 0
CONTROLLER 0
CURRENCY_CODEProxy Datenelement (generiert) FVD_CURRENCY_CODECHAR3
VALUEProxy Data Element (generated) FVD_AMOUNT_CONTENT5DEC28(6)
BALLOON_AMOUNT 0
CONTROLLER 0
CURRENCY_CODEProxy Datenelement (generiert) FVD_CURRENCY_CODECHAR3
VALUEProxy Data Element (generated) FVD_AMOUNT_CONTENT5DEC28(6)
EFFECTIVE_YIELD_CALCULATION_MProxy Datenelement (generiert) FVD_EFFECTIVE_YIELD_CALCULATIOCHAR2
DISAGIO_PERCENTProxy Datenelement (generiert) FVD_DISAGIO_PERCENTDEC6(3)
DISAGIO_DEDUCTION_EVENT_TYPEProxy Datenelement (generiert) FVD_DISAGIO_DEDUCTION_EVENT_TYCHAR2
PRODUCT_CATEGORY 0
CONTROLLER 0
INTERNAL_ID 0
CONTROLLER 0
SCHEME_ID 0
SCHEME_AGENCY_ID 0
VALUEProxy Data Element (generated) FVD_PRODUCT_CATEGORY_INTERNAL4CHAR40
STANDARD_ID 0
BUYER_IDProxy Datenelement (generiert) FVD_PRODUCT_CATEGORY_PARTY_IDCHAR40
SELLER_IDProxy Datenelement (generiert) FVD_PRODUCT_CATEGORY_PARTY_IDCHAR40
PRODUCT_RECIPIENT_IDProxy Datenelement (generiert) FVD_PRODUCT_CATEGORY_PARTY_IDCHAR40
VENDOR_IDProxy Datenelement (generiert) FVD_PRODUCT_CATEGORY_PARTY_IDCHAR40
MANUFACTURER_IDProxy Datenelement (generiert) FVD_PRODUCT_CATEGORY_PARTY_IDCHAR40
BILL_TO_IDProxy Datenelement (generiert) FVD_PRODUCT_CATEGORY_PARTY_IDCHAR40
BILL_FROM_IDProxy Datenelement (generiert) FVD_PRODUCT_CATEGORY_PARTY_IDCHAR40
BIDDER_IDProxy Datenelement (generiert) FVD_PRODUCT_CATEGORY_PARTY_IDCHAR40
PRODUCT 0
CONTROLLER 0
INTERNAL_ID 0
CONTROLLER 0
SCHEME_ID 0
SCHEME_AGENCY_ID 0
VALUEProxy Data Element (generated) FVD_PRODUCT_INTERNAL_ID_CONTECHAR60
STANDARD_ID 0
BUYER_IDProxy Datenelement (generiert) FVD_PRODUCT_PARTY_IDCHAR60
SELLER_IDProxy Datenelement (generiert) FVD_PRODUCT_PARTY_IDCHAR60
PRODUCT_RECIPIENT_IDProxy Datenelement (generiert) FVD_PRODUCT_PARTY_IDCHAR60
VENDOR_IDProxy Datenelement (generiert) FVD_PRODUCT_PARTY_IDCHAR60
MANUFACTURER_IDProxy Datenelement (generiert) FVD_PRODUCT_PARTY_IDCHAR60
BILL_TO_IDProxy Datenelement (generiert) FVD_PRODUCT_PARTY_IDCHAR60
BILL_FROM_IDProxy Datenelement (generiert) FVD_PRODUCT_PARTY_IDCHAR60
BIDDER_IDProxy Datenelement (generiert) FVD_PRODUCT_PARTY_IDCHAR60
TYPE_CODEProxy Datenelement (generiert) FVD_PRODUCT_TYPE_CODECHAR2
NOTE 0
CONTROLLER 0
LANGUAGE_CODEProxy Datenelement (generiert) FVD_LANGUAGE_CODECHAR9
VALUE 0
CHANGE_IDProxy Data Element (generated) PRODUCT_CHANGE_IDCHAR25
DISCONTINUATION_INDICATOR'Indicator' is the binary coded specification of a fact FVD_INDICATORCHAR5
PACKAGE_QUANTITY 0
CONTROLLER 0
UNIT_CODEProxy Data Element (generated) MEASURE_UNIT_CODE11CHAR3
CONTENTQUANTITY is the non-monetary numerical declaration of a quan QUANTITY_CONTENT11DEC31(14)
LOAN_INTEREST_CONDITION 0
LOAN_AMORTIZEMENT_CONDITION 0
LOAN_FEE_CONDITION 0

Key field Non-key field



How do I retrieve data from SAP structure FVD_LOAN_CALCULATION_QUERY using ABAP code?

As FVD_LOAN_CALCULATION_QUERY is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on FVD_LOAN_CALCULATION_QUERY as there is no data to select.

How to access SAP table FVD_LOAN_CALCULATION_QUERY

Within an ECC or HANA version of SAP you can also view further information about FVD_LOAN_CALCULATION_QUERY and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).