P_CLEAREDITEM3

CDS View

P_CLEAREDITEM3 is a CDS View in S/4HANA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_ClearedItem view from CONSUMPTION Cleared Item 
@AbapCatalog.sqlViewName: 'PCLRDITM3'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #CONSUMPTION
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true

define view P_ClearedItem3
  as select from P_ClearedItem2
                                                       
{
  key CompanyCode as CompanyCode,
  key AccountingDocument,
  key AccountingDocumentItem,
  key FiscalYear,
  key FinancialAccountType,
  
      ClearingJournalEntry,
      ClearingJournalEntryFiscalYear,
      cast(Account as konko)                            as  Account,
      AssignmentReference,
      cast(AccountingDocumentType as fis_blart)         as  AccountingDocumentType,
      AccountingDocumentCategory,
      PostingDate,
      SpecialGLCode,
      CompanyCodeCurrency,
      DocumentItemText,
      DocumentDate,
      InvoiceReference,
      IntercompanyTransaction,
      IsNetInvoiceCashDiscClearing,
      AmountInCompanyCodeCurrency,
      CashDiscountAmtInCoCodeCrcy,
      AmountInAdditionalCurrency1,
      AmountInAdditionalCurrency2
}
where 
(   (    FinancialAccountType = 'D' 
     and (   PaymentCardItem = '000'      //See note 647707 - FSCM-BD: FS598 when reversing a payment document

          or TransactionCode = 'F110' ) ) //Support of Biller Direct Credit Card Process. No support of SD Credit Card Process, that is handled via transaction FBRC

  or FinancialAccountType = 'K'
  or FinancialAccountType = 'S' ) 

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_CLEAREDITEM2"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More