R_OIL_LocSiteControlParamTP

DDL: R_OIL_LOCSITECONTROLPARAMTP Type: view_entity TRANSACTIONAL
63 Fields 1 Data Sources

Business Loc Site Control Parameter - TP

R_OIL_LocSiteControlParamTP is a Transactional CDS View that provides data about "Business Loc Site Control Parameter - TP" in SAP S/4HANA. It reads from 1 data source (I_OIL_LocSiteControlParam) and exposes 63 fields with key fields BusinessLocationIdentifier, RetailNetworkBusinessType, ProcessBusinessPartnerRole.

Data Sources (1)

SourceAliasJoin Type
I_OIL_LocSiteControlParam I_OIL_LocSiteControlParam from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Business Loc Site Control Parameter - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (63)

KeyFieldSource TableSource FieldDescription
KEY BusinessLocationIdentifier BusinessLocationIdentifier Location ID
KEY RetailNetworkBusinessType RetailNetworkBusinessType Business type
KEY ProcessBusinessPartnerRole ProcessBusinessPartnerRole Partner role
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
_BusinessLocation _BusinessLocation
_BusinessPartnerRoleVH _BusinessPartnerRoleVH
_BusinessTypeVH _BusinessTypeVH
_DefaultPartnerRoleVH _DefaultPartnerRoleVH
_FactoryCalendar _FactoryCalendar
_Plant _Plant
_SlsOrdEntryDfltGroupVH _SlsOrdEntryDfltGroupVH
_SteCtrlParamSlsHrSetVH _SteCtrlParamSlsHrSetVH
_StorageLocation _StorageLocation
_BusinessLocationTP _BusinessLocationTP

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_LocSiteControlParamTP.
-- 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_LocSiteControlParamTP AS
SELECT
  BusinessLocationIdentifier,
  RetailNetworkBusinessType,
  ProcessBusinessPartnerRole,
  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
FROM I_OIL_LocSiteControlParam
;

Learn More