I_LstMiMMGoodsIssue

DDL: I_LSTMIMMGOODSISSUE SQL: ILSTMIMMGI Type: view COMPOSITE

Last Mile Distribution MM Goods Issue

I_LstMiMMGoodsIssue is a Composite CDS View that provides data about "Last Mile Distribution MM Goods Issue" in SAP S/4HANA. It reads from 2 data sources (I_DeliveryDocument, I_MaterialDocumentHeader_2) and exposes 6 fields with key fields MaterialDocumentYear, MaterialDocument.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
I_DeliveryDocument I_DeliveryDocument inner
I_MaterialDocumentHeader_2 I_MaterialDocumentHeader_2 from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ILSTMIMMGI view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Last Mile Distribution MM Goods Issue view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY MaterialDocumentYear MaterialDocumentYear
KEY MaterialDocument MaterialDocument
OverallSDProcessStatus OverallSDProcessStatus
OverallGoodsMovementStatus OverallGoodsMovementStatus
DeliveryDocument I_MaterialDocumentHeader_2 DeliveryDocument
PrecedingDocumentCategory I_DeliveryDocument SDDocumentCategory 
@AbapCatalog.sqlViewName: 'ILSTMIMMGI'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@ObjectModel:   {   usageType:          { serviceQuality: #C,
                                          sizeCategory:   #XL,
                                          dataClass:      #TRANSACTIONAL}
                }
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Last Mile Distribution MM Goods Issue'
define view I_LstMiMMGoodsIssue
  as select from I_MaterialDocumentHeader_2
    inner join   I_DeliveryDocument on I_DeliveryDocument.DeliveryDocument = I_MaterialDocumentHeader_2.DeliveryDocument
{
  key  MaterialDocumentYear       as MaterialDocumentYear,
  key  MaterialDocument           as MaterialDocument,
       OverallSDProcessStatus     as OverallSDProcessStatus,
       OverallGoodsMovementStatus as OverallGoodsMovementStatus,
       I_MaterialDocumentHeader_2.DeliveryDocument as DeliveryDocument,
       I_DeliveryDocument.SDDocumentCategory as PrecedingDocumentCategory
       
}

Learn More