C_FixedAssetUsageObjectTP

DDL: C_FIXEDASSETUSAGEOBJECTTP Type: view_entity CONSUMPTION

Fixed Asset Usage Object

C_FixedAssetUsageObjectTP is a Consumption CDS View that provides data about "Fixed Asset Usage Object" in SAP S/4HANA. It reads from 1 data source (R_FixedAssetUsageObjectTP) and exposes 18 fields with key fields CompanyCode, FixedAssetUsageObject. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_FixedAssetUsageObjectTP R_FixedAssetUsageObjectTP projection

Associations (2)

CardinalityTargetAliasCondition
[0..*] C_FixedAssetUsageObjWhereUsd _UsageObjectWhereUsd $projection.CompanyCode = _UsageObjectWhereUsd.CompanyCode and $projection.FixedAssetUsageObject = _UsageObjectWhereUsd.FixedAssetUsageObject
[0..*] C_FixedAssetUsageObjectRmng _UsageObjectRmng $projection.CompanyCode = _UsageObjectRmng.CompanyCode and $projection.FixedAssetUsageObject = _UsageObjectRmng.FixedAssetUsageObject

Annotations (13)

NameValueLevelField
EndUserText.label Fixed Asset Usage Object view
AccessControl.authorizationCheck #CHECK view
UI.headerInfo.typeName Usage Object view
UI.headerInfo.typeNamePlural Usage Objects view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.value FixedAssetUsageObject view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
Search.searchable true view
ObjectModel.representativeKey FixedAssetUsageObject view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY FixedAssetUsageObject FixedAssetUsageObject
ChangeDocTableKey ChangeDocTableKey
FixedAssetUsageObjectDesc FixedAssetUsageObjectDesc
BaseUnit BaseUnit
FixedAssetUsageObjLfcycSts FixedAssetUsageObjLfcycSts
FixedAssetUsageObjLfcycName
CreationDateTime CreationDateTime
CreatedByUser CreatedByUser
LastChangeDateTime LastChangeDateTime
LastChangedByUser LastChangedByUser
UnitOfMeasureName
CompanyCodeName _CompanyCode CompanyCodeName
_CompanyCode _CompanyCode
_UnitOfMeasure _UnitOfMeasure
_UsageObjectLifecycleStatus _UsageObjectLifecycleStatus
_UsageObjectWhereUsd _UsageObjectWhereUsd
_UsageObjectRmng _UsageObjectRmng
@EndUserText.label: 'Fixed Asset Usage Object'
@AccessControl.authorizationCheck: #CHECK

