I_EquipmentStatus

DDL: I_EQUIPMENTSTATUS SQL: IEQUIPMENTSTATUS Type: view COMPOSITE
10 Fields 1 Data Sources

Equipment Status

I_EquipmentStatus (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private 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.

SAP API Hub

StateC1
Line of BusinessAsset Management
Application ComponentPM-EQM-EQ
CapabilitiesData Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities
PackageAsset Management for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
P_EquipmentStatusAggrgn _EquipmentStatus from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IEQUIPMENTSTATUS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
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
ClientHandling.algorithm #SESSION_VARIABLE 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.
-- SQL view name: IEQUIPMENTSTATUS

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