I_EquipmentValidTimeSegment

DDL: I_EQUIPMENTVALIDTIMESEGMENT Type: view_entity COMPOSITE
44 Fields 2 Data Sources 8 Associations

Equipment with Valid Time Segment Record

I_EquipmentValidTimeSegment is a Composite CDS View that provides data about "Equipment with Valid Time Segment Record" in SAP S/4HANA. It reads from 2 data sources (P_EquipmentMaximumEndDate, I_EquipmentValidOnDate) and exposes 44 fields with key fields Equipment, ValidityEndDate, EquipUsagePeriodSequenceNumber. It has 8 associations to related views.

Data Sources (2)

SourceAliasJoin Type
P_EquipmentMaximumEndDate _EquipmentMaximumEndDate inner
I_EquipmentValidOnDate _EquipmentValidOnDate from

Associations (8)

CardinalityTargetAliasCondition
[0..1] I_LocationAccountAssignment _LocationAccountAssignment _LocationAccountAssignment.MaintObjectLocAcctAssgmtNmbr = $projection.MaintObjectLocAcctAssgmtNmbr
[0..1] I_WorkCenterType _WorkCenterType $projection.WorkCenterTypeCode = _WorkCenterType.WorkCenterTypeCode
[0..1] I_WorkCenter _WorkCenter _WorkCenter.WorkCenterInternalID = $projection.WorkCenterInternalID and _WorkCenter.WorkCenterTypeCode = $projection.WorkCenterTypeCode
[0..*] I_EquipmentText _SuperordinateEquipmentText _SuperordinateEquipmentText.Equipment = $projection.SuperordinateEquipment
[0..1] I_TechnicalReport _EquipmentCodeCatalog $projection.CatalogProfile = _EquipmentCodeCatalog.CatalogProfile
[0..1] I_Equipment _Equipment $projection.Equipment = _Equipment.Equipment
[0..1] I_Product _ConstructionMaterial $projection.ConstructionMaterial = _ConstructionMaterial.Product
[0..1] I_MaintenancePlanPlant _MaintenancePlanningPlant $projection.MaintenancePlanningPlant = _MaintenancePlanningPlant.MaintenancePlanningPlant

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Equipment with Valid Time Segment Record view
AccessControl.personalData.blocking #REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY Equipment P_EquipmentMaximumEndDate Equipment Equipment check
KEY ValidityEndDate P_EquipmentMaximumEndDate ValidityEndDate ValidTo
KEY EquipUsagePeriodSequenceNumber I_EquipmentValidOnDate EquipUsagePeriodSequenceNumber
EquipmentName I_EquipmentValidOnDate EquipmentName Tech. Obj. Desc
ValidOnDate P_EquipmentMaximumEndDate ValidOnDate Calendar Date
ValidityStartDate I_EquipmentValidOnDate ValidityStartDate Validity Start Date
ValidityEndTime I_EquipmentValidOnDate ValidityEndTime Valid To Time
NextEquipUsagePeriodSqncNmbr I_EquipmentValidOnDate NextEquipUsagePeriodSqncNmbr
MaintObjectLocAcctAssgmtNmbr I_EquipmentValidOnDate MaintObjectLocAcctAssgmtNmbr Loc/AccAssmt
WorkCenterInternalID I_EquipmentValidOnDate WorkCenterInternalID Work Center
WorkCenterTypeCode I_EquipmentValidOnDate WorkCenterTypeCode Object Type
MaintenancePlannerGroup I_EquipmentValidOnDate MaintenancePlannerGroup Planner Group
CatalogProfile I_EquipmentValidOnDate CatalogProfile Catalog Profile
MaintenancePlanningPlant I_EquipmentValidOnDate MaintenancePlanningPlant Planning Plant
SuperordinateEquipment I_EquipmentValidOnDate SuperordinateEquipment
EquipInstallationPositionNmbr I_EquipmentValidOnDate EquipInstallationPositionNmbr
TechnicalObjectSortCode I_EquipmentValidOnDate TechnicalObjectSortCode
ConstructionMaterial I_EquipmentValidOnDate ConstructionMaterial ConstType
LastChangeDate I_EquipmentValidOnDate LastChangeDate Time Stamp
LastChangeDateTime I_EquipmentValidOnDate LastChangeDateTime Timestamp
EquipmentManufacturerPrtNmbr I_EquipmentValidOnDate EquipmentManufacturerPrtNmbr Mfr Part Number
Material I_EquipmentValidOnDate Material Vehicle Model
SerialNumber I_EquipmentValidOnDate SerialNumber Serial Number
Plant I_EquipmentValidOnDate Plant Valuation Area
StorageLocation I_EquipmentValidOnDate StorageLocation StorageLocation
Batch I_EquipmentValidOnDate Batch Lot No.
Customer I_EquipmentValidOnDate Customer Sold-to Party
CurrentSerialNmbrCustomerName I_EquipmentValidOnDate CurrentSerialNmbrCustomerName
Supplier I_EquipmentValidOnDate Supplier Supplier
SalesOrder I_EquipmentValidOnDate SalesOrder SD Document
SalesOrderItem I_EquipmentValidOnDate SalesOrderItem Sales Order Item
WBSElementInternalID I_EquipmentValidOnDate WBSElementInternalID WBS Internal ID
InventorySpecialStockType I_EquipmentValidOnDate InventorySpecialStockType Special Stock Type
InventoryStockType I_EquipmentValidOnDate InventoryStockType Stock Type
MaterialSerialNumberStockBatch I_EquipmentValidOnDate MaterialSerialNumberStockBatch
MaintObjectFreeDefinedAttrib I_EquipmentValidOnDate MaintObjectFreeDefinedAttrib Sort Field
_LocationAccountAssignment _LocationAccountAssignment
_WorkCenterType _WorkCenterType
_WorkCenter _WorkCenter
_SuperordinateEquipmentText _SuperordinateEquipmentText
_EquipmentCodeCatalog _EquipmentCodeCatalog
_Equipment _Equipment
_ConstructionMaterial _ConstructionMaterial
_MaintenancePlanningPlant _MaintenancePlanningPlant

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_EquipmentValidTimeSegment.
-- 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_EquipmentValidTimeSegment AS
SELECT
  _EquipmentMaximumEndDate.Equipment AS Equipment,
  _EquipmentMaximumEndDate.ValidityEndDate AS ValidityEndDate,
  _EquipmentValidOnDate.EquipUsagePeriodSequenceNumber AS EquipUsagePeriodSequenceNumber,
  _EquipmentValidOnDate.EquipmentName AS EquipmentName,
  _EquipmentMaximumEndDate.ValidOnDate AS ValidOnDate,
  _EquipmentValidOnDate.ValidityStartDate AS ValidityStartDate,
  _EquipmentValidOnDate.ValidityEndTime AS ValidityEndTime,
  _EquipmentValidOnDate.NextEquipUsagePeriodSqncNmbr AS NextEquipUsagePeriodSqncNmbr,
  _EquipmentValidOnDate.MaintObjectLocAcctAssgmtNmbr AS MaintObjectLocAcctAssgmtNmbr,
  _EquipmentValidOnDate.WorkCenterInternalID AS WorkCenterInternalID,
  _EquipmentValidOnDate.WorkCenterTypeCode AS WorkCenterTypeCode,
  _EquipmentValidOnDate.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  _EquipmentValidOnDate.CatalogProfile AS CatalogProfile,
  _EquipmentValidOnDate.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  _EquipmentValidOnDate.SuperordinateEquipment AS SuperordinateEquipment,
  _EquipmentValidOnDate.EquipInstallationPositionNmbr AS EquipInstallationPositionNmbr,
  _EquipmentValidOnDate.TechnicalObjectSortCode AS TechnicalObjectSortCode,
  _EquipmentValidOnDate.ConstructionMaterial AS ConstructionMaterial,
  _EquipmentValidOnDate.LastChangeDate AS LastChangeDate,
  _EquipmentValidOnDate.LastChangeDateTime AS LastChangeDateTime,
  _EquipmentValidOnDate.EquipmentManufacturerPrtNmbr AS EquipmentManufacturerPrtNmbr,
  _EquipmentValidOnDate.Material AS Material,
  _EquipmentValidOnDate.SerialNumber AS SerialNumber,
  _EquipmentValidOnDate.Plant AS Plant,
  _EquipmentValidOnDate.StorageLocation AS StorageLocation,
  _EquipmentValidOnDate.Batch AS Batch,
  _EquipmentValidOnDate.Customer AS Customer,
  _EquipmentValidOnDate.CurrentSerialNmbrCustomerName AS CurrentSerialNmbrCustomerName,
  _EquipmentValidOnDate.Supplier AS Supplier,
  _EquipmentValidOnDate.SalesOrder AS SalesOrder,
  _EquipmentValidOnDate.SalesOrderItem AS SalesOrderItem,
  _EquipmentValidOnDate.WBSElementInternalID AS WBSElementInternalID,
  _EquipmentValidOnDate.InventorySpecialStockType AS InventorySpecialStockType,
  _EquipmentValidOnDate.InventoryStockType AS InventoryStockType,
  _EquipmentValidOnDate.MaterialSerialNumberStockBatch AS MaterialSerialNumberStockBatch,
  _EquipmentValidOnDate.MaintObjectFreeDefinedAttrib AS MaintObjectFreeDefinedAttrib
