P_SLSQTANPROCFLOW10

CDS View

Sales Quotation Process Flow: Level +1 Sales & Distribution

P_SLSQTANPROCFLOW10 is a CDS View in S/4HANA. Sales Quotation Process Flow: Level +1 Sales & Distribution. It contains 8 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 8 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_SlsQtanProcFlow20 view from CONSUMPTION Sales Quotation Process Flow: Level +2 Sales & Distribution

Fields (8)

KeyField CDS FieldsUsed in Views
KEY Level1Document Level1Document 1
KEY Level1DocumentItem Level1DocumentItem 1
KEY SalesQuotation SalesQuotation 1
DistributionChannel DistributionChannel 1
Level1DocumentCategory Level1DocumentCategory 1
OrganizationDivision OrganizationDivision 1
SalesOrganization SalesOrganization 1
SalesQuotationType SalesQuotationType 1 
@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