A_WorkCenterPooledCapacity

DDL: A_WORKCENTERPOOLEDCAPACITY Type: view_entity CONSUMPTION
24 Fields 1 Data Sources 1 OData Services

Pooled Capacity for Work Center

A_WorkCenterPooledCapacity is a Consumption CDS View that provides data about "Pooled Capacity for Work Center" in SAP S/4HANA. It reads from 1 data source (R_WorkCenterPooledCapacityTP) and exposes 24 fields with key field CapacityInternalID. It is exposed through 1 OData service (API_WORKCENTERPOOLEDCAPACITY).

Data Sources (1)

SourceAliasJoin Type
R_WorkCenterPooledCapacityTP R_WorkCenterPooledCapacityTP projection

Annotations (8)

NameValueLevelField
EndUserText.label Pooled Capacity for Work Center view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
API_WORKCENTERPOOLEDCAPACITY API_WRKCTRPOOLEDCAPACITY V4 C2 C1

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY CapacityInternalID CapacityInternalID Capacity ID
Plant Plant Valuation Area
Capacity Capacity Engine Capacity
CapacityCategoryCode CapacityCategoryCode
CapacityActiveVersion CapacityActiveVersion
CapacityIsFinite CapacityIsFinite
CapacityIsPooled CapacityIsPooled
CapacityHasIndivCapacities CapacityHasIndivCapacities
CapacityIsExcldFrmLongTermPlng CapacityIsExcldFrmLongTermPlng
CapacityNumberOfCapacities CapacityNumberOfCapacities
CapacityResponsiblePlanner CapacityResponsiblePlanner
CapacityPlanUtilizationPercent CapacityPlanUtilizationPercent
CapacityBreakDuration CapacityBreakDuration
CapIsUsedInMultiOperations CapIsUsedInMultiOperations
ReferencedCapacityInternalID ReferencedCapacityInternalID
CapOverloadThresholdInPercent CapOverloadThresholdInPercent
FactoryCalendar FactoryCalendar Factory Calendar
AuthorizationGroup AuthorizationGroup AuthorizGroup
ShiftGroup ShiftGroup Shift Grouping
CapacityStartTimeID CapacityStartTimeID
CapacityEndTimeID CapacityEndTimeID
CapacityQuantityUnit CapacityQuantityUnit
CapacityBaseQtyUnit CapacityBaseQtyUnit
CapacityLastChangeDateTime CapacityLastChangeDateTime

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

Learn More