C_SFOOpActyNonTrcblUsedPRT

DDL: C_SFOOPACTYNONTRCBLUSEDPRT Type: view_entity CONSUMPTION
24 Fields 3 Data Sources

Shop floor order used non traceable PRT

C_SFOOpActyNonTrcblUsedPRT is a Consumption CDS View that provides data about "Shop floor order used non traceable PRT" in SAP S/4HANA. It reads from 3 data sources (I_OpActyInstceNtwkElmntBasic, I_OrderOperationBasic, I_SFOOpActyNonTrcblUsedPRT) and exposes 24 fields with key fields OpActyNtwkInstance, OpActyNtwkElement, OrderInternalID, MfgOrderOpProdnRsceToolIntID.

Data Sources (3)

SourceAliasJoin Type
I_OpActyInstceNtwkElmntBasic OpActyInstceNtwkElmntBasic inner
I_OrderOperationBasic OrderOperationBasic inner
I_SFOOpActyNonTrcblUsedPRT SFOOpActyNonTrcblUsedPRT from

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Shop floor order used non traceable PRT view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
UI.headerInfo.typeName Non-Traceable PRT view
UI.headerInfo.typeNamePlural Non-Traceable PRTs view
UI.headerInfo.title.label Non-Traceable PRT view
UI.textArrangement #TEXT_LAST view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY OpActyNtwkInstance I_SFOOpActyNonTrcblUsedPRT OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement I_SFOOpActyNonTrcblUsedPRT OpActyNtwkElement Element Number
KEY OrderInternalID I_SFOOpActyNonTrcblUsedPRT OrderInternalID Plan No.f.Oper.
KEY MfgOrderOpProdnRsceToolIntID I_SFOOpActyNonTrcblUsedPRT MfgOrderOpProdnRsceToolIntID
ProductionResourceTool
ProdnRsceToolCategoryName
ProdnRsceToolCategoryExtCode
PlannedProdnRsceToolQtyUnit I_SFOOpActyNonTrcblUsedPRT PlannedProdnRsceToolQtyUnit
PlannedTotalProdnRsceToolQty I_SFOOpActyNonTrcblUsedPRT PlannedTotalProdnRsceToolQty
ProdnRsceToolCategory
Material I_SFOOpActyNonTrcblUsedPRT Material Vehicle Model
Equipment I_SFOOpActyNonTrcblUsedPRT Equipment Equipment check
MiscProductionResourceTool I_SFOOpActyNonTrcblUsedPRT MiscProductionResourceTool
MfgOrderOpPRTItemNumber
PRTIsUsedAsTestEquipment I_SFOOpActyNonTrcblUsedPRT PRTIsUsedAsTestEquipment Test Equipment
Plant I_SFOOpActyNonTrcblUsedPRT Plant Valuation Area
MfgOrderOperationText I_OrderOperationBasic OperationText Description
OperationActivityName
OpActyNtwkElementElement I_OpActyInstceNtwkElmntBasic OpActyNtwkElementElement Operation Activity
OpActyNtwkElementElmntVersCntr I_OpActyInstceNtwkElmntBasic OpActyNtwkElementElmntVersCntr OA Version
_OpActyNtwkInstance I_SFOOpActyNonTrcblUsedPRT _OpActyNtwkInstance
_OperationActivityInstance I_SFOOpActyNonTrcblUsedPRT _OperationActivityInstance
_OrdInternalBillOfOperations I_SFOOpActyNonTrcblUsedPRT _OrdInternalBillOfOperations
_ProdnRsceToolCategory I_SFOOpActyNonTrcblUsedPRT _ProdnRsceToolCategory

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 C_SFOOpActyNonTrcblUsedPRT.
-- 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 C_SFOOpActyNonTrcblUsedPRT AS
SELECT
  SFOOpActyNonTrcblUsedPRT.OpActyNtwkInstance AS OpActyNtwkInstance,
  SFOOpActyNonTrcblUsedPRT.OpActyNtwkElement AS OpActyNtwkElement,
  SFOOpActyNonTrcblUsedPRT.OrderInternalID AS OrderInternalID,
  SFOOpActyNonTrcblUsedPRT.MfgOrderOpProdnRsceToolIntID AS MfgOrderOpProdnRsceToolIntID,
  cast( '' as pph_fhmnr ) AS ProductionResourceTool,
  SFOOpActyNonTrcblUsedPRT._ProdnRsceToolCategory._Text[1: Language=$session.system_language].ProdnRsceToolCategoryName AS ProdnRsceToolCategoryName,
  cast(SFOOpActyNonTrcblUsedPRT._ProdnRsceToolCategory._Text[1: Language=$session.system_language].ProdnRsceToolCategoryExtCode as mpe_fhmar preserving type) AS ProdnRsceToolCategoryExtCode,
  SFOOpActyNonTrcblUsedPRT.PlannedProdnRsceToolQtyUnit AS PlannedProdnRsceToolQtyUnit,
  SFOOpActyNonTrcblUsedPRT.PlannedTotalProdnRsceToolQty AS PlannedTotalProdnRsceToolQty,
  cast(SFOOpActyNonTrcblUsedPRT.ProdnRsceToolCategory as mpe_fhmar preserving type) AS ProdnRsceToolCategory,
  SFOOpActyNonTrcblUsedPRT.Material AS Material,
  SFOOpActyNonTrcblUsedPRT.Equipment AS Equipment,
  SFOOpActyNonTrcblUsedPRT.MiscProductionResourceTool AS MiscProductionResourceTool,
  cast(SFOOpActyNonTrcblUsedPRT.ProdnRsceToolItemNumber as mpe_psnfh_char) AS MfgOrderOpPRTItemNumber,
  SFOOpActyNonTrcblUsedPRT.PRTIsUsedAsTestEquipment AS PRTIsUsedAsTestEquipment,
  SFOOpActyNonTrcblUsedPRT.Plant AS Plant,
  OrderOperationBasic.OperationText AS MfgOrderOperationText,
  OpActyInstceNtwkElmntBasic._OperationActivityText[1: Language=$session.system_language].OperationActivityName AS OperationActivityName,
  OpActyInstceNtwkElmntBasic.OpActyNtwkElementElement AS OpActyNtwkElementElement,
  OpActyInstceNtwkElmntBasic.OpActyNtwkElementElmntVersCntr AS OpActyNtwkElementElmntVersCntr,
  SFOOpActyNonTrcblUsedPRT._OpActyNtwkInstance AS _OpActyNtwkInstance,
  SFOOpActyNonTrcblUsedPRT._OperationActivityInstance AS _OperationActivityInstance,
  SFOOpActyNonTrcblUsedPRT._OrdInternalBillOfOperations AS _OrdInternalBillOfOperations,
  SFOOpActyNonTrcblUsedPRT._ProdnRsceToolCategory AS _ProdnRsceToolCategory
FROM I_SFOOpActyNonTrcblUsedPRT AS SFOOpActyNonTrcblUsedPRT
INNER JOIN I_OpActyInstceNtwkElmntBasic AS OpActyInstceNtwkElmntBasic ON /* join condition not captured in parsed metadata */
INNER JOIN I_OrderOperationBasic AS OrderOperationBasic ON /* join condition not captured in parsed metadata */
;

Learn More