I_PlanHistSheetHierKeyFigSpec

DDL: I_PLANHISTSHEETHIERKEYFIGSPEC SQL: IFIASTAHSHRYPLN Type: view COMPOSITE

Key Figure Spec. of Asset History Sheet Hierarchy (Plan)

I_PlanHistSheetHierKeyFigSpec is a Composite CDS View that provides data about "Key Figure Spec. of Asset History Sheet Hierarchy (Plan)" in SAP S/4HANA. It reads from 2 data sources (I_AssetKeyFigureSetSpec, I_AssetKeyFigureSpecification) and exposes 6 fields with key fields AssetAcctAnlytlTransClassfctn, SubLedgerAcctLineItemType.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
I_AssetKeyFigureSetSpec AssetKeyFigureSetSpec from
I_AssetKeyFigureSpecification AssetKeyFigureSpec inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName IFIASTAHSHRYPLN view
EndUserText.label Key Figure Spec. of Asset History Sheet Hierarchy (Plan) view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY AssetAcctAnlytlTransClassfctn I_AssetKeyFigureSpecification AssetAcctAnlytlTransClassfctn
KEY SubLedgerAcctLineItemType I_AssetKeyFigureSpecification SubLedgerAcctLineItemType
AssetAccountingKeyFigure I_AssetKeyFigureSpecification AssetAccountingKeyFigure
_AssetKeyFigure I_AssetKeyFigureSpecification _AssetKeyFigure
_AssetAcctAnlytlTransClassfctn I_AssetKeyFigureSpecification _AssetAcctAnlytlTransClassfctn
_SubLedgerAccLineItemType I_AssetKeyFigureSpecification _SubLedgerAccLineItemType 
@AbapCatalog.sqlViewName: 'IFIASTAHSHRYPLN'
@EndUserText.label: 'Key Figure Spec. of Asset History Sheet Hierarchy (Plan)'
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel: { usageType.serviceQuality: #A,
                usageType.sizeCategory: #M,
                usageType.dataClass: #CUSTOMIZING }
@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_PlanHistSheetHierKeyFigSpec
  as select from I_AssetKeyFigureSetSpec       as AssetKeyFigureSetSpec
    inner join   I_AssetKeyFigureSpecification as AssetKeyFigureSpec on AssetKeyFigureSpec.AssetAccountingKeyFigure = AssetKeyFigureSetSpec.AssetAccountingKeyFigure
{
  key AssetKeyFigureSpec.AssetAcctAnlytlTransClassfctn,
  key AssetKeyFigureSpec.SubLedgerAcctLineItemType,
      AssetKeyFigureSpec.AssetAccountingKeyFigure,

      AssetKeyFigureSpec._AssetKeyFigure,
      AssetKeyFigureSpec._AssetAcctAnlytlTransClassfctn,
      AssetKeyFigureSpec._SubLedgerAccLineItemType
}
where
      AssetKeyFigureSetSpec.AssetAccountingKeyFigureSet =  'AHS_HRY_PL'
  and AssetKeyFigureSetSpec.AssetAccountingKeyFigure    <> '0000790401' //Exclude the net book value at fiscal year start to prevent duplicates

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ASSETKEYFIGURESETSPEC",
"I_ASSETKEYFIGURESPECIFICATION"
],
"ASSOCIATED":
[
"I_ANLYTLMOVEMENTCATEGORY",
"I_ASSETKEYFIGURE",
"I_SUBLEDGERACCLINEITEMTYPE"
],
"BASE":
[
"I_ASSETKEYFIGURESPECIFICATION"
],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More