VFCLM_BAM_DDL_BPHIER

DDL: FCLM_BAM_BPHIER SQL: VFCLMBAMBPH Type: view
44 Fields 2 Data Sources

BAM BP Based Hierarchy

VFCLM_BAM_DDL_BPHIER is a CDS View that provides data about "BAM BP Based Hierarchy" in SAP S/4HANA. It reads from 2 data sources (VFCLM_BAM_DDL_BPBNKALINK, VFCLM_BAM_DDL_BPHIERCORE) and exposes 44 fields with key fields partner, acc_id.

Data Sources (2)

SourceAliasJoin Type
VFCLM_BAM_DDL_BPBNKALINK VFCLM_BAM_DDL_BPBNKALINK from
VFCLM_BAM_DDL_BPHIERCORE VFCLM_BAM_DDL_BPHIERCORE left_outer

Parameters (2)

NameTypeDefault
pdate abap.dats
plang abap.lang

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName VFCLMBAMBPH view
AccessControl.authorizationCheck #NOT_ALLOWED view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label BAM BP Based Hierarchy view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY partner bpbnkalink partner With Partner
KEY acc_id bphiercore acc_id Technical ID
partner2 bpbnkalink partner2 Busn. Partner
bpname bpbnkalink name_org1 Name 1
banks bpbnkalink banks Bank Ctry/Rgn. Key
bankl bpbnkalink bankl House Bank
acc_num bphiercore acc_num Account Number
acc_num_txt bphiercore acc_num_txt
acc_type_id bphiercore acc_type_id Account Type
valid_from bphiercore valid_from Validity Start Time
valid_to bphiercore valid_to Validity End Time
iban bphiercore iban IBAN House Bank
status bphiercore status Workflow Status
bukrs bphiercore bukrs Value
prctr bphiercore prctr Profit Centers
gsber bphiercore gsber Business Area
segment bphiercore segment Segment number
beneficial bphiercore beneficial Account Holder
bank_contact bphiercore bank_contact General Contact
rel_manager bphiercore rel_manager Relationship Manager
edbsum bphiercore edbsum EoD
idbsum bphiercore idbsum Intraday
created_by bphiercore created_by Version Created By
opened_by bphiercore opened_by Opened By
changed_by bphiercore changed_by User Name
closed_by bphiercore closed_by Closed By
control_key bphiercore control_key Control Key
waers bphiercore waers Transaction Currency
hbkid bphiercore hbkid House Bank
hktid bphiercore hktid House Bank Account
banka bpbnkalink banka Bank Name
swift bpbnkalink swift SWIFT/BIC
bnklz bpbnkalink bnklz Bank Number
InApprovalProcess bphiercore InApprovalProcess
description bphiercore description Well Code Des.
butxt bphiercore butxt Posting Text
AccountTypeDesp bphiercore AccountTypeDesp
StatusDesp bphiercore StatusDesp
CurrencyDesp bphiercore CurrencyDesp
BusinessAreaDesp bphiercore BusinessAreaDesp
SegmentDesp bphiercore SegmentDesp
EoDImportDesp bphiercore EoDImportDesp
BankCountryDesp bphiercore BankCountryDesp
AccountNumberDesp bphiercore AccountNumberDesp

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_BPHIER.
-- 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: VFCLMBAMBPH
-- Parameters: pdate : abap.dats, plang : abap.lang

CREATE VIEW VFCLM_BAM_DDL_BPHIER AS
SELECT
  bpbnkalink.partner AS partner,
  bphiercore.acc_id AS acc_id,
  bpbnkalink.partner2 AS partner2,
  bpbnkalink.name_org1 AS bpname,
  bpbnkalink.banks AS banks,
  bpbnkalink.bankl AS bankl,
  bphiercore.acc_num AS acc_num,
  bphiercore.acc_num_txt AS acc_num_txt,
  bphiercore.acc_type_id AS acc_type_id,
  bphiercore.valid_from AS valid_from,
  bphiercore.valid_to AS valid_to,
  bphiercore.iban AS iban,
  bphiercore.status AS status,
  bphiercore.bukrs AS bukrs,
  bphiercore.prctr AS prctr,
  bphiercore.gsber AS gsber,
  bphiercore.segment AS segment,
  bphiercore.beneficial AS beneficial,
  bphiercore.bank_contact AS bank_contact,
  bphiercore.rel_manager AS rel_manager,
  bphiercore.edbsum AS edbsum,
  bphiercore.idbsum AS idbsum,
  bphiercore.created_by AS created_by,
  bphiercore.opened_by AS opened_by,
  bphiercore.changed_by AS changed_by,
  bphiercore.closed_by AS closed_by,
  bphiercore.control_key AS control_key,
  bphiercore.waers AS waers,
  bphiercore.hbkid AS hbkid,
  bphiercore.hktid AS hktid,
  bpbnkalink.banka AS banka,
  bpbnkalink.swift AS swift,
  bpbnkalink.bnklz AS bnklz,
  bphiercore.InApprovalProcess AS InApprovalProcess,
  bphiercore.description AS description,
  bphiercore.butxt AS butxt,
  bphiercore.AccountTypeDesp AS AccountTypeDesp,
  bphiercore.StatusDesp AS StatusDesp,
  bphiercore.CurrencyDesp AS CurrencyDesp,
  bphiercore.BusinessAreaDesp AS BusinessAreaDesp,
  bphiercore.SegmentDesp AS SegmentDesp,
  bphiercore.EoDImportDesp AS EoDImportDesp,
  bphiercore.BankCountryDesp AS BankCountryDesp,
  bphiercore.AccountNumberDesp AS AccountNumberDesp
FROM VFCLM_BAM_DDL_BPBNKALINK
LEFT OUTER JOIN VFCLM_BAM_DDL_BPHIERCORE ON /* join condition not captured in parsed metadata */
;

Learn More