P_RO_SAFTJournalEntryItemBase

DDL: P_RO_SAFTJOURNALENTRYITEMBASE SQL: PROSAFTJRNENITMB Type: view CONSUMPTION

RO SAFT acdoca

P_RO_SAFTJournalEntryItemBase is a Consumption CDS View that provides data about "RO SAFT acdoca" in SAP S/4HANA. It reads from 1 data source (I_JournalEntryItem) and exposes 61 fields with key fields SourceLedger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem.

1 data source(s) 61 fields

Data Sources (1)

SourceAliasJoin Type
I_JournalEntryItem I_JournalEntryItem from

Parameters (1)

NameTypeDefault
P_AlternativeGLAccountIsUsed saft_ro_alt_gl_account_flag

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PROSAFTJRNENITMB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
VDM.private true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label RO SAFT acdoca view

Fields (61)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger SourceLedger
KEY CompanyCode CompanyCode
KEY FiscalYear FiscalYear
KEY AccountingDocument AccountingDocument
KEY LedgerGLLineItem LedgerGLLineItem
KEY Ledger Ledger
AccountingDocumentCategory AccountingDocumentCategory
AccountingDocumentItem AccountingDocumentItem
FinancialAccountType FinancialAccountType
Customer Customer
Supplier Supplier
DebitCreditCode DebitCreditCode
Product Product
Plant Plant
TaxCode TaxCode
TaxCountry TaxCountry
ChartOfAccounts ChartOfAccounts
GLAccount GLAccount
GLAccountType GLAccountType
CountryChartOfAccounts _CompanyCode CountryChartOfAccounts
AlternativeGLAccount _GLAccountInCompanyCode AlternativeGLAccount
PostingDate PostingDate
DocumentDate DocumentDate
AccountingDocumentCreationDate _JournalEntry AccountingDocumentCreationDate
AccountingDocCreatedByUser _JournalEntry AccountingDocCreatedByUser
AccountingDocumentType AccountingDocumentType
ValueDate ValueDate
DocumentItemText DocumentItemText
BaseUnit BaseUnit
ControllingArea ControllingArea
ProfitCenter ProfitCenter
_ProfitCenterTxt _ProfitCenterTxt
Segment Segment
_SegmentText _SegmentText
CostCenter CostCenter
_CostCenterTxt _CostCenterTxt
OrderID OrderID
_Order _Order
WBSElement WBSElement
WBSElementInternalID WBSElementInternalID
_WBSElementBasicDataText _WBSElementBasicDataText
TransactionTypeDetermination TransactionTypeDetermination
_AccountingDocumentTypeText _AccountingDocumentTypeText
_Customer _Customer
_Supplier _Supplier
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency
CompanyCodeCurrency CompanyCodeCurrency
AmountInTransactionCurrency AmountInTransactionCurrency
TransactionCurrency TransactionCurrency
LogicalSystem LogicalSystem
Quantity Quantity
ReferenceQuantity ReferenceQuantity
ReferenceQuantityUnit ReferenceQuantityUnit
SpecialGLCode SpecialGLCode
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy
_JournalEntry _JournalEntry
ReferenceDocument ReferenceDocument
ReferenceDocumentContext ReferenceDocumentContext
ReferenceDocumentItem ReferenceDocumentItem
ReferenceDocumentItemGroup ReferenceDocumentItemGroup 
@AbapCatalog.sqlViewName: 'PROSAFTJRNENITMB'
@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: 'RO SAFT acdoca'
define view P_RO_SAFTJournalEntryItemBase
  with parameters

    P_AlternativeGLAccountIsUsed : saft_ro_alt_gl_account_flag

  as select from I_JournalEntryItem
{
  key SourceLedger,
  key CompanyCode,
  key FiscalYear,
  key AccountingDocument,
  key LedgerGLLineItem,
  key Ledger,
      AccountingDocumentCategory,
      AccountingDocumentItem,
      FinancialAccountType,
      Customer,
      Supplier,
      DebitCreditCode,
      Product,
      Plant,
      TaxCode,
      TaxCountry,
      ChartOfAccounts,
      case $parameters.P_AlternativeGLAccountIsUsed
        when 'X' then _CompanyCode.CountryChartOfAccounts
        else ChartOfAccounts
      end as ActiveChartOfAccounts,
      GLAccount,
      case $parameters.P_AlternativeGLAccountIsUsed
        when 'X' then _GLAccountInCompanyCode.AlternativeGLAccount
        else GLAccount
      end as ActiveGLAccount,
      GLAccountType,
      _CompanyCode.CountryChartOfAccounts,
      _GLAccountInCompanyCode.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,

      ReferenceDocument,
      ReferenceDocumentContext,
      ReferenceDocumentItem,
      ReferenceDocumentItemGroup

}
where AmountInCompanyCodeCurrency is not initial or AmountInTransactionCurrency is not initial

Learn More