Fclm_Bam_Amdwithau

DDL: FCLM_BAM_AMDWITHAU SQL: VFCLM_BAM_AMDWAU Type: view
23 Fields 1 Data Sources

Bank account data with authorization

Fclm_Bam_Amdwithau is a CDS View that provides data about "Bank account data with authorization" in SAP S/4HANA. It reads from 1 data source (FCLM_BAM_DDL_AMD_BASE_NO_HBA) and exposes 23 fields with key field acc_id.

Data Sources (1)

SourceAliasJoin Type
FCLM_BAM_DDL_AMD_BASE_NO_HBA FCLM_BAM_DDL_AMD_BASE_NO_HBA from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName VFCLM_BAM_AMDWAU view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Bank account data with authorization view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY acc_id acc_id Technical ID
banks banks Bank Ctry/Rgn. Key
bankl bankl House Bank
acc_num acc_num Account Number
acc_type_id acc_type_id Account Type
valid_from valid_from Validity Start Time
valid_to valid_to Validity End Time
iban iban IBAN House Bank
Status status Workflow Status
bukrs bukrs Value
prctr prctr Profit Centers
gsber gsber Business Area
segment segment Segment number
beneficial beneficial Account Holder
bank_contact bank_contact General Contact
rel_manager rel_manager Relationship Manager
edbsum edbsum EoD
idbsum idbsum Intraday
created_by created_by Version Created By
opened_by opened_by Opened By
changed_by changed_by User Name
closed_by closed_by Closed By
deleted_flag 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_Amdwithau.
-- 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_AMDWAU

CREATE VIEW Fclm_Bam_Amdwithau AS
SELECT
  acc_id,
  banks,
  bankl,
  acc_num,
  acc_type_id,
  valid_from,
  valid_to,
  iban,
  Status,
  bukrs,
  prctr,
  gsber,
  segment,
  beneficial,
  bank_contact,
  rel_manager,
  edbsum,
  idbsum,
  created_by,
  opened_by,
  changed_by,
  closed_by,
  deleted_flag
FROM FCLM_BAM_DDL_AMD_BASE_NO_HBA
;

Learn More