R_ManageJournalEntryTP

DDL: R_MANAGEJOURNALENTRYTP Type: view_entity TRANSACTIONAL
103 Fields 1 Data Sources 18 Associations

Journal Entry

R_ManageJournalEntryTP is a Transactional CDS View that provides data about "Journal Entry" in SAP S/4HANA. It reads from 1 data source (R_ManageJournalEntry) and exposes 103 fields with key fields CompanyCode, FiscalYear, AccountingDocument. It has 18 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_ManageJournalEntry _JournalEntry from

Associations (18)

CardinalityTargetAliasCondition
[0..1] I_AccountingDocumentTypeText _AccountingDocumentTypeText _JournalEntry.AccountingDocumentType = _AccountingDocumentTypeText.AccountingDocumentType and _AccountingDocumentTypeText.Language = $session.system_language
[0..1] I_LedgerGroupText _LedgerGroupText _JournalEntry.LedgerGroup = _LedgerGroupText.LedgerGroup and _LedgerGroupText.Language = $session.system_language
[0..1] I_LedgerGroupAssignment _LedgerGroupReprLedger _JournalEntry.LedgerGroup = _LedgerGroupReprLedger.LedgerGroup and _LedgerGroupReprLedger.IsRepresentativeLedger = 'X'
[0..1] I_ReversalReasonText _ReversalReasonText _JournalEntry.ReversalReason = _ReversalReasonText.ReversalReason and _ReversalReasonText.Language = $session.system_language
[0..1] I_ReferenceDocumentTypeText _ReferenceDocumentTypeText _JournalEntry.ReferenceDocumentType = _ReferenceDocumentTypeText.ReferenceDocumentType and _ReferenceDocumentTypeText.Language = $session.system_language
[0..1] I_UserContactCard _CreatedByContactCard $projection.AccountingDocCreatedByUser = _CreatedByContactCard.ContactCardID
[0..1] I_UserContactCard _ParkedByUserContactCard $projection.ParkedByUser = _ParkedByUserContactCard.ContactCardID
[0..1] I_AccountingDocumentCategoryT _AccountingDocumentCategoryT _JournalEntry.AccountingDocumentCategory = _AccountingDocumentCategoryT.AccountingDocumentCategory and _AccountingDocumentCategoryT.Language = $session.system_language
[0..1] I_CurrencyRoleText _CurrencyRoleText_AddCurr1 _JournalEntry.AdditionalCurrency1Role = _CurrencyRoleText_AddCurr1.CurrencyRole and _CurrencyRoleText_AddCurr1.Language = $session.system_language
[0..1] I_CurrencyRoleText _CurrencyRoleText_AddCurr2 _JournalEntry.AdditionalCurrency2Role = _CurrencyRoleText_AddCurr2.CurrencyRole and _CurrencyRoleText_AddCurr2.Language = $session.system_language
[0..1] I_CompanyCode _CompanyCode _JournalEntry.CompanyCode = _CompanyCode.CompanyCode
[0..1] R_ManageJournalEntryAmount _AmountFilter _JournalEntry.CompanyCode = _AmountFilter.CompanyCode and _JournalEntry.FiscalYear = _AmountFilter.FiscalYear and _JournalEntry.AccountingDocument = _AmountFilter.AccountingDocument
[0..1] I_MngJrnlEntrTaxCalcTypeText _MngJrnlEntrTaxCalcTypeText $projection.TaxCalculationType = _MngJrnlEntrTaxCalcTypeText.TaxCalculationType and _MngJrnlEntrTaxCalcTypeText.Language = $session.system_language
[0..1] I_MngJrnlEntrTxBaseAmtOrignTxt _MngJrnlEntrTxBaseAmtOrignTxt $projection.TaxBaseAmountOrigin = _MngJrnlEntrTxBaseAmtOrignTxt.TaxBaseAmountOrigin and _MngJrnlEntrTxBaseAmtOrignTxt.Language = $session.system_language
[0..1] I_MngJrnlEntrDocWrkflwStsText _DocumentWorkflowStatus _JournalEntry.AcctgDocumentWorkflowStatus = _DocumentWorkflowStatus.AcctgDocumentWorkflowStatus and _DocumentWorkflowStatus.Language = $session.system_language
[0..1] I_CountryText _TaxCountryText $projection.TaxCountry = _TaxCountryText.Country and _TaxCountryText.Language = $session.system_language
[0..*] R_OfficialDocumentNumberTP _OfficialDocumentNumberTP _OfficialDocumentNumberTP.AFDFDocumentKey1 = $projection.CompanyCode and _OfficialDocumentNumberTP.AFDFDocumentKey2 = $projection.AccountingDocument and _OfficialDocumentNumberTP.AFDFDocumentKey3 = $projection.FiscalYear
[0..*] R_ManageJournalEntryItemTP _ItemEntryView

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Journal Entry view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.sapObjectNodeType.name JournalEntry view

