ACE_ACCOUNT_PRINCIPLE_LEDGER

DDL: ACE_ACCOUNT_PRINCIPLE_LEDGER SQL: ACEV_APLEDGER Type: view
10 Fields 10 Data Sources

Accrual Account Principle and Ledger

ACE_ACCOUNT_PRINCIPLE_LEDGER is a CDS View that provides data about "Accrual Account Principle and Ledger" in SAP S/4HANA. It reads from 10 data sources and exposes 10 fields with key fields comp, bukrs, accrule, rldnrkeycomp, bukrs.

Data Sources (10)

SourceAliasJoin Type
tace_combination a from
tace_combination a union_all
tace_combination a union_all
finsc_ld_cmp b inner
tacc_trgt_ldgr b inner
tacc_trgt_ldgr b inner
finsc_ledger c inner
finsc_ld_cmp c inner
fagl_tldgrp_map c inner
finsc_ledger d inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ACEV_APLEDGER view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Accrual Account Principle and Ledger view
AbapCatalog.preserveKey true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY comp comp Legal competence
KEY bukrs tace_combination bukrs Value
KEY accrule accrule Accounting Principle
KEY rldnrkeycomp
KEY bukrs tace_combination bukrs Value
KEY accrule accrule Accounting Principle
KEY ldgrpkeycomp
KEY bukrs tace_combination bukrs Value
KEY accrule accrule Accounting Principle
KEY rldnr fagl_tldgrp_map rldnr Ledger (Compat.)

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_ACCOUNT_PRINCIPLE_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_APLEDGER

CREATE VIEW ACE_ACCOUNT_PRINCIPLE_LEDGER AS
SELECT
  comp,
  a.bukrs AS bukrs,
  accrule,
  c.rldnr AS rldnrkeycomp,
  c.rldnr AS ldgrpkeycomp,
  c.rldnr AS rldnr
FROM tace_combination AS a
INNER JOIN finsc_ld_cmp AS b ON /* join condition not captured in parsed metadata */
INNER JOIN finsc_ledger AS c ON /* join condition not captured in parsed metadata */
INNER JOIN tacc_trgt_ldgr AS b ON /* join condition not captured in parsed metadata */
INNER JOIN finsc_ld_cmp AS c ON /* join condition not captured in parsed metadata */
INNER JOIN finsc_ledger AS d ON /* join condition not captured in parsed metadata */
INNER JOIN fagl_tldgrp_map AS c ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): tace_combination
;

Learn More