C_StRpOplAcctgDocumentItemCube

Opl Acc.Doc.Item Cube for Stat.Reporting | view: CSROPACCTDOCITCU | TRAN | Extraction: Not supported | Component: Financials Poland
Column Name Description
CompanyCode FK Company Code
AccountingDocument Journal Entry
FiscalYear Fiscal Year
AccountingDocumentItem Journal Entry Posting View Item
StatryRptgEntity FK Reporting Entity
StatryRptCategory FK Report Category ID
StatryRptRunID Report Run ID
Column Name Description
💲 Transaction Currency (TransactionCurrency):
DebitAmountInTransCrcy null
CreditAmountInTransCrcy null
💲 Company Code Currency (CompanyCodeCurrency):
DebitAmountInCoCodeCrcy null
CreditAmountInCoCodeCrcy null
Column Name Description
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
ClearingDate Clearing Date
Column Name Description
FinancialAccountType Account Type Show values
AccountingDocumentCategory Journal Entry Category Show values
DebitCreditCode Debit/Credit Code Show values
Column Name Description Domain name
GLAccountLongName G/L Account Long Text TEXT50
SupplierName Name of Supplier TEXT80
CustomerName Name of Customer TEXT80
AssignmentReference Assignment Reference ZUONR
DocumentItemText Item Text TEXT50
DocumentReferenceID Document Reference ID XBLNR1
AccountingDocCreatedByUser User that created the journal entry
ClearingAccountingDocument Clearing Journal Entry BELNR
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • C_STRPOPLACCTGDOCUMENTITEMCUBE.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_STRPOPLACCTGDOCUMENTITEMCUBE.MANDT == T003.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • C_STRPOPLACCTGDOCUMENTITEMCUBE.CHARTOFACCOUNTS == T004.KTOPL
  • C_STRPOPLACCTGDOCUMENTITEMCUBE.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • C_STRPOPLACCTGDOCUMENTITEMCUBE.COMPANYCODE == T001.BUKRS
  • C_STRPOPLACCTGDOCUMENTITEMCUBE.MANDT == T001.MANDT
Customer Number
  • Customer Number
  • Client
  • C_STRPOPLACCTGDOCUMENTITEMCUBE.CUSTOMER == KNA1.KUNNR
  • C_STRPOPLACCTGDOCUMENTITEMCUBE.MANDT == KNA1.MANDT
G/L Account
  • G/L Account
  • Company Code
  • Client
  • C_STRPOPLACCTGDOCUMENTITEMCUBE.GLACCOUNT == SKB1.SAKNR
  • C_STRPOPLACCTGDOCUMENTITEMCUBE.COMPANYCODE == SKB1.BUKRS
  • C_STRPOPLACCTGDOCUMENTITEMCUBE.MANDT == SKB1.MANDT
Posting Key
  • Posting Key
  • Client
  • C_STRPOPLACCTGDOCUMENTITEMCUBE.POSTINGKEY == TBSL.BSCHL
  • C_STRPOPLACCTGDOCUMENTITEMCUBE.MANDT == TBSL.MANDT
Special G/L Indicator
  • ?
  • Client
  • Special G/L Indicator
  • C_STRPOPLACCTGDOCUMENTITEMCUBE.[column in domain "KOART"] == T074U.KOART
  • C_STRPOPLACCTGDOCUMENTITEMCUBE.MANDT == T074U.MANDT
  • C_STRPOPLACCTGDOCUMENTITEMCUBE.SPECIALGLCODE == T074U.UMSKZ
Reporting Entity
  • Client
  • Reporting Entity
  • C_STRPOPLACCTGDOCUMENTITEMCUBE.MANDT == SRF_RPG_ENT.MANDT
  • C_STRPOPLACCTGDOCUMENTITEMCUBE.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Supplier
  • Supplier
  • Client
  • C_STRPOPLACCTGDOCUMENTITEMCUBE.SUPPLIER == LFA1.LIFNR
  • C_STRPOPLACCTGDOCUMENTITEMCUBE.MANDT == LFA1.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • C_STRPOPLACCTGDOCUMENTITEMCUBE.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_STRPOPLACCTGDOCUMENTITEMCUBE.MANDT == TCURC.MANDT