VFCLM_BAM_DDL_RTNODEATTR_ACT

DDL: FCLM_BAM_HIER__RTNODEATTR_ACT SQL: VFCLMBAMRTNDAT2 Type: view

Active node from VFCLMBAMRTNDAT

VFCLM_BAM_DDL_RTNODEATTR_ACT is a CDS View that provides data about "Active node from VFCLMBAMRTNDAT" in SAP S/4HANA. It reads from 1 data source (VFCLM_BAM_DDL_HIERRTNODEATTR) and exposes 52 fields.

Data Sources (1)

SourceAliasJoin Type
VFCLM_BAM_DDL_HIERRTNODEATTR VFCLM_BAM_DDL_HIERRTNODEATTR from

Parameters (2)

NameTypeDefault
pdate abap.dats
plang abap.lang

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName VFCLMBAMRTNDAT2 view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #D view
EndUserText.label Active node from VFCLMBAMRTNDAT view

Fields (52)

KeyFieldSource TableSource FieldDescription
AccountTypeDesp VFCLM_BAM_DDL_HIERRTNODEATTR AccountTypeDesp
BankCountryDesp VFCLM_BAM_DDL_HIERRTNODEATTR BankCountryDesp
BusinessAreaDesp VFCLM_BAM_DDL_HIERRTNODEATTR BusinessAreaDesp
CompanyCodeCountry VFCLM_BAM_DDL_HIERRTNODEATTR CompanyCodeCountry Reporting Ctry/Reg.
CurrencyDesp VFCLM_BAM_DDL_HIERRTNODEATTR CurrencyDesp
EoDImportDesp VFCLM_BAM_DDL_HIERRTNODEATTR EoDImportDesp
InApprovalProcess VFCLM_BAM_DDL_HIERRTNODEATTR InApprovalProcess
SegmentDesp VFCLM_BAM_DDL_HIERRTNODEATTR SegmentDesp
StatusDesp VFCLM_BAM_DDL_HIERRTNODEATTR StatusDesp
acc_id VFCLM_BAM_DDL_HIERRTNODEATTR acc_id Technical ID
acc_num VFCLM_BAM_DDL_HIERRTNODEATTR acc_num Account Number
acc_num_txt VFCLM_BAM_DDL_HIERRTNODEATTR acc_num_txt
acc_type_id VFCLM_BAM_DDL_HIERRTNODEATTR acc_type_id Account Type
bank_contact VFCLM_BAM_DDL_HIERRTNODEATTR bank_contact General Contact
banka VFCLM_BAM_DDL_HIERRTNODEATTR banka Bank Name
bankl VFCLM_BAM_DDL_HIERRTNODEATTR bankl House Bank
banks VFCLM_BAM_DDL_HIERRTNODEATTR banks Bank Ctry/Rgn. Key
beneficial VFCLM_BAM_DDL_HIERRTNODEATTR beneficial Account Holder
bnklz VFCLM_BAM_DDL_HIERRTNODEATTR bnklz Bank Number
bukrs VFCLM_BAM_DDL_HIERRTNODEATTR bukrs Value
butxt VFCLM_BAM_DDL_HIERRTNODEATTR butxt Posting Text
changed_by VFCLM_BAM_DDL_HIERRTNODEATTR changed_by User Name
childid VFCLM_BAM_DDL_HIERRTNODEATTR childid Node
closed_by VFCLM_BAM_DDL_HIERRTNODEATTR closed_by Closed By
control_key VFCLM_BAM_DDL_HIERRTNODEATTR control_key Control Key
created_by VFCLM_BAM_DDL_HIERRTNODEATTR created_by Version Created By
description VFCLM_BAM_DDL_HIERRTNODEATTR description Well Code Des.
edbsum VFCLM_BAM_DDL_HIERRTNODEATTR edbsum EoD
gsber VFCLM_BAM_DDL_HIERRTNODEATTR gsber Business Area
hbkid VFCLM_BAM_DDL_HIERRTNODEATTR hbkid House Bank
hierid VFCLM_BAM_DDL_HIERRTNODEATTR hierid R/2 table
hktid VFCLM_BAM_DDL_HIERRTNODEATTR hktid House Bank Account
iban VFCLM_BAM_DDL_HIERRTNODEATTR iban IBAN House Bank
idbsum VFCLM_BAM_DDL_HIERRTNODEATTR idbsum Intraday
nextid VFCLM_BAM_DDL_HIERRTNODEATTR nextid Node
nodeid VFCLM_BAM_DDL_HIERRTNODEATTR nodeid Workflow Step
nodelevel VFCLM_BAM_DDL_HIERRTNODEATTR nodelevel Node Level
nodename VFCLM_BAM_DDL_HIERRTNODEATTR nodename Node Text
nodevalid_to VFCLM_BAM_DDL_HIERRTNODEATTR nodevalid_to
opened_by VFCLM_BAM_DDL_HIERRTNODEATTR opened_by Opened By
par_hiernode VFCLM_BAM_DDL_HIERRTNODEATTR par_hiernode Node
partner VFCLM_BAM_DDL_HIERRTNODEATTR partner With Partner
partner2 VFCLM_BAM_DDL_HIERRTNODEATTR partner2 Busn. Partner
prctr VFCLM_BAM_DDL_HIERRTNODEATTR prctr Profit Centers
rel_manager VFCLM_BAM_DDL_HIERRTNODEATTR rel_manager Relationship Manager
runtime_node VFCLM_BAM_DDL_HIERRTNODEATTR runtime_node Boolean Variable (X = True, - = False, Space = Unknown)
segment VFCLM_BAM_DDL_HIERRTNODEATTR segment Segment number
status VFCLM_BAM_DDL_HIERRTNODEATTR status Workflow Status
swift VFCLM_BAM_DDL_HIERRTNODEATTR swift SWIFT/BIC
valid_from VFCLM_BAM_DDL_HIERRTNODEATTR valid_from Validity Start Time
valid_to VFCLM_BAM_DDL_HIERRTNODEATTR valid_to Validity End Time
waers VFCLM_BAM_DDL_HIERRTNODEATTR waers Transaction Currency

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

