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: 'FiscalYear' AS resultElementFiscalYear,
  resultElement: 'FiscalPeriod' AS resultElementFiscalPeriod,
  resultElement: 'CompanyCodeCurrencyRole' AS resultElementCompanyCodeCurrencyRole,
  resultElement: 'FiscalPeriodEndDate' AS resultElementFiscalPeriodEndDate,
  resultElement: 'SelectedCurrencyBranch' AS resultElementSelectedCurrencyBranch,
  AssetHistory.AssetClass AS AssetClass,
  AssetHistory.AssetAccountingSortedKeyFigure AS AssetAccountingKeyFigure,
  AssetHistory.DisplayCurrency AS DisplayCurrency,
  cast( AssetHistory.AmountInDisplayCurrency as fis_balance_amount) AS AmountInDisplayCurrency,
  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.AssetDepreciationArea AS AssetDepreciationArea,
  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.AssetWBSElementExternalID AS AssetWBSElementExternalID,
  AssetHistory.ProfitCenter AS ProfitCenter,
  AssetHistory.Segment AS Segment,
  AssetHistory.FundsCenter AS FundsCenter,
  AssetHistory.BusinessArea AS BusinessArea,
  AssetHistory.MasterFixedAsset AS MasterFixedAsset,
  AssetHistory.FixedAsset AS FixedAsset,
  cast( AssetHistory.GroupMasterFixedAsset as fis_anlgr ) AS GroupMasterFixedAsset,
  cast( AssetHistory.GroupFixedAsset as fis_anlgr2 ) AS GroupFixedAsset,
  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.BusinessTransactionCategory AS BusinessTransactionCategory,
  AssetHistory.BusinessTransactionType AS BusinessTransactionType,
  AssetHistory.FinancialClosingStep AS FinancialClosingStep,
  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.PartnerCompanyCode AS PartnerCompanyCode,
  AssetHistory.PartnerMasterFixedAsset AS PartnerMasterFixedAsset,
  AssetHistory.PartnerFixedAsset AS PartnerFixedAsset,
  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,
  AssetHistory.InvestmentSupportMeasure AS InvestmentSupportMeasure,
  AssetHistory.DepreciationStartDate AS DepreciationStartDate,
  AssetHistory.SpecialDeprStartDate AS SpecialDeprStartDate,
  AssetHistory.DepreciationKey AS DepreciationKey,
  AssetHistory.PlannedUsefulLifeInYears AS PlannedUsefulLifeInYears,
  AssetHistory.PlannedUsefulLifeInPeriods AS PlannedUsefulLifeInPeriods,
  AssetHistory.FixedAssetUsageObject AS FixedAssetUsageObject,
  AssetHistory.AssetRevaluationIndex AS AssetRevaluationIndex,
  AssetHistory.Country AS Country,
  AssetHistory.NationalClassification AS NationalClassification,
  AssetHistory.TaxDepreciationGroup AS TaxDepreciationGroup,
  AssetHistory.AccountingDocument AS AccountingDocument,
  AssetHistory.Room AS Room,
  AssetHistory.VehicleLicensePlateNumber AS VehicleLicensePlateNumber,
  AssetHistory.TaxJurisdiction AS TaxJurisdiction,
  AssetHistory.WBSElementExternalID AS WBSElementExternalID,
  AssetHistory.RU_AssetOKOF AS RU_AssetOKOF,
  AssetHistory.RU_AssetDepreciationGroup AS RU_AssetDepreciationGroup,
  AssetHistory.JP_PrptyTxRptCity AS JP_PrptyTxRptCity,
  AssetHistory.JP_PrptyTxRptClassfctnKey AS JP_PrptyTxRptClassfctnKey,
  AssetHistory.AssetAdditionalDescription AS AssetAdditionalDescription
FROM I_AssetHistorySheetCube
;