finoc_pck_pc

DDL: FINOC_PCK_PC Type: view_entity
9 Fields 2 Data Sources

Orgl Change Profit Center Packaging

finoc_pck_pc is a CDS View that provides data about "Orgl Change Profit Center Packaging" in SAP S/4HANA. It reads from 2 data sources (cepc_bukrs, tka02) and exposes 9 fields with key fields kokrs, prctr, valid_from, bukrs.

Data Sources (2)

SourceAliasJoin Type
cepc_bukrs cepc_bukrs left_outer
tka02 tka02 left_outer

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Orgl Change Profit Center Packaging view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY kokrs rt kokrs Org. Value
KEY prctr rt prctr Profit Centers
KEY valid_from rt valid_from Validity Start Time
KEY bukrs
valid_to rt valid_to Validity End Time
segment_old rt segment_old
segment rt segment Segment number
orgl_change rt orgl_change Organizational Change
marker rt marker Marker

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_pc.
-- 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.

CREATE VIEW finoc_pck_pc AS
SELECT
  rt.kokrs AS kokrs,
  rt.prctr AS prctr,
  rt.valid_from AS valid_from,
  coalesce(cepc_bukrs.bukrs, tka02.bukrs) AS bukrs,
  rt.valid_to AS valid_to,
  rt.segment_old AS segment_old,
  rt.segment AS segment,
  rt.orgl_change AS orgl_change,
  rt.marker AS marker
LEFT OUTER JOIN cepc_bukrs ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tka02 ON /* join condition not captured in parsed metadata */
;

Learn More