C_ProdnModInstcAggrgd

DDL: C_PRODNMODINSTCAGGRGD Type: view_entity CONSUMPTION
8 Fields 1 Data Sources 2 OData Services

Prodn Model Instance Aggregated

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

Data Sources (1)

SourceAliasJoin Type
I_ProdnModInstcAggrgd ProdnModInstceAggrgd from

Annotations (6)

NameValueLevelField
EndUserText.label Prodn Model Instance Aggregated 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 (8)

KeyFieldSource TableSource FieldDescription
KEY ProductionModelUUID I_ProdnModInstcAggrgd ProductionModelUUID Prodn Model UUID
KEY BillOfOperationsVersion I_ProdnModInstcAggrgd BillOfOperationsVersion Routing Version
KEY IsActiveEntity I_ProdnModInstcAggrgd IsActiveEntity Is active
BillOfMaterialCategory I_ProdnModInstcAggrgd BillOfMaterialCategory BOM category
BillOfMaterialVariantUsage I_ProdnModInstcAggrgd BillOfMaterialVariantUsage Usage
BillOfOperationsType I_ProdnModInstcAggrgd BillOfOperationsType Task List Type
Plant I_ProdnModInstcAggrgd Plant Valuation Area
ProdnModAggrgdCompInstceString I_ProdnModInstcAggrgd 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_ProdnModInstcAggrgd.
-- 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_ProdnModInstcAggrgd AS
SELECT
  ProdnModInstceAggrgd.ProductionModelUUID AS ProductionModelUUID,
  ProdnModInstceAggrgd.BillOfOperationsVersion AS BillOfOperationsVersion,
  ProdnModInstceAggrgd.IsActiveEntity AS IsActiveEntity,
  ProdnModInstceAggrgd.BillOfMaterialCategory AS BillOfMaterialCategory,
  ProdnModInstceAggrgd.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  ProdnModInstceAggrgd.BillOfOperationsType AS BillOfOperationsType,
  ProdnModInstceAggrgd.Plant AS Plant,
  ProdnModInstceAggrgd.ProdnModAggrgdCompInstceString AS ProdnModAggrgdCompInstceString
FROM I_ProdnModInstcAggrgd AS ProdnModInstceAggrgd
;

Learn More