P_FundFixedAsset

DDL: P_FUNDFIXEDASSET Type: view COMPOSITE Package: ODATA_PSM_S4C_FM_WHRUSED_FUND

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
KEY Fund Fund
KEY CompanyCode CompanyCode
KEY MasterFixedAsset MasterFixedAsset
KEY FixedAsset FixedAsset
KEY ValidityEndDate ValidityEndDate
ValidityStartDate ValidityStartDate
FixedAssetDescription _FixedAsset FixedAssetDescription
AssetClass
AssetClassName
ControllingArea ControllingArea
CostCenter CostCenter
BusinessArea BusinessArea
Plant Plant
AssetAuthorizationContext AssetAuthorizationContext
CompanyCodeName _CompanyCode CompanyCodeName
_FixedAsset _FixedAsset
_CompanyCode _CompanyCode
_MasterFixedAsset _MasterFixedAsset
_ControllingArea _ControllingArea
_CostCenter _CostCenter
_BusinessArea _BusinessArea
_Plant _Plant
@AbapCatalog: {
  sqlViewName: 'PWUFUNDFA',
  compiler.compareFilter: true,
  preserveKey: true
}
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'WUFUND Fixed Assets'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType:{
  sizeCategory: #L,
  serviceQuality: #B,
  dataClass: #MIXED
}
@VDM: {
  private: true,
  viewType: #COMPOSITE
}
define view P_FundFixedAsset
  as select from I_FixedAssetAssgmt
  association [1..1] to I_Fund as _Fund on  $projection.ControllingArea = _Fund.FinancialManagementArea
                                        and $projection.Fund            = _Fund.Fund
{
  key cast( '1FXA' as psm_s4c_fm_fund_wu_obj_type_vh )                                           as FundWhereUsedObjType,
  key _Fund.FinancialManagementArea,
  key Fund,  
  key CompanyCode,
  key MasterFixedAsset,
  key FixedAsset,
  key ValidityEndDate,
      ValidityStartDate,
      _FixedAsset.FixedAssetDescription                                                          as FixedAssetDescription,
      _FixedAsset._AssetClass.AssetClass,
      _FixedAsset._AssetClass._Text[ Language = $session.system_language ].AssetClassName        as AssetClassName,
      ControllingArea,
      CostCenter,                
      BusinessArea,              
      Plant,                     
      AssetAuthorizationContext, 
      _CompanyCode.CompanyCodeName,
      _FixedAsset,
      _CompanyCode,      
      _MasterFixedAsset,
      _ControllingArea,
      _CostCenter,
      _BusinessArea,
      _Plant                          
}