I_StatKeyFigWhereUsedAllocType

DDL: I_STATKEYFIGWHEREUSEDALLOCTYPE SQL: ISKFWHEREUSDAT Type: view COMPOSITE Package: ODATA_WHERE_USED_STAT_KEY_FIG
6 Fields 2 Data Sources

Old and New Allocation Types

I_StatKeyFigWhereUsedAllocType is a Composite CDS View that provides data about "Old and New Allocation Types" in SAP S/4HANA. It reads from 2 data sources (dd07t, dd07t) and exposes 6 fields with key fields AllocationPostingType, AllocationPostingTypeContext, AllocationPostingTypeContext. Part of development package ODATA_WHERE_USED_STAT_KEY_FIG.

Data Sources (2)

SourceAliasJoin Type
dd07t dd07t from
dd07t dd07t union

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ISKFWHEREUSDAT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Old and New Allocation Types view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #META view
ClientHandling.algorithm #SESSION_VARIABLE view
UI.textArrangement #TEXT_LAST view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY AllocationPostingType domvalue_l Lower Value
KEY AllocationPostingTypeContext
Language ddlanguage Lang.
KEY AllocationPostingTypeContext
Language ddlanguage Lang.
AllocationPostingTypeText ddtext Short text

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_StatKeyFigWhereUsedAllocType.
-- 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: ISKFWHEREUSDAT

CREATE VIEW I_StatKeyFigWhereUsedAllocType AS
SELECT
  domvalue_l AS AllocationPostingType,
  'O' AS AllocationPostingTypeContext,
  ddlanguage AS Language,
  ddtext AS AllocationPostingTypeText
FROM dd07t
-- UNION with additional select branch(es): dd07t
;

Learn More