P_RO_SAFTFixedAsset

DDL: P_RO_SAFTFIXEDASSET SQL: PROSAFASSET Type: view_entity COMPOSITE Package: GLO_FIN_IS_SAFT_AA_RO
17 Fields 3 Data Sources

RO SAFT Fixed Asset Master Data

P_RO_SAFTFixedAsset is a Composite CDS View that provides data about "RO SAFT Fixed Asset Master Data" in SAP S/4HANA. It reads from 3 data sources (I_AssetValuationForLedger, I_FixedAsset, I_FixedAssetForLedger) and exposes 17 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset. Part of development package GLO_FIN_IS_SAFT_AA_RO.

Data Sources (3)

SourceAliasJoin Type
I_AssetValuationForLedger AssetValuationForLedger inner
I_FixedAsset FixedAsset from
I_FixedAssetForLedger FixedAssetForLedger inner

Parameters (4)

NameTypeDefault
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

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label RO SAFT Fixed Asset Master Data view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_FixedAsset CompanyCode Receiver Company Code
KEY MasterFixedAsset I_FixedAsset MasterFixedAsset Fixed Asset
KEY FixedAsset I_FixedAsset FixedAsset Sub-number
Inventory I_FixedAsset Inventory Ci Inventory
FixedAssetDescription I_FixedAsset FixedAssetDescription Description
AssetAdditionalDescription
AssetClass I_FixedAsset AssetClass Asset Class
AssetAccountDetermination I_FixedAsset AssetAccountDetermination Account Determ.
FixedAssetOrderDate I_FixedAsset FixedAssetOrderDate Ordered On
AssetCapitalizationDate I_FixedAssetForLedger AssetCapitalizationDate Asset Capitalization
AssetDeactivationDate I_FixedAssetForLedger AssetDeactivationDate Deact.Date
AcquisitionValueDate I_FixedAssetForLedger AcquisitionValueDate First Acq. on
PlannedUsefulLifeInYears I_AssetValuationForLedger PlannedUsefulLifeInYears Planned Use Life Yr.
PlannedUsefulLifeInPeriods I_AssetValuationForLedger PlannedUsefulLifeInPeriods
DepreciationKey I_AssetValuationForLedger DepreciationKey
LeadingCompanyCode
RO_SAFTAstIsInvestmentSupport

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 P_RO_SAFTFixedAsset.
-- 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: PROSAFASSET
-- Parameters: 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

CREATE VIEW P_RO_SAFTFixedAsset AS
SELECT
  FixedAsset.CompanyCode AS CompanyCode,
  FixedAsset.MasterFixedAsset AS MasterFixedAsset,
  FixedAsset.FixedAsset AS FixedAsset,
  FixedAsset.Inventory AS Inventory,
  FixedAsset.FixedAssetDescription AS FixedAssetDescription,
  '' AS AssetAdditionalDescription,
  FixedAsset.AssetClass AS AssetClass,
  FixedAsset.AssetAccountDetermination AS AssetAccountDetermination,
  FixedAsset.FixedAssetOrderDate AS FixedAssetOrderDate,
  FixedAssetForLedger.AssetCapitalizationDate AS AssetCapitalizationDate,
  FixedAssetForLedger.AssetDeactivationDate AS AssetDeactivationDate,
  FixedAssetForLedger.AcquisitionValueDate AS AcquisitionValueDate,
  AssetValuationForLedger.PlannedUsefulLifeInYears AS PlannedUsefulLifeInYears,
  AssetValuationForLedger.PlannedUsefulLifeInPeriods AS PlannedUsefulLifeInPeriods,
  AssetValuationForLedger.DepreciationKey AS DepreciationKey,
  $parameters.P_LeadingCompanyCode AS LeadingCompanyCode,
  cast( ' ' as /ceecv/ro_sa_ast_is_invmt_supp ) AS RO_SAFTAstIsInvestmentSupport
FROM I_FixedAsset AS FixedAsset
INNER JOIN I_FixedAssetForLedger AS FixedAssetForLedger ON /* join condition not captured in parsed metadata */
INNER JOIN I_AssetValuationForLedger AS AssetValuationForLedger ON /* join condition not captured in parsed metadata */
;

Learn More