C_TR_StRpElectronicLedgerQ

Query View ForElectronic Ledger | view: CELDGRQ | Extraction: Not supported | Component: Localization Financials
Column Name Description
CompanyCode Company Code
AccountingDocument Document Number of an Accounting Document
FiscalYear Fiscal Year
AccountingDocumentItem Number of Line Item Within Accounting Document
StatryRptgEntity FK Reporting Entity
StatryRptCategory FK Report Category ID
StatryRptRunID Report Run ID
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in local currency
TR_MonetaryAmtInCoCodeCrcy Amount in local currency
Column Name Description
Column Name Description
Column Name Description
DebitCreditCode Debit/Credit Indicator Show values
Column Name Description Domain name
PostingDateAsText Posting Date
SenderGLAccount null
GLAccount General Ledger Account SAKNR
DocumentDateAsText Document Date
TR_ElectronicLedgerDocType External Document Type. FIGN_EXTDOCTYP
TR_ElectronicLedgerExtDocName External Document Type Description FIGN_EXTDOCTYP_DESC
DocumentReferenceID Reference Document Number XBLNR
AlternativeGLAccount Account Number in the Local Chart of Accounts SAKNR
AlternativeGLAccountLongName G/L Account Long Text TEXT50
GLAccountLongName G/L Account Long Text TEXT50
PaymentMethodDescription Payment method Description. FITR_ELPAYMETH_DESC
AccountingDocCreatedByUser User Name XUBNAME
DocumentItemText Item Text TEXT50
AccountingDocumentHeaderText Comment TEXT50
DocumentHeaderSeqNumber Header Sequence Counter FITR_SEQ_NUM
DocumentItemSeqNumber Line Item Sequence Counter FITR_SEQ_NUM
Master Data Relations Join Conditions
Reporting Entity
  • Client
  • Reporting Entity
  • C_TR_STRPELECTRONICLEDGERQ.MANDT == SRF_RPG_ENT.MANDT
  • C_TR_STRPELECTRONICLEDGERQ.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY