I_FixedAssetValueForToFsclPerd

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_FixedAssetValueForToFsclPerd.
-- 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_AssetAccountingKeyFigureSet : faa_key_figure_set, P_FiscalYear : fis_gjahr, P_ToFiscalPeriod : fis_period_to

CREATE VIEW I_FixedAssetValueForToFsclPerd AS
SELECT
  Values.CompanyCode AS CompanyCode,
  Values.AssetDepreciationArea AS AssetDepreciationArea,
  Values.MasterFixedAsset AS MasterFixedAsset,
  Values.FixedAsset AS FixedAsset,
  Values.AccountingDocument AS AccountingDocument,
  Values.TransactionSubitem AS TransactionSubitem,
  Values.Ledger AS Ledger,
  Values.FiscalYear AS FiscalYear,
  Values.FiscalPeriod AS FiscalPeriod,
  Values.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  Values.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  :P_AssetAccountingKeyFigureSet AS AssetAccountingKeyFigureSet,
  Values.AssetAccountingKeyFigure AS AssetAccountingKeyFigure,
  Values.DebitCreditCode AS DebitCreditCode,
  LedgerFiscalYear,
  LedgerCompanyCodeCrcyRole.FiscalYearVariant AS FiscalYearVariant,
  FiscalYearPeriod,
  DepreciationFiscalPeriod,
  Values.AssetAccountingSortedKeyFigure AS AssetAccountingSortedKeyFigure,
  Values.PlannedValueIsInclusive AS PlannedValueIsInclusive,
  Values.LedgerGroup AS LedgerGroup,
  _CompanyCode.Country AS Country,
  Values.CountryChartOfAccounts AS CountryChartOfAccounts,
  Values.GLAccount AS GLAccount,
  Values.AlternativeGLAccount AS AlternativeGLAccount,
  Values.GroupMasterFixedAsset AS GroupMasterFixedAsset,
  Values.GroupFixedAsset AS GroupFixedAsset,
  Values.FinancialAccountType AS FinancialAccountType,
  Values.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  Values.CreationTime AS CreationTime,
  Values.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  Values.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  Values.ChartOfDepreciation AS ChartOfDepreciation,
  _AssetDepreciationArea.FinancialStatementVariant AS FinancialStatementVariant,
  LedgerCompanyCodeCrcyRole.AccountingPrinciple AS AccountingPrinciple,
  Values.CostCenter AS CostCenter,
  Values.Plant AS Plant,
  Values.BusinessArea AS BusinessArea,
  Values.PersonnelNumber AS PersonnelNumber,
  Values.FinancialManagementArea AS FinancialManagementArea,
  Values.Fund AS Fund,
  Values.GrantID AS GrantID,
  Values.FunctionalArea AS FunctionalArea,
  Values.BudgetPeriod AS BudgetPeriod,
  Values.ProfitCenter AS ProfitCenter,
  Values.Segment AS Segment,
  Values.FundsCenter AS FundsCenter,
  Values.AssetTransactionType AS AssetTransactionType,
  Values.AccountingDocumentType AS AccountingDocumentType,
  Values.ReferenceDocumentItem AS ReferenceDocumentItem,
  Values.ReferenceDocumentType AS ReferenceDocumentType,
  Values.LogicalSystem AS LogicalSystem,
  Values.ReferenceDocument AS ReferenceDocument,
  Values.ReferenceDocumentContext AS ReferenceDocumentContext,
  Values.ReversalReferenceDocument AS ReversalReferenceDocument,
  Values.ReversalReferenceDocumentCntxt AS ReversalReferenceDocumentCntxt,
  Values.ReversalTransactionSubitem AS ReversalTransactionSubitem,
  Values.IsReversal AS IsReversal,
  Values.IsReversed AS IsReversed,
  Values.DocumentDate AS DocumentDate,
  Values.PostingDate AS PostingDate,
  Values.AssetValueDate AS AssetValueDate,
  Values.AssignmentReference AS AssignmentReference,
  Values.DocumentItemText AS DocumentItemText,
  Values.IsStatisticalDocument AS IsStatisticalDocument,
  Values.GLBusinessTransactionType AS GLBusinessTransactionType,
  _CompanyCode.ChartOfAccounts AS ChartOfAccounts,
  _CompanyCode.ControllingArea AS ControllingArea,
  Values.CompanyCodeCurrency AS CompanyCodeCurrency,
  LedgerCompanyCodeCrcyRole.CompanyCodeCurrencyRole AS CompanyCodeCurrencyRole,
  Values.GlobalCurrency AS GlobalCurrency,
  LedgerCompanyCodeCrcyRole.GlobalCurrencyRole AS GlobalCurrencyRole,
  Values.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency1Role AS FreeDefinedCurrency1Role,
  Values.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency2Role AS FreeDefinedCurrency2Role,
  Values.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency3Role AS FreeDefinedCurrency3Role,
  Values.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency4Role AS FreeDefinedCurrency4Role,
  Values.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency5Role AS FreeDefinedCurrency5Role,
  Values.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency6Role AS FreeDefinedCurrency6Role,
  Values.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency7Role AS FreeDefinedCurrency7Role,
  Values.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency8Role AS FreeDefinedCurrency8Role,
  BaseUnit,
  Quantity,
  _FixedAsset.AssetAccountDetermination AS AssetAccountDetermination,
  _FixedAsset.AssetClass AS AssetClass,
  _FixedAsset.FixedAssetGroup AS FixedAssetGroup,
  _FixedAsset.AssetSupplierName AS AssetSupplierName,
  _FixedAsset.InvestmentOrder AS InvestmentOrder,
  _FixedAsset.InventoryIsCounted AS InventoryIsCounted,
  _FixedAsset.LastInventoryDate AS LastInventoryDate,
  _FixedAsset.Inventory AS Inventory,
  _FixedAsset.Group1AssetEvaluationKey AS Group1AssetEvaluationKey,
  _FixedAsset.Group2AssetEvaluationKey AS Group2AssetEvaluationKey,
  _FixedAsset.Group3AssetEvaluationKey AS Group3AssetEvaluationKey,
  _FixedAsset.Group4AssetEvaluationKey AS Group4AssetEvaluationKey,
  _FixedAsset.Group5AssetEvaluationKey AS Group5AssetEvaluationKey,
  _FixedAsset.AssetSerialNumber AS AssetSerialNumber,
  _FixedAsset.Supplier AS Supplier,
  _FixedAssetForLedger.AssetCapitalizationDate AS AssetCapitalizationDate,
  _FixedAssetForLedger.AssetDeactivationDate AS AssetDeactivationDate,
  _FixedAssetForLedger.FirstAcquisitionFiscalYear AS FirstAcquisitionFiscalYear,
  _FixedAssetForLedger.FirstAcquisitionFiscalPeriod AS FirstAcquisitionFiscalPeriod,
  _FixedAssetCountryData.NationalClassification AS NationalClassification,
  _FixedAssetCountryData.TaxDepreciationGroup AS TaxDepreciationGroup,
  Values.PartnerMasterFixedAsset AS PartnerMasterFixedAsset,
  Values.PartnerFixedAsset AS PartnerFixedAsset,
  _FixedAsset.InvestmentProjectWBSElement AS WBSElementInternalID,
  _FixedAsset._FixedAssetGroup AS _FixedAssetGroup,
  _FixedAsset._InvestmentOrder AS _InvestmentOrder,
  _FixedAsset._Group1AssetEvaluationKey AS _Group1AssetEvaluationKey,
  _FixedAsset._Group2AssetEvaluationKey AS _Group2AssetEvaluationKey,
  _FixedAsset._Group3AssetEvaluationKey AS _Group3AssetEvaluationKey,
  _FixedAsset._Group4AssetEvaluationKey AS _Group4AssetEvaluationKey,
  _FixedAsset._Group5AssetEvaluationKey AS _Group5AssetEvaluationKey
