I_PurInfCndHelpr

@AbapCatalog.sqlViewName: 'IPURINFCNDHLPRV'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Helper View For CDS'
@VDM.viewType: #BASIC
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
define view I_PurInfCndHelpr
  as select distinct from I_PurchasingInfoRecord     as inf_gen

    inner join            I_PurgInfoRecdOrgPlantData as inf_org on inf_org.PurchasingInfoRecord = inf_gen.PurchasingInfoRecord

    left outer join       a017                       as i_a017  on  i_a017.lifnr = inf_gen.Supplier
                                                                and i_a017.matnr = inf_gen.Material
                                                                and i_a017.ekorg = inf_org.PurchasingOrganization
                                                                and i_a017.werks = inf_org.Plant
                                                                and i_a017.esokz = inf_org.PurchasingInfoRecordCategory

    left outer join       a018                       as i_a018  on  i_a018.lifnr = inf_gen.Supplier
                                                                and i_a018.matnr = inf_gen.Material
                                                                and i_a018.ekorg = inf_org.PurchasingOrganization
                                                                and i_a018.esokz = inf_org.PurchasingInfoRecordCategory

    left outer join       a025                       as i_a025  on  i_a025.lifnr = inf_gen.Supplier
                                                                and i_a025.ekorg = inf_org.PurchasingOrganization
                                                                and i_a025.matkl = inf_gen.MaterialGroup
                                                                and i_a025.infnr = inf_gen.PurchasingInfoRecord
                                                                and i_a025.werks = inf_org.Plant
                                                                and i_a025.esokz = inf_org.PurchasingInfoRecordCategory

    left outer join       a028                       as i_a028  on  i_a028.lifnr = inf_gen.Supplier
                                                                and i_a028.ekorg = inf_org.PurchasingOrganization
                                                                and i_a028.matkl = inf_gen.MaterialGroup
                                                                and i_a028.infnr = inf_gen.PurchasingInfoRecord
                                                                and i_a028.esokz = inf_org.PurchasingInfoRecordCategory
{

  key case
  when inf_gen.Supplier <> '' and inf_gen.Material <> '' and inf_org.PurchasingOrganization <> '' and inf_org.Plant <> '' and  inf_org.PurchasingInfoRecordCategory <> ''
  then i_a017.knumh
  when inf_gen.Supplier <> '' and inf_gen.Material <> '' and inf_org.PurchasingOrganization <> '' and inf_org.PurchasingInfoRecordCategory <> ''
  then i_a018.knumh
  when inf_gen.Supplier <> '' and inf_org.PurchasingOrganization <> '' and inf_gen.MaterialGroup <> '' and inf_gen.PurchasingInfoRecord <> ''  and inf_org.Plant <> '' and inf_org.PurchasingInfoRecordCategory <> ''
  then i_a025.knumh
  when inf_gen.Supplier <> '' and inf_org.PurchasingOrganization <> '' and inf_gen.MaterialGroup <> '' and inf_gen.PurchasingInfoRecord <> ''  and inf_org.PurchasingInfoRecordCategory <> ''
  then i_a028.knumh
  else
  'NULL'
  end                  as ConditionRecord,

  key inf_gen.PurchasingInfoRecord,

  key case
  when inf_gen.Supplier <> '' and inf_gen.Material <> '' and inf_org.PurchasingOrganization <> '' and inf_org.Plant <> '' and  inf_org.PurchasingInfoRecordCategory <> ''
  then i_a017.datbi
  when inf_gen.Supplier <> '' and inf_gen.Material <> '' and inf_org.PurchasingOrganization <> '' and inf_org.PurchasingInfoRecordCategory <> ''
  then i_a018.datbi
  when inf_gen.Supplier <> '' and inf_org.PurchasingOrganization <> '' and inf_gen.MaterialGroup <> '' and inf_gen.PurchasingInfoRecord <> ''  and inf_org.Plant <> '' and inf_org.PurchasingInfoRecordCategory <> ''
  then i_a025.datbi
  when inf_gen.Supplier <> '' and inf_org.PurchasingOrganization <> '' and inf_gen.MaterialGroup <> '' and inf_gen.PurchasingInfoRecord <> ''  and inf_org.PurchasingInfoRecordCategory <> ''
  then i_a028.datbi
  else
  cast( '00000000' as abap.dats )
  end                  as ConditionValidityEndDate,

      inf_gen.Supplier as Supplier,
      inf_org.PurchasingOrganization,
      inf_org.Plant    as Plant,
      inf_org.PurchasingInfoRecordCategory,

      case
      when inf_gen.Supplier <> '' and inf_gen.Material <> '' and inf_org.PurchasingOrganization <> '' and inf_org.Plant <> '' and  inf_org.PurchasingInfoRecordCategory <> ''
      then i_a017.datab
      when inf_gen.Supplier <> '' and inf_gen.Material <> '' and inf_org.PurchasingOrganization <> '' and inf_org.PurchasingInfoRecordCategory <> ''
      then i_a018.datab
      when inf_gen.Supplier <> '' and inf_org.PurchasingOrganization <> '' and inf_gen.MaterialGroup <> '' and inf_gen.PurchasingInfoRecord <> ''  and inf_org.Plant <> '' and inf_org.PurchasingInfoRecordCategory <> ''
      then i_a025.datab
      when inf_gen.Supplier <> '' and inf_org.PurchasingOrganization <> '' and inf_gen.MaterialGroup <> '' and inf_gen.PurchasingInfoRecord <> ''  and inf_org.PurchasingInfoRecordCategory <> ''
      then i_a028.datab
      else
      cast( '00000000' as abap.dats )
      end              as ConditionValidityStartDate,


      case
      when inf_gen.Supplier <> '' and inf_gen.Material <> '' and inf_org.PurchasingOrganization <> '' and inf_org.Plant <> '' and  inf_org.PurchasingInfoRecordCategory <> ''
      then cast('A017'  as abap.char(4))
      when inf_gen.Supplier <> '' and inf_gen.Material <> '' and inf_org.PurchasingOrganization <> '' and inf_org.PurchasingInfoRecordCategory <> ''
      then cast ('A018' as abap.char(4))
      when inf_gen.Supplier <> '' and inf_org.PurchasingOrganization <> '' and inf_gen.MaterialGroup <> '' and inf_gen.PurchasingInfoRecord <> ''  and inf_org.Plant <> '' and inf_org.PurchasingInfoRecordCategory <> ''
      then cast ('A025' as abap.char(4))
      when inf_gen.Supplier <> '' and inf_org.PurchasingOrganization <> '' and inf_gen.MaterialGroup <> '' and inf_gen.PurchasingInfoRecord <> ''  and inf_org.PurchasingInfoRecordCategory <> ''
      then cast ('A028' as abap.char(4))
      else
      cast ('Annn' as abap.char(4))
      end              as ConditionTable
}                    
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASINGINFORECORD",
"I_PURGINFORECDORGPLANTDATA",
"A017",
"A018",
"A025",
"A028"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/