A_EquipProductionResourceTool

DDL: A_EQUIPPRODUCTIONRESOURCETOOL Type: view_entity COMPOSITE
32 Fields 2 Data Sources

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.

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

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY Equipment I_EquipmentProdnRsceTool Equipment Equipment check
KEY ValidityEndDate I_EquipmentTimeSeg ValidityEndDate ValidTo
ProductionResourceType I_EquipmentProdnRsceTool ProductionResourceType Object Type
ProductionResourceInternalID I_EquipmentProdnRsceTool ProductionResourceInternalID Object ID
ProductionResourceToolGroup1 I_EquipmentProdnRsceTool ProductionResourceToolGroup1
ProductionResourceToolGroup2 I_EquipmentProdnRsceTool ProductionResourceToolGroup2
ProductionResourceUsage I_EquipmentProdnRsceTool ProductionResourceUsage
ProdnRsceToolControlProfile I_EquipmentProdnRsceTool ProdnRsceToolControlProfile
ChangeNumber I_EquipmentProdnRsceTool ChangeNumber Change Number
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 Time Stamp
CreatedByUser I_EquipmentProdnRsceTool CreatedByUser User Name
LastChangeDate I_EquipmentProdnRsceTool LastChangeDate Time Stamp
LastChangedByUser I_EquipmentProdnRsceTool LastChangedByUser User Name
_Equipment _Equipment

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 A_EquipProductionResourceTool.
-- 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 A_EquipProductionResourceTool AS
SELECT
  ProductionResourceTool.Equipment AS Equipment,
  EquipmentTimeSeg.ValidityEndDate AS ValidityEndDate,
  ProductionResourceTool.ProductionResourceType AS ProductionResourceType,
  ProductionResourceTool.ProductionResourceInternalID AS ProductionResourceInternalID,
  ProductionResourceTool.ProductionResourceToolGroup1 AS ProductionResourceToolGroup1,
  ProductionResourceTool.ProductionResourceToolGroup2 AS ProductionResourceToolGroup2,
  ProductionResourceTool.ProductionResourceUsage AS ProductionResourceUsage,
  ProductionResourceTool.ProdnRsceToolControlProfile AS ProdnRsceToolControlProfile,
  ProductionResourceTool.ChangeNumber AS ChangeNumber,
  ProductionResourceTool.ProdnRsceToolStandardTextCode AS ProdnRsceToolStandardTextCode,
  ProductionResourceTool.ProdnRsceToolTotQtyCalcFormula AS ProdnRsceToolTotQtyCalcFormula,
  ProductionResourceTool.ProdnRsceToolUsageQtyCalcFmla AS ProdnRsceToolUsageQtyCalcFmla,
  ProductionResourceTool.StartDateOffsetReferenceCode AS StartDateOffsetReferenceCode,
  ProductionResourceTool.EndDateOffsetReferenceCode AS EndDateOffsetReferenceCode,
  ProductionResourceTool.EndDateOffsetDurnIsReferenced AS EndDateOffsetDurnIsReferenced,
  ProductionResourceTool.StartDateOffstDurnIsReferenced AS StartDateOffstDurnIsReferenced,
  ProductionResourceTool.EndDteOffstRefCodeIsReferenced AS EndDteOffstRefCodeIsReferenced,
  ProductionResourceTool.StartDateOffsetRefCodeIsRefcd AS StartDateOffsetRefCodeIsRefcd,
  ProductionResourceTool.PRTTotQtyCalcFmlaIsReferenced AS PRTTotQtyCalcFmlaIsReferenced,
  ProductionResourceTool.PRTUsgeQtyCalcFmlaIsReferenced AS PRTUsgeQtyCalcFmlaIsReferenced,
  ProductionResourceTool.PRTControlProfileIsReferenced AS PRTControlProfileIsReferenced,
  ProductionResourceTool.PRTStdTextCodeIsReferenced AS PRTStdTextCodeIsReferenced,
  ProductionResourceTool.ProdPRTLoadRecordsAreCreated AS ProdPRTLoadRecordsAreCreated,
  ProductionResourceTool.StartDateOffsetDuration AS StartDateOffsetDuration,
  ProductionResourceTool.StartDateOffsetDurationUnit AS StartDateOffsetDurationUnit,
  ProductionResourceTool.EndDateOffsetDuration AS EndDateOffsetDuration,
  ProductionResourceTool.EndDateOffsetDurationUnit AS EndDateOffsetDurationUnit,
  ProductionResourceTool.CreationDate AS CreationDate,
  ProductionResourceTool.CreatedByUser AS CreatedByUser,
  ProductionResourceTool.LastChangeDate AS LastChangeDate,
  ProductionResourceTool.LastChangedByUser AS LastChangedByUser
FROM I_EquipmentProdnRsceTool AS ProductionResourceTool
INNER JOIN I_EquipmentTimeSeg AS EquipmentTimeSeg ON /* join condition not captured in parsed metadata */
;

Learn More