FROM I_EquipmentValidOnDate AS _EquipmentValidOnDate
INNER JOIN P_EquipmentMaximumEndDate AS _EquipmentMaximumEndDate ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_LocationAccountAssignment AS _LocationAccountAssignment ON _LocationAccountAssignment.MaintObjectLocAcctAssgmtNmbr = MaintObjectLocAcctAssgmtNmbr  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterType AS _WorkCenterType ON WorkCenterTypeCode = _WorkCenterType.WorkCenterTypeCode  -- association [0..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON _WorkCenter.WorkCenterInternalID = WorkCenterInternalID AND _WorkCenter.WorkCenterTypeCode = WorkCenterTypeCode  -- association [0..1]
LEFT OUTER JOIN I_EquipmentText AS _SuperordinateEquipmentText ON _SuperordinateEquipmentText.Equipment = SuperordinateEquipment  -- association [0..*]
LEFT OUTER JOIN I_TechnicalReport AS _EquipmentCodeCatalog ON CatalogProfile = _EquipmentCodeCatalog.CatalogProfile  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _Equipment ON Equipment = _Equipment.Equipment  -- association [0..1]
LEFT OUTER JOIN I_Product AS _ConstructionMaterial ON ConstructionMaterial = _ConstructionMaterial.Product  -- association [0..1]
LEFT OUTER JOIN I_MaintenancePlanPlant AS _MaintenancePlanningPlant ON MaintenancePlanningPlant = _MaintenancePlanningPlant.MaintenancePlanningPlant  -- association [0..1]
;

Learn More