CIC_MaterialDocumentData

DDL: CIC_MATERIALDOCUMENTDATA Type: view_entity

Proj. View on Material Document

CIC_MaterialDocumentData is a CDS View that provides data about "Proj. View on Material Document" in SAP S/4HANA. It reads from 1 data source (CIC_PLANT_BASIC) and exposes 8 fields with key fields MaterialDocument, MaterialDocumentYear.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
CIC_PLANT_BASIC _plant inner

Annotations (6)

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

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY MaterialDocument _header MaterialDocument
KEY MaterialDocumentYear _header MaterialDocumentYear
DocumentDate _header DocumentDate
PostingDate _header PostingDate
MaterialDocumentHeaderText _header MaterialDocumentHeaderText
ReferenceDocument _header InvtryMgmtReferenceDocument
TransactionCode _header TransactionCode
InventoryTransactionType _header InventoryTransactionType 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Proj. View on Material Document'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #B,
  sizeCategory: #XXL,
  dataClass: #TRANSACTIONAL
}
define view entity CIC_MaterialDocumentData
as select distinct from I_MaterialDocumentRecord as _header
inner join CIC_PLANT_BASIC as _plant on _plant.werks = _header.Plant and _plant.vlfkz = 'B'
//inner join CIC_MaterialDocumentItemData as _item on _item.MaterialDocumentYear = _header.MaterialDocumentYear

//                                        and _item.MaterialDocument = _header.MaterialDocument

{

  key _header.MaterialDocument,
  key _header.MaterialDocumentYear,
  _header.DocumentDate,
  _header.PostingDate,
  _header.MaterialDocumentHeaderText,
  _header.InvtryMgmtReferenceDocument as ReferenceDocument,
  _header.TransactionCode,
  _header.InventoryTransactionType
}
where
      _header.MaterialDocumentRecordType = 'MDOC'
  and _header.IsMaterialDocumentHeader   = 1

Learn More