FAC_DART_Z3_WIP_ACCOUNTUNION

DDL: FAC_DART_Z3_WIP_ACCOUNTUNION SQL: FAC_DZWIPACCU Type: view
4 Fields 5 Data Sources

Dart Z3 WIP Accounts Union

FAC_DART_Z3_WIP_ACCOUNTUNION is a CDS View that provides data about "Dart Z3 WIP Accounts Union" in SAP S/4HANA. It reads from 5 data sources (fcoc_ebw_assg_cc, fcoc_ebw_assg_cc, fcoc_ebw_assg_cc, fcoc_ebw_assg_it, fcoc_ebw_assg_it) and exposes 4 fields with key fields CompanyCode, company_codeasCompanyCode, company_codeasCompanyCode, GLAccount.

Data Sources (5)

SourceAliasJoin Type
fcoc_ebw_assg_cc CC from
fcoc_ebw_assg_cc CC union_all
fcoc_ebw_assg_cc CC union_all
fcoc_ebw_assg_it it inner
fcoc_ebw_assg_it it inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FAC_DZWIPACCU view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Dart Z3 WIP Accounts Union view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode bukrs Value
KEY company_codeasCompanyCode G/L act balance
KEY company_codeasCompanyCode G/L act balance
KEY GLAccount

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 FAC_DART_Z3_WIP_ACCOUNTUNION.
-- 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: FAC_DZWIPACCU

CREATE VIEW FAC_DART_Z3_WIP_ACCOUNTUNION AS
SELECT
  bukrs AS CompanyCode,
  cast( sakha as saknr ) as GLAccount AS company_codeasCompanyCode,
  cast( it.rsrv_bs_acct as saknr ) AS GLAccount
FROM fcoc_ebw_assg_cc AS CC
INNER JOIN fcoc_ebw_assg_it AS it ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): fcoc_ebw_assg_cc
;

Learn More