P_SlsQtanProcFlow0

DDL: P_SLSQTANPROCFLOW0 SQL: PSLSQTANPROCF0 Type: view CONSUMPTION Package: ODATA_SD_QUT_PROCESSFLOW

Sales Quotation Process Flow: Level 0 Initial Focus

P_SlsQtanProcFlow0 is a Consumption CDS View that provides data about "Sales Quotation Process Flow: Level 0 Initial Focus" in SAP S/4HANA. It reads from 1 data source (I_SalesDocumentBasic) and exposes 9 fields with key fields Level1Document, Level1DocumentItem, SalesQuotation. Part of development package ODATA_SD_QUT_PROCESSFLOW.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_SalesDocumentBasic SalesDocument from

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 PSLSQTANPROCF0 view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY Level1Document
KEY Level1DocumentItem
KEY SalesQuotation
SalesQuotationType SalesDocumentType
SalesQuotationCategory SDDocumentCategory
SalesOrganization SalesOrganization
DistributionChannel DistributionChannel
OrganizationDivision 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: '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