I_PubSecCmtmtActlItemCube

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 I_PubSecCmtmtActlItemCube.
-- 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 I_PubSecCmtmtActlItemCube AS
SELECT
  AcItem.Ledger AS Ledger,
  AcItem.SourceLedger AS SourceLedger,
  AcItem.CompanyCode AS CompanyCode,
  AcItem.FiscalYear AS FiscalYear,
  AcItem.AccountingDocument AS AccountingDocument,
  AcItem.LedgerGLLineItem AS LedgerGLLineItem,
  AcItem.LedgerFiscalYear AS LedgerFiscalYear,
  AcItem.ChartOfAccounts AS ChartOfAccounts,
  AcItem.ControllingArea AS ControllingArea,
  AcItem.FinancialTransactionType AS FinancialTransactionType,
  AcItem.BusinessTransactionType AS BusinessTransactionType,
  AcItem.ReferenceDocumentType AS ReferenceDocumentType,
  AcItem.LogicalSystem AS LogicalSystem,
  AcItem.ReferenceDocumentContext AS ReferenceDocumentContext,
  AcItem.ReferenceDocument AS ReferenceDocument,
  AcItem.ReferenceDocumentItem AS ReferenceDocumentItem,
  AcItem.ReferenceDocumentItemGroup AS ReferenceDocumentItemGroup,
  AcItem.IsReversal AS IsReversal,
  AcItem.IsReversed AS IsReversed,
  AcItem.ReversalReferenceDocumentCntxt AS ReversalReferenceDocumentCntxt,
  AcItem.ReversalReferenceDocument AS ReversalReferenceDocument,
  AcItem.IsSettlement AS IsSettlement,
  AcItem.IsSettled AS IsSettled,
  AcItem.PredecessorReferenceDocType AS PredecessorReferenceDocType,
  AcItem.PredecessorReferenceDocCntxt AS PredecessorReferenceDocCntxt,
  AcItem.PredecessorReferenceDocument AS PredecessorReferenceDocument,
  AcItem.PredecessorReferenceDocItem AS PredecessorReferenceDocItem,
  AcItem.SourceReferenceDocumentType AS SourceReferenceDocumentType,
  AcItem.SourceLogicalSystem AS SourceLogicalSystem,
  AcItem.SourceReferenceDocumentCntxt AS SourceReferenceDocumentCntxt,
  AcItem.SourceReferenceDocument AS SourceReferenceDocument,
  AcItem.SourceReferenceDocumentItem AS SourceReferenceDocumentItem,
  AcItem.SourceReferenceDocSubitem AS SourceReferenceDocSubitem,
  AcItem.IsCommitment AS IsCommitment,
  AcItem.JrnlEntryItemObsoleteReason AS JrnlEntryItemObsoleteReason,
  AcItem.GLAccount AS GLAccount,
  cast( AcItem.CostCenter as fis_cctr_hryid_42) AS CostCenterHierarchy,
  AcItem.CostCenter AS CostCenter,
  AcItem.ProfitCenter AS ProfitCenter,
  AcItem.FunctionalArea AS FunctionalArea,
  AcItem.BusinessArea AS BusinessArea,
  AcItem.Segment AS Segment,
  AcItem.PartnerCostCenter AS PartnerCostCenter,
  AcItem.PartnerProfitCenter AS PartnerProfitCenter,
  AcItem.PartnerFunctionalArea AS PartnerFunctionalArea,
  AcItem.PartnerBusinessArea AS PartnerBusinessArea,
  AcItem.PartnerCompany AS PartnerCompany,
  AcItem.PartnerSegment AS PartnerSegment,
  AcItem.TransactionCurrency AS TransactionCurrency,
  AcItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  AcItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  AcItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  AcItem.GlobalCurrency AS GlobalCurrency,
  AcItem.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  AcItem.BaseUnit AS BaseUnit,
  AcItem.Quantity AS Quantity,
  AcItem.CostSourceUnit AS CostSourceUnit,
  cast( AcItem.Fund as fmis_hryid_fund ) AS FundHierarchy,
  cast (AcItem.GrantID as gm_hryid_grant) AS GrantHierarchy,
  cast( AcItem.FunctionalArea as fis_hryid_functionalarea_42) AS FunctionalAreaHierarchy,
  cast (PubSecBudgetAccount as psm_hryid_budgetaccount ) AS BudgetAccountHierarchy,
  AcItem.DebitCreditCode AS DebitCreditCode,
  AcItem.FiscalPeriod AS FiscalPeriod,
  AcItem.FiscalYearVariant AS FiscalYearVariant,
  AcItem.FiscalYearPeriod AS FiscalYearPeriod,
  AcItem.PostingDate AS PostingDate,
  AcItem.DocumentDate AS DocumentDate,
  AcItem.AccountingDocumentType AS AccountingDocumentType,
  AcItem.AccountingDocumentItem AS AccountingDocumentItem,
  AcItem.AssignmentReference AS AssignmentReference,
  AcItem.AccountingDocumentCategory AS AccountingDocumentCategory,
  AcItem.PostingKey AS PostingKey,
  AcItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  AcItem.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  AcItem.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  AcItem.LastChangeDateTime AS LastChangeDateTime,
  AcItem.CreationDateTime AS CreationDateTime,
  AcItem.CreationDate AS CreationDate,
  AcItem.EliminationProfitCenter AS EliminationProfitCenter,
  AcItem.OriginObjectType AS OriginObjectType,
  AcItem.GLAccountType AS GLAccountType,
  AcItem.AlternativeGLAccount AS AlternativeGLAccount,
  AcItem.CountryChartOfAccounts AS CountryChartOfAccounts,
  AcItem.InvoiceReference AS InvoiceReference,
  AcItem.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  AcItem.FollowOnDocumentType AS FollowOnDocumentType,
  AcItem.InvoiceItemReference AS InvoiceItemReference,
  AcItem.ReferencePurchaseOrderCategory AS ReferencePurchaseOrderCategory,
  AcItem.PurchasingDocument AS PurchasingDocument,
  AcItem.PurchasingDocumentItem AS PurchasingDocumentItem,
  AcItem.AccountAssignmentNumber AS AccountAssignmentNumber,
  AcItem.DocumentItemText AS DocumentItemText,
  AcItem.SalesDocument AS SalesDocument,
  AcItem.SalesDocumentItem AS SalesDocumentItem,
  AcItem.Product AS Product,
  AcItem.Plant AS Plant,
  AcItem.Supplier AS Supplier,
  AcItem.Customer AS Customer,
  AcItem.ServicesRenderedDate AS ServicesRenderedDate,
  AcItem.ConditionContract AS ConditionContract,
  AcItem.FinancialAccountType AS FinancialAccountType,
  AcItem.SpecialGLCode AS SpecialGLCode,
  AcItem.TaxCode AS TaxCode,
  AcItem.IsOpenItemManaged AS IsOpenItemManaged,
  AcItem.ClearingDate AS ClearingDate,
  AcItem.ClearingAccountingDocument AS ClearingAccountingDocument,
  AcItem.ClearingDocFiscalYear AS ClearingDocFiscalYear,
  AcItem._GLAccountInChartOfAccounts.IsBalanceSheetAccount AS IsBalanceSheetAccount,
  AcItem.AssetDepreciationArea AS AssetDepreciationArea,
  AcItem.MasterFixedAsset AS MasterFixedAsset,
  AcItem.FixedAsset AS FixedAsset,
  AcItem.AssetValueDate AS AssetValueDate,
  AcItem.AssetTransactionType AS AssetTransactionType,
  AcItem.DepreciationFiscalPeriod AS DepreciationFiscalPeriod,
  AcItem.GroupMasterFixedAsset AS GroupMasterFixedAsset,
  AcItem.GroupFixedAsset AS GroupFixedAsset,
  AcItem.AssetClass AS AssetClass,
  AcItem.CostEstimate AS CostEstimate,
  AcItem.InventorySpecialStockValnType AS InventorySpecialStockValnType,
  AcItem.InvtrySpecialStockValnType_2 AS InvtrySpecialStockValnType_2,
  AcItem.InventorySpecialStockType AS InventorySpecialStockType,
  AcItem.InventorySpclStkSalesDocument AS InventorySpclStkSalesDocument,
  AcItem.InventorySpclStkSalesDocItm AS InventorySpclStkSalesDocItm,
  AcItem.InventorySpecialStockSupplier AS InventorySpecialStockSupplier,
  AcItem.InventoryValuationType AS InventoryValuationType,
  AcItem.ValuationArea AS ValuationArea,
  AcItem.SenderGLAccount AS SenderGLAccount,
  AcItem.SenderAccountAssignment AS SenderAccountAssignment,
  AcItem.SenderAccountAssignmentType AS SenderAccountAssignmentType,
  AcItem.CostOriginGroup AS CostOriginGroup,
  AcItem.OriginSenderObject AS OriginSenderObject,
  AcItem.ControllingDebitCreditCode AS ControllingDebitCreditCode,
  AcItem.ControllingObjectDebitType AS ControllingObjectDebitType,
  AcItem.QuantityIsIncomplete AS QuantityIsIncomplete,
  AcItem.OffsettingAccount AS OffsettingAccount,
  AcItem.OffsettingAccountType AS OffsettingAccountType,
  AcItem.OffsettingChartOfAccounts AS OffsettingChartOfAccounts,
  AcItem.LineItemIsCompleted AS LineItemIsCompleted,
  AcItem.PersonnelNumber AS PersonnelNumber,
  AcItem.ControllingObjectClass AS ControllingObjectClass,
  AcItem.PartnerCompanyCode AS PartnerCompanyCode,
  AcItem.PartnerControllingObjectClass AS PartnerControllingObjectClass,
  AcItem.OriginCostCenter AS OriginCostCenter,
  AcItem.OriginProfitCenter AS OriginProfitCenter,
  AcItem.OriginCostCtrActivityType AS OriginCostCtrActivityType,
  AcItem.AccountAssignment AS AccountAssignment,
  AcItem.AccountAssignmentType AS AccountAssignmentType,
  AcItem.CostCtrActivityType AS CostCtrActivityType,
  AcItem.OrderID AS OrderID,
  AcItem.OrderCategory AS OrderCategory,
  AcItem.WBSElementInternalID AS WBSElementInternalID,
  cast( AcItem._WBSElementBasicData.WBSElementExternalID as fis_wbsext_no_conv preserving type ) AS WBSElementExternalID,
  AcItem.PartnerWBSElementInternalID AS PartnerWBSElementInternalID,
  cast( AcItem._PartnerWBSElementBasicData.WBSElementExternalID as fis_partner_wbsext_no_conv preserving type ) AS PartnerWBSElementExternalID,
  AcItem.ProjectInternalID AS ProjectInternalID,
  cast( _ProjectBasicData.ProjectExternalID as fis_projectext_no_conv preserving type ) AS ProjectExternalID,
  AcItem.PartnerProjectInternalID AS PartnerProjectInternalID,
  cast( _PartnerProjectBasicData.ProjectExternalID as fis_part_projectext_no_conv preserving type ) AS PartnerProjectExternalID,
  AcItem.OperatingConcern AS OperatingConcern,
  AcItem.BusinessProcess AS BusinessProcess,
  AcItem.CostObject AS CostObject,
  AcItem.CostAnalysisResource AS CostAnalysisResource,
  AcItem.WorkPackage AS WorkPackage,
  AcItem.WorkItem AS WorkItem,
  AcItem.CustomerServiceNotification AS CustomerServiceNotification,
  AcItem.ServiceDocumentType AS ServiceDocumentType,
  AcItem.ServiceDocument AS ServiceDocument,
  AcItem.ServiceDocumentItem AS ServiceDocumentItem,
  AcItem.PartnerServiceDocumentType AS PartnerServiceDocumentType,
  AcItem.PartnerServiceDocument AS PartnerServiceDocument,
  AcItem.PartnerServiceDocumentItem AS PartnerServiceDocumentItem,
  AcItem.ServiceContractType AS ServiceContractType,
  AcItem.ServiceContract AS ServiceContract,
  AcItem.ServiceContractItem AS ServiceContractItem,
  AcItem.PartnerAccountAssignment AS PartnerAccountAssignment,
  AcItem.PartnerAccountAssignmentType AS PartnerAccountAssignmentType,
  AcItem.PartnerCostCtrActivityType AS PartnerCostCtrActivityType,
  PartnerOrder,
  PartnerOrder_2,
  AcItem.PartnerOrderCategory AS PartnerOrderCategory,
  AcItem.PartnerSalesDocument AS PartnerSalesDocument,
  AcItem.PartnerSalesDocumentItem AS PartnerSalesDocumentItem,
  AcItem.PartnerBusinessProcess AS PartnerBusinessProcess,
  AcItem.PartnerCostObject AS PartnerCostObject,
  AcItem.BillingDocumentType AS BillingDocumentType,
  AcItem.SalesOrganization AS SalesOrganization,
  AcItem.DistributionChannel AS DistributionChannel,
  AcItem.OrganizationDivision AS OrganizationDivision,
  AcItem.SoldProduct AS SoldProduct,
  AcItem.CustomerGroup AS CustomerGroup,
  AcItem.CustomerSupplierCountry AS CustomerSupplierCountry,
  AcItem.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  AcItem.SalesDistrict AS SalesDistrict,
  AcItem.BillToParty AS BillToParty,
  AcItem.ShipToParty AS ShipToParty,
  AcItem.CustomerSupplierCorporateGroup AS CustomerSupplierCorporateGroup,
  AcItem.FinancialManagementArea AS FinancialManagementArea,
  AcItem.Fund AS Fund,
  _Fund._Text[1:Language = $session.system_language].FundName AS FundName,
  AcItem.GrantID AS GrantID,
  AcItem._Grant.GranteeMgmtSponsor AS GranteeMgmtSponsor,
  AcItem.BudgetPeriod AS BudgetPeriod,
  AcItem.PartnerFund AS PartnerFund,
  AcItem.PartnerGrant AS PartnerGrant,
  AcItem.PartnerBudgetPeriod AS PartnerBudgetPeriod,
  AcItem.FundsCenter AS FundsCenter,
  AcItem.FundedProgram AS FundedProgram,
  AcItem.CashLedgerAccount AS CashLedgerAccount,
  AcItem.CashLedgerCompanyCode AS CashLedgerCompanyCode,
  AcItem.PubSecBudgetAccount AS PubSecBudgetAccount,
  AcItem.PubSecBudgetAccountCoCode AS PubSecBudgetAccountCoCode,
  AcItem.PubSecBudgetCnsmpnDate AS PubSecBudgetCnsmpnDate,
  AcItem.PubSecBudgetCnsmpnFsclPeriod AS PubSecBudgetCnsmpnFsclPeriod,
  AcItem.PubSecBudgetCnsmpnFsclYear AS PubSecBudgetCnsmpnFsclYear,
  AcItem.PubSecBudgetCnsmpnType AS PubSecBudgetCnsmpnType,
  AcItem.PubSecBudgetCnsmpnAmtType AS PubSecBudgetCnsmpnAmtType,
  AcItem._PubSecBudgetCnsmpnType.PubSecBudgetCnsmpnTypeGroup AS PubSecBudgetCnsmpnTypeGroup,
  AcItem.PubSecBudgetIsRelevant AS PubSecBudgetIsRelevant,
  AcItem._PubSecBudgetAccount.PubSecBdgtAcctRevnExpnCode AS PubSecBdgtAcctRevnExpnCode,
  AcItem._Fund.FundType AS FundType,
  AcItem._Fund._FundType.GranteeMgmtFundType AS GranteeMgmtFundType,
  AcItem.SponsoredClass AS SponsoredClass,
  AcItem.SponsoredProgram AS SponsoredProgram,
  AcItem.GteeMBudgetValidityNumber AS GteeMBudgetValidityNumber,
  AcItem.DebitAmountInCoCodeCrcy AS DebitAmountInCoCodeCrcy,
  AcItem.CreditAmountInCoCodeCrcy AS CreditAmountInCoCodeCrcy,
  AcItem.DebitAmountInTransCrcy AS DebitAmountInTransCrcy,
  AcItem.CreditAmountInTransCrcy AS CreditAmountInTransCrcy,
  AcItem.IsStatisticalOrder AS IsStatisticalOrder,
  AcItem.IsStatisticalCostCenter AS IsStatisticalCostCenter,
  AcItem.IsStatisticalSalesDocument AS IsStatisticalSalesDocument,
  AcItem.WBSIsStatisticalWBSElement AS WBSIsStatisticalWBSElement,
  AcItem.CalendarYear AS CalendarYear,
  AcItem.CalendarQuarter AS CalendarQuarter,
  AcItem.CalendarYearQuarter AS CalendarYearQuarter,
  AcItem.CalendarMonth AS CalendarMonth,
  AcItem.CalendarYearMonth AS CalendarYearMonth,
  AcItem.CalendarWeek AS CalendarWeek,
  AcItem.CalendarYearWeek AS CalendarYearWeek,
  AcItem.GLAccountAuthorizationGroup AS GLAccountAuthorizationGroup,
  AcItem.SupplierBasicAuthorizationGrp AS SupplierBasicAuthorizationGrp,
  AcItem.CustomerBasicAuthorizationGrp AS CustomerBasicAuthorizationGrp,
  AcItem.AcctgDocTypeAuthorizationGroup AS AcctgDocTypeAuthorizationGroup,
  AcItem.OrderType AS OrderType,
  AcItem.SalesOrderType AS SalesOrderType,
  AcItem._CashLedgerAccount AS _CashLedgerAccount,
  AcItem._CashLedgerCompanyCode AS _CashLedgerCompanyCode,
  AcItem._PubSecBudgetAccount AS _PubSecBudgetAccount,
  AcItem._PubSecBudgetAccountCoCode AS _PubSecBudgetAccountCoCode,
  AcItem._PubSecBudgetCnsmpnFsclYear AS _PubSecBdgtCnsmpnFsclYear,
  AcItem._PubSecBudgetCnsmpnFsclPeriod AS _PubSecBdgtCnsmpnFsclPeriod,
  AcItem._PubSecBudgetCnsmpnType AS _PubSecBdgtCnsmpnType,
  AcItem._PubSecBudgetCnsmpnType._PubSecBudgetCnsmpnTypeGroup AS _PubSecBudgetCnsmpnTypeGroup,
  AcItem._PubSecBudgetCnsmpnAmtType AS _PubSecBdgtCnsmpnAmtType,
  AcItem._PubSecBudgetCnsmpnDate AS _PubSecBudgetCnsmpnDate,
  AcItem._AccountingDocumentCategory AS _AccountingDocumentCategory,
  AcItem._AccountingDocumentType AS _AccountingDocumentType,
  AcItem._AccountingDocumentTypeText AS _AccountingDocumentTypeText,
  AcItem._AlternativeGLAccount AS _AlternativeGLAccount,
  AcItem._AlternativeGLAccountText AS _AlternativeGLAccountText,
  AcItem._AssetTransactionType AS _AssetTransactionType,
  AcItem._BaseUnit AS _BaseUnit,
  AcItem._BillingDocumentType AS _BillingDocumentType,
  AcItem._BillToParty AS _BillToParty,
  AcItem._BudgetPeriod AS _BudgetPeriod,
  AcItem._BudgetPeriodText AS _BudgetPeriodText,
  AcItem._BusinessArea AS _BusinessArea,
  AcItem._BusinessAreaText AS _BusinessAreaText,
  AcItem._BusinessProcess AS _BusinessProcess,
  AcItem._BusinessProcessText AS _BusinessProcessText,
  AcItem._BusinessTransactionType AS _BusinessTransactionType,
  AcItem._BusinessTransactionTypeText AS _BusinessTransactionTypeText,
  AcItem._CalendarDate AS _CalendarDate,
  AcItem._ChartOfAccounts AS _ChartOfAccounts,
  AcItem._ChartOfAccountsText AS _ChartOfAccountsText,
  AcItem._ClearingAccountingDocument AS _ClearingAccountingDocument,
  AcItem._CompanyCode AS _CompanyCode,
  AcItem._CompanyCodeCurrency AS _CompanyCodeCurrency,
  AcItem._CompanyCodeText AS _CompanyCodeText,
  AcItem._ConditionContract AS _ConditionContract,
  AcItem._ControllingArea AS _ControllingArea,
  AcItem._ControllingAreaText AS _ControllingAreaText,
  AcItem._ControllingDebitCreditCode AS _ControllingDebitCreditCode,
  AcItem._ControllingObjectClass AS _ControllingObjectClass,
  AcItem._CostAnalysisResource AS _CostAnalysisResource,
  AcItem._CostAnalysisResourceText AS _CostAnalysisResourceText,
  AcItem._CostCenter AS _CostCenter,
  AcItem._CostCenterText AS _CostCenterText,
  AcItem._CostCtrActivityType AS _CostCtrActivityType,
  AcItem._CostOriginGroup AS _CostOriginGroup,
  AcItem._CostSourceUnit AS _CostSourceUnit,
  AcItem._CountryChartOfAccounts AS _CountryChartOfAccounts,
  AcItem._CountryChartOfAccountsText AS _CountryChartOfAccountsText,
  AcItem._CurrentCostCenter AS _CurrentCostCenter,
  AcItem._CurrentProfitCenter AS _CurrentProfitCenter,
  AcItem._Customer AS _Customer,
  AcItem._CustomerGroup AS _CustomerGroup,
  AcItem._CustomerSupplierCountry AS _CustomerSupplierCountry,
  AcItem._CustomerText AS _CustomerText,
  AcItem._DebitCreditCode AS _DebitCreditCode,
  AcItem._DebitCreditCodeText AS _DebitCreditCodeText,
  AcItem._DistributionChannel AS _DistributionChannel,
  AcItem._EliminationProfitCenter AS _EliminationProfitCenter,
  AcItem._Employment AS _Employment,
  AcItem._FinancialAccountType AS _FinancialAccountType,
  AcItem._FinancialAccountTypeText AS _FinancialAccountTypeText,
  AcItem._FinancialManagementArea AS _FinancialManagementArea,
  AcItem._FinancialManagementAreaText AS _FinancialManagementAreaText,
  AcItem._FinancialTransactionType AS _FinancialTransactionType,
  AcItem._FiscalCalendarDate AS _FiscalCalendarDate,
  AcItem._FiscalPeriodForVariant AS _FiscalPeriodForVariant,
  AcItem._FiscalYear AS _FiscalYear,
  AcItem._FiscalYearPeriodForVariant AS _FiscalYearPeriodForVariant,
  AcItem._FiscalYearVariant AS _FiscalYearVariant,
  AcItem._FixedAsset AS _FixedAsset,
  AcItem._FixedAssetText AS _FixedAssetText,
  AcItem._FunctionalArea AS _FunctionalArea,
  AcItem._FunctionalAreaText AS _FunctionalAreaText,
  AcItem._FundsCenter AS _FundsCenter,
  AcItem._FundText AS _FundText,
  AcItem._Grant._Sponsor AS _Sponsor,
  AcItem._SponsoredClass AS _SponsoredClass,
  AcItem._SponsoredProgram AS _SponsoredProgram,
  AcItem._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  AcItem._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  AcItem._GLAccountTxt AS _GLAccountTxt,
  AcItem._GLAccountType AS _GLAccountType,
  AcItem._GLAcctInChartOfAccountsText AS _GLAcctInChartOfAccountsText,
  AcItem._GlobalCurrency AS _GlobalCurrency,
  AcItem._GroupFixedAsset AS _GroupFixedAsset,
  AcItem._GroupFixedAssetText AS _GroupFixedAssetText,
  AcItem._GroupMasterFixedAsset AS _GroupMasterFixedAsset,
  AcItem._GroupMasterFixedAssetText AS _GroupMasterFixedAssetText,
  AcItem._InternalOrder AS _InternalOrder,
  AcItem._InventorySpclStkSalesDocItm AS _InventorySpclStkSalesDocItm,
  AcItem._InventorySpclStkSalesDocument AS _InventorySpclStkSalesDocument,
  AcItem._InventorySpecialStockSupplier AS _InventorySpecialStockSupplier,
  AcItem._InventorySpecialStockType AS _InventorySpecialStockType,
  AcItem._InventorySpecialStockValnType AS _InventorySpecialStockValnType,
  AcItem._InventorySpclStockValnType AS _InventorySpclStockValnType,
  AcItem._InventoryValuationType AS _InventoryValuationType,
  AcItem._InvtrySpclStockSupplierText AS _InvtrySpclStockSupplierText,
  AcItem._JournalEntry AS _JournalEntry,
  AcItem._Ledger AS _Ledger,
  AcItem._LedgerFiscalYearForVariant AS _LedgerFiscalYearForVariant,
  AcItem._LedgerText AS _LedgerText,
  AcItem._MaintenanceOrder AS _MaintenanceOrder,
  AcItem._MasterFixedAsset AS _MasterFixedAsset,
  AcItem._MasterFixedAssetText AS _MasterFixedAssetText,
  AcItem._OffsettingAccount AS _OffsettingAccount,
  AcItem._OffsettingAccountText AS _OffsettingAccountText,
  AcItem._OffsettingAccountType AS _OffsettingAccountType,
  AcItem._OffsettingAccountTypeText AS _OffsettingAccountTypeText,
  AcItem._OffsettingAccountWithBP AS _OffsettingAccountWithBP,
  AcItem._OffsettingChartOfAccounts AS _OffsettingChartOfAccounts,
  AcItem._OffsettingChartOfAccountsText AS _OffsettingChartOfAccountsText,
  AcItem._OperatingConcern AS _OperatingConcern,
  AcItem._OperatingConcernText AS _OperatingConcernText,
  AcItem._Order AS _Order,
  AcItem._OrderCategory AS _OrderCategory,
  AcItem._OriginCostCenter AS _OriginCostCenter,
  AcItem._OriginCostCtrActivityType AS _OriginCostCtrActivityType,
  AcItem._OriginProfitCenter AS _OriginProfitCenter,
  AcItem._OriginSenderObject AS _OriginSenderObject,
  AcItem._PartnerBudgetPeriod AS _PartnerBudgetPeriod,
  AcItem._PartnerBusinessArea AS _PartnerBusinessArea,
  AcItem._PartnerBusinessAreaText AS _PartnerBusinessAreaText,
  AcItem._PartnerBusinessProcess AS _PartnerBusinessProcess,
  AcItem._PartnerBusinessProcessText AS _PartnerBusinessProcessText,
  AcItem._PartnerCompany AS _PartnerCompany,
  AcItem._PartnerCompanyCode AS _PartnerCompanyCode,
  AcItem._PartnerCompanyCodeText AS _PartnerCompanyCodeText,
  AcItem._PartnerControllingObjectClass AS _PartnerControllingObjectClass,
  AcItem._PartnerCostCenter AS _PartnerCostCenter,
  AcItem._PartnerCostCtrActivityType AS _PartnerCostCtrActivityType,
  AcItem._PartnerFunctionalArea AS _PartnerFunctionalArea,
  AcItem._PartnerFund AS _PartnerFund,
  AcItem._PartnerFundText AS _PartnerFundText,
  AcItem._PartnerOrder AS _PartnerOrder,
  AcItem._PartnerOrder_2 AS _PartnerOrder_2,
  AcItem._PartnerOrderCategory AS _PartnerOrderCategory,
  AcItem._PartnerOrderText AS _PartnerOrderText,
  AcItem._PartnerProfitCenter AS _PartnerProfitCenter,
  AcItem._PartnerProjectBasicData AS _PartnerProjectBasicData,
  AcItem._PartnerProjectBasicDataText AS _PartnerProjectBasicDataText,
  AcItem._PartnerProjectInternalID AS _PartnerProjectInternalID,
  AcItem._PartnerSalesDocument AS _PartnerSalesDocument,
  AcItem._PartnerSalesDocumentItem AS _PartnerSalesDocumentItem,
  AcItem._PartnerSegment AS _PartnerSegment,
  AcItem._PartnerSegmentText AS _PartnerSegmentText,
  AcItem._PartnerServiceDocument AS _PartnerServiceDocument,
  AcItem._PartnerServiceDocumentItem AS _PartnerServiceDocumentItem,
  AcItem._PartnerServiceDocumentType AS _PartnerServiceDocumentType,
  AcItem._Plant AS _Plant,
  AcItem._PostingKey AS _PostingKey,
  AcItem._PredecessorReferenceDocType AS _PredecessorReferenceDocType,
  AcItem._Product AS _Product,
  AcItem._ProductText AS _ProductText,
  AcItem._ProfitCenter AS _ProfitCenter,
  AcItem._ProfitCenterText AS _ProfitCenterText,
  AcItem._ProjectBasicData AS _ProjectBasicData,
  AcItem._ProjectBasicDataText AS _ProjectBasicDataText,
  AcItem._ProjectInternalID AS _ProjectInternalID,
  AcItem._ProjectInternalIDText AS _ProjectInternalIDText,
  AcItem._PurchasingDocument AS _PurchasingDocument,
  AcItem._PurchasingDocumentItem AS _PurchasingDocumentItem,
  AcItem._ReferenceDocumentType AS _ReferenceDocumentType,
  AcItem._SalesDistrict AS _SalesDistrict,
  AcItem._SalesDocument AS _SalesDocument,
  AcItem._SalesDocumentItem AS _SalesDocumentItem,
  AcItem._SalesOrganization AS _SalesOrganization,
  AcItem._Segment AS _Segment,
  AcItem._SegmentText AS _SegmentText,
  AcItem._SemTagGLAccount AS _SemTagGLAccount,
  AcItem._ServiceContract AS _ServiceContract,
  AcItem._ServiceContractItem AS _ServiceContractItem,
  AcItem._ServiceContractType AS _ServiceContractType,
  AcItem._ServiceDocument AS _ServiceDocument,
  AcItem._ServiceDocumentItem AS _ServiceDocumentItem,
  AcItem._ServiceDocumentType AS _ServiceDocumentType,
  AcItem._ShipToParty AS _ShipToParty,
  AcItem._SoldProduct AS _SoldProduct,
  AcItem._SoldProductText AS _SoldProductText,
  AcItem._SourceLedger AS _SourceLedger,
  AcItem._SourceLedgerText AS _SourceLedgerText,
  AcItem._SpecialGLCode AS _SpecialGLCode,
  AcItem._SubLedgerAccLineItemType AS _SubLedgerAccLineItemType,
  AcItem._Supplier AS _Supplier,
  AcItem._SupplierText AS _SupplierText,
  AcItem._TaxCode AS _TaxCode,
  AcItem._TransactionCurrency AS _TransactionCurrency,
  AcItem._WBSElementBasicData AS _WBSElementBasicData,
  AcItem._WBSElementBasicDataText AS _WBSElementBasicDataText,
  AcItem._WBSElementInternalID AS _WBSElementInternalID,
  AcItem._WBSElementInternalIDText AS _WBSElementInternalIDText,
  AcItem._PartnerWBSElementBasicData AS _PartnerWBSElementBasicData,
  AcItem._WorkPackage AS _WorkPackage,
  AcItem._WorkPackageWorkItem AS _WorkPackageWorkItem
