C_PL_SAFTFixedAssetValueCube

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_PL_SAFTFixedAssetValueCube.
-- 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_gjahr, P_ToFiscalPeriod : fis_period_to, P_ReportingEndDate : srf_rpg_period_end_date, P_SelectedCurrencyBranch : fis_selected_currency_branch, P_BookDepreciationAreaLedger : saft_aa_pl_book_area_ledger, P_ConfigurationKeyDate : fipl_sa_confign_key_date

CREATE VIEW C_PL_SAFTFixedAssetValueCube AS
SELECT
  AstBal.CompanyCode AS CompanyCode,
  AstBal.MasterFixedAsset AS MasterFixedAsset,
  AstBal.FixedAsset AS FixedAsset,
  AstBal.AssetDepreciationArea AS AssetDepreciationArea,
  AstBal.Ledger AS Ledger,
  AstBal.FiscalYear AS FiscalYear,
  AstBal.FiscalPeriod AS FiscalPeriod,
  AstBal.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  AstBal.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  AstBal.AssetAccountingKeyFigure AS AssetAccountingKeyFigure,
  AstBal.AssetAccountingKeyFigureSet AS AssetAccountingKeyFigureSet,
  AstBal.AccountingDocument AS AccountingDocument,
  AstBal.TransactionSubitem AS TransactionSubitem,
  AstBal.DebitCreditCode AS DebitCreditCode,
  AstBal.AccountingDocumentType AS AccountingDocumentType,
  AstBal.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  AstBal.AssetTransactionType AS AssetTransactionType,
  AstBal.AssetValueDate AS AssetValueDate,
  AstBal.AssetClass AS AssetClass,
  AstBal.BusinessTransactionCategory AS BusinessTransactionCategory,
  AstBal.BusinessTransactionType AS BusinessTransactionType,
  AstBal.ChartOfDepreciation AS ChartOfDepreciation,
  AstBal.DisplayCurrency AS DisplayCurrency,
  AstBal.PostingDate AS PostingDate,
  AstBal.DocumentDate AS DocumentDate,
  AstBal.SelectedCurrencyBranch AS SelectedCurrencyBranch,
  AstBal.IsReversal AS IsReversal,
  AstBal.IsReversed AS IsReversed,
  FxdAstLed.AssetCapitalizationDate AS AssetCapitalizationDate,
  FxdAstLed.AssetDeactivationDate AS AssetDeactivationDate,
  AstBal._AssetAcctTransClassfctn AS _AssetAcctTransClassfctn,
  AstBal._AssetKeyFigure AS _AssetKeyFigure,
  AstBal._AssetKeyFigureSet AS _AssetKeyFigureSet,
  AstBal._AssetClass AS _AssetClass,
  AstBal._AssetTransactionType AS _AssetTransactionType,
  AstBal._AccountingDocumentType AS _AccountingDocumentType,
  AstBal._BusinessTransactionCategory AS _BusinessTransactionCategory,
  AstBal._BusinessTransactionType AS _BusinessTransactionType,
  AstBal._CompanyCode AS _CompanyCode,
  AstBal._ChartOfDepreciation AS _ChartOfDepreciation,
  AstBal._DepreciationArea AS _DepreciationArea,
  AstBal._FixedAsset AS _FixedAsset,
  AstBal._FiscalYear AS _FiscalYear,
  AstBal._JournalEntry AS _JournalEntry,
  AstBal._MasterFixedAsset AS _MasterFixedAsset,
  AstBal._Ledger AS _Ledger,
  AstBal._SelectedCurrencyBranch AS _SelectedCurrencyBranch
FROM I_AssetBalanceCube
INNER JOIN I_PL_SAFTAssetDepreciationArea AS AstDprA ON /* join condition not captured in parsed metadata */
INNER JOIN I_FixedAssetForLedger AS FxdAstLed ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SubLedgerAccLineItemType AS _SubledgerAccLineItemType ON SubLedgerAcctLineItemType = _SubledgerAccLineItemType.SubLedgerAcctLineItemType  -- association [0..1]
;