I_ShopFloorExecToolEquipRegnVH

DDL: I_SHOPFLOOREXECTOOLEQUIPREGNVH SQL: ISFEEQUIPREGVH Type: view COMPOSITE Package: MPE_EXEC_TRACKABLE_TOOLS
14 Fields 1 Data Sources 1 Associations 1 OData Services

Value help view for equipment valid for registration

I_ShopFloorExecToolEquipRegnVH is a Composite CDS View that provides data about "Value help view for equipment valid for registration" in SAP S/4HANA. It reads from 1 data source (I_TrackToolUsageEquipment) and exposes 14 fields with key field Equipment. It has 1 association to related views. It is exposed through 1 OData service (UI_OPACTYSFIGROUP_EXECUTE). Part of development package MPE_EXEC_TRACKABLE_TOOLS.

Data Sources (1)

SourceAliasJoin Type
I_TrackToolUsageEquipment TrackToolUsageEquipment from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_EquipmentStdVH _EquipmentStdVH _EquipmentStdVH.Equipment = $projection.Equipment

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ISFEEQUIPREGVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Value help view for equipment valid for registration view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey Equipment view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_OPACTYSFIGROUP_EXECUTE UI_OPACTYSFIGROUP_EXECUTE V2 C1 NOT_RELEASED

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY Equipment I_TrackToolUsageEquipment Equipment Equipment check
SerialNumber _Equipment SerialNumber Serial Number
Material _Equipment Material Vehicle Model
UniqueItemIdentifier _Equipment UniqueItemIdentifier UII
MaintObjectInternalID _Equipment MaintObjectInternalID Object number
Customer _EquipmentStdVH Customer Sold-to Party
Supplier _EquipmentStdVH Supplier Supplier
AuthorizationGroup _EquipmentStdVH AuthorizationGroup AuthorizGroup
ShopFloorRtgPRTIsRegistrable I_TrackToolUsageEquipment ShopFloorRtgPRTIsRegistrable
_Customer _EquipmentStdVH _Customer
_Supplier _EquipmentStdVH _Supplier
_Status _Equipment _Status
_Material _Equipment _Material
_EquipmentProdnRsceTool I_TrackToolUsageEquipment _EquipmentProdnRsceTool

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_ShopFloorExecToolEquipRegnVH.
-- 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: ISFEEQUIPREGVH

CREATE VIEW I_ShopFloorExecToolEquipRegnVH AS
SELECT
  TrackToolUsageEquipment.Equipment AS Equipment,
  _Equipment.SerialNumber AS SerialNumber,
  _Equipment.Material AS Material,
  _Equipment.UniqueItemIdentifier AS UniqueItemIdentifier,
  _Equipment.MaintObjectInternalID AS MaintObjectInternalID,
  _EquipmentStdVH.Customer AS Customer,
  _EquipmentStdVH.Supplier AS Supplier,
  _EquipmentStdVH.AuthorizationGroup AS AuthorizationGroup,
  TrackToolUsageEquipment.ShopFloorRtgPRTIsRegistrable AS ShopFloorRtgPRTIsRegistrable,
  _EquipmentStdVH._Customer AS _Customer,
  _EquipmentStdVH._Supplier AS _Supplier,
  _Equipment._Status AS _Status,
  _Equipment._Material AS _Material,
  TrackToolUsageEquipment._EquipmentProdnRsceTool AS _EquipmentProdnRsceTool
FROM I_TrackToolUsageEquipment AS TrackToolUsageEquipment
LEFT OUTER JOIN I_EquipmentStdVH AS _EquipmentStdVH ON _EquipmentStdVH.Equipment = Equipment  -- association [1..1]
;

Learn More