P_MaterialDocumentMigration

DDL: P_MATERIALDOCUMENTMIGRATION SQL: PMMMATDOCMIG Type: view CONSUMPTION Package: ODATA_MM_ANALYTICS

Material Document for Migration

P_MaterialDocumentMigration is a Consumption CDS View that provides data about "Material Document for Migration" in SAP S/4HANA. It reads from 2 data sources (I_GoodsMovementType, I_MaterialDocumentRecord) and exposes 9 fields with key fields MaterialDocument, MaterialDocumentItem, MaterialDocumentYear. Part of development package ODATA_MM_ANALYTICS.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
I_GoodsMovementType GoodsMovement inner
I_MaterialDocumentRecord MatDoc from

Parameters (1)

NameTypeDefault
P_PurchaseOrder ebeln

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PMMMATDOCMIG view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
VDM.private true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Material Document for Migration view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY MaterialDocument MaterialDocument
KEY MaterialDocumentItem MaterialDocumentItem
KEY MaterialDocumentYear MaterialDocumentYear
PurchaseOrder PurchaseOrder
PurchaseOrderItem PurchaseOrderItem
QuantityInBaseUnit QuantityInBaseUnit
GoodsReceiptQtyInOrderUnit GoodsReceiptQtyInOrderUnit
PostingDate PostingDate
IsReversalMovementType I_MaterialDocumentRecord IsReversalMovementType 
@AbapCatalog.sqlViewName: 'PMMMATDOCMIG'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter: true
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Material Document for Migration'
define view P_MaterialDocumentMigration
  with parameters
    P_PurchaseOrder : ebeln
  as select from I_MaterialDocumentRecord as MatDoc
    inner join   I_GoodsMovementType      as GoodsMovement on  BasicMovementTypeReference      = '101'
                                                           and GoodsMovement.GoodsMovementType = MatDoc.GoodsMovementType

{
  key  MaterialDocument,
  key  MaterialDocumentItem,
  key  MaterialDocumentYear,
       PurchaseOrder,
       PurchaseOrderItem,
       QuantityInBaseUnit,
       GoodsReceiptQtyInOrderUnit,
       PostingDate,
       case MatDoc.DebitCreditCode
          when 'S' then 1
          when 'H' then -1
          else 0
       end as DebitCreditCode,
       MatDoc.IsReversalMovementType
}
where
       PurchaseOrder                 = $parameters.P_PurchaseOrder
  and  GoodsMovementIsCancelled      = ''
  and(
       GoodsMovementCancellationType = ''
    or GoodsMovementCancellationType = '1'
  )

Learn More