I_CN_CADEFixedAssetValueCube

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_CN_CADEFixedAssetValueCube.
-- 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: ICADEASTCUBE
-- Parameters: P_CurrencyRole : fis_curtp, P_FiscalYear : fis_gjahr, P_FromFiscalPeriod : fis_period_from, P_ToFiscalPeriod : fis_period_to, P_CompanyCode : fis_bukrs, P_AssetDepreciationArea : fis_afabe, P_AssetAccountingKeyFigureSet : faa_key_figure_set, P_Ledger : fis_rldnr, P_Language : sylangu, P_KeyDate : fagl_keydate

CREATE VIEW I_CN_CADEFixedAssetValueCube AS
SELECT
  FixedAssetValue.CompanyCode AS CompanyCode,
  FixedAssetValue.AssetDepreciationArea AS AssetDepreciationArea,
  FixedAsset.MasterFixedAsset AS MasterFixedAsset,
  FixedAsset.FixedAsset AS FixedAsset,
  FixedAssetValue.Ledger AS Ledger,
  FixedAssetValue.FiscalYear AS FiscalYear,
  ltrim(Period.FiscalPeriod,'0') AS FiscalPeriod,
  FixedAssetValue.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  FixedAssetValue.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  FixedAssetValue.AssetAccountingKeyFigure AS AssetAccountingKeyFigure,
  FixedAssetValue.AssetAccountingKeyFigureSet AS AssetAccountingKeyFigureSet,
  Period.FiscalYearPeriod AS FiscalYearPeriod,
  Period.FiscalPeriod AS PostingFiscalPeriod,
  FixedAssetValue.AssetAccountDetermination AS AssetAccountDetermination,
  FixedAssetValue.ChartOfAccounts AS ChartOfAccounts,
  ChartOfDepreciation,
  AssetAccountingSortedKeyFigure,
  FixedAssetValue._Currency._Text[1:Language = $parameters.P_Language].CurrencyShortName AS CurrencyShortName,
  FixedAssetValue._AssetClass._Text[1:Language = $parameters.P_Language].AssetClassName AS AssetClassName,
  DisplayCurrency,
  AmountInDisplayCurrency,
  ltrim(AcqnProdnCostGLAccount,'0') AS AcqnProdnCostGLAccount,
  ltrim( OrdinaryDeprValAdjmtAccount.OrdinaryDeprValAdjmtGLAccount,'0') AS OrdinaryDeprValAdjmtGLAccount,
  ltrim( RevalOrdnryDeprValAdjmtAccount.RevalOrdnryDeprValAdjmtGLAcct,'0') AS RevalOrdnryDeprValAdjmtGLAcct,
  FixedAssetValue.AssetClass AS AssetClass,
  FixedAsset._FixedAsset.FixedAssetDescription AS FixedAssetDescription
FROM I_FiscalYearPeriodForLedger AS Period
INNER JOIN I_FixedAssetForLedger AS FixedAsset ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AssetBalanceCube ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FixedAssetAssgmt AS AssignmentByFiscalPeriodEnd ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AssetValuationForLedger AS DeprAreaByFiscalPeriodEnd ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_CN_CADECalcExpiredPeriods ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OrdinaryDeprValAdjmtAccount AS OrdinaryDeprValAdjmtAccount ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_RevalOrdnryDeprValAdjmtAcct AS RevalOrdnryDeprValAdjmtAccount ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CN_CADEGeneralInformation AS AdecConfiguration ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_CN_CADEAssetChgDoc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_CN_CADEAssetQuantity ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_GlobAssetAssignment AS AssetUsageNew ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AssetKeyFigureText AS _AssetKeyFigureText ON AssetAccountingKeyFigure = _AssetKeyFigureText.AssetAccountingKeyFigure  -- association [0..*]
;