C_OpActyInstceEquipActvRegn

DDL: C_OPACTYINSTCEEQUIPACTVREGN SQL: CMPEOAIEQACTVRGN Type: view CONSUMPTION
32 Fields 1 Data Sources

Actv Equipment Registration at OA Instce

C_OpActyInstceEquipActvRegn is a Consumption CDS View that provides data about "Actv Equipment Registration at OA Instce" in SAP S/4HANA. It reads from 1 data source (P_OpActyInstceEquipActvRegn) and exposes 32 fields with key fields OpActyNtwkInstance, OpActyNtwkElement, OrderInternalID, MfgOrderOpProdnRsceToolIntID, Equipment.

Data Sources (1)

SourceAliasJoin Type
P_OpActyInstceEquipActvRegn OpActyInstceEquipActvRegn from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CMPEOAIEQACTVRGN view
AbapCatalog.compiler.compareFilter true 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
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #CONSUMPTION view
UI.headerInfo.typeName Traceable PRT view
UI.headerInfo.typeNamePlural Traceable PRTs view
UI.headerInfo.title.label Traceable PRT view
UI.textArrangement #TEXT_LAST view
EndUserText.label Actv Equipment Registration at OA Instce view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY OpActyNtwkInstance P_OpActyInstceEquipActvRegn OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement P_OpActyInstceEquipActvRegn OpActyNtwkElement Element Number
KEY OrderInternalID P_OpActyInstceEquipActvRegn OrderInternalID Plan No.f.Oper.
KEY MfgOrderOpProdnRsceToolIntID P_OpActyInstceEquipActvRegn MfgOrderOpProdnRsceToolIntID
KEY Equipment P_OpActyInstceEquipActvRegn Equipment Equipment check
ProductionResourceTool
ProdnRsceToolCategoryExtCode
ProdnRsceToolCategory P_OpActyInstceEquipActvRegn ProdnRsceToolCategory
ProdnRsceToolCategoryName
MiscProductionResourceTool P_OpActyInstceEquipActvRegn MiscProductionResourceTool
ProdnRsceToolItemNumber P_OpActyInstceEquipActvRegn ProdnRsceToolItemNumber Item Number
PRTIsUsedAsTestEquipment P_OpActyInstceEquipActvRegn PRTIsUsedAsTestEquipment Test Equipment
EquipmentSerialNumber
UniqueItemIdentifier
Material P_OpActyInstceEquipActvRegn Material Vehicle Model
MaterialName
MfgOrderOperationText P_OpActyInstceEquipActvRegn MfgOrderOperationText Description
OperationActivityName
ManufacturingOrderCategory P_OpActyInstceEquipActvRegn ManufacturingOrderCategory
ManufacturingOrderType P_OpActyInstceEquipActvRegn ManufacturingOrderType
ProductionPlant P_OpActyInstceEquipActvRegn ProductionPlant Prod plnt
PRTRegistrationControl P_OpActyInstceEquipActvRegn PRTRegistrationControl Registration Type
PRTRegistrationControlName P_OpActyInstceEquipActvRegn PRTRegistrationControlName Short Description
_OpActyNtwkInstance P_OpActyInstceEquipActvRegn _OpActyNtwkInstance
_OperationActivityInstance P_OpActyInstceEquipActvRegn _OperationActivityInstance
_OrderInternalID P_OpActyInstceEquipActvRegn _OrderInternalID
_ProdnRsceToolCategory P_OpActyInstceEquipActvRegn _ProdnRsceToolCategory
_Equipment P_OpActyInstceEquipActvRegn _Equipment
_Material P_OpActyInstceEquipActvRegn _Material
_MfgOrderCategory P_OpActyInstceEquipActvRegn _MfgOrderCategory
_MfgOrderType P_OpActyInstceEquipActvRegn _MfgOrderType
_ProductionPlant P_OpActyInstceEquipActvRegn _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_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.
-- SQL view name: CMPEOAIEQACTVRGN

CREATE VIEW C_OpActyInstceEquipActvRegn AS
SELECT
  OpActyInstceEquipActvRegn.OpActyNtwkInstance AS OpActyNtwkInstance,
  OpActyInstceEquipActvRegn.OpActyNtwkElement AS OpActyNtwkElement,
  OpActyInstceEquipActvRegn.OrderInternalID AS OrderInternalID,
  OpActyInstceEquipActvRegn.MfgOrderOpProdnRsceToolIntID AS MfgOrderOpProdnRsceToolIntID,
  OpActyInstceEquipActvRegn.Equipment AS Equipment,
  cast( '' as pph_fhmnr ) AS ProductionResourceTool,
  cast(_ProdnRsceToolCategory._Text[1: Language=$session.system_language].ProdnRsceToolCategoryExtCode as mpe_fhmar preserving type) AS ProdnRsceToolCategoryExtCode,
  OpActyInstceEquipActvRegn.ProdnRsceToolCategory AS ProdnRsceToolCategory,
  OpActyInstceEquipActvRegn._ProdnRsceToolCategory._Text[1: Language=$session.system_language].ProdnRsceToolCategoryName AS ProdnRsceToolCategoryName,
  OpActyInstceEquipActvRegn.MiscProductionResourceTool AS MiscProductionResourceTool,
  OpActyInstceEquipActvRegn.ProdnRsceToolItemNumber AS ProdnRsceToolItemNumber,
  OpActyInstceEquipActvRegn.PRTIsUsedAsTestEquipment AS PRTIsUsedAsTestEquipment,
  OpActyInstceEquipActvRegn._Equipment.SerialNumber AS EquipmentSerialNumber,
  OpActyInstceEquipActvRegn._Equipment.UniqueItemIdentifier AS UniqueItemIdentifier,
  OpActyInstceEquipActvRegn.Material AS Material,
  OpActyInstceEquipActvRegn._Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  OpActyInstceEquipActvRegn.MfgOrderOperationText AS MfgOrderOperationText,
  OpActyInstceEquipActvRegn._OperationActivityText[1: Language=$session.system_language].OperationActivityName AS OperationActivityName,
  OpActyInstceEquipActvRegn.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  OpActyInstceEquipActvRegn.ManufacturingOrderType AS ManufacturingOrderType,
  OpActyInstceEquipActvRegn.ProductionPlant AS ProductionPlant,
  OpActyInstceEquipActvRegn.PRTRegistrationControl AS PRTRegistrationControl,
  OpActyInstceEquipActvRegn.PRTRegistrationControlName AS PRTRegistrationControlName,
  OpActyInstceEquipActvRegn._OpActyNtwkInstance AS _OpActyNtwkInstance,
  OpActyInstceEquipActvRegn._OperationActivityInstance AS _OperationActivityInstance,
  OpActyInstceEquipActvRegn._OrderInternalID AS _OrderInternalID,
  OpActyInstceEquipActvRegn._ProdnRsceToolCategory AS _ProdnRsceToolCategory,
  OpActyInstceEquipActvRegn._Equipment AS _Equipment,
  OpActyInstceEquipActvRegn._Material AS _Material,
  OpActyInstceEquipActvRegn._MfgOrderCategory AS _MfgOrderCategory,
  OpActyInstceEquipActvRegn._MfgOrderType AS _MfgOrderType,
  OpActyInstceEquipActvRegn._ProductionPlant AS _ProductionPlant
FROM P_OpActyInstceEquipActvRegn AS OpActyInstceEquipActvRegn
;

Learn More