_JOURNALENTRY

_JOURNALENTRY is an SAP database table in S/4HANA. It contains 90 fields.

Fields (90)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 3
KEY AccountingDocumentHeaderText AccountingDocumentHeaderText,JP_OffsetJournalEntryHeaderTxt 19
KEY CompanyCode CompanyCode 2
KEY FiscalYear FiscalYear 2
KEY LedgerGroup Ledger,LedgerGroup,SourceLedger 7
_FinancialManagementArea _FinancialManagementArea 1
_TransactionCurrency _TransactionCurrency 1
AbsoluteExchangeRate AbsoluteExchangeRate 1
AccountingDocCreatedByUser AccountingDocCreatedByUser 15
AccountingDocumentCategory AccountingDocumentCategory 7
AccountingDocumentCreationDate AccountingDocumentCreationDate,CreationDate,JournalEntryCreationDate 22
AccountingDocumentType AccountingDocumentType 12
AdditionalCurrency1 AdditionalCurrency1 3
AdditionalCurrency1Role AdditionalCurrency1Role 1
AdditionalCurrency2 AdditionalCurrency2 3
AdditionalCurrency2Role AdditionalCurrency2Role 1
AlternativeReferenceDocument AlternativeReferenceDocument 1
Branch Branch 1
BusinessTransactionType BusinessTransactionType 1
CompanyCodeCurrency CompanyCodeCurrency 4
CompanyCodeName CompanyCodeName 1
CreationDateTime CreationDateTime 1
CreationTime CreationTime 3
CtryCrcyTxAbsoluteExchangeRate CtryCrcyTxAbsoluteExchangeRate 1
DocumentDate DocumentDate 9
DocumentReferenceID DocumentReferenceID,ReferenceDocument 31
ExchangeRate ExchangeRate 1
ExchangeRateDate ExchangeRateDate 1
ExchangeRateType ExchangeRateType 1
FinancialManagementArea FinancialManagementArea 2
FiscalPeriod FiscalPeriod 7
FiscalYearPeriod FiscalYearPeriod 1
FullName FullName 1
IntercompanyTransaction IntercompanyTransaction 2
InvoiceReceiptDate InvoiceReceiptDate 2
IsReversal IsReversal 4
IsReversed IsReversed 9
JrnlEntryCntrySpecificBP1 JrnlEntryCntrySpecificBP1 1
JrnlEntryCntrySpecificBP2 JrnlEntryCntrySpecificBP2 1
JrnlEntryCntrySpecificDate1 InvoiceDate,JrnlEntryCntrySpecificDate1 4
JrnlEntryCntrySpecificDate2 JrnlEntryCntrySpecificDate2 1
JrnlEntryCntrySpecificDate3 JrnlEntryCntrySpecificDate3 1
JrnlEntryCntrySpecificDate4 JrnlEntryCntrySpecificDate4 1
JrnlEntryCntrySpecificDate5 JrnlEntryCntrySpecificDate5 1
JrnlEntryCntrySpecificRef1 JrnlEntryCntrySpecificRef1 3
JrnlEntryCntrySpecificRef2 JrnlEntryCntrySpecificRef2 1
JrnlEntryCntrySpecificRef3 JrnlEntryCntrySpecificRef3 1
JrnlEntryCntrySpecificRef4 JrnlEntryCntrySpecificRef4 2
JrnlEntryCntrySpecificRef5 JrnlEntryCntrySpecificRef5 2
LastAutomaticChangeDate LastAutomaticChangeDate 1
LastChangeDate LastChangeDate 6
LastManualChangeDate LastManualChangeDate 1
Ledger Ledger 2
MarketDataAbsoluteExchangeRate MarketDataAbsoluteExchangeRate 1
NetAmountIsPosted NetAmountIsPosted 2
NmbrOfPages NmbrOfPages 2
OriginalReferenceDocument OriginalReferenceDocument 10
ParkedByUser ParkedByUser 1
ParkingDate ParkingDate 1
ParkingDateTime ParkingDateTime 1
ParkingTime ParkingTime 1
PlannedReversalDate PlannedReversalDate 1
PostingDate PostingDate 11
RecurringAccountingDocument RecurringAccountingDocument 1
Reference1InDocumentHeader Reference1InDocumentHeader 2
Reference2InDocumentHeader Reference2InDocumentHeader 2
ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem 2
ReferenceDocumentType ReferenceDocumentType 5
ReversalReason ReversalReason 3
ReversalReferenceDocument ReversalReferenceDocument 1
ReversedDocument ReversedDocument 1
ReverseDocument ReverseDocument 9
ReverseDocumentFiscalYear ReverseDocumentFiscalYear 1
ReversedReferenceDocument ReversedReferenceDocument 1
SenderAccountingDocument SenderAccountingDocument 8
SenderCompanyCode SenderCompanyCode 7
SenderFiscalYear SenderFiscalYear 6
SenderLogicalSystem SenderLogicalSystem 7
SourceReferenceDocument SourceReferenceDocument 1
TaxAbsoluteExchangeRate TaxAbsoluteExchangeRate 1
TaxBaseAmountIsNetAmount TaxBaseAmountIsNetAmount 1
TaxBaseAmountOrigin TaxBaseAmountOrigin 1
TaxCalculationType TaxCalculationType 1
TaxCountry TaxCountry 1
TaxFulfillmentDate TaxFulfillmentDate 3
TaxIsCalculatedAutomatically TaxIsCalculatedAutomatically 1
TaxReportingDate TaxReportingDate 9
TransactionCode TransactionCode 10
TransactionCurrency Currency,DocumentCurrency,TransactionCurrency 8
WithholdingTaxReportingDate WithholdingTaxReportingDate 2