I_AssetHistorySheetCube

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_AssetHistorySheetCube.
-- 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_FiscalPeriod : fis_poper, P_KeyDate : fagl_keydate

CREATE VIEW I_AssetHistorySheetCube AS
SELECT
  cast(FixedAsset.AssetAdditionalDescription as fis_txa50_more) AS AssetAdditionalDescription,
  cast(_FixedAssetAssgmt.CostCenter as faa_kostl) AS AssetCostCenter,
  cast(_FixedAssetAssgmt.BusinessArea as faa_gsber) AS AssetBusinessArea,
  cast(_FixedAssetAssgmt.Fund as faa_bp_geber) AS AssetFund,
  cast(_FixedAssetAssgmt.ProfitCenter as faa_prctr) AS AssetProfitCenter,
  cast(_FixedAssetAssgmt.Segment as faa_fb_segment) AS AssetSegment,
  cast(_FixedAssetAssgmt.Plant as faa_werks) AS AssetPlant,
  cast(_FixedAssetAssgmt.BudgetPeriod as faa_budget_period) AS AssetBudgetPeriod,
  cast(_FixedAssetAssgmt.GrantID as faa_gm_grant_nbr) AS AssetGrant,
  cast(_FixedAssetAssgmt.CostCtrActivityType as faa_lstar) AS AssetCostCtrActivityType,
  cast(_FixedAssetAssgmt.PersonnelNumber as faa_pernr_d) AS AssetPersonnelNumber,
  cast(_FixedAssetAssgmt.FunctionalArea as faa_fkber) AS AssetFunctionalArea,
  cast(_FixedAssetAssgmt.FundsCenter as faa_fistl) AS AssetFundsCenter,
  FixedAsset.BaseUnit AS BaseUnit,
  FixedAsset.AssetAccountDetermination AS AssetAccountDetermination,
  FixedAsset.AssetClass AS AssetClass,
  FixedAsset.FixedAssetGroup AS FixedAssetGroup,
  FixedAsset.Supplier AS Supplier,
  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.InvestmentProjectWBSElement_2 AS WBSElementInternalID_2,
  FixedAsset.InvestmentProjectWBSElement AS WBSElementInternalID,
  FixedAsset.AssetAuthorizationContext AS AssetAuthorizationContext,
  P_AssetHistorySheetCube1.CompanyCode AS CompanyCode,
  P_AssetHistorySheetCube1.AssetDepreciationArea AS AssetDepreciationArea,
  P_AssetHistorySheetCube1.MasterFixedAsset AS MasterFixedAsset,
  P_AssetHistorySheetCube1.FixedAsset AS FixedAsset,
  P_AssetHistorySheetCube1.Ledger AS Ledger,
  P_AssetHistorySheetCube1.FiscalYear AS FiscalYear,
  P_AssetHistorySheetCube1.FiscalPeriod AS FiscalPeriod,
  P_AssetHistorySheetCube1.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  P_AssetHistorySheetCube1.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  P_AssetHistorySheetCube1.AssetAccountingKeyFigure AS AssetAccountingKeyFigure,
  P_AssetHistorySheetCube1.AssetAccountingKeyFigureSet AS AssetAccountingKeyFigureSet,
  P_AssetHistorySheetCube1.AccountingDocument AS AccountingDocument,
  P_AssetHistorySheetCube1.LedgerGLLineItem AS LedgerGLLineItem,
  P_AssetHistorySheetCube1.TransactionSubitem AS TransactionSubitem,
  P_AssetHistorySheetCube1.DebitCreditCode AS DebitCreditCode,
  P_AssetHistorySheetCube1.CurrencyRole AS CurrencyRole,
  P_AssetHistorySheetCube1.KeyFigureIsZeroBalance AS KeyFigureIsZeroBalance,
  P_AssetHistorySheetCube1.LedgerFiscalYear AS LedgerFiscalYear,
  P_AssetHistorySheetCube1.FiscalYearVariant AS FiscalYearVariant,
  P_AssetHistorySheetCube1.FiscalYearPeriod AS FiscalYearPeriod,
  P_AssetHistorySheetCube1.DepreciationFiscalPeriod AS DepreciationFiscalPeriod,
  P_AssetHistorySheetCube1.PostingDate AS PostingDate,
  P_AssetHistorySheetCube1.AssetAccountingSortedKeyFigure AS AssetAccountingSortedKeyFigure,
  P_AssetHistorySheetCube1.LedgerGroup AS LedgerGroup,
  P_AssetHistorySheetCube1.ChartOfAccounts AS ChartOfAccounts,
  P_AssetHistorySheetCube1.GLAccount AS GLAccount,
  P_AssetHistorySheetCube1.AlternativeGLAccount AS AlternativeGLAccount,
  P_AssetHistorySheetCube1.GroupMasterFixedAsset AS GroupMasterFixedAsset,
  P_AssetHistorySheetCube1.GroupFixedAsset AS GroupFixedAsset,
  P_AssetHistorySheetCube1.FinancialAccountType AS FinancialAccountType,
  P_AssetHistorySheetCube1.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  P_AssetHistorySheetCube1.CreationTime AS CreationTime,
  P_AssetHistorySheetCube1.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  P_AssetHistorySheetCube1.ChartOfDepreciation AS ChartOfDepreciation,
  P_AssetHistorySheetCube1.CostCenter AS CostCenter,
  P_AssetHistorySheetCube1.Plant AS Plant,
  P_AssetHistorySheetCube1.BusinessArea AS BusinessArea,
  P_AssetHistorySheetCube1.PersonnelNumber AS PersonnelNumber,
  P_AssetHistorySheetCube1.FinancialManagementArea AS FinancialManagementArea,
  P_AssetHistorySheetCube1.Fund AS Fund,
  P_AssetHistorySheetCube1.GrantID AS GrantID,
  P_AssetHistorySheetCube1.FunctionalArea AS FunctionalArea,
  P_AssetHistorySheetCube1.BudgetPeriod AS BudgetPeriod,
  P_AssetHistorySheetCube1.ProfitCenter AS ProfitCenter,
  P_AssetHistorySheetCube1.Segment AS Segment,
  P_AssetHistorySheetCube1.FundsCenter AS FundsCenter,
  P_AssetHistorySheetCube1.AssetTransactionType AS AssetTransactionType,
  P_AssetHistorySheetCube1.Country AS Country,
  P_AssetHistorySheetCube1.ControllingArea AS ControllingArea,
  P_AssetHistorySheetCube1.CountryChartOfAccounts AS CountryChartOfAccounts,
  P_AssetHistorySheetCube1.FinancialStatementVariant AS FinancialStatementVariant,
  P_AssetHistorySheetCube1.AccountingPrinciple AS AccountingPrinciple,
  P_AssetHistorySheetCube1.SelectedCurrencyBranch AS SelectedCurrencyBranch,
  P_AssetHistorySheetCube1.DisplayCurrency AS DisplayCurrency,
  P_AssetHistorySheetCube1.AmountInDisplayCurrency AS AmountInDisplayCurrency,
  P_AssetHistorySheetCube1.Quantity AS Quantity,
  _AssetValuationForLedger.InvestmentSupportMeasure AS InvestmentSupportMeasure,
  _AssetValuationForLedger.DepreciationStartDate AS DepreciationStartDate,
  _AssetValuationForLedger.SpecialDeprStartDate AS SpecialDeprStartDate,
  _AssetValuationForLedger.DepreciationKey AS DepreciationKey,
  _AssetValuationForLedger.PlannedUsefulLifeInYears AS PlannedUsefulLifeInYears,
  _AssetValuationForLedger.PlannedUsefulLifeInPeriods AS PlannedUsefulLifeInPeriods,
  _AssetValuationForLedger.OriglAstUsefulLifeInYears AS OriglAstUsefulLifeInYears,
  _AssetValuationForLedger.OriglAstUsefulLifeInPerds AS OriglAstUsefulLifeInPerds,
  _AssetValuationForLedger.DeprKeyChangeoverYear AS DeprKeyChangeoverYear,
  _AssetValuationForLedger.DeprKeyChangeoverPeriod AS DeprKeyChangeoverPeriod,
  _AssetValuationForLedger.VintageYear AS VintageYear,
  _AssetValuationForLedger.VintageMonth AS VintageMonth,
  _AssetValuationForLedger.ReplacementValueIndexSers AS ReplacementValueIndexSers,
  _AssetValuationForLedger.RplcmtValueAgingIndexSers AS RplcmtValueAgingIndexSers,
  _BalanceSheetAccount.AcqnProdnCostGLAccount AS AcqnProdnCostGLAccount,
  _FixedAssetAssgmt.AssetLocation AS AssetLocation,
  _FixedAssetAssgmt.REInternalFinNumber AS REInternalFinNumber,
  _FixedAssetAssgmt.RealEstateObject AS RealEstateObject,
  _FixedAssetAssgmt.Room AS Room,
  _FixedAssetAssgmt.VehicleLicensePlateNumber AS VehicleLicensePlateNumber,
  _FixedAssetAssgmt.TaxJurisdiction AS TaxJurisdiction,
  _FixedAssetCountryData.NationalClassification AS NationalClassification,
  _FixedAssetCountryData.TaxDepreciationGroup AS TaxDepreciationGroup,
  _FixedAssetCountryData.JP_PrptyTxRptCity AS JP_PrptyTxRptCity,
  _FixedAssetCountryData.JP_PrptyTxRptClassfctnKey AS JP_PrptyTxRptClassfctnKey,
  _FixedAssetForLedger.AssetCapitalizationDate AS AssetCapitalizationDate,
  _FixedAssetForLedger.FirstAcquisitionFiscalYear AS FirstAcquisitionFiscalYear,
  _FixedAssetForLedger.FirstAcquisitionFiscalPeriod AS FirstAcquisitionFiscalPeriod,
  _FixedAssetForLedger.AssetDeactivationDate AS AssetDeactivationDate,
  _GlobAssetAssignment.RU_AssetOKOF AS RU_AssetOKOF,
  _GlobAssetAssignment.RU_AssetDepreciationGroup AS RU_AssetDepreciationGroup,
  _WBSElement_2.WBSElementExternalID AS WBSElementExternalID
