P_NL_SAFTInvoiceType

DDL: P_NL_SAFTINVOICETYPE SQL: PNLSAFTINVTYP Type: view COMPOSITE Package: GLO_FIN_IS_SAFT_NL

SAF-T NL Invoice Type (P or S)

P_NL_SAFTInvoiceType is a Composite CDS View that provides data about "SAF-T NL Invoice Type (P or S)" in SAP S/4HANA. It reads from 1 data source (I_JournalEntryItem) and exposes 11 fields with key fields SourceLedger, Ledger, CompanyCode, FiscalYear, AccountingDocument. Part of development package GLO_FIN_IS_SAFT_NL.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_JournalEntryItem I_JournalEntryItem from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PNLSAFTINVTYP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger SourceLedger
KEY Ledger Ledger
KEY CompanyCode CompanyCode
KEY FiscalYear FiscalYear
KEY AccountingDocument AccountingDocument
LedgerGLLineItem
_SourceLedger _SourceLedger
_Ledger _Ledger
_CompanyCode _CompanyCode
_FiscalYear _FiscalYear
_JournalEntry _JournalEntry 
@AbapCatalog.sqlViewName: 'PNLSAFTINVTYP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #P
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_NL_SAFTInvoiceType
  as select from I_JournalEntryItem
{
      @ObjectModel.foreignKey.association: '_SourceLedger'
  key SourceLedger,
      @ObjectModel.foreignKey.association: '_Ledger'
  key Ledger,
      @ObjectModel.foreignKey.association: '_CompanyCode'
  key CompanyCode,
      @ObjectModel.foreignKey.association: '_FiscalYear'
  key FiscalYear,
      @ObjectModel.foreignKey.association: '_JournalEntry'
  key AccountingDocument,
      max(LedgerGLLineItem) as LedgerGLLineItem,
      case when FinancialAccountType = 'D'
             then 'S'
             else 'P'
      end                   as DocumentType,

      _SourceLedger,
      _Ledger,
      _CompanyCode,
      _FiscalYear,
      _JournalEntry

}
where
        FinancialAccountType  = 'D'
  or    FinancialAccountType  = 'K'
  or(
        FinancialAccountType  = 'S'
    and ReferenceDocumentType = 'FKKSU'
  ) // G/L Account



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

Learn More