FINOC_PCK_IPRJH

DDL: FINOC_PCK_IPRJH SQL: FINOCV_PCK_IPRJH Type: view

OrglChange: Internal Projects Header

FINOC_PCK_IPRJH is a CDS View that provides data about "OrglChange: Internal Projects Header" in SAP S/4HANA. It reads from 2 data sources (proj, finoc_rt_pro) and exposes 8 fields.

Data Sources (2)

SourceAliasJoin Type
proj proj inner
finoc_rt_pro runtime from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FINOCV_PCK_IPRJH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label OrglChange: Internal Projects Header view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

Fields (8)

KeyFieldSource TableSource FieldDescription
prctr finoc_rt_pro prctr Profit Centers
prctr_old finoc_rt_pro prctr_old Old Profit Center
ps_prj_pnr finoc_rt_pro ps_prj_pnr Project def.
kokrs finoc_rt_pro kokrs Org. Value
valid_from finoc_rt_pro valid_from Validity Start Time
orgl_change finoc_rt_pro orgl_change Organizational Change
bukrs finoc_rt_pro bukrs Value
profl proj profl Project Profile

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 FINOC_PCK_IPRJH.
-- 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: FINOCV_PCK_IPRJH

CREATE VIEW FINOC_PCK_IPRJH AS
SELECT
  runtime.prctr AS prctr,
  runtime.prctr_old AS prctr_old,
  runtime.ps_prj_pnr AS ps_prj_pnr,
  runtime.kokrs AS kokrs,
  runtime.valid_from AS valid_from,
  runtime.orgl_change AS orgl_change,
  runtime.bukrs AS bukrs,
  proj.profl AS profl
FROM finoc_rt_pro AS runtime
INNER JOIN proj ON /* join condition not captured in parsed metadata */
;