I_PPS_GoodsMovementProcessFlow

DDL: I_PPS_GOODSMOVEMENTPROCESSFLOW SQL: IPPSGDSMNTPF Type: view BASIC

Goods Movement Documents For XPO History

I_PPS_GoodsMovementProcessFlow is a Basic CDS View that provides data about "Goods Movement Documents For XPO History" in SAP S/4HANA. It reads from 1 data source (ekbe) and exposes 9 fields with key fields MaterialDocument, MaterialDocumentYear, MaterialDocumentItem.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
ekbe GoodsMovement from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPPSGDSMNTPF view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Goods Movement Documents For XPO History view
VDM.viewType #BASIC view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY MaterialDocument ekbe belnr
KEY MaterialDocumentYear ekbe gjahr
KEY MaterialDocumentItem ekbe buzei
CompanyCode
PPSAmtWthCrcyAsText
Currency ekbe waers
PPSQuantityWithUnitAsText
MaterialBaseUnit MaterialDocument meins
IsCancelled MaterialDocument cancelled 
@AbapCatalog.sqlViewName: 'IPPSGDSMNTPF'
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.compiler.compareFilter:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #TRANSACTIONAL }
@EndUserText.label: 'Goods Movement Documents For XPO History'
@VDM.viewType: #BASIC 
define view I_PPS_GoodsMovementProcessFlow
  as select from           ekbe   as GoodsMovement
    left outer to one join matdoc as MaterialDocument on  MaterialDocument.mblnr = GoodsMovement.belnr
                                                      and MaterialDocument.mjahr = GoodsMovement.gjahr
                                                      and MaterialDocument.zeile = GoodsMovement.buzei

{
  key GoodsMovement.belnr                                                                                               as MaterialDocument,
  key GoodsMovement.gjahr                                                                                               as MaterialDocumentYear,
  key GoodsMovement.buzei                                                                                               as MaterialDocumentItem,
      cast(MaterialDocument.mjahr    as bukrs)                                                                          as CompanyCode,
      cast(concat_with_space(cast( GoodsMovement.dmbtr as abap.char(20)), GoodsMovement.waers , 1) as abap.char(30))    as PPSAmtWthCrcyAsText,
      GoodsMovement.waers                                                                                               as Currency,
      cast(concat_with_space(cast( GoodsMovement.menge as abap.char(20)), MaterialDocument.meins , 1) as abap.char(30)) as PPSQuantityWithUnitAsText,
      MaterialDocument.meins                                                                                            as MaterialBaseUnit,
      MaterialDocument.cancelled                                                                                        as IsCancelled



}
where
  GoodsMovement.bewtp = 'E'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EKBE",
"MATDOC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More