I_CapChgBackgroundJobIntvlShft

DDL: I_CAPCHGBACKGROUNDJOBINTVLSHFT SQL: ICAPBGJINVSHF Type: view_entity BASIC
16 Fields 1 Data Sources

Capacity Mass Change Background Job Interval Shifts

I_CapChgBackgroundJobIntvlShft is a Basic CDS View that provides data about "Capacity Mass Change Background Job Interval Shifts" in SAP S/4HANA. It reads from 1 data source (ppcapmcbgjinvshf) and exposes 16 fields with key fields BackgroundJobUUID, IntervalEndDate, WeekDay, AvailableCapacityShift.

Data Sources (1)

SourceAliasJoin Type
ppcapmcbgjinvshf ppcapmcbgjinvshf from

Annotations (10)

NameValueLevelField
ObjectModel.representativeKey AvailableCapacityShift view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #BASIC view
Metadata.allowExtensions true view
EndUserText.label Capacity Mass Change Background Job Interval Shifts view
Analytics.technicalName ICAPBGJINVSHF view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY BackgroundJobUUID guid UUID 22 char.
KEY IntervalEndDate datub Valid to
KEY WeekDay
KEY AvailableCapacityShift schnr Capacity Shift
IntervalStartDate datuv Valid-from date
WorkDayRule fabtg Workdays
AvailableCapacityIntervalDurn anztg Number of days
ShiftSequence sprog Shift Sequence
ShiftDefinition tprog Shift Definition
ShiftStartTime begzt Start Time
ShiftEndTime endzt End Time
CapacityBreakDuration pause Break Length
CapacityPlanUtilizationPercent ngrad Utilization
CapacityNumberOfCapacities anzhl Standard Pct.
CapacityChangeIsInterval isinterval TRUE
CapacityIntervalIsDeleted isdeleted TRUE

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_CapChgBackgroundJobIntvlShft.
-- 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: ICAPBGJINVSHF

CREATE VIEW I_CapChgBackgroundJobIntvlShft AS
SELECT
  guid AS BackgroundJobUUID,
  datub AS IntervalEndDate,
  cast(substring ( tagnr, 3, 1) as vdm_weekday) AS WeekDay,
  schnr AS AvailableCapacityShift,
  datuv AS IntervalStartDate,
  fabtg AS WorkDayRule,
  anztg AS AvailableCapacityIntervalDurn,
  sprog AS ShiftSequence,
  tprog AS ShiftDefinition,
  begzt AS ShiftStartTime,
  endzt AS ShiftEndTime,
  pause AS CapacityBreakDuration,
  ngrad AS CapacityPlanUtilizationPercent,
  anzhl AS CapacityNumberOfCapacities,
  isinterval AS CapacityChangeIsInterval,
  isdeleted AS CapacityIntervalIsDeleted
FROM ppcapmcbgjinvshf
;

Learn More