SBN_DRF_PI_DETAILS

@AbapCatalog.sqlViewName: 'SBN_PI_DETAIL'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory:#L
@ObjectModel.usageType.dataClass:#MASTER
@EndUserText.label: 'Get PI details'
define view SBN_DRF_PI_DETAILS as select from packkp as p
inner join packpo as o
   on p.packnr = o.packnr
left outer join mara as m
 on o.matnr = m.matnr
left outer join makt as t
   on o.matnr = t.matnr
  and t.spras = $session.system_language
//left outer join tvty as y

//on m.vhart = y.traty 

left outer join packkp as sp
on o.subpacknr = sp.packnr
    {
  p.packnr as id,
  o.packitem,
  p.packnr as packnr,
  p.hdcount as hdcount,
  p.pobjid,
  case p.chdat
  when '00000000' then p.crdat
  else p.chdat
  end as chdat,
  p.chtim,
  o.paitemtype,
  case o.paitemtype
    when 'I' then
      case o.matnr
      when '' then 'I'
      else 'M'
      end 
    when 'R' then 'R'
    when 'P' then 'P'
    when 'S' then ''
    when 'T' then 'T'
    else ''
  end as packdetail,
  o.matnr,
  t.maktx,
  sp.pobjid as sub_packinstrid,
  o.trgqty,
  o.minqty,
  o.rndqty,
  o.unitqty,
  o.matmixawd,
  o.indnohu,
  case p.inddel
     when 'X' then 'X'
     else o.inddel
  end as inddel,
 '' as is_aux,
  m.vhart,
  m.laeng,
  m.breit,
  m.hoehe,
  m.volum,
  m.ntgew,
  m.brgew,
  m.meabm,
  m.voleh,
  m.gewei,
  o.subpacknr
  } where o.inddel = '' 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MAKT",
"MARA",
"PACKKP",
"PACKPO"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/