C_SFIOpActyNonTrcblUsedPRT

DDL: C_SFIOPACTYNONTRCBLUSEDPRT Type: view_entity CONSUMPTION
26 Fields 3 Data Sources

SFI used non traceable PRT

C_SFIOpActyNonTrcblUsedPRT is a Consumption CDS View that provides data about "SFI used non traceable PRT" in SAP S/4HANA. It reads from 3 data sources (I_OrderOperationBasic, I_SFIOfOriginalReplacedSFI, I_SFIOpActyNonTrcblUsedPRT) and exposes 26 fields with key fields OpActyNtwkInstance, OpActyNtwkElement, OrderInternalID, MfgOrderOpProdnRsceToolIntID, ShopFloorItem.

Data Sources (3)

SourceAliasJoin Type
I_OrderOperationBasic OrderOperationBasic inner
I_SFIOfOriginalReplacedSFI SFIOfOriginalReplacedSFI from
I_SFIOpActyNonTrcblUsedPRT SFIOpActyNonTrcblUsedPRT inner

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY 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
EndUserText.label SFI used non traceable PRT view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY OpActyNtwkInstance I_SFIOpActyNonTrcblUsedPRT OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement I_SFIOpActyNonTrcblUsedPRT OpActyNtwkElement Element Number
KEY OrderInternalID I_SFIOpActyNonTrcblUsedPRT OrderInternalID Plan No.f.Oper.
KEY MfgOrderOpProdnRsceToolIntID I_SFIOpActyNonTrcblUsedPRT MfgOrderOpProdnRsceToolIntID
KEY ShopFloorItem I_SFIOfOriginalReplacedSFI ShopFloorItem Serial.Mat. ID
OriginalReplacedShopFloorItem I_SFIOfOriginalReplacedSFI OriginalReplacedShopFloorItem
ProductionResourceTool
ProdnRsceToolCategoryName
ProdnRsceToolCategoryExtCode
PlannedProdnRsceToolQtyUnit I_SFIOpActyNonTrcblUsedPRT PlannedProdnRsceToolQtyUnit
PlannedTotalProdnRsceToolQty I_SFIOpActyNonTrcblUsedPRT PlannedTotalProdnRsceToolQty
ProdnRsceToolCategory
Material I_SFIOpActyNonTrcblUsedPRT Material Vehicle Model
Equipment I_SFIOpActyNonTrcblUsedPRT Equipment Equipment check
MiscProductionResourceTool I_SFIOpActyNonTrcblUsedPRT MiscProductionResourceTool
MfgOrderOpPRTItemNumber
PRTIsUsedAsTestEquipment I_SFIOpActyNonTrcblUsedPRT PRTIsUsedAsTestEquipment Test Equipment
Plant I_SFIOpActyNonTrcblUsedPRT Plant Valuation Area
MfgOrderOperationText I_OrderOperationBasic OperationText Description
OperationActivityName
OpActyNtwkElementElement I_SFIOpActyNonTrcblUsedPRT OpActyNtwkElementElement Operation Activity
OpActyNtwkElementElmntVersCntr I_SFIOpActyNonTrcblUsedPRT OpActyNtwkElementElmntVersCntr OA Version
_OpActyNtwkInstance I_SFIOpActyNonTrcblUsedPRT _OpActyNtwkInstance
_OperationActivityInstance I_SFIOpActyNonTrcblUsedPRT _OperationActivityInstance
_OrdInternalBillOfOperations I_SFIOpActyNonTrcblUsedPRT _OrdInternalBillOfOperations
_ProdnRsceToolCategory I_SFIOpActyNonTrcblUsedPRT _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_SFIOpActyNonTrcblUsedPRT.
-- 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_SFIOpActyNonTrcblUsedPRT AS
SELECT
  SFIOpActyNonTrcblUsedPRT.OpActyNtwkInstance AS OpActyNtwkInstance,
  SFIOpActyNonTrcblUsedPRT.OpActyNtwkElement AS OpActyNtwkElement,
  SFIOpActyNonTrcblUsedPRT.OrderInternalID AS OrderInternalID,
  SFIOpActyNonTrcblUsedPRT.MfgOrderOpProdnRsceToolIntID AS MfgOrderOpProdnRsceToolIntID,
  SFIOfOriginalReplacedSFI.ShopFloorItem AS ShopFloorItem,
  SFIOfOriginalReplacedSFI.OriginalReplacedShopFloorItem AS OriginalReplacedShopFloorItem,
  cast( '' as pph_fhmnr ) AS ProductionResourceTool,
  SFIOpActyNonTrcblUsedPRT._ProdnRsceToolCategory._Text[1: Language=$session.system_language].ProdnRsceToolCategoryName AS ProdnRsceToolCategoryName,
  cast(SFIOpActyNonTrcblUsedPRT._ProdnRsceToolCategory._Text[1: Language=$session.system_language].ProdnRsceToolCategoryExtCode as mpe_fhmar preserving type) AS ProdnRsceToolCategoryExtCode,
  SFIOpActyNonTrcblUsedPRT.PlannedProdnRsceToolQtyUnit AS PlannedProdnRsceToolQtyUnit,
  SFIOpActyNonTrcblUsedPRT.PlannedTotalProdnRsceToolQty AS PlannedTotalProdnRsceToolQty,
  cast(SFIOpActyNonTrcblUsedPRT.ProdnRsceToolCategory as mpe_fhmar preserving type) AS ProdnRsceToolCategory,
  SFIOpActyNonTrcblUsedPRT.Material AS Material,
  SFIOpActyNonTrcblUsedPRT.Equipment AS Equipment,
  SFIOpActyNonTrcblUsedPRT.MiscProductionResourceTool AS MiscProductionResourceTool,
  cast(SFIOpActyNonTrcblUsedPRT.ProdnRsceToolItemNumber as mpe_psnfh_char) AS MfgOrderOpPRTItemNumber,
  SFIOpActyNonTrcblUsedPRT.PRTIsUsedAsTestEquipment AS PRTIsUsedAsTestEquipment,
  SFIOpActyNonTrcblUsedPRT.Plant AS Plant,
  OrderOperationBasic.OperationText AS MfgOrderOperationText,
  SFIOpActyNonTrcblUsedPRT._OperationActivityText[1: Language=$session.system_language].OperationActivityName AS OperationActivityName,
  SFIOpActyNonTrcblUsedPRT.OpActyNtwkElementElement AS OpActyNtwkElementElement,
  SFIOpActyNonTrcblUsedPRT.OpActyNtwkElementElmntVersCntr AS OpActyNtwkElementElmntVersCntr,
  SFIOpActyNonTrcblUsedPRT._OpActyNtwkInstance AS _OpActyNtwkInstance,
  SFIOpActyNonTrcblUsedPRT._OperationActivityInstance AS _OperationActivityInstance,
  SFIOpActyNonTrcblUsedPRT._OrdInternalBillOfOperations AS _OrdInternalBillOfOperations,
  SFIOpActyNonTrcblUsedPRT._ProdnRsceToolCategory AS _ProdnRsceToolCategory
FROM I_SFIOfOriginalReplacedSFI AS SFIOfOriginalReplacedSFI
INNER JOIN I_SFIOpActyNonTrcblUsedPRT AS SFIOpActyNonTrcblUsedPRT ON /* join condition not captured in parsed metadata */
INNER JOIN I_OrderOperationBasic AS OrderOperationBasic ON /* join condition not captured in parsed metadata */
;

Learn More