P_MDChgProcCustValnWthBusPart

@AbapCatalog.sqlViewName: 'PMDCCUSTVALNBPNO'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
@VDM.viewType: #BASIC

define view P_MDChgProcCustValnWthBusPart as select from but000 as but000
   inner join cvi_cust_link as cust_link on but000.partner_guid = cust_link.partner_guid
   inner join kna1 as kna1 on cust_link.customer = kna1.kunnr
   inner join P_MDChgProcCustValn as ausp on kna1.kunnr = ausp.objek
   inner join cabn as cabn on ausp.atinn = cabn.atinn
{
  key but000.client as source_client,
  key but000.partner as source_id,
  key '000000000002' as assignment_id,
  key ausp.atzhl,
  key ausp.mafid,
  key ausp.klart, 
  key ausp.adzhl,
  key ausp.source_atinn,   
  ausp.atwrt,
  ausp.atflv,
  ausp.atawe,
  ausp.atflb,
  ausp.ataw1,
  ausp.atcod,
  ausp.attlv,
  ausp.attlb,
  ausp.atprz,
  ausp.atinc,
  ausp.ataut,
  ausp.aennr,
  ausp.datuv,
  ausp.lkenz,
  ausp.atimb,
  ausp.atzis,
  ausp.atsrt,
  ausp.atvglart,
  ausp.datub, 
  cabn.atnam,
  ausp.atinn     
}
union select from but000 as but000
  inner join mdg_mlt_assgmnt as mlt_assmnt on but000.partner = mlt_assmnt.partner and mlt_assmnt.assignment_cat = 'CUST' and mlt_assmnt.standard <> 'X'
  inner join kna1 as kna1 on mlt_assmnt.object_id = kna1.kunnr
  inner join P_MDChgProcCustValn as ausp on kna1.kunnr = ausp.objek
  inner join cabn as cabn on ausp.atinn = cabn.atinn
{
  key but000.client as source_client,
  key but000.partner as source_id,
  key mlt_assmnt.assignment_id as assignment_id,
  key ausp.atzhl,
  key ausp.mafid,
  key ausp.klart, 
  key ausp.adzhl,
  key ausp.source_atinn,   
  ausp.atwrt,
  ausp.atflv,
  ausp.atawe,
  ausp.atflb,
  ausp.ataw1,
  ausp.atcod,
  ausp.attlv,
  ausp.attlb,
  ausp.atprz,
  ausp.atinc,
  ausp.ataut,
  ausp.aennr,
  ausp.datuv,
  ausp.lkenz,
  ausp.atimb,
  ausp.atzis,
  ausp.atsrt,
  ausp.atvglart,
  ausp.datub, 
  cabn.atnam,
  ausp.atinn      
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_MDCHGPROCCUSTVALN",
"BUT000",
"CABN",
"CVI_CUST_LINK",
"KNA1",
"MDG_MLT_ASSGMNT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/