FROM P_FixedAssetValueForToFsclPerd
INNER JOIN I_LedgerCompanyCodeCrcyRoles AS LedgerCompanyCodeCrcyRole ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AssetKeyFigureSet AS _AssetKeyFigureSet ON AssetAccountingKeyFigureSet = _AssetKeyFigureSet.AssetAccountingKeyFigureSet  -- association [0..1]
LEFT OUTER JOIN I_AssetSortedKeyFigureSetSpec AS _AssetSortedKeyFigureSetSpec ON AssetAccountingKeyFigureSet = _AssetSortedKeyFigureSetSpec.AssetAccountingKeyFigureSet AND AssetAccountingSortedKeyFigure = _AssetSortedKeyFigureSetSpec.AssetAccountingSortedKeyFigure  -- association [1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_DepreciationAreaForLedger AS _DepreciationArea ON CompanyCode = _DepreciationArea.CompanyCode AND Ledger = _DepreciationArea.Ledger AND AssetDepreciationArea = _DepreciationArea.AssetDepreciationArea  -- association [0..1]
LEFT OUTER JOIN I_RealDepreciationAreaByCoCode AS _AssetDepreciationArea ON CompanyCode = _AssetDepreciationArea.CompanyCode AND AssetDepreciationArea = _AssetDepreciationArea.AssetRealDepreciationArea  -- association [0..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON CompanyCode = _MasterFixedAsset.CompanyCode AND MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON CompanyCode = _FixedAsset.CompanyCode AND MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset  -- association [0..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _PartnerMasterFixedAsset ON CompanyCode = _PartnerMasterFixedAsset.CompanyCode AND PartnerMasterFixedAsset = _PartnerMasterFixedAsset.MasterFixedAsset  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _PartnerFixedAsset ON CompanyCode = _PartnerFixedAsset.CompanyCode AND PartnerMasterFixedAsset = _PartnerFixedAsset.MasterFixedAsset AND PartnerFixedAsset = _PartnerFixedAsset.FixedAsset  -- association [0..1]
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON CompanyCode = _JournalEntry.CompanyCode AND FiscalYear = _JournalEntry.FiscalYear AND AccountingDocument = _JournalEntry.AccountingDocument  -- association [0..1]
LEFT OUTER JOIN I_DebitCreditCode AS _DebitCreditCode ON DebitCreditCode = _DebitCreditCode.DebitCreditCode  -- association [1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYear ON FiscalYear = _FiscalYear.FiscalYear AND CompanyCode = _FiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearPeriodForCmpnyCode AS _FiscalPeriod ON FiscalYear = _FiscalPeriod.FiscalYear AND FiscalPeriod = _FiscalPeriod.FiscalPeriod AND CompanyCode = _FiscalPeriod.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearPeriodForLedger AS _FiscalYearPeriod ON CompanyCode = _FiscalYearPeriod.CompanyCode AND Ledger = _FiscalYearPeriod.Ledger AND FiscalYear = _FiscalYearPeriod.FiscalYear AND FiscalPeriod = _FiscalYearPeriod.FiscalPeriod  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON chartofaccounts = _ChartOfAccounts.ChartOfAccounts  -- association [1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts ON chartofaccounts = _GLAccountInChartOfAccounts.ChartOfAccounts AND GLAccount = _GLAccountInChartOfAccounts.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _AlternativeGLAccount ON CountryChartOfAccounts = _AlternativeGLAccount.ChartOfAccounts AND AlternativeGLAccount = _AlternativeGLAccount.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_SubLedgerAccLineItemType AS _SubLedgerAccLineItemType ON SubLedgerAcctLineItemType = _SubLedgerAccLineItemType.SubLedgerAcctLineItemType  -- association [0..1]
LEFT OUTER JOIN I_MovementCategory AS _AssetAcctTransClassfctn ON AssetAcctTransClassfctn = _AssetAcctTransClassfctn.AssetAcctTransClassfctn  -- association [0..1]
LEFT OUTER JOIN I_AssetKeyFigure AS _AssetKeyFigure ON AssetAccountingKeyFigure = _AssetKeyFigure.AssetAccountingKeyFigure  -- association [0..1]
LEFT OUTER JOIN I_LedgerGroup AS _LedgerGroup ON LedgerGroup = _LedgerGroup.LedgerGroup  -- association [0..1]
LEFT OUTER JOIN I_FinancialAccountType AS _FinancialAccountType ON FinancialAccountType = _FinancialAccountType.FinancialAccountType  -- association [0..1]
LEFT OUTER JOIN I_ChartOfDepreciation AS _ChartOfDepreciation ON ChartOfDepreciation = _ChartOfDepreciation.ChartOfDepreciation  -- association [0..1]
LEFT OUTER JOIN I_FinancialStatementVersion AS _FinancialStatementVersion ON financialstatementvariant = _FinancialStatementVersion.FinancialStatementVariant  -- association [0..1]
LEFT OUTER JOIN I_AccountingPrinciple AS _AccountingPrinciple ON AccountingPrinciple = _AccountingPrinciple.AccountingPrinciple  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON CostCenter = _CostCenter.CostCenter AND controllingarea = _CostCenter.ControllingArea  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ProfitCenter = _ProfitCenter.ProfitCenter AND controllingarea = _ProfitCenter.ControllingArea  -- association [0..*]
LEFT OUTER JOIN I_Segment AS _Segment ON Segment = _Segment.Segment  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_AssetTransactionType AS _AssetTransactionType ON AssetTransactionType = _AssetTransactionType.AssetTransactionType  -- association [0..1]
LEFT OUTER JOIN I_AssetClass AS _AssetClass ON assetclass = _AssetClass.AssetClass  -- association [0..1]
LEFT OUTER JOIN I_AssetAcctDetermination AS _AssetAccountDetermination ON assetaccountdetermination = _AssetAccountDetermination.AssetAccountDetermination  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearVariant AS _FiscalYearVariant ON FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _CountryChartOfAccounts ON CountryChartOfAccounts = _CountryChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON controllingarea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON country = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _GlobalCurrency ON GlobalCurrency = _GlobalCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency1 ON FreeDefinedCurrency1 = _FreeDefinedCurrency1.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency2 ON FreeDefinedCurrency2 = _FreeDefinedCurrency2.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency3 ON FreeDefinedCurrency3 = _FreeDefinedCurrency3.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency4 ON FreeDefinedCurrency4 = _FreeDefinedCurrency4.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency5 ON FreeDefinedCurrency5 = _FreeDefinedCurrency5.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency6 ON FreeDefinedCurrency6 = _FreeDefinedCurrency6.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency7 ON FreeDefinedCurrency7 = _FreeDefinedCurrency7.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency8 ON FreeDefinedCurrency8 = _FreeDefinedCurrency8.Currency  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRole AS _CompanyCodeCurrencyRole ON CompanyCodeCurrencyRole = _CompanyCodeCurrencyRole.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRole AS _GlobalCurrencyRole ON GlobalCurrencyRole = _GlobalCurrencyRole.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRole AS _FreeDefinedCurrency1Role ON FreeDefinedCurrency1Role = _FreeDefinedCurrency1Role.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRole AS _FreeDefinedCurrency2Role ON FreeDefinedCurrency2Role = _FreeDefinedCurrency2Role.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRole AS _FreeDefinedCurrency3Role ON FreeDefinedCurrency3Role = _FreeDefinedCurrency3Role.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRole AS _FreeDefinedCurrency4Role ON FreeDefinedCurrency4Role = _FreeDefinedCurrency4Role.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRole AS _FreeDefinedCurrency5Role ON FreeDefinedCurrency5Role = _FreeDefinedCurrency5Role.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRole AS _FreeDefinedCurrency6Role ON FreeDefinedCurrency6Role = _FreeDefinedCurrency6Role.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRole AS _FreeDefinedCurrency7Role ON FreeDefinedCurrency7Role = _FreeDefinedCurrency7Role.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRole AS _FreeDefinedCurrency8Role ON FreeDefinedCurrency8Role = _FreeDefinedCurrency8Role.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON BaseUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForVariant AS _LedgerFiscalYearForVariant ON LedgerFiscalYear = _LedgerFiscalYearForVariant.FiscalYear AND FiscalYearVariant = _LedgerFiscalYearForVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearPeriodForVariant AS _FiscalYearPeriodForVariant ON FiscalYearPeriod = _FiscalYearPeriodForVariant.FiscalYearPeriod AND FiscalYearVariant = _FiscalYearPeriodForVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _FiscalPeriodForVariant ON LedgerFiscalYear = _FiscalPeriodForVariant.FiscalYear AND FiscalPeriod = _FiscalPeriodForVariant.FiscalPeriod AND FiscalYearVariant = _FiscalPeriodForVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentType AS _AccountingDocumentType ON AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_FixedAssetNatlClfn AS _FixedAssetNatlClfn ON country = _FixedAssetNatlClfn.Country AND nationalclassification = _FixedAssetNatlClfn.NationalClassification  -- association [0..1]
LEFT OUTER JOIN I_TaxDepreciationGroup AS _TaxDepreciationGroup ON country = _TaxDepreciationGroup.Country AND taxdepreciationgroup = _TaxDepreciationGroup.TaxDepreciationGroup  -- association [0..1]
LEFT OUTER JOIN I_FixedAssetCountryData AS _FixedAssetCountryData ON CompanyCode = _FixedAssetCountryData.CompanyCode AND MasterFixedAsset = _FixedAssetCountryData.MasterFixedAsset AND FixedAsset = _FixedAssetCountryData.FixedAsset  -- association [0..1]
LEFT OUTER JOIN I_FixedAssetForLedger AS _FixedAssetForLedger ON _FixedAssetForLedger.CompanyCode = CompanyCode AND _FixedAssetForLedger.MasterFixedAsset = MasterFixedAsset AND _FixedAssetForLedger.FixedAsset = FixedAsset AND _FixedAssetForLedger.Ledger = Ledger  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_FinancialManagementArea AS _FinancialManagementArea ON FinancialManagementArea = _FinancialManagementArea.FinancialManagementArea  -- 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_BudgetPeriod AS _BudgetPeriod ON BudgetPeriod = _BudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
;