ACE_ACEPSOIT_ACEPSOITV_UNION

DDL: ACE_ACEPSOIT_ACEPSOITV_UNION SQL: ACEV_ACEPSOITVU Type: view Package: ACE_MIG
31 Fields 2 Data Sources

Union ACEPSOIT and view ACEPSOIT

ACE_ACEPSOIT_ACEPSOITV_UNION is a CDS View that provides data about "Union ACEPSOIT and view ACEPSOIT" in SAP S/4HANA. It reads from 2 data sources (ACE_ACEPSOIT, acepsoit) and exposes 31 fields with key fields mandt, comp, bukrs, objid, subid. Part of development package ACE_MIG.

Data Sources (2)

SourceAliasJoin Type
ACE_ACEPSOIT ACE_ACEPSOIT union_all
acepsoit acepsoit from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ACEV_ACEPSOITVU view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Union ACEPSOIT and view ACEPSOIT view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY mandt mandt Editing Client
KEY comp comp Legal competence
KEY bukrs bukrs Value
KEY objid objid Work Center
KEY subid subid Topic ID
KEY acrtype acrtype Accrual Type
KEY accrule accrule Accounting Principle
valtbp Posted
currency currency Valuation Crcy
transtype transtype ACE Transaction
effdate effdate Key Date for Accrls
podate podate Posting Date
poper poper Posting periods
poyear poyear FI Fiscal Year
awtyp awtyp Reference Document Type
KEY comp comp Legal competence
KEY bukrs bukrs Value
KEY gjahr gjahr Settlement Year
KEY objid objid Work Center
KEY subid subid Topic ID
KEY acrtype acrtype Accrual Type
KEY accrule accrule Accounting Principle
valtbp valtbp Posted
currency currency Valuation Crcy
transtype transtype ACE Transaction
effdate effdate Key Date for Accrls
podate podate Posting Date
poper poper Posting periods
poyear poyear FI Fiscal Year
awtyp awtyp Reference Document Type
awkey awkey RefKey GJE

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 ACE_ACEPSOIT_ACEPSOITV_UNION.
-- 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: ACEV_ACEPSOITVU

CREATE VIEW ACE_ACEPSOIT_ACEPSOITV_UNION AS
SELECT
  mandt,
  comp,
  bukrs,
  objid,
  subid,
  acrtype,
  accrule,
  (-1)*valtbp AS valtbp,
  currency,
  transtype,
  effdate,
  podate,
  poper,
  poyear,
  awtyp,
  gjahr,
  awkey
FROM acepsoit
-- UNION ALL with additional select branch(es): ACE_ACEPSOIT
;

Learn More