I_AssetBalancesYOYComprnCube

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_AssetBalancesYOYComprnCube.
-- 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_ryear, P_PreviousFiscalYear : fis_ryear, P_FiscalPeriod : fis_period_to, P_FiscalYearEndDate : fagl_keydate, P_FiscalPeriodEndDate : fagl_keydate, P_Ledger : fis_rldnr, P_AssetDepreciationArea : fis_afabe

CREATE VIEW I_AssetBalancesYOYComprnCube AS
SELECT
  AssetBal.CompanyCode AS CompanyCode,
  AssetBal.AssetDepreciationArea AS AssetDepreciationArea,
  AssetBal.MasterFixedAsset AS MasterFixedAsset,
  AssetBal.FixedAsset AS FixedAsset,
  AssetBal.Ledger AS Ledger,
  AssetBal.FiscalYear AS FiscalYear,
  AssetBal.FiscalPeriod AS FiscalPeriod,
  AssetBal.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  AssetBal.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  AssetBal.AssetAccountingKeyFigure AS AssetAccountingKeyFigure,
  AssetBal.AssetAccountingKeyFigureSet AS AssetAccountingKeyFigureSet,
  AssetBal.AccountingDocument AS AccountingDocument,
  AssetBal.LedgerGLLineItem AS LedgerGLLineItem,
  AssetBal.TransactionSubitem AS TransactionSubitem,
  AssetBal.DebitCreditCode AS DebitCreditCode,
  AssetBal.CurrencyRole AS CurrencyRole,
  AssetBal.AssetAccountDetermination AS AssetAccountDetermination,
  AssetBal.AssetClass AS AssetClass,
  AssetBal.AssetAccountingSortedKeyFigure AS AssetAccountingSortedKeyFigure,
  AssetBal.Quantity AS Quantity,
  AssetBal.AcqnProdnCostGLAccount AS AcqnProdnCostGLAccount,
  AssetBal.ChartOfAccounts AS ChartOfAccounts,
  AssetBal.AssetPlant AS AssetPlant,
  AssetBal.CostCenter AS CostCenter,
  AssetBal.ProfitCenter AS ProfitCenter,
  AssetBal.Segment AS Segment,
  AssetBal.FundsCenter AS FundsCenter,
  AssetBal.FunctionalArea AS FunctionalArea,
  AssetBal.AssetTransactionType AS AssetTransactionType,
  AssetBal.BusinessTransactionCategory AS BusinessTransactionCategory,
  AssetBal.BusinessTransactionType AS BusinessTransactionType,
  AssetBal.FinancialClosingStep AS FinancialClosingStep,
  AssetBal.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  AssetBal.PostingDate AS PostingDate,
  AssetBal.CreationTime AS CreationTime,
  AssetBal.FiscalYearVariant AS FiscalYearVariant,
  AssetBal.GLAccount AS GLAccount,
  AssetBal.AlternativeGLAccount AS AlternativeGLAccount,
  AssetBal.AssetCostCenter AS AssetCostCenter,
  AssetBal.AssetWBSElementExternalID AS AssetWBSElementExternalID,
  AssetBal.AssetProfitCenter AS AssetProfitCenter,
  AssetBal.AssetSegment AS AssetSegment,
  AssetBal.AssetFunctionalArea AS AssetFunctionalArea,
  AssetBal.GrantID AS GrantID,
  AssetBal.AssetGrant AS AssetGrant,
  AssetBal.Fund AS Fund,
  AssetBal.AssetFund AS AssetFund,
  AssetBal.AssetLocation AS AssetLocation,
  AssetBal.AssetFundsCenter AS AssetFundsCenter,
  AssetBal.FirstAcquisitionFiscalYear AS FirstAcquisitionFiscalYear,
  AssetBal.FirstAcquisitionFiscalPeriod AS FirstAcquisitionFiscalPeriod,
  AssetBal.AssetCapitalizationDate AS AssetCapitalizationDate,
  AssetBal.AssetDeactivationDate AS AssetDeactivationDate,
  AssetBal.Supplier AS Supplier,
  AssetBal.AssetSupplierName AS AssetSupplierName,
  AssetBal.LastInventoryDate AS LastInventoryDate,
  AssetBal.Inventory AS Inventory,
  AssetBal.AssetSerialNumber AS AssetSerialNumber,
  AssetBal.DepreciationStartDate AS DepreciationStartDate,
  AssetBal.SpecialDeprStartDate AS SpecialDeprStartDate,
  AssetBal.DepreciationKey AS DepreciationKey,
  AssetBal.PlannedUsefulLifeInYears AS PlannedUsefulLifeInYears,
  AssetBal.PlannedUsefulLifeInPeriods AS PlannedUsefulLifeInPeriods,
  AssetBal.FixedAssetUsageObject AS FixedAssetUsageObject,
  AssetBal.AssetRevaluationIndex AS AssetRevaluationIndex,
  AssetBal.Country AS Country,
  AssetBal.Room AS Room,
  AssetBal.VehicleLicensePlateNumber AS VehicleLicensePlateNumber,
  AssetBal.TaxJurisdiction AS TaxJurisdiction,
  AssetBal.WBSElementExternalID AS WBSElementExternalID,
  AssetBal.SelectedCurrencyBranch AS SelectedCurrencyBranch,
  AssetBal.AmountInDisplayCurrency AS AmountInDisplayCurrency,
  AssetBal.CurrentFiscalYearBalanceAmount AS CurrentFiscalYearBalanceAmount,
  AssetBal.PriorFiscalYearBalanceAmount AS PriorFiscalYearBalanceAmount,
  cast ( AssetBal.CurrentFiscalYearBalanceAmount - AssetBal.PriorFiscalYearBalanceAmount as fis_balance_amount ) AS ComparisonDifferenceAmt,
  AssetBal.DisplayCurrency AS DisplayCurrency,
  AssetBal.BaseUnit AS BaseUnit
FROM P_AssetBalancesYrOvrYrComprn
LEFT OUTER JOIN I_AstBalancesYOYComprnDSt AS _DocumentStore ON _DocumentStore.tra_companycode = CompanyCode AND _DocumentStore.tra_00034 = AssetDepreciationArea AND _DocumentStore.tra_p_fiscalyear = FiscalYear AND _DocumentStore.tra_fiscalperiod = FiscalPeriod AND _DocumentStore.tra_00015 = AssetAccountingKeyFigureSet AND _DocumentStore.tra_00021 = AssetAccountingKeyFigure AND _DocumentStore.tra_00037 = AccountingDocument AND _DocumentStore.tra_00042 = MasterFixedAsset AND _DocumentStore.tra_fixedasset = FixedAsset AND _DocumentStore.tra_00043 = SubLedgerAcctLineItemType AND _DocumentStore.tra_00039 = AssetAcctTransClassfctn AND _DocumentStore.tra_00027 = LedgerGLLineItem AND _DocumentStore.tra_00009 = TransactionSubitem AND _DocumentStore.tra_ledger = Ledger AND _DocumentStore.tra_00032 = DebitCreditCode AND _DocumentStore.tra_currencyrole = CurrencyRole  -- association [0..1]
;