I_OpActyInstceEquipActvRegn

DDL: I_OPACTYINSTCEEQUIPACTVREGN Type: view_entity COMPOSITE
21 Fields 1 Data Sources

Active Equipment Registration at an OA Instance

I_OpActyInstceEquipActvRegn is a Composite CDS View that provides data about "Active Equipment Registration at an OA Instance" in SAP S/4HANA. It reads from 1 data source (I_OpActyInstceEquipRegn) and exposes 21 fields with key field OpActyInstanceEquipmentRegn.

Data Sources (1)

SourceAliasJoin Type
I_OpActyInstceEquipRegn OpActyInstceEquipRegn from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey OpActyInstanceEquipmentRegn view
VDM.viewType #COMPOSITE view
EndUserText.label Active Equipment Registration at an OA Instance view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY OpActyInstanceEquipmentRegn I_OpActyInstceEquipRegn OpActyInstanceEquipmentRegn Document Number
OrderInternalID I_OpActyInstceEquipRegn OrderInternalID Plan No.f.Oper.
MfgOrderOpProdnRsceToolIntID I_OpActyInstceEquipRegn MfgOrderOpProdnRsceToolIntID Test equipment
OpActyNtwkInstance I_OpActyInstceEquipRegn OpActyNtwkInstance Instance ID
OpActyNtwkElement I_OpActyInstceEquipRegn OpActyNtwkElement Element Number
ShopFloorItem I_OpActyInstceEquipRegn ShopFloorItem Serial.Mat. ID
Equipment I_OpActyInstceEquipRegn Equipment Equipment check
EquipmentMaterial
Plant
EquipmentSerialNumber
UniqueItemIdentifier
CreatedByUser I_OpActyInstceEquipRegn CreatedByUser User Name
CreationDateTime I_OpActyInstceEquipRegn CreationDateTime Timestamp
_OpActyNtwkInstance I_OpActyInstceEquipRegn _OpActyNtwkInstance
_OpActyNtwkInstanceBasic I_OpActyInstceEquipRegn _OpActyNtwkInstanceBasic
_OperationActivityInstance I_OpActyInstceEquipRegn _OperationActivityInstance
_ShopFloorItem I_OpActyInstceEquipRegn _ShopFloorItem
_Equipment I_OpActyInstceEquipRegn _Equipment
_Material
_OrdInternalBillOfOperations I_OpActyInstceEquipRegn _OrdInternalBillOfOperations
_OrderInternalID I_OpActyInstceEquipRegn _OrderInternalID

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 I_OpActyInstceEquipActvRegn.
-- 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 I_OpActyInstceEquipActvRegn AS
SELECT
  OpActyInstceEquipRegn.OpActyInstanceEquipmentRegn AS OpActyInstanceEquipmentRegn,
  OpActyInstceEquipRegn.OrderInternalID AS OrderInternalID,
  OpActyInstceEquipRegn.MfgOrderOpProdnRsceToolIntID AS MfgOrderOpProdnRsceToolIntID,
  OpActyInstceEquipRegn.OpActyNtwkInstance AS OpActyNtwkInstance,
  OpActyInstceEquipRegn.OpActyNtwkElement AS OpActyNtwkElement,
  OpActyInstceEquipRegn.ShopFloorItem AS ShopFloorItem,
  OpActyInstceEquipRegn.Equipment AS Equipment,
  OpActyInstceEquipRegn._Equipment.Material AS EquipmentMaterial,
  OpActyInstceEquipRegn._Equipment.Plant AS Plant,
  OpActyInstceEquipRegn._Equipment.SerialNumber AS EquipmentSerialNumber,
  OpActyInstceEquipRegn._Equipment.UniqueItemIdentifier AS UniqueItemIdentifier,
  OpActyInstceEquipRegn.CreatedByUser AS CreatedByUser,
  OpActyInstceEquipRegn.CreationDateTime AS CreationDateTime,
  OpActyInstceEquipRegn._OpActyNtwkInstance AS _OpActyNtwkInstance,
  OpActyInstceEquipRegn._OpActyNtwkInstanceBasic AS _OpActyNtwkInstanceBasic,
  OpActyInstceEquipRegn._OperationActivityInstance AS _OperationActivityInstance,
  OpActyInstceEquipRegn._ShopFloorItem AS _ShopFloorItem,
  OpActyInstceEquipRegn._Equipment AS _Equipment,
  OpActyInstceEquipRegn._Equipment._Material AS _Material,
  OpActyInstceEquipRegn._OrdInternalBillOfOperations AS _OrdInternalBillOfOperations,
  OpActyInstceEquipRegn._OrderInternalID AS _OrderInternalID
FROM I_OpActyInstceEquipRegn AS OpActyInstceEquipRegn
;

Learn More