C_PE_StRpJournalEntryItemCube

Journal Entry Item Cube View for Peru | view: CPEJNLENTITMCB | TRAN | Extraction: Not supported | Component: Financials Peru
Tables used: BSEC, ACCT_SRF_REP_ITM, ACCT_SRF_RPIT_TI, ACCT_SRF_RPIT_WI, ACDOCA, BKPF, T001, TKA02, KNA1, LFA1, T003_I, FINSC_LEDGER_REP
Column Name Description
SourceLedger FK Source Ledger
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Ledger FK Ledger in General Ledger Accounting
StatryRptRunID Report Run ID
StatryRptgEntity FK Reporting Entity
StatryRptCategory FK Report Category ID
Column Name Description
💲 Reporting Currency (ReportingCurrency):
CreditAmountInReportingCrcy Credit Amount in Reporting Currency
DebitAmountInReportingCurrency Debit Amount in Reporting Currency
CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
CreditAmountInTransCrcy Credit Amount in Transaction Currency
CreditAmountInGlobalCrcy Credit Amount in Global Currency
CreditAmountInBalanceTransCrcy Credit Amount in Balance Transaction Currency
DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
DebitAmountInTransCrcy Debit Amount in Transaction Currency
DebitAmountInGlobalCrcy Debit Amount in Global Currency
DebitAmountInBalanceTransCrcy Debit Amount in Balance Transaction Currency
Column Name Description
Column Name Description
DocumentDate Journal Entry Date
PostingDate Posting Date
ClearingDate Clearing Date
ReportingDate Tax Reporting Date
Column Name Description
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
FinancialAccountType Account Type Show values
BusinessOperationStatus Operation Status Show values
Column Name Description Domain name
GLAccount G/L Account SAKNR
AccountingDocumentExtendedID Unique Operation Code
ExternalItemID External Item Identification
CalendarYearMonth Calendar Year and Month
AccountingDocumentItem Journal Entry Posting View Item BUZEI
LedgerFiscalYear Ledger Fiscal Year GJAHR
ReferenceDocument Reference document number AWREF
ReferenceDocumentItem Reference Document Item NUMC6
ReferenceDocumentItemGroup Reference Document Item Group NUMC6
ReversalReferenceDocumentCntxt Reversal Reference Document Context AWORG
ReversalReferenceDocument Reversal Reference Document AWREF
DocumentReferenceID Document Reference ID XBLNR1
ExternalReferenceDocumentType Document Type
SerialNumber Document Serial Number
InvoiceNumber Official Document Number
TaxNumberType Tax Number Type J_1ATOID
TaxNumber1 Tax Number 1 STCD1
BusinessPartnerCountry Business Partner Country/Region Key LAND1
DocumentItemText Item Text TEXT50
ExternalDocumentID External Document Identification
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • C_PE_STRPJOURNALENTRYITEMCUBE.MANDT == T003.MANDT
  • C_PE_STRPJOURNALENTRYITEMCUBE.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Alternative G/L Account Number In Company Code
  • Alternative Chart of Accounts for Country/Region
  • Client
  • Alternative G/L Account Number In Company Code
  • C_PE_STRPJOURNALENTRYITEMCUBE.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL
  • C_PE_STRPJOURNALENTRYITEMCUBE.MANDT == SKA1.MANDT
  • C_PE_STRPJOURNALENTRYITEMCUBE.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • C_PE_STRPJOURNALENTRYITEMCUBE.MANDT == TCURC.MANDT
  • C_PE_STRPJOURNALENTRYITEMCUBE.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Business Area
  • Client
  • Business Area
  • C_PE_STRPJOURNALENTRYITEMCUBE.MANDT == TGSB.MANDT
  • C_PE_STRPJOURNALENTRYITEMCUBE.BUSINESSAREA == TGSB.GSBER
Business Transaction Type
  • Client
  • Business Transaction Type
Chart of Accounts
  • Client
  • Chart of Accounts
  • C_PE_STRPJOURNALENTRYITEMCUBE.MANDT == T004.MANDT
  • C_PE_STRPJOURNALENTRYITEMCUBE.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • C_PE_STRPJOURNALENTRYITEMCUBE.MANDT == T001.MANDT
  • C_PE_STRPJOURNALENTRYITEMCUBE.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • C_PE_STRPJOURNALENTRYITEMCUBE.MANDT == TCURC.MANDT
  • C_PE_STRPJOURNALENTRYITEMCUBE.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Controlling Area
  • Client
  • C_PE_STRPJOURNALENTRYITEMCUBE.CONTROLLINGAREA == TKA01.KOKRS
  • C_PE_STRPJOURNALENTRYITEMCUBE.MANDT == TKA01.MANDT
Cost Center
  • ?
  • Controlling Area
  • Client
  • Cost Center
  • C_PE_STRPJOURNALENTRYITEMCUBE.[column in domain "DATBI"] == CSKS.DATBI
  • C_PE_STRPJOURNALENTRYITEMCUBE.CONTROLLINGAREA == CSKS.KOKRS
  • C_PE_STRPJOURNALENTRYITEMCUBE.MANDT == CSKS.MANDT
  • C_PE_STRPJOURNALENTRYITEMCUBE.COSTCENTER == CSKS.KOSTL
Alternative Chart of Accounts for Country/Region
  • Alternative Chart of Accounts for Country/Region
  • Client
  • C_PE_STRPJOURNALENTRYITEMCUBE.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
  • C_PE_STRPJOURNALENTRYITEMCUBE.MANDT == T004.MANDT
