P_SlsQtanProcFlow10

DDL: P_SLSQTANPROCFLOW10 SQL: PSLSQTANPROCF10 Type: view CONSUMPTION Package: ODATA_SD_QUT_PROCESSFLOW

Sales Quotation Process Flow: Level +1 Sales & Distribution

P_SlsQtanProcFlow10 is a Consumption CDS View that provides data about "Sales Quotation Process Flow: Level +1 Sales & Distribution" in SAP S/4HANA. It reads from 2 data sources (P_SlsQtanProcFlow0, I_SDDocumentProcessFlow) and exposes 10 fields with key fields Level1Document, Level1DocumentItem, Level1DocumentCategory. Part of development package ODATA_SD_QUT_PROCESSFLOW.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
P_SlsQtanProcFlow0 Level0 from
I_SDDocumentProcessFlow Level1 inner

Annotations (8)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName PSLSQTANPROCF10 view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Level1Document I_SDDocumentProcessFlow SubsequentDocument
KEY Level1DocumentItem I_SDDocumentProcessFlow SubsequentDocumentItem
KEY Level1DocumentCategory I_SDDocumentProcessFlow SubsequentDocumentCategory
SalesQuotation P_SlsQtanProcFlow0 SalesQuotation
SalesQuotationType P_SlsQtanProcFlow0 SalesQuotationType
SalesQuotationCategory P_SlsQtanProcFlow0 SalesQuotationCategory
SalesOrganization P_SlsQtanProcFlow0 SalesOrganization
DistributionChannel P_SlsQtanProcFlow0 DistributionChannel
OrganizationDivision P_SlsQtanProcFlow0 OrganizationDivision
SalesOrderIsProjectBased 
@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: 'PSLSQTANPROCF10'
define view P_SlsQtanProcFlow10
  as select from P_SlsQtanProcFlow0                       as Level0
    
    inner join I_SDDocumentProcessFlow                    as Level1
      on Level0.SalesQuotation = Level1.PrecedingDocument
        and (
          Level1.SubsequentDocumentCategory = 'B' or  --> Quotation
          Level1.SubsequentDocumentCategory = 'C' or  --> Order
          Level1.SubsequentDocumentCategory = 'I'     --> Order w/o charge
        )

    left outer to one join I_SalesDocumentBasic           as SalesDocument 
      on Level1.SubsequentDocument = SalesDocument.SalesDocument

{
      //Key

  key Level1.SubsequentDocument                           as Level1Document,
  key Level1.SubsequentDocumentItem                       as Level1DocumentItem,
  key Level1.SubsequentDocumentCategory                   as Level1DocumentCategory,
      
      //SalesQuotation

      Level0.SalesQuotation,
      Level0.SalesQuotationType,
      Level0.SalesQuotationCategory,

      //Organization

      Level0.SalesOrganization,
      Level0.DistributionChannel,
      Level0.OrganizationDivision,

      //Status

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

      case when 
        ( SalesDocument.OverallOrdReltdBillgStatus = 'A' or
          SalesDocument.OverallOrdReltdBillgStatus = 'B' )
      then
        'X'
      else
        ''
      end                                                 as BillingDocumentIsRequired,

      //Order relevant for Project e.g Professional Service

      ''                                                  as SalesOrderIsProjectBased

      
}
where
  // No support for Professional Service

  ( SalesDocument._SalesDocumentType.OrderTypeForBillingRequest = ' ' and
    SalesDocument._SalesDocumentType.SalesDocumentProcessingType != 'P' )

Learn More