P_ProcOrdOpReservationItem

@AbapCatalog.sqlViewName: 'PPOROPRESITM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
//@EndUserText.label: 'Process Order Reservation Item'

@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #BASIC
define view P_ProcOrdOpReservationItem
  as select from           resb  as resb
    left outer to one join caufv as aufv on aufv.aufnr = resb.aufnr
    
{
      // Key

  key resb.rsnum,
  key resb.rspos,
  key resb.rsart,

      //Material data

      resb.matkl,
      resb.matnr,
      resb.werks,

      // Order and Operation data

      aufv.autyp,
      aufv.auart,
      resb.aufnr,
      resb.plnfl,
      resb.flgat,
      //      resb.vornr,

      resb.vornr,
      aufv.werks                                         as pwerk,
      resb.aufpl,
      resb.aplzl,
      aufv.dispo,
      aufv.fevor,

      // Date and Time

      resb.bdter,
      resb.bdztp,
      resb.sbter,
      aufv.ftrmi,

      // Attributes

      resb.rssta,
      resb.kzear,
      resb.xloek,
      resb.xfehl,
      resb.schgt,
      resb.dbskz,
      resb.rgekz,
      resb.txtps,
      resb.kzkup,
      resb.afpos,
      resb.kfpos,
      resb.sanka,
      resb.clakz,
      resb.inpos,
      resb.beikz,
      resb.no_disp,

      // Long Text

      resb.ltxsp,

      // Assignments

      resb.bdart,
      resb.kdauf,
      resb.kdpos,
      resb.pspel,
      resb.cuobj,
      resb.aennr,
      resb.techs,
      resb.sortf,

      // Assignments BOM

      resb.stlty,
      resb.stlnr,
      aufv.stlan,
      resb.stlal,
      //      aufv.stlnr                                                      as stlnr2,

      cast ( resb.stlnr as pph_stnum preserving type )   as stlnr2,
      resb.stlkn,
      resb.bom_versn,
      resb.stpoz,
      resb.stvkn,
      resb.postp,
      //      resb.posnr,

      cast ( resb.posnr   as pph_sposn preserving type ) as posnr,
      resb.potx1,
      resb.potx2,
      resb.sernr,

      // Assignments Purchasing

      resb.infnr,
      resb.ekgrp,
      resb.banfn,
      resb.bnfpo,
      resb.ebeln,
      resb.ebelp,
      resb.lifnr,
      resb.lifzt,
      resb.gpreis,
      resb.peinh,

      // Goods Movement data

      resb.xwaok,
      resb.lgort,
      resb.charg,
      resb.splkz,
      resb.shkzg,
      resb.bwart,
      resb.sobkz,
      resb.kzbws,
      resb.kzvbr,
      resb.prvbe,
      resb.wempf,
      resb.ablad,
      resb.webaz,
      resb.sgt_scat,
      resb.sgt_rcat,

      // Assignments WM

      resb.lgnum,
      resb.lgtyp,
      resb.lgpla,

      // Assignments FI/CO

      resb.gsber,
      aufv.bukrs,
      resb.saknr,
      resb.fkber,
      aufv.kokrs,
      resb.knttp,
      resb.fipos,
      resb.fistl,

      // Variable-size comp. data

      resb.rohps,
      resb.roanz,
      resb.rokme,
      resb.romen,
      resb.romei,
      resb.roms1,
      resb.roms2,
      resb.roms3,
      resb.rform,

      // Alternative comp. data

      resb.alpos,
      resb.alpgr,
      resb.alpst,
      resb.alprf,
      resb.ewahr,

      // Phantom assembly

      resb.dumps,
      resb.aufwg,
      resb.aufst,
      resb.baugr,
      resb.bauwg,
      resb.baust,

      // Discontinuation

      resb.nfeag,
      resb.kzaus,
      resb.nfpkz,
      resb.nfgrp,
      resb.nomat,
      resb.nafkz,

      // Lead-Time offset

      resb.nlfzt,
      resb.nlfmv,
      resb.nlfzv,

      // Quantities and UoM

      resb.fmeng,
      resb.netau,
      resb.ausch,
      resb.avoau,
      resb.umrez,
      resb.umren,
      resb.meins,
      resb.bdmng,
      resb.enmng,
      resb.vmeng,
      resb.nomng,
      resb.erfme,
      resb.erfmg,

      // Amount and Currency

      resb.waers,
      resb.enwrt,

      // Fashion Manufacturing Fields

      resb.fsh_critical_comp,
      resb.fsh_critical_level,

      //Parent Item

      resb.splrv

}
where
  aufv.autyp = '40';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"RESB",
"CAUFV"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/