I_EquipMatlSerialNumber

DDL: I_EQUIPMATLSERIALNUMBER Type: view COMPOSITE
42 Fields 1 Data Sources 1 Associations 1 OData Services

Material Serial Number

I_EquipMatlSerialNumber is a Composite CDS View that provides data about "Material Serial Number" in SAP S/4HANA. It reads from 1 data source (I_Equipment) and exposes 42 fields with key fields Material, SerialNumber. It has 1 association to related views. It is exposed through 1 OData service (EAM_MATERIALSERIALNUMBER).

Data Sources (1)

SourceAliasJoin Type
I_Equipment Equipment from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_EquipMatlLastSerialNumber _EquipMatlLastSerialNumber $projection.Material = _EquipMatlLastSerialNumber.Material association[0..1] to I_PlantMaintenancePartner as _PlantMaintenancePartner on Equipment.MaintObjectInternalID = _PlantMaintenancePartner.MaintObjectInternalID

Annotations (11)

NameValueLevelField
EndUserText.label Material Serial Number view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName IEQUIPMATSERNUM view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
Analytics.internalName #LOCAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey SerialNumber view
AccessControl.personalData.blocking #REQUIRED view

OData Services (1)

ServiceBindingVersionContractRelease
EAM_MATERIALSERIALNUMBER EAM_SB_MATERIALSERIALNUMBER V4 C1 NOT_RELEASED

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY Material I_Equipment Material Vehicle Model
KEY SerialNumber I_Equipment SerialNumber Serial Number
Equipment I_Equipment Equipment Equipment check
EquipmentCategory I_Equipment EquipmentCategory EquipCategory
UniqueItemIdentifier I_Equipment UniqueItemIdentifier UII
UniqueItemIdentifierStrucType I_Equipment UniqueItemIdentifierStrucType IUID Type
UniqueItemIdentifierRespPlant I_Equipment UniqueItemIdentifierRespPlant Resp. Plant UII
MaintObjectInternalID I_Equipment MaintObjectInternalID Object number
HasEquipmentData I_Equipment HasEquipmentData Equipment data
EquipmentHasStockInformation I_Equipment EquipmentHasStockInformation
CreatedByUser I_Equipment CreatedByUser User Name
LastChangedByUser I_Equipment LastChangedByUser User Name
CreationDate I_Equipment CreationDate Time Stamp
LastChangeDate I_Equipment LastChangeDate Time Stamp
LastChangeDateTime I_Equipment LastChangeDateTime Timestamp
MatlSrlNmbrMasterBatch I_Equipment Batch Lot No.
MatlSrlNmbrLastGdsMvtDte I_Equipment MatlSrlNmbrLastGdsMvtDte Date L.GoodsMvt
EquipMaterialLastSerialNumber _EquipMatlLastSerialNumber EquipMaterialLastSerialNumber
InventoryStockType SerialNumberStockSegment InventoryStockType Stock Type
Plant SerialNumberStockSegment Plant Valuation Area
StorageLocation SerialNumberStockSegment StorageLocation StorageLocation
MaterialSerialNumberStockBatch SerialNumberStockSegment Batch Lot No.
InventorySpecialStockType SerialNumberStockSegment InventorySpecialStockType Special Stock Type
Customer SerialNumberStockSegment Customer Sold-to Party
Supplier SerialNumberStockSegment Supplier Supplier
SalesOrder SerialNumberStockSegment SalesOrder SD Document
SalesOrderItem SerialNumberStockSegment SalesOrderItem Sales Order Item
WBSElementInternalID
StockOwner SerialNumberStockSegment StockOwner Owner of stock
_EquipmentText I_Equipment _EquipmentText
_Status I_Equipment _Status
_Material I_Equipment _Material
_EquipmentCategory I_Equipment _EquipmentCategory
_InventoryStockType SerialNumberStockSegment _InventoryStockType
_Plant SerialNumberStockSegment _Plant
_StorageLocation SerialNumberStockSegment _StorageLocation
_Customer SerialNumberStockSegment _Customer
_Supplier SerialNumberStockSegment _Supplier
_InventorySpecialStockType SerialNumberStockSegment _InventorySpecialStockType
_SalesOrder SerialNumberStockSegment _SalesOrder
_SalesOrderItem SerialNumberStockSegment _SalesOrderItem
_WBSElementByInternalKey SerialNumberStockSegment _WBSElementByInternalKey

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_EquipMatlSerialNumber.
-- 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_EquipMatlSerialNumber AS
SELECT
  Equipment.Material AS Material,
  Equipment.SerialNumber AS SerialNumber,
  Equipment.Equipment AS Equipment,
  Equipment.EquipmentCategory AS EquipmentCategory,
  Equipment.UniqueItemIdentifier AS UniqueItemIdentifier,
  Equipment.UniqueItemIdentifierStrucType AS UniqueItemIdentifierStrucType,
  Equipment.UniqueItemIdentifierRespPlant AS UniqueItemIdentifierRespPlant,
  Equipment.MaintObjectInternalID AS MaintObjectInternalID,
  Equipment.HasEquipmentData AS HasEquipmentData,
  Equipment.EquipmentHasStockInformation AS EquipmentHasStockInformation,
  Equipment.CreatedByUser AS CreatedByUser,
  Equipment.LastChangedByUser AS LastChangedByUser,
  Equipment.CreationDate AS CreationDate,
  Equipment.LastChangeDate AS LastChangeDate,
  Equipment.LastChangeDateTime AS LastChangeDateTime,
  Equipment.Batch AS MatlSrlNmbrMasterBatch,
  Equipment.MatlSrlNmbrLastGdsMvtDte AS MatlSrlNmbrLastGdsMvtDte,
  _EquipMatlLastSerialNumber.EquipMaterialLastSerialNumber AS EquipMaterialLastSerialNumber,
  SerialNumberStockSegment.InventoryStockType AS InventoryStockType,
  SerialNumberStockSegment.Plant AS Plant,
  SerialNumberStockSegment.StorageLocation AS StorageLocation,
  SerialNumberStockSegment.Batch AS MaterialSerialNumberStockBatch,
  SerialNumberStockSegment.InventorySpecialStockType AS InventorySpecialStockType,
  SerialNumberStockSegment.Customer AS Customer,
  SerialNumberStockSegment.Supplier AS Supplier,
  SerialNumberStockSegment.SalesOrder AS SalesOrder,
  SerialNumberStockSegment.SalesOrderItem AS SalesOrderItem,
  cast(SerialNumberStockSegment.WBSElementInternalID as ps_s4_pspnr preserving type) AS WBSElementInternalID,
  SerialNumberStockSegment.StockOwner AS StockOwner,
  Equipment._EquipmentText AS _EquipmentText,
  Equipment._Status AS _Status,
  Equipment._Material AS _Material,
  Equipment._EquipmentCategory AS _EquipmentCategory,
  SerialNumberStockSegment._InventoryStockType AS _InventoryStockType,
  SerialNumberStockSegment._Plant AS _Plant,
  SerialNumberStockSegment._StorageLocation AS _StorageLocation,
  SerialNumberStockSegment._Customer AS _Customer,
  SerialNumberStockSegment._Supplier AS _Supplier,
  SerialNumberStockSegment._InventorySpecialStockType AS _InventorySpecialStockType,
  SerialNumberStockSegment._SalesOrder AS _SalesOrder,
  SerialNumberStockSegment._SalesOrderItem AS _SalesOrderItem,
  SerialNumberStockSegment._WBSElementByInternalKey AS _WBSElementByInternalKey
FROM I_Equipment AS Equipment
LEFT OUTER JOIN I_EquipMatlLastSerialNumber AS _EquipMatlLastSerialNumber ON Material = _EquipMatlLastSerialNumber.Material association[0..1] to I_PlantMaintenancePartner as _PlantMaintenancePartner on Equipment.MaintObjectInternalID = _PlantMaintenancePartner.MaintObjectInternalID  -- association [0..1]
;

Learn More