C_RO_SAFTFixedAssetTransCube

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_RO_SAFTFixedAssetTransCube.
-- 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: CROSAFTFATRANCUB
-- Parameters: P_AssetAccountingKeyFigureSet : faa_key_figure_set, P_FiscalYear : fis_gjahr, P_ToFiscalPeriod : fis_period_to, P_KeyDate : fagl_keydate, P_SelectedCurrencyBranch : saft_aa_ro_curr_branch

CREATE VIEW C_RO_SAFTFixedAssetTransCube AS
SELECT
  Values.CompanyCode AS CompanyCode,
  Values.AssetDepreciationArea AS AssetDepreciationArea,
  Values.MasterFixedAsset AS MasterFixedAsset,
  Values.FixedAsset AS FixedAsset,
  Values.Ledger AS Ledger,
  Values.FiscalYear AS FiscalYear,
  Values.FiscalPeriod AS FiscalPeriod,
  Values.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  Values.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  Values.AssetAccountingKeyFigure AS AssetAccountingKeyFigure,
  Values.AssetAccountingKeyFigureSet AS AssetAccountingKeyFigureSet,
  Values.AccountingDocument AS AccountingDocument,
  Values.TransactionSubitem AS TransactionSubitem,
  Values.DebitCreditCode AS DebitCreditCode,
  Values._FixedAsset.AssetClass AS AssetClass,
  Values.ChartOfDepreciation AS ChartOfDepreciation,
  Values.ControllingArea AS ControllingArea,
  Values.LedgerGroup AS LedgerGroup,
  Values.GroupMasterFixedAsset AS GroupMasterFixedAsset,
  Values.GroupFixedAsset AS GroupFixedAsset,
  AccountingDocumentType,
  Values.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  Values.CreationTime AS CreationTime,
  Values.PostingDate AS PostingDate,
  Values.DocumentDate AS DocumentDate,
  Values.AssetValueDate AS AssetValueDate,
  Values.AssetTransactionType AS AssetTransactionType,
  Values.AssignmentReference AS AssignmentReference,
  Values.DocumentItemText AS DocumentItemText,
  Values.ReferenceDocumentType AS ReferenceDocumentType,
  Values.ReferenceDocument AS ReferenceDocument,
  Values.LogicalSystem AS LogicalSystem,
  Values.ReferenceDocumentContext AS ReferenceDocumentContext,
  Values.IsReversal AS IsReversal,
  Values.IsReversed AS IsReversed,
  Values.BusinessArea AS BusinessArea,
  Values.Segment AS Segment,
  Values.FinancialAccountType AS FinancialAccountType,
  Values.Fund AS Fund,
  Values.FunctionalArea AS FunctionalArea,
  AcctgDocIsPostedPeriodically,
  Values.DisplayCurrency AS DisplayCurrency,
  Values.AmountInDisplayCurrency AS AmountInDisplayCurrency,
  AcqnProdnCostOnTransIsReset,
  cast('' as vdm_v_company_code_currency) AS CompanyCodeCurrency,
  cast('0' as fis_hsl) AS AmountInCompanyCodeCurrency
FROM I_AssetBalanceCube
;