I_MfgOrderOpPRTDataList

DDL: I_MFGORDEROPPRTDATALIST SQL: IPPMOROPPRTDATA Type: view COMPOSITE Package: PP_MAN_OM_MOR

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. Part of development package PP_MAN_OM_MOR.

1 data source(s) 18 fields

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
KEY MfgOrderOpProdnRsceToolIntID I_MfgOrderOperationPRT MfgOrderOpProdnRsceToolIntID
ManufacturingOrder I_MfgOrderOperationPRT ManufacturingOrder
ManufacturingOrderSequence I_MfgOrderOperationPRT ManufacturingOrderSequence
ManufacturingOrderOperation I_MfgOrderOperationPRT ManufacturingOrderOperation
OrderIntBillOfOperationsItem I_MfgOrderOperationPRT OrderOperationInternalID
ProdnRsceToolItemNumber I_MfgOrderOperationPRT ProdnRsceToolItemNumber
PlannedTotalProdnRsceToolQty I_MfgOrderOperationPRT PlannedTotalProdnRsceToolQty
PlannedProdnRsceToolQtyUnit I_MfgOrderOperationPRT PlannedProdnRsceToolQtyUnit
LatestSchedldUsageStartDate I_MfgOrderOperationPRT LatestSchedldUsageStartDate
LatestSchedldUsageEndDate I_MfgOrderOperationPRT LatestSchedldUsageEndDate
MfgOrderOpProdnRsceToolText I_MfgOrderOperationPRT MfgOrderOpProdnRsceToolText
LongTextLanguageCode I_MfgOrderOperationPRT Language
ProductionResourceType I_MfgOrderOperationPRT ProductionResourceType
ProductionResourceInternalID I_MfgOrderOperationPRT ProductionResourceInternalID
ProductionResourceTool I_MfgOrderOperationPRT ProductionResourceTool
Plant
_PlannedProdnRsceToolQtyUnit _PlannedProdnRsceToolQtyUnit 
@AbapCatalog.sqlViewName: 'IPPMOROPPRTDATA'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'MfgOrder ProductionResourceTool DataList'
define view I_MfgOrderOpPRTDataList
  as select from I_MfgOrderOperationPRT as prt
{
      // Key

  key prt.MfgOrderInternalID                as OrderInternalBillOfOperations,
  key prt.MfgOrderOpProdnRsceToolIntID      as MfgOrderOpProdnRsceToolIntID,

      @ObjectModel.foreignKey.association: null
      prt.ManufacturingOrder                as ManufacturingOrder,
      @ObjectModel.foreignKey.association: null
      prt.ManufacturingOrderSequence        as ManufacturingOrderSequence,
      prt.ManufacturingOrderOperation       as ManufacturingOrderOperation,
      prt.OrderOperationInternalID          as OrderIntBillOfOperationsItem,

      // Position

      prt.ProdnRsceToolItemNumber           as ProdnRsceToolItemNumber,

      // Quantity

      @Semantics.quantity.unitOfMeasure: 'PlannedProdnRsceToolQtyUnit'
      prt.PlannedTotalProdnRsceToolQty      as PlannedTotalProdnRsceToolQty,
      @Semantics.unitOfMeasure: true
      prt.PlannedProdnRsceToolQtyUnit       as PlannedProdnRsceToolQtyUnit,

      // Dates

      prt.LatestSchedldUsageStartDate       as LatestSchedldUsageStartDate,
      prt.LatestSchedldUsageEndDate         as LatestSchedldUsageEndDate,

      prt.MfgOrderOpProdnRsceToolText       as MfgOrderOpProdnRsceToolText,
      prt.Language                          as LongTextLanguageCode,

      // Master data

      prt.ProductionResourceType            as ProductionResourceType,
      prt.ProductionResourceInternalID      as ProductionResourceInternalID,
      prt.ProductionResourceTool            as ProductionResourceTool,
      prt._ProdnRsceToolByInternalKey.Plant as Plant,

      _PlannedProdnRsceToolQtyUnit
}

where
      prt.IsDeleted                                           = ' '
  and _ProdnRsceToolControlProfile.ProdnRsceToolPrintIsActive = 'X'

Learn More