I_RptvMfgProdCostCtrlgOrder

DDL: I_RPTVMFGPRODCOSTCTRLGORDER Type: view_entity COMPOSITE
31 Fields 1 Data Sources 4 Associations

Product Cost Controlling Order in Repetitive Manufacturing

I_RptvMfgProdCostCtrlgOrder is a Composite CDS View (Fact) that provides data about "Product Cost Controlling Order in Repetitive Manufacturing" in SAP S/4HANA. It reads from 1 data source (I_ProductCostCtrlgOrder) and exposes 31 fields with key field OrderID. It has 4 associations to related views.

SAP Help Documentation

CategoryCDS Views for Repetitive Manufacturing
Data CategoryFact
Purpose
This CDS view retrieves data for cost controlling orders in repetitive manufacturing. This CDS view provides the data to answer the following business questions: Which product cost controlling orders exist in repetitive manufacturing? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have a role with the following restriction types set to read access: WERKS (Plant) You can use the Display Restriction Types app to find out in which business catalogs these restriction types are included.

Structure
Important Fields Important fields in this view include the following: Field Name Description OrderID Order Number OrderDescription Order Description OrderType Order Type CreatedByUser Created By CreationDate Created On BaseUnit Base Unit of Measure Plant Plant ProductionProcess Production Process ControllingArea Controlling Area CompanyCode Company Code BusinessArea Business Area

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
I_ProductCostCtrlgOrder pcc from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_UnitOfMeasure _BaseUnit $projection.BaseUnit = _BaseUnit.UnitOfMeasure
[0..1] I_Currency _Currency $projection.Currency = _Currency.Currency -- to child
[0..*] I_RptvMfgProdCostCtrlgOrdItem _OrderItem $projection.OrderID = _OrderItem.OrderID -- to extension --
[1..1] E_ProductCostCtrlgOrder _Extension $projection.OrderID = _Extension.OrderID

Annotations (14)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
Analytics.dataCategory #FACT view
Analytics.dataExtraction.enabled true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.compositionRoot true view
ObjectModel.modelingPattern #NONE view
ObjectModel.sapObjectNodeType.name RepetitiveManufacturingPCC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #COMPOSITE view
EndUserText.label Product Cost Controlling Order in Repetitive Manufacturing view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY OrderID I_ProductCostCtrlgOrder OrderID Order ID
OrderDescription
OrderType I_ProductCostCtrlgOrder OrderType Order Type
CreatedByUser I_ProductCostCtrlgOrder CreatedByUser User Name
CreationDate I_ProductCostCtrlgOrder CreationDate Time Stamp
LastChangedByUser I_ProductCostCtrlgOrder LastChangedByUser User Name
LastChangeDate I_ProductCostCtrlgOrder LastChangeDate Time Stamp
IsMarkedForDeletion I_ProductCostCtrlgOrder IsMarkedForDeletion Purch.org. data
IsStatisticalOrder I_ProductCostCtrlgOrder IsStatisticalOrder Statistical Order
ReferenceOrder I_ProductCostCtrlgOrder ReferenceOrder Reference Order
ObjectInternalID I_ProductCostCtrlgOrder ObjectInternalID Object number
Currency I_ProductCostCtrlgOrder Currency Valuation Crcy
BaseUnit I_ProductCostCtrlgOrder BaseUnit Unit of Measure
Plant I_ProductCostCtrlgOrder Plant Valuation Area
ProductionProcess
ControllingArea I_ProductCostCtrlgOrder ControllingArea Controlling Area
CompanyCode I_ProductCostCtrlgOrder CompanyCode Receiver Company Code
BusinessArea I_ProductCostCtrlgOrder BusinessArea Business Area
ProfitCenter I_ProductCostCtrlgOrder ProfitCenter Profit Center
CostCenter I_ProductCostCtrlgOrder CostCenter Cost Center
ResponsibleCostCenter I_ProductCostCtrlgOrder ResponsibleCostCenter Responsible Cost Center
RequestingCostCenter
FunctionalArea I_ProductCostCtrlgOrder FunctionalArea Sendr Fctl Area
ActualCostsCostingVariant I_ProductCostCtrlgOrder ActualCostsCostingVariant Act. Costing Variant
PlannedCostsCostingVariant I_ProductCostCtrlgOrder PlannedCostsCostingVariant Plnd Costing Variant
_OrderItem _OrderItem
_BaseUnit _BaseUnit
_Currency _Currency
_OrderType I_ProductCostCtrlgOrder _OrderType
_ControllingArea I_ProductCostCtrlgOrder _ControllingArea
_CompanyCode I_ProductCostCtrlgOrder _CompanyCode

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 I_RptvMfgProdCostCtrlgOrder.
-- 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 I_RptvMfgProdCostCtrlgOrder AS
SELECT
  pcc.OrderID AS OrderID,
  cast(pcc.OrderDescription as pph_auftext preserving type) AS OrderDescription,
  pcc.OrderType AS OrderType,
  pcc.CreatedByUser AS CreatedByUser,
  pcc.CreationDate AS CreationDate,
  pcc.LastChangedByUser AS LastChangedByUser,
  pcc.LastChangeDate AS LastChangeDate,
  pcc.IsMarkedForDeletion AS IsMarkedForDeletion,
  pcc.IsStatisticalOrder AS IsStatisticalOrder,
  pcc.ReferenceOrder AS ReferenceOrder,
  pcc.ObjectInternalID AS ObjectInternalID,
  pcc.Currency AS Currency,
  pcc.BaseUnit AS BaseUnit,
  pcc.Plant AS Plant,
  cast(pcc.ProductionProcess as fco_production_process preserving type) AS ProductionProcess,
  pcc.ControllingArea AS ControllingArea,
  pcc.CompanyCode AS CompanyCode,
  pcc.BusinessArea AS BusinessArea,
  pcc.ProfitCenter AS ProfitCenter,
  pcc.CostCenter AS CostCenter,
  pcc.ResponsibleCostCenter AS ResponsibleCostCenter,
  cast(pcc.RequestingCostCenter as fco_io_ps_akstl preserving type) AS RequestingCostCenter,
  pcc.FunctionalArea AS FunctionalArea,
  pcc.ActualCostsCostingVariant AS ActualCostsCostingVariant,
  pcc.PlannedCostsCostingVariant AS PlannedCostsCostingVariant,
  pcc._OrderType AS _OrderType,
  pcc._ControllingArea AS _ControllingArea,
  pcc._CompanyCode AS _CompanyCode
FROM I_ProductCostCtrlgOrder AS pcc
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_RptvMfgProdCostCtrlgOrdItem AS _OrderItem ON OrderID = _OrderItem.OrderID  -- association [0..*]
LEFT OUTER JOIN E_ProductCostCtrlgOrder AS _Extension ON OrderID = _Extension.OrderID  -- association [1..1]
;

Learn More