C_PE_StRpJournalEntryItemQuery

DDL: C_PE_STRPJOURNALENTRYITEMQUERY SQL: CPEJENTRYITEMQ Type: view CONSUMPTION Package: GLO_FIN_IS_PE
92 Fields 1 Data Sources

Peru Journal Entry Query View

C_PE_StRpJournalEntryItemQuery is a Consumption CDS View that provides data about "Peru Journal Entry Query View" in SAP S/4HANA. It reads from 1 data source (C_PE_StRpJournalEntryItemCube) and exposes 92 fields with key fields CalendarYearMonth, AccountingDocumentExtendedID, ExternalItemID, SourceLedger, CompanyCode. Part of development package GLO_FIN_IS_PE.

Data Sources (1)

SourceAliasJoin Type
C_PE_StRpJournalEntryItemCube C_PE_StRpJournalEntryItemCube from

Parameters (3)

NameTypeDefault
P_ReportingPeriodStartDate fis_rep_period_start_date
P_AlternativeGLAccount allgaltk
P_ReportingCurrency glo_reporting_currency

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CPEJENTRYITEMQ view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
Analytics.query true view
EndUserText.label Peru Journal Entry Query View view

Fields (92)

KeyFieldSource TableSource FieldDescription
KEY CalendarYearMonth CalendarYearMonth
KEY AccountingDocumentExtendedID AccountingDocumentExtendedID
KEY ExternalItemID ExternalItemID
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 StatryRptCategory StatryRptCategory Report ID
KEY StatryRptgEntity StatryRptgEntity Reporting Entity
KEY StatryRptRunID StatryRptRunID Report Run ID
AccountingDocumentCategory AccountingDocumentCategory Journal Entry Category
GLAccount GLAccount General Ledger
AlternativeGLAccount AlternativeGLAccount Group Account
GLAccountName GLAccountName Short Text
ReportingDate ReportingDate
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 ExternalReferenceDocumentType
SerialNumber SerialNumber Serial Number
InvoiceNumber InvoiceNumber Invoice Number
DocumentDate DocumentDate Journal Entry Date
PostingDate PostingDate Posting Date for GR
ClearingDate ClearingDate Clearing Date
ClearingJournalEntry ClearingJournalEntry Clrng doc.
ClearingJournalEntryFiscalYear ClearingJournalEntryFiscalYear Fiscal Year of Clearing Journal Entry
FinancialAccountType FinancialAccountType Fin. Account Type
CustomerName CustomerName Name of Customer
Customer Customer Sold-to Party
Supplier Supplier Supplier
SupplierName SupplierName Supplier Name
BusinessPartnerName1 BusinessPartnerName1 Name
TaxNumberType TaxNumberType Tax number type
TaxNumber1 TaxNumber1 VAT Reg. No.
BusinessPartnerCountry BusinessPartnerCountry BP Ctry/Reg.
ExternalDocumentID ExternalDocumentID Ext. Reference ID
PE_CARIdentifier PE_CARIdentifier
DocumentItemText DocumentItemText Text
BusinessOperationStatus BusinessOperationStatus
AssignmentReference AssignmentReference Assignment Reference
BaseUnit BaseUnit Unit of Measure
Quantity Quantity Value
BankInternalID BankInternalID Bank Key
BankAccountNumber BankAccountNumber Bank Account
BankAccountCurrency BankAccountCurrency Currency
CompanyCodeCurrency CompanyCodeCurrency Local Currency
TransactionCurrency TransactionCurrency Transaction Currency
BalanceTransactionCurrency BalanceTransactionCurrency Currency
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
ReportingCurrency ReportingCurrency Currency
CreditAmountInReportingCrcy CreditAmountInReportingCrcy
DebitAmountInReportingCurrency DebitAmountInReportingCurrency
AmountInReportingCurrency AmountInReportingCurrency
DebitEndingBalAmtInRptgCrcy
CreditEndingBalAmtInRptgCrcy
UnitPriceAmountInReportingCrcy UnitPriceAmountInReportingCrcy
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

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_StRpJournalEntryItemQuery.
-- 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: CPEJENTRYITEMQ
-- Parameters: P_ReportingPeriodStartDate : fis_rep_period_start_date, P_AlternativeGLAccount : allgaltk, P_ReportingCurrency : glo_reporting_currency

CREATE VIEW C_PE_StRpJournalEntryItemQuery AS
SELECT
  CalendarYearMonth,
  AccountingDocumentExtendedID,
  ExternalItemID,
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  Ledger,
  StatryRptCategory,
  StatryRptgEntity,
  StatryRptRunID,
  AccountingDocumentCategory,
  GLAccount,
  AlternativeGLAccount,
  GLAccountName,
  ReportingDate,
  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,
  ExternalReferenceDocumentType,
  SerialNumber,
  InvoiceNumber,
  DocumentDate,
  PostingDate,
  ClearingDate,
  ClearingJournalEntry,
  ClearingJournalEntryFiscalYear,
  FinancialAccountType,
  CustomerName,
  Customer,
  Supplier,
  SupplierName,
  BusinessPartnerName1,
  TaxNumberType,
  TaxNumber1,
  BusinessPartnerCountry,
  ExternalDocumentID,
  PE_CARIdentifier,
  DocumentItemText,
  BusinessOperationStatus,
  AssignmentReference,
  BaseUnit,
  Quantity,
  BankInternalID,
  BankAccountNumber,
  BankAccountCurrency,
  CompanyCodeCurrency,
  TransactionCurrency,
  BalanceTransactionCurrency,
  GlobalCurrency,
  ReportingCurrency,
  CreditAmountInReportingCrcy,
  DebitAmountInReportingCurrency,
  AmountInReportingCurrency,
  cast( 0 as glo_db_endg_bal_amt_rptg_crcy ) AS DebitEndingBalAmtInRptgCrcy,
  cast( 0 as glo_cr_endg_bal_amt_rptg_crcy ) AS CreditEndingBalAmtInRptgCrcy,
  UnitPriceAmountInReportingCrcy,
  CreditAmountInCoCodeCrcy,
  CreditAmountInTransCrcy,
  CreditAmountInGlobalCrcy,
  CreditAmountInBalanceTransCrcy,
  DebitAmountInCoCodeCrcy,
  DebitAmountInTransCrcy,
  DebitAmountInGlobalCrcy,
  DebitAmountInBalanceTransCrcy
FROM C_PE_StRpJournalEntryItemCube
;

Learn More