I_MasterFixedAsset

DDL: I_MASTERFIXEDASSET Type: view BASIC

Master Fixed Asset

I_MasterFixedAsset is a Basic CDS View (Dimension) that provides data about "Master Fixed Asset" in SAP S/4HANA. It reads from 1 data source (P_MasterFixedAsset) and exposes 6 fields with key fields CompanyCode, MasterFixedAsset. It has 2 associations to related views.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
P_MasterFixedAsset P_MasterFixedAsset from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..*] I_FixedAsset _FixedAsset $projection.CompanyCode = _FixedAsset.CompanyCode and $projection.MasterFixedAsset = _FixedAsset.MasterFixedAsset

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IFIMASTFIXASSET view
AbapCatalog.preserveKey true view
Analytics.dataCategory #DIMENSION view
EndUserText.label Master Fixed Asset view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey MasterFixedAsset view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY MasterFixedAsset MasterFixedAsset
MasterFixedAssetDescription MasterFixedAssetDescription
AssetAuthorizationContext AssetAuthorizationContext
_CompanyCode _CompanyCode
_FixedAsset _FixedAsset 
@AbapCatalog: {sqlViewName: 'IFIMASTFIXASSET', preserveKey: true}
@Analytics: { dataCategory: #DIMENSION }
@EndUserText.label: 'Master Fixed Asset'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@ObjectModel: { representativeKey: 'MasterFixedAsset',
                usageType.serviceQuality: #A,
                usageType.sizeCategory: #XL,
                usageType.dataClass: #MASTER,
                modelingPattern: #ANALYTICAL_DIMENSION,
                supportedCapabilities: [#ANALYTICAL_DIMENSION]
              }
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata: {ignorePropagatedAnnotations: true, allowExtensions:true}

define view I_MasterFixedAsset
  as select from P_MasterFixedAsset

  association [0..1] to I_CompanyCode as _CompanyCode on  $projection.CompanyCode = _CompanyCode.CompanyCode
  association [0..*] to I_FixedAsset  as _FixedAsset  on  $projection.CompanyCode      = _FixedAsset.CompanyCode
                                                      and $projection.MasterFixedAsset = _FixedAsset.MasterFixedAsset
{
      @ObjectModel.foreignKey.association: '_CompanyCode'
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_CompanyCodeStdVH', element: 'CompanyCode' } } ]
  key CompanyCode,
      @ObjectModel.text.element:  [ 'MasterFixedAssetDescription' ]
  key MasterFixedAsset,

      @Semantics.text: true
      MasterFixedAssetDescription,

      @Consumption.hidden: true
      AssetAuthorizationContext, //Needed for DCL


      _CompanyCode,
      _FixedAsset
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_MASTERFIXEDASSET"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_FIXEDASSET"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More