Fields (103)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode R_ManageJournalEntry CompanyCode Receiver Company Code
KEY FiscalYear R_ManageJournalEntry FiscalYear G/L Fiscal Year
KEY AccountingDocument R_ManageJournalEntry AccountingDocument Journal Entry
Ledger R_ManageJournalEntry Ledger Ledger
AccountingDocumentCategory R_ManageJournalEntry AccountingDocumentCategory Journal Entry Category
AccountingDocumentHeaderText R_ManageJournalEntry AccountingDocumentHeaderText Doc.Header Text
SenderAccountingDocument R_ManageJournalEntry SenderAccountingDocument Sender Journal Entry
AccountingDocumentType R_ManageJournalEntry AccountingDocumentType Journal Entry Type
AdditionalCurrency1 R_ManageJournalEntry AdditionalCurrency1 Local curr. 2
AdditionalCurrency1Role R_ManageJournalEntry AdditionalCurrency1Role LC2 Crcy Type
AdditionalCurrency2 R_ManageJournalEntry AdditionalCurrency2 Local curr. 3
AdditionalCurrency2Role R_ManageJournalEntry AdditionalCurrency2Role LC3 Crcy Type
AlternativeReferenceDocument
Branch R_ManageJournalEntry Branch Repository branch
BusinessTransactionType R_ManageJournalEntry BusinessTransactionType Bus.transaction
CompanyCodeCurrency R_ManageJournalEntry CompanyCodeCurrency Local Currency
SenderCompanyCode R_ManageJournalEntry SenderCompanyCode Sender Company Code
AccountingDocCreatedByUser R_ManageJournalEntry AccountingDocCreatedByUser User which created overhead document
AccountingDocumentCreationDate R_ManageJournalEntry AccountingDocumentCreationDate Journal Entry Date
CreationTime R_ManageJournalEntry CreationTime Time of Change
CreationDateTime R_ManageJournalEntry CreationDateTime Timestamp
DocumentDate R_ManageJournalEntry DocumentDate Journal Entry Date
DocumentReferenceID R_ManageJournalEntry DocumentReferenceID Reference
AbsoluteExchangeRate R_ManageJournalEntry AbsoluteExchangeRate Absolute Exchange Rate
ExchangeRateDate R_ManageJournalEntry ExchangeRateDate Translatn Date
TaxAbsoluteExchangeRate R_ManageJournalEntry TaxAbsoluteExchangeRate Absolute Tax Exchange Rate
CtryCrcyTxAbsoluteExchangeRate R_ManageJournalEntry CtryCrcyTxAbsoluteExchangeRate Absolute Tax Exch. Rate in C/R Cur.
MarketDataAbsoluteExchangeRate R_ManageJournalEntry MarketDataAbsoluteExchangeRate Absolute Market Data Exch. Rate
TaxCountry R_ManageJournalEntry TaxCountry Tax Ctry/Reg.
ExchangeRateType R_ManageJournalEntry ExchangeRateType Exch. Rate Type
FiscalPeriod R_ManageJournalEntry FiscalPeriod Tax period
FiscalYearPeriod R_ManageJournalEntry FiscalYearPeriod Period/Year
SenderFiscalYear R_ManageJournalEntry SenderFiscalYear Sender FiscalYr
IntercompanyTransaction R_ManageJournalEntry IntercompanyTransaction Intercompany Transaction
InvoiceReceiptDate R_ManageJournalEntry InvoiceReceiptDate Invoice Receipt Date
LastManualChangeDate R_ManageJournalEntry LastManualChangeDate Manual Change Date
LastAutomaticChangeDate R_ManageJournalEntry LastAutomaticChangeDate Autom. Change Date
LedgerGroup R_ManageJournalEntry LedgerGroup Ledger Group
SenderLogicalSystem R_ManageJournalEntry SenderLogicalSystem Sender Logical System
NmbrOfPages R_ManageJournalEntry NmbrOfPages SDS Number of Pages
OriginalReferenceDocument R_ManageJournalEntry OriginalReferenceDocument Reference Key
ReferenceDocumentLogicalSystem R_ManageJournalEntry ReferenceDocumentLogicalSystem Ref. Doc. Lgcl Syst.
ParkingTime R_ManageJournalEntry ParkingTime Parked At
ParkedByUser R_ManageJournalEntry ParkedByUser JE Parked By
ParkingDate R_ManageJournalEntry ParkingDate Parked On
ParkingDateTime R_ManageJournalEntry ParkingDateTime Time Stamp
PostingDate R_ManageJournalEntry PostingDate Posting Date for GR
RecurringAccountingDocument R_ManageJournalEntry RecurringAccountingDocument Recurring Journal Entry
Reference1InDocumentHeader R_ManageJournalEntry Reference1InDocumentHeader Reference 1
Reference2InDocumentHeader R_ManageJournalEntry Reference2InDocumentHeader Reference 2
ReferenceDocumentType R_ManageJournalEntry ReferenceDocumentType Reference Document Type
ReversalReason R_ManageJournalEntry ReversalReason Reversal Reason
ReverseDocument R_ManageJournalEntry ReverseDocument Reversed With
ReversedDocument R_ManageJournalEntry ReversedDocument Reversed doc.
ReverseDocumentFiscalYear R_ManageJournalEntry ReverseDocumentFiscalYear Year
ReversalReferenceDocument R_ManageJournalEntry ReversalReferenceDocument Reversal Reference Document
ReversedReferenceDocument R_ManageJournalEntry ReversedReferenceDocument Reversed Reference Document
IsReversal R_ManageJournalEntry IsReversal Reversal doc.
IsReversed R_ManageJournalEntry IsReversed Reversed?
PlannedReversalDate R_ManageJournalEntry PlannedReversalDate Reversal Date
TaxBaseAmountIsNetAmount R_ManageJournalEntry TaxBaseAmountIsNetAmount Tax Base Amount is Net Amount
TaxBaseAmountOrigin R_ManageJournalEntry TaxBaseAmountOrigin Tax Based On
TaxFulfillmentDate R_ManageJournalEntry TaxFulfillmentDate Tax Settlement Date
TaxIsCalculatedAutomatically R_ManageJournalEntry TaxIsCalculatedAutomatically Tax Is Automatically Calculated
TaxCalculationType R_ManageJournalEntry TaxCalculationType Tax Calculation
TaxReportingDate R_ManageJournalEntry TaxReportingDate Tax Reporting Date
WithholdingTaxReportingDate R_ManageJournalEntry WithholdingTaxReportingDate Withholding Tax Reporting Date
TransactionCode R_ManageJournalEntry TransactionCode Transaction Code
TransactionCurrency R_ManageJournalEntry TransactionCurrency Transaction Currency
JrnlEntryCntrySpecificRef1 R_ManageJournalEntry JrnlEntryCntrySpecificRef1 Country/Region Specific Reference 1
JrnlEntryCntrySpecificDate1 R_ManageJournalEntry JrnlEntryCntrySpecificDate1 Country/Region Specific Date 1
JrnlEntryCntrySpecificRef2 R_ManageJournalEntry JrnlEntryCntrySpecificRef2 Country/Region Specific Reference 2
JrnlEntryCntrySpecificDate2 R_ManageJournalEntry JrnlEntryCntrySpecificDate2 Country/Region Specific Date 2
JrnlEntryCntrySpecificRef3 R_ManageJournalEntry JrnlEntryCntrySpecificRef3 Country/Region Specific Reference 3
JrnlEntryCntrySpecificDate3 R_ManageJournalEntry JrnlEntryCntrySpecificDate3 Country/Region Specific Date 3
JrnlEntryCntrySpecificRef4 R_ManageJournalEntry JrnlEntryCntrySpecificRef4 Country/Region Specific Reference 4
JrnlEntryCntrySpecificDate4 R_ManageJournalEntry JrnlEntryCntrySpecificDate4 Country/Region Specific Date 4
JrnlEntryCntrySpecificRef5 R_ManageJournalEntry JrnlEntryCntrySpecificRef5 Country/Region Specific Reference 5
JrnlEntryCntrySpecificDate5 R_ManageJournalEntry JrnlEntryCntrySpecificDate5 Country/Region Specific Date 5
JrnlEntryCntrySpecificBP1 R_ManageJournalEntry JrnlEntryCntrySpecificBP1 Ctry/Reg. Specific Business Partner 1
JrnlEntryCntrySpecificBP2 R_ManageJournalEntry JrnlEntryCntrySpecificBP2 Ctry/Reg. Specific Business Partner 2
AcctgDocumentWorkflowStatus R_ManageJournalEntry AcctgDocumentWorkflowStatus Workflow Status
WrkflwScenIsActv R_ManageJournalEntry WrkflwScenIsActv
AccountingDocumentIsReversible R_ManageJournalEntry AccountingDocumentIsReversible
JournalEntryLastChangeDateTime R_ManageJournalEntry JournalEntryLastChangeDateTime Journal Entry Last Change Date Time
LastChangeDateTime R_ManageJournalEntry JournalEntryLastChangeDateTime Journal Entry Last Change Date Time
_ItemEntryView _ItemEntryView
_OfficialDocumentNumberTP _OfficialDocumentNumberTP
_AmountFilter _AmountFilter
_CreatedByContactCard _CreatedByContactCard
_ParkedByUserContactCard _ParkedByUserContactCard
_MngJrnlEntrTaxCalcTypeText _MngJrnlEntrTaxCalcTypeText
_MngJrnlEntrTxBaseAmtOrignTxt _MngJrnlEntrTxBaseAmtOrignTxt
_AccountingDocumentCategoryT _AccountingDocumentCategoryT
_AccountingDocumentTypeText _AccountingDocumentTypeText
_CompanyCode _CompanyCode
_LedgerGroupText _LedgerGroupText
_ReferenceDocumentTypeText _ReferenceDocumentTypeText
_ReversalReasonText _ReversalReasonText
_DocumentWorkflowStatus _DocumentWorkflowStatus
_TaxCountryText _TaxCountryText
_AccountingDocumentType _AccountingDocumentType
_LedgerGroupReprLedger _LedgerGroupReprLedger

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_ManageJournalEntryTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_ManageJournalEntryTP AS
SELECT
  _JournalEntry.CompanyCode AS CompanyCode,
  _JournalEntry.FiscalYear AS FiscalYear,
  _JournalEntry.AccountingDocument AS AccountingDocument,
  _JournalEntry.Ledger AS Ledger,
  _JournalEntry.AccountingDocumentCategory AS AccountingDocumentCategory,
  _JournalEntry.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  _JournalEntry.SenderAccountingDocument AS SenderAccountingDocument,
  _JournalEntry.AccountingDocumentType AS AccountingDocumentType,
  _JournalEntry.AdditionalCurrency1 AS AdditionalCurrency1,
  _JournalEntry.AdditionalCurrency1Role AS AdditionalCurrency1Role,
  _JournalEntry.AdditionalCurrency2 AS AdditionalCurrency2,
  _JournalEntry.AdditionalCurrency2Role AS AdditionalCurrency2Role,
  cast(_JournalEntry.AlternativeReferenceDocument as fis_xblnr_alt_wo_exit) AS AlternativeReferenceDocument,
  _JournalEntry.Branch AS Branch,
  _JournalEntry.BusinessTransactionType AS BusinessTransactionType,
  _JournalEntry.CompanyCodeCurrency AS CompanyCodeCurrency,
  _JournalEntry.SenderCompanyCode AS SenderCompanyCode,
  _JournalEntry.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  _JournalEntry.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  _JournalEntry.CreationTime AS CreationTime,
  _JournalEntry.CreationDateTime AS CreationDateTime,
  _JournalEntry.DocumentDate AS DocumentDate,
  _JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  _JournalEntry.AbsoluteExchangeRate AS AbsoluteExchangeRate,
  _JournalEntry.ExchangeRateDate AS ExchangeRateDate,
  _JournalEntry.TaxAbsoluteExchangeRate AS TaxAbsoluteExchangeRate,
  _JournalEntry.CtryCrcyTxAbsoluteExchangeRate AS CtryCrcyTxAbsoluteExchangeRate,
  _JournalEntry.MarketDataAbsoluteExchangeRate AS MarketDataAbsoluteExchangeRate,
  _JournalEntry.TaxCountry AS TaxCountry,
  _JournalEntry.ExchangeRateType AS ExchangeRateType,
  _JournalEntry.FiscalPeriod AS FiscalPeriod,
  _JournalEntry.FiscalYearPeriod AS FiscalYearPeriod,
  _JournalEntry.SenderFiscalYear AS SenderFiscalYear,
  _JournalEntry.IntercompanyTransaction AS IntercompanyTransaction,
  _JournalEntry.InvoiceReceiptDate AS InvoiceReceiptDate,
  _JournalEntry.LastManualChangeDate AS LastManualChangeDate,
  _JournalEntry.LastAutomaticChangeDate AS LastAutomaticChangeDate,
  _JournalEntry.LedgerGroup AS LedgerGroup,
  _JournalEntry.SenderLogicalSystem AS SenderLogicalSystem,
  _JournalEntry.NmbrOfPages AS NmbrOfPages,
  _JournalEntry.OriginalReferenceDocument AS OriginalReferenceDocument,
  _JournalEntry.ReferenceDocumentLogicalSystem AS ReferenceDocumentLogicalSystem,
  _JournalEntry.ParkingTime AS ParkingTime,
  _JournalEntry.ParkedByUser AS ParkedByUser,
  _JournalEntry.ParkingDate AS ParkingDate,
  _JournalEntry.ParkingDateTime AS ParkingDateTime,
  _JournalEntry.PostingDate AS PostingDate,
  _JournalEntry.RecurringAccountingDocument AS RecurringAccountingDocument,
  _JournalEntry.Reference1InDocumentHeader AS Reference1InDocumentHeader,
  _JournalEntry.Reference2InDocumentHeader AS Reference2InDocumentHeader,
  _JournalEntry.ReferenceDocumentType AS ReferenceDocumentType,
  _JournalEntry.ReversalReason AS ReversalReason,
  _JournalEntry.ReverseDocument AS ReverseDocument,
  _JournalEntry.ReversedDocument AS ReversedDocument,
  _JournalEntry.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  _JournalEntry.ReversalReferenceDocument AS ReversalReferenceDocument,
  _JournalEntry.ReversedReferenceDocument AS ReversedReferenceDocument,
  _JournalEntry.IsReversal AS IsReversal,
  _JournalEntry.IsReversed AS IsReversed,
  _JournalEntry.PlannedReversalDate AS PlannedReversalDate,
  _JournalEntry.TaxBaseAmountIsNetAmount AS TaxBaseAmountIsNetAmount,
  _JournalEntry.TaxBaseAmountOrigin AS TaxBaseAmountOrigin,
  _JournalEntry.TaxFulfillmentDate AS TaxFulfillmentDate,
  _JournalEntry.TaxIsCalculatedAutomatically AS TaxIsCalculatedAutomatically,
  _JournalEntry.TaxCalculationType AS TaxCalculationType,
  _JournalEntry.TaxReportingDate AS TaxReportingDate,
  _JournalEntry.WithholdingTaxReportingDate AS WithholdingTaxReportingDate,
  _JournalEntry.TransactionCode AS TransactionCode,
  _JournalEntry.TransactionCurrency AS TransactionCurrency,
  _JournalEntry.JrnlEntryCntrySpecificRef1 AS JrnlEntryCntrySpecificRef1,
  _JournalEntry.JrnlEntryCntrySpecificDate1 AS JrnlEntryCntrySpecificDate1,
  _JournalEntry.JrnlEntryCntrySpecificRef2 AS JrnlEntryCntrySpecificRef2,
  _JournalEntry.JrnlEntryCntrySpecificDate2 AS JrnlEntryCntrySpecificDate2,
  _JournalEntry.JrnlEntryCntrySpecificRef3 AS JrnlEntryCntrySpecificRef3,
  _JournalEntry.JrnlEntryCntrySpecificDate3 AS JrnlEntryCntrySpecificDate3,
  _JournalEntry.JrnlEntryCntrySpecificRef4 AS JrnlEntryCntrySpecificRef4,
  _JournalEntry.JrnlEntryCntrySpecificDate4 AS JrnlEntryCntrySpecificDate4,
  _JournalEntry.JrnlEntryCntrySpecificRef5 AS JrnlEntryCntrySpecificRef5,
  _JournalEntry.JrnlEntryCntrySpecificDate5 AS JrnlEntryCntrySpecificDate5,
  _JournalEntry.JrnlEntryCntrySpecificBP1 AS JrnlEntryCntrySpecificBP1,
  _JournalEntry.JrnlEntryCntrySpecificBP2 AS JrnlEntryCntrySpecificBP2,
  _JournalEntry.AcctgDocumentWorkflowStatus AS AcctgDocumentWorkflowStatus,
  _JournalEntry.WrkflwScenIsActv AS WrkflwScenIsActv,
  _JournalEntry.AccountingDocumentIsReversible AS AccountingDocumentIsReversible,
  _JournalEntry.JournalEntryLastChangeDateTime AS JournalEntryLastChangeDateTime,
  _JournalEntry.JournalEntryLastChangeDateTime AS LastChangeDateTime