@UI: {
  headerInfo: { typeName: 'Usage Object', typeNamePlural: 'Usage Objects', title: { type: #STANDARD, value: 'FixedAssetUsageObject' } } }

@VDM.viewType: #CONSUMPTION
@VDM.usage.type:[#TRANSACTIONAL_PROCESSING_SERVICE]
@Metadata.allowExtensions: true
@Search.searchable: true

@ObjectModel.representativeKey: 'FixedAssetUsageObject'
@ObjectModel.usageType: {
        serviceQuality: #C,
        sizeCategory: #XL,
        dataClass: #MASTER
}

define root view entity C_FixedAssetUsageObjectTP
  provider contract transactional_query 
  as projection on R_FixedAssetUsageObjectTP
  association [0..*] to C_FixedAssetUsageObjWhereUsd as _UsageObjectWhereUsd on  $projection.CompanyCode           = _UsageObjectWhereUsd.CompanyCode
                                                                             and $projection.FixedAssetUsageObject = _UsageObjectWhereUsd.FixedAssetUsageObject

  association [0..*] to C_FixedAssetUsageObjectRmng  as _UsageObjectRmng     on  $projection.CompanyCode           = _UsageObjectRmng.CompanyCode
                                                                             and $projection.FixedAssetUsageObject = _UsageObjectRmng.FixedAssetUsageObject
{
         @ObjectModel.foreignKey.association: '_CompanyCode'
         @Consumption.valueHelpDefinition: [ { entity: { name: 'I_CompanyCodeStdVH', element: 'CompanyCode' } } ]
         @Search.defaultSearchElement: true
         @Consumption.semanticObject: 'CompanyCode'
         @ObjectModel.text.element: ['CompanyCodeName']
  key    CompanyCode,
         @Search: {
           defaultSearchElement: true,
           //ranking: #HIGH,

           fuzzinessThreshold: 0.8
         }
         @Consumption.valueHelpDefinition: [ { entity: { name: 'I_FixedAssetUsageObjectVH', element: 'FixedAssetUsageObject' }
                                                      ,additionalBinding:  [ { localElement: 'CompanyCode', element:'CompanyCode' }
                                                      ]
                                               }]
  key    FixedAssetUsageObject,

         @Consumption.filter.hidden: true
         @UI.hidden: true
         ChangeDocTableKey,


         @Search: {
           defaultSearchElement: true,
           //ranking: #HIGH,

           fuzzinessThreshold: 0.8
         }

         @Consumption.filter.hidden: true
         FixedAssetUsageObjectDesc,

         @ObjectModel.text.element: ['UnitOfMeasureName']
         @Consumption.valueHelpDefinition: [ { entity: { name: 'I_UnitOfMeasureStdVH', element: 'UnitOfMeasure' } } ]
         BaseUnit,

         @ObjectModel.text.element: ['FixedAssetUsageObjLfcycName']
         @Consumption.filter.hidden: true
         FixedAssetUsageObjLfcycSts,

         @Semantics.text: true
         @Consumption.valueHelpDefinition: [ { entity: { name: 'I_FxdAstUsageObjectLfcycStsVH', element: 'FixedAssetUsageObjLfcycName' },
                                                   additionalBinding:[{localElement: 'FixedAssetUsageObjLfcycSts', element: 'FixedAssetUsageObjLfcycSts', usage: #FILTER }]
                                                  } ]
         _UsageObjectLifecycleStatus._Text[1:Language = $session.system_language].FixedAssetUsageObjLfcycName,
         
         @Consumption.filter.selectionType:  #SINGLE
         CreationDateTime,

         CreatedByUser,
         
         @Consumption.filter.selectionType:  #SINGLE
         LastChangeDateTime,

         //         DraftLastChangedDateTime,


         LastChangedByUser,

         @Consumption.filter.hidden: true
         _UnitOfMeasure._Text[ 1: Language = $session.system_language ].UnitOfMeasureName,

         @Consumption.filter.hidden: true
         _CompanyCode.CompanyCodeName,

         _CompanyCode,

         _UnitOfMeasure,

         _UsageObjectLifecycleStatus,

         _UsageObjectWhereUsd,


         @ObjectModel.filter.enabled: false
         //@ObjectModel.sort.enabled: false

         _UsageObjectRmng,

         _UsageObjectPeriod : redirected to composition child C_FixedAssetUsageObjectPerdTP,
         _UsageObjectTotal  : redirected to composition child C_FixedAssetUsageObjectTotTP
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"I_FXDASTUSAGEOBJECTLFCYCSTS",
"I_FXDASTUSAGEOBJLFCYCSTSTEXT",
"I_UNITOFMEASURE",
"I_UNITOFMEASURETEXT",
"R_FIXEDASSETUSAGEOBJECTTP"
],
"ASSOCIATED":
[
"C_FIXEDASSETUSAGEOBJECTPERDTP",
"C_FIXEDASSETUSAGEOBJECTRMNG",
"C_FIXEDASSETUSAGEOBJECTTOTTP",
"C_FIXEDASSETUSAGEOBJWHEREUSD",
"I_COMPANYCODE",
"I_FXDASTUSAGEOBJECTLFCYCSTS",
"I_UNITOFMEASURE",
"R_FIXEDASSETUSAGEOBJECTPERDTP",
"R_FIXEDASSETUSAGEOBJECTTOTTP"
],
"BASE":
[
"R_FIXEDASSETUSAGEOBJECTTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/