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. 9 CDS views read from this table.

Used by 9 CDS view(s)

CDS Views using this table (9)

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
C_RO_SAFTUnitOfMeasure view inner CONSUMPTION Unit Of Measure
P_RO_SAFTAnalysisTypeItem view from CONSUMPTION
P_RO_SAFTAnalysisTypeItem view union_all CONSUMPTION
P_RO_SAFTJournalEntryItem view inner CONSUMPTION
P_RO_SAFTPaymnetItemNew view inner CONSUMPTION SAFT RO Payment Item
P_RO_SAFTSalesInvoiceItem view inner CONSUMPTION
P_RO_SAFTSalInvHdr1 view inner CONSUMPTION Sales Inv Header for RO SAFT Base 1 
@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)
{
  key SourceLedger,
  key CompanyCode,
  key FiscalYear,
  key AccountingDocument,
  key LedgerGLLineItem,
  key Ledger,
      AccountingDocumentCategory,
      AccountingDocumentItem,
      FinancialAccountType,
      Customer,
      Supplier,
      DebitCreditCode,
      Product,
      Plant,
      TaxCode,
      TaxCountry,
      ChartOfAccounts,
      ActiveChartOfAccounts,
      GLAccount,
      ActiveGLAccount,
      GLAccountType,
      CountryChartOfAccounts,
      AlternativeGLAccount,
      PostingDate,
      DocumentDate,
      _JournalEntry.AccountingDocumentCreationDate,
      _JournalEntry.AccountingDocCreatedByUser,
      AccountingDocumentType,
      ValueDate,
      DocumentItemText,
      BaseUnit,
      ControllingArea,
      ProfitCenter,
      _ProfitCenterTxt,
      Segment,
      _SegmentText,
      CostCenter,
      _CostCenterTxt,
      OrderID,
      _Order,
      WBSElement,
      WBSElementInternalID,
      _WBSElementBasicDataText,
      TransactionTypeDetermination,

      _AccountingDocumentTypeText,

      _Customer,
      _Supplier,

      AmountInCompanyCodeCurrency,

      @Semantics.currencyCode:true
      CompanyCodeCurrency,

      AmountInTransactionCurrency,

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

}
where
      ActiveGLAccount not like '8%'
  and ActiveGLAccount not like '08%'
  and ActiveGLAccount not like '008%'
  and ActiveGLAccount not like '0008%'
  and ActiveGLAccount not like '00008%'
  and ActiveGLAccount not like '000008%'
  and ActiveGLAccount not like '0000008%'
  and ActiveGLAccount not like '00000008%'
  and ActiveGLAccount not like '000000008%'
  and ActiveGLAccount not like '0000000008%'
  and ActiveGLAccount not like '00000000008%'
  and ActiveGLAccount not like '9%'
  and ActiveGLAccount not like '09%'
  and ActiveGLAccount not like '009%'
  and ActiveGLAccount not like '0009%'
  and ActiveGLAccount not like '00009%'
  and ActiveGLAccount not like '000009%'
  and ActiveGLAccount not like '0000009%'
  and ActiveGLAccount not like '00000009%'
  and ActiveGLAccount not like '000000009%'
  and ActiveGLAccount not like '0000000009%'
  and ActiveGLAccount not like '00000000009%'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_JOURNALENTRY",
"P_RO_SAFTJOURNALENTRYITEMBASE"
],
"ASSOCIATED":
[
"I_ACCOUNTINGDOCUMENTTYPETEXT",
"I_COSTCENTERTEXT",
"I_CUSTOMER",
"I_JOURNALENTRY",
"I_ORDER",
"I_PROFITCENTERTEXT",
"I_SEGMENTTEXT",
"I_SUPPLIER",
"I_WBSELEMENTBASICDATA"
],
"BASE":
[
"P_RO_SAFTJOURNALENTRYITEMBASE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More