C_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 C_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.
-- Parameters: P_Language : sylangu, P_KeyDate : fagl_keydate, P_BusinessUser : syuname, P_AssetAccountingKeyFigureSet : faa_key_figure_set, P_CompanyCode : fis_bukrs, P_Ledger : fis_rldnr, P_AssetDepreciationArea : fis_afabe, P_FiscalYear : fis_ryear, P_FiscalPeriod : fis_period_to, P_CurrencyRole : fins_curtp, P_FiscalPeriodEndDate : fagl_keydate, P_SelectedCurrencyBranch : fis_curtp

CREATE VIEW C_AssetHistorySheet AS
SELECT
  resultElement: 'CompanyCode' AS resultElementCompanyCode,
  resultElement: 'Ledger' AS resultElementLedger,
  resultElement: 'AssetDepreciationArea' AS resultElementAssetDepreciationArea,
  resultElement: 'FiscalYear' AS resultElementFiscalYear,
  resultElement: 'FiscalPeriod' AS resultElementFiscalPeriod,
  resultElement: 'CompanyCodeCurrencyRole' AS resultElementCompanyCodeCurrencyRole,
  resultElement: 'FiscalPeriodEndDate' AS resultElementFiscalPeriodEndDate,
  resultElement: 'SelectedCurrencyBranch' AS resultElementSelectedCurrencyBranch,
  cast ( AssetHistory.AmountInDisplayCurrency as fis_balance_amount) AS AmountInDisplayCurrency,
  AssetDepreciationArea,
  cast(AssetHistory.GroupMasterFixedAsset as fis_anlgr) AS GroupMasterFixedAsset,
  cast(AssetHistory.GroupFixedAsset as fis_anlgr2) AS GroupFixedAsset,
  InvestmentSupportMeasure,
  DepreciationStartDate,
  SpecialDeprStartDate,
  DepreciationKey,
  PlannedUsefulLifeInYears,
  PlannedUsefulLifeInPeriods,
  Country,
  NationalClassification,
  TaxDepreciationGroup,
  AccountingDocument,
  Room,
  VehicleLicensePlateNumber,
  TaxJurisdiction,
  WBSElementExternalID,
  RU_AssetOKOF,
  RU_AssetDepreciationGroup,
  JP_PrptyTxRptCity,
  JP_PrptyTxRptClassfctnKey,
  AssetAdditionalDescription,
  AssetHistory.AssetClass AS AssetClass,
  AssetHistory.AssetAccountingSortedKeyFigure AS AssetAccountingKeyFigure,
  AssetHistory.DisplayCurrency AS DisplayCurrency,
  AssetHistory.BaseUnit AS BaseUnit,
  AssetHistory.Quantity AS Quantity,
  AssetHistory.AcqnProdnCostGLAccount AS AcqnProdnCostGLAccount,
  AssetHistory.ChartOfAccounts AS ChartOfAccounts,
  AssetHistory.CompanyCode AS CompanyCode,
  AssetHistory.LedgerGroup AS LedgerGroup,
  AssetHistory.Ledger AS Ledger,
  AssetHistory.ChartOfDepreciation AS ChartOfDepreciation,
  AssetHistory.FiscalYear AS FiscalYear,
  AssetHistory.FiscalPeriod AS FiscalPeriod,
  AssetHistory.FinancialStatementVariant AS FinancialStatementVariant,
  AssetHistory.ControllingArea AS ControllingArea,
  AssetHistory.CostCenter AS CostCenter,
  AssetHistory.ProfitCenter AS ProfitCenter,
  AssetHistory.Segment AS Segment,
  AssetHistory.FundsCenter AS FundsCenter,
  AssetHistory.BusinessArea AS BusinessArea,
  AssetHistory.MasterFixedAsset AS MasterFixedAsset,
  AssetHistory.FixedAsset AS FixedAsset,
  AssetHistory.PersonnelNumber AS PersonnelNumber,
  AssetHistory.AssetPersonnelNumber AS AssetPersonnelNumber,
  AssetHistory.FinancialManagementArea AS FinancialManagementArea,
  AssetHistory.Fund AS Fund,
  AssetHistory.GrantID AS GrantID,
  AssetHistory.FunctionalArea AS FunctionalArea,
  AssetHistory.BudgetPeriod AS BudgetPeriod,
  AssetHistory.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  AssetHistory.AssetTransactionType AS AssetTransactionType,
  AssetHistory.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  AssetHistory.FinancialAccountType AS FinancialAccountType,
  AssetHistory.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  AssetHistory.CreationTime AS CreationTime,
  AssetHistory.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  AssetHistory.AccountingPrinciple AS AccountingPrinciple,
  AssetHistory.FiscalYearVariant AS FiscalYearVariant,
  AssetHistory.CountryChartOfAccounts AS CountryChartOfAccounts,
  AssetHistory.GLAccount AS GLAccount,
  AssetHistory.AlternativeGLAccount AS AlternativeGLAccount,
  AssetHistory.AssetBusinessArea AS AssetBusinessArea,
  AssetHistory.AssetPlant AS AssetPlant,
  AssetHistory.AssetCostCenter AS AssetCostCenter,
  AssetHistory.AssetProfitCenter AS AssetProfitCenter,
  AssetHistory.AssetSegment AS AssetSegment,
  AssetHistory.AssetFunctionalArea AS AssetFunctionalArea,
  AssetHistory.AssetBudgetPeriod AS AssetBudgetPeriod,
  AssetHistory.AssetGrant AS AssetGrant,
  AssetHistory.AssetFund AS AssetFund,
  AssetHistory.AssetLocation AS AssetLocation,
  AssetHistory.REInternalFinNumber AS REInternalFinNumber,
  AssetHistory.RealEstateObject AS RealEstateObject,
  AssetHistory.AssetFundsCenter AS AssetFundsCenter,
  AssetHistory.AssetCostCtrActivityType AS AssetCostCtrActivityType,
  AssetHistory.FirstAcquisitionFiscalYear AS FirstAcquisitionFiscalYear,
  AssetHistory.FirstAcquisitionFiscalPeriod AS FirstAcquisitionFiscalPeriod,
  AssetHistory.AssetCapitalizationDate AS AssetCapitalizationDate,
  AssetHistory.AssetDeactivationDate AS AssetDeactivationDate,
  AssetHistory.FixedAssetGroup AS FixedAssetGroup,
  AssetHistory.Supplier AS Supplier,
  AssetHistory.AssetSupplierName AS AssetSupplierName,
  AssetHistory.InvestmentOrder AS InvestmentOrder,
  AssetHistory.InventoryIsCounted AS InventoryIsCounted,
  AssetHistory.LastInventoryDate AS LastInventoryDate,
  AssetHistory.Inventory AS Inventory,
  AssetHistory.Group1AssetEvaluationKey AS Group1AssetEvaluationKey,
  AssetHistory.Group2AssetEvaluationKey AS Group2AssetEvaluationKey,
  AssetHistory.Group3AssetEvaluationKey AS Group3AssetEvaluationKey,
  AssetHistory.Group4AssetEvaluationKey AS Group4AssetEvaluationKey,
  AssetHistory.Group5AssetEvaluationKey AS Group5AssetEvaluationKey,
  AssetHistory.AssetSerialNumber AS AssetSerialNumber
FROM I_AssetHistorySheetCube
;