I_SAFTJournalCode

DDL: I_SAFTJOURNALCODE SQL: ISAFTJOURNALCOD Type: view COMPOSITE Package: GLO_FIN_IS_SAFT_GEN

SAF-T Journal Codes

I_SAFTJournalCode is a Composite CDS View that provides data about "SAF-T Journal Codes" in SAP S/4HANA. It reads from 1 data source (I_JournalEntryItem) and exposes 7 fields with key fields CompanyCode, Ledger, AccountingDocumentType. Part of development package GLO_FIN_IS_SAFT_GEN.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_JournalEntryItem I_JournalEntryItem from

Parameters (3)

NameTypeDefault
P_StartDate dats
P_EndDate dats
P_Ledger fins_ledger

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ISAFTJOURNALCOD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label SAF-T Journal Codes view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY Ledger Ledger
KEY AccountingDocumentType AccountingDocumentType
_AccountingDocumentTypeText _AccountingDocumentTypeText
_CompanyCode _CompanyCode
_Ledger _Ledger
_AccountingDocumentType _AccountingDocumentType 
@AbapCatalog.sqlViewName: 'ISAFTJOURNALCOD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'SAF-T Journal Codes'
define view I_SAFTJournalCode
  with parameters
    P_StartDate : dats,
    P_EndDate   : dats,
    P_Ledger    : fins_ledger

  as select from I_JournalEntryItem
{
      @ObjectModel.foreignKey.association: '_CompanyCode'
  key CompanyCode            as CompanyCode,
      @ObjectModel.foreignKey.association: '_Ledger'
  key Ledger                 as Ledger,

      @ObjectModel.foreignKey.association: '_AccountingDocumentType'
  key AccountingDocumentType as AccountingDocumentType,

      //Associations

      _AccountingDocumentTypeText,
      _CompanyCode,
      _Ledger,
      _AccountingDocumentType
}
where
      PostingDate >= :P_StartDate
  and PostingDate <= :P_EndDate
  and Ledger      =  :P_Ledger

group by
  AccountingDocumentType,
  CompanyCode,
  Ledger

Learn More