ACE_ACEPSOI_04

DDL: ACE_ACEPSOI_04 SQL: ACEV_ACEPSOI4 Type: view
9 Fields 1 Data Sources

Compatibility view for ACEPSOI 04

ACE_ACEPSOI_04 is a CDS View that provides data about "Compatibility view for ACEPSOI 04" in SAP S/4HANA. It reads from 1 data source (ACE_ACDOCA_MIG) and exposes 9 fields with key fields mandt, comp, bukrs, gjahr, objid.

Data Sources (1)

SourceAliasJoin Type
ACE_ACDOCA_MIG ACE_ACDOCA_MIG from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ACEV_ACEPSOI4 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 Compatibility view for ACEPSOI 04 view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY mandt mandt Editing Client
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
lasteffdate

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_04.
-- 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_ACEPSOI4

CREATE VIEW ACE_ACEPSOI_04 AS
SELECT
  mandt,
  comp,
  bukrs,
  gjahr,
  objid,
  subid,
  acrtype,
  accrule,
  max(effdate) AS lasteffdate
FROM ACE_ACDOCA_MIG
;

Learn More