I_MAINTOBJLISTMATERIALDOCUMENT

CDS View

Maint Object List in Material Document

I_MAINTOBJLISTMATERIALDOCUMENT is a CDS View in S/4HANA. Maint Object List in Material Document. It contains 6 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 6 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_MaintObjectListCollection view_entity union_all COMPOSITE Maintenance Object List Collection
I_SerialNumberMaterialDoc_2 view_entity from COMPOSITE Serial Number in Material Document

Fields (6)

KeyField CDS FieldsUsed in Views
KEY MaterialDocument MaterialDocument 1
KEY MaterialDocumentItem MaterialDocumentItem 1
KEY MaterialDocumentYear MaterialDocumentYear 1
_MaterialDocument _MaterialDocument 1
_MaterialDocumentItem _MaterialDocumentItem 1
_MaterialDocumentYear _MaterialDocumentYear 1 
@AccessControl: { authorizationCheck: #CHECK,
                  personalData.blocking: #NOT_REQUIRED }

@VDM.viewType: #BASIC

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

@EndUserText.label: 'Maint Object List in Material Document'
define view entity I_MaintObjListMaterialDocument
  as select from ser03

  association [1..*] to I_MaintenanceObjectListItem as _MaintenanceObjectListItem
    on $projection.MaintenanceObjectList = _MaintenanceObjectListItem.MaintenanceObjectList
  association [0..1] to I_MaterialDocumentYear as _MaterialDocumentYear
    on $projection.MaterialDocumentYear = _MaterialDocumentYear.MaterialDocumentYear
  association [0..1] to I_MaterialDocumentHeader_2 as _MaterialDocument
    on $projection.MaterialDocumentYear = _MaterialDocument.MaterialDocumentYear
    and $projection.MaterialDocument = _MaterialDocument.MaterialDocument
  association [0..1] to I_MaterialDocumentItem_2 as _MaterialDocumentItem
    on $projection.MaterialDocumentYear = _MaterialDocumentItem.MaterialDocumentYear
    and $projection.MaterialDocument = _MaterialDocumentItem.MaterialDocument
    and $projection.MaterialDocumentItem = _MaterialDocumentItem.MaterialDocumentItem
{
  key obknr as MaintenanceObjectList,

  @ObjectModel.foreignKey.association: '_MaterialDocumentYear'
  cast(mjahr as nsdm_mjahr preserving type) as MaterialDocumentYear,
  @ObjectModel.foreignKey.association: '_MaterialDocument'
  mblnr as MaterialDocument,
  @ObjectModel.foreignKey.association: '_MaterialDocumentItem'
  cast(zeile as nsdm_mblpo preserving type) as MaterialDocumentItem,
  
  blart     as AccountingDocumentType,
  bwart     as GoodsMovementType,
  shkzg     as DebitCreditCode,
  datum     as SerialNumberAssignmentDate,
  uzeit     as SerialNumberAssignmentTime,
  anzsn     as NumberOfSerialNumbers,
  lieferant as Supplier,
  kunde     as Customer,
  werk      as Plant,
  lagerort  as StorageLocation,
  charge    as Batch,

  _MaintenanceObjectListItem,
  _MaterialDocumentYear,
  _MaterialDocument,
  _MaterialDocumentItem
}

Learn More