fins_prctr_of_object_acdoca

DDL: FINS_PRCTR_OF_OBJECT_ACDOCA SQL: FINSPRCTR Type: view

Derive PRCTR & PPRCTR for ACDOCA object

fins_prctr_of_object_acdoca is a CDS View that provides data about "Derive PRCTR & PPRCTR for ACDOCA object" in SAP S/4HANA. It reads from 28 data sources.

Data Sources (28)

SourceAliasJoin Type
afvc af left_outer
afko afk left_outer
aufk afu left_outer
onrao ao left_outer
aufk aun left_outer
aufk auo left_outer
cbpr cb left_outer
csks ks left_outer
prps p left_outer
cbpr pacb left_outer
afvc paf left_outer
afko pafk left_outer
aufk pafu left_outer
onrao pao left_outer
aufk paun left_outer
aufk pauo left_outer
csks pks left_outer
prps pp left_outer
proj ppro left_outer
proj pro left_outer
tvko ptv left_outer
vicn01 pvi left_outer
vbak pvk left_outer
vbap pvp left_outer
tvko tv left_outer
vicn01 vi left_outer
vbak vk left_outer
vbap vp left_outer

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FINSPRCTR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Derive PRCTR & PPRCTR for ACDOCA object 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 fins_prctr_of_object_acdoca.
-- 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: FINSPRCTR

CREATE VIEW fins_prctr_of_object_acdoca AS
SELECT *  -- field list not available in parsed metadata
LEFT OUTER JOIN afvc AS af ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN afko AS afk ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aufk AS afu ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aufk AS auo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aufk AS aun ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN prps AS p ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN proj AS pro ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN csks AS ks ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vbak AS vk ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vbap AS vp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tvko AS tv ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN onrao AS ao ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vicn01 AS vi ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cbpr AS cb ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN afvc AS paf ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN afko AS pafk ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aufk AS pafu ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aufk AS pauo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aufk AS paun ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN prps AS pp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN proj AS ppro ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN csks AS pks ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vbak AS pvk ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vbap AS pvp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tvko AS ptv ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN onrao AS pao ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vicn01 AS pvi ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cbpr AS pacb ON /* join condition not captured in parsed metadata */
;