I_APSResourceCapacityByFilter

DDL: I_APSRESOURCECAPACITYBYFILTER Type: view_entity COMPOSITE
34 Fields 1 Data Sources 7 Associations

Resource Capacity By Filters

I_APSResourceCapacityByFilter is a Composite CDS View that provides data about "Resource Capacity By Filters" in SAP S/4HANA. It reads from 1 data source (P_APSRsceCapByFltr) and exposes 34 fields with key fields AdvncdPlngPlanningVersion, SimulationSessionUUID, AdvncdPlngResourceID, FactoryCalendarDate. It has 7 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_APSRsceCapByFltr P_APSRsceCapByFltr from

Parameters (3)

NameTypeDefault
P_StartDate vdm_v_start_date
P_EndDate vdm_v_end_date
P_TimeZoneID tznzone

Associations (7)

CardinalityTargetAliasCondition
[0..1] I_APSResource _Resource _Resource.AdvncdPlngResourceID = rc.AdvncdPlngResourceID and _Resource.AdvncdPlngPlanningVersion = rc.AdvncdPlngPlanningVersion and _Resource.SimulationSessionUUID = rc.ResourceSimulationSessionUUID
[0..1] I_APSPlanVersion _PlanningVersion _PlanningVersion.AdvncdPlngPlanningVersion = rc.AdvncdPlngPlanningVersion
[0..1] I_APSSimulationSession _SimulationSession _SimulationSession.SimulationSessionUUID = rc.SimulationSessionUUID
[0..1] I_APSSimulationSession _RsceSimSession _RsceSimSession.SimulationSessionUUID = rc.ResourceSimulationSessionUUID
[0..*] I_APSPlanningModelText _ModelText _ModelText.PlanningModel = rc.PlanningModel
[0..*] I_LocationText _LocationText _LocationText.LocationUUID = $projection.locationuuid
[0..*] I_AdvncdPlngResourceGroupTxt _ResourceGroupText _ResourceGroupText.ResourceGroup = $projection.resourcegroup

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Resource Capacity By Filters view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
Metadata.allowExtensions true view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY AdvncdPlngPlanningVersion rc AdvncdPlngPlanningVersion
KEY SimulationSessionUUID rc SimulationSessionUUID Sim. Session
KEY AdvncdPlngResourceID rc AdvncdPlngResourceID Internal Resrce
KEY FactoryCalendarDate rc FactoryCalendarDate
PlanningModel rc PlanningModel
PlanningVersionExternal rc PlanningVersionExternal
AdvncdPlngResourceName _Resource AdvncdPlngResourceName Resource
ResourceType _Resource ResourceType
AdvncdPlngRsceUoM _Resource AdvncdPlngRsceUoM
ResourceCategory _Resource ResourceCategory
Location _Resource ResourceHomeLocation
LocationUUID _Resource LocationUUID UUID
LocationType _Resource LocationType Location Type
AdvncdPlngRsceUtilznCapUnit rc AdvncdPlngRsceUtilznCapUnit
TotalAvailableResourceCapDurn rc TotalAvailableResourceCapDurn
TotalConsumedResourceCapDurn rc TotalConsumedResourceCapDurn
FreeResourceCapDurn rc FreeResourceCapDurn
TotalSetupAndTeardownCapDurn rc TotalSetupAndTeardownCapDurn
TotalProductionAndQueueCapDurn rc TotalProductionAndQueueCapDurn
ResourcePlanner _Resource ResourcePlanner
ResourcePlannerName _Resource PlannerName
ResourceGroup _Resource ResourceGroup
ResourceIsBottleNeck _Resource ResourceIsBottleNeck
ResourceSortText _Resource ResourceSortText
ResourceFinitenessLevelValue _Resource ResourceFinitenessLevelValue
AdvncdPlngCapIsOverloaded rc AdvncdPlngCapIsOverloaded
ResourceSimulationSessionUUID rc ResourceSimulationSessionUUID
_Resource _Resource
_PlanningVersion _PlanningVersion
_SimulationSession _SimulationSession
_RsceSimSession _RsceSimSession
_LocationText _LocationText
_ModelText _ModelText
_ResourceGroupText _ResourceGroupText

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_APSResourceCapacityByFilter.
-- 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.
-- Parameters: P_StartDate : vdm_v_start_date, P_EndDate : vdm_v_end_date, P_TimeZoneID : tznzone

