FAC_DART_Z3_GL_LEDGER_ITEM

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_GL_LEDGER_ITEM.
-- 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_DZGLLDGRITEM
-- Parameters: P_FiscalYear : fins_gjahr, P_FromFiscalPeriod : fins_fagl_fiscper_from, P_ToFiscalPeriod : fins_fagl_fiscper_to, P_Language : sylangu

CREATE VIEW FAC_DART_Z3_GL_LEDGER_ITEM AS
SELECT
  I_GLAccountLineItemCube.Ledger AS 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,
  FiscalPeriod,
  PostingDate,
  I_GLAccountLineItemCube._JournalEntry.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  I_GLAccountLineItemCube._JournalEntry.OriginalReferenceDocument AS OriginalReferenceDocument,
  ReferenceDocument,
  ReferenceDocumentType,
  FunctionalArea,
  Customer,
  Supplier,
  OffsettingAccount,
  OffsettingAccountName,
  DocumentItemText,
  I_GLAccountLineItemCube._JournalEntry.ReverseDocument AS ReverseDocument,
  I_GLAccountLineItemCube._JournalEntry.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  I_GLAccountLineItemCube.TaxCode AS TaxCode,
  I_GLAccountLineItemCube.TaxCountry AS TaxCountry,
  P_Bset.TaxDeterminationDate AS TaxDeterminationDate,
  P_Bset.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  P_Bset.TaxItemGroup AS TaxItemGroup,
  I_GLAccountLineItemCube.DebitCreditCode AS DebitCreditCode,
  DebitAmountInCoCodeCrcy,
  I_GLAccountLineItemCube.CompanyCodeCurrency AS DebitCompanyCodeCurrency,
  cast( (-1) * CreditAmountInCoCodeCrcy as fis_cr_hsl) AS CreditAmountInCoCodeCrcy,
  I_GLAccountLineItemCube.CompanyCodeCurrency AS CreditCompanyCodeCurrency,
  I_GLAccountLineItemCube.CompanyCodeCurrency AS CompanyCodeCurrency,
  _OperationalAcctgDocItem.AddressAndBankIsSetManually AS AddressAndBankIsSetManually,
  AmountInTransactionCurrency AS DebitAmountInTransCrcy,
  I_GLAccountLineItemCube._JournalEntry.TransactionCurrency AS DebitTransactionCurrency,
  cast( (-1) * CreditAmountInTransCrcy as fis_cr_wsl) AS CreditAmountInTransCrcy,
  I_GLAccountLineItemCube._JournalEntry.TransactionCurrency AS CreditTransactionCurrency,
  I_GLAccountLineItemCube._JournalEntry.TransactionCurrency AS BalTransactionCurrency,
  I_GLAccountLineItemCube._JournalEntry.IntercompanyTransaction AS IntercompanyTransaction,
  I_GLAccountLineItemCube._JournalEntry.ExchangeRateDate AS ExchangeRateDate,
  I_GLAccountLineItemCube._JournalEntry.TransactionCurrency AS TransactionCurrency,
  I_GLAccountLineItemCube._JournalEntry.ExchangeRate AS ExchangeRate,
  I_GLAccountLineItemCube._JournalEntry.BusinessTransactionType AS BusinessTransactionType,
  _JournalEntry._BusinessTransactionType._Text[1: Language = $parameters.P_Language].BusinessTransactionTypeName AS BusinessTransactionTypeName,
  I_GLAccountLineItemCube._JournalEntry.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  I_GLAccountLineItemCube._JournalEntry.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  I_GLAccountLineItemCube._JournalEntry.LedgerGroup AS LedgerGroup,
  I_GLAccountLineItemCube._JournalEntry.TaxReportingDate AS TaxReportingDate,
  I_GLAccountLineItemCube._JournalEntry.TaxIsCalculatedAutomatically AS TaxIsCalculatedAutomatically,
  I_GLAccountLineItemCube._JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  SourceReferenceDocument,
  SourceReferenceDocumentType,
  _OperationalAcctgDocItem.CorporateGroupAccount AS CorporateGroupAccount,
  _OperationalAcctgDocItem.Reference1IDByBusinessPartner AS Reference1IDByBusinessPartner,
  _OperationalAcctgDocItem.AdditionalCurrency1 AS AdditionalCurrency1,
  _OperationalAcctgDocItem.AdditionalCurrency2 AS AdditionalCurrency2,
  _OperationalAcctgDocItem.PaymentMethod AS PaymentMethod,
  _OperationalAcctgDocItem.PaymentMethodSupplement AS PaymentMethodSupplement,
  AccountingDocumentType,
  _AccountingDocumentTypeText[1: Language = $parameters.P_Language].AccountingDocumentTypeName AS AccountingDocumentTypeName,
  CreationDate,
  AssetValueDate,
  SettlementReferenceDate,
  InvoiceReference,
  DocumentDate,
  IsReversed,
  ReversalReferenceDocument,
  FinancialAccountType,
  OffsettingAccountType,
  ClearingDate,
  ClearingAccountingDocument,
  PostingKey,
  FollowOnDocumentType,
  _FunctionAreaText[1: Language = $parameters.P_Language].FunctionalAreaName AS FunctionalAreaName,
  I_GLAccountLineItemCube._JournalEntry.TransactionCode AS TransactionCode,
  I_GLAccountLineItemCube._JournalEntry.RecurringAccountingDocument AS RecurringAccountingDocument,
  _OperationalAcctgDocItem.CostElement AS CostElement,
  ControllingBusTransacType,
  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,
  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,
  I_GLAccountLineItemCube.FiscalYearVariant AS 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,
  (-1) * CreditAmountInBalanceTransCrcy AS CreditAmountInBalanceTransCrcy,
  DebitAmountInGlobalCrcy,
  (-1) * CreditAmountInGlobalCrcy AS CreditAmountInGlobalCrcy,
  DebitAmountInFreeDefinedCrcy1,
  (-1) * CreditAmountInFreeDefinedCrcy1 AS CreditAmountInFreeDefinedCrcy1,
  DebitAmountInFreeDefinedCrcy2,
  (-1) * CreditAmountInFreeDefinedCrcy2 AS CreditAmountInFreeDefinedCrcy2,
  DebitAmountInFreeDefinedCrcy3,
  (-1) * CreditAmountInFreeDefinedCrcy3 AS CreditAmountInFreeDefinedCrcy3,
  DebitAmountInFreeDefinedCrcy4,
  (-1) * CreditAmountInFreeDefinedCrcy4 AS CreditAmountInFreeDefinedCrcy4,
  DebitAmountInFreeDefinedCrcy5,
  (-1) * CreditAmountInFreeDefinedCrcy5 AS CreditAmountInFreeDefinedCrcy5,
  DebitAmountInFreeDefinedCrcy6,
  (-1) * CreditAmountInFreeDefinedCrcy6 AS CreditAmountInFreeDefinedCrcy6,
  DebitAmountInFreeDefinedCrcy7,
  (-1) * CreditAmountInFreeDefinedCrcy7 AS CreditAmountInFreeDefinedCrcy7,
  DebitAmountInFreeDefinedCrcy8,
  (-1) * CreditAmountInFreeDefinedCrcy8 AS CreditAmountInFreeDefinedCrcy8,
  IsStatisticalOrder,
  IsStatisticalCostCenter,
  IsStatisticalSalesDocument,
  WBSIsStatisticalWBSElement,
  CalendarYear,
  CalendarQuarter,
  CalendarYearQuarter,
  CalendarMonth,
  CalendarYearMonth,
  CalendarWeek,
  CalendarYearWeek,
  I_GLAccountLineItemCube._JournalEntry AS _JournalEntry,
  I_GLAccountLineItemCube._JournalEntry._TransactionCurrency AS _TransactionCurrency,
  I_GLAccountLineItemCube._CompanyCodeCurrency AS _CompanyCodeCurrency,
  I_GLAccountLineItemCube._JournalEntry._BusinessTransactionType AS _BusinessTransactionType,
  I_GLAccountLineItemCube._JournalEntry._User AS _User
FROM I_GLAccountLineItemCube
LEFT OUTER JOIN P_Bset ON /* join condition not captured in parsed metadata */
INNER JOIN I_LedgerCompanyCodeCrcyRoles 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 = I_LedgerCompanyCodeCrcyRoles.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 = I_LedgerCompanyCodeCrcyRoles.FiscalYearVariant AND _ToFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear AND _ToFiscalPeriodForVariant.FiscalPeriod = $parameters.P_ToFiscalPeriod  -- association [0..1]
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _OperationalAcctgDocItem ON CompanyCode = _OperationalAcctgDocItem.CompanyCode AND AccountingDocument = _OperationalAcctgDocItem.AccountingDocument AND FiscalYear = _OperationalAcctgDocItem.FiscalYear AND AccountingDocumentItem = _OperationalAcctgDocItem.AccountingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearVariant AS _FiscalYearVariant ON FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant  -- association [1..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger association[0..*] to I_FunctionalAreaText as _FunctionAreaText on _FunctionAreaText.FunctionalArea = FunctionalArea association[0..*] to I_AccountingDocumentTypeText as _AccountingDocumentTypeText on _AccountingDocumentTypeText.AccountingDocumentType = AccountingDocumentType  -- association [1..1]
;