I_SERIALNUMBERMATERIALDOCUMENT

CDS View

Serial Number Material Documents

I_SERIALNUMBERMATERIALDOCUMENT is a CDS View in S/4HANA. Serial Number Material Documents. 3 CDS views read from this table.

Used by 3 CDS view(s)

CDS Views using this table (3)

ViewTypeJoinVDMDescription
A_SerialNumberMaterialDocument view from COMPOSITE Serial Numbers
I_MaterialDocumentSerialNumber view_entity from COMPOSITE Seial Numbers for Material Document
R_MaterialDocItemSerialNoTP view_entity from TRANSACTIONAL RAP Matdoc Serialnumbers 
@AbapCatalog.sqlViewName: 'ISERNOMATDOCS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl: { authorizationCheck: #CHECK,
                  personalData.blocking: #NOT_REQUIRED }

@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_LOCAL_API,
  lifecycle.status: #DEPRECATED,
  lifecycle.successor: 'I_SerialNumberMaterialDoc_2'
}

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

@EndUserText.label: 'Serial Number Material Documents'
@Metadata.ignorePropagatedAnnotations:true
define view I_SerialNumberMaterialDocument
  as select from I_MaintItmObjListMaterialDoc as _SerialMaterialDoc

    inner join   I_MaintenanceItemObject      as _MaintenanceItemObject on _SerialMaterialDoc.MaintenanceItemObjectList = _MaintenanceItemObject.MaintenanceItemObjectList

  association [0..1] to I_Product              as _Product              on  $projection.Material = _Product.Product  
  association [0..1] to I_Equipment            as _Equipment            on  $projection.Material     = _Equipment.Material
                                                                        and $projection.SerialNumber = _Equipment.SerialNumber                                                                      
  association [0..1] to I_MaterialDocumentItem as _MaterialDocumentItem on  $projection.MaterialDocument     = _MaterialDocumentItem.MaterialDocument
                                                                        and $projection.MaterialDocumentItem = _MaterialDocumentItem.MaterialDocumentItem
                                                                        and $projection.MaterialDocumentYear = _MaterialDocumentItem.MaterialDocumentYear

{
      @ObjectModel.foreignKey.association: '_Product'
  key Material,
  key SerialNumber,
  key MaterialDocument,
  key MaterialDocumentItem,
  key MaterialDocumentYear,

      Equipment,

      _Product,
      _Equipment,
      _MaterialDocumentItem
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTENANCEITEMOBJECT",
"I_MAINTITMOBJLISTMATERIALDOC"
],
"ASSOCIATED":
[
"I_EQUIPMENT",
"I_MATERIALDOCUMENTITEM",
"I_PRODUCT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More