P_WhereUsdIntOrdFixedAsset

DDL: P_WHEREUSDINTORDFIXEDASSET Type: view COMPOSITE Package: ODATA_WHERE_USED_INTERNALORDER

WUIO Object Type Data - Fixed Assets

P_WhereUsdIntOrdFixedAsset is a Composite CDS View that provides data about "WUIO Object Type Data - Fixed Assets" in SAP S/4HANA. It reads from 1 data source (I_FixedAsset) and exposes 16 fields with key fields WhereUsdIntOrdObjectType, CompanyCode, MasterFixedAsset, FixedAsset. Part of development package ODATA_WHERE_USED_INTERNALORDER.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_FixedAsset I_FixedAsset from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PWUIOFIXEDASSETS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY WhereUsdIntOrdObjectType
KEY CompanyCode CompanyCode
KEY MasterFixedAsset MasterFixedAsset
KEY FixedAsset FixedAsset
FixedAssetDescription FixedAssetDescription
AssetClass AssetClass
AssetClassDescription
InternalOrder InvestmentOrder
InternalOrderDescription _InvestmentOrder InternalOrderDescription
ControllingArea _InvestmentOrder ControllingArea
ControllingAreaName
CompanyCodeName
OrderType _InvestmentOrder OrderType
OrderTypeName
AssetAuthorizationContext AssetAuthorizationContext
_FixedAssetAssgmt _FixedAssetAssgmt 
@AbapCatalog: {
  sqlViewName: 'PWUIOFIXEDASSETS',
  compiler.compareFilter: true,
  preserveKey: true
}
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType:{
  serviceQuality: #B,
  sizeCategory: #XXL,
  dataClass: #MASTER
}
@VDM: {
  private: true,
  viewType: #COMPOSITE
}
define view P_WhereUsdIntOrdFixedAsset
  as select from I_FixedAsset
{
  key cast( 'FA' as whereusdintordobjecttype ) as WhereUsdIntOrdObjectType,
  key CompanyCode,
  key MasterFixedAsset,
  key FixedAsset,
  
  FixedAssetDescription,
  AssetClass,
  _AssetClass._Text[ Language = $session.system_language ].AssetClassDescription,

  InvestmentOrder as InternalOrder,
  _InvestmentOrder.InternalOrderDescription as InternalOrderDescription,
  _InvestmentOrder.ControllingArea as ControllingArea,
  _InvestmentOrder._ControllingArea.ControllingAreaName,
  _InvestmentOrder._CompanyCode.CompanyCodeName,
  _InvestmentOrder.OrderType as OrderType,
  _InvestmentOrder._InternalOrderTypeText[ Language = $session.system_language ].OrderTypeName,
  AssetAuthorizationContext,
  _FixedAssetAssgmt
}

Learn More