_JOURNALENTRY

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

Fields (108)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 5
KEY AccountingDocumentHeaderText AccountingDocumentHeaderText,JP_OffsetJournalEntryHeaderTxt 23
KEY CompanyCode CompanyCode 2
KEY FiscalYear FiscalYear 4
_BusinessTransactionType _BusinessTransactionType 1
_FinancialManagementArea _FinancialManagementArea 2
_Ledger _Ledger 1
_LogicalSystem _LogicalSystem 1
_TransactionCurrency _TransactionCurrency 1
AbsoluteExchangeRate AbsoluteExchangeRate 3
AccountingDocCreatedByUser AccountingDocCreatedByUser 15
AccountingDocumentCategory AccountingDocumentCategory 7
AccountingDocumentClass AccountingDocumentClass 3
AccountingDocumentCreationDate AccountingDocumentCreationDate,CreationDate,JournalEntryCreationDate 24
AccountingDocumentIsReversible AccountingDocumentIsReversible 1
AccountingDocumentType AccountingDocumentType 16
AcctgDocumentWorkflowStatus AcctgDocumentWorkflowStatus 1
AdditionalCurrency1 AdditionalCurrency1 3
AdditionalCurrency1Role AdditionalCurrency1Role 1
AdditionalCurrency2 AdditionalCurrency2 3
AdditionalCurrency2Role AdditionalCurrency2Role 1
AlternativeReferenceDocument AlternativeReferenceDocument 3
BatchInputSession BatchInputSession 2
Branch Branch 3
BusinessTransactionType BusinessTransactionType 3
CompanyCodeCurrency CompanyCodeCurrency 4
CompanyCodeName CompanyCodeName 1
CreationDateTime CreationDateTime 1
CreationTime CreationTime 6
CtryCrcyTxAbsoluteExchangeRate CtryCrcyTxAbsoluteExchangeRate 1
DocumentDate DocumentDate 10
DocumentReferenceID DocumentReferenceID,LastMileRouteCreditMemoNo,ReferenceDocument,xblnr 37
EffectiveExchangeRate EffectiveExchangeRate 2
ExchangeRate ExchangeRate 3
ExchangeRateDate ExchangeRateDate 2
ExchangeRateType ExchangeRateType 3
ExchRateIsIndirectQuotation ExchRateIsIndirectQuotation 2
FinancialManagementArea FinancialManagementArea 4
FiscalPeriod FiscalPeriod 10
FiscalYearPeriod FiscalYearPeriod 1
FullName FullName 1
IntercompanyTransaction IntercompanyTransaction 3
InvoiceReceiptDate InvoiceReceiptDate 4
IsReversal IsReversal 9
IsReversed IsReversed 12
JournalEntryLastChangeDateTime JournalEntryLastChangeDateTime 1
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 3
JrnlEntryCntrySpecificRef5 JrnlEntryCntrySpecificRef5 3
LastAutomaticChangeDate LastAutomaticChangeDate 1
LastChangeDate LastChangeDate 7
LastManualChangeDate LastManualChangeDate 1
LatePaymentReason LatePaymentReason 2
Ledger Ledger 3
LedgerGroup LedgerGroup 8
LogicalSystem LogicalSystem 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 3
PostingDate PostingDate 13
RecurringAccountingDocument RecurringAccountingDocument 3
Reference1InDocumentHeader Reference1InDocumentHeader 4
Reference2InDocumentHeader Reference2InDocumentHeader 4
ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem 2
ReferenceDocumentType ReferenceDocumentType 5
ReversalIsPlanned ReversalIsPlanned,xstov 3
ReversalReason ReversalReason 5
ReversalReferenceDocument ReversalRefDoc,ReversalReferenceDocument 2
ReversedDocument ReversedDocument 1
ReverseDocument ReverseDocument 15
ReverseDocumentFiscalYear ReverseDocumentFiscalYear 5
ReversedReferenceDocument ReversedReferenceDocument 1
SalesDocumentCondition SalesDocumentCondition 2
SenderAccountingDocument belnr_sender,SenderAccountingDocument 10
SenderCompanyCode bukrs_sender,SenderCompanyCode 8
SenderFiscalYear gjahr_sender,SenderFiscalYear 8
SenderLogicalSystem logsystem_sender,SenderLogicalSystem 10
SourceCompanyCode SourceCompanyCode 2
SourceReferenceDocument SourceReferenceDocument 1
TaxAbsoluteExchangeRate TaxAbsoluteExchangeRate 3
TaxBaseAmountIsNetAmount TaxBaseAmountIsNetAmount 3
TaxBaseAmountOrigin TaxBaseAmountOrigin 1
TaxCalculationType TaxCalculationType 1
TaxCountry TaxCountry 1
TaxEffectiveExchangeRate TaxEffectiveExchangeRate 2
TaxExchangeRate TaxExchangeRate 2
TaxExchRateIsIndirectQuotation TaxExchRateIsIndirectQuotation 2
TaxFulfillmentDate TaxFulfillmentDate 6
TaxIsCalculatedAutomatically TaxIsCalculatedAutomatically 3
TaxReportingDate TaxReportingDate 13
TransactionCode TransactionCode 12
TransactionCurrency Currency,DocumentCurrency,TransactionCurrency 10
WithholdingTaxReportingDate WithholdingTaxReportingDate 2