C_RO_SAFTFixedAssetCube

DDL: C_RO_SAFTFIXEDASSETCUBE SQL: CROSAFTFASSETCUB Type: view CONSUMPTION
39 Fields 2 Data Sources

RO SAFT Fixed Asset - Cube

C_RO_SAFTFixedAssetCube is a Consumption CDS View (Cube) that provides data about "RO SAFT Fixed Asset - Cube" in SAP S/4HANA. It reads from 2 data sources (I_AssetBalanceCube, P_RO_SAFTFixedAsset) and exposes 39 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset, AssetDepreciationArea, Ledger.

Data Sources (2)

SourceAliasJoin Type
I_AssetBalanceCube I_AssetBalanceCube inner
P_RO_SAFTFixedAsset P_RO_SAFTFixedAsset from

Parameters (8)

NameTypeDefault
P_AssetAccountingKeyFigureSet faa_key_figure_set
P_FiscalYear fis_gjahr
P_ToFiscalPeriod fis_period_to
P_KeyDate fagl_keydate
P_ReportingStartDate srf_rpg_period_start_date
P_AstLeadingDepreciationArea saft_aa_ro_depr_area
P_AstLdngDeprAreaLedger saft_aa_ro_depr_area_ledger
P_SelectedCurrencyBranch saft_aa_ro_curr_branch

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CROSAFTFASSETCUB view
VDM.viewType #CONSUMPTION view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality D view
ObjectModel.usageType.dataClass TRANSACTIONAL view
AccessControl.authorizationCheck #MANDATORY view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
EndUserText.label RO SAFT Fixed Asset - Cube view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode AstBal CompanyCode Receiver Company Code
KEY MasterFixedAsset AstBal MasterFixedAsset Fixed Asset
KEY FixedAsset AstBal FixedAsset Sub-number
KEY AssetDepreciationArea AstBal AssetDepreciationArea Deprec. Area
KEY Ledger AstBal Ledger Ledger
KEY FiscalYear AstBal FiscalYear G/L Fiscal Year
KEY FiscalPeriod AstBal FiscalPeriod Tax period
KEY SubLedgerAcctLineItemType AstBal SubLedgerAcctLineItemType SLALineItemType
KEY AssetAcctTransClassfctn AstBal AssetAcctTransClassfctn Trans.Type Cat.
KEY AssetAccountingKeyFigure AstBal AssetAccountingKeyFigure
KEY AssetAccountingKeyFigureSet AstBal AssetAccountingKeyFigureSet
KEY AccountingDocument AstBal AccountingDocument Journal Entry
ChartOfDepreciation AstBal ChartOfDepreciation
AcqnProdnCostGLAccount AstBal AcqnProdnCostGLAccount
AssetAccountDetermination AstBal AssetAccountDetermination Account Determ.
Inventory SAFTFixedAsset Inventory Ci Inventory
RO_SAFTAssetID SAFTFixedAsset RO_SAFTAssetID
FixedAssetDescription SAFTFixedAsset FixedAssetDescription Description
AssetAdditionalDescription SAFTFixedAsset AssetAdditionalDescription
AssetClass SAFTFixedAsset AssetClass Asset Class
AssetCapitalizationDate SAFTFixedAsset AssetCapitalizationDate Asset Capitalization
AcquisitionValueDate SAFTFixedAsset AcquisitionValueDate
FixedAssetOrderDate SAFTFixedAsset FixedAssetOrderDate
AcquisitionDate SAFTFixedAsset AcquisitionDate Date Entered
UtilizationStartDate SAFTFixedAsset UtilizationStartDate
NationalClassification SAFTFixedAsset NationalClassification
PlannedUsefulLifeInYears SAFTFixedAsset PlannedUsefulLifeInYears Planned Use Life Yr.
PlannedUsefulLifeInPeriods SAFTFixedAsset PlannedUsefulLifeInPeriods
DepreciationKey SAFTFixedAsset DepreciationKey
RO_SAFTAstIsInvestmentSupport RO_SAFTAstIsInvestmentSupport
DisplayCurrency DisplayCurrency Display Currency
_CompanyCode _CompanyCode
_DepreciationArea _DepreciationArea
_ChartOfDepreciation _ChartOfDepreciation
_MasterFixedAsset _MasterFixedAsset
_FixedAsset _FixedAsset
_AssetAccountDetermination _AssetAccountDetermination
_Ledger _Ledger
_FiscalYear _FiscalYear

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_SAFTFixedAssetCube.
-- 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: CROSAFTFASSETCUB
-- Parameters: P_AssetAccountingKeyFigureSet : faa_key_figure_set, P_FiscalYear : fis_gjahr, P_ToFiscalPeriod : fis_period_to, P_KeyDate : fagl_keydate, P_ReportingStartDate : srf_rpg_period_start_date, P_AstLeadingDepreciationArea : saft_aa_ro_depr_area, P_AstLdngDeprAreaLedger : saft_aa_ro_depr_area_ledger, P_SelectedCurrencyBranch : saft_aa_ro_curr_branch

CREATE VIEW C_RO_SAFTFixedAssetCube 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.ChartOfDepreciation AS ChartOfDepreciation,
  AstBal.AcqnProdnCostGLAccount AS AcqnProdnCostGLAccount,
  AstBal.AssetAccountDetermination AS AssetAccountDetermination,
  SAFTFixedAsset.Inventory AS Inventory,
  SAFTFixedAsset.RO_SAFTAssetID AS RO_SAFTAssetID,
  SAFTFixedAsset.FixedAssetDescription AS FixedAssetDescription,
  SAFTFixedAsset.AssetAdditionalDescription AS AssetAdditionalDescription,
  SAFTFixedAsset.AssetClass AS AssetClass,
  SAFTFixedAsset.AssetCapitalizationDate AS AssetCapitalizationDate,
  SAFTFixedAsset.AcquisitionValueDate AS AcquisitionValueDate,
  SAFTFixedAsset.FixedAssetOrderDate AS FixedAssetOrderDate,
  SAFTFixedAsset.AcquisitionDate AS AcquisitionDate,
  SAFTFixedAsset.UtilizationStartDate AS UtilizationStartDate,
  SAFTFixedAsset.NationalClassification AS NationalClassification,
  SAFTFixedAsset.PlannedUsefulLifeInYears AS PlannedUsefulLifeInYears,
  SAFTFixedAsset.PlannedUsefulLifeInPeriods AS PlannedUsefulLifeInPeriods,
  SAFTFixedAsset.DepreciationKey AS DepreciationKey,
  RO_SAFTAstIsInvestmentSupport,
  DisplayCurrency
FROM P_RO_SAFTFixedAsset
INNER JOIN I_AssetBalanceCube ON /* join condition not captured in parsed metadata */
;

Learn More