I_MAINTITMOBJLISTMATERIALDOC

CDS View

Maintenance Item Object List Material Document

I_MAINTITMOBJLISTMATERIALDOC is a CDS View in S/4HANA. Maintenance Item Object List Material Document. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_MaterialDocumentSerialNoFDP view from CONSUMPTION Material Document Serial Numbers Output Forms
I_SerialNumberMaterialDocument view from COMPOSITE Serial Number Material Documents 
@AbapCatalog.sqlViewName: 'IMIOLNOMATDOC'
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY // never expose this view directly, only via associations

@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Maintenance Item Object List Material Document'
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL

@VDM: {
  viewType: #BASIC,
  lifecycle.status: #DEPRECATED,
  lifecycle.successor: 'I_MaintObjListMaterialDocument'
}
define view I_MaintItmObjListMaterialDoc
  as select from ser03

  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 MaintenanceItemObjectList,

      cast( mjahr as nsdm_mjahr preserving type) as MaterialDocumentYear,
      mblnr                                      as MaterialDocument,
      cast( zeile as nsdm_mblpo preserving type) as MaterialDocumentItem,

      shkzg                                      as DebitCreditCode,
      datum                                      as DocumentDate,

      _MaterialDocumentYear,
      _MaterialDocument,
      _MaterialDocumentItem
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SER03"
],
"ASSOCIATED":
[
"I_MATERIALDOCUMENTHEADER_2",
"I_MATERIALDOCUMENTITEM_2",
"I_MATERIALDOCUMENTYEAR"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More