I_PlanHistSheetHierKeyFigSpec

DDL: I_PLANHISTSHEETHIERKEYFIGSPEC SQL: IFIASTAHSHRYPLN Type: view COMPOSITE
6 Fields 2 Data Sources

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.

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 Trans.Type Cat.
KEY SubLedgerAcctLineItemType I_AssetKeyFigureSpecification SubLedgerAcctLineItemType SLALineItemType
AssetAccountingKeyFigure I_AssetKeyFigureSpecification AssetAccountingKeyFigure Key Figure
_AssetKeyFigure I_AssetKeyFigureSpecification _AssetKeyFigure
_AssetAcctAnlytlTransClassfctn I_AssetKeyFigureSpecification _AssetAcctAnlytlTransClassfctn
_SubLedgerAccLineItemType I_AssetKeyFigureSpecification _SubLedgerAccLineItemType

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_PlanHistSheetHierKeyFigSpec.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IFIASTAHSHRYPLN

CREATE VIEW I_PlanHistSheetHierKeyFigSpec AS
SELECT
  AssetKeyFigureSpec.AssetAcctAnlytlTransClassfctn AS AssetAcctAnlytlTransClassfctn,
  AssetKeyFigureSpec.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  AssetKeyFigureSpec.AssetAccountingKeyFigure AS AssetAccountingKeyFigure,
  AssetKeyFigureSpec._AssetKeyFigure AS _AssetKeyFigure,
  AssetKeyFigureSpec._AssetAcctAnlytlTransClassfctn AS _AssetAcctAnlytlTransClassfctn,
  AssetKeyFigureSpec._SubLedgerAccLineItemType AS _SubLedgerAccLineItemType
FROM I_AssetKeyFigureSetSpec AS AssetKeyFigureSetSpec
INNER JOIN I_AssetKeyFigureSpecification AS AssetKeyFigureSpec ON /* join condition not captured in parsed metadata */
;

Learn More