C_PE_StRpJournalEntryItemCube

DDL: C_PE_STRPJOURNALENTRYITEMCUBE SQL: CPEJNLENTITMCB Type: view CONSUMPTION Package: GLO_FIN_IS_PE
82 Fields 1 Data Sources

Journal Entry Item Cube View for Peru

C_PE_StRpJournalEntryItemCube is a Consumption CDS View (Cube) that provides data about "Journal Entry Item Cube View for Peru" in SAP S/4HANA. It reads from 1 data source (P_PE_StRpJournalEntryItem) and exposes 82 fields with key fields SourceLedger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem. Part of development package GLO_FIN_IS_PE.

Data Sources (1)

SourceAliasJoin Type
P_PE_StRpJournalEntryItem P_PE_StRpJournalEntryItem from

Parameters (3)

NameTypeDefault
P_ReportingPeriodStartDate fis_rep_period_start_date
P_AlternativeGLAccount allgaltk
P_ReportingCurrency glo_reporting_currency

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CPEJNLENTITMCB view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
EndUserText.label Journal Entry Item Cube View for Peru view
Metadata.allowExtensions true view

Fields (82)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger SourceLedger Source Ledger
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
KEY Ledger Ledger Ledger
KEY StatryRptRunID StatryRptRunID Report Run ID
KEY StatryRptgEntity StatryRptgEntity Reporting Entity
KEY StatryRptCategory StatryRptCategory Report ID
AccountingDocumentCategory AccountingDocumentCategory Journal Entry Category
AlternativeGLAccount AlternativeGLAccount Group Account
AccountingDocumentExtendedID AccountingDocumentExtendedID
ExternalItemID ExternalItemID
CalendarYearMonth CalendarYearMonth
AccountingDocumentItem AccountingDocumentItem Posting View Item
LedgerFiscalYear LedgerFiscalYear
FiscalYearVariant FiscalYearVariant FY Variant
ChartOfAccounts ChartOfAccounts Node Class
CountryChartOfAccounts CountryChartOfAccounts Chart of Accts
ControllingArea ControllingArea Controlling Area
AccountingDocumentType AccountingDocumentType Journal Entry Type
FinancialTransactionType FinancialTransactionType Transact. Type
BusinessTransactionType BusinessTransactionType Bus.transaction
ReferenceDocument ReferenceDocument Reference Document
ReferenceDocumentItem ReferenceDocumentItem Reference item
ReferenceDocumentItemGroup ReferenceDocumentItemGroup Reference Document Item Group
IsReversal IsReversal Reversal doc.
IsReversed IsReversed Reversed?
ReversalReferenceDocumentCntxt ReversalReferenceDocumentCntxt Reversal Reference Document Context
ReversalReferenceDocument ReversalReferenceDocument Reversal Reference Document
CostCenter CostCenter Cost Center
ProfitCenter ProfitCenter Profit Center
FunctionalArea FunctionalArea Sendr Fctl Area
BusinessArea BusinessArea Business Area
Segment Segment Segment number
PartnerCostCenter PartnerCostCenter Sender Cost Ctr
PartnerProfitCenter PartnerProfitCenter Profit Center
PartnerBusinessArea PartnerBusinessArea Trdg Part.BA
ODNDocumentClass ODNDocumentClass
DocumentReferenceID DocumentReferenceID Reference
PE_OfficialDocumentType PE_OfficialDocumentType
PE_DocumentSerialNumber PE_DocumentSerialNumber
PE_OfficialDocumentNumber PE_OfficialDocumentNumber
ExternalReferenceDocumentType
SerialNumber
InvoiceNumber
DocumentDate DocumentDate Journal Entry Date
PostingDate PostingDate Posting Date for GR
ReportingDate ReportingDate
ClearingDate ClearingDate Clearing Date
ClearingJournalEntry ClearingJournalEntry Clrng doc.
ClearingJournalEntryFiscalYear ClearingJournalEntryFiscalYear Fiscal Year of Clearing Journal Entry
FinancialAccountType FinancialAccountType Fin. Account Type
Customer Customer Sold-to Party
Supplier Supplier Supplier
CustomerName
SupplierName
BusinessPartnerName1 Broker Name
BusinessPartnerFullName BusinessPartnerFullName Broker Name
TaxNumberType TaxNumberType Tax number type
TaxNumber1 TaxNumber1 VAT Reg. No.
BusinessPartnerCountry
ExternalDocumentID
DocumentItemText DocumentItemText Text
CompanyCodeCurrency CompanyCodeCurrency Local Currency
TransactionCurrency TransactionCurrency Transaction Currency
BalanceTransactionCurrency BalanceTransactionCurrency Currency
ReportingCurrency ReportingCurrency Currency
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
CreditAmountInTransCrcy CreditAmountInTransCrcy Credit Amt in DC
CreditAmountInGlobalCrcy CreditAmountInGlobalCrcy
CreditAmountInBalanceTransCrcy CreditAmountInBalanceTransCrcy Credit Amount in Balance Trans. Currency
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
DebitAmountInTransCrcy DebitAmountInTransCrcy Debit Amt in DC
DebitAmountInGlobalCrcy DebitAmountInGlobalCrcy
DebitAmountInBalanceTransCrcy DebitAmountInBalanceTransCrcy Debit Amount in Balance Trans. Currency
BaseUnit BaseUnit Unit of Measure
AssignmentReference AssignmentReference Assignment Reference
BankInternalID BankInternalID Bank Key
BankAccountNumber BankAccountNumber Bank Account
BankAccountCurrency BankAccountCurrency Currency

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_PE_StRpJournalEntryItemCube.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CPEJNLENTITMCB
-- Parameters: P_ReportingPeriodStartDate : fis_rep_period_start_date, P_AlternativeGLAccount : allgaltk, P_ReportingCurrency : glo_reporting_currency

