C_PL_SAFTJournalEntryItemCube

DDL: C_PL_SAFTJOURNALENTRYITEMCUBE SQL: CPLSAFTJNLENTITC Type: view CONSUMPTION

SAFT PL Journal Entry Item Cube

C_PL_SAFTJournalEntryItemCube is a Consumption CDS View (Cube) that provides data about "SAFT PL Journal Entry Item Cube" in SAP S/4HANA. It reads from 1 data source (I_JournalEntryItem) and exposes 20 fields with key fields SourceLedger, CompanyCode, AccountingDocument, FiscalYear, LedgerGLLineItem. It has 1 association to related views.

1 data source(s) 20 fields

Data Sources (1)

SourceAliasJoin Type
I_JournalEntryItem I_JournalEntryItem from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_StRpJournalEntryLog _ReportedItemsLog $projection.CompanyCode = _ReportedItemsLog.CompanyCode and $projection.AccountingDocument = _ReportedItemsLog.AccountingDocument and $projection.FiscalYear = _ReportedItemsLog.FiscalYear

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CPLSAFTJNLENTITC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
Analytics.dataCategory #CUBE view
Metadata.allowExtensions true view
Analytics.internalName #LOCAL view
EndUserText.label SAFT PL Journal Entry Item Cube view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger SourceLedger
KEY CompanyCode CompanyCode
KEY AccountingDocument AccountingDocument
KEY FiscalYear FiscalYear
KEY LedgerGLLineItem LedgerGLLineItem
KEY Ledger Ledger
KEY StatryRptCategory _ReportedItemsLog StatryRptCategory
KEY StatryRptgEntity _ReportedItemsLog StatryRptgEntity
KEY StatryRptRunID _ReportedItemsLog StatryRptRunID
PostingDate PostingDate
ChartOfAccounts ChartOfAccounts
GLAccount GLAccount
DocumentItemText DocumentItemText
CompanyCodeCurrency CompanyCodeCurrency
TransactionCurrency TransactionCurrency
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy
DebitAmountInTransCrcy DebitAmountInTransCrcy
CreditAmountInCoCodeCrcy
CreditAmountInTransCrcy
_JournalEntry _JournalEntry 
@AbapCatalog.sqlViewName: 'CPLSAFTJNLENTITC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Analytics.dataCategory: #CUBE
@Metadata.allowExtensions:true
@Analytics.internalName:#LOCAL
@EndUserText.label: 'SAFT PL Journal Entry Item Cube'
define view C_PL_SAFTJournalEntryItemCube
  as select from I_JournalEntryItem

  association [0..*] to I_StRpJournalEntryLog as _ReportedItemsLog on  $projection.CompanyCode        = _ReportedItemsLog.CompanyCode
                                                                   and $projection.AccountingDocument = _ReportedItemsLog.AccountingDocument
                                                                   and $projection.FiscalYear         = _ReportedItemsLog.FiscalYear
{
  key  SourceLedger,
  key  CompanyCode,
  key  AccountingDocument,
  key  FiscalYear,
  key  LedgerGLLineItem,
  key  Ledger,
  key  _ReportedItemsLog.StatryRptCategory,
  key  _ReportedItemsLog.StatryRptgEntity,
  key  _ReportedItemsLog.StatryRptRunID,

       PostingDate,

       ChartOfAccounts,
       GLAccount,

       DocumentItemText,

       @Semantics.currencyCode: true
       CompanyCodeCurrency,
       @Semantics.currencyCode: true
       TransactionCurrency,

       @DefaultAggregation:#SUM
       @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
       DebitAmountInCoCodeCrcy,
       @DefaultAggregation:#SUM
       @Semantics.amount.currencyCode: 'TransactionCurrency'
       DebitAmountInTransCrcy,

       @DefaultAggregation:#SUM
       @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
       cast(- CreditAmountInCoCodeCrcy as fis_cr_hsl) as CreditAmountInCoCodeCrcy,
       @DefaultAggregation:#SUM
       @Semantics.amount.currencyCode: 'TransactionCurrency'
       cast(- CreditAmountInTransCrcy as fis_cr_wsl)  as CreditAmountInTransCrcy,

       _JournalEntry
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_JOURNALENTRYITEM",
"I_STRPJOURNALENTRYLOG"
],
"ASSOCIATED":
[
"I_JOURNALENTRY",
"I_STRPJOURNALENTRYLOG"
],
"BASE":
[
"I_JOURNALENTRYITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More