P_ManageJournalEntryLedgerView

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 P_ManageJournalEntryLedgerView.
-- 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 P_ManageJournalEntryLedgerView AS
SELECT
  cast( '' as fins_technical_ledger ) AS TechnicalLedger,
  _LedgerSourceLedger.Ledger AS SourceLedger,
  _Item.CompanyCode AS CompanyCode,
  _Item.FiscalYear AS FiscalYear,
  _Item.AccountingDocument AS AccountingDocument,
  _Item.LedgerGLLineItem AS LedgerGLLineItem,
  _Item.LedgerFiscalYear AS LedgerFiscalYear,
  _Item.GLRecordType AS GLRecordType,
  _Item.JrnlEntrAltvFYConsecutiveID AS JrnlEntrAltvFYConsecutiveID,
  _Item.ControllingArea AS ControllingArea,
  _Item.BusinessTransactionCategory AS BusinessTransactionCategory,
  _Item.BusinessTransactionType AS BusinessTransactionType,
  _Item.ReferenceDocumentType AS ReferenceDocumentType,
  _Item.ReferenceDocumentContext AS ReferenceDocumentContext,
  _Item.ReferenceDocument AS ReferenceDocument,
  _Item.ReferenceDocumentItem AS ReferenceDocumentItem,
  _Item.ReferenceDocumentItemGroup AS ReferenceDocumentItemGroup,
  _Item.FinancialTransactionType AS FinancialTransactionType,
  _Item.IsReversal AS IsReversal,
  _Item.IsReversed AS IsReversed,
  _Item.ReversalReferenceDocumentCntxt AS ReversalReferenceDocumentCntxt,
  _Item.ReversalReferenceDocument AS ReversalReferenceDocument,
  _Item.IsSettlement AS IsSettlement,
  _Item.IsSettled AS IsSettled,
  _Item.PredecessorReferenceDocCntxt AS PredecessorReferenceDocCntxt,
  _Item.PredecessorReferenceDocItem AS PredecessorReferenceDocItem,
  _Item.PredecessorReferenceDocType AS PredecessorReferenceDocType,
  _Item.PredecessorReferenceDocument AS PredecessorReferenceDocument,
  _Item.SourceReferenceDocument AS SourceReferenceDocument,
  _Item.SourceReferenceDocumentType AS SourceReferenceDocumentType,
  _Item.SourceReferenceDocumentItem AS SourceReferenceDocumentItem,
  _Item.SourceReferenceDocumentCntxt AS SourceReferenceDocumentCntxt,
  _Item.SourceLogicalSystem AS SourceLogicalSystem,
  _Item.SourceReferenceDocSubitem AS SourceReferenceDocSubitem,
  _Item.IsCommitment AS IsCommitment,
  _Item.JrnlEntryItemObsoleteReason AS JrnlEntryItemObsoleteReason,
  _Item.GLBusinessTransactionType AS GLBusinessTransactionType,
  _Item.LogicalSystem AS LogicalSystem,
  _Item.GLAccount AS GLAccount,
  _Item.ChartOfAccounts AS ChartOfAccounts,
  _Item.CostCenter AS CostCenter,
  _Item.ProfitCenter AS ProfitCenter,
  _Item.FunctionalArea AS FunctionalArea,
  _Item.BusinessArea AS BusinessArea,
  _Item.Segment AS Segment,
  _Item.PartnerCostCenter AS PartnerCostCenter,
  _Item.PartnerProfitCenter AS PartnerProfitCenter,
  _Item.PartnerFunctionalArea AS PartnerFunctionalArea,
  _Item.PartnerBusinessArea AS PartnerBusinessArea,
  _Item.PartnerCompany AS PartnerCompany,
  _Item.PartnerSegment AS PartnerSegment,
  _Item.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  _Item.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  _Item.TransactionCurrency AS TransactionCurrency,
  _Item.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  _Item.CompanyCodeCurrency AS CompanyCodeCurrency,
  _Item.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  _Item.GlobalCurrency AS GlobalCurrency,
  _Item.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  _Item.FunctionalCurrency AS FunctionalCurrency,
  _Item.AmountInFunctionalCurrency AS AmountInFunctionalCurrency,
  _Item.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  _Item.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  _Item.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  _Item.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  _Item.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  _Item.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  _Item.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  _Item.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  _Item.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  _Item.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
  _Item.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  _Item.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  _Item.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  _Item.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  _Item.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  _Item.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  _Item.ControllingObjectCurrency AS ControllingObjectCurrency,
  _Item.AmountInObjectCurrency AS AmountInObjectCurrency,
  _Item.GrantCurrency AS GrantCurrency,
  _Item.AmountInGrantCurrency AS AmountInGrantCurrency,
  _Item.BaseUnit AS BaseUnit,
  _Item.Quantity AS Quantity,
  _Item.FixedQuantity AS FixedQuantity,
  _Item.CostSourceUnit AS CostSourceUnit,
  _Item.ValuationQuantity AS ValuationQuantity,
  _Item.ValuationFixedQuantity AS ValuationFixedQuantity,
  _Item.AdditionalQuantity1Unit AS AdditionalQuantity1Unit,
  _Item.AdditionalQuantity1 AS AdditionalQuantity1,
  _Item.AdditionalQuantity2Unit AS AdditionalQuantity2Unit,
  _Item.AdditionalQuantity2 AS AdditionalQuantity2,
  _Item.AdditionalQuantity3Unit AS AdditionalQuantity3Unit,
  _Item.AdditionalQuantity3 AS AdditionalQuantity3,
  _Item.DebitCreditCode AS DebitCreditCode,
  _Item.ExchangeRateDate AS ExchangeRateDate,
  _Item.FiscalPeriod AS FiscalPeriod,
  _Item.FiscalYearVariant AS FiscalYearVariant,
  _Item.FiscalYearPeriod AS FiscalYearPeriod,
  _Item.PostingDate AS PostingDate,
  _Item.DocumentDate AS DocumentDate,
  _Item.AccountingDocumentType AS AccountingDocumentType,
  _Item.AccountingDocumentItem AS AccountingDocumentItem,
  _Item.AssignmentReference AS AssignmentReference,
  _Item.AccountingDocumentCategory AS AccountingDocumentCategory,
  _Item.PostingKey AS PostingKey,
  _Item.TransactionTypeDetermination AS TransactionTypeDetermination,
  _Item.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  _Item.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  _Item.CreationDate AS CreationDate,
  _Item.CreationDateTime AS CreationDateTime,
  _Item.EliminationProfitCenter AS EliminationProfitCenter,
  _Item.OriginObjectType AS OriginObjectType,
  _Item.GLAccountType AS GLAccountType,
  _Item.AlternativeGLAccount AS AlternativeGLAccount,
  _Item.CountryChartOfAccounts AS CountryChartOfAccounts,
  _Item.ConsolidationUnit AS ConsolidationUnit,
  _Item.InvoiceReference AS InvoiceReference,
  _Item.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  _Item.FollowOnDocumentType AS FollowOnDocumentType,
  _Item.InvoiceItemReference AS InvoiceItemReference,
  _Item.PartnerConsolidationUnit AS PartnerConsolidationUnit,
  _Item.Company AS Company,
  _Item.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  _Item.CnsldtnFinancialStatementItem AS CnsldtnFinancialStatementItem,
  _Item.CnsldtnSubitemCategory AS CnsldtnSubitemCategory,
  _Item.CnsldtnSubitem AS CnsldtnSubitem,
  _Item.ReferencePurchaseOrderCategory AS ReferencePurchaseOrderCategory,
  _Item.PurchasingDocument AS PurchasingDocument,
  _Item.PurchasingDocumentItem AS PurchasingDocumentItem,
  _Item.AccountAssignmentNumber AS AccountAssignmentNumber,
  _Item.DocumentItemText AS DocumentItemText,
  _Item.SalesDocument AS SalesDocument,
  _Item.SalesDocumentItem AS SalesDocumentItem,
  _Item.Product AS Product,
  _Item.ProductGroup AS ProductGroup,
  _Item.Plant AS Plant,
  _Item.Supplier AS Supplier,
  _Item.Customer AS Customer,
  _Item.ServicesRenderedDate AS ServicesRenderedDate,
  _Item.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  _Item.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  _Item.FinancialAccountType AS FinancialAccountType,
  _Item.SpecialGLCode AS SpecialGLCode,
  _Item.TaxCode AS TaxCode,
  _Item.TaxCountry AS TaxCountry,
  _Item.HouseBank AS HouseBank,
  _Item.HouseBankAccount AS HouseBankAccount,
  _Item.IsOpenItemManaged AS IsOpenItemManaged,
  _Item.ClearingDate AS ClearingDate,
  _Item.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
  _Item.ClearingJournalEntry AS ClearingJournalEntry,
  _Item.ValueDate AS ValueDate,
  _Item.AssetDepreciationArea AS AssetDepreciationArea,
  _Item.MasterFixedAsset AS MasterFixedAsset,
  _Item.FixedAsset AS FixedAsset,
  _Item.AssetValueDate AS AssetValueDate,
  _Item.AssetTransactionType AS AssetTransactionType,
  _Item.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  _Item.DepreciationFiscalPeriod AS DepreciationFiscalPeriod,
  _Item.GroupMasterFixedAsset AS GroupMasterFixedAsset,
  _Item.GroupFixedAsset AS GroupFixedAsset,
  _Item.PartnerMasterFixedAsset AS PartnerMasterFixedAsset,
  _Item.PartnerFixedAsset AS PartnerFixedAsset,
  _Item.AssetClass AS AssetClass,
  _Item.CostEstimate AS CostEstimate,
  _Item.InventorySpecialStockValnType AS InventorySpecialStockValnType,
  _Item.InventorySpecialStockType AS InventorySpecialStockType,
  _Item.InventorySpclStkSalesDocument AS InventorySpclStkSalesDocument,
  _Item.InventorySpclStkSalesDocItm AS InventorySpclStkSalesDocItm,
  _Item.InvtrySpclStockWBSElmntIntID AS InvtrySpclStockWBSElmntIntID,
  _Item.InventorySpecialStockSupplier AS InventorySpecialStockSupplier,
  _Item.InventoryValuationType AS InventoryValuationType,
  _Item.ValuationArea AS ValuationArea,
  cast( _Item._InvtrySpclStkWBSElmntBscData.WBSElementExternalID as fis_invspstock_wbsext_no_conv ) AS InvtrySpclStockWBSElmntExtID,
  _Item.ProductPriceControl AS ProductPriceControl,
  _Item.SenderGLAccount AS SenderGLAccount,
  _Item.SenderAccountAssignment AS SenderAccountAssignment,
  _Item.SenderAccountAssignmentType AS SenderAccountAssignmentType,
  _Item.ControllingObject AS ControllingObject,
  _Item.CostOriginGroup AS CostOriginGroup,
  _Item.OriginSenderObject AS OriginSenderObject,
  cast(_Item.ControllingDebitCreditCode as fis_co_belkz_conv) AS ControllingDebitCreditCode,
  _Item.ControllingObjectDebitType AS ControllingObjectDebitType,
  _Item.QuantityIsIncomplete AS QuantityIsIncomplete,
  _Item.OffsettingAccount AS OffsettingAccount,
  _Item.OffsettingAccountType AS OffsettingAccountType,
  _Item.OffsettingChartOfAccounts AS OffsettingChartOfAccounts,
  _Item.LineItemIsCompleted AS LineItemIsCompleted,
  _Item.PersonnelNumber AS PersonnelNumber,
  _Item.BillableControl AS BillableControl,
  _Item.ControllingObjectClass AS ControllingObjectClass,
  _Item.PartnerCompanyCode AS PartnerCompanyCode,
  _Item.PartnerControllingObjectClass AS PartnerControllingObjectClass,
  _Item.OriginCostCtrActivityType AS OriginCostCtrActivityType,
  _Item.OriginCostCenter AS OriginCostCenter,
  _Item.OriginProfitCenter AS OriginProfitCenter,
  _Item.OriginProduct AS OriginProduct,
  _Item.VarianceOriginGLAccount AS VarianceOriginGLAccount,
  _Item.AccountAssignment AS AccountAssignment,
  _Item.AccountAssignmentType AS AccountAssignmentType,
  _Item.CostCtrActivityType AS CostCtrActivityType,
  _Item.OrderID AS OrderID,
  _Item.OrderCategory AS OrderCategory,
  _Item.WBSElementInternalID AS WBSElementInternalID,
  cast( _Item._WBSElementBasicData.WBSElementExternalID as fis_wbsext_no_conv ) AS WBSElementExternalID,
  _Item.PartnerWBSElementInternalID AS PartnerWBSElementInternalID,
  cast( _Item._PartnerWBSElementBasicData.WBSElementExternalID as fis_partner_wbsext_no_conv ) AS PartnerWBSElementExternalID,
  _Item.WorkPackage AS WorkPackage,
  _Item.ProjectInternalID AS ProjectInternalID,
  _Item.PartnerProjectInternalID AS PartnerProjectInternalID,
  cast( _Item._PartnerProjectBasicData.ProjectExternalID as fis_part_projectext_no_conv ) AS PartnerProjectExternalID,
  cast( _Item._ProjectBasicData.ProjectExternalID as fis_projectext_no_conv ) AS ProjectExternalID,
  _Item.OperatingConcern AS OperatingConcern,
  _Item.ProjectNetwork AS ProjectNetwork,
  cast(_Item.RelatedNetworkActivity as fis_npvrg_conv) AS RelatedNetworkActivity,
  _Item.BusinessProcess AS BusinessProcess,
  _Item.CostObject AS CostObject,
  _Item.CostAnalysisResource AS CostAnalysisResource,
  _Item.CustomerServiceNotification AS CustomerServiceNotification,
  _Item.ServiceDocumentType AS ServiceDocumentType,
  _Item.ServiceDocument AS ServiceDocument,
  _Item.ServiceDocumentItem AS ServiceDocumentItem,
  _Item.PartnerServiceDocumentType AS PartnerServiceDocumentType,
  _Item.PartnerServiceDocument AS PartnerServiceDocument,
  _Item.PartnerServiceDocumentItem AS PartnerServiceDocumentItem,
  _Item.ServiceContractType AS ServiceContractType,
  _Item.ServiceContract AS ServiceContract,
  _Item.ServiceContractItem AS ServiceContractItem,
  _Item.BusinessSolutionOrder AS BusinessSolutionOrder,
  _Item.BusinessSolutionOrderItem AS BusinessSolutionOrderItem,
  _Item.ProviderContract AS ProviderContract,
  _Item.ProviderContractItem AS ProviderContractItem,
  _Item.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  _Item.PartnerAccountAssignment AS PartnerAccountAssignment,
  _Item.PartnerAccountAssignmentType AS PartnerAccountAssignmentType,
  _Item.PartnerCostCtrActivityType AS PartnerCostCtrActivityType,
  cast(_Item.PartnerOrder as fis_par_aufnr preserving type ) AS PartnerOrder,
  _Item.PartnerOrderCategory AS PartnerOrderCategory,
  _Item.PartnerSalesDocument AS PartnerSalesDocument,
  _Item.PartnerSalesDocumentItem AS PartnerSalesDocumentItem,
  _Item.PartnerProjectNetwork AS PartnerProjectNetwork,
  cast(_Item.PartnerProjectNetworkActivity as fis_par_vornr_auf_conv) AS PartnerProjectNetworkActivity,
  _Item.PartnerBusinessProcess AS PartnerBusinessProcess,
  _Item.PartnerCostObject AS PartnerCostObject,
  _Item.WorkItem AS WorkItem,
  _Item.BillingDocumentType AS BillingDocumentType,
  _Item.SalesOrganization AS SalesOrganization,
  _Item.DistributionChannel AS DistributionChannel,
  _Item.OrganizationDivision AS OrganizationDivision,
  _Item.SoldProduct AS SoldProduct,
  _Item.SoldProductGroup AS SoldProductGroup,
  _Item.CustomerGroup AS CustomerGroup,
  _Item.CustomerSupplierCountry AS CustomerSupplierCountry,
  _Item.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  _Item.SalesDistrict AS SalesDistrict,
  _Item.BillToParty AS BillToParty,
  _Item.ShipToParty AS ShipToParty,
  _Item.CustomerSupplierCorporateGroup AS CustomerSupplierCorporateGroup,
  _Item.CashLedgerCompanyCode AS CashLedgerCompanyCode,
  _Item.CashLedgerAccount AS CashLedgerAccount,
  _Item.FinancialManagementArea AS FinancialManagementArea,
  _Item.FundsCenter AS FundsCenter,
  _Item.FundedProgram AS FundedProgram,
  _Item.Fund AS Fund,
  _Item.GrantID AS GrantID,
  _Item.BudgetPeriod AS BudgetPeriod,
  _Item.PartnerFund AS PartnerFund,
  _Item.PartnerGrant AS PartnerGrant,
  _Item.PartnerBudgetPeriod AS PartnerBudgetPeriod,
  _Item.PubSecBudgetAccount AS PubSecBudgetAccount,
  _Item.PubSecBudgetAccountCoCode AS PubSecBudgetAccountCoCode,
  _Item.PubSecBudgetCnsmpnDate AS PubSecBudgetCnsmpnDate,
  _Item.PubSecBudgetCnsmpnFsclYear AS PubSecBudgetCnsmpnFsclYear,
  _Item.PubSecBudgetCnsmpnFsclPeriod AS PubSecBudgetCnsmpnFsclPeriod,
  _Item.PubSecBudgetIsRelevant AS PubSecBudgetIsRelevant,
  _Item.PubSecBudgetCnsmpnType AS PubSecBudgetCnsmpnType,
  _Item.PubSecBudgetCnsmpnAmtType AS PubSecBudgetCnsmpnAmtType,
  _Item.SponsoredProgram AS SponsoredProgram,
  _Item.SponsoredClass AS SponsoredClass,
  _Item.GteeMBudgetValidityNumber AS GteeMBudgetValidityNumber,
  _Item.CommitmentItem AS CommitmentItem,
  _Item.JointVenture AS JointVenture,
  _Item.JointVentureEquityGroup AS JointVentureEquityGroup,
  _Item.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  _Item.JointVenturePartner AS JointVenturePartner,
  _Item.JointVentureBillingType AS JointVentureBillingType,
  _Item.JointVentureEquityType AS JointVentureEquityType,
  _Item.JointVentureProductionDate AS JointVentureProductionDate,
  _Item.JointVentureBillingDate AS JointVentureBillingDate,
  _Item.JointVentureOperationalDate AS JointVentureOperationalDate,
  _Item.CutbackRun AS CutbackRun,
  _Item.JointVentureAccountingActivity AS JointVentureAccountingActivity,
  _Item.SettlementReferenceDate AS SettlementReferenceDate,
  _Item.PartnerVenture AS PartnerVenture,
  _Item.PartnerEquityGroup AS PartnerEquityGroup,
  _Item.SenderCostRecoveryCode AS SenderCostRecoveryCode,
  _Item.CutbackAccount AS CutbackAccount,
  _Item.CutbackCostObject AS CutbackCostObject,
  _Item.REBusinessEntity AS REBusinessEntity,
  _Item.RealEstateBuilding AS RealEstateBuilding,
  _Item.RealEstateProperty AS RealEstateProperty,
  _Item.RERentalObject AS RERentalObject,
  _Item.RealEstateContract AS RealEstateContract,
  _Item.REServiceChargeKey AS REServiceChargeKey,
  _Item.RESettlementUnitID AS RESettlementUnitID,
  _Item.AccrualObjectType AS AccrualObjectType,
  _Item.AccrualObjectLogicalSystem AS AccrualObjectLogicalSystem,
  _Item.AccrualObject AS AccrualObject,
  _Item.AccrualSubobject AS AccrualSubobject,
  _Item.AccrualItemType AS AccrualItemType,
  _Item.AccrualReferenceObject AS AccrualReferenceObject,
  _Item.AccrualValueDate AS AccrualValueDate,
  _Item.FinancialValuationObjectType AS FinancialValuationObjectType,
  _Item.FinancialValuationObject AS FinancialValuationObject,
  _Item.FinancialValuationSubobject AS FinancialValuationSubobject,
  _Item.NetDueDate AS NetDueDate,
  _Item.CreditRiskClass AS CreditRiskClass,
  cast(_Item.OrderOperation as vdm_vornr) AS OrderOperation,
  _Item.JrnlEntryItemMigrationSource AS JrnlEntryItemMigrationSource,
  cast(_Item.FinancialServicesProductGroup as ffs_product_group preserving type) AS FinancialServicesProductGroup,
  cast(_Item.FinancialServicesBranch as ffs_branch_id preserving type) AS FinancialServicesBranch,
  cast(_Item.FinancialDataSource as ffs_datasource_id preserving type) AS FinancialDataSource,
  cast('STANDARD' as abap.char( 10 )) AS Source,
  _Item._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  _Item._Supplier AS _Supplier,
  _Item._Order AS _Order,
  _Item._Customer AS _Customer,
  _Item._AccountingDocumentType AS _AccountingDocumentType,
  _Item._ServiceDocument AS _ServiceDocument,
  _Item._SalesDocument AS SourceLedgerasTechnicalLedger,
  _Item._SalesDocument AS _SalesDocument
FROM I_GLAccountLineItemRawData AS _Item
INNER JOIN I_CoCodeLedgerSourceLedger AS _LedgerSourceLedger ON /* join condition not captured in parsed metadata */
INNER JOIN I_TechnicalLedger AS _TechnicalLedger ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_GLAccountLineItemRawData
;