Deprecated
This CDS view is deprecated in S/4HANA. View all deprecated CDS views →

I_FixedAssetBalanceOvw

DDL: I_FIXEDASSETBALANCEOVW SQL: IFASSETBALOV Type: view COMPOSITE
42 Fields 1 Data Sources 3 Associations

Fixed Asset Balance Overview

I_FixedAssetBalanceOvw is a Composite CDS View that provides data about "Fixed Asset Balance Overview" in SAP S/4HANA. It reads from 1 data source (P_FixedAssetBalanceOvw) and exposes 42 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset, AssetDepreciationArea, Ledger. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_FixedAssetBalanceOvw P_FixedAssetBalanceOvw from

Parameters (4)

NameTypeDefault
P_TodayDate fagl_keydate
P_CurrencyRole fis_curtp
P_FiscalYear fis_gjahr
P_FiscalPeriod fis_poper

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_FixedAssetAssgmt _FixedAssetAssgmt _FixedAssetAssgmt.CompanyCode = $projection.CompanyCode and _FixedAssetAssgmt.MasterFixedAsset = $projection.MasterFixedAsset and _FixedAssetAssgmt.FixedAsset = $projection.FixedAsset
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_AssetClass _AssetClass $projection.AssetClass = _AssetClass.AssetClass

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IFASSETBALOV view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Fixed Asset Balance Overview view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.lifecycle.status #DEPRECATED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY MasterFixedAsset MasterFixedAsset Fixed Asset
KEY FixedAsset FixedAsset Sub-number
KEY AssetDepreciationArea AssetDepreciationArea Deprec. Area
KEY Ledger Ledger Ledger
FiscalYearVariant FiscalYearVariant FY Variant
ChartOfDepreciation ChartOfDepreciation
AssetClass AssetClass Asset Class
AssetDeactivationDate AssetDeactivationDate
AssetCapitalizationDate AssetCapitalizationDate Asset Capitalization
FixedAssetDescription _FixedAsset FixedAssetDescription Description
Group1AssetEvaluationKey _FixedAsset Group1AssetEvaluationKey
Group2AssetEvaluationKey _FixedAsset Group2AssetEvaluationKey
Group3AssetEvaluationKey _FixedAsset Group3AssetEvaluationKey
Group4AssetEvaluationKey _FixedAsset Group4AssetEvaluationKey
Group5AssetEvaluationKey _FixedAsset Group5AssetEvaluationKey
AssetCountryOfOrigin
AssetSupplier _FixedAsset Supplier Supplier
SupplierAccountGroup
SupplierBasicAuthorizationGrp
AssetAuthorizationContext _FixedAsset AssetAuthorizationContext
AssetCostCenter
BusinessArea
AssetPlant
AssetProfitCenter
Segment
AssetLocation
CostCenterName
BusinessAreaName
PlantName
ProfitCenterName
SegmentName
LocationName
AssetAccountDetermination _FixedAsset AssetAccountDetermination Account Determ.
AssetAccountDeterminationDesc
DisplayCurrency DisplayCurrency Display Currency
NetBookValueAmtInDspCrcy NetBookValueAmtInDspCrcy
_CompanyCode _CompanyCode
_FixedAsset _FixedAsset
_DepreciationArea _DepreciationArea
_AssetClass _AssetClass
_FixedAssetAssgmt _FixedAssetAssgmt

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 I_FixedAssetBalanceOvw.
-- 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: IFASSETBALOV
-- Parameters: P_TodayDate : fagl_keydate, P_CurrencyRole : fis_curtp, P_FiscalYear : fis_gjahr, P_FiscalPeriod : fis_poper

