I_SchedProdnSchedgDrctn

DDL: I_SCHEDPRODNSCHEDGDRCTN SQL: ISHPDSHGDRCTN Type: view BASIC

ValueHelp for Scheduling Direction

I_SchedProdnSchedgDrctn is a Basic CDS View that provides data about "ValueHelp for Scheduling Direction" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 1 field with key field SchedulingDirection. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
dd07l dd07l from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_SchedProdnSchedgDrctnText _schedprodnschedgdrctntxt $projection.SchedulingDirection = _schedprodnschedgdrctntxt.SchedulingDirection

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ISHPDSHGDRCTN view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label ValueHelp for Scheduling Direction view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY SchedulingDirection Lower Value

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_SchedProdnSchedgDrctn.
-- 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: ISHPDSHGDRCTN

CREATE VIEW I_SchedProdnSchedgDrctn AS
SELECT
  cast( domvalue_l as pph_cfs_sch_schedg_drctn) AS SchedulingDirection
FROM dd07l
LEFT OUTER JOIN I_SchedProdnSchedgDrctnText AS _schedprodnschedgdrctntxt ON SchedulingDirection = _schedprodnschedgdrctntxt.SchedulingDirection  -- association [0..*]
;