I_FixedAssetTransaction

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_FixedAssetTransaction.
-- 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_KeyDate : fagl_keydate, P_AssetAccountingKeyFigureSet : faa_key_figure_set

CREATE VIEW I_FixedAssetTransaction AS
SELECT
  P_FixedAssetTransaction1.CompanyCode AS CompanyCode,
  P_FixedAssetTransaction1.AssetDepreciationArea AS AssetDepreciationArea,
  P_FixedAssetTransaction1.MasterFixedAsset AS MasterFixedAsset,
  P_FixedAssetTransaction1.FixedAsset AS FixedAsset,
  P_FixedAssetTransaction1.Ledger AS Ledger,
  P_FixedAssetTransaction1.FiscalYear AS FiscalYear,
  P_FixedAssetTransaction1.FiscalPeriod AS FiscalPeriod,
  P_FixedAssetTransaction1.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  P_FixedAssetTransaction1.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  P_FixedAssetTransaction1.AssetAccountingKeyFigure AS AssetAccountingKeyFigure,
  P_FixedAssetTransaction1.AssetAccountingKeyFigureSet AS AssetAccountingKeyFigureSet,
  P_FixedAssetTransaction1.AccountingDocument AS AccountingDocument,
  P_FixedAssetTransaction1.LedgerGLLineItem AS LedgerGLLineItem,
  P_FixedAssetTransaction1.TransactionSubitem AS TransactionSubitem,
  P_FixedAssetTransaction1.DebitCreditCode AS DebitCreditCode,
  cast(P_FixedAssetTransaction1.CurrencyRole as fins_curtype) AS CurrencyRole,
  P_FixedAssetTransaction1.LedgerGroup AS LedgerGroup,
  P_FixedAssetTransaction1.LedgerFiscalYear AS LedgerFiscalYear,
  P_FixedAssetTransaction1.FiscalYearVariant AS FiscalYearVariant,
  P_FixedAssetTransaction1.FiscalYearPeriod AS FiscalYearPeriod,
  _FixedAsset.AssetAuthorizationContext AS AssetAuthorizationContext,
  _FixedAsset.FixedAssetExternalID AS FixedAssetExternalID,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  P_FixedAssetTransaction1.GroupMasterFixedAsset AS GroupMasterFixedAsset,
  P_FixedAssetTransaction1.GroupFixedAsset AS GroupFixedAsset,
  P_FixedAssetTransaction1.ChartOfDepreciation AS ChartOfDepreciation,
  P_FixedAssetTransaction1.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  P_FixedAssetTransaction1.CreationTime AS CreationTime,
  P_FixedAssetTransaction1.PostingDate AS PostingDate,
  P_FixedAssetTransaction1.DocumentDate AS DocumentDate,
  P_FixedAssetTransaction1.AssetValueDate AS AssetValueDate,
  P_FixedAssetTransaction1.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  P_FixedAssetTransaction1.AssetTransactionType AS AssetTransactionType,
  P_FixedAssetTransaction1.AssetTransactionVariant AS AssetTransactionVariant,
  P_FixedAssetTransaction1.AssignmentReference AS AssignmentReference,
  P_FixedAssetTransaction1.DocumentItemText AS DocumentItemText,
  P_FixedAssetTransaction1.ReferenceDocumentType AS ReferenceDocumentType,
  P_FixedAssetTransaction1.ReferenceDocument AS ReferenceDocument,
  P_FixedAssetTransaction1.LogicalSystem AS LogicalSystem,
  P_FixedAssetTransaction1.ReferenceDocumentContext AS ReferenceDocumentContext,
  P_FixedAssetTransaction1.ReversalReferenceDocumentCntxt AS ReversalReferenceDocumentCntxt,
  P_FixedAssetTransaction1.ReversalReferenceDocument AS ReversalReferenceDocument,
  P_FixedAssetTransaction1.ReversalTransactionSubitem AS ReversalTransactionSubitem,
  P_FixedAssetTransaction1.IsReversal AS IsReversal,
  P_FixedAssetTransaction1.IsReversed AS IsReversed,
  P_FixedAssetTransaction1.BusinessArea AS BusinessArea,
  P_FixedAssetTransaction1.Segment AS Segment,
  P_FixedAssetTransaction1.FinancialAccountType AS FinancialAccountType,
  P_FixedAssetTransaction1.ControllingArea AS ControllingArea,
  _FixedAsset.InvestmentProjectWBSElement AS InvestmentProjectWBSElement,
  P_FixedAssetTransaction1.FinancialManagementArea AS FinancialManagementArea,
  P_FixedAssetTransaction1.Fund AS Fund,
  P_FixedAssetTransaction1.GrantID AS GrantID,
  P_FixedAssetTransaction1.FunctionalArea AS FunctionalArea,
  P_FixedAssetTransaction1.BudgetPeriod AS BudgetPeriod,
  P_FixedAssetTransaction1.Country AS Country,
  _FixedAssetCountryData.NationalClassification AS NationalClassification,
  _FixedAssetCountryData.TaxDepreciationGroup AS TaxDepreciationGroup,
  _FixedAssetCountryData.JP_PrptyTxRptCity AS JP_PrptyTxRptCity,
  _FixedAssetCountryData.JP_PrptyTxRptClassfctnKey AS JP_PrptyTxRptClassfctnKey,
  _GlobAssetAssignment.RU_AssetOKOF AS RU_AssetOKOF,
  _GlobAssetAssignment.RU_AssetDepreciationGroup AS RU_AssetDepreciationGroup,
  P_FixedAssetTransaction1.SelectedCurrencyBranch AS SelectedCurrencyBranch,
  P_FixedAssetTransaction1.DisplayCurrency AS DisplayCurrency,
  P_FixedAssetTransaction1.AmountInDisplayCurrency AS AmountInDisplayCurrency,
  _FixedAsset.BaseUnit AS BaseUnit,
  P_FixedAssetTransaction1.Quantity AS Quantity,
  P_FixedAssetTransaction1.IsStatisticalDocument AS IsStatisticalDocument,
  _FixedAsset.AssetClass AS AssetClass,
  _FixedAssetForLedger.AssetCapitalizationDate AS AssetCapitalizationDate,
  _FixedAsset.FixedAssetDescription AS FixedAssetDescription,
  cast(_FixedAsset.AssetAdditionalDescription as fis_txa50_more) AS AssetAdditionalDescription,
  _FixedAsset.AssetAccountDetermination AS AssetAccountDetermination,
  _FixedAsset.Inventory AS Inventory,
  cast(_FixedAssetAssgmt.CostCenter as faa_kostl) AS AssetCostCenter,
  cast(_FixedAssetAssgmt.BusinessArea as faa_gsber) AS AssetBusinessArea,
  cast(_FixedAssetAssgmt.Plant as faa_werks) AS AssetPlant,
  cast(_FixedAssetAssgmt.ProfitCenter as faa_prctr) AS AssetProfitCenter,
  cast(_FixedAssetAssgmt.Segment as faa_fb_segment) AS AssetSegment,
  _FixedAssetAssgmt.AssetLocation AS AssetLocation,
  _AssetValuationForLedger.DepreciationKey AS DepreciationKey,
  _AssetValuationForLedger.PlannedUsefulLifeInYears AS PlannedUsefulLifeInYears,
  _AssetValuationForLedger.PlannedUsefulLifeInPeriods AS PlannedUsefulLifeInPeriods,
  _AssetValuationForLedger.OriglAstUsefulLifeInYears AS OriglAstUsefulLifeInYears,
  _AssetValuationForLedger.OriglAstUsefulLifeInPerds AS OriglAstUsefulLifeInPerds,
  _AssetValuationForLedger.DepreciationStartDate AS DepreciationStartDate,
  _AssetValuationForLedger.DeprKeyChangeoverYear AS DeprKeyChangeoverYear,
  _AssetValuationForLedger.DeprKeyChangeoverPeriod AS DeprKeyChangeoverPeriod,
  _AssetValuationForLedger.VintageYear AS VintageYear,
  _AssetValuationForLedger.VintageMonth AS VintageMonth,
  _AssetValuationForLedger.ReplacementValueIndexSers AS ReplacementValueIndexSers,
  _AssetValuationForLedger.RplcmtValueAgingIndexSers AS RplcmtValueAgingIndexSers
