C_MaintOrderUnplannedMat

DDL: C_MAINTORDERUNPLANNEDMAT SQL: CMAINTORDUNPLMAT Type: view CONSUMPTION

Maintenance Order Unplanned material

C_MaintOrderUnplannedMat is a Consumption CDS View that provides data about "Maintenance Order Unplanned material" in SAP S/4HANA. It reads from 1 data source (I_MaterialDocumentRecord) and exposes 14 fields with key fields MaterialDocument, MaterialDocumentItem, MaterialDocumentYear. It has 1 association to related views.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
I_MaterialDocumentRecord I_MaterialDocumentRecord from

Associations (1)

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

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName CMAINTORDUNPLMAT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Maintenance Order Unplanned material view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY MaterialDocument I_MaterialDocumentRecord MaterialDocument
KEY MaterialDocumentItem I_MaterialDocumentRecord MaterialDocumentItem
KEY MaterialDocumentYear I_MaterialDocumentRecord MaterialDocumentYear
Material I_MaterialDocumentRecord Material
StockIdentifyingMaterial I_MaterialDocumentRecord StockIdentifyingMaterial
WBSElementInternalID I_MaterialDocumentRecord WBSElementInternalID
GoodsMovementType I_MaterialDocumentRecord GoodsMovementType
QuantityInBaseUnit I_MaterialDocumentRecord QuantityInBaseUnit
MaterialBaseUnit I_MaterialDocumentRecord MaterialBaseUnit
MaintenanceOrder I_MaterialDocumentRecord OrderID
Reservation I_MaterialDocumentRecord Reservation
_Material I_MaterialDocumentRecord _Material
_MaterialBaseUnit I_MaterialDocumentRecord _MaterialBaseUnit
ForDCL_MaintenanceOrder 
@AbapCatalog.sqlViewName: 'CMAINTORDUNPLMAT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@EndUserText.label: 'Maintenance Order Unplanned material'

define view C_MaintOrderUnplannedMat
  as select from I_MaterialDocumentRecord
  association [0..1] to I_MaintenanceOrder as _MaintenanceOrder on _MaintenanceOrder.MaintenanceOrder = $projection.MaintenanceOrder
{
  key I_MaterialDocumentRecord.MaterialDocument,
  key I_MaterialDocumentRecord.MaterialDocumentItem,
  key I_MaterialDocumentRecord.MaterialDocumentYear,
      I_MaterialDocumentRecord.Material,
      I_MaterialDocumentRecord.StockIdentifyingMaterial,
      I_MaterialDocumentRecord.WBSElementInternalID,
      I_MaterialDocumentRecord.GoodsMovementType,
      @UI.lineItem: [ { position: 10 } ]
      I_MaterialDocumentRecord.QuantityInBaseUnit,
      I_MaterialDocumentRecord.MaterialBaseUnit,
      //I_MaterialDocumentRecord.ManufacturingOrder as MaintenanceOrder,

      I_MaterialDocumentRecord.OrderID as MaintenanceOrder,
      I_MaterialDocumentRecord.Reservation,
      I_MaterialDocumentRecord._Material,
      I_MaterialDocumentRecord._MaterialBaseUnit,

      -- For DCL:
      _MaintenanceOrder
}
where
      I_MaterialDocumentRecord.Reservation                =  '0000000000'
  and I_MaterialDocumentRecord.OrderID                    <> ''
  and _MaintenanceOrder.MaintenanceOrderCategory          =  '30'
  and I_MaterialDocumentRecord.MaterialDocumentRecordType <> 'MDOC_CP' --duplicate keys from complementary booking
-- For DCL (moved into DCL)
--  and _MaintenanceOrder.MaintenanceOrder is not null;
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTENANCEORDER",
"I_MATERIALDOCUMENTRECORD"
],
"ASSOCIATED":
[
"I_MAINTENANCEORDER",
"I_MATERIAL",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_MATERIALDOCUMENTRECORD"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More