ACE_ACEPSOI_LEDGER

DDL: ACE_ACEPSOI_LEDGER SQL: ACEV_ACEPSOIL Type: view
8 Fields 2 Data Sources

ACEPSOI with ledger

ACE_ACEPSOI_LEDGER is a CDS View that provides data about "ACEPSOI with ledger" in SAP S/4HANA. It reads from 2 data sources (acepsoi, ACE_ACCOUNT_PRINCIPLE_LEDGER) and exposes 8 fields with key fields comp, bukrs, gjahr, objid, subid.

Data Sources (2)

SourceAliasJoin Type
acepsoi a from
ACE_ACCOUNT_PRINCIPLE_LEDGER b left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ACEV_ACEPSOIL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #X view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.preserveKey true view
EndUserText.label ACEPSOI with ledger view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY comp acepsoi comp Legal competence
KEY bukrs acepsoi bukrs Value
KEY gjahr gjahr Settlement Year
KEY objid objid Work Center
KEY subid subid Topic ID
KEY accrule acepsoi accrule Accounting Principle
KEY rldnr rldnr Ledger (Compat.)
acrtype acepsoi acrtype Accrual Type

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_LEDGER.
-- 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_ACEPSOIL

CREATE VIEW ACE_ACEPSOI_LEDGER AS
SELECT
  a.comp AS comp,
  a.bukrs AS bukrs,
  gjahr,
  objid,
  subid,
  a.accrule AS accrule,
  rldnr,
  a.acrtype AS acrtype
FROM acepsoi AS a
LEFT OUTER JOIN ACE_ACCOUNT_PRINCIPLE_LEDGER AS b ON /* join condition not captured in parsed metadata */
;

Learn More