P_SLSQTANPROCFLOW0

CDS View

Sales Quotation Process Flow: Level 0 Initial Focus

P_SLSQTANPROCFLOW0 is a CDS View in S/4HANA. Sales Quotation Process Flow: Level 0 Initial Focus. It contains 6 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 6 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_SlsQtanProcFlow10 view from CONSUMPTION Sales Quotation Process Flow: Level +1 Sales & Distribution
P_SlsQtanProcFlowM1 view from CONSUMPTION Sales Quotation Process Flow: Level -1 Sales & Distribution

Fields (6)

KeyField CDS FieldsUsed in Views
KEY SalesQuotation SalesQuotation 2
DistributionChannel DistributionChannel 2
OrganizationDivision OrganizationDivision 2
SalesOrganization SalesOrganization 2
SalesQuotationCategory SalesQuotationCategory 2
SalesQuotationType SalesQuotationType 2 
@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';

Learn More