P_DRFEWMBATCH

DDL: P_DRFEWMBATCH SQL: PDRFEWMBATCHOUT Type: view BASIC

P_DRFEWMBATCH is a Basic CDS View in SAP S/4HANA. It reads from 10 data sources and exposes 7 fields with key fields matnr, werks, charg, matnr, werks.

10 data source(s) 7 fields

Data Sources (10)

SourceAliasJoin Type
t340d ewm inner
t340d ewm inner
t320 lg inner
t320 lg inner
mch1 mch1 from
mcha mcha union_all
mard md inner
mard md inner
tcuch tcuch inner
tcuch tcuch inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PDRFEWMBATCHOUT view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view
VDM.private true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY matnr mch1 matnr
KEY werks
KEY charg mch1 charg
KEY matnr
KEY werks mcha werks
KEY charg mcha charg
KEY lgnum t320 lgnum 
@AbapCatalog.sqlViewName: 'PDRFEWMBATCHOUT'
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass:#MASTER

@VDM.viewType: #BASIC
@VDM.private: true
define view P_DRFEWMBATCH
  as select from mch1
    inner join   tcuch        on kzdch_old <> '0'
    inner join   mard  as md   on mch1.matnr = md.matnr
    inner join   t320  as lg   on  lg.lgort = md.lgort
                               and lg.werks = md.werks
    inner join   t340d as ewm on ewm.lgnum = lg.lgnum
{
  key mch1.matnr,
  key cast('    ' as werks_d preserving type) as werks,
  key mch1.charg,
  key lg.lgnum
}
where
  ewm.decsy = 'E'
group by
  mch1.matnr,
  mch1.charg,
  lg.lgnum

union all

select from  mcha
  inner join tcuch        on kzdch_old = '0'
  inner join mard  as md   on  mcha.matnr = md.matnr
                           and mcha.werks = md.werks
  inner join t320  as lg   on  lg.lgort = md.lgort
                           and lg.werks = md.werks
  inner join t340d as ewm on ewm.lgnum = lg.lgnum
{
  key mcha.matnr,
  key mcha.werks,
  key mcha.charg,
  key lg.lgnum
}
where
  ewm.decsy = 'E'
group by
  mcha.matnr,
  mcha.werks,
  mcha.charg,
  lg.lgnum
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MARD",
"MCH1",
"MCHA",
"T320",
"T340D",
"TCUCH"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More