VFCLM_BAM_DDL_AMD_LIM_WITHDESP

DDL: FCLM_BAM_AMDLIM_WITHDESP SQL: VFCLM_BAM_AMDLID Type: view

VFCLM_BAM_DDL_AMD_LIM_WITHDESP is a CDS View in SAP S/4HANA. It reads from 2 data sources (tcurt, VFCLM_BAM_DDL_AMD_LIM) and exposes 7 fields with key fields AccountID, LimitID.

Data Sources (2)

SourceAliasJoin Type
tcurt curr_desp left_outer
VFCLM_BAM_DDL_AMD_LIM header from

Parameters (1)

NameTypeDefault
plang abap.lang

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName VFCLM_BAM_AMDLID view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY AccountID VFCLM_BAM_DDL_AMD_LIM AccountID Account no.
KEY LimitID VFCLM_BAM_DDL_AMD_LIM LimitID
ValidFrom VFCLM_BAM_DDL_AMD_LIM ValidFrom Vers.Valid From
ValidTo VFCLM_BAM_DDL_AMD_LIM ValidTo Vers.Valid To
Amount VFCLM_BAM_DDL_AMD_LIM Amount Value Amount
Currency VFCLM_BAM_DDL_AMD_LIM Currency Valuation Crcy
CurrencyDesp tcurt ltext Text exists

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_AMD_LIM_WITHDESP.
-- 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: VFCLM_BAM_AMDLID
-- Parameters: plang : abap.lang

CREATE VIEW VFCLM_BAM_DDL_AMD_LIM_WITHDESP AS
SELECT
  header.AccountID AS AccountID,
  header.LimitID AS LimitID,
  header.ValidFrom AS ValidFrom,
  header.ValidTo AS ValidTo,
  header.Amount AS Amount,
  header.Currency AS Currency,
  curr_desp.ltext AS CurrencyDesp
FROM VFCLM_BAM_DDL_AMD_LIM AS header
LEFT OUTER JOIN tcurt AS curr_desp ON /* join condition not captured in parsed metadata */
;