C_SFIOpActyInstceEquipActvRegn

DDL: C_SFIOPACTYINSTCEEQUIPACTVREGN Type: view CONSUMPTION
36 Fields 2 Data Sources

C_SFIOpActyInstceEquipActvRegn is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_SFIOfOriginalReplacedSFI, P_SFIOpActyInstceEquipActvRegn) and exposes 36 fields with key fields OpActyNtwkInstance, OpActyNtwkElement, OrderInternalID, MfgOrderOpProdnRsceToolIntID, ShopFloorItem.

Data Sources (2)

SourceAliasJoin Type
I_SFIOfOriginalReplacedSFI SFIOfOriginalReplacedSFI from
P_SFIOpActyInstceEquipActvRegn SFIOpActyInstceEquipActvRegn inner

Annotations (12)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName CMPEOAIACTVEQRGN view
AccessControl.authorizationCheck #MANDATORY view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
UI.headerInfo.title.label Traceable PRT view
UI.headerInfo.typeName Traceable PRT view
UI.headerInfo.typeNamePlural Traceable PRTs view
UI.textArrangement #TEXT_LAST view
VDM.viewType #CONSUMPTION view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY OpActyNtwkInstance P_SFIOpActyInstceEquipActvRegn OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement P_SFIOpActyInstceEquipActvRegn OpActyNtwkElement Element Number
KEY OrderInternalID P_SFIOpActyInstceEquipActvRegn OrderInternalID Plan No.f.Oper.
KEY MfgOrderOpProdnRsceToolIntID P_SFIOpActyInstceEquipActvRegn MfgOrderOpProdnRsceToolIntID
KEY ShopFloorItem P_SFIOpActyInstceEquipActvRegn ShopFloorItem Serial.Mat. ID
KEY OpActyInstanceEquipmentRegn P_SFIOpActyInstceEquipActvRegn OpActyInstanceEquipmentRegn
OriginalReplacedShopFloorItem I_SFIOfOriginalReplacedSFI OriginalReplacedShopFloorItem
ProductionResourceTool
ProdnRsceToolCategoryExtCode
ProdnRsceToolCategory
ProdnRsceToolCategoryName
MiscProductionResourceTool P_SFIOpActyInstceEquipActvRegn MiscProductionResourceTool
ProdnRsceToolItemNumber P_SFIOpActyInstceEquipActvRegn ProdnRsceToolItemNumber Item Number
PRTIsUsedAsTestEquipment P_SFIOpActyInstceEquipActvRegn PRTIsUsedAsTestEquipment Test Equipment
EquipmentSerialNumber P_SFIOpActyInstceEquipActvRegn EquipmentSerialNumber
UniqueItemIdentifier P_SFIOpActyInstceEquipActvRegn UniqueItemIdentifier UII
Material P_SFIOpActyInstceEquipActvRegn Material Vehicle Model
MaterialName
Equipment P_SFIOpActyInstceEquipActvRegn Equipment Equipment check
MfgOrderOperationText P_SFIOpActyInstceEquipActvRegn MfgOrderOperationText Description
OperationActivityName
ManufacturingOrderCategory P_SFIOpActyInstceEquipActvRegn ManufacturingOrderCategory
ManufacturingOrderType P_SFIOpActyInstceEquipActvRegn ManufacturingOrderType
ProductionPlant P_SFIOpActyInstceEquipActvRegn ProductionPlant Prod plnt
PRTRegistrationControl P_SFIOpActyInstceEquipActvRegn PRTRegistrationControl Registration Type
PRTRegistrationControlName P_SFIOpActyInstceEquipActvRegn PRTRegistrationControlName Short Description
_OpActyNtwkInstance P_SFIOpActyInstceEquipActvRegn _OpActyNtwkInstance
_OperationActivityInstance P_SFIOpActyInstceEquipActvRegn _OperationActivityInstance
_OrderInternalID P_SFIOpActyInstceEquipActvRegn _OrderInternalID
_ProdnRsceToolCategory P_SFIOpActyInstceEquipActvRegn _ProdnRsceToolCategory
_Equipment P_SFIOpActyInstceEquipActvRegn _Equipment
_ShopFloorItem P_SFIOpActyInstceEquipActvRegn _ShopFloorItem
_Material P_SFIOpActyInstceEquipActvRegn _Material
_MfgOrderCategory P_SFIOpActyInstceEquipActvRegn _MfgOrderCategory
_MfgOrderType P_SFIOpActyInstceEquipActvRegn _MfgOrderType
_ProductionPlant P_SFIOpActyInstceEquipActvRegn _ProductionPlant

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_SFIOpActyInstceEquipActvRegn.
-- 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_SFIOpActyInstceEquipActvRegn AS
SELECT
  SFIOpActyInstceEquipActvRegn.OpActyNtwkInstance AS OpActyNtwkInstance,
  SFIOpActyInstceEquipActvRegn.OpActyNtwkElement AS OpActyNtwkElement,
  SFIOpActyInstceEquipActvRegn.OrderInternalID AS OrderInternalID,
  SFIOpActyInstceEquipActvRegn.MfgOrderOpProdnRsceToolIntID AS MfgOrderOpProdnRsceToolIntID,
  SFIOpActyInstceEquipActvRegn.ShopFloorItem AS ShopFloorItem,
  SFIOpActyInstceEquipActvRegn.OpActyInstanceEquipmentRegn AS OpActyInstanceEquipmentRegn,
  SFIOfOriginalReplacedSFI.OriginalReplacedShopFloorItem AS OriginalReplacedShopFloorItem,
  cast( '' as pph_fhmnr ) AS ProductionResourceTool,
  cast(SFIOpActyInstceEquipActvRegn._ProdnRsceToolCategory._Text[1: Language=$session.system_language].ProdnRsceToolCategoryExtCode as mpe_fhmar preserving type) AS ProdnRsceToolCategoryExtCode,
  cast(SFIOpActyInstceEquipActvRegn.ProdnRsceToolCategory as mpe_fhmar preserving type) AS ProdnRsceToolCategory,
  SFIOpActyInstceEquipActvRegn._ProdnRsceToolCategory._Text[1: Language=$session.system_language].ProdnRsceToolCategoryName AS ProdnRsceToolCategoryName,
  SFIOpActyInstceEquipActvRegn.MiscProductionResourceTool AS MiscProductionResourceTool,
  SFIOpActyInstceEquipActvRegn.ProdnRsceToolItemNumber AS ProdnRsceToolItemNumber,
  SFIOpActyInstceEquipActvRegn.PRTIsUsedAsTestEquipment AS PRTIsUsedAsTestEquipment,
  SFIOpActyInstceEquipActvRegn.EquipmentSerialNumber AS EquipmentSerialNumber,
  SFIOpActyInstceEquipActvRegn.UniqueItemIdentifier AS UniqueItemIdentifier,
  SFIOpActyInstceEquipActvRegn.Material AS Material,
  SFIOpActyInstceEquipActvRegn._Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  SFIOpActyInstceEquipActvRegn.Equipment AS Equipment,
  SFIOpActyInstceEquipActvRegn.MfgOrderOperationText AS MfgOrderOperationText,
  SFIOpActyInstceEquipActvRegn._OperationActivityText[1: Language=$session.system_language].OperationActivityName AS OperationActivityName,
  SFIOpActyInstceEquipActvRegn.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  SFIOpActyInstceEquipActvRegn.ManufacturingOrderType AS ManufacturingOrderType,
  SFIOpActyInstceEquipActvRegn.ProductionPlant AS ProductionPlant,
  SFIOpActyInstceEquipActvRegn.PRTRegistrationControl AS PRTRegistrationControl,
  SFIOpActyInstceEquipActvRegn.PRTRegistrationControlName AS PRTRegistrationControlName,
  SFIOpActyInstceEquipActvRegn._OpActyNtwkInstance AS _OpActyNtwkInstance,
  SFIOpActyInstceEquipActvRegn._OperationActivityInstance AS _OperationActivityInstance,
  SFIOpActyInstceEquipActvRegn._OrderInternalID AS _OrderInternalID,
  SFIOpActyInstceEquipActvRegn._ProdnRsceToolCategory AS _ProdnRsceToolCategory,
  SFIOpActyInstceEquipActvRegn._Equipment AS _Equipment,
  SFIOpActyInstceEquipActvRegn._ShopFloorItem AS _ShopFloorItem,
  SFIOpActyInstceEquipActvRegn._Material AS _Material,
  SFIOpActyInstceEquipActvRegn._MfgOrderCategory AS _MfgOrderCategory,
  SFIOpActyInstceEquipActvRegn._MfgOrderType AS _MfgOrderType,
  SFIOpActyInstceEquipActvRegn._ProductionPlant AS _ProductionPlant
FROM I_SFIOfOriginalReplacedSFI AS SFIOfOriginalReplacedSFI
INNER JOIN P_SFIOpActyInstceEquipActvRegn AS SFIOpActyInstceEquipActvRegn ON /* join condition not captured in parsed metadata */
;

Learn More