P_SLSQTANPROCFLOW0

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL

@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@AbapCatalog.sqlViewName: 'PSLSQTANPROCF0'
define view P_SlsQtanProcFlow0
  as select from I_SalesDocumentBasic as SalesDocument

{
      //Key

  key cast('' as vbeln_von)                   as Level1Document,
  key cast('' as posnr_von)                   as Level1DocumentItem,
  
      //SalesQuotation

  key cast(SalesDocument as sales_quotation)  as SalesQuotation,
      SalesDocumentType                       as SalesQuotationType,
      SDDocumentCategory                      as SalesQuotationCategory,
     
      //Organization

      SalesOrganization,
      DistributionChannel,
      OrganizationDivision,

      //Status

      case when
        ( OverallTotalDeliveryStatus = 'A' or
          OverallTotalDeliveryStatus = 'B' )
      then
        'X'
      else
        ''
      end                                     as DeliveryDocumentIsRequired,

      case when
        ( OverallOrdReltdBillgStatus = 'A' or
          OverallOrdReltdBillgStatus = 'B' )
      then
        'X'
      else
        ''
      end                                     as BillingDocumentIsRequired,
      
      //Order relevant for Project e.g Professional Service

      ''                                      as SalesOrderIsProjectBased
      
}
where
  SDDocumentCategory = 'B';