CIC_MaterialDocumentItemData

DDL: CIC_MATERIALDOCUMENTITEMDATA Type: view_entity

Proj. View on Material Document Item

CIC_MaterialDocumentItemData is a CDS View that provides data about "Proj. View on Material Document Item" in SAP S/4HANA. It reads from 2 data sources (I_MaterialDocumentRecord, CIC_PLANT) and exposes 26 fields with key fields MaterialDocument, MaterialDocumentYear, MaterialDocumentItem.

2 data source(s) 26 fields

Data Sources (2)

SourceAliasJoin Type
I_MaterialDocumentRecord _item from
CIC_PLANT _plant inner

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Proj. View on Material Document Item view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY MaterialDocument I_MaterialDocumentRecord MaterialDocument
KEY MaterialDocumentYear I_MaterialDocumentRecord MaterialDocumentYear
KEY MaterialDocumentItem I_MaterialDocumentRecord MaterialDocumentItem
StockIdentifyingMaterial I_MaterialDocumentRecord StockIdentifyingMaterial
StorageLocation I_MaterialDocumentRecord StorageLocation
Plant I_MaterialDocumentRecord Plant
InventoryStockType I_MaterialDocumentRecord InventoryStockType
InventorySpecialStockType I_MaterialDocumentRecord InventorySpecialStockType
MaterialDocumentItemText I_MaterialDocumentRecord MaterialDocumentItemText
GoodsMovementType I_MaterialDocumentRecord GoodsMovementType
GoodsMovementRefDocType I_MaterialDocumentRecord GoodsMovementRefDocType
QuantityInBaseUnit I_MaterialDocumentRecord QuantityInBaseUnit
MaterialBaseUnit I_MaterialDocumentRecord MaterialBaseUnit
QuantityInEntryUnit I_MaterialDocumentRecord QuantityInEntryUnit
EntryUnit I_MaterialDocumentRecord EntryUnit
IsCompletelyDelivered I_MaterialDocumentRecord IsCompletelyDelivered
GoodsMovementIsCancelled I_MaterialDocumentRecord GoodsMovementIsCancelled
IssgOrRcvgMaterial I_MaterialDocumentRecord IssgOrRcvgMaterial
IssuingOrReceivingPlant I_MaterialDocumentRecord IssuingOrReceivingPlant
IssuingOrReceivingStorageLoc I_MaterialDocumentRecord IssuingOrReceivingStorageLoc
IssuingOrReceivingStockType I_MaterialDocumentRecord IssuingOrReceivingStockType
IssgOrRcvgSpclStockInd I_MaterialDocumentRecord IssgOrRcvgSpclStockInd
MaterialDocumentParentLine I_MaterialDocumentRecord MaterialDocumentParentLine
GoodsMovementReasonCode I_MaterialDocumentRecord GoodsMovementReasonCode
ShelfLifeExpirationDate I_MaterialDocumentRecord ShelfLifeExpirationDate
IsAutomaticallyCreated I_MaterialDocumentRecord IsAutomaticallyCreated 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Proj. View on Material Document Item'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #B,
  sizeCategory: #XXL,
  dataClass: #TRANSACTIONAL
}
define view entity CIC_MaterialDocumentItemData
  as select from I_MaterialDocumentRecord as _item
inner join CIC_PLANT as _plant on _plant.werks = _item.Plant and _plant.vlfkz = 'B' 
{
  key _item.MaterialDocument,
  key _item.MaterialDocumentYear,
  key _item.MaterialDocumentItem,
      _item.StockIdentifyingMaterial, //matbf

      _item.StorageLocation,
      _item.Plant,
      _item.InventoryStockType,
      _item.InventorySpecialStockType,
      _item.MaterialDocumentItemText,
      _item.GoodsMovementType,
      _item.GoodsMovementRefDocType,
      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      _item.QuantityInBaseUnit,
      _item.MaterialBaseUnit,
      @Semantics.quantity.unitOfMeasure: 'EntryUnit'
      _item.QuantityInEntryUnit,
      _item.EntryUnit,
//      _item.CompanyCodeCurrency,

//      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'

//      _item.GdsMvtExtAmtInCoCodeCrcy,

//      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'

//      _item.SlsPrcAmtInclVATInCoCodeCrcy, //vkwrt

//      _item.ReservationIsFinallyIssued,

      _item.IsCompletelyDelivered,
      _item.GoodsMovementIsCancelled,
//      _item.ReversedMaterialDocument,

//      _item.ReversedMaterialDocumentItem,

      _item.IssgOrRcvgMaterial, //ummat

      _item.IssuingOrReceivingPlant, 
      _item.IssuingOrReceivingStorageLoc, //plant id needs to be checked

      _item.IssuingOrReceivingStockType, //lbbsa_cis

      _item.IssgOrRcvgSpclStockInd,
      _item.MaterialDocumentParentLine, //parent_id

      _item.GoodsMovementReasonCode, //grund

      _item.ShelfLifeExpirationDate, //vfdat

      _item.IsAutomaticallyCreated //xauto



}
where
  _item.MaterialDocumentRecordType = 'MDOC'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CIC_PLANT",
"I_MATERIALDOCUMENTRECORD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More