R_OIL_LocSiteControlParamD

DDL: R_OIL_LOCSITECONTROLPARAMD Type: view_entity BASIC
61 Fields 1 Data Sources

Location Site Control Parameter - Draft

R_OIL_LocSiteControlParamD is a Basic CDS View that provides data about "Location Site Control Parameter - Draft" in SAP S/4HANA. It reads from 1 data source (oiiscpbl_d) and exposes 61 fields with key fields BusinessLocationIdentifier, RetailNetworkBusinessType, ProcessBusinessPartnerRole, DraftUUID.

Data Sources (1)

SourceAliasJoin Type
oiiscpbl_d oiiscpbl_d from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
EndUserText.label Location Site Control Parameter - Draft view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (61)

KeyFieldSource TableSource FieldDescription
KEY BusinessLocationIdentifier businesslocationidentifier Location ID
KEY RetailNetworkBusinessType retailnetworkbusinesstype Business type
KEY ProcessBusinessPartnerRole processbusinesspartnerrole Partner role
KEY DraftUUID draftuuid UUID
ParentDraftUUID parentdraftuuid NodeID
SiteSalesCalendar sitesalescalendar Site sales cal.
SalesHourSet saleshourset Sales hour set
MondayMorningOpeningTime mondaymorningopeningtime Monday
MondayMorningClosingTime mondaymorningclosingtime Monday
MondayAfternoonOpeningTime mondayafternoonopeningtime Monday
MondayAfternoonClosingTime mondayafternoonclosingtime Monday
TuesdayMorningOpeningTime tuesdaymorningopeningtime Tuesday
TuesdayMorningClosingTime tuesdaymorningclosingtime Tuesday
TuesdayAfternoonOpeningTime tuesdayafternoonopeningtime Tuesday
TuesdayAfternoonClosingTime tuesdayafternoonclosingtime Tuesday
WednesdayMorningOpeningTime wednesdaymorningopeningtime Wednesday
WednesdayMorningClosingTime wednesdaymorningclosingtime Wednesday
WednesdayAfternoonOpeningTime wednesdayafternoonopeningtime Wednesday
WednesdayAfternoonClosingTime wednesdayafternoonclosingtime Wednesday
ThursdayMorningOpeningTime thursdaymorningopeningtime Thursday
ThursdayMorningClosingTime thursdaymorningclosingtime Thursday
ThursdayAfternoonOpeningTime thursdayafternoonopeningtime Thursday
ThursdayAfternoonClosingTime thursdayafternoonclosingtime Thursday
FridayMorningOpeningTime fridaymorningopeningtime Friday
FridayMorningClosingTime fridaymorningclosingtime Friday
FridayAfternoonOpeningTime fridayafternoonopeningtime Friday
FridayAfternoonClosingTime fridayafternoonclosingtime Friday
SaturdayMorningOpeningTime saturdaymorningopeningtime Saturday
SaturdayMorningClosingTime saturdaymorningclosingtime Saturday
SaturdayAfternoonOpeningTime saturdayafternoonopeningtime Saturday
SaturdayAfternoonClosingTime saturdayafternoonclosingtime Saturday
SundayMorningOpeningTime sundaymorningopeningtime Sunday
SundayMorningClosingTime sundaymorningclosingtime Sunday
SundayAfternoonOpeningTime sundayafternoonopeningtime Sunday
SundayAfternoonClosingTime sundayafternoonclosingtime Sunday
HolidayMorningOpeningTime holidaymorningopeningtime Hol.:begin 1
HolidayMorningClosingTime holidaymorningclosingtime Hol.:end 1
HolidayAfternoonOpeningTime holidayafternoonopeningtime Hol.:begin 2
HolidayAfternoonClosingTime holidayafternoonclosingtime Hol.:end 2
CreationDate creationdate Time Stamp
CreationTime creationtime Time of Change
CreatedByUser createdbyuser User Name
LastChangeDate lastchangedate Time Stamp
LastChangeTime lastchangetime Time changed
LastChangedByUser lastchangedbyuser User Name
EntityIsBlocked entityisblocked Blocking ind.
EntityIsMarkedForDeletion entityismarkedfordeletion Will be Deleted
SalesHoursAreBlocked saleshoursareblocked Block sls.hrs.
UseOfLeadTimeEntriesIsBlocked useofleadtimeentriesisblocked Block ld.times
SalesOrderEntryDefaultGroup salesorderentrydefaultgroup SOE default grp
DefaultPartnerRole defaultpartnerrole Def.prtnr.role
DeliveryCsgnmtStockRcvgPlant deliverycsgnmtstockrcvgplant Consign StkPlnt
DeliveryCsgnmtStockRcvgStorLoc deliverycsgnmtstockrcvgstorloc Consign StkSLoc
AutomReplenishmentIsBlocked automreplenishmentisblocked Block rpln.calc
DispatchOptimizationIsBlocked dispatchoptimizationisblocked Block dispOpt
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE
DraftFieldChanges draftfieldchanges Field Changes

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 R_OIL_LocSiteControlParamD.
-- 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 R_OIL_LocSiteControlParamD AS
SELECT
  BusinessLocationIdentifier,
  RetailNetworkBusinessType,
  ProcessBusinessPartnerRole,
  DraftUUID,
  ParentDraftUUID,
  SiteSalesCalendar,
  SalesHourSet,
  MondayMorningOpeningTime,
  MondayMorningClosingTime,
  MondayAfternoonOpeningTime,
  MondayAfternoonClosingTime,
  TuesdayMorningOpeningTime,
  TuesdayMorningClosingTime,
  TuesdayAfternoonOpeningTime,
  TuesdayAfternoonClosingTime,
  WednesdayMorningOpeningTime,
  WednesdayMorningClosingTime,
  WednesdayAfternoonOpeningTime,
  WednesdayAfternoonClosingTime,
  ThursdayMorningOpeningTime,
  ThursdayMorningClosingTime,
  ThursdayAfternoonOpeningTime,
  ThursdayAfternoonClosingTime,
  FridayMorningOpeningTime,
  FridayMorningClosingTime,
  FridayAfternoonOpeningTime,
  FridayAfternoonClosingTime,
  SaturdayMorningOpeningTime,
  SaturdayMorningClosingTime,
  SaturdayAfternoonOpeningTime,
  SaturdayAfternoonClosingTime,
  SundayMorningOpeningTime,
  SundayMorningClosingTime,
  SundayAfternoonOpeningTime,
  SundayAfternoonClosingTime,
  HolidayMorningOpeningTime,
  HolidayMorningClosingTime,
  HolidayAfternoonOpeningTime,
  HolidayAfternoonClosingTime,
  CreationDate,
  CreationTime,
  CreatedByUser,
  LastChangeDate,
  LastChangeTime,
  LastChangedByUser,
  EntityIsBlocked,
  EntityIsMarkedForDeletion,
  SalesHoursAreBlocked,
  UseOfLeadTimeEntriesIsBlocked,
  SalesOrderEntryDefaultGroup,
  DefaultPartnerRole,
  DeliveryCsgnmtStockRcvgPlant,
  DeliveryCsgnmtStockRcvgStorLoc,
  AutomReplenishmentIsBlocked,
  DispatchOptimizationIsBlocked,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM oiiscpbl_d
;

Learn More