I_MatlSerialNumberInformation

DDL: I_MATLSERIALNUMBERINFORMATION Type: view_entity COMPOSITE

Serial Number Information

I_MatlSerialNumberInformation is a Composite CDS View that provides data about "Serial Number Information" in SAP S/4HANA. It reads from 1 data source (I_Equipment) and exposes 37 fields with key fields Equipment, Material, SerialNumber. It has 8 associations to related views.

1 data source(s) 37 fields

Data Sources (1)

SourceAliasJoin Type
I_Equipment I_Equipment from

Associations (8)

CardinalityTargetAliasCondition
[0..1] I_EquipmentStockSegment _StockSegment $projection.Equipment = _StockSegment.Equipment
[1..1] I_MasterWrntyObjectAssgmt _CustomerWarranty $projection.MaintObjectInternalID = _CustomerWarranty.ObjectInternalID and _CustomerWarranty.WarrantyType = '1'
[1..1] I_MasterWrntyObjectAssgmt _SupplierWarranty $projection.MaintObjectInternalID = _SupplierWarranty.ObjectInternalID and _SupplierWarranty.WarrantyType = '2'
[1..1] I_MaterialText _MaterialText $projection.Material = _MaterialText.Material and _MaterialText.Language = $session.system_language
[0..1] I_PlantMaintenancePartner _Partner $projection.MaintObjectInternalID = _Partner.MaintObjectInternalID and _Partner.PartnerFunction = 'AG'
[0..*] C_SerialNumberHistoryPartner _PartnerInfo $projection.MaintObjectInternalID = _PartnerInfo.MaintObjectInternalID
[0..1] I_SalesOrderItem _SalesOrderItem $projection.salesorder = _SalesOrderItem.SalesOrder and $projection.salesorderitem = _SalesOrderItem.SalesOrderItem
[0..*] I_SerialNumberHistory _SrlNmbrHistory

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Serial Number Information view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY Equipment Equipment
KEY Material Material
KEY SerialNumber SerialNumber
MasterWarranty MasterWarranty
MaintObjectInternalID MaintObjectInternalID
Plant _StockSegment Plant
StorageLocation _StockSegment StorageLocation
Customer _StockSegment Customer
Supplier _StockSegment Supplier
SalesOrder _StockSegment SalesOrder
SalesOrderItem _StockSegment SalesOrderItem
InventorySpecialStockType _StockSegment InventorySpecialStockType
WBSElementInternalID
Batch _StockSegment Batch
InventoryStockType _StockSegment InventoryStockType
StockOwner _StockSegment StockOwner
InventorySpecialStockTypeName
InventoryStockTypeName
MaterialName _MaterialText MaterialName
_Plant _StockSegment _Plant
_StorageLocation _StockSegment _StorageLocation
TechObjCustomerMasterWarranty _CustomerWarranty MasterWarranty
TechObjCustWarrantyStartDate _CustomerWarranty WarrantyStartDate
TechObjCustWarrantyEndDate _CustomerWarranty WarrantyEndDate
TechObjSuplrWarrantyStartDate _SupplierWarranty WarrantyStartDate
TechObjSupplierMasterWarranty _SupplierWarranty MasterWarranty
TechObjSuplrWarrantyEndDate _SupplierWarranty WarrantyEndDate
MaintenancePartner _Partner MaintenancePartner
BusinessPartnerName
CustomerName
SupplierName
_SrlNmbrHistory _SrlNmbrHistory
_Material _Material
_CustomerWarranty _CustomerWarranty
_SupplierWarranty _SupplierWarranty
_PartnerInfo _PartnerInfo
_SalesOrderItem _SalesOrderItem 
@AccessControl: { authorizationCheck: #MANDATORY,
                  personalData.blocking: #NOT_REQUIRED }

@VDM.viewType: #COMPOSITE

@ObjectModel.usageType: {
        dataClass:      #TRANSACTIONAL,
        serviceQuality: #C,
        sizeCategory:   #XL }
@ObjectModel.supportedCapabilities: [
  #SQL_DATA_SOURCE,
  #CDS_MODELING_DATA_SOURCE,
  #CDS_MODELING_ASSOCIATION_TARGET
]

@EndUserText.label: 'Serial Number Information'

define root view entity I_MatlSerialNumberInformation

  as select from I_Equipment
  composition [0..*] of I_SerialNumberHistory        as _SrlNmbrHistory

  association [0..1] to I_EquipmentStockSegment      as _StockSegment     on  $projection.Equipment = _StockSegment.Equipment
  association [1..1] to I_MasterWrntyObjectAssgmt    as _CustomerWarranty on  $projection.MaintObjectInternalID = _CustomerWarranty.ObjectInternalID
                                                                          and _CustomerWarranty.WarrantyType    = '1'
  association [1..1] to I_MasterWrntyObjectAssgmt    as _SupplierWarranty on  $projection.MaintObjectInternalID = _SupplierWarranty.ObjectInternalID
                                                                          and _SupplierWarranty.WarrantyType    = '2'
  association [1..1] to I_MaterialText               as _MaterialText     on  $projection.Material   = _MaterialText.Material
                                                                          and _MaterialText.Language = $session.system_language
  association [0..1] to I_PlantMaintenancePartner    as _Partner          on  $projection.MaintObjectInternalID = _Partner.MaintObjectInternalID
                                                                          and _Partner.PartnerFunction          = 'AG'
  association [0..*] to C_SerialNumberHistoryPartner as _PartnerInfo      on  $projection.MaintObjectInternalID = _PartnerInfo.MaintObjectInternalID
  association [0..1] to I_SalesOrderItem             as _SalesOrderItem   on  $projection.salesorder     = _SalesOrderItem.SalesOrder
                                                                          and $projection.salesorderitem = _SalesOrderItem.SalesOrderItem
{
  key Equipment,
  key Material,
  key SerialNumber,
      MasterWarranty,
      MaintObjectInternalID,

      _StockSegment.Plant,
      _StockSegment.StorageLocation,
      _StockSegment.Customer,
      _StockSegment.Supplier,
      _StockSegment.SalesOrder,
      _StockSegment.SalesOrderItem,
      _StockSegment.InventorySpecialStockType,
      cast( _StockSegment.WBSElementInternalID as nsdm_wbselement_internal_id preserving type ) as WBSElementInternalID,
      _StockSegment.Batch,
      _StockSegment.InventoryStockType,
      _StockSegment.StockOwner,
      _StockSegment._InventorySpecialStockType._Text[1: Language=$session.system_language].InventorySpecialStockTypeName,
      _StockSegment._InventoryStockType._Text[1: Language=$session.system_language].InventoryStockTypeName,
      _MaterialText.MaterialName,
      _StockSegment._Plant,
      _StockSegment._StorageLocation,
      _CustomerWarranty.MasterWarranty                                                          as TechObjCustomerMasterWarranty,
      _CustomerWarranty.WarrantyStartDate                                                       as TechObjCustWarrantyStartDate,
      _CustomerWarranty.WarrantyEndDate                                                         as TechObjCustWarrantyEndDate,
      _SupplierWarranty.WarrantyStartDate                                                       as TechObjSuplrWarrantyStartDate,
      _SupplierWarranty.MasterWarranty                                                          as TechObjSupplierMasterWarranty,
      _SupplierWarranty.WarrantyEndDate                                                         as TechObjSuplrWarrantyEndDate,
      _Partner.MaintenancePartner,
      _Partner._Customer.CustomerName                                                           as BusinessPartnerName,
      _StockSegment._Customer.CustomerName,
      _StockSegment._Supplier.SupplierName,

      //Associations

      _SrlNmbrHistory,
      _Material,
      _CustomerWarranty,
      _SupplierWarranty,
      _PartnerInfo,
      _SalesOrderItem
}
where
      Material     <> ''
  and SerialNumber <> ''

Learn More