P_WorkCenterCapacityBase

DDL: P_WORKCENTERCAPACITYBASE SQL: PWCCAPBASE Type: view COMPOSITE
33 Fields 1 Data Sources

P_WorkCenterCapacityBase is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_Capacity) and exposes 33 fields with key field CapacityInternalID.

Data Sources (1)

SourceAliasJoin Type
I_Capacity I_Capacity from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PWCCAPBASE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE 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.
-- SQL view name: PWCCAPBASE

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