JOURNALENTRYITEM

JOURNALENTRYITEM is an SAP database table in S/4HANA. It contains 157 fields.

Fields (157)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument,OriginAccountingDocument 22
KEY AccountingDocumentItem AccountingDocumentItem 5
KEY CO_DIANReportFormat CO_DIANReportFormat 5
KEY CO_DIANReportItemType CO_DIANReportItemType 5
KEY CompanyCode CompanyCode 24
KEY FiscalYear FiscalYear 21
KEY FiscalYearPeriod FiscalYearPeriod 1
KEY GLAccount GLAccount 8
KEY Ledger Ledger 22
KEY LedgerGLLineItem AccountingDocumentItem,LedgerGLLineItem 8
KEY PerformanceObligation PerformanceObligation 3
KEY SourceLedger SourceLedger 13
KEY StatryRptCategory StatryRptCategory 15
KEY StatryRptgEntity StatryRptgEntity 15
KEY StatryRptRunID StatryRptRunID 15
KEY TaxItem TaxItem 1
_BalanceTransactionCurrency _BalanceTransactionCurrency 2
_BusinessTransactionType _BusinessTransactionType 1
_CO_DIANCityCode _CO_DIANCityCode 1
_CO_DIANCountryMapping _CO_DIANCountryMapping 1
_CO_DIANTaxMapping _CO_DIANTaxMapping 1
_CompanyCode _CompanyCode 6
_CompanyCodeCurrency _CompanyCodeCurrency 3
_ControllingArea _ControllingArea 1
_Customer _Customer 1
_DebitCreditCode _DebitCreditCode 2
_FinancialAccountType _FinancialAccountType 2
_FiscalYear _FiscalYear 4
_FreeDefinedCurrency1 _FreeDefinedCurrency1 2
_FreeDefinedCurrency2 _FreeDefinedCurrency2 2
_FreeDefinedCurrency3 _FreeDefinedCurrency3 2
_FreeDefinedCurrency4 _FreeDefinedCurrency4 2
_FreeDefinedCurrency5 _FreeDefinedCurrency5 2
_FreeDefinedCurrency6 _FreeDefinedCurrency6 2
_FreeDefinedCurrency7 _FreeDefinedCurrency7 2
_FreeDefinedCurrency8 _FreeDefinedCurrency8 2
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts 1
_GlobalCurrency _GlobalCurrency 2
_JournalEntry _JournalEntry 2
_Ledger _Ledger 4
_OneTimeAccountBP _OneTimeAccountBP 1
_ReferenceDocumentType _ReferenceDocumentType 1
_ReportingCurrency _ReportingCurrency 1
_Supplier _Supplier 1
_TransactionCurrency _TransactionCurrency 2
AccountAssignmentType AccountAssignmentType 2
AccountingDocCreatedByUser AccountingDocCreatedByUser 5
AccountingDocumentType AccountingDocumentType 8
AccountingPrinciple AccountingPrinciple 2
AdditionalLastName AdditionalLastName 1
AlternativeGLAccount AlternativeGLAccount 6
AlternativeGLAccountIsUsed AlternativeGLAccountIsUsed 1
AmountInBalanceTransacCrcy AmountInBalanceTransacCrcy 2
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 2
AmountInFreeDefinedCurrency1 AmountInFreeDefinedCurrency1 2
AmountInFreeDefinedCurrency2 AmountInFreeDefinedCurrency2 2
AmountInFreeDefinedCurrency3 AmountInFreeDefinedCurrency3 2
AmountInFreeDefinedCurrency4 AmountInFreeDefinedCurrency4 2
AmountInFreeDefinedCurrency5 AmountInFreeDefinedCurrency5 2
AmountInFreeDefinedCurrency6 AmountInFreeDefinedCurrency6 2
AmountInFreeDefinedCurrency7 AmountInFreeDefinedCurrency7 2
AmountInFreeDefinedCurrency8 AmountInFreeDefinedCurrency8 2
AmountInGlobalCurrency AmountInGlobalCurrency 2
AmountInReportingCurrency AmountInReportingCurrency 4
AmountInTransactionCurrency AmountInTransactionCurrency 4
BalanceTransactionCurrency BalanceTransactionCurrency 2
BusinessPartner BusinessPartner 1
BusinessPartnerCategory BusinessPartnerCategory 1
BusinessPartnerCountry BusinessPartnerCountry 1
BusinessPlace BusinessPlace 2
BusinessTransactionType BusinessTransactionType 1
CAIsDownPaymentRequest CAIsDownPaymentRequest 1
ChartOfAccounts ChartOfAccounts 8
CityCode CityCode 1
CityName CityName 1
ClearingDate ClearingDate 6
CO_DIANAmountClassification CO_DIANAmountClassification 2
CO_DIANBPTaxLongNumber CO_DIANBPTaxLongNumber 3
CompanyCodeCurrency CompanyCodeCurrency,TaxReportingCurrency 5
ConditionType ConditionType 1
ConditionTypeName ConditionTypeName 1
ControllingArea ControllingArea 1
CostCenter CostCenter 7
CountryChartOfAccounts CountryChartOfAccounts 6
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy 1
CreditAmountInReportingCrcy CreditAmountInReportingCrcy 1
CreditAmountInTransCrcy CreditAmountInTransCrcy 1
Customer Customer 3
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy 1
DebitAmountInReportingCurrency DebitAmountInReportingCurrency 1
DebitAmountInTransCrcy DebitAmountInTransCrcy 1
DebitCreditCode DebitCreditCode 6
DocumentDate DocumentDate 7
DocumentItemText DocumentItemText 1
DocumentReferenceID DocumentReferenceID 6
EndingBalanceAmtInCoCodeCrcy EndingBalanceAmtInCoCodeCrcy 1
EndingBalanceAmtInTransCrcy EndingBalanceAmtInTransCrcy 1
ExchangeRate ExchangeRate 3
FinancialAccountType FinancialAccountType 7
FirstName FirstName 1
FiscalPeriod FiscalPeriod 5
FiscalYearVariant FiscalYearVariant 1
FreeDefinedCurrency1 FreeDefinedCurrency1 2
FreeDefinedCurrency2 FreeDefinedCurrency2 2
FreeDefinedCurrency3 FreeDefinedCurrency3 2
FreeDefinedCurrency4 FreeDefinedCurrency4 2
FreeDefinedCurrency5 FreeDefinedCurrency5 2
FreeDefinedCurrency6 FreeDefinedCurrency6 2
FreeDefinedCurrency7 FreeDefinedCurrency7 2
FreeDefinedCurrency8 FreeDefinedCurrency8 2
GLAccountType GLAccountType 6
GlobalCurrency GlobalCurrency 2
IsNaturalPerson IsNaturalPerson 1
IsReversal IsReversal 6
IsReversed IsReversed 6
JrnlEntryCntrySpecificRef5 JrnlEntryCntrySpecificRef5 2
LastName LastName 1
MiddleName MiddleName 1
OffsettingAccount OffsettingAccount 6
OffsettingAccountType OffsettingAccountType 4
OpeningBalanceAmtInCoCodeCrcy OpeningBalanceAmtInCoCodeCrcy 1
OpeningBalanceAmtInTransCrcy OpeningBalanceAmtInTransCrcy 1
OrganizationBPName1 OrganizationBPName1 2
OrganizationBPName2 OrganizationBPName2 1
OrganizationBPName3 OrganizationBPName3 1
OrganizationBPName4 OrganizationBPName4 1
PaymentMethod PaymentMethod 3
Plant Plant 1
PostingDate PostingDate,RADocumentCreationDate 13
ProfitCenter ProfitCenter 6
Reference1IDByBusinessPartner Reference1IDByBusinessPartner 3
Reference3IDByBusinessPartner Reference3IDByBusinessPartner 3
ReferenceDocument ReferenceDocument 7
ReferenceDocumentContext ReferenceDocumentContext 1
ReferenceDocumentItem ReferenceDocumentItem 6
ReferenceDocumentType ReferenceDocumentType 1
Region Region 1
ReportedTaxNumber ReportedTaxNumber 2
ReportingCurrency ReportingCurrency 7
RevenueAccountingContract RevenueAccountingContract 1
ReversalReferenceDocument ReversalReferenceDocument 1
ReversalReferenceDocumentCntxt ReversalReferenceDocumentCntxt 1
SalesDocument SalesDocument 1
SpecialGLCode SpecialGLCode 8
StreetName StreetName 1
Supplier Supplier 3
TaxCode TaxCode 8
TaxNumber1 TaxNumber1 8
TaxNumber2 TaxNumber2 1
TaxNumber3 TaxNumber3 1
TaxNumber4 TaxNumber4 1
TaxNumber5 TaxNumber5 1
TaxNumberType TaxNumberType 1
TransactionCode TransactionCode 1
TransactionCurrency TransactionCurrency 11
TransactionTypeDetermination TransactionTypeDetermination 7
VATRegistration VATRegistration 1