C_ProdnModOpInstcAggrgd

DDL: C_PRODNMODOPINSTCAGGRGD Type: view_entity CONSUMPTION

Prodn Model Operation Instance Aggrgd

C_ProdnModOpInstcAggrgd is a Consumption CDS View that provides data about "Prodn Model Operation Instance Aggrgd" in SAP S/4HANA. It reads from 1 data source (I_ProdnModOpInstcAggrgd) and exposes 9 fields with key fields ProductionModelUUID, BillOfOperationsVersion, BOOOperationInternalID, IsActiveEntity. It is exposed through 2 OData services (UI_MATL_PRODNMODEL_MANAGE, UI_SLSORD_PRODNMODEL_MANAGE).

Data Sources (1)

SourceAliasJoin Type
I_ProdnModOpInstcAggrgd ProdnModOpInstceAggrgd from

Annotations (6)

NameValueLevelField
EndUserText.label Prodn Model Operation Instance Aggrgd view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

OData Services (2)

ServiceBindingVersionContractRelease
UI_MATL_PRODNMODEL_MANAGE UI_MATL_PRODNMODEL_MANAGE V4 C1 NOT_RELEASED
UI_SLSORD_PRODNMODEL_MANAGE UI_SLSORD_PRODNMODEL_MANAGE V4 C1 NOT_RELEASED

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ProductionModelUUID I_ProdnModOpInstcAggrgd ProductionModelUUID Prodn Model UUID
KEY BillOfOperationsVersion I_ProdnModOpInstcAggrgd BillOfOperationsVersion Routing Version
KEY BOOOperationInternalID I_ProdnModOpInstcAggrgd BOOOperationInternalID Task list node
KEY IsActiveEntity I_ProdnModOpInstcAggrgd IsActiveEntity Is active
BillOfMaterialCategory I_ProdnModOpInstcAggrgd BillOfMaterialCategory BOM category
BillOfMaterialVariantUsage I_ProdnModOpInstcAggrgd BillOfMaterialVariantUsage Usage
BillOfOperationsType I_ProdnModOpInstcAggrgd BillOfOperationsType Task List Type
Plant I_ProdnModOpInstcAggrgd Plant Valuation Area
ProdnModAggrgdCompInstceString I_ProdnModOpInstcAggrgd ProdnModAggrgdCompInstceString

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_ProdnModOpInstcAggrgd.
-- 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 C_ProdnModOpInstcAggrgd AS
SELECT
  ProdnModOpInstceAggrgd.ProductionModelUUID AS ProductionModelUUID,
  ProdnModOpInstceAggrgd.BillOfOperationsVersion AS BillOfOperationsVersion,
  ProdnModOpInstceAggrgd.BOOOperationInternalID AS BOOOperationInternalID,
  ProdnModOpInstceAggrgd.IsActiveEntity AS IsActiveEntity,
  ProdnModOpInstceAggrgd.BillOfMaterialCategory AS BillOfMaterialCategory,
  ProdnModOpInstceAggrgd.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  ProdnModOpInstceAggrgd.BillOfOperationsType AS BillOfOperationsType,
  ProdnModOpInstceAggrgd.Plant AS Plant,
  ProdnModOpInstceAggrgd.ProdnModAggrgdCompInstceString AS ProdnModAggrgdCompInstceString
FROM I_ProdnModOpInstcAggrgd AS ProdnModOpInstceAggrgd
;