P_AUDIT_AT_AssetHistorySheet

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 P_AUDIT_AT_AssetHistorySheet.
-- 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: PAUDITATAHS
-- Parameters: P_AssetAccountingKeyFigureSet : faa_key_figure_set, P_CompanyCode : fis_bukrs, P_Ledger : fis_rldnr, P_AssetDepreciationArea : fis_afabe, P_FiscalYear : fis_gjahr, P_FiscalPeriod : fis_period_to, P_FiscalPeriodEndDate : fagl_keydate, P_SelectedCurrencyBranch : fis_curtp

CREATE VIEW P_AUDIT_AT_AssetHistorySheet AS
SELECT
  Values.CompanyCode AS CompanyCode,
  Values.AssetDepreciationArea AS AssetDepreciationArea,
  Values.MasterFixedAsset AS MasterFixedAsset,
  Values.FixedAsset AS FixedAsset,
  Values.Ledger AS Ledger,
  Values.FiscalYear AS FiscalYear,
  Values.AssetAccountingKeyFigureSet AS AssetAccountingKeyFigureSet,
  Values.CurrencyRole AS CurrencyRole,
  Values.AssetAuthorizationContext AS AssetAuthorizationContext,
  Values.AssetClass AS AssetClass,
  Values._AssetClass._Text[1: Language = $session.system_language].AssetClassName AS AssetClassName,
  Values._AssetClass._Text[1: Language = $session.system_language].AssetClassDescription AS AssetClassDescription,
  Values._MasterFixedAsset.MasterFixedAssetDescription AS MasterFixedAssetDescription,
  FixedAsset.FixedAssetDescription AS FixedAssetDescription,
  FixedAsset.AssetAdditionalDescription AS AssetAdditionalDescription,
  FixedAsset.Supplier AS Supplier,
  FixedAsset.AssetCountryOfOrigin AS AssetCountryofOrigin,
  FixedAsset.AssetStatusAtPurchase AS AssetStatusAtPurchase,
  FixedAsset.MasterFixedAssetSearchTerm AS MasterFixedAssetSearchTerm,
  FixedAsset.InvestmentOrder AS InvestmentOrder,
  FixedAsset.PartnerCompany AS PartnerCompany,
  FixedAsset.InvestmentReason AS InvestmentReason,
  FixedAsset.AssetUnderConstIsInvmtMsr AS AssetUnderConstIsInvmtMsr,
  FixedAssetForLedger.AcquisitionValueDate AS AcquisitionValueDate,
  FixedAssetForLedger.AssetCapitalizationDate AS AssetCapitalizationDate,
  FixedAssetForLedger.AssetCapitalizationDate AS AssetDeactivationDate,
  AssetValuationForLedger.LastRetirementValueDate AS LastRetirementValueDate,
  AssetValuationForLedger.DepreciationStartDate AS DepreciationStartDate,
  AssetValuationForLedger.PlannedUsefulLifeInYears AS PlannedUsefulLifeInYears,
  AssetValuationForLedger.PlannedUsefulLifeInPeriods AS PlannedUsefulLifeInPeriods,
  AssetValuationForLedger.DeprKeyChangeoverYear AS DeprKeyChangeoverYear,
  FixedAssetAssgmt.BusinessArea AS AssetBusinessArea,
  FixedAssetAssgmt.CostCenter AS AssetCostCenter,
  FixedAssetAssgmt.ControllingArea AS ControllingArea,
  Values.AssetAccountDetermination AS AssetAccountDetermination,
  Values.ChartOfAccounts AS ChartOfAccounts,
  Values.AcqnProdnCostGLAccount AS AcqnProdnCostGLAccount,
  _AcqnProdnCostGLAccount._Text[1: Language = $session.system_language].GLAccountName AS APCGLAccountDescription,
  Values.SelectedCurrencyBranch AS SelectedCurrencyBranch,
  Values.DisplayCurrency AS DisplayCurrency,
  Values.AmountInDisplayCurrency1 AS AmountInDisplayCurrency1,
  Values.AmountInDisplayCurrency2 AS AmountInDisplayCurrency2,
  Values.AmountInDisplayCurrency3 AS AmountInDisplayCurrency3,
  Values.AmountInDisplayCurrency4 AS AmountInDisplayCurrency4,
  Values.AmountInDisplayCurrency5 AS AmountInDisplayCurrency5,
  Values.AmountInDisplayCurrency6 AS AmountInDisplayCurrency6,
  Values.AmountInDisplayCurrency7 AS AmountInDisplayCurrency7,
  Values.AmountInDisplayCurrency8 AS AmountInDisplayCurrency8,
  Values.AmountInDisplayCurrency9 AS AmountInDisplayCurrency9,
  Values.AmountInDisplayCurrency10 AS AmountInDisplayCurrency10,
  Values.AmountInDisplayCurrency11 AS AmountInDisplayCurrency11,
  Values.AmountInDisplayCurrency12 AS AmountInDisplayCurrency12,
  Values.AmountInDisplayCurrency13 AS AmountInDisplayCurrency13,
  Values.AmountInDisplayCurrency14 AS AmountInDisplayCurrency14,
  Values.AmountInDisplayCurrency15 AS AmountInDisplayCurrency15,
  Values.AmountInDisplayCurrency16 AS AmountInDisplayCurrency16,
  Values.AmountInDisplayCurrency17 AS AmountInDisplayCurrency17,
  Values.AmountInDisplayCurrency18 AS AmountInDisplayCurrency18,
  Values.AmountInDisplayCurrency19 AS AmountInDisplayCurrency19,
  Values._CompanyCode AS _CompanyCode,
  Values._DepreciationArea AS _DepreciationArea,
  Values._MasterFixedAsset AS _MasterFixedAsset,
  Values._FixedAsset AS _FixedAsset,
  Values._Ledger AS _Ledger,
  Values._FiscalYear AS _FiscalYear,
  Values._AssetKeyFigureSet AS _AssetKeyFigureSet,
  Values._ChartOfAccounts AS _ChartOfAccounts,
  Values._AcqnProdnCostGLAccount AS _AcqnProdnCostGLAccount,
  Values._AssetClass AS _AssetClass,
  Values._AssetAccountDetermination AS _AssetAccountDetermination,
  FixedAsset._AssetCountryOfOrigin AS _AssetCountryOfOrigin,
  FixedAsset._AssetStatusAtPurchase AS _AssetStatusAtPurchase,
  FixedAsset._InvestmentOrder AS _InvestmentOrder,
  FixedAsset._PartnerCompany AS _PartnerCompany,
  FixedAsset._InvestmentReason AS _InvestmentReason,
  FixedAssetAssgmt._BusinessArea AS _BusinessArea,
  FixedAssetAssgmt._CostCenter AS _CostCenter,
  FixedAssetAssgmt._ControllingArea AS _ControllingArea,
  Values._SelectedCurrencyBranch AS _SelectedCurrencyBranch,
  Values._CurrencyRole AS _CurrencyRole
FROM P_AUDIT_AT_AstHistShtToKeyFigs
LEFT OUTER JOIN I_FixedAsset AS FixedAsset ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FixedAssetAssgmt AS FixedAssetAssgmt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FixedAssetForLedger AS FixedAssetForLedger ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MasterFixedAsset AS MasterFixedAsset ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AssetValuationForLedger AS AssetValuationForLedger ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
;