ScmPrd_Matexec

@AbapCatalog.sqlViewName: 'SCMPRDMATEXEC'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Redirect for /SAPAPO/MATEXEC'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory : #L
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #AUTOMATED


define view ScmPrd_Matexec
  as select from mara
{

  //  mara.mandt,

  mara.scm_matid_guid22                                                  as matid,
  cast ( mara.pilferable as /scmb/de_pilferable )                        as pilferable,

  cast( cast ( mara.whmatgr as abap.char(4))      as /scmb/de_whmatgr )  as whmatgr,
  cast( cast ( mara.whstc as abap.char(2))        as /scmb/de_whstc )    as whstc,
  cast( cast ( mara.hndlcode as abap.char(4) )    as /scmb/de_hndlcode ) as hndlcode,

  cast( mara.kzumw as /scmb/de_envrel )                                  as envrel,

  cast( cast( mara.profl as abap.char(3)) as /scmb/de_dgprofl )          as dgprofl,

  cast ( mara.hazmat as /scmb/de_hazmat )                                as hazmat,

  cast( cast( mara.mtpos_mara as abap.char(4)) as /scmb/de_itmtpg )      as itmtpg,
  cast( cast ( mara.mfrgr as  abap.char(8)) as /scmb/de_mfrgr )          as mfrgr,

  cast ( mara.qqtime as /scwm/de_qqtime )                                as qqtime,
  cast ( mara.qqtimeuom as /scwm/de_qqtimeuom )                          as qqtimeuom,

  cast( cast ( mara.qgrp as abap.char(4)) as /scwm/de_qgrp )             as qgrp,

  cast( cast( mara.cwqtolgr as abap.char(9)) as /scwm/de_cwtolgr )       as cwtolgr,
  cast( cast( mara.cwqproc as abap.char(2)) as /scwm/de_cwproc )         as cwproc,
  cast( cast( mara.adprof as abap.char(3)) as /scwm/de_medi_aprof )      as medi_aprof,

  mara.scm_puom                                                          as puom,

  cast( '' as klasse_d )                                                 as class,
  cast( '' as klassenart )                                               as klart,
  cast( '' as /scmb/de_plant_batch_handling )                            as plant_batch_handling

}

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MARA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/