I_MatDocOvwItmSerialNumber

DDL: I_MATDOCOVWITMSERIALNUMBER Type: view_entity COMPOSITE

Serial Number for Material Document Item

I_MatDocOvwItmSerialNumber is a Composite CDS View that provides data about "Serial Number for Material Document Item" in SAP S/4HANA. It reads from 1 data source (I_MaterialDocumentSerialNumber) and exposes 10 fields with key fields Material, SerialNumber, MaterialDocument, MaterialDocumentItem, MaterialDocumentYear. It has 1 association to related views.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
I_MaterialDocumentSerialNumber I_MaterialDocumentSerialNumber from

Associations (1)

CardinalityTargetAliasCondition
[1..1] F_Mmim_Matdoc_Item _Item $projection.MaterialDocument = _Item.MaterialDocument and $projection.MaterialDocumentItem = _Item.MaterialDocumentItem and $projection.MaterialDocumentYear = _Item.MaterialDocumentYear

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Serial Number for Material Document Item view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view
UI.headerInfo.typeName Serial Number Details view
UI.headerInfo.typeNamePlural Serial Number Details view
VDM.viewType #COMPOSITE view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Material Material
KEY SerialNumber SerialNumber
KEY MaterialDocument MaterialDocument
KEY MaterialDocumentItem MaterialDocumentItem Material Document Item
KEY MaterialDocumentYear MaterialDocumentYear
Equipment Equipment
MaterialName MaterialName
PhysicalInventoryDocumentItem PhysicalInventoryDocumentItem
_Product _Product
_Item _Item 
// This CDS View is intended to fetch the serial numbers for the Material Document Item

// It is open for any further improvements/additions


// NOTE: This CDS view should never be release to PUBLIC state as it has an association to F_Mmim_Matdoc_Item.


@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Serial Number for Material Document Item'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
    serviceQuality: #X,
    sizeCategory: #S,
    dataClass: #MIXED
}
@Search.searchable: true
@UI.headerInfo:{
                typeName: 'Serial Number Details',
                typeNamePlural: 'Serial Number Details'
               }
@VDM.viewType: #COMPOSITE

define view entity I_MatDocOvwItmSerialNumber

  as select from I_MaterialDocumentSerialNumber
  association [1..1] to F_Mmim_Matdoc_Item as _Item on  $projection.MaterialDocument     = _Item.MaterialDocument
                                                    and $projection.MaterialDocumentItem = _Item.MaterialDocumentItem
                                                    and $projection.MaterialDocumentYear = _Item.MaterialDocumentYear

{
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.7
      @ObjectModel.text.element: ['MaterialName']
  key Material,
      @UI.lineItem: [ { position: 10, importance: #HIGH } ]
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
  key SerialNumber,
      @UI.hidden: true
  key MaterialDocument,
      @Search.fuzzinessThreshold: 0.7
      @EndUserText.label: 'Material Document Item'
  key MaterialDocumentItem,
      @UI.hidden: true
  key MaterialDocumentYear,
      @Consumption.hidden: true
      Equipment,
      @UI.hidden: true
      @Semantics.text: true
      MaterialName,
      @UI.hidden: true
      PhysicalInventoryDocumentItem,
//      @UI.lineItem: [{ position: 20,

//                       importance: #HIGH,

//                       hidden: #(_Item.UICT_MatDocHasNoSrlNmbrForPInv)

//                    }]

//      @EndUserText.label: 'In Book'

//      SerialNumberIsInBooks,

//      @UI.lineItem: [{hidden: #(_Item.UICT_MatDocHasNoSrlNmbrForPInv), position: 30, importance: #HIGH }]

//      @EndUserText.label: 'In Stock'

//      SerialNumberIsCounted,


      /* Associations */
      @Consumption.hidden: true
      _Product,
      _Item

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MATERIALDOCUMENTSERIALNUMBER"
],
"ASSOCIATED":
[
"F_MMIM_MATDOC_ITEM",
"I_PRODUCT"
],
"BASE":
[
"I_MATERIALDOCUMENTSERIALNUMBER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More