A_ProductionRsceTools

DDL: A_PRODUCTIONRSCETOOLS Type: view_entity COMPOSITE Package: ODATA_PP_API_PRODORDER
22 Fields 1 Data Sources

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

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 Order
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 Prod plnt

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_ProductionRsceTools.
-- 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_ProductionRsceTools AS
SELECT
  MfgOrderInternalID AS OrderInternalBillOfOperations,
  MfgOrderOpProdnRsceToolIntID,
  ManufacturingOrder,
  ProdnRsceToolCategory,
  _ProdnRsceToolCategory._Text[1: Language=$session.system_language].ProdnRsceToolCategoryName AS ProdnRsceToolCategoryName,
  PlannedProdnRsceToolQtyUnit,
  PlannedTotalProdnRsceToolQty,
  ConfirmedProdnRsceToolQtyUnit,
  ConfirmedProdnRsceToolQty,
  ProdnRsceToolUsageQuantityUnit,
  ProdnRsceToolUsageQuantity,
  EarliestSchedldUsageStartDate,
  EarliestSchedldUsageStartTime,
  EarliestSchedldUsageEndDate,
  EarliestSchedldUsageEndTime,
  LatestSchedldUsageStartDate,
  LatestSchedldUsageStartTime,
  LatestSchedldUsageEndDate,
  LatestSchedldUsageEndTime,
  ManufacturingOrderType,
  ManufacturingOrderCategory,
  ProductionPlant
FROM I_MfgOrderOperationPRT
;

Learn More