v_acdoct_per_view

DDL: V_ACDOCT_PER_DDL SQL: V_ACDOCT_PER Type: view
2 Data Sources

Period sums of ACDOCA without period block

v_acdoct_per_view is a CDS View that provides data about "Period sums of ACDOCA without period block" in SAP S/4HANA. It reads from 2 data sources (finsc_ld_cmp, finsc_ledger_rep).

Data Sources (2)

SourceAliasJoin Type
finsc_ld_cmp lc inner
finsc_ledger_rep lr inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName V_ACDOCT_PER view
EndUserText.label Period sums of ACDOCA without period block view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view

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 v_acdoct_per_view.
-- 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: V_ACDOCT_PER

CREATE VIEW v_acdoct_per_view AS
SELECT *  -- field list not available in parsed metadata
INNER JOIN finsc_ledger_rep AS lr ON /* join condition not captured in parsed metadata */
INNER JOIN finsc_ld_cmp AS lc ON /* join condition not captured in parsed metadata */
;

Learn More