P_WorkCenterCapacityBase

DDL: P_WORKCENTERCAPACITYBASE Type: view_entity COMPOSITE Package: ODATA_PP_WORKCENTER_API
33 Fields 1 Data Sources

Work Center Capacity Base

P_WorkCenterCapacityBase is a Composite CDS View that provides data about "Work Center Capacity Base" in SAP S/4HANA. It reads from 1 data source (I_Capacity) and exposes 33 fields with key field CapacityInternalID. Part of development package ODATA_PP_WORKCENTER_API.

Data Sources (1)

SourceAliasJoin Type
I_Capacity I_Capacity from

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY CapacityInternalID CapacityInternalID Capacity ID
Capacity Capacity Engine Capacity
CapacityCategoryCode CapacityCategoryCode
CapacityActiveVersion CapacityActiveVersion RA Version
CapacityIsFinite CapacityIsFinite Finite Scheduling
CapacityIsPooled CapacityIsPooled Pooled Capacity
CapacityHasIndivCapacities CapacityHasIndivCapacities Individ. Capacities
CapacityIsExcldFrmLongTermPlng CapacityIsExcldFrmLongTermPlng No LongTerm Planning
CapacityNumberOfCapacities CapacityNumberOfCapacities Number
CapacityResponsiblePlanner CapacityResponsiblePlanner Plng Segmnt No.
CapacityPlanUtilizationPercent CapacityPlanUtilizationPercent Utilization
CapacityBreakDuration CapacityBreakDuration Break Length
CapIsUsedInMultiOperations CapIsUsedInMultiOperations
ReferencedCapacityInternalID ReferencedCapacityInternalID
CapOverloadThresholdInPercent CapOverloadThresholdInPercent Overload (%)
Plant Plant Valuation Area
FactoryCalendar FactoryCalendar Factory Calendar
AuthorizationGroup AuthorizationGroup AuthorizGroup
ShiftGroup ShiftGroup Shift Grouping
CapacityStartTime CapacityStartTime Start Time
CapacityEndTime CapacityEndTime End Time
CapacityQuantityUnit CapacityQuantityUnit Capacity Unit
CapacityBaseQtyUnit CapacityBaseQtyUnit Valuation Unit
CapacityLastChangeDateTime CapacityLastChangeDateTime
_Capacity _Capacity
_CapacityBaseQtyUnit _CapacityBaseQtyUnit
_CapacityCategory _CapacityCategory
_CapacityQuantityUnit _CapacityQuantityUnit
_CapacityResponsiblePlanner _CapacityResponsiblePlanner
_FactoryCalendar _FactoryCalendar
_Plant _Plant
_ShiftGrouping _ShiftGrouping
_Text _Text

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 P_WorkCenterCapacityBase.
-- 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 P_WorkCenterCapacityBase AS
SELECT
  CapacityInternalID,
  Capacity,
  CapacityCategoryCode,
  CapacityActiveVersion,
  CapacityIsFinite,
  CapacityIsPooled,
  CapacityHasIndivCapacities,
  CapacityIsExcldFrmLongTermPlng,
  CapacityNumberOfCapacities,
  CapacityResponsiblePlanner,
  CapacityPlanUtilizationPercent,
  CapacityBreakDuration,
  CapIsUsedInMultiOperations,
  ReferencedCapacityInternalID,
  CapOverloadThresholdInPercent,
  Plant,
  FactoryCalendar,
  AuthorizationGroup,
  ShiftGroup,
  CapacityStartTime,
  CapacityEndTime,
  CapacityQuantityUnit,
  CapacityBaseQtyUnit,
  CapacityLastChangeDateTime
FROM I_Capacity
;

Learn More