FROM P_FixedAssetTransaction1
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_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_FiscalYearForCompanyCode AS _FiscalYear ON FiscalYear = _FiscalYear.FiscalYear AND CompanyCode = _FiscalYear.CompanyCode  -- 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_LedgerGroup AS _LedgerGroup ON LedgerGroup = _LedgerGroup.LedgerGroup  -- association [0..1]
LEFT OUTER JOIN I_ChartOfDepreciation AS _ChartOfDepreciation ON ChartOfDepreciation = _ChartOfDepreciation.ChartOfDepreciation  -- 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_CurrencyRole AS _CurrencyRole ON CurrencyRole = _CurrencyRole.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_AssetTransactionType AS _AssetTransactionType ON AssetTransactionType = _AssetTransactionType.AssetTransactionType  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON _ControllingArea.ControllingArea = ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _AssetCostCenter ON _AssetCostCenter.ControllingArea = ControllingArea AND _AssetCostCenter.CostCenter = AssetCostCenter  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenter AS _AssetProfitCenter ON _AssetProfitCenter.ControllingArea = ControllingArea AND _AssetProfitCenter.ProfitCenter = AssetProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_BusinessArea AS _AssetBusinessArea ON _AssetBusinessArea.BusinessArea = AssetBusinessArea  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _AssetPlant ON _AssetPlant.Plant = AssetPlant  -- association [0..1]
LEFT OUTER JOIN I_Segment AS _AssetSegment ON _AssetSegment.Segment = AssetSegment  -- association [0..1]
LEFT OUTER JOIN I_AssetTransactionVariant AS _AssetTransactionVariant ON _AssetTransactionVariant.AssetTransactionVariant = AssetTransactionVariant  -- 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_AssetAcctDetermination AS _AssetAccountDetermination ON assetaccountdetermination = _AssetAccountDetermination.AssetAccountDetermination  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearVariant AS _FiscalYearVariant ON FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant  -- association [1..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_Country AS _Country ON Country = _Country.Country  -- 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_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_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_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- 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_AssetClass AS _AssetClass ON assetclass = _AssetClass.AssetClass  -- 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_DepreciationKey AS _DepreciationKey ON ChartOfDepreciation = _DepreciationKey.ChartOfDepreciation AND depreciationkey = _DepreciationKey.DepreciationKey  -- association [0..1]
LEFT OUTER JOIN I_SelectedCurrencyBranch AS _SelectedCurrencyBranch ON SelectedCurrencyBranch = _SelectedCurrencyBranch.SelectedCurrencyBranch  -- association [1]
LEFT OUTER JOIN I_Currency AS _Currency ON DisplayCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON baseunit = _BaseUnit.UnitOfMeasure  -- 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_DeprAreaForLedgerText AS _DepreciationAreaText ON CompanyCode = _DepreciationAreaText.CompanyCode AND Ledger = _DepreciationAreaText.Ledger AND AssetDepreciationArea = _DepreciationAreaText.AssetDepreciationArea  -- association [0..*]
LEFT OUTER JOIN I_AssetClassText AS _AssetClassText ON assetclass = _AssetClassText.AssetClass  -- association [0..*]
LEFT OUTER JOIN I_AssetTransactionTypeText AS _AssetTransactionTypeText ON AssetTransactionType = _AssetTransactionTypeText.AssetTransactionType  -- association [0..*]
LEFT OUTER JOIN I_SubLedgerAccLineItemTypeT AS _SubLedgerAccLineItemTypeText ON SubLedgerAcctLineItemType = _SubLedgerAccLineItemTypeText.SubLedgerAcctLineItemType  -- association [0..*]
LEFT OUTER JOIN I_FixedAssetNatlClfnText AS _FixedAssetNatlClfnText ON Country = _FixedAssetNatlClfnText.Country AND nationalclassification = _FixedAssetNatlClfnText.NationalClassification  -- association [0..*]
LEFT OUTER JOIN I_LedgerText AS _LedgerText ON Ledger = _LedgerText.Ledger  -- association [0..*]
LEFT OUTER JOIN I_AssetTransactionVariantText AS _AssetTransactionVariantText ON AssetTransactionVariant = _AssetTransactionVariantText.AssetTransactionVariant  -- association [0..*]
LEFT OUTER JOIN I_TaxDepreciationGroupText AS _TaxDepreciationGroupText ON Country = _TaxDepreciationGroupText.Country AND taxdepreciationgroup = _TaxDepreciationGroupText.TaxDepreciationGroup  -- association [0..*]
LEFT OUTER JOIN I_FinancialManagementAreaText AS _FinancialManagementAreaText ON FinancialManagementArea = _FinancialManagementAreaText.FinancialManagementArea  -- association [1..*]
LEFT OUTER JOIN I_FunctionalAreaText AS _FunctionalAreaText ON FunctionalArea = _FunctionalAreaText.FunctionalArea  -- association [0..*]
LEFT OUTER JOIN I_FundText AS _FundText ON FinancialManagementArea = _FundText.FinancialManagementArea AND Fund = _FundText.Fund  -- association [0..*]
LEFT OUTER JOIN I_BudgetPeriodText AS _BudgetPeriodText ON BudgetPeriod = _BudgetPeriodText.BudgetPeriod  -- association [0..*]
LEFT OUTER JOIN I_DepreciationKeyText AS _DepreciationKeyText ON ChartOfDepreciation = _DepreciationKeyText.ChartOfDepreciation AND depreciationkey = _DepreciationKeyText.DepreciationKey  -- association [0..*]
LEFT OUTER JOIN I_BusinessAreaText AS _AssetBusinessAreaText ON _AssetBusinessAreaText.BusinessArea = AssetBusinessArea  -- association [0..*]
LEFT OUTER JOIN I_SegmentText AS _AssetSegmentText ON Segment = _AssetSegmentText.Segment  -- association [0..*]
LEFT OUTER JOIN I_AssetAcctDeterminationText AS _AssetAcctDeterminationText ON assetaccountdetermination = _AssetAcctDeterminationText.AssetAccountDetermination  -- association [0..*]
LEFT OUTER JOIN I_MovementCategoryText AS _AssetAcctTransClassfctnText ON AssetAcctTransClassfctn = _AssetAcctTransClassfctnText.AssetAcctTransClassfctn  -- association [0..*]
LEFT OUTER JOIN I_JP_PrptyTxRptCityT AS _JP_PrptyTxRptCityText ON jp_prptytxrptcity = _JP_PrptyTxRptCityText.JP_PrptyTxRptCity  -- association [0..*]
LEFT OUTER JOIN I_JP_PrptyTxRptClassfctnKeyT AS _JP_PrptyTxRptClassfctnKeyText ON jp_prptytxrptclassfctnkey = _JP_PrptyTxRptClassfctnKeyText.JP_PrptyTxRptClassfctnKey  -- association [0..*]
LEFT OUTER JOIN I_RU_AssetDepreciationGroupT AS _RU_AssetDepreciationGroupText ON ru_assetdepreciationgroup = _RU_AssetDepreciationGroupText.RU_AssetDepreciationGroup AND Country = _RU_AssetDepreciationGroupText.Country AND ru_assetokof = _RU_AssetDepreciationGroupText.RU_AssetOKOF  -- association [0..*]
LEFT OUTER JOIN I_RU_AssetOKOFText AS _RU_AssetOKOFText ON ru_assetokof = _RU_AssetOKOFText.RU_AssetOKOF AND Country = _RU_AssetOKOFText.Country  -- association [0..*]
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]
;