I_JOURNALENTRY

CDS View
93 Fields 209 CDS Views

Journal Entry

I_JOURNALENTRY is a CDS View in S/4HANA. Journal Entry. It contains 93 fields. 209 CDS views read from this table.

CDS Views using this table (209)

ViewTypeJoinVDMDescription
C_AccountingDocument view from CONSUMPTION Accounting Document
C_AR_StRpCashJournalItemCube view_entity inner CONSUMPTION Argentina Cash Journal Item - Cube
C_BSOrdProcFlwJournalEntry view from CONSUMPTION Journal Entry Attrib for BSOrd Prgrs
C_BudgetaryDocumentForObjP view from CONSUMPTION Auxiliary Budgetary Doc Cosumption view for FM Obejct Pages
C_CN_TaxInvcJrnlEntrRef view from CONSUMPTION VAT Invoice Journal Entry Reference
C_CO_UGPPTrialBalanceItemC view_entity inner CONSUMPTION Colombia UGPP Trial Balance Item - Cube
C_EG_StRpStampTaxItemCube view inner CONSUMPTION Stamp Tax Item Cube for Egypt
C_GB_StRpAuditFinFileC view_entity from CONSUMPTION GB HRMC Audit File for FI - Cube
C_JP_MachineLearningOpenItem view from CONSUMPTION Machine Learning Open Receivable Items
C_JP_MachineLrngClearedARItem view from CONSUMPTION Machine Learning Cleared Receivable Item
C_JrnlEntryCorrespnc view from CONSUMPTION Correspondence SAP09 - Ledger View - Journal Entry
C_MngJrnlEntrReltdJournalEntry view_entity from CONSUMPTION Journal Entry Associated Journal Entry
C_NO_SAFTJournalEntryCube view inner CONSUMPTION SAF-T Norway Journal Entry Cube
C_OplAcctgDocCorrespnc view from CONSUMPTION Correspondence SAP09 - Operational document
C_PaymentBatchPaymentDocument view_entity inner CONSUMPTION Payment Batch Payment Documents
C_PE_StRpJournalEntryWithTax view from CONSUMPTION Peru journal entries with tax
C_PE_StRpNotRptdJournalEntry view_entity from CONSUMPTION Not Reported Journal Entries for Statutory Reporting
C_PT_SAFTGenLedgerHeaderC view_entity from CONSUMPTION General Ledger Document Header - Cube
C_PT_SAFTPaymentOrderRefer view_entity from CONSUMPTION Originating Document of the Payment
C_PT_SAFTPaytDocHeaderCube view_entity from CONSUMPTION Payment Header for SAFT PT - Cube
C_RO_SAFTPaymentItemC view inner CONSUMPTION Payment Data for RO SAFT - Cube
C_RO_StRpDocumentJournalC view_entity from CONSUMPTION Romania Document Journal - Cube
C_RO_StRpDomesticSlsPurListC view left_outer CONSUMPTION Romania Domestic Sales and Purchase List - Cube
C_StRpDocLineItemWthRefDoc view left_outer CONSUMPTION Tax Items with Reference Accounting Documents
C_StRpNotRptdJournalEntry view from CONSUMPTION Not Reported Journal Entries
FARMLVD_APAR_ACCDOC view from Cleared Receivable Item Information
FISTRPGSTR1ITEM view inner
FISTRPGSTR1ITEM view left_outer
H_HU_StRpInvoiceChainNode view from Hungary VAT: Definition Of Parent-Child Relationship
I_CFinAAPurchasingItemPosting view_entity inner TRANSACTIONAL CFinAA Purchasing Item Posting
I_CFinAAPurchasingPosting view_entity inner COMPOSITE CFinAA Purchasing Posting
I_CN_TaxInvoiceAccountingDoc view_entity inner COMPOSITE China Tax Invoice Accouting Document
I_EDCJournalEntryRecords view_entity inner BASIC EDC Relevant Journal Entry Records
I_ES_ElectronicDocAccountDoc view_entity inner COMPOSITE Spain SII Header eDocument Consistency
I_GLJrnlEntryToBeVerified view from COMPOSITE Interface View of GL JE to be verified
I_ID_StRpVATReturnOutCube view from COMPOSITE Indonesia VAT Return Out - Cube
I_ID_StRpVATReturnOutCube view union_all COMPOSITE Indonesia VAT Return Out - Cube
I_IL_IncomingPaymentDocument view_entity from COMPOSITE Incoming Payment Document
I_JournalEntryStdVH view from COMPOSITE Journal Entry
I_JournalEntryVH view from COMPOSITE Journal Entry
I_LU_SAFTJournalEntry view from COMPOSITE SAFT LU General Ledger Documents
I_PT_PaytRcptSersDocNumber view_entity from COMPOSITE PT Payment Receipts ATCUD
I_PT_SAFTBillgAcctgAmount view_entity from COMPOSITE Accounting Document Total Amount
I_PT_SAFTBillgAcctgHeader view_entity inner COMPOSITE Accounting Document Header
I_PT_SAFTSelfBillgSuplrInvcHdr view inner COMPOSITE SAF-T PT Self-Billing SupplierInv Header
I_RU_ReverseDocuments view from COMPOSITE Reverse Documents
I_SAFTJournalEntry view from COMPOSITE SAF-T Journal Ledger Entry
I_SAFTJournalHeader view from COMPOSITE SAF-T Journal Header
I_StRpBillingWithRefAcctgDoc view left_outer COMPOSITE Billing Documents With Reference Accounting Document
I_TaxItemProcessFlow view_entity inner COMPOSITE Tax Item Process Flow
I_TxRegIndirectTaxJournalEntry view_entity inner BASIC Indirect Tax with Journal Entry
P_AddlLedgerAcctDocItemHistory view left_outer COMPOSITE
P_AddlLedgerDocHeaderHistory view from COMPOSITE
P_APProcFlowJournalEntry view from CONSUMPTION AP Process Flow Journal Entry
P_AR_DailyVATTaxBaseAmount view inner CONSUMPTION
P_AR_JournalEntry view from CONSUMPTION
P_AR_JournalEntryTaxDetail view from CONSUMPTION Argentina: Journal Entry Tax Detail
P_AR_JournalEntryTaxDetail view left_outer CONSUMPTION Argentina: Journal Entry Tax Detail
P_AR_StRpVatPrcptnTaxItem view_entity inner COMPOSITE
P_AR_SuplrPaytSupplierLineItem view_entity from CONSUMPTION
P_AU_StRpPaytTmesRptgPaidInvc0 view from COMPOSITE
P_AU_StRpTPARFullyPaidInvcDoc view from COMPOSITE
P_AU_StRpTPARPrtlyPaidInvcDoc view from COMPOSITE
P_AUDIT_AT_BKPF view inner COMPOSITE
P_AUDIT_AT_BSET view_entity inner COMPOSITE Austrian Audit Journal Tax Data
P_BG_SAFTJournalEntryItem view_entity inner CONSUMPTION
P_BG_SAFTPAYMENTITEM view_entity inner CONSUMPTION
P_BG_SAFTPURINVOICEHEADER view_entity inner CONSUMPTION
P_BG_SAFTPURINVOICEITEM view_entity inner CONSUMPTION
P_BG_SAFTSALESINVOICEHEADER view_entity inner CONSUMPTION
P_BG_SAFTSALESINVOICEITEM view_entity inner CONSUMPTION
P_BusSolnOrdEntProjectFlwLvl5 view inner CONSUMPTION Solution Order Enterprise Project Flow: Level5
P_BusSolnOrdSlsOrdFlwLvl41 view inner CONSUMPTION Solution Order Sales Order Flow: Level 41
P_BusSolnOrdSlsOrdFlwLvl51 view inner CONSUMPTION Solution Order Sales Order Flow: Level 51
P_BusSolnOrdSlsOrdFlwLvl61 view inner CONSUMPTION Solution Order Sales Order Flow: Level 61
P_BusSolnOrdSlsOrdFlwLvl7 view inner CONSUMPTION Solution Order Sales Order Flow: Level 7
P_BusSolnOrdSlsOrdFlwLvl8 view inner CONSUMPTION Solution Order Sales Order Flow: Level 8
P_BusSolnOrdSrvcContrFlwLvl51 view inner CONSUMPTION Solution Order Service Contract Level51
P_BusSolnOrdSrvcContrFlwLvl7 view inner CONSUMPTION Solution Order Service Contract Level7
P_BusSolnOrdSrvcContrFlwLvl72 view inner CONSUMPTION Solution Order Service Contract Level 72
P_BusSolnOrdSrvcOrdFlwLvl51 view inner CONSUMPTION Solution Order Service Order Flow: Level 51
P_BUSSOLNORDSUBSCRPNFLWVL4 view inner CONSUMPTION Solution Order Subscription Flow: Level4
P_CL_JournalEntryItemDocAmount view from CONSUMPTION
P_ClearedAccount4 view from CONSUMPTION
P_ClearedItem2 view from CONSUMPTION
P_ClearingDocument view from CONSUMPTION
P_CustomerVendorLineItem view from COMPOSITE
P_CustSuplrLineItmWthParam view from COMPOSITE
P_CZ_StRpReportingGroupsSelCr view left_outer CONSUMPTION Rpg. Groups for Doc. Selection - Corr.
P_DaysBeyondTerms1 view inner COMPOSITE
P_DeftaxInvoice view from COMPOSITE
P_DefTaxTransfer1 view from COMPOSITE
P_DefTaxTransfer10 view from COMPOSITE
P_DwnPaytReqDocument view_entity from COMPOSITE DPRS Document Header
P_FR_AuditFECPaymentDocsInCA view inner CONSUMPTION France Audit FEC CA payment documents
P_HR_CUSTOMERVENDORLINEITEM view_entity from COMPOSITE
P_Hu_FiInvoice view from COMPOSITE
P_IN_RvsChrgIncgInvcAcctgDoc view_entity from COMPOSITE
P_JournalEntryHeaderHistory view from COMPOSITE
P_JournalEntryItemHistory view left_outer COMPOSITE
P_JrnlEntrWithRprstvLdgr view from COMPOSITE
P_KR_VATREVERSEDINVITEM view_entity from COMPOSITE
P_KZ_DSVATRetDeduct view from COMPOSITE
P_KZ_DSVATRetDoc view from COMPOSITE
P_KZ_DSVATRetForiegnDoc view from COMPOSITE
P_KZ_DSVATRetForiegnDocRenew view from COMPOSITE
P_KZ_DSVATRetInDoc1 view from COMPOSITE
P_KZ_DSVATRetOutDoc1 view from COMPOSITE
P_LU_SAFTJournal view from COMPOSITE
P_ManageJournalEntry view_entity from COMPOSITE Journal Entry
P_MJEJrnlEntrWthRprstvLdgr view_entity from COMPOSITE
P_NO_SAFTCUSTOMERCLOSEITEM view from COMPOSITE
P_NO_SAFTCustomerOpenItem view from COMPOSITE
P_NO_SAFTSUPPLIERCLOSEITEM view from COMPOSITE
P_NO_SAFTSUPPLIEROPENITEM view from COMPOSITE
P_NonMngdPurchasingSpend1 view inner CONSUMPTION Non Managed Spend
P_PayReqnAmount view inner COMPOSITE
P_PE_FISlsEntrWthOriginalDoc view_entity from CONSUMPTION
P_PE_JrnlEntryWthOfclDocClass view from CONSUMPTION Journal Entries With Document Class
P_PE_OriginalJournalEntry view from CONSUMPTION
P_PE_PurchaseOriginalJrnlEntry view from CONSUMPTION
P_PE_PurDmstcSuplrJEItemAggrgd view_entity from CONSUMPTION
P_PE_PurFrgnSuplrTaxItemAggrgd view_entity from CONSUMPTION
P_PE_SalesOriginalJrnlEntry view from CONSUMPTION Original Documents for Sales Ledger Peru
P_PE_SDSlsEntrWthOriginalDoc view_entity from CONSUMPTION
P_PL_SAFTAcctgDocInvoiceBasic view from COMPOSITE
P_PL_SAFTAcctgInvcBscVersion2 view_entity from COMPOSITE
P_PL_SAFTAssetRetirement10 view_entity inner CONSUMPTION
P_PL_SAFTInvcHeaderBscVersion2 view_entity from COMPOSITE
P_PL_SAFTInvoiceHeaderBasic view from COMPOSITE
P_PL_SAFTMapTaxCode view from COMPOSITE
P_PostedParkedJournalEntry view from COMPOSITE
P_PT_OriginalDocumentUnion view_entity from CONSUMPTION
P_RelatedAccountingDocument view_entity from COMPOSITE Related Accounting Documents
P_RO_SAFTDocumentType view inner CONSUMPTION GL Entry Document Type for RO SAFT
P_RO_SAFTNTRPurInvItem view_entity inner CONSUMPTION
P_RO_SAFTNTRPURINVWIAHEADER view_entity inner CONSUMPTION
P_RO_SAFTNTRSlsInvItem view_entity inner CONSUMPTION
P_RO_SAFTNTRSLSINVWIAHEADER view_entity inner CONSUMPTION
P_RO_SAFTPurInvItemAmount view_entity inner CONSUMPTION
P_RO_SAFTSalesInvoiceItem view inner CONSUMPTION
P_RO_SAFTSlsInvoiceItemAmount view_entity inner CONSUMPTION
P_RU_AcctgDocReferenceID view from CONSUMPTION
P_RU_BusPartnerClearingNotRvsd view inner CONSUMPTION
P_RU_CFinPseudoReversedDoc1 view inner CONSUMPTION
P_RU_CFinVATAccDocClassfctn view left_outer CONSUMPTION
P_RU_CFinVATCorrectionDocument view inner CONSUMPTION
P_RU_CFinVatCorrectionRevision view inner CONSUMPTION
P_RU_CFinVatCorRev view inner CONSUMPTION
P_RU_CFinVatCorRev view left_outer CONSUMPTION
P_RU_CFinVatDocExtras view inner CONSUMPTION
P_RU_CFinVatDocExtrasCm view inner COMPOSITE
P_RU_CFinVATRevisionDocument view inner CONSUMPTION
P_RU_CheckLinkToImpNotNum view from CONSUMPTION Check link to ImportNotificationNumber
P_RU_CommissionTradeInvoice10 view_entity from CONSUMPTION
P_RU_CommissionTradeInvoice14 view_entity inner CONSUMPTION
P_RU_DPClearingTotalAmount1 view inner CONSUMPTION
P_RU_DSVATReporting0 view from CONSUMPTION
P_RU_GTDBase1 view from COMPOSITE
P_RU_GTDBase2 view from COMPOSITE
P_RU_GtdFromBillingDoc view inner COMPOSITE
P_RU_GtdFromPOMM7N view from COMPOSITE
P_RU_GtdFromPOMM7N view union_all COMPOSITE
P_RU_GtdFromPOMM8N view from COMPOSITE
P_RU_GtdFromPOMM8N view union_all COMPOSITE
P_RU_JournalEntry view from CONSUMPTION
P_RU_JrnlEntrRvsdNeg view from CONSUMPTION
P_RU_LinkedCommsnTradeInvoice0 view inner CONSUMPTION
P_RU_MaterialRcptDateMMMvtAccD view inner CONSUMPTION
P_RU_MaterialReceiptDate1 view from CONSUMPTION
P_RU_MaterialReceiptDateMM0 view from COMPOSITE
P_RU_MaterialReceiptDateMM8 view from COMPOSITE
P_RU_MaterialReceiptMM view inner COMPOSITE
P_RU_PseudoReversedDocument view inner CONSUMPTION
P_RU_PseudoReversedDocument1 view from CONSUMPTION
P_RU_RealReversedDocument view from CONSUMPTION
P_RU_ReverseDocuments1 view from COMPOSITE
P_RU_SuplrInvcAcctgItem1 view from CONSUMPTION
P_RU_TaxTransferAcctgDoc view from CONSUMPTION
P_RU_VATDocumentExtraInfo1 view from COMPOSITE
P_RU_VATDocumentExtraInfo1 view union_all COMPOSITE
P_RU_VATDocumentExtraInfo1C view from CONSUMPTION
P_RU_VATExtraInfo view from CONSUMPTION
P_RU_VATExtraInfo view left_outer CONSUMPTION
P_RU_VATInvcJrnlLinkIncgInvc view inner CONSUMPTION
P_RU_VATInvcJrnlLinkOutgInvc view from CONSUMPTION
P_RU_VATInvoiceClearingDP view inner CONSUMPTION
P_RU_VATInvoiceClearingPR view inner CONSUMPTION
P_RU_VATOriginalDocument1 view from CONSUMPTION
P_RU_VATOriginalDocument1 view inner CONSUMPTION
P_RU_VATOriginalDocument1Jrnl view from CONSUMPTION
P_RU_VATReportingRNPT1 view inner CONSUMPTION
P_RU_VATReturnGeneralSection3 view inner CONSUMPTION
P_RU_VATTrdClassfctnNmbr1 view inner CONSUMPTION
P_SI_CustomerVendorLineItem view_entity from COMPOSITE
P_SK_CustRefDocNumVH view inner COMPOSITE
P_SK_StRpVATCSClearingInfo view inner COMPOSITE
P_SK_VATLedgerClearingInfo view_entity inner COMPOSITE
P_SK_VendRefDocNumVH view inner COMPOSITE
P_StRpBillingDocumentItem view inner COMPOSITE
P_StRpSalesInvoiceItem view inner CONSUMPTION Private View for Sales Invoice List
P_StRpSupplierInvoiceItem view inner COMPOSITE
P_TxDocStRpActy0 view from COMPOSITE
P_VE_StRpBPTaxItem view_entity inner COMPOSITE
P_VE_StRpReverseSDDocument view_entity inner COMPOSITE Venezuela StRp Reverse SD Document
R_ES_EDCSalesInvoiceSIITaxItem view_entity inner COMPOSITE Spain SII Customer Inv TaxLines
R_ES_EDCSuplrInvcSIITaxLine view_entity inner COMPOSITE Spain Supplier Invoice Tax lines
R_JournalEntryTP view_entity from TRANSACTIONAL Journal Entry Transaction Processing
R_NO_OpAccDocWthRecnclnKey view_entity from COMPOSITE Norway Acc Docs with Reconciliation Key

