ACE_ACEPSOIT_SUM_01

DDL: ACE_ACEPSOIT_SUM_01 SQL: ACEV_ACEPSOITS1 Type: view Package: ACE_MIG
10 Fields 1 Data Sources

Calculate amount of each year

ACE_ACEPSOIT_SUM_01 is a CDS View that provides data about "Calculate amount of each year" in SAP S/4HANA. It reads from 1 data source (acepsoit) and exposes 10 fields with key fields mandt, comp, bukrs, gjahr, objid. Part of development package ACE_MIG.

Data Sources (1)

SourceAliasJoin Type
acepsoit acepsoit from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ACEV_ACEPSOITS1 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 Calculate amount of each year view

Fields (10)

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
currency currency Valuation Crcy

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_SUM_01.
-- 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_ACEPSOITS1

CREATE VIEW ACE_ACEPSOIT_SUM_01 AS
SELECT
  mandt,
  comp,
  bukrs,
  gjahr,
  objid,
  subid,
  acrtype,
  accrule,
  '01010000' AS lasteffdate,
  currency
FROM acepsoit
;

Learn More