@AbapCatalog.sqlViewName: 'PMFGORDOPRESITM'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.private: true
@VDM.viewType: #BASIC
//preselect view for I_MfgOrderOperationComponent
define view P_MfgOrderOpReservationItem
as select from resb as resb
left outer to one join caufv as aufv on aufv.aufnr = resb.aufnr
left outer to one join tcs03 as tcs03 on agb29 = '29'
{
// 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,
aufv.objnr as OrderObjectInternalID,
resb.aufnr,
resb.plnfl,
resb.flgat,
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.objnr,
resb.rgekz,
resb.txtps,
resb.kzkup,
resb.afpos,
resb.kfpos,
resb.sanka,
resb.clakz,
resb.inpos,
resb.no_disp,
// Long Text
resb.ltxsp,
// Assignments
resb.bdart,
resb.kdauf,
resb.kdpos,
resb.pspel,
resb.cuobj,
resb.aennr,
resb.techs,
resb.sortf,
resb.revlv,
// Assignments BOM
resb.stlty,
resb.stlnr,
aufv.stlan,
resb.stlal,
aufv.stlnr as stlnr2,
resb.stlkn,
resb.bom_versn,
resb.stpoz,
resb.stvkn,
resb.postp,
resb.posnr,
resb.potx1,
resb.potx2,
resb.sernr,
// Assignments Purchasing
resb.infnr,
resb.ekgrp,
resb.banfn,
resb.bnfpo,
resb.ebeln,
resb.ebelp,
resb.ebele,
resb.lifnr,
resb.lifzt,
resb.gpreis,
resb.peinh,
// Goods Movement data
resb.xwaok,
resb.lgort,
resb.shkzg,
resb.bwart,
resb.sobkz,
resb.kzbws,
resb.kzvbr,
resb.prvbe,
resb.wempf,
resb.ablad,
resb.webaz,
resb.sgt_scat,
resb.sgt_rcat,
// Batch data
resb.charg,
resb.kzech,
resb.splkz,
resb.splrv,
resb.chobj,
// Assignments WM
resb.berkz,
resb.lgnum,
resb.lgtyp,
resb.lgpla,
// Assignments FI/CO
resb.gsber,
aufv.bukrs,
resb.saknr,
resb.fkber,
aufv.kokrs,
resb.knttp,
resb.kblnr,
resb.kblpos,
resb.fipos,
resb.fipex,
resb.fistl,
resb.geber,
// Variable-size comp. data
resb.rohps,
resb.roanz,
resb.rokme,
resb.romen,
resb.romei,
resb.roms1,
resb.roms2,
resb.roms3,
resb.rform,
tcs03.roame,
// 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,
// Material provision
resb.beikz,
// Spare parts
resb.erskz,
// 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
}
where aufv.autyp = '10'
or aufv.autyp = '40';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"RESB",
"TCS03",
"CAUFV"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/