FROM P_AssetHistorySheetCube1
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON CompanyCode = _FixedAsset.CompanyCode AND MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset  -- association [1]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON CompanyCode = _MasterFixedAsset.CompanyCode AND MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset  -- 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_FixedAssetGroup AS _FixedAssetGroup ON FixedAssetGroup = _FixedAssetGroup.FixedAssetGroup  -- association [0..1]
LEFT OUTER JOIN I_InternalOrder AS _InvestmentOrder ON InvestmentOrder = _InvestmentOrder.InternalOrder  -- association [0..1]
LEFT OUTER JOIN I_Group1AssetEvaluationKey AS _Group1AssetEvaluationKey ON Group1AssetEvaluationKey = _Group1AssetEvaluationKey.Group1AssetEvaluationKey  -- association [0..1]
LEFT OUTER JOIN I_Group2AssetEvaluationKey AS _Group2AssetEvaluationKey ON Group2AssetEvaluationKey = _Group2AssetEvaluationKey.Group2AssetEvaluationKey  -- association [0..1]
LEFT OUTER JOIN I_Group3AssetEvaluationKey AS _Group3AssetEvaluationKey ON Group3AssetEvaluationKey = _Group3AssetEvaluationKey.Group3AssetEvaluationKey  -- association [0..1]
LEFT OUTER JOIN I_Group4AssetEvaluationKey AS _Group4AssetEvaluationKey ON Group4AssetEvaluationKey = _Group4AssetEvaluationKey.Group4AssetEvaluationKey  -- association [0..1]
LEFT OUTER JOIN I_Group5AssetEvaluationKey AS _Group5AssetEvaluationKey ON Group5AssetEvaluationKey = _Group5AssetEvaluationKey.Group5AssetEvaluationKey  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON BaseUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_LedgerGroup AS _LedgerGroup ON LedgerGroup = _LedgerGroup.LedgerGroup  -- association [0..1]
LEFT OUTER JOIN I_AssetKeyFigure AS _AssetKeyFigure ON AssetAccountingKeyFigure = _AssetKeyFigure.AssetAccountingKeyFigure  -- association [0..1]
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_DepreciationAreaForLedger AS _DepreciationArea ON CompanyCode = _DepreciationArea.CompanyCode AND Ledger = _DepreciationArea.Ledger AND AssetDepreciationArea = _DepreciationArea.AssetDepreciationArea  -- association [0..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- 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_ChartOfDepreciation AS _ChartOfDepreciation ON ChartOfDepreciation = _ChartOfDepreciation.ChartOfDepreciation  -- 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_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_FinancialAccountType AS _FinancialAccountType ON FinancialAccountType = _FinancialAccountType.FinancialAccountType  -- association [0..1]
LEFT OUTER JOIN I_AccountingPrinciple AS _AccountingPrinciple ON AccountingPrinciple = _AccountingPrinciple.AccountingPrinciple  -- association [1]
LEFT OUTER JOIN I_AssetTransactionType AS _AssetTransactionType ON AssetTransactionType = _AssetTransactionType.AssetTransactionType  -- 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_JournalEntry AS _JournalEntry ON CompanyCode = _JournalEntry.CompanyCode AND FiscalYear = _JournalEntry.FiscalYear AND AccountingDocument = _JournalEntry.AccountingDocument  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _AssetCostCenter ON ControllingArea = _AssetCostCenter.ControllingArea AND AssetCostCenter = _AssetCostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenterActivityType AS _AssetCostCenterActivityType ON AssetCostCtrActivityType = _AssetCostCenterActivityType.CostCtrActivityType AND ControllingArea = _AssetCostCenterActivityType.ControllingArea  -- association [0..*]
LEFT OUTER JOIN I_BusinessArea AS _AssetBusinessArea ON AssetBusinessArea = _AssetBusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _AssetProfitCenter ON AssetProfitCenter = _AssetProfitCenter.ProfitCenter AND ControllingArea = _AssetProfitCenter.ControllingArea  -- association [0..*]
LEFT OUTER JOIN I_FunctionalArea AS _AssetFunctionalArea ON AssetFunctionalArea = _AssetFunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_Segment AS _AssetSegment ON AssetSegment = _AssetSegment.Segment  -- association [0..1]
LEFT OUTER JOIN I_Location AS _AssetLocation ON assetlocation = _AssetLocation.Location AND AssetPlant = _AssetLocation.Plant  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _AssetPlant ON AssetPlant = _AssetPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_DepreciationKey AS _DepreciationKey ON ChartOfDepreciation = _DepreciationKey.ChartOfDepreciation AND depreciationkey = _DepreciationKey.DepreciationKey  -- association [0..1]
LEFT OUTER JOIN I_InvestmentSupportMeasure AS _InvestmentSupportMeasure ON ChartOfDepreciation = _InvestmentSupportMeasure.ChartOfDepreciation AND investmentsupportmeasure = _InvestmentSupportMeasure.InvestmentSupportMeasure  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _CountryChartOfAccounts ON CountryChartOfAccounts = _CountryChartOfAccounts.ChartOfAccounts  -- association [0..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_GLAccountInChartOfAccounts AS _AcqnProdnCostGLAccount ON ChartOfAccounts = _AcqnProdnCostGLAccount.ChartOfAccounts AND acqnprodncostglaccount = _AcqnProdnCostGLAccount.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_AssetBalanceSheetAccount AS _BalanceSheetAccount ON CompanyCode = _BalanceSheetAccount.CompanyCode AND AssetAccountDetermination = _BalanceSheetAccount.AssetAccountDetermination AND AssetDepreciationArea = _BalanceSheetAccount.AssetRealDepreciationArea  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON _Currency.Currency = DisplayCurrency  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRole AS _CurrencyRole ON _CurrencyRole.CurrencyRole = CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_SelectedCurrencyBranch AS _SelectedCurrencyBranch ON _SelectedCurrencyBranch.SelectedCurrencyBranch = SelectedCurrencyBranch  -- 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_FiscalYearVariant AS _FiscalYearVariant ON FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant  -- association [1..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_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_WBSElementBasicData AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement_2 ON WBSElementInternalID_2 = _WBSElement_2.WBSElementInternalID  -- 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_Country AS _Country ON Country = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_JP_PrptyTxRptCity AS _JP_PrptyTxRptCity ON jp_prptytxrptcity = _JP_PrptyTxRptCity.JP_PrptyTxRptCity  -- association [0..1]
LEFT OUTER JOIN I_JP_PrptyTxRptClassfctnKey AS _JP_PrptyTxRptClassfctnKey ON jp_prptytxrptclassfctnkey = _JP_PrptyTxRptClassfctnKey.JP_PrptyTxRptClassfctnKey  -- association [0..1]
LEFT OUTER JOIN I_RU_AssetDepreciationGroup AS _RU_AssetDepreciationGroup ON ru_assetdepreciationgroup = _RU_AssetDepreciationGroup.RU_AssetDepreciationGroup AND Country = _RU_AssetDepreciationGroup.Country AND ru_assetokof = _RU_AssetDepreciationGroup.RU_AssetOKOF  -- association [0..1]
LEFT OUTER JOIN I_RU_AssetOKOF AS _RU_AssetOKOF ON ru_assetokof = _RU_AssetOKOF.RU_AssetOKOF AND Country = _RU_AssetOKOF.Country  -- association [0..1]
LEFT OUTER JOIN I_AssetRedesignSwitchStatus AS _AssetRedesignSwitchStatus ON _AssetRedesignSwitchStatus.AssetRedesignSwitchIsActive = '' OR _AssetRedesignSwitchStatus.AssetRedesignSwitchIsActive = 'X'  -- association [1]
LEFT OUTER JOIN I_FixedAssetForLedger AS _FixedAssetForLedger ON CompanyCode = _FixedAssetForLedger.CompanyCode AND MasterFixedAsset = _FixedAssetForLedger.MasterFixedAsset AND FixedAsset = _FixedAssetForLedger.FixedAsset AND Ledger = _FixedAssetForLedger.Ledger  -- association [0..1]
LEFT OUTER JOIN I_FixedAssetAssgmt AS _FixedAssetAssgmt ON _FixedAssetAssgmt.CompanyCode = CompanyCode AND _FixedAssetAssgmt.MasterFixedAsset = MasterFixedAsset AND _FixedAssetAssgmt.FixedAsset = FixedAsset AND _FixedAssetAssgmt.ValidityStartDate <= $parameters.P_KeyDate AND _FixedAssetAssgmt.ValidityEndDate >= $parameters.P_KeyDate  -- association [0..1]
LEFT OUTER JOIN I_AssetValuationForLedger AS _AssetValuationForLedger ON _AssetValuationForLedger.CompanyCode = CompanyCode AND _AssetValuationForLedger.MasterFixedAsset = MasterFixedAsset AND _AssetValuationForLedger.FixedAsset = FixedAsset AND _AssetValuationForLedger.Ledger = Ledger AND _AssetValuationForLedger.AssetRealDepreciationArea = AssetDepreciationArea AND _AssetValuationForLedger.ValidityStartDate <= $parameters.P_KeyDate AND _AssetValuationForLedger.ValidityEndDate >= $parameters.P_KeyDate  -- association [0..1]
LEFT OUTER JOIN I_GlobAssetAssignment AS _GlobAssetAssignment ON _GlobAssetAssignment.CompanyCode = CompanyCode AND _GlobAssetAssignment.MasterFixedAsset = MasterFixedAsset AND _GlobAssetAssignment.FixedAsset = FixedAsset AND _GlobAssetAssignment.ValidityStartDate <= $parameters.P_KeyDate AND _GlobAssetAssignment.ValidityEndDate >= $parameters.P_KeyDate  -- association [0..1]
LEFT OUTER JOIN E_FixedAsset AS _Extension ON MasterFixedAsset = _Extension.MasterFixedAsset AND FixedAsset = _Extension.FixedAsset AND CompanyCode = _Extension.CompanyCode  -- association [1..1]
;