C_RSHWorkCenterNonWrkgTmeIntvl

DDL: C_RSHWORKCENTERNONWRKGTMEINTVL SQL: CRSHNONWRKGINT Type: view CONSUMPTION
14 Fields 1 Data Sources

Non working time interval for work centers

C_RSHWorkCenterNonWrkgTmeIntvl is a Consumption CDS View that provides data about "Non working time interval for work centers" in SAP S/4HANA. It reads from 1 data source (P_RSHWorkCenterNonWrkgTmeIntvl) and exposes 14 fields with key fields WorkCenterInternalID, WorkCenterTypeCode, CapacityInternalID, CalendarDate, MaintSchedSimlnUUID.

Data Sources (1)

SourceAliasJoin Type
P_RSHWorkCenterNonWrkgTmeIntvl NonWorkingDays from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CRSHNONWRKGINT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Non working time interval for work centers view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID WorkCenterInternalID Work Center
KEY WorkCenterTypeCode WorkCenterTypeCode Object Type
KEY CapacityInternalID CapacityInternalID Capacity ID
KEY CalendarDate CalendarDate Calendar Date
KEY MaintSchedSimlnUUID MaintSchedSimlnUUID UUID
KEY MaintSchedSimulationStartDate MaintSchedSimulationStartDate Start Date
KEY MaintSchedSimulationEndDate MaintSchedSimulationEndDate End Date
KEY WorkCenterNonAvailStrtDteTme WorkCenterNonAvailStrtDteTme
WorkCenterNonAvailEndDteTme WorkCenterNonAvailEndDteTme
ValidityStartDateTime
ValidityEndDateTime
WorkCenter P_RSHWorkCenterNonWrkgTmeIntvl WorkCenter Work Center
WorkCenterCategoryCode WorkCenterCategoryCode
Plant Plant Valuation Area

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 C_RSHWorkCenterNonWrkgTmeIntvl.
-- 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: CRSHNONWRKGINT

CREATE VIEW C_RSHWorkCenterNonWrkgTmeIntvl AS
SELECT
  WorkCenterInternalID,
  WorkCenterTypeCode,
  CapacityInternalID,
  CalendarDate,
  MaintSchedSimlnUUID,
  MaintSchedSimulationStartDate,
  MaintSchedSimulationEndDate,
  WorkCenterNonAvailStrtDteTme,
  WorkCenterNonAvailEndDteTme,
  cast(dats_tims_to_tstmp( MaintSchedSimulationStartDate,cast('000000' as tims),abap_system_timezone( $session.client,'NULL'),$session.client,'NULL') as timestamp preserving type) AS ValidityStartDateTime,
  cast(dats_tims_to_tstmp( MaintSchedSimulationEndDate,cast('235959' as tims),abap_system_timezone( $session.client,'NULL'),$session.client,'NULL') as timestamp preserving type) AS ValidityEndDateTime,
  NonWorkingDays.WorkCenter AS WorkCenter,
  WorkCenterCategoryCode,
  Plant
FROM P_RSHWorkCenterNonWrkgTmeIntvl AS NonWorkingDays
;

Learn More