C_JrnlEntryCorrespnc

Correspondence SAP09 - Ledger View - Journal Entry | view: CJRNLENCOR | Extraction: Not supported | Component: Fiori FXU Accounts Receivable FI-FIO-AR
Tables used: BKPFT003TT001TKA02TKA01TTYPTT000
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
Column Name Description
Column Name Description
Column Name Description
DocumentDate Journal Entry Date
PostingDate Posting Date
AccountingDocumentCreationDate Accounting Document Entry Date
CreationTime Creation Time
LastManualChangeDate Calendar date of the last manual change in document
LastAutomaticChangeDate Calendar date of the last automatic change in document
LastChangeDate Last Change Date
ExchangeRateDate Exchange Rate Date
PlannedReversalDate Planned Date for the Reversal Posting
ParkingDate Day of Parking of Accounting Document
ParkingTime Time of Parking
InvoiceReceiptDate Invoice Receipt Date
TaxReportingDate Tax Reporting Date
Column Name Description
AccountingDocumentCategory Journal Entry Category Show values
ReversalIsPlanned Indicator: Reversal Is Planned for Document Show values
TaxIsCalculatedAutomatically Tax Is Automatically Calculated Show values
TaxBaseAmountIsNetAmount Tax Base Amount is Net Amount Show values
IsDiscountDocument Indicator: entry represents a discount document Show values
AccountingDocumentClass Accounting Document Class Show values
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
Column Name Description Domain name
AccountingDocumentTypeName Document Type Name TEXT20
FiscalPeriod Fiscal Period POPER
AccountingDocCreatedByUser User that created the journal entry
TransactionCode Transaction Code TCODE
IntercompanyTransaction Intercompany Transaction Number BVORG
DocumentReferenceID Document Reference ID XBLNR1
RecurringAccountingDocument Recurring Journal Entry BELNR
ReverseDocument Reverse Document BELNR
ReverseDocumentFiscalYear Reverse Document Fiscal Year GJAHR
AccountingDocumentHeaderText Document Header Text TEXT25
ExchangeRate Exchange Rate UKURS
BusinessTransactionType Business Transaction Category FINS_BTTYPE
BatchInputSession Batch Input Session CHAR12
ReferenceDocumentType Reference Document Type AWTYP
ReferenceDocumentTypeName Name of Object Type TEXT20
OriginalReferenceDocument Object key AWKEY
FinancialManagementArea Financial Management Area FIKRS
LogicalSystem Logical System LOGSYS
ReferenceDocumentLogicalSystem Logical System of Reference Document LOGSYS
TaxExchangeRate Tax Exchange Rate KURSF
NmbrOfPages Number of pages of invoice J_1ANOPG
Reference1InDocumentHeader Internal ID of Reference Key 1 in Document Header CHAR20
Reference2InDocumentHeader Internal ID of Reference Key 2 in Document Header CHAR20
AlternativeReferenceDocument Alternative Reference Document FIS_XBLNR_ALT_ALPHA
SenderLogicalSystem Sender Logical System LOGSYS
SenderCompanyCode Company Code in Sender System CHAR4
SenderAccountingDocument Sender Journal Entry BELNR
SenderFiscalYear Fiscal Year of an Accounting Document in the Sender System GJAHR
ReversalReferenceDocumentCntxt Reversal: Reference Organizations of Document to Be Reversed AWORG
ReversalReferenceDocument Reversal: Reference Document No. of Document to Be Reversed AWREF
LatePaymentReason Late Payment Reason CHAR2
SalesDocumentCondition Sales Document Condition KNUMV
ControllingAreaName Controlling Area Name TEXT25
Master Data Relations | to Other Relations ↓ Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • C_JRNLENTRYCORRESPNC.MANDT == T003.MANDT
  • C_JRNLENTRYCORRESPNC.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Company Code
  • Company Code
  • Client
  • C_JRNLENTRYCORRESPNC.COMPANYCODE == T001.BUKRS
  • C_JRNLENTRYCORRESPNC.MANDT == T001.MANDT
Controlling Area
  • Client
  • Controlling Area
  • C_JRNLENTRYCORRESPNC.MANDT == TKA01.MANDT
  • C_JRNLENTRYCORRESPNC.CONTROLLINGAREA == TKA01.KOKRS
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • C_JRNLENTRYCORRESPNC.MANDT == TCURV.MANDT
  • C_JRNLENTRYCORRESPNC.EXCHANGERATETYPE == TCURV.KURST
Ledger Group
  • Client
  • Ledger Group
Reason for Reversal or Inverse Posting
  • Reason for Reversal or Inverse Posting
  • Client
  • C_JRNLENTRYCORRESPNC.REVERSALREASON == T041C.STGRD
  • C_JRNLENTRYCORRESPNC.MANDT == T041C.MANDT
Source Company Code
  • Client
  • Source Company Code
  • C_JRNLENTRYCORRESPNC.MANDT == T001.MANDT
  • C_JRNLENTRYCORRESPNC.SOURCECOMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • C_JRNLENTRYCORRESPNC.MANDT == TCURC.MANDT
  • C_JRNLENTRYCORRESPNC.TRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Ledger
  • Company Code
  • Client
  • Ledger
  • Ledger
Ledger
  • Company Code
  • Client
  • Ledger
  • Ledger