FCLM_BAM_AMD_FOR_DPP

DDL: FCLM_BAM_AMD_FOR_DPP SQL: VFCLMDPP Type: view

BAM AMD view for DPP

FCLM_BAM_AMD_FOR_DPP is a CDS View that provides data about "BAM AMD view for DPP" in SAP S/4HANA. It reads from 2 data sources (fclm_bam_amd, fclm_bam_rev) and exposes 8 fields.

Data Sources (2)

SourceAliasJoin Type
fclm_bam_amd header from
fclm_bam_rev rev left_outer

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName VFCLMDPP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label BAM AMD view for DPP view

Fields (8)

KeyFieldSource TableSource FieldDescription
acc_id fclm_bam_amd acc_id Technical ID
revision fclm_bam_amd revision Revision Number
acc_num fclm_bam_amd acc_num Account Number
bank_contact fclm_bam_amd bank_contact General Contact
rel_manager fclm_bam_amd rel_manager Relationship Manager
status fclm_bam_amd status Workflow Status
rev_status fclm_bam_rev rev_status Revision Status
deleted_flag fclm_bam_amd deleted_flag TRUE

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 FCLM_BAM_AMD_FOR_DPP.
-- 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: VFCLMDPP

CREATE VIEW FCLM_BAM_AMD_FOR_DPP AS
SELECT
  header.acc_id AS acc_id,
  header.revision AS revision,
  header.acc_num AS acc_num,
  header.bank_contact AS bank_contact,
  header.rel_manager AS rel_manager,
  header.status AS status,
  rev.rev_status AS rev_status,
  header.deleted_flag AS deleted_flag
FROM fclm_bam_amd AS header
LEFT OUTER JOIN fclm_bam_rev AS rev ON /* join condition not captured in parsed metadata */
;