I_APSRsceCapByAORCube

DDL: I_APSRSCECAPBYAORCUBE Type: view_entity COMPOSITE
37 Fields 1 Data Sources 8 Associations

Resource Capacity by AOR - Cube

I_APSRsceCapByAORCube is a Composite CDS View (Cube) that provides data about "Resource Capacity by AOR - Cube" in SAP S/4HANA. It reads from 1 data source (P_APSRsceCapByAOR) and exposes 37 fields with key fields AdvncdPlngPlanningVersion, SimulationSessionUUID, AdvncdPlngResourceID, FactoryCalendarDate. It has 8 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_APSRsceCapByAOR P_APSRsceCapByAOR from

Parameters (3)

NameTypeDefault
P_StartDate vdm_v_start_date
P_EndDate vdm_v_end_date
P_TimeZoneID tznzone

Associations (8)

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
[1..1] I_CalendarDate _CalendarDate _CalendarDate.CalendarDate = rc.FactoryCalendarDate
[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 (12)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Resource Capacity by AOR - Cube view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
ObjectModel.modelingPattern #ANALYTICAL_CUBE view
Metadata.allowExtensions true view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY AdvncdPlngPlanningVersion rc AdvncdPlngPlanningVersion
KEY SimulationSessionUUID rc SimulationSessionUUID Sim. Session
KEY AdvncdPlngResourceID rc AdvncdPlngResourceID Internal Resrce
KEY FactoryCalendarDate rc FactoryCalendarDate
YearQuarter _CalendarDate YearQuarter Year Quarter
YearMonth _CalendarDate YearMonth Year Month
FirstDayOfWeekDate _CalendarDate FirstDayOfWeekDate First day of week date
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_APSRsceCapByAORCube.
-- 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_APSRsceCapByAORCube AS
SELECT
  rc.AdvncdPlngPlanningVersion AS AdvncdPlngPlanningVersion,
  rc.SimulationSessionUUID AS SimulationSessionUUID,
  rc.AdvncdPlngResourceID AS AdvncdPlngResourceID,
  rc.FactoryCalendarDate AS FactoryCalendarDate,
  _CalendarDate.YearQuarter AS YearQuarter,
  _CalendarDate.YearMonth AS YearMonth,
  _CalendarDate.FirstDayOfWeekDate AS FirstDayOfWeekDate,
  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_APSRsceCapByAOR
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_CalendarDate AS _CalendarDate ON _CalendarDate.CalendarDate = rc.FactoryCalendarDate  -- association [1..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