Fins_Trr_Acc_Ass_Obj_vbap

@AbapCatalog.sqlViewName: 'TRR_AAO_VB'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Account Assignment Object'

@ObjectModel.dataCategory:#VALUE_HELP
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED

//Used for value help FINS_TRR_AAO_VB for Account Assignment Object, data element FINS_TRR_ACC_ASS_OBJ

//Selects from VBAP, VBAK and P_Kkag_Werk_Bukrs_Kokrs


define view Fins_Trr_Acc_Ass_Obj_vbap as 

  select    
    key 
    cast( case when vbap.vbeln between '0000000000' and '9999999999' 
          then concat(concat(concat(cast(cast(cast(vbap.vbeln as fins_trr_numeric_char) as fins_trr_numeric) as fins_trr_acc_ass_obj),'-'),vbap.posnr),'(VB)')
          else concat(concat(concat(vbap.vbeln,'-'),vbap.posnr),'(VB)') end 
          as fins_trr_acc_ass_obj) as cost_object,
    vbak.vbeln as vbeln,           
    vbak.kunnr as kunnr,
    vbak.bstnk as bstnk,
    vbak.vbtyp as vbtyp,
    vbap.kzvbr as kzvbr,
    vbak.vkorg as vkorg,
//    vbak.bukrs_vf as BUKRS_VF,

//    P_Kkag_Werk_Bukrs_Kokrs.bukrs as bukrs,

//    P_Kkag_Werk_Bukrs_Kokrs.kokrs as kokrs,

    cast( vbak.bukrs_vf as bukrs ) as bukrs,
    tka02.kokrs as kokrs,
    vbap.posnr as posnr,
    vbap.werks as werks,
    vbap.prctr as prctr,
    vbap.abgrs as abgsl,
    vbap.pstyv as PSTYV,
    vbap.matnr as matnr,
    cast( case when vbap.fkrel = ' ' then ' ' else 'X' end as ps_fakkz) as fakkz,
    cast( vbap.arktx as auftext ) as ktext,
    vbap.solution_order_id as solution_order_id
    from vbap
//    inner join P_Kkag_Werk_Bukrs_Kokrs on P_Kkag_Werk_Bukrs_Kokrs.werks = vbap.werks 

    inner join vbak on vbak.vbeln = vbap.vbeln
    inner join tka02 on tka02.bukrs = vbak.bukrs_vf
     where ( vbap.kzvbr = 'E' and vbap.vbelv = vbap.vbeln and vbap.posnv = vbap.posnr ) or
           ( vbap.kzvbr = 'V' or vbap.kzvbr = ' ' ) 
    
    

;
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TKA02",
"VBAK",
"VBAP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/