P_SAFTJOURNALENTRYLEDGER

CDS View

SAFT Journal Entry Ledger

P_SAFTJOURNALENTRYLEDGER is a CDS View in S/4HANA. SAFT Journal Entry Ledger. It contains 2 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 2 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_PT_SAFTGenLedgerHeaderC view_entity inner CONSUMPTION General Ledger Document Header - Cube
C_PT_SAFTGenLedgerJournal view inner CONSUMPTION SAF-T PT General Ledger Journal
I_SAFTJournalEntry view inner COMPOSITE SAF-T Journal Ledger Entry

Fields (2)

KeyField CDS FieldsUsed in Views
KEY Ledger Ledger 1
SourceLedger SourceLedger 1 
@AbapCatalog.sqlViewName: 'PSAFTJOURNALDG'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #P
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking : #NOT_REQUIRED
define view P_SAFTJournalEntryLedger
  as select from I_JournalEntryItem
{

  key SourceLedger,
  key CompanyCode,
  key FiscalYear,
  key AccountingDocument,
      Ledger,
      sum( DebitAmountInCoCodeCrcy )  as DebitAmountInCoCodeCrcy,
      sum( CreditAmountInCoCodeCrcy ) as CreditAmountInCoCodeCrcy

}
group by
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  Ledger

Learn More