CREATE VIEW VFCLM_BAM_DDL_RTNODEATTR_ACT AS
SELECT
  VFCLM_BAM_DDL_HIERRTNODEATTR.AccountTypeDesp AS AccountTypeDesp,
  VFCLM_BAM_DDL_HIERRTNODEATTR.BankCountryDesp AS BankCountryDesp,
  VFCLM_BAM_DDL_HIERRTNODEATTR.BusinessAreaDesp AS BusinessAreaDesp,
  VFCLM_BAM_DDL_HIERRTNODEATTR.CompanyCodeCountry AS CompanyCodeCountry,
  VFCLM_BAM_DDL_HIERRTNODEATTR.CurrencyDesp AS CurrencyDesp,
  VFCLM_BAM_DDL_HIERRTNODEATTR.EoDImportDesp AS EoDImportDesp,
  VFCLM_BAM_DDL_HIERRTNODEATTR.InApprovalProcess AS InApprovalProcess,
  VFCLM_BAM_DDL_HIERRTNODEATTR.SegmentDesp AS SegmentDesp,
  VFCLM_BAM_DDL_HIERRTNODEATTR.StatusDesp AS StatusDesp,
  VFCLM_BAM_DDL_HIERRTNODEATTR.acc_id AS acc_id,
  VFCLM_BAM_DDL_HIERRTNODEATTR.acc_num AS acc_num,
  VFCLM_BAM_DDL_HIERRTNODEATTR.acc_num_txt AS acc_num_txt,
  VFCLM_BAM_DDL_HIERRTNODEATTR.acc_type_id AS acc_type_id,
  VFCLM_BAM_DDL_HIERRTNODEATTR.bank_contact AS bank_contact,
  VFCLM_BAM_DDL_HIERRTNODEATTR.banka AS banka,
  VFCLM_BAM_DDL_HIERRTNODEATTR.bankl AS bankl,
  VFCLM_BAM_DDL_HIERRTNODEATTR.banks AS banks,
  VFCLM_BAM_DDL_HIERRTNODEATTR.beneficial AS beneficial,
  VFCLM_BAM_DDL_HIERRTNODEATTR.bnklz AS bnklz,
  VFCLM_BAM_DDL_HIERRTNODEATTR.bukrs AS bukrs,
  VFCLM_BAM_DDL_HIERRTNODEATTR.butxt AS butxt,
  VFCLM_BAM_DDL_HIERRTNODEATTR.changed_by AS changed_by,
  VFCLM_BAM_DDL_HIERRTNODEATTR.childid AS childid,
  VFCLM_BAM_DDL_HIERRTNODEATTR.closed_by AS closed_by,
  VFCLM_BAM_DDL_HIERRTNODEATTR.control_key AS control_key,
  VFCLM_BAM_DDL_HIERRTNODEATTR.created_by AS created_by,
  VFCLM_BAM_DDL_HIERRTNODEATTR.description AS description,
  VFCLM_BAM_DDL_HIERRTNODEATTR.edbsum AS edbsum,
  VFCLM_BAM_DDL_HIERRTNODEATTR.gsber AS gsber,
  VFCLM_BAM_DDL_HIERRTNODEATTR.hbkid AS hbkid,
  VFCLM_BAM_DDL_HIERRTNODEATTR.hierid AS hierid,
  VFCLM_BAM_DDL_HIERRTNODEATTR.hktid AS hktid,
  VFCLM_BAM_DDL_HIERRTNODEATTR.iban AS iban,
  VFCLM_BAM_DDL_HIERRTNODEATTR.idbsum AS idbsum,
  VFCLM_BAM_DDL_HIERRTNODEATTR.nextid AS nextid,
  VFCLM_BAM_DDL_HIERRTNODEATTR.nodeid AS nodeid,
  VFCLM_BAM_DDL_HIERRTNODEATTR.nodelevel AS nodelevel,
  VFCLM_BAM_DDL_HIERRTNODEATTR.nodename AS nodename,
  VFCLM_BAM_DDL_HIERRTNODEATTR.nodevalid_to AS nodevalid_to,
  VFCLM_BAM_DDL_HIERRTNODEATTR.opened_by AS opened_by,
  VFCLM_BAM_DDL_HIERRTNODEATTR.par_hiernode AS par_hiernode,
  VFCLM_BAM_DDL_HIERRTNODEATTR.partner AS partner,
  VFCLM_BAM_DDL_HIERRTNODEATTR.partner2 AS partner2,
  VFCLM_BAM_DDL_HIERRTNODEATTR.prctr AS prctr,
  VFCLM_BAM_DDL_HIERRTNODEATTR.rel_manager AS rel_manager,
  VFCLM_BAM_DDL_HIERRTNODEATTR.runtime_node AS runtime_node,
  VFCLM_BAM_DDL_HIERRTNODEATTR.segment AS segment,
  VFCLM_BAM_DDL_HIERRTNODEATTR.status AS status,
  VFCLM_BAM_DDL_HIERRTNODEATTR.swift AS swift,
  VFCLM_BAM_DDL_HIERRTNODEATTR.valid_from AS valid_from,
  VFCLM_BAM_DDL_HIERRTNODEATTR.valid_to AS valid_to,
  VFCLM_BAM_DDL_HIERRTNODEATTR.waers AS waers
FROM VFCLM_BAM_DDL_HIERRTNODEATTR
;