I_SerialNumberHistory

DDL: I_SERIALNUMBERHISTORY Type: view_entity COMPOSITE

Serial Number History

I_SerialNumberHistory is a Composite CDS View that provides data about "Serial Number History" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceObjectListItem) and exposes 66 fields with key fields MaintenanceObjectList, MaintenanceObjectListItem. It has 2 associations to related views.

1 data source(s) 66 fields

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceObjectListItem I_MaintenanceObjectListItem from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_MaintObjectListCollection _ObjListCollection $projection.MaintenanceObjectList = _ObjListCollection.MaintenanceObjectList
[0..1] I_SrlNmbrBizDocObjectTypeText _ObjectTypeText $projection.srlnmbrbizdocumentobjecttype = _ObjectTypeText.SrlNmbrBizDocumentObjectType and _ObjectTypeText.Language = $session.system_language

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 History view

Fields (66)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceObjectList MaintenanceObjectList
KEY MaintenanceObjectListItem MaintenanceObjectListItem
Equipment Equipment
Material Material
SerialNumber SerialNumber
DeliveryDocument _ObjListCollection DeliveryDocument
DeliveryDocumentItem _ObjListCollection DeliveryDocumentItem
SalesOrder _ObjListCollection SalesOrder
SalesOrderItem _ObjListCollection SalesOrderItem
MaterialDocument _ObjListCollection MaterialDocument
MaterialDocumentItem _ObjListCollection MaterialDocumentItem
MaterialDocumentYear _ObjListCollection MaterialDocumentYear
InspectionLot _ObjListCollection InspectionLot
LogisticsOrder _ObjListCollection LogisticsOrder
OrderItem _ObjListCollection OrderItem
HandlingUnitExternalID _ObjListCollection HandlingUnitExternalID
PhysicalInventoryDocument _ObjListCollection PhysicalInventoryDocument
PhysicalInventoryDocumentItem _ObjListCollection PhysicalInventoryDocumentItem
FiscalYear _ObjListCollection FiscalYear
PurchaseOrder _ObjListCollection PurchaseOrder
PurchaseOrderItem _ObjListCollection PurchaseOrderItem
PurchaseRequisition _ObjListCollection PurchaseRequisition
PurchaseRequisitionItem _ObjListCollection PurchaseRequisitionItem
InternalJITCallNumber _ObjListCollection InternalJITCallNumber
JITCallItemNumber _ObjListCollection JITCallItemNumber
CompGrpNumber _ObjListCollection CompGrpNumber
SerialNumberAssignmentDate _ObjListCollection SerialNumberAssignmentDate
SerialNumberAssignmentTime _ObjListCollection SerialNumberAssignmentTime
Customer _ObjListCollection Customer
CustomerName _ObjListCollection CustomerName
Supplier _ObjListCollection Supplier
SupplierName _ObjListCollection SupplierName
NumberOfSerialNumbers _ObjListCollection NumberOfSerialNumbers
SDDocumentCategory _ObjListCollection SDDocumentCategory
GoodsMovementType _ObjListCollection GoodsMovementType
MovementTypeDescription _ObjListCollection MovementTypeDescription
SalesOrderType _ObjListCollection SalesOrderType
SalesDocumentTypeName _ObjListCollection SalesDocumentTypeName
SalesOrderItemCategory _ObjListCollection SalesOrderItemCategory
AccountingDocumentType _ObjListCollection AccountingDocumentType
AccountingDocumentTypeName _ObjListCollection AccountingDocumentTypeName
Plant _ObjListCollection Plant
PlantName _ObjListCollection PlantName
StorageLocation _ObjListCollection StorageLocation
StorageLocationName _ObjListCollection StorageLocationName
Batch _ObjListCollection Batch
DebitCreditCode _ObjListCollection DebitCreditCode
DebitCreditCodeName _ObjListCollection DebitCreditCodeName
OrderCategory _ObjListCollection OrderCategory
OrderType _ObjListCollection OrderType
OrderTypeName _ObjListCollection OrderTypeName
OrderIsRefurbishmentOrder _ObjListCollection OrderIsRefurbishmentOrder
SerialNumberPhysicalInvtryType _ObjListCollection SerialNumberPhysicalInvtryType
PhysicalInventoryStockType _ObjListCollection PhysicalInventoryStockType
PhysicalInventoryStockTypeName _ObjListCollection PhysicalInventoryStockTypeName
PurchasingDocumentCategory _ObjListCollection PurchasingDocumentCategory
PurchasingDocumentType _ObjListCollection PurchasingDocumentType
PurchasingDocumentTypeName _ObjListCollection PurchasingDocumentTypeName
PurchasingDocumentItemCategory _ObjListCollection PurchasingDocumentItemCategory
ExternalJITCallNumber _ObjListCollection ExternalJITCallNumber
ShipToParty _ObjListCollection ShipToParty
BusinessPartnerName _ObjListCollection BusinessPartnerName
SubcontrgCompOfInbDelivItem _ObjListCollection SubcontrgCompOfInbDelivItem
SrlNmbrBizDocumentObjectType _ObjListCollection SrlNmbrBizDocumentObjectType
_MatlSrlNmbrInfo _MatlSrlNmbrInfo
_ObjectTypeText _ObjectTypeText 
@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 History'

