I_OIL_SteCtrlParamSlsHrSetVH

DDL: I_OIL_STECTRLPARAMSLSHRSETVH Type: view_entity BASIC
34 Fields 1 Data Sources 1 Associations

SCP Sales Hour Sets

I_OIL_SteCtrlParamSlsHrSetVH is a Basic CDS View that provides data about "SCP Sales Hour Sets" in SAP S/4HANA. It reads from 1 data source (oiiscpsh) and exposes 34 fields with key field SalesHourSet. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
oiiscpsh oiiscpsh from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_OIL_SteCtrlParamSlsHrSetTxt _Text _Text.SalesHourSet = $projection.SalesHourSet

Annotations (11)

NameValueLevelField
AbapCatalog.entityBuffer.definitionAllowed true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label SCP Sales Hour Sets view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.representativeKey SalesHourSet view
ObjectModel.dataCategory #VALUE_HELP view
VDM.viewType #BASIC view
Search.searchable true view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY SalesHourSet vkfsid Sales hour set
MondayMorningOpeningTime w11bos Mon.:begin 1
MondayMorningClosingTime w11eos Mon.:end 1
MondayAfternoonOpeningTime w12bos Mon.:begin 2
MondayAfternoonClosingTime w12eos Mon. end 2
TuesdayMorningOpeningTime w21bos Tue.:begin 1
TuesdayMorningClosingTime w21eos Tue.:end 1
TuesdayAfternoonOpeningTime w22bos Tue.:begin 2
TuesdayAfternoonClosingTime w22eos Tue.:end 2
WednesdayMorningOpeningTime w31bos Wed.:begin 1
WednesdayMorningClosingTime w31eos Wed.:end 1
WednesdayAfternoonOpeningTime w32bos Wed.:begin 2
WednesdayAfternoonClosingTime w32eos Wed.:end 2
ThursdayMorningOpeningTime w41bos Thu.:begin 1
ThursdayMorningClosingTime w41eos Thu.:end 1
ThursdayAfternoonOpeningTime w42bos Thu.:begin 2
ThursdayAfternoonClosingTime w42eos Thu.:end 2
FridayMorningOpeningTime w51bos Fri.:begin 1
FridayMorningClosingTime w51eos Fri.:end 1
FridayAfternoonOpeningTime w52bos Fri.:begin 2
FridayAfternoonClosingTime w52eos Fri.:end 2
SaturdayMorningOpeningTime w61bos Sat.:begin 1
SaturdayMorningClosingTime w61eos Sat.:end 1
SaturdayAfternoonOpeningTime w62bos Sat.:begin 2
SaturdayAfternoonClosingTime w62eos Sat.:end 2
SundayMorningOpeningTime w71bos Sun.:begin 1
SundayMorningClosingTime w71eos Sun.:end 1
SundayAfternoonOpeningTime w72bos Sun.:begin 2
SundayAfternoonClosingTime w72eos Sun.:end 2
HolidayMorningOpeningTime w81bos Hol.:begin 1
HolidayMorningClosingTime w81eos Hol.:end 1
HolidayAfternoonOpeningTime w82bos Hol.:begin 2
HolidayAfternoonClosingTime w82eos Hol.:end 2
_Text _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_OIL_SteCtrlParamSlsHrSetVH.
-- 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.

CREATE VIEW I_OIL_SteCtrlParamSlsHrSetVH AS
SELECT
  vkfsid AS SalesHourSet,
  w11bos AS MondayMorningOpeningTime,
  w11eos AS MondayMorningClosingTime,
  w12bos AS MondayAfternoonOpeningTime,
  w12eos AS MondayAfternoonClosingTime,
  w21bos AS TuesdayMorningOpeningTime,
  w21eos AS TuesdayMorningClosingTime,
  w22bos AS TuesdayAfternoonOpeningTime,
  w22eos AS TuesdayAfternoonClosingTime,
  w31bos AS WednesdayMorningOpeningTime,
  w31eos AS WednesdayMorningClosingTime,
  w32bos AS WednesdayAfternoonOpeningTime,
  w32eos AS WednesdayAfternoonClosingTime,
  w41bos AS ThursdayMorningOpeningTime,
  w41eos AS ThursdayMorningClosingTime,
  w42bos AS ThursdayAfternoonOpeningTime,
  w42eos AS ThursdayAfternoonClosingTime,
  w51bos AS FridayMorningOpeningTime,
  w51eos AS FridayMorningClosingTime,
  w52bos AS FridayAfternoonOpeningTime,
  w52eos AS FridayAfternoonClosingTime,
  w61bos AS SaturdayMorningOpeningTime,
  w61eos AS SaturdayMorningClosingTime,
  w62bos AS SaturdayAfternoonOpeningTime,
  w62eos AS SaturdayAfternoonClosingTime,
  w71bos AS SundayMorningOpeningTime,
  w71eos AS SundayMorningClosingTime,
  w72bos AS SundayAfternoonOpeningTime,
  w72eos AS SundayAfternoonClosingTime,
  w81bos AS HolidayMorningOpeningTime,
  w81eos AS HolidayMorningClosingTime,
  w82bos AS HolidayAfternoonOpeningTime,
  w82eos AS HolidayAfternoonClosingTime
FROM oiiscpsh
LEFT OUTER JOIN I_OIL_SteCtrlParamSlsHrSetTxt AS _Text ON _Text.SalesHourSet = SalesHourSet  -- association [0..*]
;

Learn More