I_EquipmentStatus

DDL: I_EQUIPMENTSTATUS Type: view_entity COMPOSITE Package: IEQM
10 Fields 1 Data Sources

Equipment Status

I_EquipmentStatus (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Asset Management

I_EquipmentStatus is a Composite CDS View that provides data about "Equipment Status" in SAP S/4HANA. It reads from 1 data source (P_EquipmentStatusAggrgn) and exposes 10 fields with key field Equipment. Part of development package IEQM.

SAP API Hub

CategoryComposite
StateC1
Line of BusinessAsset Management
Application ComponentPM-EQM-EQ-2CL
CapabilitiesData Source in SQL Select,Association Target for Defining CDS Entities,Data Source for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageAsset Management for SAP S/4HANA Cloud Public Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
P_EquipmentStatusAggrgn _EquipmentStatus from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Equipment Status view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Equipment P_EquipmentStatusAggrgn Equipment Equipment Number
MaintObjectInternalID P_EquipmentStatusAggrgn MaintObjectInternalID Object number
EquipmentIsAtCustomer Checkbox
EquipmentIsAvailable Checkbox
EquipmentIsInWarehouse Checkbox
EquipmentIsAssignedToDelivery Checkbox
EquipmentIsMarkedForDeletion Checkbox
EquipmentIsInstalled Checkbox
EquipIsAllocToSuperiorEquip Checkbox
EquipmentIsInactive Checkbox

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_EquipmentStatus.
-- 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_EquipmentStatus AS
SELECT
  _EquipmentStatus.Equipment AS Equipment,
  _EquipmentStatus.MaintObjectInternalID AS MaintObjectInternalID,
  cast(_EquipmentStatus.EquipmentIsAtCustomer as xfeld preserving type) AS EquipmentIsAtCustomer,
  cast(_EquipmentStatus.EquipmentIsAvailable as xfeld preserving type) AS EquipmentIsAvailable,
  cast(_EquipmentStatus.EquipmentIsInWarehouse as xfeld preserving type) AS EquipmentIsInWarehouse,
  cast(_EquipmentStatus.EquipmentIsAssignedToDelivery as xfeld preserving type) AS EquipmentIsAssignedToDelivery,
  cast(_EquipmentStatus.EquipmentIsMarkedForDeletion as xfeld preserving type) AS EquipmentIsMarkedForDeletion,
  cast(_EquipmentStatus.EquipmentIsInstalled as xfeld preserving type ) AS EquipmentIsInstalled,
  cast(_EquipmentStatus.EquipIsAllocToSuperiorEquip as xfeld preserving type ) AS EquipIsAllocToSuperiorEquip,
  cast(_EquipmentStatus.EquipmentIsInactive as xfeld preserving type ) AS EquipmentIsInactive
FROM P_EquipmentStatusAggrgn AS _EquipmentStatus
;

Learn More