What is C_FixedAssetsForFundsMgmt in SAP S/4HANA?

C_FixedAssetsForFundsMgmt is a consumption CDS view in SAP S/4HANA. Fixed Assets for Funds Management ObjP It contains 24 fields.

What VDM layer is C_FixedAssetsForFundsMgmt?

C_FixedAssetsForFundsMgmt is classified as a Consumption view optimized for specific business scenarios and reporting.

C_FixedAssetsForFundsMgmt

DDL: C_FIXEDASSETSFORFUNDSMGMT SQL: CFASETSFORFM Type: view CONSUMPTION

24 Fields 2 Associations

Fixed Assets for Funds Management ObjP

C_FixedAssetsForFundsMgmt is a Consumption CDS View that provides data about "Fixed Assets for Funds Management ObjP" in SAP S/4HANA. It has 2 associations to related views.

Associations (2)

Cardinality	Target	Alias	Condition
[1..1]	I_CompanyCode	_CompanyCode	`I_FixedAssetAssgmt.CompanyCode = _CompanyCode.CompanyCode`
[0..1]	I_Location	_Location	`$projection.AssetLocation = _Location.Location and I_FixedAssetAssgmt.Plant = _Location.Plant`

Annotations (12)

Name	Value	Level
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#L	view
VDM.viewType	#CONSUMPTION	view
AbapCatalog.sqlViewName	CFASETSFORFM	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Fixed Assets for Funds Management ObjP	view
UI.headerInfo.typeName	Fixed Asset	view
UI.headerInfo.typeNamePlural	Fixed Assets	view

Fields (24)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	_CompanyCode	CompanyCode	Company Code
KEY	MasterFixedAsset	I_FixedAssetAssgmt	MasterFixedAsset	Master Fixed Asset
KEY	FixedAsset	I_FixedAssetAssgmt	FixedAsset	Fixed Asset
KEY	ValidityEndDate	I_FixedAssetAssgmt	ValidityEndDate	Validity End Date
	FinancialManagementArea	_CompanyCode	FinancialManagementArea	Financial Management Area
	CompanyCodeName	_CompanyCode	CompanyCodeName	Company Code Name
	CompanyCodeExtendedName
	FixedAssetDescription			Fixed Asset Description
	AssetExtendedDescription
	AssetClass			Asset Class
	AssetClassName			Asset Class Name
	FixedAssetsExtendedName
	AssetClassDescription			Class Description
	AssetLocation	I_FixedAssetAssgmt	AssetLocation	Asset Location
	LocationName	_Location	LocationName	Location Name
	ExtendedLocationName
	Fund	I_FixedAssetAssgmt	Fund	Fund
	FundsCenter	I_FixedAssetAssgmt	FundsCenter	Funds Center
	BudgetPeriod	I_FixedAssetAssgmt	BudgetPeriod	Budget Period
	FunctionalArea	I_FixedAssetAssgmt	FunctionalArea	Functional Area
	GrantID	I_FixedAssetAssgmt	GrantID	Grant
	BusinessArea	I_FixedAssetAssgmt	BusinessArea	Business Area
	CostCenter	I_FixedAssetAssgmt	CostCenter	Cost Center
	Plant	I_FixedAssetAssgmt	Plant	Plant

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_FixedAssetsForFundsMgmt.
-- 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: CFASETSFORFM

CREATE VIEW C_FixedAssetsForFundsMgmt AS
SELECT
  _CompanyCode.CompanyCode AS CompanyCode,
  I_FixedAssetAssgmt.MasterFixedAsset AS MasterFixedAsset,
  I_FixedAssetAssgmt.FixedAsset AS FixedAsset,
  I_FixedAssetAssgmt.ValidityEndDate AS ValidityEndDate,
  _CompanyCode.FinancialManagementArea AS FinancialManagementArea,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  cast( concat_with_space(_CompanyCode.CompanyCode, _CompanyCode.CompanyCodeName, 1) as fmis_companycodeextendedname ) AS CompanyCodeExtendedName,
  I_FixedAssetAssgmt._FixedAsset.FixedAssetDescription AS FixedAssetDescription,
  cast( concat_with_space(I_FixedAssetAssgmt.FixedAsset, I_FixedAssetAssgmt._FixedAsset.FixedAssetDescription, 1) as fmis_assetsextendedescr ) AS AssetExtendedDescription,
  I_FixedAssetAssgmt._FixedAsset.AssetClass AS AssetClass,
  I_FixedAssetAssgmt._FixedAsset._AssetClass._Text[1:Language = $session.system_language].AssetClassName AS AssetClassName,
  cast( concat_with_space(I_FixedAssetAssgmt._FixedAsset.AssetClass, I_FixedAssetAssgmt._FixedAsset._AssetClass._Text[1:Language = $session.system_language].AssetClassName, 1) as fmis_fixedasstesextendedname ) AS FixedAssetsExtendedName,
  I_FixedAssetAssgmt._FixedAsset._AssetClass._Text[1:Language = $session.system_language].AssetClassDescription AS AssetClassDescription,
  I_FixedAssetAssgmt.AssetLocation AS AssetLocation,
  _Location.LocationName AS LocationName,
  cast( concat_with_space(I_FixedAssetAssgmt.AssetLocation, _Location.LocationName, 1) as fmis_extendedlocationname ) AS ExtendedLocationName,
  I_FixedAssetAssgmt.Fund AS Fund,
  I_FixedAssetAssgmt.FundsCenter AS FundsCenter,
  I_FixedAssetAssgmt.BudgetPeriod AS BudgetPeriod,
  I_FixedAssetAssgmt.FunctionalArea AS FunctionalArea,
  I_FixedAssetAssgmt.GrantID AS GrantID,
  I_FixedAssetAssgmt.BusinessArea AS BusinessArea,
  I_FixedAssetAssgmt.CostCenter AS CostCenter,
  I_FixedAssetAssgmt.Plant AS Plant
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON I_FixedAssetAssgmt.CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Location AS _Location ON AssetLocation = _Location.Location AND I_FixedAssetAssgmt.Plant = _Location.Plant  -- association [0..1]
;

Depth:

C_FixedAssetsForFundsMgmt view