P_SlsQtanProcFlow31

DDL: P_SLSQTANPROCFLOW31 SQL: PSLSQTANPROCF31 Type: view CONSUMPTION

P_SlsQtanProcFlow31 is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_AccountingDocument) and exposes 10 fields with key fields Level2Document, AccountingDocument, SalesQuotation.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
I_AccountingDocument AccountingDocument 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
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PSLSQTANPROCF31 view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Level2Document Level2 Level2Document
KEY AccountingDocument I_AccountingDocument AccountingDocument
KEY SalesQuotation Level2 SalesQuotation
SalesQuotationType Level2 SalesQuotationType
Level2DocumentCategory Level2 Level2DocumentCategory
SalesOrganization Level2 SalesOrganization
DistributionChannel Level2 DistributionChannel
OrganizationDivision Level2 OrganizationDivision
CompanyCode I_AccountingDocument CompanyCode
FiscalYear I_AccountingDocument FiscalYear 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL

@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.sqlViewName: 'PSLSQTANPROCF31'
define view P_SlsQtanProcFlow31
  as select distinct from P_SlsQtanProcFlow20 as Level2
    
    inner join I_AccountingDocument           as AccountingDocument
      on Level2.Level2Document                       = AccountingDocument.OriginalReferenceDocument
        and AccountingDocument.ReferenceDocumentType = 'VBRK'
        and AccountingDocument.LedgerGroup           = ''
{
  
      //Key

  key Level2.Level2Document,
  key AccountingDocument.AccountingDocument,
   
      //SalesQuotation

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

      Level2.Level2DocumentCategory,

      //Organization

      Level2.SalesOrganization,
      Level2.DistributionChannel,
      Level2.OrganizationDivision,
    
      //AccountingDocument additional keys

      AccountingDocument.CompanyCode,
      AccountingDocument.FiscalYear

}
where Level2.Level2DocumentCategory = 'M'  --> Invoice
 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ACCOUNTINGDOCUMENT",
"P_SLSQTANPROCFLOW20"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More