CREATE VIEW I_FixedAssetBalanceOvw AS
SELECT
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  AssetDepreciationArea,
  Ledger,
  FiscalYearVariant,
  ChartOfDepreciation,
  AssetClass,
  AssetDeactivationDate,
  AssetCapitalizationDate,
  _FixedAsset.FixedAssetDescription AS FixedAssetDescription,
  _FixedAsset.Group1AssetEvaluationKey AS Group1AssetEvaluationKey,
  _FixedAsset.Group2AssetEvaluationKey AS Group2AssetEvaluationKey,
  _FixedAsset.Group3AssetEvaluationKey AS Group3AssetEvaluationKey,
  _FixedAsset.Group4AssetEvaluationKey AS Group4AssetEvaluationKey,
  _FixedAsset.Group5AssetEvaluationKey AS Group5AssetEvaluationKey,
  cast(_FixedAsset.AssetCountryOfOrigin as faa_asset_cntry_of_origin) AS AssetCountryOfOrigin,
  _FixedAsset.Supplier AS AssetSupplier,
  _FixedAsset._Supplier.SupplierAccountGroup AS SupplierAccountGroup,
  _FixedAsset._Supplier.AuthorizationGroup AS SupplierBasicAuthorizationGrp,
  _FixedAsset.AssetAuthorizationContext AS AssetAuthorizationContext,
  _FixedAssetAssgmt[1:ValidityStartDate <= :P_TodayDate and ValidityEndDate >= :P_TodayDate].CostCenter AS AssetCostCenter,
  _FixedAssetAssgmt[1:ValidityStartDate <= :P_TodayDate and ValidityEndDate >= :P_TodayDate].BusinessArea AS BusinessArea,
  _FixedAssetAssgmt[1:ValidityStartDate <= :P_TodayDate and ValidityEndDate >= :P_TodayDate].Plant AS AssetPlant,
  _FixedAssetAssgmt[1:ValidityStartDate <= :P_TodayDate and ValidityEndDate >= :P_TodayDate].ProfitCenter AS AssetProfitCenter,
  _FixedAssetAssgmt[1:ValidityStartDate <= :P_TodayDate and ValidityEndDate >= :P_TodayDate].Segment AS Segment,
  _FixedAssetAssgmt[1:ValidityStartDate <= :P_TodayDate and ValidityEndDate >= :P_TodayDate].AssetLocation AS AssetLocation,
  _FixedAssetAssgmt[1:ValidityStartDate <= :P_TodayDate and ValidityEndDate >= :P_TodayDate]._CostCenter[1:ValidityStartDate <= :P_TodayDate and ValidityEndDate >= :P_TodayDate]._Text[1:Language = $session.system_language].CostCenterName AS CostCenterName,
  _FixedAssetAssgmt[1:ValidityStartDate <= :P_TodayDate and ValidityEndDate >= :P_TodayDate]._BusinessArea._Text[1:Language = $session.system_language].BusinessAreaName AS BusinessAreaName,
  _FixedAssetAssgmt[1:ValidityStartDate <= :P_TodayDate and ValidityEndDate >= :P_TodayDate]._Plant.PlantName AS PlantName,
  _FixedAssetAssgmt[1:ValidityStartDate <= :P_TodayDate and ValidityEndDate >= :P_TodayDate]._ProfitCenter[1:ValidityStartDate <= :P_TodayDate and ValidityEndDate >= :P_TodayDate]._Text[1:Language = $session.system_language].ProfitCenterName AS ProfitCenterName,
  _FixedAssetAssgmt[1:ValidityStartDate <= :P_TodayDate and ValidityEndDate >= :P_TodayDate]._Segment._Text[1:Language = $session.system_language].SegmentName AS SegmentName,
  _FixedAssetAssgmt[1:ValidityStartDate <= :P_TodayDate and ValidityEndDate >= :P_TodayDate]._AssetLocation.LocationName AS LocationName,
  _FixedAsset.AssetAccountDetermination AS AssetAccountDetermination,
  _FixedAsset._AssetAccountDetermination._Text[1: Language = $session.system_language ].AssetAccountDeterminationDesc AS AssetAccountDeterminationDesc,
  DisplayCurrency,
  NetBookValueAmtInDspCrcy
FROM P_FixedAssetBalanceOvw
LEFT OUTER JOIN I_FixedAssetAssgmt AS _FixedAssetAssgmt ON _FixedAssetAssgmt.CompanyCode = CompanyCode AND _FixedAssetAssgmt.MasterFixedAsset = MasterFixedAsset AND _FixedAssetAssgmt.FixedAsset = FixedAsset  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_AssetClass AS _AssetClass ON AssetClass = _AssetClass.AssetClass  -- association [0..1]
;

Learn More