P_SlsQtanProcFlow41

DDL: P_SLSQTANPROCFLOW41 SQL: PSLSQTANPROCF41 Type: view CONSUMPTION

P_SlsQtanProcFlow41 is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_AccountingDocument) and exposes 10 fields with key fields Level3Document, 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 PSLSQTANPROCF41 view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Level3Document Level3 Level3Document
KEY AccountingDocument I_AccountingDocument AccountingDocument
KEY SalesQuotation Level3 SalesQuotation
SalesQuotationType Level3 SalesQuotationType
Level3DocumentCategory Level3 Level3DocumentCategory
SalesOrganization Level3 SalesOrganization
DistributionChannel Level3 DistributionChannel
OrganizationDivision Level3 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: 'PSLSQTANPROCF41'
define view P_SlsQtanProcFlow41
  as select distinct from P_SlsQtanProcFlow30 as Level3

    inner join I_AccountingDocument           as AccountingDocument
      on Level3.Level3Document                       = AccountingDocument.OriginalReferenceDocument
        and AccountingDocument.ReferenceDocumentType = 'VBRK'
        and AccountingDocument.LedgerGroup           = ''
{
  
      //Key

  key Level3.Level3Document,
  key AccountingDocument.AccountingDocument,
  
      //SalesQuotation

  key Level3.SalesQuotation,
      Level3.SalesQuotationType,

      //Category

      Level3.Level3DocumentCategory,

      //Organization

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

      AccountingDocument.CompanyCode,
      AccountingDocument.FiscalYear

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

Learn More