I_MfgOrderOpPRTDataList

DDL: I_MFGORDEROPPRTDATALIST SQL: IPPMOROPPRTDATA Type: view COMPOSITE
18 Fields 1 Data Sources

MfgOrder ProductionResourceTool DataList

I_MfgOrderOpPRTDataList is a Composite CDS View that provides data about "MfgOrder ProductionResourceTool DataList" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderOperationPRT) and exposes 18 fields with key fields OrderInternalBillOfOperations, MfgOrderOpProdnRsceToolIntID.

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderOperationPRT prt from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPPMOROPPRTDATA view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
EndUserText.label MfgOrder ProductionResourceTool DataList view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY OrderInternalBillOfOperations I_MfgOrderOperationPRT MfgOrderInternalID Order Internal Bill of Operations
KEY MfgOrderOpProdnRsceToolIntID I_MfgOrderOperationPRT MfgOrderOpProdnRsceToolIntID
ManufacturingOrder I_MfgOrderOperationPRT ManufacturingOrder Order
ManufacturingOrderSequence I_MfgOrderOperationPRT ManufacturingOrderSequence
ManufacturingOrderOperation I_MfgOrderOperationPRT ManufacturingOrderOperation Activity
OrderIntBillOfOperationsItem I_MfgOrderOperationPRT OrderOperationInternalID Order Internal Bill of Operations Item
ProdnRsceToolItemNumber I_MfgOrderOperationPRT ProdnRsceToolItemNumber Item Number
PlannedTotalProdnRsceToolQty I_MfgOrderOperationPRT PlannedTotalProdnRsceToolQty
PlannedProdnRsceToolQtyUnit I_MfgOrderOperationPRT PlannedProdnRsceToolQtyUnit
LatestSchedldUsageStartDate I_MfgOrderOperationPRT LatestSchedldUsageStartDate
LatestSchedldUsageEndDate I_MfgOrderOperationPRT LatestSchedldUsageEndDate
MfgOrderOpProdnRsceToolText I_MfgOrderOperationPRT MfgOrderOpProdnRsceToolText
LongTextLanguageCode I_MfgOrderOperationPRT Language Report Text Language
ProductionResourceType I_MfgOrderOperationPRT ProductionResourceType Object Type
ProductionResourceInternalID I_MfgOrderOperationPRT ProductionResourceInternalID Object ID
ProductionResourceTool I_MfgOrderOperationPRT ProductionResourceTool PRT
Plant
_PlannedProdnRsceToolQtyUnit _PlannedProdnRsceToolQtyUnit

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_MfgOrderOpPRTDataList.
-- 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: IPPMOROPPRTDATA

CREATE VIEW I_MfgOrderOpPRTDataList AS
SELECT
  prt.MfgOrderInternalID AS OrderInternalBillOfOperations,
  prt.MfgOrderOpProdnRsceToolIntID AS MfgOrderOpProdnRsceToolIntID,
  prt.ManufacturingOrder AS ManufacturingOrder,
  prt.ManufacturingOrderSequence AS ManufacturingOrderSequence,
  prt.ManufacturingOrderOperation AS ManufacturingOrderOperation,
  prt.OrderOperationInternalID AS OrderIntBillOfOperationsItem,
  prt.ProdnRsceToolItemNumber AS ProdnRsceToolItemNumber,
  prt.PlannedTotalProdnRsceToolQty AS PlannedTotalProdnRsceToolQty,
  prt.PlannedProdnRsceToolQtyUnit AS PlannedProdnRsceToolQtyUnit,
  prt.LatestSchedldUsageStartDate AS LatestSchedldUsageStartDate,
  prt.LatestSchedldUsageEndDate AS LatestSchedldUsageEndDate,
  prt.MfgOrderOpProdnRsceToolText AS MfgOrderOpProdnRsceToolText,
  prt.Language AS LongTextLanguageCode,
  prt.ProductionResourceType AS ProductionResourceType,
  prt.ProductionResourceInternalID AS ProductionResourceInternalID,
  prt.ProductionResourceTool AS ProductionResourceTool,
  prt._ProdnRsceToolByInternalKey.Plant AS Plant
FROM I_MfgOrderOperationPRT AS prt
;

Learn More