C_ProdnModOAInstcAggrgd

DDL: C_PRODNMODOAINSTCAGGRGD Type: view_entity CONSUMPTION
11 Fields 1 Data Sources

Prodn Model OA Instance Aggrgd

C_ProdnModOAInstcAggrgd is a Consumption CDS View that provides data about "Prodn Model OA Instance Aggrgd" in SAP S/4HANA. It reads from 1 data source (I_ProdnModOAInstcAggrgd) and exposes 11 fields with key fields ProductionModelUUID, BillOfOperationsVersion, BOOOperationInternalID, OperationActivity, OperationActyVersionCounter.

Data Sources (1)

SourceAliasJoin Type
I_ProdnModOAInstcAggrgd ProdnModOAInstceAggrgd from

Annotations (7)

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

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ProductionModelUUID I_ProdnModOAInstcAggrgd ProductionModelUUID Prodn Model UUID
KEY BillOfOperationsVersion I_ProdnModOAInstcAggrgd BillOfOperationsVersion Routing Version
KEY BOOOperationInternalID I_ProdnModOAInstcAggrgd BOOOperationInternalID Task list node
KEY OperationActivity I_ProdnModOAInstcAggrgd OperationActivity Operation Activity
KEY OperationActyVersionCounter I_ProdnModOAInstcAggrgd OperationActyVersionCounter OA Version
KEY IsActiveEntity I_ProdnModOAInstcAggrgd IsActiveEntity Is active
BillOfMaterialCategory I_ProdnModOAInstcAggrgd BillOfMaterialCategory BOM category
BillOfMaterialVariantUsage I_ProdnModOAInstcAggrgd BillOfMaterialVariantUsage Usage
BillOfOperationsType I_ProdnModOAInstcAggrgd BillOfOperationsType Task List Type
Plant I_ProdnModOAInstcAggrgd Plant Valuation Area
ProdnModAggrgdCompInstceString I_ProdnModOAInstcAggrgd 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_ProdnModOAInstcAggrgd.
-- 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_ProdnModOAInstcAggrgd AS
SELECT
  ProdnModOAInstceAggrgd.ProductionModelUUID AS ProductionModelUUID,
  ProdnModOAInstceAggrgd.BillOfOperationsVersion AS BillOfOperationsVersion,
  ProdnModOAInstceAggrgd.BOOOperationInternalID AS BOOOperationInternalID,
  ProdnModOAInstceAggrgd.OperationActivity AS OperationActivity,
  ProdnModOAInstceAggrgd.OperationActyVersionCounter AS OperationActyVersionCounter,
  ProdnModOAInstceAggrgd.IsActiveEntity AS IsActiveEntity,
  ProdnModOAInstceAggrgd.BillOfMaterialCategory AS BillOfMaterialCategory,
  ProdnModOAInstceAggrgd.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  ProdnModOAInstceAggrgd.BillOfOperationsType AS BillOfOperationsType,
  ProdnModOAInstceAggrgd.Plant AS Plant,
  ProdnModOAInstceAggrgd.ProdnModAggrgdCompInstceString AS ProdnModAggrgdCompInstceString
FROM I_ProdnModOAInstcAggrgd AS ProdnModOAInstceAggrgd
;

Learn More