I_CapacityChgBackgroundJobHdr

DDL: I_CAPACITYCHGBACKGROUNDJOBHDR SQL: ICAPCHBGJ Type: view_entity BASIC
28 Fields 1 Data Sources

Capacity Mass Change Background Job Header

I_CapacityChgBackgroundJobHdr is a Basic CDS View that provides data about "Capacity Mass Change Background Job Header" in SAP S/4HANA. It reads from 1 data source (ppcapmcbgjhdr) and exposes 28 fields with key field BackgroundJobUUID.

Data Sources (1)

SourceAliasJoin Type
ppcapmcbgjhdr ppcapmcbgjhdr from

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey BackgroundJobUUID 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
EndUserText.label Capacity Mass Change Background Job Header view
Metadata.allowExtensions true view
Analytics.technicalName ICAPCHBGJ view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY BackgroundJobUUID guid UUID 22 char.
CapacityUpdateIsMassChange mass_maint TRUE
RecurrenceRepeat recurrencerepeat Recurrence Repeat
NumberOfRecurrenceInterval recurrenceinterval Recurrence Interval
RecurrenceDayOfMonth recurrencedayofmonth RecurrenceDayofMonth
RecurrenceWeekDayOrderOfMonth recurrenceweekofmonth Recurrence week of M
IntervalHasWeekDay1 day1 TRUE
IntervalHasWeekDay2 day2 TRUE
IntervalHasWeekDay3 day3 TRUE
IntervalHasWeekDay4 day4 TRUE
IntervalHasWeekDay5 day5 TRUE
IntervalHasWeekDay6 day6 TRUE
IntervalHasWeekDay7 day7 TRUE
IntervalHasCapacityHeaderVals usehdrvalues TRUE
BackgroundJobName jobname Name of Send Process
BackgroundJob jobcount Job number
ApplicationJobDescription appllogextid External ID
BackgroundJobChangedDateTime creationts CreationTS
JobProcessingMode jobmode Processing Mode
CapacityHeaderHasUpdate caphdrupd TRUE
IntervalHasExistingUtilization iskeepexstingutilization TRUE
CapacityPlanUtilizationPercent utilization Utilization
IntvlHasExistingNmbrOfCap iskeepexistingcapacity TRUE
CapacityNumberOfCapacities numberofcapacity Number
CalendarWeek calendarweek Calendar Week
CalendarYear calendaryear Year
CalendarMonth calendarmonth Calendar Month
PreviewCapacityChgsMonthThld preview_till_months 3-Byte field

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_CapacityChgBackgroundJobHdr.
-- 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: ICAPCHBGJ

CREATE VIEW I_CapacityChgBackgroundJobHdr AS
SELECT
  guid AS BackgroundJobUUID,
  mass_maint AS CapacityUpdateIsMassChange,
  RecurrenceRepeat,
  recurrenceinterval AS NumberOfRecurrenceInterval,
  RecurrenceDayOfMonth,
  recurrenceweekofmonth AS RecurrenceWeekDayOrderOfMonth,
  day1 AS IntervalHasWeekDay1,
  day2 AS IntervalHasWeekDay2,
  day3 AS IntervalHasWeekDay3,
  day4 AS IntervalHasWeekDay4,
  day5 AS IntervalHasWeekDay5,
  day6 AS IntervalHasWeekDay6,
  day7 AS IntervalHasWeekDay7,
  usehdrvalues AS IntervalHasCapacityHeaderVals,
  jobname AS BackgroundJobName,
  jobcount AS BackgroundJob,
  appllogextid AS ApplicationJobDescription,
  creationts AS BackgroundJobChangedDateTime,
  jobmode AS JobProcessingMode,
  caphdrupd AS CapacityHeaderHasUpdate,
  iskeepexstingutilization AS IntervalHasExistingUtilization,
  utilization AS CapacityPlanUtilizationPercent,
  iskeepexistingcapacity AS IntvlHasExistingNmbrOfCap,
  numberofcapacity AS CapacityNumberOfCapacities,
  CalendarWeek,
  CalendarYear,
  CalendarMonth,
  preview_till_months AS PreviewCapacityChgsMonthThld
FROM ppcapmcbgjhdr
;

Learn More