FROM R_ManageJournalEntry AS _JournalEntry
LEFT OUTER JOIN I_AccountingDocumentTypeText AS _AccountingDocumentTypeText ON _JournalEntry.AccountingDocumentType = _AccountingDocumentTypeText.AccountingDocumentType AND _AccountingDocumentTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LedgerGroupText AS _LedgerGroupText ON _JournalEntry.LedgerGroup = _LedgerGroupText.LedgerGroup AND _LedgerGroupText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LedgerGroupAssignment AS _LedgerGroupReprLedger ON _JournalEntry.LedgerGroup = _LedgerGroupReprLedger.LedgerGroup AND _LedgerGroupReprLedger.IsRepresentativeLedger = 'X'  -- association [0..1]
LEFT OUTER JOIN I_ReversalReasonText AS _ReversalReasonText ON _JournalEntry.ReversalReason = _ReversalReasonText.ReversalReason AND _ReversalReasonText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ReferenceDocumentTypeText AS _ReferenceDocumentTypeText ON _JournalEntry.ReferenceDocumentType = _ReferenceDocumentTypeText.ReferenceDocumentType AND _ReferenceDocumentTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByContactCard ON AccountingDocCreatedByUser = _CreatedByContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ParkedByUserContactCard ON ParkedByUser = _ParkedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentCategoryT AS _AccountingDocumentCategoryT ON _JournalEntry.AccountingDocumentCategory = _AccountingDocumentCategoryT.AccountingDocumentCategory AND _AccountingDocumentCategoryT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRoleText AS _CurrencyRoleText_AddCurr1 ON _JournalEntry.AdditionalCurrency1Role = _CurrencyRoleText_AddCurr1.CurrencyRole AND _CurrencyRoleText_AddCurr1.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRoleText AS _CurrencyRoleText_AddCurr2 ON _JournalEntry.AdditionalCurrency2Role = _CurrencyRoleText_AddCurr2.CurrencyRole AND _CurrencyRoleText_AddCurr2.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON _JournalEntry.CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN R_ManageJournalEntryAmount AS _AmountFilter ON _JournalEntry.CompanyCode = _AmountFilter.CompanyCode AND _JournalEntry.FiscalYear = _AmountFilter.FiscalYear AND _JournalEntry.AccountingDocument = _AmountFilter.AccountingDocument  -- association [0..1]
LEFT OUTER JOIN I_MngJrnlEntrTaxCalcTypeText AS _MngJrnlEntrTaxCalcTypeText ON TaxCalculationType = _MngJrnlEntrTaxCalcTypeText.TaxCalculationType AND _MngJrnlEntrTaxCalcTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MngJrnlEntrTxBaseAmtOrignTxt AS _MngJrnlEntrTxBaseAmtOrignTxt ON TaxBaseAmountOrigin = _MngJrnlEntrTxBaseAmtOrignTxt.TaxBaseAmountOrigin AND _MngJrnlEntrTxBaseAmtOrignTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MngJrnlEntrDocWrkflwStsText AS _DocumentWorkflowStatus ON _JournalEntry.AcctgDocumentWorkflowStatus = _DocumentWorkflowStatus.AcctgDocumentWorkflowStatus AND _DocumentWorkflowStatus.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _TaxCountryText ON TaxCountry = _TaxCountryText.Country AND _TaxCountryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN R_OfficialDocumentNumberTP AS _OfficialDocumentNumberTP ON _OfficialDocumentNumberTP.AFDFDocumentKey1 = CompanyCode AND _OfficialDocumentNumberTP.AFDFDocumentKey2 = AccountingDocument AND _OfficialDocumentNumberTP.AFDFDocumentKey3 = FiscalYear  -- association [0..*]
LEFT OUTER JOIN R_ManageJournalEntryItemTP AS _ItemEntryView ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More