Fields (93)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument,belnr,ClearingAccountingDocument,Invoice,OriginalAccountingDocument,OriginalDocument,PaymentDocument,ReversalDocument,RevisionInvoice,SrcDocNmbrForOriginalDocument,SubsequentDocument 107
KEY AccountingDocumentType AccountingDocumentType,blart,JournalEntryType,OriginalDocumentType,ReversalDocumentType 55
KEY BusinessTransactionType BusinessTransactionType 9
KEY CompanyCode bukrs,CompanyCode 90
KEY FiscalYear FiscalYear,gjahr,InvoiceYear,OriginalDocumentYear,OriginalFiscalYear,ReversalDocumentFiscalYear,RevisionInvoiceYear,SrcDocYearForOriginalDocument 93
KEY Ledger Ledger 9
KEY PostingDate budat,InvoicePostingDate,PostingDate,ReportingDate,ReversalDocumentPostingDate 65
KEY ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem 5
_AccountingDocumentCategory _AccountingDocumentCategory 3
_AccountingDocumentType _AccountingDocumentType 11
_AccountingDocumentTypeText _AccountingDocumentTypeText 2
_CompanyCode _CompanyCode 12
_CompanyCodeCurrency _CompanyCodeCurrency 2
_FiscalPeriod _FiscalPeriod 5
_FiscalYear _FiscalYear 11
_RefDocumentLogicalSystem _RefDocumentLogicalSystem 1
_ReferenceDocumentType _ReferenceDocumentType 2
_TransactionCurrency _TransactionCurrency 4
AbsoluteExchangeRate AbsoluteExchangeRate,ExchangeRate,kursf 5
AccountingDocCreatedByUser AccountingDocCreatedByUser,CreatedByUser 18
AccountingDocumentCategory AccountingDocumentCategory,bstat 16
AccountingDocumentClass AccountingDocumentClass 4
AccountingDocumentCreationDate AccountingDocumentCreationDate 11
AccountingDocumentHeaderText AccountingDocumentHeaderText,ltext 20
AdditionalCurrency1 AdditionalCurrency1 5
AdditionalCurrency1Role AdditionalCurrency1Role 1
AdditionalCurrency2 AdditionalCurrency2 5
AdditionalCurrency2Role AdditionalCurrency2Role 1
AlternativeReferenceDocument AlternativeReferenceDocument 6
Branch Branch 4
CompanyCodeCurrency CompanyCodeCurrency 24
CreationTime CreationTime 6
CtryCrcyTxAbsoluteExchangeRate CtryCrcyTxAbsoluteExchangeRate 1
DocumentDate bldat,DefaultExternalInvoiceDate,DocumentDate,InvoiceDate,InvoiceDocumentDate,TransactionDate 55
DocumentReferenceID DocumentReferenceID,Invoice,invxblnr,ReversalDocumentReferenceID,xblnr 40
ExchangeRate ExchangeRate 7
ExchangeRateDate ExchangeRateDate 4
ExchangeRateType ExchangeRateType 4
FinancialManagementArea FinancialManagementArea 2
FiscalPeriod FiscalPeriod 20
IntercompanyTransaction IntercompanyTransaction 5
InvoiceReceiptDate InvoiceReceiptDate 2
IsDiscountDocument IsDiscountDocument 1
IsReversal IsReversal,OriginalDocumentIsReversal,ReversalDocumentIsReversal 22
IsReversed IsReversed,OriginalDocumentIsReversed,ReversalDocumentIsReversed 22
JournalEntryLastChangeDateTime JournalEntryLastChangeDateTime 1
JrnlEntryCntrySpecificBP1 JrnlEntryCntrySpecificBP1 4
JrnlEntryCntrySpecificBP2 JrnlEntryCntrySpecificBP2 4
JrnlEntryCntrySpecificDate1 JrnlEntryCntrySpecificDate1 4
JrnlEntryCntrySpecificDate2 JrnlEntryCntrySpecificDate2 4
JrnlEntryCntrySpecificDate3 JrnlEntryCntrySpecificDate3 4
JrnlEntryCntrySpecificDate4 InvoiceDate,JrnlEntryCntrySpecificDate4 5
JrnlEntryCntrySpecificDate5 JrnlEntryCntrySpecificDate5 4
JrnlEntryCntrySpecificRef1 JrnlEntryCntrySpecificRef1 6
JrnlEntryCntrySpecificRef2 JrnlEntryCntrySpecificRef2 5
JrnlEntryCntrySpecificRef3 JrnlEntryCntrySpecificRef3 4
JrnlEntryCntrySpecificRef4 JrnlEntryCntrySpecificRef4 4
JrnlEntryCntrySpecificRef5 JrnlEntryCntrySpecificRef5 4
LastAutomaticChangeDate LastAutomaticChangeDate 1
LastChangeDate LastChangeDate 1
LastManualChangeDate LastManualChangeDate 2
LedgerGroup LedgerGroup 9
LogicalSystem LogicalSystem,ReferenceDocumentLogicalSystem 3
MarketDataAbsoluteExchangeRate MarketDataAbsoluteExchangeRate 1
NmbrOfPages NmbrOfPages 1
OriginalReferenceDocument ObjectKey,OriginalReferenceDocument 19
ParkedByUser ParkedByUser 1
ParkingDate ParkingDate 1
ParkingTime ParkingTime 1
PlannedReversalDate PlannedReversalDate 2
RecurringAccountingDocument dbblg,RecurringAccountingDocument 2
Reference1InDocumentHeader Reference1InDocumentHeader 4
Reference2InDocumentHeader Reference2InDocumentHeader 3
ReferenceDocumentType ReferenceDocumentType,ReversalDocumentRefDocType 27
ReversalReason ReversalReason 8
ReversalReferenceDocument ReversalRefDoc,ReversalReferenceDocument 8
ReversalReferenceDocumentCntxt ReversalReferenceDocumentCntxt 3
ReverseDocument ReversedDocumentBKPF,ReverseDocument 16
ReverseDocumentFiscalYear ReversedDocumentFiscalYearBKPF,ReverseDocumentFiscalYear 13
SenderAccountingDocument SenderAccountingDocument,SenderCorrectionInvoice,SenderInvoice,SenderRevisionInvoice 13
SenderCompanyCode SenderCompanyCode 13
SenderFiscalYear SenderCorrectionInvoiceYear,SenderFiscalYear,SenderInvoiceYear,SenderRevisionInvoiceYear 13
SenderLogicalSystem SenderLogicalSystem 14
TaxAbsoluteExchangeRate TaxAbsoluteExchangeRate 1
TaxBaseAmountIsNetAmount TaxBaseAmountIsNetAmount 4
TaxCountry TaxCountry 2
TaxExchangeRate TaxExchangeRate 1
TaxFulfillmentDate TaxFulfillmentDate 4
TaxIsCalculatedAutomatically TaxIsCalculatedAutomatically,xmwst 3
TaxReportingDate ReversalDocumentTaxRepDate,TaxReportingDate,vatdate 36
TransactionCode TransactionCode 7
TransactionCurrency Currency,TransactionCurrency,waers 21
WithholdingTaxReportingDate WithholdingTaxReportingDate 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Journal Entry
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_JOURNALENTRY (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTTYPE,
    BUSINESSTRANSACTIONTYPE,
    COMPANYCODE,
    FISCALYEAR,
    LEDGER,
    POSTINGDATE,
    REFERENCEDOCUMENTLOGICALSYSTEM,
    _ACCOUNTINGDOCUMENTCATEGORY,
    _ACCOUNTINGDOCUMENTTYPE,
    _ACCOUNTINGDOCUMENTTYPETEXT,
    _COMPANYCODE,
    _COMPANYCODECURRENCY,
    _FISCALPERIOD,
    _FISCALYEAR,
    _REFDOCUMENTLOGICALSYSTEM,
    _REFERENCEDOCUMENTTYPE,
    _TRANSACTIONCURRENCY,
    ABSOLUTEEXCHANGERATE,
    ACCOUNTINGDOCCREATEDBYUSER,
    ACCOUNTINGDOCUMENTCATEGORY,
    ACCOUNTINGDOCUMENTCLASS,
    ACCOUNTINGDOCUMENTCREATIONDATE,
    ACCOUNTINGDOCUMENTHEADERTEXT,
    ADDITIONALCURRENCY1,
    ADDITIONALCURRENCY1ROLE,
    ADDITIONALCURRENCY2,
    ADDITIONALCURRENCY2ROLE,
    ALTERNATIVEREFERENCEDOCUMENT,
    BRANCH,
    COMPANYCODECURRENCY,
    CREATIONTIME,
    CTRYCRCYTXABSOLUTEEXCHANGERATE,
    DOCUMENTDATE,
    DOCUMENTREFERENCEID,
    EXCHANGERATE,
    EXCHANGERATEDATE,
    EXCHANGERATETYPE,
    FINANCIALMANAGEMENTAREA,
    FISCALPERIOD,
    INTERCOMPANYTRANSACTION,
    INVOICERECEIPTDATE,
    ISDISCOUNTDOCUMENT,
    ISREVERSAL,
    ISREVERSED,
    JOURNALENTRYLASTCHANGEDATETIME,
    JRNLENTRYCNTRYSPECIFICBP1,
    JRNLENTRYCNTRYSPECIFICBP2,
    JRNLENTRYCNTRYSPECIFICDATE1,
    JRNLENTRYCNTRYSPECIFICDATE2,
    JRNLENTRYCNTRYSPECIFICDATE3,
    JRNLENTRYCNTRYSPECIFICDATE4,
    JRNLENTRYCNTRYSPECIFICDATE5,
    JRNLENTRYCNTRYSPECIFICREF1,
    JRNLENTRYCNTRYSPECIFICREF2,
    JRNLENTRYCNTRYSPECIFICREF3,
    JRNLENTRYCNTRYSPECIFICREF4,
    JRNLENTRYCNTRYSPECIFICREF5,
    LASTAUTOMATICCHANGEDATE,
    LASTCHANGEDATE,
    LASTMANUALCHANGEDATE,
    LEDGERGROUP,
    LOGICALSYSTEM,
    MARKETDATAABSOLUTEEXCHANGERATE,
    NMBROFPAGES,
    ORIGINALREFERENCEDOCUMENT,
    PARKEDBYUSER,
    PARKINGDATE,
    PARKINGTIME,
    PLANNEDREVERSALDATE,
    RECURRINGACCOUNTINGDOCUMENT,
    REFERENCE1INDOCUMENTHEADER,
    REFERENCE2INDOCUMENTHEADER,
    REFERENCEDOCUMENTTYPE,
    REVERSALREASON,
    REVERSALREFERENCEDOCUMENT,
    REVERSALREFERENCEDOCUMENTCNTXT,
    REVERSEDOCUMENT,
    REVERSEDOCUMENTFISCALYEAR,
    SENDERACCOUNTINGDOCUMENT,
    SENDERCOMPANYCODE,
    SENDERFISCALYEAR,
    SENDERLOGICALSYSTEM,
    TAXABSOLUTEEXCHANGERATE,
    TAXBASEAMOUNTISNETAMOUNT,
    TAXCOUNTRY,
    TAXEXCHANGERATE,
    TAXFULFILLMENTDATE,
    TAXISCALCULATEDAUTOMATICALLY,
    TAXREPORTINGDATE,
    TRANSACTIONCODE,
    TRANSACTIONCURRENCY,
    WITHHOLDINGTAXREPORTINGDATE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTTYPE, BUSINESSTRANSACTIONTYPE, COMPANYCODE, FISCALYEAR, LEDGER, POSTINGDATE, REFERENCEDOCUMENTLOGICALSYSTEM)
);

Learn More