C_ChgImpactProdnOrdDets

DDL: C_CHGIMPACTPRODNORDDETS SQL: CCHGIMPCTPRODN Type: view CONSUMPTION Package: MPE_PLAN_CIMA
6 Fields 1 Data Sources

Mfg BOM linked with Production orders

C_ChgImpactProdnOrdDets is a Consumption CDS View that provides data about "Mfg BOM linked with Production orders" in SAP S/4HANA. It reads from 1 data source (I_MfgOrder) and exposes 6 fields with key field ManufacturingOrder. Part of development package MPE_PLAN_CIMA.

Data Sources (1)

SourceAliasJoin Type
I_MfgOrder MfgOrder from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CCHGIMPCTPRODN view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Mfg BOM linked with Production orders view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
UI.headerInfo.title.value ManufacturingOrder view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ManufacturingOrder ManufacturingOrder Order
ValidityStartDate I_MfgOrder MfgOrderScheduledStartDate
ValidityEndDate I_MfgOrder MfgOrderScheduledEndDate
ProductionPlant I_MfgOrder ProductionPlant Prod plnt
ManufacturingOrderType ManufacturingOrderType
ManufacturingOrderCategory ManufacturingOrderCategory

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 C_ChgImpactProdnOrdDets.
-- 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: CCHGIMPCTPRODN

CREATE VIEW C_ChgImpactProdnOrdDets AS
SELECT
  ManufacturingOrder,
  MfgOrder.MfgOrderScheduledStartDate AS ValidityStartDate,
  MfgOrder.MfgOrderScheduledEndDate AS ValidityEndDate,
  MfgOrder.ProductionPlant AS ProductionPlant,
  ManufacturingOrderType,
  ManufacturingOrderCategory
FROM I_MfgOrder AS MfgOrder
;

Learn More