CREATE VIEW C_PE_StRpJournalEntryItemCube AS
SELECT
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  Ledger,
  StatryRptRunID,
  StatryRptgEntity,
  StatryRptCategory,
  AccountingDocumentCategory,
  AlternativeGLAccount,
  AccountingDocumentExtendedID,
  ExternalItemID,
  CalendarYearMonth,
  AccountingDocumentItem,
  LedgerFiscalYear,
  FiscalYearVariant,
  ChartOfAccounts,
  CountryChartOfAccounts,
  ControllingArea,
  AccountingDocumentType,
  FinancialTransactionType,
  BusinessTransactionType,
  ReferenceDocument,
  ReferenceDocumentItem,
  ReferenceDocumentItemGroup,
  IsReversal,
  IsReversed,
  ReversalReferenceDocumentCntxt,
  ReversalReferenceDocument,
  CostCenter,
  ProfitCenter,
  FunctionalArea,
  BusinessArea,
  Segment,
  PartnerCostCenter,
  PartnerProfitCenter,
  PartnerBusinessArea,
  ODNDocumentClass,
  DocumentReferenceID,
  PE_OfficialDocumentType,
  PE_DocumentSerialNumber,
  PE_OfficialDocumentNumber,
  cast( '' as xblnr ) AS ExternalReferenceDocumentType,
  cast( '' as gernr ) AS SerialNumber,
  cast( '' as rebzg ) AS InvoiceNumber,
  DocumentDate,
  PostingDate,
  ReportingDate,
  ClearingDate,
  ClearingJournalEntry,
  ClearingJournalEntryFiscalYear,
  FinancialAccountType,
  Customer,
  Supplier,
  cast( '' as md_customer_name ) AS CustomerName,
  cast( '' as md_supplier_name ) AS SupplierName,
  cast( BusinessPartnerFullName as ad_name1 ) AS BusinessPartnerName1,
  BusinessPartnerFullName,
  TaxNumberType,
  TaxNumber1,
  cast( '' as glo_partner_country ) AS BusinessPartnerCountry,
  cast( '' as fipe_external_doc_id ) AS ExternalDocumentID,
  DocumentItemText,
  CompanyCodeCurrency,
  TransactionCurrency,
  BalanceTransactionCurrency,
  ReportingCurrency,
  GlobalCurrency,
  CreditAmountInCoCodeCrcy,
  CreditAmountInTransCrcy,
  CreditAmountInGlobalCrcy,
  CreditAmountInBalanceTransCrcy,
  DebitAmountInCoCodeCrcy,
  DebitAmountInTransCrcy,
  DebitAmountInGlobalCrcy,
  DebitAmountInBalanceTransCrcy,
  BaseUnit,
  AssignmentReference,
  BankInternalID,
  BankAccountNumber,
  BankAccountCurrency
FROM P_PE_StRpJournalEntryItem
;

Learn More