P_PrepaymentClearingAcctgDoc

DDL: P_PREPAYMENTCLEARINGACCTGDOC SQL: PPPMGCLACCDOC Type: view BASIC

Private View : Clearing Accounting Doc

P_PrepaymentClearingAcctgDoc is a Basic CDS View that provides data about "Private View : Clearing Accounting Doc" in SAP S/4HANA. It reads from 2 data sources (bkpf, bseg) and exposes 7 fields with key fields ClearedAccountingDocument, FiscalYear.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
bkpf _AccountingDocumentHeader inner
bseg AccountingDocumentSegment from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PPPMGCLACCDOC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.private true view
VDM.viewType #BASIC view
EndUserText.label Private View : Clearing Accounting Doc view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ClearedAccountingDocument bseg belnr
KEY FiscalYear bseg gjahr
CompanyCode bseg bukrs
ClearingDate bseg augdt
ClearingJournalEntry bseg augbl
ACMReferenceKey bkpf awkey
SupplierConfirmationExtNumber bkpf xblnr 
@AbapCatalog.sqlViewName: 'PPPMGCLACCDOC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@VDM.private:true
@VDM.viewType:#BASIC
@EndUserText.label: 'Private View : Clearing Accounting Doc'

define view P_PrepaymentClearingAcctgDoc
  as select from bseg as AccountingDocumentSegment
    inner join   bkpf   as _AccountingDocumentHeader on  _AccountingDocumentHeader.belnr = AccountingDocumentSegment.belnr
                                                     and _AccountingDocumentHeader.gjahr = AccountingDocumentSegment.gjahr

{
  key AccountingDocumentSegment.belnr as ClearedAccountingDocument,
  key AccountingDocumentSegment.gjahr as FiscalYear,
      AccountingDocumentSegment.bukrs as CompanyCode,
      AccountingDocumentSegment.augdt as ClearingDate,
      AccountingDocumentSegment.augbl as ClearingJournalEntry,
      _AccountingDocumentHeader.awkey as ACMReferenceKey,
      _AccountingDocumentHeader.xblnr as SupplierConfirmationExtNumber
}
where
      AccountingDocumentSegment.augbl != ''
  and AccountingDocumentSegment.augdt is not initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"BKPF",
"BSEG"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More