P_RO_SAFTJOURNALENTRYITEMEXC

CDS View

Acdoca Exclude 8/9 GL accounts

P_RO_SAFTJOURNALENTRYITEMEXC is a CDS View in S/4HANA. Acdoca Exclude 8/9 GL accounts. 18 CDS views read from this table.

Used by 18 CDS view(s)

CDS Views using this table (18)

ViewTypeJoinVDMDescription
C_RO_SAFTProductC view inner CONSUMPTION Product Type for RO SAFT - Cube
C_RO_SAFTSalesInvoiceItemC view inner CONSUMPTION Sales invoice item for RO SAFT - Cube
P_RO_SAFTAnalysisTypeItem view from CONSUMPTION Analysis Types for GL Entries/Payments
P_RO_SAFTAnalysisTypeItem view union_all CONSUMPTION Analysis Types for GL Entries/Payments
P_RO_SAFTJournalEntryItem view inner CONSUMPTION GL Item and Header for RO SAFT
P_RO_SAFTNTRPurInvItem view_entity inner CONSUMPTION Purchase invoice items
P_RO_SAFTNTRREPORTEDITEMSLOG2 view_entity from CONSUMPTION RO SAFT NTR Reported Items Log
P_RO_SAFTNTRSlsInvItem view_entity inner CONSUMPTION Sales invoice items
P_RO_SAFTPaymentHeader view inner CONSUMPTION RO SAFT Payment Header for totals calculation
P_RO_SAFTPaymnetItemNew view inner CONSUMPTION SAFT RO Payment Item
P_RO_SAFTPurInvHdr1 view inner CONSUMPTION Pur Inv Header for RO SAFT Base 1
P_RO_SAFTPurInvItem view inner CONSUMPTION Purchase invoice items
P_RO_SAFTPurInvItemAmount view_entity inner CONSUMPTION Purchase invoice items
P_RO_SAFTPURINVITEMTOTAL view_entity inner CONSUMPTION Purchase invoice items
P_RO_SAFTSalesInvoiceItem view inner CONSUMPTION Sales invoice item for RO SAFT - Cube
P_RO_SAFTSalInvHdr1 view inner CONSUMPTION Sales Inv Header for RO SAFT Base 1
P_RO_SAFTSLSINVITEMTOTAL view_entity inner CONSUMPTION Sales invoice items
P_RO_SAFTSlsInvoiceItemAmount view_entity inner CONSUMPTION Non RO TaxCodes 
@AbapCatalog.sqlViewName: 'PROSAFTJRNENITME'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #CONSUMPTION
@VDM.private:true
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #BLOCKED_DATA_INCLUDED
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Acdoca Exclude 8/9 GL accounts'
define view P_RO_SAFTJournalEntryItemExc
  with parameters

    P_AlternativeGLAccountIsUsed : saft_ro_alt_gl_account_flag

  as select from P_RO_SAFTJournalEntryItemBase (P_AlternativeGLAccountIsUsed: $parameters.P_AlternativeGLAccountIsUsed) as Item
    inner join   I_RO_SAFTAccountMapping                                                                                as Account on  Account.ChartOfAccounts = Item.ActiveChartOfAccounts
                                                                                                                                   and Account.GLAccount       = Item.ActiveGLAccount
{
  key Item.SourceLedger,
  key Item.CompanyCode,
  key Item.FiscalYear,
  key Item.AccountingDocument,
  key Item.LedgerGLLineItem,
  key Item.Ledger,
      Item.AccountingDocumentCategory,
      Item.AccountingDocumentItem,
      Item.FinancialAccountType,
      Item.Customer,
      Item.Supplier,
      Item.DebitCreditCode,
      Item.Product,
      Item.Plant,
      Item.TaxCode,
      Item.TaxCountry,
      Item.ChartOfAccounts,
      Item.ActiveChartOfAccounts,
      Item.GLAccount,
      Item.ActiveGLAccount,
      Item.GLAccountType,
      Item.CountryChartOfAccounts,
      Item.AlternativeGLAccount,
      Item.PostingDate,
      Item.DocumentDate,
      Item._JournalEntry.AccountingDocumentCreationDate,
      Item._JournalEntry.AccountingDocCreatedByUser,
      Item.AccountingDocumentType,
      Item.ValueDate,
      Item.DocumentItemText,
      Item.BaseUnit,
      Item.ControllingArea,
      Item.ProfitCenter,
      Item._ProfitCenterTxt,
      Item.Segment,
      Item._SegmentText,
      Item.CostCenter,
      Item._CostCenterTxt,
      Item.OrderID,
      Item._Order,
      Item.WBSElement,
      Item.WBSElementInternalID,
      Item._WBSElementBasicDataText,
      Item.TransactionTypeDetermination,

      Item._AccountingDocumentTypeText,

      Item._Customer,
      Item._Supplier,

      Item.AmountInCompanyCodeCurrency,

      @Semantics.currencyCode:true
      Item.CompanyCodeCurrency,

      Item.AmountInTransactionCurrency,

      @Semantics.currencyCode:true
      Item.TransactionCurrency,
      Item.LogicalSystem,
      Item.Quantity,
      Item.ReferenceQuantity,
      Item.ReferenceQuantityUnit,
      Item.SpecialGLCode,
      Item.DebitAmountInCoCodeCrcy,
      Item.CreditAmountInCoCodeCrcy,
      Item._JournalEntry,

      Item.ReferenceDocument,
      Item.ReferenceDocumentContext,
      Item.ReferenceDocumentItem,
      Item.ReferenceDocumentItemGroup,
      Item.ReferenceDocumentType,
      Item.BillingDocumentType,

      Account.RO_SAFTStandardAccount,
      Account.RO_SAFTIsDefaultZeroQuantity

}
where
  Account.GLAccountIsNotProdnRelevant is initial

Learn More