Customer Number
  • Client
  • Customer Number
  • C_PE_STRPJOURNALENTRYITEMCUBE.MANDT == KNA1.MANDT
  • C_PE_STRPJOURNALENTRYITEMCUBE.CUSTOMER == KNA1.KUNNR
Financial Transaction Type
  • Client
  • Financial Transaction Type
  • C_PE_STRPJOURNALENTRYITEMCUBE.MANDT == T856.MANDT
  • C_PE_STRPJOURNALENTRYITEMCUBE.FINANCIALTRANSACTIONTYPE == T856.TRTYP
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • C_PE_STRPJOURNALENTRYITEMCUBE.FISCALYEARVARIANT == T009.PERIV
  • C_PE_STRPJOURNALENTRYITEMCUBE.MANDT == T009.MANDT
Functional Area
  • Client
  • Functional Area
  • C_PE_STRPJOURNALENTRYITEMCUBE.MANDT == TFKB.MANDT
  • C_PE_STRPJOURNALENTRYITEMCUBE.FUNCTIONALAREA == TFKB.FKBER
Global Currency
  • Client
  • Global Currency
  • C_PE_STRPJOURNALENTRYITEMCUBE.MANDT == TCURC.MANDT
  • C_PE_STRPJOURNALENTRYITEMCUBE.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
  • C_PE_STRPJOURNALENTRYITEMCUBE.LEDGER == FINSC_LEDGER.RLDNR
  • C_PE_STRPJOURNALENTRYITEMCUBE.SOURCELEDGER == FINSC_LEDGER.RLDNR
  • C_PE_STRPJOURNALENTRYITEMCUBE.MANDT == FINSC_LEDGER.MANDT
Official document class
  • ?
  • Official document class
  • Client
  • C_PE_STRPJOURNALENTRYITEMCUBE.[column in domain "LAND1"] == DOCCLSS.LAND1
  • C_PE_STRPJOURNALENTRYITEMCUBE.ODNDOCUMENTCLASS == DOCCLSS.DOCCLS
  • C_PE_STRPJOURNALENTRYITEMCUBE.MANDT == DOCCLSS.MANDT
Partner Business Area
  • Client
  • Partner Business Area
  • C_PE_STRPJOURNALENTRYITEMCUBE.MANDT == TGSB.MANDT
  • C_PE_STRPJOURNALENTRYITEMCUBE.PARTNERBUSINESSAREA == TGSB.GSBER
Partner Cost Center
  • Partner Cost Center
  • ?
  • Controlling Area
  • Client
  • C_PE_STRPJOURNALENTRYITEMCUBE.PARTNERCOSTCENTER == CSKS.KOSTL
  • C_PE_STRPJOURNALENTRYITEMCUBE.[column in domain "DATBI"] == CSKS.DATBI
  • C_PE_STRPJOURNALENTRYITEMCUBE.CONTROLLINGAREA == CSKS.KOKRS
  • C_PE_STRPJOURNALENTRYITEMCUBE.MANDT == CSKS.MANDT
Partner Profit Center
  • ?
  • Controlling Area
  • Client
  • Partner Profit Center
  • C_PE_STRPJOURNALENTRYITEMCUBE.[column in domain "DATBI"] == CEPC.DATBI
  • C_PE_STRPJOURNALENTRYITEMCUBE.CONTROLLINGAREA == CEPC.KOKRS
  • C_PE_STRPJOURNALENTRYITEMCUBE.MANDT == CEPC.MANDT
  • C_PE_STRPJOURNALENTRYITEMCUBE.PARTNERPROFITCENTER == CEPC.PRCTR
Profit Center
  • ?
  • Controlling Area
  • Client
  • Profit Center
  • C_PE_STRPJOURNALENTRYITEMCUBE.[column in domain "DATBI"] == CEPC.DATBI
  • C_PE_STRPJOURNALENTRYITEMCUBE.CONTROLLINGAREA == CEPC.KOKRS
  • C_PE_STRPJOURNALENTRYITEMCUBE.MANDT == CEPC.MANDT
  • C_PE_STRPJOURNALENTRYITEMCUBE.PROFITCENTER == CEPC.PRCTR
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • C_PE_STRPJOURNALENTRYITEMCUBE.SEGMENT == FAGL_SEGM.SEGMENT
  • C_PE_STRPJOURNALENTRYITEMCUBE.MANDT == FAGL_SEGM.MANDT
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
  • C_PE_STRPJOURNALENTRYITEMCUBE.MANDT == FINSC_LEDGER.MANDT
  • C_PE_STRPJOURNALENTRYITEMCUBE.LEDGER == FINSC_LEDGER.RLDNR
  • C_PE_STRPJOURNALENTRYITEMCUBE.SOURCELEDGER == FINSC_LEDGER.RLDNR
Reporting Entity
  • Reporting Entity
  • Client
  • C_PE_STRPJOURNALENTRYITEMCUBE.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
  • C_PE_STRPJOURNALENTRYITEMCUBE.MANDT == SRF_RPG_ENT.MANDT
Supplier
  • Supplier
  • Client
  • C_PE_STRPJOURNALENTRYITEMCUBE.SUPPLIER == LFA1.LIFNR
  • C_PE_STRPJOURNALENTRYITEMCUBE.MANDT == LFA1.MANDT
Transaction Currency
  • Client
  • Transaction Currency
  • C_PE_STRPJOURNALENTRYITEMCUBE.MANDT == TCURC.MANDT
  • C_PE_STRPJOURNALENTRYITEMCUBE.TRANSACTIONCURRENCY == TCURC.WAERS