I_JITOutbCallDelivDocRef

DDL: I_JITOUTBCALLDELIVDOCREF SQL: IJITODELVDOC Type: view COMPOSITE

Material Document Reference for Delivery

I_JITOutbCallDelivDocRef is a Composite CDS View that provides data about "Material Document Reference for Delivery" in SAP S/4HANA. It reads from 3 data sources (I_DeliveryDocumentItem, I_JITOutbCallCompDocRef, I_SDDocumentMultiLevelProcFlow) and exposes 4 fields with key fields DeliveryDocument, DeliveryDocumentItem.

3 data source(s) 4 fields

Data Sources (3)

SourceAliasJoin Type
I_DeliveryDocumentItem _DeliveryDocumentItem inner
I_JITOutbCallCompDocRef _NjitDoCumentReference inner
I_SDDocumentMultiLevelProcFlow _SDDocumentMultiLevelProcFlow from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IJITODELVDOC view
AbapCatalog.compiler.compareFilter true view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Material Document Reference for Delivery view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY DeliveryDocument I_SDDocumentMultiLevelProcFlow PrecedingDocument
KEY DeliveryDocumentItem I_SDDocumentMultiLevelProcFlow PrecedingDocumentItem
MaterialDocument
MaterialDocumentYear I_SDDocumentMultiLevelProcFlow MaterialDocumentYear 
@AbapCatalog.sqlViewName: 'IJITODELVDOC'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling:{
     type: #INHERITED,
     algorithm: #SESSION_VARIABLE
   }
@ObjectModel: {
    usageType.dataClass: #TRANSACTIONAL,
    usageType.serviceQuality: #C,
    usageType.sizeCategory: #XL
}
@VDM: {
    viewType: #COMPOSITE
}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Material Document Reference for Delivery'

define view I_JITOutbCallDelivDocRef
  as select from    I_SDDocumentMultiLevelProcFlow as _SDDocumentMultiLevelProcFlow
    inner join      I_JITOutbCallCompDocRef        as _NjitDoCumentReference on(
      _SDDocumentMultiLevelProcFlow.PrecedingDocument         = _NjitDoCumentReference.BusinessTransactionDocument
      and _SDDocumentMultiLevelProcFlow.PrecedingDocumentItem = _NjitDoCumentReference.BusinessTransactionDocItem
      and _NjitDoCumentReference.BusinessTransactionDocStatus = '1'
      and _NjitDoCumentReference.BusinessTransactionDocType   = 'I'
    )
    inner join      I_DeliveryDocumentItem         as _DeliveryDocumentItem  on(
       _SDDocumentMultiLevelProcFlow.PrecedingDocument         = _DeliveryDocumentItem.DeliveryDocument
       and _SDDocumentMultiLevelProcFlow.PrecedingDocumentItem = _DeliveryDocumentItem.DeliveryDocumentItem
       and ( _DeliveryDocumentItem.GoodsMovementStatus           = 'C' or
             _DeliveryDocumentItem.GoodsMovementStatus           = 'B' )
     )
{
  key _SDDocumentMultiLevelProcFlow.PrecedingDocument       as DeliveryDocument,
  key _SDDocumentMultiLevelProcFlow.PrecedingDocumentItem   as DeliveryDocumentItem,
      max(_SDDocumentMultiLevelProcFlow.SubsequentDocument) as MaterialDocument,
      _SDDocumentMultiLevelProcFlow.MaterialDocumentYear    as MaterialDocumentYear
}
where
      _SDDocumentMultiLevelProcFlow.PrecedingDocumentCategory = '7'
  and _SDDocumentMultiLevelProcFlow.MaterialDocumentYear      is not initial
group by
  _SDDocumentMultiLevelProcFlow.PrecedingDocument,
  _SDDocumentMultiLevelProcFlow.PrecedingDocumentItem,
  _SDDocumentMultiLevelProcFlow.MaterialDocumentYear

Learn More