I_ShopFloorExecToolEquipRegnVH

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

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). It is used in 1 Fiori application: Process Serial Number Groups.

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

Fiori Apps (1)

App IDApp NameTypeDescription
F6773 Process Serial Number Groups Transactional S/4HANA Manufacturing Production Engineering and Operations (PEO) 2022 FPS0 release offers a new functionality to collectively process any number of serial numbers as a group at an operation activity. The Process Serial Number Groups app allows production operators to create an maintain a group of serial numbers to be processed at an operation activity, execute SAS and some of the non-SAS actions (i.e. Start, Labor On, Complete, Pause, etc.) once for the complete group, view non-traceable components, PRTs and documents assigned to an operation activity as well as keep the activity log recorded for each serial number individually.

Process Serial Number Groups

Business Role: Production Operator - Discrete Manufacturing (Extended Production Operations)

With this app, you can collectively process any number of serial numbers as a group at an operation activity in the segment type Produce. This allows you, for example, to work on standardized serialized products that often need to undergo the same fabrication process. You perform the actions once for the serial number group and the system records the data individually for each serial number in that group. You access this app by executing a serial number group from the My Work Queue app.

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