FROM I_GLAccountLineItem AS AcItem
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalID ON WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalIDText ON WBSElementExternalID = _WBSElementExternalIDText.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _PartnerWBSElementExternalID ON PartnerWBSElementExternalID = _PartnerWBSElementExternalID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _ProjectExternalID ON ProjectExternalID = _ProjectExternalID.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _ProjectExternalIDText ON ProjectExternalID = _ProjectExternalIDText.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _PartnerProjectExternalID ON PartnerProjectExternalID = _PartnerProjectExternalID.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_CalendarMonth AS _CalendarMonth ON CalendarMonth = _CalendarMonth.CalendarMonth  -- association [1..1]
LEFT OUTER JOIN I_CalendarQuarter AS _CalendarQuarter ON CalendarQuarter = _CalendarQuarter.CalendarQuarter  -- association [1..1]
LEFT OUTER JOIN I_YearMonth AS _CalendarYearMonth ON CalendarYearMonth = _CalendarYearMonth.YearMonth  -- association [1..1]
LEFT OUTER JOIN I_PubSecBdgtAcctRevnExpnCode AS _PubSecBdgtAcctRevnExpnCode ON PubSecBdgtAcctRevnExpnCode = _PubSecBdgtAcctRevnExpnCode.PubSecBdgtAcctRevnExpnCode  -- association [0..1]
LEFT OUTER JOIN I_FundType AS _FundType ON FinancialManagementArea = _FundType.FinancialManagementArea AND FundType = _FundType.FundType  -- association [0..1]
LEFT OUTER JOIN I_BudgetAccountInChtAccts AS _BudgetAccountInChtAccts ON ChartOfAccounts = _BudgetAccountInChtAccts.ChartOfAccounts AND PubSecBudgetAccount = _BudgetAccountInChtAccts.PubSecBudgetAccount  -- association [0..1]
LEFT OUTER JOIN I_ReferenceDocumentType AS _SourceReferenceDocumentType ON SourceReferenceDocumentType = _SourceReferenceDocumentType.ReferenceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_GranteeMgmtFundType AS _GranteeMgmtFundType ON GranteeMgmtFundType = _GranteeMgmtFundType.GranteeMgmtFundType  -- association [0..1]
LEFT OUTER JOIN I_Fund AS _FundHierarchy ON FinancialManagementArea = _FundHierarchy.FinancialManagementArea AND FundHierarchy = _FundHierarchy.Fund  -- association [0..1]
LEFT OUTER JOIN I_Fund AS _Fund ON FinancialManagementArea = _Fund.FinancialManagementArea AND Fund = _Fund.Fund  -- association [0..1]
LEFT OUTER JOIN I_Grant AS _GrantHierarchy ON GrantHierarchy = _GrantHierarchy.GrantID  -- association [0..1]
LEFT OUTER JOIN I_Grant AS _Grant ON GrantID = _Grant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_BudgetAccountInChtAccts AS _BudgetAccountInChtAcctsHier ON ChartOfAccounts = _BudgetAccountInChtAcctsHier.ChartOfAccounts AND BudgetAccountHierarchy = _BudgetAccountInChtAcctsHier.PubSecBudgetAccount  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalAreaHierarchy ON FunctionalAreaHierarchy = _FunctionalAreaHierarchy.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenterHierarchy ON ControllingArea = _CostCenterHierarchy.ControllingArea AND CostCenterHierarchy = _CostCenterHierarchy.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_PubSecCmtmtActlItemDSt AS _DocumentStore ON _DocumentStore.tra_ledger = Ledger AND _DocumentStore.tra_sourceledger = SourceLedger AND _DocumentStore.tra_companycode = CompanyCode AND _DocumentStore.tra_fiscalyear = FiscalYear AND _DocumentStore.tra_00113 = AccountingDocument AND _DocumentStore.tra_00098 = LedgerGLLineItem  -- association [0..1]
;