A_ProductionRsceTools

DDL: A_PRODUCTIONRSCETOOLS Type: view_entity COMPOSITE

API Production Resource/Tools

A_ProductionRsceTools is a Composite CDS View that provides data about "API Production Resource/Tools" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderOperationPRT) and exposes 22 fields with key fields OrderInternalBillOfOperations, MfgOrderOpProdnRsceToolIntID.

1 data source(s) 22 fields

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderOperationPRT I_MfgOrderOperationPRT from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label API Production Resource/Tools view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY OrderInternalBillOfOperations MfgOrderInternalID Operation Task List No.
KEY MfgOrderOpProdnRsceToolIntID MfgOrderOpProdnRsceToolIntID PRT Item Counter
ManufacturingOrder ManufacturingOrder
ProdnRsceToolCategory ProdnRsceToolCategory
ProdnRsceToolCategoryName
PlannedProdnRsceToolQtyUnit PlannedProdnRsceToolQtyUnit
PlannedTotalProdnRsceToolQty PlannedTotalProdnRsceToolQty
ConfirmedProdnRsceToolQtyUnit ConfirmedProdnRsceToolQtyUnit
ConfirmedProdnRsceToolQty ConfirmedProdnRsceToolQty
ProdnRsceToolUsageQuantityUnit ProdnRsceToolUsageQuantityUnit
ProdnRsceToolUsageQuantity ProdnRsceToolUsageQuantity
EarliestSchedldUsageStartDate EarliestSchedldUsageStartDate
EarliestSchedldUsageStartTime EarliestSchedldUsageStartTime
EarliestSchedldUsageEndDate EarliestSchedldUsageEndDate
EarliestSchedldUsageEndTime EarliestSchedldUsageEndTime
LatestSchedldUsageStartDate LatestSchedldUsageStartDate
LatestSchedldUsageStartTime LatestSchedldUsageStartTime
LatestSchedldUsageEndDate LatestSchedldUsageEndDate
LatestSchedldUsageEndTime LatestSchedldUsageEndTime
ManufacturingOrderType ManufacturingOrderType
ManufacturingOrderCategory ManufacturingOrderCategory
ProductionPlant ProductionPlant 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'API Production Resource/Tools'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #MIXED}
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API

define view entity A_ProductionRsceTools
as select from I_MfgOrderOperationPRT
{
       @EndUserText.label: 'Operation Task List No.'
  key  MfgOrderInternalID as OrderInternalBillOfOperations,
       @EndUserText.label: 'PRT Item Counter'
  key  MfgOrderOpProdnRsceToolIntID,
       ManufacturingOrder,
       ProdnRsceToolCategory,
       _ProdnRsceToolCategory._Text[1: Language=$session.system_language].ProdnRsceToolCategoryName,
       PlannedProdnRsceToolQtyUnit,
       @Semantics.quantity.unitOfMeasure: 'PlannedProdnRsceToolQtyUnit'
       PlannedTotalProdnRsceToolQty,
       ConfirmedProdnRsceToolQtyUnit,
       @Semantics.quantity.unitOfMeasure: 'ConfirmedProdnRsceToolQtyUnit'
       ConfirmedProdnRsceToolQty,
       ProdnRsceToolUsageQuantityUnit,
       @Semantics.quantity.unitOfMeasure: 'ProdnRsceToolUsageQuantityUnit'
       ProdnRsceToolUsageQuantity,

       EarliestSchedldUsageStartDate,
       EarliestSchedldUsageStartTime,

       EarliestSchedldUsageEndDate,
       EarliestSchedldUsageEndTime,

       LatestSchedldUsageStartDate,
       LatestSchedldUsageStartTime,

       LatestSchedldUsageEndDate,
       LatestSchedldUsageEndTime,
       
       ManufacturingOrderType,
       ManufacturingOrderCategory,
       ProductionPlant
}
where
  IsDeleted != 'X';       
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MFGORDEROPERATIONPRT",
"I_PRODNRSCETOOLCATEGORY",
"I_PRODNRSCETOOLCATEGORYTEXT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More