P_FundFixedAsset

DDL: P_FUNDFIXEDASSET Type: view COMPOSITE Package: ODATA_PSM_S4C_FM_WHRUSED_FUND
24 Fields 1 Data Sources 1 Associations

WUFUND Fixed Assets

P_FundFixedAsset is a Composite CDS View that provides data about "WUFUND Fixed Assets" in SAP S/4HANA. It reads from 1 data source (I_FixedAssetAssgmt) and exposes 24 fields with key fields FundWhereUsedObjType, FinancialManagementArea, Fund, CompanyCode, MasterFixedAsset. It has 1 association to related views. Part of development package ODATA_PSM_S4C_FM_WHRUSED_FUND.

Data Sources (1)

SourceAliasJoin Type
I_FixedAssetAssgmt I_FixedAssetAssgmt from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Fund _Fund $projection.ControllingArea = _Fund.FinancialManagementArea and $projection.Fund = _Fund.Fund

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PWUFUNDFA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label WUFUND Fixed Assets view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY FundWhereUsedObjType
KEY FinancialManagementArea _Fund FinancialManagementArea FM Area
KEY Fund Fund Sender Fund
KEY CompanyCode CompanyCode Receiver Company Code
KEY MasterFixedAsset MasterFixedAsset Fixed Asset
KEY FixedAsset FixedAsset Sub-number
KEY ValidityEndDate ValidityEndDate ValidTo
ValidityStartDate ValidityStartDate Validity Start Date
FixedAssetDescription _FixedAsset FixedAssetDescription Description
AssetClass
AssetClassName
ControllingArea ControllingArea Controlling Area
CostCenter CostCenter Cost Center
BusinessArea BusinessArea Business Area
Plant Plant Valuation Area
AssetAuthorizationContext AssetAuthorizationContext
CompanyCodeName _CompanyCode CompanyCodeName Company Name
_FixedAsset _FixedAsset
_CompanyCode _CompanyCode
_MasterFixedAsset _MasterFixedAsset
_ControllingArea _ControllingArea
_CostCenter _CostCenter
_BusinessArea _BusinessArea
_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 P_FundFixedAsset.
-- 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.

CREATE VIEW P_FundFixedAsset AS
SELECT
  cast( '1FXA' as psm_s4c_fm_fund_wu_obj_type_vh ) AS FundWhereUsedObjType,
  _Fund.FinancialManagementArea AS FinancialManagementArea,
  Fund,
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  ValidityEndDate,
  ValidityStartDate,
  _FixedAsset.FixedAssetDescription AS FixedAssetDescription,
  _FixedAsset._AssetClass.AssetClass AS AssetClass,
  _FixedAsset._AssetClass._Text[ Language = $session.system_language ].AssetClassName AS AssetClassName,
  ControllingArea,
  CostCenter,
  BusinessArea,
  Plant,
  AssetAuthorizationContext,
  _CompanyCode.CompanyCodeName AS CompanyCodeName
FROM I_FixedAssetAssgmt
LEFT OUTER JOIN I_Fund AS _Fund ON ControllingArea = _Fund.FinancialManagementArea AND Fund = _Fund.Fund  -- association [1..1]
;

Learn More