P_RevRecgnSalesOrderVH

@AbapCatalog.sqlViewName: 'PREVRECSALORDVH'
@AbapCatalog.compiler.compareFilter:true
@AbapCatalog.preserveKey:true

@VDM.viewType: #CONSUMPTION
@VDM.private: true

@ObjectModel.representativeKey: 'SalesOrder'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.type: #CLIENT_DEPENDENT
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L


define view P_RevRecgnSalesOrderVH

  as select from I_SalesDocumentBasic as vbak
    inner join   I_SalesDocumentItem  as vbap           on vbap.SalesDocument = vbak.SalesDocument
    inner join   P_SDItemCategory     as ItemCategories on vbap.SalesDocumentItemCategory = ItemCategories.Pstyv
    inner join   I_ResultsAnalysisKey as tkkaa          on tkkaa.ResultAnalysisInternalID = vbap.ResultAnalysisInternalID
    inner join   I_SalesOrganization  as so             on so.SalesOrganization = vbak.SalesOrganization
  //    inner join   acdoca              as acdoca on acdoca.kdauf = vbak.vbeln



{
  key vbak.SalesDocument        as SalesOrder,
      so.CompanyCode            as CompanyCode,
      vbak.SalesOrganization    as SalesOrganization,
      //      acdoca.rldnr       as Ledger,

      vbak.OrganizationDivision as OrganizationDivision,
      vbak.SalesDocumentType    as SalesOrderType,
      vbak.DistributionChannel  as DistributionChannel
}

where
       vbap.ResultAnalysisInternalID        <> ' '
  and  tkkaa.RsltIsForEvtBsdRevnRecognition =  'X'
  and(
       vbak.SDDocumentCategory              =  'C'
    or vbak.SDDocumentCategory              =  'H'
  )
  //  and(

  //       vbap.pstyv  =  'TAN'

  //    or vbap.pstyv  =  'TANN'

  //    or vbap.pstyv  =  'CBEN'

  //    or vbap.pstyv  =  'CB1'

  //    or vbap.pstyv  =  'CB2'

  //    or vbap.pstyv  =  'CBTC'

  //    or vbap.pstyv  =  'TAD'

  //    or vbap.pstyv  =  'CB1C'

  //    or vbap.pstyv  =  'CB2C'

  //    or vbap.pstyv  =  'TAQ'

  //    or vbap.pstyv  =  'CBXN'

  //    or vbap.pstyv  =  'CPHD'

  //    or vbap.pstyv  =  'CBIC'

  //  )

  and(
       vbap.ItemIsBillingRelevant           =  'A'
    or vbap.ItemIsBillingRelevant           =  'B'
    or vbap.ItemIsBillingRelevant           =  'F'
    or vbap.ItemIsBillingRelevant           =  'K'
    or vbap.ItemIsBillingRelevant           =  'Y'
  )
//  and(

//       vbap.kzvbr                    =  ' '

//    or vbap.kzvbr                    =  'V'

//  )


group by
  vbak.SalesDocument,
  so.CompanyCode,
  vbak.SalesOrganization,
  vbak.OrganizationDivision,
  vbak.SalesDocumentType,
  vbak.DistributionChannel
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_RESULTSANALYSISKEY",
"I_SALESDOCUMENTBASIC",
"I_SALESDOCUMENTITEM",
"I_SALESORGANIZATION",
"P_SDITEMCATEGORY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/