VFCLM_BAM_DDL_RTNODEATTR_ACT
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)
| Source | Alias | Join Type |
|---|---|---|
| VFCLM_BAM_DDL_HIERRTNODEATTR | VFCLM_BAM_DDL_HIERRTNODEATTR | from |
Parameters (2)
| Name | Type | Default |
|---|---|---|
| pdate | abap.dats | |
| plang | abap.lang |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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
;
Learn More
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA