VFCLM_BAM_DDL_FBAR15

DDL: FCLM_BAM_FBAR15 SQL: VFCLMFBAR15 Type: view

The 15th view for FBAR

VFCLM_BAM_DDL_FBAR15 is a CDS View that provides data about "The 15th view for FBAR" in SAP S/4HANA. It reads from 2 data sources (fqmet_balance, VFCLM_BAM_FBAR14) and exposes 3 fields with key fields BankAccountId, TransactionDate.

Data Sources (2)

SourceAliasJoin Type
fqmet_balance _bal inner
VFCLM_BAM_FBAR14 VFCLM_BAM_FBAR14 from

Parameters (4)

NameTypeDefault
pStartDate abap.dats
pEndDate abap.dats
pToCurrency abap.cuky( 5 )
pExgRateType abap.char( 4 )

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName VFCLMFBAR15 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label The 15th view for FBAR view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY BankAccountId balance BankAccountId
KEY TransactionDate balance TransactionDate Value Date
Currency balance BalanceCurrency

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 VFCLM_BAM_DDL_FBAR15.
-- 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: VFCLMFBAR15
-- Parameters: pStartDate : abap.dats, pEndDate : abap.dats, pToCurrency : abap.cuky( 5 ), pExgRateType : abap.char( 4 )

CREATE VIEW VFCLM_BAM_DDL_FBAR15 AS
SELECT
  balance.BankAccountId AS BankAccountId,
  balance.TransactionDate AS TransactionDate,
  balance.BalanceCurrency AS Currency
FROM VFCLM_BAM_FBAR14
INNER JOIN fqmet_balance AS _bal ON /* join condition not captured in parsed metadata */
;