ACE_ACEPSOI_BASIC

DDL: ACE_ACEPSOI_BASIC SQL: ACEV_ACEPSOIBSC Type: view
17 Fields 3 Data Sources

basic view for ACEPSOI

ACE_ACEPSOI_BASIC is a CDS View that provides data about "basic view for ACEPSOI" in SAP S/4HANA. It reads from 3 data sources (acac_objects, acepsoi, acesobj) and exposes 17 fields with key fields mandt, comp, bukrs, gjahr, objid.

Data Sources (3)

SourceAliasJoin Type
acac_objects acac_objects left_outer
acepsoi acepsoi from
acesobj acesobj left_outer

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ACEV_ACEPSOIBSC 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 basic view for ACEPSOI view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY mandt acepsoi mandt Editing Client
KEY comp acepsoi comp Legal competence
KEY bukrs acepsoi bukrs Value
KEY gjahr gjahr Settlement Year
KEY objid acepsoi objid Work Center
KEY subid acepsoi subid Topic ID
KEY acrtype acrtype Accrual Type
KEY accrule accrule Accounting Principle
cumvalcap cumvalcap Cuml.Asset Val. PYs
cumvalaccr cumvalaccr Cumul.Recog. PYears
valcap valcap Asset Amt
valaccr valaccr Recognition
valretire valretire Prem Finish Amt
currency currency Valuation Crcy
ref_key acesobj ref_key Source Reference Key
ref_subkey acesobj ref_subkey Ext Ref of Subobject
acac_objtype acac_objects acac_objtype Accr Object Cat

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_ACEPSOI_BASIC.
-- 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_ACEPSOIBSC

CREATE VIEW ACE_ACEPSOI_BASIC AS
SELECT
  acepsoi.mandt AS mandt,
  acepsoi.comp AS comp,
  acepsoi.bukrs AS bukrs,
  gjahr,
  acepsoi.objid AS objid,
  acepsoi.subid AS subid,
  acrtype,
  accrule,
  cumvalcap,
  cumvalaccr,
  valcap,
  valaccr,
  valretire,
  currency,
  acesobj.ref_key AS ref_key,
  acesobj.ref_subkey AS ref_subkey,
  acac_objects.acac_objtype AS acac_objtype
FROM acepsoi
LEFT OUTER JOIN acesobj ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN acac_objects ON /* join condition not captured in parsed metadata */
;

Learn More