C_RO_StRpGLAcctJrnlEntryItmQry

GL Account Trial Balance Query – Romania | view: CROSRGLACTRBLITQ | Extraction: Not supported | Component: Financials Romania
Column Name Description
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
DebitCarryFwdBalAmtInCCCrcy Debit Carry Forward Balance Amount in Company Code Currency
CreditCarryFwdBalAmtInCCCrcy Credit Carry Forward Balance Amount in Company Code Currency
DebitPrevPeriodYTDAmtInCCCrcy Debit Previous Period YTD Amount in Company Code Currency
CreditPrevPeriodYTDAmtInCCCrcy Credit Previous Period YTD Amount in Company Code Currency
DebitStartingBalAmtInCCCrcy Debit Starting Balance Amount in Company Code Currency
CreditStartingBalAmtInCCCrcy Credit Starting Balance Amount in Company Code Currency
DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
YTDDebitAmtInCoCodeCrcy Debit Year to Date Amount in Company Code Currency
YTDCrdtAmtInCoCodeCrcy Credit Year to Date Amount in Company Code Currency
DebitEndingAmountInCCCrcy Debit Ending Balance Amount in Company Code Currency
CreditEndingAmountInCCCrcy Credit Ending Balance Amount in Company Code Currency
DebitEndingBalAmtInCCCrcy Debit Ending Balance Amount in Company Code Currency
CreditEndingBalAmtInCCCrcy Credit Ending Balance Amount in Company Code Currency
Column Name Description
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
Column Name Description
ItemType Line Item Type Show values
FinancialAccountType Account Type Show values
AccountingDocumentCategory Journal Entry Category Show values
DebitCreditCode Debit/Credit Code Show values
Column Name Description Domain name
AccountingDocument Journal Entry BELNR
LedgerGLLineItem Ledger Journal Entry Item DOCLN6
FiscalPeriod Fiscal Period POPER
GLAccountLongName G/L Account Long Text TEXT50
AssignmentReference Assignment Reference ZUONR
DocumentItemText Item Text TEXT50
StatryRptRunID Report Run ID SRF_REPORT_RUN_ID
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • C_RO_STRPGLACCTJRNLENTRYITMQRY.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_RO_STRPGLACCTJRNLENTRYITMQRY.MANDT == T003.MANDT
Alternative G/L Account Number In Company Code
  • Alternative G/L Account Number In Company Code
  • ?
  • Client
  • C_RO_STRPGLACCTJRNLENTRYITMQRY.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
  • C_RO_STRPGLACCTJRNLENTRYITMQRY.[column in domain "KTOPL"] == SKA1.KTOPL
  • C_RO_STRPGLACCTJRNLENTRYITMQRY.MANDT == SKA1.MANDT
Company Code
  • Company Code
  • Client
  • C_RO_STRPGLACCTJRNLENTRYITMQRY.COMPANYCODE == T001.BUKRS
  • C_RO_STRPGLACCTJRNLENTRYITMQRY.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • C_RO_STRPGLACCTJRNLENTRYITMQRY.MANDT == TCURC.MANDT
  • C_RO_STRPGLACCTJRNLENTRYITMQRY.COMPANYCODECURRENCY == TCURC.WAERS
Customer Number
  • Customer Number
  • Client
  • C_RO_STRPGLACCTJRNLENTRYITMQRY.CUSTOMER == KNA1.KUNNR
  • C_RO_STRPGLACCTJRNLENTRYITMQRY.MANDT == KNA1.MANDT
G/L Account
  • G/L Account
  • Company Code
  • Client
  • C_RO_STRPGLACCTJRNLENTRYITMQRY.GLACCOUNT == SKB1.SAKNR
  • C_RO_STRPGLACCTJRNLENTRYITMQRY.COMPANYCODE == SKB1.BUKRS
  • C_RO_STRPGLACCTJRNLENTRYITMQRY.MANDT == SKB1.MANDT
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
  • C_RO_STRPGLACCTJRNLENTRYITMQRY.MANDT == FINSC_LEDGER.MANDT
  • C_RO_STRPGLACCTJRNLENTRYITMQRY.LEDGER == FINSC_LEDGER.RLDNR
  • C_RO_STRPGLACCTJRNLENTRYITMQRY.SOURCELEDGER == FINSC_LEDGER.RLDNR
Posting Key
  • Posting Key
  • Client
  • C_RO_STRPGLACCTJRNLENTRYITMQRY.POSTINGKEY == TBSL.BSCHL
  • C_RO_STRPGLACCTJRNLENTRYITMQRY.MANDT == TBSL.MANDT
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
  • C_RO_STRPGLACCTJRNLENTRYITMQRY.MANDT == FINSC_LEDGER.MANDT
  • C_RO_STRPGLACCTJRNLENTRYITMQRY.LEDGER == FINSC_LEDGER.RLDNR
  • C_RO_STRPGLACCTJRNLENTRYITMQRY.SOURCELEDGER == FINSC_LEDGER.RLDNR
Special G/L Indicator
  • Account Type
  • Special G/L Indicator
  • Client
  • C_RO_STRPGLACCTJRNLENTRYITMQRY.FINANCIALACCOUNTTYPE == T074U.KOART
  • C_RO_STRPGLACCTJRNLENTRYITMQRY.SPECIALGLCODE == T074U.UMSKZ
  • C_RO_STRPGLACCTJRNLENTRYITMQRY.MANDT == T074U.MANDT
Reporting Entity
  • Client
  • Reporting Entity
  • C_RO_STRPGLACCTJRNLENTRYITMQRY.MANDT == SRF_RPG_ENT.MANDT
  • C_RO_STRPGLACCTJRNLENTRYITMQRY.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Supplier
  • Supplier
  • Client
  • C_RO_STRPGLACCTJRNLENTRYITMQRY.SUPPLIER == LFA1.LIFNR
  • C_RO_STRPGLACCTJRNLENTRYITMQRY.MANDT == LFA1.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • C_RO_STRPGLACCTJRNLENTRYITMQRY.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_RO_STRPGLACCTJRNLENTRYITMQRY.MANDT == TCURC.MANDT