define view entity I_SerialNumberHistory
  as select from I_MaintenanceObjectListItem
  association        to parent I_MatlSerialNumberInformation as _MatlSrlNmbrInfo   on  $projection.Material     = _MatlSrlNmbrInfo.Material
                                                                                   and $projection.SerialNumber = _MatlSrlNmbrInfo.SerialNumber
                                                                                   and $projection.Equipment    = _MatlSrlNmbrInfo.Equipment

  association [1..1] to I_MaintObjectListCollection          as _ObjListCollection on  $projection.MaintenanceObjectList = _ObjListCollection.MaintenanceObjectList
  association [0..1] to I_SrlNmbrBizDocObjectTypeText        as _ObjectTypeText    on  $projection.srlnmbrbizdocumentobjecttype = _ObjectTypeText.SrlNmbrBizDocumentObjectType
                                                                                   and _ObjectTypeText.Language                 = $session.system_language

{
  key MaintenanceObjectList,
  key MaintenanceObjectListItem,
      Equipment,
      Material,
      SerialNumber,
      _ObjListCollection.DeliveryDocument,
      _ObjListCollection.DeliveryDocumentItem,
      _ObjListCollection.SalesOrder,
      _ObjListCollection.SalesOrderItem,
      _ObjListCollection.MaterialDocument,
      _ObjListCollection.MaterialDocumentItem,
      _ObjListCollection.MaterialDocumentYear,
      _ObjListCollection.InspectionLot,
      _ObjListCollection.LogisticsOrder,
      _ObjListCollection.OrderItem,
      _ObjListCollection.HandlingUnitExternalID,
      _ObjListCollection.PhysicalInventoryDocument,
      _ObjListCollection.PhysicalInventoryDocumentItem,
      _ObjListCollection.FiscalYear,
      _ObjListCollection.PurchaseOrder,
      _ObjListCollection.PurchaseOrderItem,
      _ObjListCollection.PurchaseRequisition,
      _ObjListCollection.PurchaseRequisitionItem,
      _ObjListCollection.InternalJITCallNumber,
      _ObjListCollection.JITCallItemNumber,
      _ObjListCollection.CompGrpNumber,
      _ObjListCollection.SerialNumberAssignmentDate,
      _ObjListCollection.SerialNumberAssignmentTime,
      _ObjListCollection.Customer,
      _ObjListCollection.CustomerName,
      _ObjListCollection.Supplier,
      _ObjListCollection.SupplierName,
      _ObjListCollection.NumberOfSerialNumbers,
      _ObjListCollection.SDDocumentCategory,
      _ObjListCollection.GoodsMovementType,
      _ObjListCollection.MovementTypeDescription,
      _ObjListCollection.SalesOrderType,
      _ObjListCollection.SalesDocumentTypeName,
      _ObjListCollection.SalesOrderItemCategory,
      _ObjListCollection.AccountingDocumentType,
      _ObjListCollection.AccountingDocumentTypeName,
      _ObjListCollection.Plant,
      _ObjListCollection.PlantName,
      _ObjListCollection.StorageLocation,
      _ObjListCollection.StorageLocationName,
      _ObjListCollection.Batch,
      _ObjListCollection.DebitCreditCode,
      _ObjListCollection.DebitCreditCodeName,
      _ObjListCollection.OrderCategory,
      _ObjListCollection.OrderType,
      _ObjListCollection.OrderTypeName,
      _ObjListCollection.OrderIsRefurbishmentOrder,
      _ObjListCollection.SerialNumberPhysicalInvtryType,
      _ObjListCollection.PhysicalInventoryStockType,
      _ObjListCollection.PhysicalInventoryStockTypeName,
      _ObjListCollection.PurchasingDocumentCategory,
      _ObjListCollection.PurchasingDocumentType,
      _ObjListCollection.PurchasingDocumentTypeName,
      _ObjListCollection.PurchasingDocumentItemCategory,
      _ObjListCollection.ExternalJITCallNumber,
      _ObjListCollection.ShipToParty,
      _ObjListCollection.BusinessPartnerName,
      _ObjListCollection.SubcontrgCompOfInbDelivItem,
      _ObjListCollection.SrlNmbrBizDocumentObjectType,


      _MatlSrlNmbrInfo,
      _ObjectTypeText
}
where MaintenanceObjectListUsageCode = 'S'

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTENANCEOBJECTLISTITEM",
"I_MAINTOBJECTLISTCOLLECTION"
],
"ASSOCIATED":
[
"I_MATLSERIALNUMBERINFORMATION",
"I_SRLNMBRBIZDOCOBJECTTYPETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More