P_FundFixedAsset
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)
| Source | Alias | Join Type |
|---|---|---|
| I_FixedAssetAssgmt | I_FixedAssetAssgmt | from |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_Fund | _Fund | $projection.ControllingArea = _Fund.FinancialManagementArea and $projection.Fund = _Fund.Fund |
Annotations (11)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA