Arberp_V_Int_Ord_View

@AbapCatalog.sqlViewName: 'ARBERP_V_INT_ORD'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #MASTER
@EndUserText.label: 'Fieldglass: Relevant Internal Orders'
define view Arberp_V_Int_Ord_View
  as select
    aufk.mandt,
    aufnr,
    auart,
    autyp,
    refnr,
    ernam,
    erdat,
    aenam,
    aedat,
    ktext,
    ltext,
    bukrs,
    werks,
    gsber,
    kokrs,
    cckey,
    kostv,
    stort,
    sowrk,
    astkz,
    waers,
    astnr,
    stdat,
    estnr,
    phas0,
    phas1,
    phas2,
    phas3,
    pdat1,
    pdat2,
    pdat3,
    idat1,
    idat2,
    idat3,
    objid,
    vogrp,
    loekz,
    plgkz,
    kalsm,
    zschl,
    aufk.objnr,
    prctr,
    pspel,
    awsls,
    abgsl,
    txjcd,
    func_area,
    scope,
    plint,
    kdauf,
    kdpos,
    aufex,
    ivpro,
    logsystem
  from              aufk
    left outer join jest on  jest.objnr = aufk.objnr
                         and jest.stat  = 'I0043'
  where
         autyp      =  '01'
    and  loekz      <> 'X'
    and  astkz      <> 'X'
    and(
         phas1      =  'X'
      or phas2      =  'X'
    )
    and(
         jest.stat  is null
      or jest.inact =  'X'
    ); 
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"AUFK",
"JEST"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/