e_mrp_pre_stocktransf_demands

@AbapCatalog.sqlViewName: 'V_MRP_PRE_TRANSF'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #P} /*sizeCategory: #XL, dataClass: #MIXED*/
define view e_mrp_pre_stocktransf_demands as
  select from v_mrp_plan_segments as seg
    inner join pph_cache_mat mat
      on seg.mandt    = mat.mandt and
         seg.mrpplant = mat.mrpplant and
         seg.material = mat.material and
         seg.mrparea  = mat.mrparea
    left outer join pph_cache_item as sdi
      on seg.mandt    = sdi.mandt and
         seg.mrpplant = sdi.mrpplant and
         seg.material = sdi.material and
         seg.mrparea  = sdi.mrparea and
         seg.mrpplanningsegmenttype   = sdi.mrpplanningsegmenttype and
         seg.mrpplanningsegmentnumber = sdi.mrpplanningsegmentnumber and
         seg.materialshortageprofile  = sdi.materialshortageprofile and
       ( sdi.mrpelementcategory = 'U1' or
         sdi.mrpelementcategory = 'U2' or
         sdi.mrpelementcategory = 'U3' or
         sdi.mrpelementcategory = 'U4' )
    left outer join v_mrp_currency as cur
      on seg.mandt    = cur.mandt and
         seg.mrpplant = cur.plant
    left outer join t006 as uom
      on mat.mandt            = uom.mandt and
         mat.materialbaseunit = uom.msehi
  {   seg.mandt,
      seg.mrpplanningsegmenttype,
      seg.mrpplanningsegmentnumber,
      seg.mrpplanningsegmentID,
      seg.mrpplanningsegmentitem,
      mat.material,
      mat.mrparea,
      mat.mrpplant,
      mat.mrpcontroller,
      mat.materialprocurementcategory,
      mat.materialsafetystockqty,
      mat.materialbaseunit,
      uom.andec as quantityprecision,
      uom.decan as targetquantityunitdisplaydcmls,
      mat.materialreplnmtleaddurnenddate,
      mat.totalreplnmtleaddurnenddate,
      mat.manualplanninghorizonenddate,
      mat.mrpsafetydurationenddate,
      sdi.mrpelementcategory,
      sdi.mrpelement,
      sdi.mrpelementitem,
      substring(sdi.mrpelementitem, 2, 5) as mrpelementitem5,
      sdi.mrpelementscheduleline,
      sdi.materialshortageprofile,
      sdi.materialshortageprof_cnt,
      sdi.mrpelementavailyorrqmtdate,
      sdi.mrpelementopenquantity,
      sdi.sourcemrpelementcategory,
      sdi.sourcemrpelement,
      sdi.sourcemrpelementitem,
      sdi.mrpelementuncoveredquantity,
      sdi.mrpelementdelayedquantity,
      sdi.mrpelementtypeimportance,
      sdi.maximumdelaydate as maximumdelay,
      sdi.maximumdelayindays,
      sdi.maximumdelayinworkdays,
      sdi.procurementprogressindicator,
      sdi.storagelocation,
      sdi.issuingorreceivingplant as customer,
      cur.companycodecurrency,
      cur.targetcurrencydecimals as companycodecurrencydcmls
  };

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"V_MRP_PLAN_SEGMENTS",
"PPH_CACHE_ITEM",
"PPH_CACHE_MAT",
"T006",
"V_MRP_CURRENCY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/