I_MaintOrderGoodsMovement

DDL: I_MAINTORDERGOODSMOVEMENT SQL: IMAINTORDGDSM Type: view BASIC

Maintenance Order Goods Movement

I_MaintOrderGoodsMovement is a Basic CDS View that provides data about "Maintenance Order Goods Movement" in SAP S/4HANA. It reads from 1 data source (aufm) and exposes 10 fields with key fields MaterialDocument, MaterialDocumentItem, MaterialDocumentYear. It has 2 associations to related views.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
aufm aufm from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_MaintenanceOrder _MaintenanceOrder $projection.MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder
[0..1] I_Material _Material $projection.Material = _Material.Material

Annotations (8)

NameValueLevelField
EndUserText.label Maintenance Order Goods Movement view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName IMAINTORDGDSM view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY MaterialDocument aufm mblnr
KEY MaterialDocumentItem aufm zeile
KEY MaterialDocumentYear aufm mjahr
DocumentDate aufm bldat
MaintenanceOrder aufm aufnr
Material aufm matnr
Plant aufm werks
StorageLocation aufm lgort
_MaintenanceOrder _MaintenanceOrder
_Material _Material 
@EndUserText.label: 'Maintenance Order Goods Movement'
@VDM.viewType: #BASIC

@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.sqlViewName: 'IMAINTORDGDSM'

@ClientHandling.algorithm: #SESSION_VARIABLE

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


define view I_MaintOrderGoodsMovement
  as select from aufm
  association [0..1] to I_MaintenanceOrder as _MaintenanceOrder on $projection.MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder
  association [0..1] to I_Material         as _Material         on $projection.Material = _Material.Material
{
  key aufm.mblnr as MaterialDocument,
  key aufm.zeile as MaterialDocumentItem,
  key aufm.mjahr as MaterialDocumentYear,

  aufm.bldat as DocumentDate,
  aufm.aufnr as MaintenanceOrder,
  aufm.matnr as Material,
  // aufm.rsnum as Reservation, -- unused


  aufm.werks as Plant,
  aufm.lgort as StorageLocation,


  _MaintenanceOrder,
  _Material
} 
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"AUFM"
],
"ASSOCIATED":
[
"I_MAINTENANCEORDER",
"I_MATERIAL"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More