FAC_DART_Z3_JOURNAL_ENTRY

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 FAC_DART_Z3_JOURNAL_ENTRY.
-- 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.
-- SQL view name: FAC_DZJOURNALENT
-- Parameters: P_FiscalYear : fins_gjahr, P_FromFiscalPeriod : fins_fagl_fiscper_from, P_ToFiscalPeriod : fins_fagl_fiscper_to

CREATE VIEW FAC_DART_Z3_JOURNAL_ENTRY AS
SELECT
  Ledger,
  SourceLedger,
  I_GLAccountLineItemCube.CompanyCode AS CompanyCode,
  I_GLAccountLineItemCube.FiscalYear AS FiscalYear,
  I_GLAccountLineItemCube.AccountingDocument AS AccountingDocument,
  I_GLAccountLineItemCube.LedgerGLLineItem AS LedgerGLLineItem,
  I_GLAccountLineItemCube.GLAccount AS GLAccount,
  _GLAcctInChartOfAccountsText[1: Language = $session.system_language].GLAccountLongName AS GLAccountLongName,
  FiscalPeriod,
  PostingDate,
  _AccountingDocumentType._Text[1: Language = $session.system_language ].AccountingDocumentTypeName AS AccountingDocumentTypeName,
  I_GLAccountLineItemCube._JournalEntry.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  I_GLAccountLineItemCube._JournalEntry.OriginalReferenceDocument AS OriginalReferenceDocument,
  ReferenceDocument,
  ReferenceDocumentType,
  _ReferenceDocumentType._Text[1: Language = $session.system_language ].ReferenceDocumentTypeName AS ReferenceDocumentTypeName,
  FunctionalArea,
  _GLAccountInCompanyCode._Reconciliationaccttype._Text[1: Language = $session.system_language ].ReconciliationAccountTypeName AS ReconciliationAccountTypeName,
  Customer,
  _Customer.CustomerName AS CustomerName,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  OffsettingAccount,
  _OffsettingAccount._Text[1: Language = $session.system_language].GLAccountName AS OffsettingAccountName,
  DocumentItemText,
  I_GLAccountLineItemCube._JournalEntry.ReverseDocument AS ReverseDocument,
  I_GLAccountLineItemCube._JournalEntry.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  I_TaxItem.TaxCode AS TaxCode,
  I_TaxItem.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  I_TaxItem.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  I_GLAccountLineItemCube.DebitCreditCode AS DebitCreditCode,
  _DebitCreditCode._Text[1: Language = $session.system_language].DebitCreditCodeName AS DebitCreditCodeName,
  DebitAmountInCoCodeCrcy,
  (-1) * CreditAmountInCoCodeCrcy AS CreditAmountInCoCodeCrcy,
  I_GLAccountLineItemCube.CompanyCodeCurrency AS CompanyCodeCurrency,
  SourceReferenceDocument,
  SourceReferenceDocumentType,
  BusinessTransactionType,
  AccountingDocumentType,
  CreationDate,
  AssetValueDate,
  SettlementReferenceDate,
  InvoiceReference,
  DocumentDate,
  IsReversed,
  ReversalReferenceDocument,
  AccountingDocCreatedByUser,
  FinancialAccountType,
  OffsettingAccountType,
  ClearingDate,
  ClearingAccountingDocument,
  PostingKey,
  DebitAmountInTransCrcy,
  CreditAmountInTransCrcy,
  TransactionCurrency,
  FollowOnDocumentType,
  LedgerFiscalYear,
  ChartOfAccounts,
  ControllingArea,
  FinancialTransactionType,
  LogicalSystem,
  ReferenceDocumentContext,
  ReferenceDocumentItem,
  ReferenceDocumentItemGroup,
  IsReversal,
  ReversalReferenceDocumentCntxt,
  IsSettlement,
  IsSettled,
  PredecessorReferenceDocType,
  PredecessorReferenceDocCntxt,
  PredecessorReferenceDocument,
  PredecessorReferenceDocItem,
  SourceReferenceDocumentCntxt,
  SourceReferenceDocumentItem,
  SourceReferenceDocSubitem,
  IsCommitment,
  JrnlEntryItemObsoleteReason,
  CostCenter,
  ProfitCenter,
  BusinessArea,
  Segment,
  PartnerCostCenter,
  PartnerProfitCenter,
  PartnerFunctionalArea,
  PartnerBusinessArea,
  PartnerCompany,
  PartnerSegment,
  BalanceTransactionCurrency,
  AmountInBalanceTransacCrcy,
  AmountInTransactionCurrency,
  AmountInCompanyCodeCurrency,
  GlobalCurrency,
  AmountInGlobalCurrency,
  FreeDefinedCurrency1,
  AmountInFreeDefinedCurrency1,
  FreeDefinedCurrency2,
  AmountInFreeDefinedCurrency2,
  FreeDefinedCurrency3,
  AmountInFreeDefinedCurrency3,
  FreeDefinedCurrency4,
  AmountInFreeDefinedCurrency4,
  FreeDefinedCurrency5,
  AmountInFreeDefinedCurrency5,
  FreeDefinedCurrency6,
  AmountInFreeDefinedCurrency6,
  FreeDefinedCurrency7,
  AmountInFreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AmountInFreeDefinedCurrency8,
  FixedAmountInGlobalCrcy,
  GrpValnFixedAmtInGlobCrcy,
  PrftCtrValnFxdAmtInGlobCrcy,
  TotalPriceVarcInGlobalCrcy,
  GrpValnTotPrcVarcInGlobCrcy,
  PrftCtrValnTotPrcVarcInGlbCrcy,
  FixedPriceVarcInGlobalCrcy,
  GrpValnFixedPrcVarcInGlobCrcy,
  PrftCtrValnFxdPrcVarcInGlbCrcy,
  ControllingObjectCurrency,
  AmountInObjectCurrency,
  BaseUnit,
  Quantity,
  FixedQuantity,
  CostSourceUnit,
  ValuationQuantity,
  ValuationFixedQuantity,
  AdditionalQuantity1Unit,
  AdditionalQuantity1,
  AdditionalQuantity2Unit,
  AdditionalQuantity2,
  AdditionalQuantity3Unit,
  AdditionalQuantity3,
  FiscalYearVariant,
  FiscalYearPeriod,
  I_GLAccountLineItemCube.AccountingDocumentItem AS AccountingDocumentItem,
  AssignmentReference,
  AccountingDocumentCategory,
  I_GLAccountLineItemCube.TransactionTypeDetermination AS TransactionTypeDetermination,
  SubLedgerAcctLineItemType,
  LastChangeDateTime,
  CreationDateTime,
  EliminationProfitCenter,
  OriginObjectType,
  GLAccountType,
  AlternativeGLAccount,
  CountryChartOfAccounts,
  InvoiceReferenceFiscalYear,
  InvoiceItemReference,
  ReferencePurchaseOrderCategory,
  PurchasingDocument,
  PurchasingDocumentItem,
  AccountAssignmentNumber,
  SalesOrder,
  SalesOrderItem,
  SalesDocument,
  SalesDocumentItem,
  Material,
  Product,
  Plant,
  ServicesRenderedDate,
  ConditionContract,
  SpecialGLCode,
  HouseBank,
  HouseBankAccount,
  IsOpenItemManaged,
  ClearingDocFiscalYear,
  AssetDepreciationArea,
  MasterFixedAsset,
  FixedAsset,
  AssetTransactionType,
  AssetAcctTransClassfctn,
  DepreciationFiscalPeriod,
  GroupMasterFixedAsset,
  GroupFixedAsset,
  AssetClass,
  CostEstimate,
  InventorySpecialStockValnType,
  InventorySpecialStockType,
  InventorySpclStkSalesDocument,
  InventorySpclStkSalesDocItm,
  InvtrySpclStockWBSElmntIntID,
  InventorySpclStockWBSElement,
  InventorySpecialStockSupplier,
  InventoryValuationType,
  ValuationArea,
  SenderGLAccount,
  SenderAccountAssignment,
  SenderAccountAssignmentType,
  CostOriginGroup,
  OriginSenderObject,
  ControllingDebitCreditCode,
  ControllingObjectDebitType,
  QuantityIsIncomplete,
  OffsettingChartOfAccounts,
  LineItemIsCompleted,
  PersonnelNumber,
  ControllingObjectClass,
  PartnerCompanyCode,
  PartnerControllingObjectClass,
  OriginCostCenter,
  OriginProfitCenter,
  OriginCostCtrActivityType,
  AccountAssignment,
  AccountAssignmentType,
  CostCtrActivityType,
  OrderID,
  OrderCategory,
  WBSElementInternalID,
  PartnerWBSElementInternalID,
  WBSElement,
  ProjectInternalID,
  PartnerProjectInternalID,
  Project,
  OperatingConcern,
  ProjectNetwork,
  RelatedNetworkActivity,
  BusinessProcess,
  CostObject,
  BillableControl,
  CostAnalysisResource,
  CustomerServiceNotification,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  PartnerServiceDocumentType,
  PartnerServiceDocument,
  PartnerServiceDocumentItem,
  ServiceContractType,
  ServiceContract,
  ServiceContractItem,
  PartnerAccountAssignment,
  PartnerAccountAssignmentType,
  PartnerCostCtrActivityType,
  PartnerOrder,
  PartnerOrderCategory,
  PartnerWBSElement,
  PartnerProject,
  PartnerSalesDocument,
  PartnerSalesDocumentItem,
  PartnerProjectNetwork,
  PartnerProjectNetworkActivity,
  PartnerBusinessProcess,
  PartnerCostObject,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SoldMaterial,
  SoldProduct,
  MaterialGroup,
  SoldProductGroup,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  SalesDistrict,
  BillToParty,
  ShipToParty,
  CustomerSupplierCorporateGroup,
  FinancialManagementArea,
  Fund,
  GrantID,
  BudgetPeriod,
  PartnerFund,
  PartnerGrant,
  PartnerBudgetPeriod,
  FundsCenter,
  FundedProgram,
  JointVenture,
  JointVentureEquityGroup,
  JointVentureCostRecoveryCode,
  JointVenturePartner,
  JointVentureBillingType,
  JointVentureEquityType,
  JointVentureProductionDate,
  JointVentureBillingDate,
  JointVentureOperationalDate,
  CutbackRun,
  JointVentureAccountingActivity,
  PartnerVenture,
  PartnerEquityGroup,
  SenderCostRecoveryCode,
  CutbackAccount,
  CutbackCostObject,
  AccrualObjectType,
  AccrualObject,
  AccrualSubobject,
  AccrualItemType,
  WorkCenterInternalID,
  OrderOperation,
  OrderItem,
  OrderSuboperation,
  Equipment,
  FunctionalLocation,
  Assembly,
  MaintenanceActivityType,
  MaintenanceOrderPlanningCode,
  MaintPriorityType,
  MaintPriority,
  SuperiorOrder,
  ProductGroup,
  MaintenanceOrderIsPlanned,
  DebitAmountInBalanceTransCrcy,
  CreditAmountInBalanceTransCrcy,
  DebitAmountInGlobalCrcy,
  CreditAmountInGlobalCrcy,
  DebitAmountInFreeDefinedCrcy1,
  CreditAmountInFreeDefinedCrcy1,
  DebitAmountInFreeDefinedCrcy2,
  CreditAmountInFreeDefinedCrcy2,
  DebitAmountInFreeDefinedCrcy3,
  CreditAmountInFreeDefinedCrcy3,
  DebitAmountInFreeDefinedCrcy4,
  CreditAmountInFreeDefinedCrcy4,
  DebitAmountInFreeDefinedCrcy5,
  CreditAmountInFreeDefinedCrcy5,
  DebitAmountInFreeDefinedCrcy6,
  CreditAmountInFreeDefinedCrcy6,
  DebitAmountInFreeDefinedCrcy7,
  CreditAmountInFreeDefinedCrcy7,
  DebitAmountInFreeDefinedCrcy8,
  CreditAmountInFreeDefinedCrcy8,
  IsStatisticalOrder,
  IsStatisticalCostCenter,
  IsStatisticalSalesDocument,
  WBSIsStatisticalWBSElement,
  CalendarYear,
  CalendarQuarter,
  CalendarYearQuarter,
  CalendarMonth,
  CalendarYearMonth,
  CalendarWeek,
  CalendarYearWeek,
  I_GLAccountLineItemCube._JournalEntry AS _JournalEntry,
  I_GLAccountLineItemCube._CompanyCodeCurrency AS _CompanyCodeCurrency
FROM I_GLAccountLineItemCube
LEFT OUTER JOIN I_TaxItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_GLAccountText AS _GLAcctInChartOfAccountsText ON ChartOfAccounts = _GLAcctInChartOfAccountsText.ChartOfAccounts AND GLAccount = _GLAcctInChartOfAccountsText.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _FromFiscalPeriodForVariant ON _FromFiscalPeriodForVariant.FiscalYearVariant = FiscalYearVariant AND _FromFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear AND _FromFiscalPeriodForVariant.FiscalPeriod = $parameters.P_FromFiscalPeriod  -- association [0..1]
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _ToFiscalPeriodForVariant ON _ToFiscalPeriodForVariant.FiscalYearVariant = FiscalYearVariant AND _ToFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear AND _ToFiscalPeriodForVariant.FiscalPeriod = $parameters.P_ToFiscalPeriod  -- association [0..1]
;