FCLM_BAM_DOC_DM_BK_ATTR

DDL: FCLM_BAM_DOC_DM_BK_ATTR SQL: VFCLMBAMBKATTR Type: view Package: FCLM_BAM
7 Fields 2 Data Sources

Active Company Code List of FI

FCLM_BAM_DOC_DM_BK_ATTR is a CDS View that provides data about "Active Company Code List of FI" in SAP S/4HANA. It reads from 2 data sources (FCLM_BAM_DDL_AMD_BASE_NO_HBA, bnka) and exposes 7 fields. Part of development package FCLM_BAM.

Data Sources (2)

SourceAliasJoin Type
FCLM_BAM_DDL_AMD_BASE_NO_HBA a from
bnka b left_outer

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName VFCLMBAMBKATTR view
ClientDependent true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Active Company Code List of FI view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view

Fields (7)

KeyFieldSource TableSource FieldDescription
mandt FCLM_BAM_DDL_AMD_BASE_NO_HBA mandt Editing Client
banks FCLM_BAM_DDL_AMD_BASE_NO_HBA banks Bank Ctry/Rgn. Key
bankl FCLM_BAM_DDL_AMD_BASE_NO_HBA bankl House Bank
acc_id FCLM_BAM_DDL_AMD_BASE_NO_HBA acc_id Technical ID
acc_num FCLM_BAM_DDL_AMD_BASE_NO_HBA acc_num Account Number
bukrs FCLM_BAM_DDL_AMD_BASE_NO_HBA bukrs Value
bgrup

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_DOC_DM_BK_ATTR.
-- 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: VFCLMBAMBKATTR

CREATE VIEW FCLM_BAM_DOC_DM_BK_ATTR AS
SELECT
  a.mandt AS mandt,
  a.banks AS banks,
  a.bankl AS bankl,
  a.acc_id AS acc_id,
  a.acc_num AS acc_num,
  a.bukrs AS bukrs,
  cast(coalesce(b.bgrup,'') as bgrup ) AS bgrup
FROM FCLM_BAM_DDL_AMD_BASE_NO_HBA AS a
LEFT OUTER JOIN bnka AS b ON /* join condition not captured in parsed metadata */
;

Learn More