C_JournalEntryItemBrowser

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 C_JournalEntryItemBrowser.
-- 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.
-- Parameters: P_DisplayCurrency : vdm_v_display_currency, P_ExchangeRateType : kurst, P_ExchangeRateDate : vdm_v_exchange_rate_date, P_KeyDate : vdm_v_key_date, P_ClearingStatusSelection : fis_clearingstatusselection

CREATE VIEW C_JournalEntryItemBrowser AS
SELECT
  entity: { name: 'I_CurrencyStdVH' , element: 'Currency' AS LedgerGLLineItem,
  multipleSelections: false AS multipleSelectionsfalse,
  mandatory: true AS ReferenceDocumentItemGroup,
  mandatory: false AS IsReversal,
  mandatory: false AS ReversalReferenceDocument,
  mandatory: false AS IsSettlement,
  mandatory: false AS SourceReferenceDocSubitem,
  mandatory: false AS LastChangeDateTime,
  multipleSelections: false AS Supplier,
  { entity: { name: 'I_BPCustomerMultiAddrVH', element: 'Customer' AS _MasterFixedAssetText
FROM I_JournalEntryItemBrowser
LEFT OUTER JOIN I_WBSElement AS _WBSElement ON WBSElement = _WBSElement.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _WBSElementText ON WBSElement = _WBSElementText.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _InventorySpclStockWBSElement ON InventorySpclStockWBSElement = _InventorySpclStockWBSElement.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _InvtrySpclStockWBSElmntText ON InventorySpclStockWBSElement = _InvtrySpclStockWBSElmntText.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _PartnerWBSElement ON PartnerWBSElement = _PartnerWBSElement.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _PartnerWBSElementText ON PartnerWBSElement = _PartnerWBSElementText.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByInternalKey AS _WBSElementInternalID ON WBSElementInternalID = _WBSElementInternalID.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByInternalKey AS _WBSElementInternalIDText ON WBSElementInternalID = _WBSElementInternalIDText.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_Project AS _Project ON Project = _Project.Project  -- association [0..1]
LEFT OUTER JOIN I_Project AS _ProjectText ON Project = _ProjectText.Project  -- association [0..1]
LEFT OUTER JOIN I_Project AS _PartnerProject ON PartnerProject = _PartnerProject.Project  -- association [0..1]
LEFT OUTER JOIN I_Project AS _PartnerProjectText ON PartnerProject = _PartnerProjectText.Project  -- association [0..1]
LEFT OUTER JOIN I_ProjectByInternalKey AS _ProjectInternalID ON ProjectInternalID = _ProjectInternalID.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByInternalKey AS _ProjectInternalIDText ON ProjectInternalID = _ProjectInternalIDText.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _ProjectExternalIDText ON ProjectExternalID = _ProjectExternalIDText.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalIDText ON WBSElementExternalID = _WBSElementExternalIDText.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectBasicData AS _ProjectBasicData ON ProjectInternalID = _ProjectBasicData.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectBasicData AS _ProjectBasicDataText ON ProjectInternalID = _ProjectBasicDataText.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectBasicData AS _PartnerProjectBasicData ON PartnerProjectInternalID = _PartnerProjectBasicData.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectBasicData AS _PartnerProjectBasicDataText ON PartnerProjectInternalID = _PartnerProjectBasicDataText.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicDataText ON WBSElementInternalID = _WBSElementBasicDataText.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _PartnerWBSElementBasicData ON PartnerWBSElementInternalID = _PartnerWBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _PartnerWBSElemntBasicDataText ON PartnerWBSElementInternalID = _PartnerWBSElemntBasicDataText.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _InvtrySpclStockWBSElmntExtID ON InvtrySpclStockWBSElmntExtID = _InvtrySpclStockWBSElmntExtID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _PartnerWBSElemntExtrnalIDText ON PartnerWBSElementExternalID = _PartnerWBSElemntExtrnalIDText.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _PartnerProjctExtrnalIDText ON PartnerProjectExternalID = _PartnerProjctExtrnalIDText.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_LedgerCompanyCodeVH AS _LedgerCompanyCodeVH ON Ledger = _LedgerCompanyCodeVH.Ledger AND CompanyCode = _LedgerCompanyCodeVH.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _GLAccountInCompanyCode ON CompanyCode = _GLAccountInCompanyCode.CompanyCode AND GLAccount = _GLAccountInCompanyCode.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _UserContactCard ON AccountingDocCreatedByUser = _UserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_TimeSheetOvertimeCatText AS _TimeSheetOvertimeCatText ON TimeSheetOvertimeCategory = _TimeSheetOvertimeCatText.TimeSheetOvertimeCategory  -- association [0..*]
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _OperationalAcctgDocItem ON CompanyCode = _OperationalAcctgDocItem.CompanyCode AND FiscalYear = _OperationalAcctgDocItem.FiscalYear AND AccountingDocument = _OperationalAcctgDocItem.AccountingDocument AND AccountingDocumentItem = _OperationalAcctgDocItem.AccountingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON ControllingArea = _ProfitCenterText.ControllingArea AND ProfitCenter = _ProfitCenterText.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON ControllingArea = _CostCenterText.ControllingArea AND CostCenter = _CostCenterText.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_GLAccountText AS _GLAccountText ON ChartOfAccounts = _GLAccountText.ChartOfAccounts AND GLAccount = _GLAccountText.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_GLAccountTextRawData AS _GLAccountTextRawData ON ChartOfAccounts = _GLAccountTextRawData.ChartOfAccounts AND GLAccount = _GLAccountTextRawData.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenterText AS _PartnerProfitCenterText ON ControllingArea = _PartnerProfitCenterText.ControllingArea AND PartnerProfitCenter = _PartnerProfitCenterText.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenterText AS _OriginCostCenterText ON ControllingArea = _OriginCostCenterText.ControllingArea AND OriginCostCenter = _OriginCostCenterText.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenterActivityTypeText AS _OriginCostCtrActivityTypeText ON ControllingArea = _OriginCostCtrActivityTypeText.ControllingArea AND OriginCostCtrActivityType = _OriginCostCtrActivityTypeText.CostCtrActivityType  -- association [0..*]
LEFT OUTER JOIN I_ProductText AS _ProductText ON Product = _ProductText.Product  -- association [0..*]
LEFT OUTER JOIN I_ProductText AS _SoldProductText ON SoldProduct = _SoldProductText.Product  -- association [0..*]
LEFT OUTER JOIN I_SubLedgerAccLineItemTypeT AS _SubLedgerAccLineItemTypeT ON SubLedgerAcctLineItemType = _SubLedgerAccLineItemTypeT.SubLedgerAcctLineItemType  -- association [0..*]
LEFT OUTER JOIN I_SponsoredProgramTextCore AS _SponsoredProgramCoreText ON SponsoredProgram = _SponsoredProgramCoreText.SponsoredProgram  -- association [0..*]
LEFT OUTER JOIN I_SponsoredClassCoreText AS _SponsoredClassCoreText ON SponsoredClass = _SponsoredClassCoreText.SponsoredClass  -- association [0..*]
LEFT OUTER JOIN I_PubSecBdgtCnsmpnAmtTypeText AS _PubSecBdgtCnsmpnAmtTypeT ON PubSecBudgetCnsmpnAmtType = _PubSecBdgtCnsmpnAmtTypeT.PubSecBudgetCnsmpnAmtType  -- association [0..*]
LEFT OUTER JOIN I_PubSecBdgtCnsmpnTypeText AS _PubSecBdgtCnsmpnTypeText ON PubSecBudgetCnsmpnType = _PubSecBdgtCnsmpnTypeText.PubSecBudgetCnsmpnType  -- association [0..*]
LEFT OUTER JOIN I_BudgetAccountText AS _BudgetAccountText ON ChartOfAccounts = _BudgetAccountText.ChartOfAccounts AND PubSecBudgetAccount = _BudgetAccountText.PubSecBudgetAccount  -- association [0..*]
LEFT OUTER JOIN I_BudgetPeriodText AS _BudgetPeriodText ON BudgetPeriod = _BudgetPeriodText.BudgetPeriod  -- association [0..*]
LEFT OUTER JOIN I_BudgetPeriodText AS _PartnerBudgetPeriodText ON PartnerBudgetPeriod = _PartnerBudgetPeriodText.BudgetPeriod  -- association [0..*]
LEFT OUTER JOIN I_GLAccountText AS _CashLedgerAccountText ON ChartOfAccounts = _CashLedgerAccountText.ChartOfAccounts AND CashLedgerAccount = _CashLedgerAccountText.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_FundText AS _FundText ON FinancialManagementArea = _FundText.FinancialManagementArea AND Fund = _FundText.Fund  -- association [0..*]
LEFT OUTER JOIN I_FundText AS _PartnerFundText ON FinancialManagementArea = _PartnerFundText.FinancialManagementArea AND PartnerFund = _PartnerFundText.Fund  -- association [0..*]
LEFT OUTER JOIN I_GrantText AS _GrantText ON GrantID = _GrantText.GrantID  -- association [0..*]
LEFT OUTER JOIN I_GrantText AS _PartnerGrantText ON PartnerGrant = _PartnerGrantText.GrantID  -- association [0..*]
LEFT OUTER JOIN I_FundedProgramText AS _FundedProgramText ON FinancialManagementArea = _FundedProgramText.FinancialManagementArea AND FundedProgram = _FundedProgramText.FundedProgram  -- association [0..*]
LEFT OUTER JOIN I_FundsCenterText AS _FundsCenterText ON FinancialManagementArea = _FundsCenterText.FinancialManagementArea AND FundsCenter = _FundsCenterText.FundsCenter  -- association [0..*]
LEFT OUTER JOIN I_Order AS _PartnerOrder_2 ON PartnerOrder = _PartnerOrder_2.OrderID  -- association [0..1]
LEFT OUTER JOIN I_Order AS _PartnerOrderText_2 ON PartnerOrder = _PartnerOrderText_2.OrderID  -- association [0..1]
LEFT OUTER JOIN I_Order AS _OrderIDText ON OrderID = _OrderIDText.OrderID  -- association [0..1]
LEFT OUTER JOIN I_InternalOrder AS _PartnerOrderText ON PartnerOrder = _PartnerOrderText.InternalOrder  -- association [0..1]
LEFT OUTER JOIN I_InternalOrder AS _PartnerOrder ON PartnerOrder = _PartnerOrder.InternalOrder  -- association [0..1]
LEFT OUTER JOIN C_BusinessPartner AS _BusinessPartner ON Customer = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_CustomerGroupText AS _CustomerGroupText ON CustomerGroup = _CustomerGroupText.CustomerGroup  -- association [0..*]
LEFT OUTER JOIN I_CustomerSupplierIndustryText AS _CustomerSupplierIndustryText ON CustomerSupplierIndustry = _CustomerSupplierIndustryText.Industry  -- association [0..*]
LEFT OUTER JOIN I_CountryText AS _CustomerSupplierCountryText ON CustomerSupplierCountry = _CustomerSupplierCountryText.Country  -- association [0..*]
;