CREATE VIEW I_APSResourceCapacityByFilter AS
SELECT
  rc.AdvncdPlngPlanningVersion AS AdvncdPlngPlanningVersion,
  rc.SimulationSessionUUID AS SimulationSessionUUID,
  rc.AdvncdPlngResourceID AS AdvncdPlngResourceID,
  rc.FactoryCalendarDate AS FactoryCalendarDate,
  rc.PlanningModel AS PlanningModel,
  rc.PlanningVersionExternal AS PlanningVersionExternal,
  _Resource.AdvncdPlngResourceName AS AdvncdPlngResourceName,
  _Resource.ResourceType AS ResourceType,
  _Resource.AdvncdPlngRsceUoM AS AdvncdPlngRsceUoM,
  _Resource.ResourceCategory AS ResourceCategory,
  _Resource.ResourceHomeLocation AS Location,
  _Resource.LocationUUID AS LocationUUID,
  _Resource.LocationType AS LocationType,
  rc.AdvncdPlngRsceUtilznCapUnit AS AdvncdPlngRsceUtilznCapUnit,
  rc.TotalAvailableResourceCapDurn AS TotalAvailableResourceCapDurn,
  rc.TotalConsumedResourceCapDurn AS TotalConsumedResourceCapDurn,
  rc.FreeResourceCapDurn AS FreeResourceCapDurn,
  rc.TotalSetupAndTeardownCapDurn AS TotalSetupAndTeardownCapDurn,
  rc.TotalProductionAndQueueCapDurn AS TotalProductionAndQueueCapDurn,
  _Resource.ResourcePlanner AS ResourcePlanner,
  _Resource.PlannerName AS ResourcePlannerName,
  _Resource.ResourceGroup AS ResourceGroup,
  _Resource.ResourceIsBottleNeck AS ResourceIsBottleNeck,
  _Resource.ResourceSortText AS ResourceSortText,
  _Resource.ResourceFinitenessLevelValue AS ResourceFinitenessLevelValue,
  rc.AdvncdPlngCapIsOverloaded AS AdvncdPlngCapIsOverloaded,
  rc.ResourceSimulationSessionUUID AS ResourceSimulationSessionUUID
FROM P_APSRsceCapByFltr
LEFT OUTER JOIN I_APSResource AS _Resource ON _Resource.AdvncdPlngResourceID = rc.AdvncdPlngResourceID AND _Resource.AdvncdPlngPlanningVersion = rc.AdvncdPlngPlanningVersion AND _Resource.SimulationSessionUUID = rc.ResourceSimulationSessionUUID  -- association [0..1]
LEFT OUTER JOIN I_APSPlanVersion AS _PlanningVersion ON _PlanningVersion.AdvncdPlngPlanningVersion = rc.AdvncdPlngPlanningVersion  -- association [0..1]
LEFT OUTER JOIN I_APSSimulationSession AS _SimulationSession ON _SimulationSession.SimulationSessionUUID = rc.SimulationSessionUUID  -- association [0..1]
LEFT OUTER JOIN I_APSSimulationSession AS _RsceSimSession ON _RsceSimSession.SimulationSessionUUID = rc.ResourceSimulationSessionUUID  -- association [0..1]
LEFT OUTER JOIN I_APSPlanningModelText AS _ModelText ON _ModelText.PlanningModel = rc.PlanningModel  -- association [0..*]
LEFT OUTER JOIN I_LocationText AS _LocationText ON _LocationText.LocationUUID = locationuuid  -- association [0..*]
LEFT OUTER JOIN I_AdvncdPlngResourceGroupTxt AS _ResourceGroupText ON _ResourceGroupText.ResourceGroup = resourcegroup  -- association [0..*]
;

Learn More