FCLM_BAH_UH_BANKACCGROUP

DDL: FCLM_BAH_UH_BANKACCGROUP SQL: VFCLMBAHVH Type: view Package: FCLM_BAM
13 Fields 2 Data Sources

Bank Account Group Value Help

FCLM_BAH_UH_BANKACCGROUP is a CDS View that provides data about "Bank Account Group Value Help" in SAP S/4HANA. It reads from 2 data sources (fclm_bam_hier, fclm_bam_hiert) and exposes 13 fields with key fields BankAccountHierarchy, ValidityEndDate. Part of development package FCLM_BAM.

Data Sources (2)

SourceAliasJoin Type
fclm_bam_hier hier from
fclm_bam_hiert text left_outer

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName VFCLMBAHVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Bank Account Group Value Help view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY BankAccountHierarchy fclm_bam_hier hierid R/2 table
KEY ValidityEndDate fclm_bam_hier valid_to Validity End Time
ValidityStartDate fclm_bam_hier valid_from Validity Start Time
HierarchyType fclm_bam_hier hiertype Hierarchy Type
CreatedByUser created_by Version Created By
CreationDate created_on Variant created on
CreationTime created_at Uploaded On
LastChangedByUser changed_by User Name
LastChangeDate changed_on Variant Changed on
LastChangeTime changed_at Timestamp
IsCashPool
IsPublicHierarchy public_hier Boolean Variable (X = True, - = False, Space = Unknown)
BankAccountHierarchyName fclm_bam_hiert hiername Account Group Text

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_BAH_UH_BANKACCGROUP.
-- 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: VFCLMBAHVH

CREATE VIEW FCLM_BAH_UH_BANKACCGROUP AS
SELECT
  hier.hierid AS BankAccountHierarchy,
  hier.valid_to AS ValidityEndDate,
  hier.valid_from AS ValidityStartDate,
  hier.hiertype AS HierarchyType,
  created_by AS CreatedByUser,
  created_on AS CreationDate,
  created_at AS CreationTime,
  changed_by AS LastChangedByUser,
  changed_on AS LastChangeDate,
  changed_at AS LastChangeTime,
  '' AS IsCashPool,
  public_hier AS IsPublicHierarchy,
  text.hiername AS BankAccountHierarchyName
FROM fclm_bam_hier AS hier
LEFT OUTER JOIN fclm_bam_hiert AS text ON /* join condition not captured in parsed metadata */
;

Learn More