P_SlsQtanProcFlow30

DDL: P_SLSQTANPROCFLOW30 SQL: PSLSQTANPROCF30 Type: view CONSUMPTION

P_SlsQtanProcFlow30 is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (P_SlsQtanProcFlow20, I_SDDocumentProcessFlow) and exposes 11 fields with key fields Level2Document, Level2DocumentItem, Level3Document, Level3DocumentItem, SalesQuotation.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
P_SlsQtanProcFlow20 Level2 from
I_SDDocumentProcessFlow Level3 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 PSLSQTANPROCF30 view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY Level2Document P_SlsQtanProcFlow20 Level2Document
KEY Level2DocumentItem P_SlsQtanProcFlow20 Level2DocumentItem
KEY Level3Document I_SDDocumentProcessFlow SubsequentDocument
KEY Level3DocumentItem I_SDDocumentProcessFlow SubsequentDocumentItem
KEY SalesQuotation P_SlsQtanProcFlow20 SalesQuotation
SalesQuotationType P_SlsQtanProcFlow20 SalesQuotationType
Level2DocumentCategory P_SlsQtanProcFlow20 Level2DocumentCategory
Level3DocumentCategory I_SDDocumentProcessFlow SubsequentDocumentCategory
SalesOrganization P_SlsQtanProcFlow20 SalesOrganization
DistributionChannel P_SlsQtanProcFlow20 DistributionChannel
OrganizationDivision P_SlsQtanProcFlow20 OrganizationDivision 
@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: 'PSLSQTANPROCF30'
define view P_SlsQtanProcFlow30
  as select from P_SlsQtanProcFlow20                     as Level2

    inner join I_SDDocumentProcessFlow                   as Level3
      on Level2.Level1Document            = Level3.PrecedingDocument
        and Level2.Level2DocumentCategory = Level3.PrecedingDocumentCategory
        and Level2.Level2DocumentItem     = Level3.PrecedingDocumentItem
        and (
          Level3.SubsequentDocumentCategory = 'M' or  --> Invoice
          Level3.SubsequentDocumentCategory = 'U'     --> Pro Forma Invoice
        )

{

      //Key

  key Level2.Level2Document                              as Level2Document,
  key Level2.Level2DocumentItem                          as Level2DocumentItem,
  key Level3.SubsequentDocument                          as Level3Document,
  key Level3.SubsequentDocumentItem                      as Level3DocumentItem,
      
      //SalesQuotation

  key Level2.SalesQuotation,
      Level2.SalesQuotationType,
      
      //Category

      Level2.Level2DocumentCategory                      as Level2DocumentCategory,
                                                    
      Level3.SubsequentDocumentCategory                  as Level3DocumentCategory, 
       
      //Organization

      Level2.SalesOrganization,
      Level2.DistributionChannel,
      Level2.OrganizationDivision

}
where Level2.Level2DocumentCategory = 'J' --> Delivery

Learn More