C_FixedAssetInvmtSuppMsrMntn

DDL: C_FIXEDASSETINVMTSUPPMSRMNTN SQL: CFASSETINVSMNTN Type: view CONSUMPTION Package: ODATA_AA_ASSET_MANAGE
9 Fields 2 Associations

Consumption View of Fixed Asset Change - Invmt Supp Measure

C_FixedAssetInvmtSuppMsrMntn is a Consumption CDS View that provides data about "Consumption View of Fixed Asset Change - Invmt Supp Measure" in SAP S/4HANA. It has 2 associations to related views. Part of development package ODATA_AA_ASSET_MANAGE.

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_FixedAssetMaintain _FixedAsset $projection.CompanyCode = _FixedAsset.CompanyCode and $projection.MasterFixedAsset = _FixedAsset.MasterFixedAsset and $projection.FixedAsset = _FixedAsset.FixedAsset
[0..1] I_InvestmentSupportMeasureText _InvestmentSupportMeasureText I_FixedAssetDeprAreaTP.ChartOfDepreciation = _InvestmentSupportMeasureText.ChartOfDepreciation and I_FixedAssetDeprAreaTP.InvestmentSupportMeasure = _InvestmentSupportMeasureText.InvestmentSupportMeasure and _InvestmentSupportMeasureText.Language = $session.system_language

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName CFASSETINVSMNTN view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Consumption View of Fixed Asset Change - Invmt Supp Measure view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_FixedAssetDeprAreaTP CompanyCode Receiver Company Code
KEY MasterFixedAsset I_FixedAssetDeprAreaTP MasterFixedAsset Fixed Asset
KEY FixedAsset I_FixedAssetDeprAreaTP FixedAsset Sub-number
KEY InvestmentSupportMeasure I_FixedAssetDeprAreaTP InvestmentSupportMeasure
ChartOfDepreciation I_FixedAssetDeprAreaTP ChartOfDepreciation
InvestmentSupportMeasureName _InvestmentSupportMeasureText InvestmentSupportMeasureName
_FixedAsset _FixedAsset
_InvestmentSupportMeasure I_FixedAssetDeprAreaTP _InvestmentSupportMeasure
_ChartOfDepreciation _ChartOfDepreciation

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_FixedAssetInvmtSuppMsrMntn.
-- 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: CFASSETINVSMNTN

CREATE VIEW C_FixedAssetInvmtSuppMsrMntn AS
SELECT
  I_FixedAssetDeprAreaTP.CompanyCode AS CompanyCode,
  I_FixedAssetDeprAreaTP.MasterFixedAsset AS MasterFixedAsset,
  I_FixedAssetDeprAreaTP.FixedAsset AS FixedAsset,
  I_FixedAssetDeprAreaTP.InvestmentSupportMeasure AS InvestmentSupportMeasure,
  I_FixedAssetDeprAreaTP.ChartOfDepreciation AS ChartOfDepreciation,
  _InvestmentSupportMeasureText.InvestmentSupportMeasureName AS InvestmentSupportMeasureName,
  I_FixedAssetDeprAreaTP._InvestmentSupportMeasure AS _InvestmentSupportMeasure
LEFT OUTER JOIN C_FixedAssetMaintain AS _FixedAsset ON CompanyCode = _FixedAsset.CompanyCode AND MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset  -- association [1..1]
LEFT OUTER JOIN I_InvestmentSupportMeasureText AS _InvestmentSupportMeasureText ON I_FixedAssetDeprAreaTP.ChartOfDepreciation = _InvestmentSupportMeasureText.ChartOfDepreciation AND I_FixedAssetDeprAreaTP.InvestmentSupportMeasure = _InvestmentSupportMeasureText.InvestmentSupportMeasure AND _InvestmentSupportMeasureText.Language = $session.system_language  -- association [0..1]
;

Learn More