P_COPCCOrdPlnTgtWIPByObject

DDL: P_COPCCORDPLNTGTWIPBYOBJECT SQL: PPCCOPLNTGTWIPBO Type: view COMPOSITE
4 Fields 4 Data Sources

P_COPCCOrdPlnTgtWIPByObject is a Composite CDS View in SAP S/4HANA. It reads from 4 data sources (I_COPlanTargetByPeriod, I_ProductCostCtrlgOrder, I_TargetCostVariant, I_MfgOrdPlngCat) and exposes 4 fields with key fields ControllingObject, ControllingValueType.

Data Sources (4)

SourceAliasJoin Type
I_COPlanTargetByPeriod _COPlanTargetByPeriod from
I_ProductCostCtrlgOrder _ProductCostCtrlgOrder left_outer
I_TargetCostVariant _TargetCostVariant left_outer
I_MfgOrdPlngCat I_MfgOrdPlngCat left_outer

Parameters (2)

NameTypeDefault
P_FromFiscalYearPeriod fis_jahrper
P_ToFiscalYearPeriod fis_jahrper

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName PPCCOPLNTGTWIPBO view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.type #CLIENT_DEPENDENT view
AbapCatalog.compiler.compareFilter true view
VDM.private true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AbapCatalog.preserveKey true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ControllingObject ControllingObject Object number
KEY ControllingValueType ControllingValueType Value Type
OrderID I_COPlanTargetByPeriod OrderID Order ID
PlanningCategory PlanningCategory Plan Category

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 P_COPCCOrdPlnTgtWIPByObject.
-- 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: PPCCOPLNTGTWIPBO
-- Parameters: P_FromFiscalYearPeriod : fis_jahrper, P_ToFiscalYearPeriod : fis_jahrper

CREATE VIEW P_COPCCOrdPlnTgtWIPByObject AS
SELECT
  ControllingObject,
  ControllingValueType,
  _COPlanTargetByPeriod.OrderID AS OrderID,
  PlanningCategory
FROM I_COPlanTargetByPeriod AS _COPlanTargetByPeriod
LEFT OUTER JOIN I_ProductCostCtrlgOrder AS _ProductCostCtrlgOrder ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_TargetCostVariant AS _TargetCostVariant ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MfgOrdPlngCat ON /* join condition not captured in parsed metadata */
;

Learn More