C_Ftr_Fs_BookValueQuery

DDL: C_FTR_FS_BOOKVALUEQUERY SQL: CFTRFSBVQ Type: view CONSUMPTION

Financial Status for Book Value Amounts

C_Ftr_Fs_BookValueQuery is a Consumption CDS View that provides data about "Financial Status for Book Value Amounts" in SAP S/4HANA. It reads from 1 data source (I_Ftr_Fs_Cube) and exposes 32 fields.

Data Sources (1)

SourceAliasJoin Type
I_Ftr_Fs_Cube I_Ftr_Fs_Cube from

Parameters (3)

NameTypeDefault
P_KeyDate vdm_v_key_date
P_ReportingCurrency fxm_group_currency
P_ExchangeRateType ftr_gen_exch_rate_type

Annotations (11)

NameValueLevelField
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CFTRFSBVQ view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #CONSUMPTION view
OData.publish true view
Analytics.query true view
EndUserText.label Financial Status for Book Value Amounts view

Fields (32)

KeyFieldSource TableSource FieldDescription
multipleSelectionstrue
mandatoryfalseCompanyCode
multipleSelectionstrue
multipleSelectionstrue
mandatoryfalseFinancialPositionGroup
multipleSelectionstrue
mandatoryfalseFinancialPosition
multipleSelectionstrue
multipleSelectionstrue
mandatoryfalseGLAccount
multipleSelectionstrue
mandatoryfalseHouseBank
multipleSelectionstrue
mandatoryfalseHouseBankAccount
multipleSelectionstrue
mandatoryfalseBusinessArea
multipleSelectionstrue
mandatoryfalseIssuer
multipleSelectionstrue
mandatoryfalseCounterparty
multipleSelectionstrue
multipleSelectionstrue
multipleSelectionstrue
mandatoryfalseTreasuryValuationClass
multipleSelectionstrue
mandatoryfalsePortfolio
multipleSelectionstrue
mandatoryfalseSecurityAccount
multipleSelectionstrue
mandatoryfalseSecurityClass
multipleSelectionstrue
multipleSelectionstrue

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_Ftr_Fs_BookValueQuery.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CFTRFSBVQ
-- Parameters: P_KeyDate : vdm_v_key_date, P_ReportingCurrency : fxm_group_currency, P_ExchangeRateType : ftr_gen_exch_rate_type

CREATE VIEW C_Ftr_Fs_BookValueQuery AS
SELECT
  multipleSelections: true AS multipleSelectionstrue,
  mandatory: false AS mandatoryfalseCompanyCode,
  mandatory: false AS mandatoryfalseFinancialPositionGroup,
  mandatory: false AS mandatoryfalseFinancialPosition,
  mandatory: false AS mandatoryfalseGLAccount,
  mandatory: false AS mandatoryfalseHouseBank,
  mandatory: false AS mandatoryfalseHouseBankAccount,
  mandatory: false AS mandatoryfalseBusinessArea,
  mandatory: false AS mandatoryfalseIssuer,
  mandatory: false AS mandatoryfalseCounterparty,
  mandatory: false AS mandatoryfalseTreasuryValuationClass,
  mandatory: false AS mandatoryfalsePortfolio,
  mandatory: false AS mandatoryfalseSecurityAccount,
  mandatory: false AS mandatoryfalseSecurityClass
FROM I_Ftr_Fs_Cube
;