_JOURNALENTRY

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

Fields (116)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 6
KEY AccountingDocumentHeaderText AccountingDocumentHeaderText,JP_OffsetJournalEntryHeaderTxt 26
KEY CompanyCode CompanyCode 3
KEY FiscalYear FiscalYear 5
KEY PostingDate PostingDate 17
KEY TaxReportingDate TaxReportingDate 13
AbsoluteExchangeRate AbsoluteExchangeRate 2
AccountingDocCreatedByUser AccountingDocCreatedByUser 14
AccountingDocumentCategory AccountingDocumentCategory 7
AccountingDocumentClass AccountingDocumentClass 1
AccountingDocumentCreationDate AccountingDocumentCreationDate,CreationDate,JournalEntryCreationDate 26
AccountingDocumentIsReversible AccountingDocumentIsReversible 1
AccountingDocumentType AccountingDocumentType 16
AcctgDocumentWorkflowStatus AcctgDocumentWorkflowStatus 1
AdditionalCurrency1 AdditionalCurrency1 3
AdditionalCurrency1Role AdditionalCurrency1Role 2
AdditionalCurrency2 AdditionalCurrency2 3
AdditionalCurrency2Role AdditionalCurrency2Role 2
AlternativeReferenceDocument AlternativeReferenceDocument 2
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 1
AmountInTransactionCurrency AmountInTransactionCurrency 1
BatchInputSession BatchInputSession 1
Branch Branch 2
BranchCode BranchCode 1
BusinessPlace CustomerBusinessPlace 1
BusinessTransactionType BusinessTransactionType 2
CashDiscountAmount CashDiscountAmount 1
ClearingAccountingDocument ClearingAccountingDocument 1
CompanyCodeCurrency CompanyCodeCurrency 6
CreationDateTime CreationDateTime 1
CreationTime CreationTime 7
CtryCrcyTxAbsoluteExchangeRate CtryCrcyTxAbsoluteExchangeRate 2
DocumentDate DocumentDate 12
DocumentReferenceID DocumentReferenceID,ReferenceDocument,xblnr 40
EffectiveExchangeRate EffectiveExchangeRate 1
EntryViewPostingControl EntryViewPostingControl 1
ExchangeRate ExchangeRate 2
ExchangeRateDate ExchangeRateDate 1
ExchangeRateType ExchangeRateType 2
ExchRateIsIndirectQuotation ExchRateIsIndirectQuotation 1
FinancialManagementArea FinancialManagementArea 2
FiscalPeriod FiscalPeriod 11
FiscalYearPeriod FiscalYearPeriod 1
FullName FullName 1
IntercompanyTransaction IntercompanyTransaction 2
InvoiceReceiptDate InvoiceReceiptDate 3
IsReversal IsReversal 7
IsReversed IsReversed,RblsFinancingPostingIsReversed 12
IsUsedInPaymentTransaction IsUsedInPaymentTransaction 1
JournalEntryIsSecondaryEntry JournalEntryIsSecondaryEntry 1
JournalEntryLastChangeDateTime JournalEntryLastChangeDateTime 1
JrnlEntryBusinessTransType JrnlEntryBusinessTransType 1
JrnlEntryCntrySpecificBP1 JrnlEntryCntrySpecificBP1 1
JrnlEntryCntrySpecificBP2 JrnlEntryCntrySpecificBP2 1
JrnlEntryCntrySpecificDate1 InvoiceDate,JrnlEntryCntrySpecificDate1 5
JrnlEntryCntrySpecificDate2 JrnlEntryCntrySpecificDate2 1
JrnlEntryCntrySpecificDate3 JrnlEntryCntrySpecificDate3 1
JrnlEntryCntrySpecificDate4 JrnlEntryCntrySpecificDate4 1
JrnlEntryCntrySpecificDate5 JrnlEntryCntrySpecificDate5 1
JrnlEntryCntrySpecificRef1 JrnlEntryCntrySpecificRef1 5
JrnlEntryCntrySpecificRef2 JrnlEntryCntrySpecificRef2 2
JrnlEntryCntrySpecificRef3 JrnlEntryCntrySpecificRef3 1
JrnlEntryCntrySpecificRef4 JrnlEntryCntrySpecificRef4 2
JrnlEntryCntrySpecificRef5 JrnlEntryCntrySpecificRef5 2
LastAutomaticChangeDate LastAutomaticChangeDate 1
LastChangeDate LastChangeDate 6
LastManualChangeDate LastManualChangeDate 1
LatePaymentReason LatePaymentReason 1
Ledger Ledger 3
LedgerGroup LedgerGroup 6
LogicalSystem LogicalSystem 1
MarketDataAbsoluteExchangeRate MarketDataAbsoluteExchangeRate 1
NetAmountIsPosted NetAmountIsPosted 2
NetPaymentAmount NetPaymentAmount 1
NmbrOfPages NmbrOfPages 2
OriginalReferenceDocument OriginalReferenceDocument 10
ParkedByUser ParkedByUser 1
ParkingDate ParkingDate 1
ParkingDateTime ParkingDateTime 1
ParkingTime ParkingTime 1
ParkingTransactionCode ParkingTransactionCode 1
PaymentMethod PaymentMethod 1
PlannedReversalDate PlannedReversalDate 2
RecurringAccountingDocument RecurringAccountingDocument 2
Reference1InDocumentHeader Reference1InDocumentHeader 3
Reference2InDocumentHeader Reference2InDocumentHeader 3
ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem 2
ReferenceDocumentType ReferenceDocumentType 6
ReversalIsPlanned ReversalIsPlanned,xstov 2
ReversalReason ReversalReason 4
ReversalReferenceDocument ReversalReferenceDocument 1
ReversedDocument ReversedDocument 1
ReverseDocument ReverseDocument 15
ReverseDocumentFiscalYear ReverseDocumentFiscalYear 5
ReversedReferenceDocument ReversedReferenceDocument 1
SalesDocumentCondition SalesDocumentCondition 1
SenderAccountingDocument belnr_sender,SenderAccountingDocument 9
SenderCompanyCode bukrs_sender,SenderCompanyCode 7
SenderFiscalYear gjahr_sender,SenderFiscalYear 8
SenderLogicalSystem logsystem_sender,SenderLogicalSystem 9
SourceCompanyCode SourceCompanyCode 1
SourceReferenceDocument SourceReferenceDocument 1
SourceReferenceDocumentType SourceReferenceDocumentType 1
TaxAbsoluteExchangeRate TaxAbsoluteExchangeRate 2
TaxBaseAmountIsNetAmount TaxBaseAmountIsNetAmount 2
TaxBaseAmountOrigin TaxBaseAmountOrigin 1
TaxCalculationType TaxCalculationType 1
TaxCountry TaxCountry 1
TaxEffectiveExchangeRate TaxEffectiveExchangeRate 1
TaxExchangeRate TaxExchangeRate 1
TaxExchRateIsIndirectQuotation TaxExchRateIsIndirectQuotation 1
TaxFulfillmentDate TaxFulfillmentDate 6
TaxIsCalculatedAutomatically TaxIsCalculatedAutomatically 2
TransactionCode TransactionCode 12
TransactionCurrency Currency,DocumentCurrency,TransactionCurrency 11
WithholdingTaxReportingDate WithholdingTaxReportingDate 2