A_EquipProductionResourceTool

DDL: A_EQUIPPRODUCTIONRESOURCETOOL Type: view_entity COMPOSITE Package: IEQM

Equipment Production Resource Tool

A_EquipProductionResourceTool is a Composite CDS View that provides data about "Equipment Production Resource Tool" in SAP S/4HANA. It reads from 2 data sources (I_EquipmentTimeSeg, I_EquipmentProdnRsceTool) and exposes 32 fields with key fields Equipment, ValidityEndDate. It is exposed through 1 OData service (API_EQUIPMENT). Part of development package IEQM.

2 data source(s) Exposed by 1 service(s) 32 fields

Data Sources (2)

SourceAliasJoin Type
I_EquipmentTimeSeg EquipmentTimeSeg inner
I_EquipmentProdnRsceTool ProductionResourceTool from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Equipment Production Resource Tool view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name EquipProductionResourceTool_Type 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

OData Services (1)

ServiceBindingVersionContractRelease
API_EQUIPMENT API_EQUIPMENT V2 C2 C1

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY Equipment I_EquipmentProdnRsceTool Equipment
KEY ValidityEndDate I_EquipmentTimeSeg ValidityEndDate
ProductionResourceType I_EquipmentProdnRsceTool ProductionResourceType
ProductionResourceInternalID I_EquipmentProdnRsceTool ProductionResourceInternalID
ProductionResourceToolGroup1 I_EquipmentProdnRsceTool ProductionResourceToolGroup1
ProductionResourceToolGroup2 I_EquipmentProdnRsceTool ProductionResourceToolGroup2
ProductionResourceUsage I_EquipmentProdnRsceTool ProductionResourceUsage
ProdnRsceToolControlProfile I_EquipmentProdnRsceTool ProdnRsceToolControlProfile
ChangeNumber I_EquipmentProdnRsceTool ChangeNumber
ProdnRsceToolStandardTextCode I_EquipmentProdnRsceTool ProdnRsceToolStandardTextCode
ProdnRsceToolTotQtyCalcFormula I_EquipmentProdnRsceTool ProdnRsceToolTotQtyCalcFormula
ProdnRsceToolUsageQtyCalcFmla I_EquipmentProdnRsceTool ProdnRsceToolUsageQtyCalcFmla
StartDateOffsetReferenceCode I_EquipmentProdnRsceTool StartDateOffsetReferenceCode
EndDateOffsetReferenceCode I_EquipmentProdnRsceTool EndDateOffsetReferenceCode
EndDateOffsetDurnIsReferenced I_EquipmentProdnRsceTool EndDateOffsetDurnIsReferenced
StartDateOffstDurnIsReferenced I_EquipmentProdnRsceTool StartDateOffstDurnIsReferenced
EndDteOffstRefCodeIsReferenced I_EquipmentProdnRsceTool EndDteOffstRefCodeIsReferenced
StartDateOffsetRefCodeIsRefcd I_EquipmentProdnRsceTool StartDateOffsetRefCodeIsRefcd
PRTTotQtyCalcFmlaIsReferenced I_EquipmentProdnRsceTool PRTTotQtyCalcFmlaIsReferenced
PRTUsgeQtyCalcFmlaIsReferenced I_EquipmentProdnRsceTool PRTUsgeQtyCalcFmlaIsReferenced
PRTControlProfileIsReferenced I_EquipmentProdnRsceTool PRTControlProfileIsReferenced
PRTStdTextCodeIsReferenced I_EquipmentProdnRsceTool PRTStdTextCodeIsReferenced
ProdPRTLoadRecordsAreCreated I_EquipmentProdnRsceTool ProdPRTLoadRecordsAreCreated
StartDateOffsetDuration I_EquipmentProdnRsceTool StartDateOffsetDuration
StartDateOffsetDurationUnit I_EquipmentProdnRsceTool StartDateOffsetDurationUnit
EndDateOffsetDuration I_EquipmentProdnRsceTool EndDateOffsetDuration
EndDateOffsetDurationUnit I_EquipmentProdnRsceTool EndDateOffsetDurationUnit
CreationDate I_EquipmentProdnRsceTool CreationDate
CreatedByUser I_EquipmentProdnRsceTool CreatedByUser
LastChangeDate I_EquipmentProdnRsceTool LastChangeDate
LastChangedByUser I_EquipmentProdnRsceTool LastChangedByUser
_Equipment _Equipment 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Equipment Production Resource Tool'
@Metadata.ignorePropagatedAnnotations: true
@OData.entityType.name: 'EquipProductionResourceTool_Type'
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #MIXED
}
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@VDM.usage.type: [#TRANSACTIONAL_PROCESSING_SERVICE]

define view entity A_EquipProductionResourceTool  
  as select from I_EquipmentProdnRsceTool as ProductionResourceTool
  inner join I_EquipmentTimeSeg as EquipmentTimeSeg on EquipmentTimeSeg.Equipment = ProductionResourceTool.Equipment
  

  
   association to parent A_Equipment as _Equipment on $projection.Equipment = _Equipment.Equipment  
                                                  and $projection.ValidityEndDate = _Equipment.ValidityEndDate
  
{
  key ProductionResourceTool.Equipment,
  key EquipmentTimeSeg.ValidityEndDate,
      ProductionResourceTool.ProductionResourceType,
      ProductionResourceTool.ProductionResourceInternalID,
      ProductionResourceTool.ProductionResourceToolGroup1,
      ProductionResourceTool.ProductionResourceToolGroup2,
      ProductionResourceTool.ProductionResourceUsage,
      ProductionResourceTool.ProdnRsceToolControlProfile,
      ProductionResourceTool.ChangeNumber,
      ProductionResourceTool.ProdnRsceToolStandardTextCode,
      ProductionResourceTool.ProdnRsceToolTotQtyCalcFormula,
      ProductionResourceTool.ProdnRsceToolUsageQtyCalcFmla,
      ProductionResourceTool.StartDateOffsetReferenceCode,
      ProductionResourceTool.EndDateOffsetReferenceCode,
      ProductionResourceTool.EndDateOffsetDurnIsReferenced,
      ProductionResourceTool.StartDateOffstDurnIsReferenced,
      ProductionResourceTool.EndDteOffstRefCodeIsReferenced,
      ProductionResourceTool.StartDateOffsetRefCodeIsRefcd,
      ProductionResourceTool.PRTTotQtyCalcFmlaIsReferenced,
      ProductionResourceTool.PRTUsgeQtyCalcFmlaIsReferenced,
      ProductionResourceTool.PRTControlProfileIsReferenced,
      ProductionResourceTool.PRTStdTextCodeIsReferenced,
      ProductionResourceTool.ProdPRTLoadRecordsAreCreated,
      
      @Semantics.quantity.unitOfMeasure: 'StartDateOffsetDurationUnit'
      ProductionResourceTool.StartDateOffsetDuration,
      ProductionResourceTool.StartDateOffsetDurationUnit,
      @Semantics.quantity.unitOfMeasure: 'EndDateOffsetDurationUnit'
      ProductionResourceTool.EndDateOffsetDuration,
      ProductionResourceTool.EndDateOffsetDurationUnit,
      ProductionResourceTool.CreationDate,
      ProductionResourceTool.CreatedByUser,
      ProductionResourceTool.LastChangeDate,
      ProductionResourceTool.LastChangedByUser,
    
      /* Associations */
      _Equipment
}

Learn More