I_AssetKeyFigureSpecification

DDL: I_ASSETKEYFIGURESPECIFICATION Type: view BASIC

Asset Key Figure Specification

I_AssetKeyFigureSpecification is a Basic CDS View that provides data about "Asset Key Figure Specification" in SAP S/4HANA. It reads from 1 data source (faac_kfc_spec) and exposes 7 fields with key fields AssetAccountingKeyFigure, AssetAcctAnlytlTransClassfctn, SubLedgerAcctLineItemType. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
faac_kfc_spec faac_kfc_spec from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_AssetKeyFigure _AssetKeyFigure $projection.AssetAccountingKeyFigure = _AssetKeyFigure.AssetAccountingKeyFigure
[0..1] I_AnlytlMovementCategory _AssetAcctAnlytlTransClassfctn $projection.AssetAcctAnlytlTransClassfctn = _AssetAcctAnlytlTransClassfctn.AssetAcctAnlytlTransClassfctn
[0..1] I_SubLedgerAccLineItemType _SubLedgerAccLineItemType $projection.SubLedgerAcctLineItemType = _SubLedgerAccLineItemType.SubLedgerAcctLineItemType

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IASSETKEYFIGSPEC view
AbapCatalog.preserveKey true view
EndUserText.label Asset Key Figure Specification view
VDM.viewType #BASIC 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
Metadata.ignorePropagatedAnnotations true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY AssetAccountingKeyFigure faac_kfc_spec key_figure_code
KEY AssetAcctAnlytlTransClassfctn faac_kfc_spec movcat
KEY SubLedgerAcctLineItemType faac_kfc_spec slalittype
PlannedValueIsInclusive faac_kfc_spec use_value_type
_AssetKeyFigure _AssetKeyFigure
_AssetAcctAnlytlTransClassfctn _AssetAcctAnlytlTransClassfctn
_SubLedgerAccLineItemType _SubLedgerAccLineItemType
@AbapCatalog: {sqlViewName: 'IASSETKEYFIGSPEC', preserveKey: true}
@EndUserText.label: 'Asset Key Figure Specification'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel: { usageType.serviceQuality: #A,
                usageType.sizeCategory: #M,
                usageType.dataClass: #CUSTOMIZING }
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true

define view I_AssetKeyFigureSpecification
  as select from faac_kfc_spec

  association [0..1] to I_AssetKeyFigure           as _AssetKeyFigure                on $projection.AssetAccountingKeyFigure = _AssetKeyFigure.AssetAccountingKeyFigure
  association [0..1] to I_AnlytlMovementCategory   as _AssetAcctAnlytlTransClassfctn on $projection.AssetAcctAnlytlTransClassfctn = _AssetAcctAnlytlTransClassfctn.AssetAcctAnlytlTransClassfctn
  association [0..1] to I_SubLedgerAccLineItemType as _SubLedgerAccLineItemType      on $projection.SubLedgerAcctLineItemType = _SubLedgerAccLineItemType.SubLedgerAcctLineItemType
{
      @ObjectModel.foreignKey.association: '_AssetKeyFigure'
  key faac_kfc_spec.key_figure_code as AssetAccountingKeyFigure,
      @ObjectModel.foreignKey.association: '_AssetAcctAnlytlTransClassfctn'
  key faac_kfc_spec.movcat          as AssetAcctAnlytlTransClassfctn,
      @ObjectModel.foreignKey.association: '_SubledgerAccLineItemType'
  key faac_kfc_spec.slalittype      as SubLedgerAcctLineItemType,
      faac_kfc_spec.use_value_type  as PlannedValueIsInclusive,

      _AssetKeyFigure,
      _AssetAcctAnlytlTransClassfctn,
      _SubLedgerAccLineItemType
}