C_AdvncdSchedgRsceRelshpDetsTP

DDL: C_ADVNCDSCHEDGRSCERELSHPDETSTP Type: view_entity CONSUMPTION
54 Fields 1 Data Sources 1 Associations

Resource details for ASB App

C_AdvncdSchedgRsceRelshpDetsTP is a Consumption CDS View that provides data about "Resource details for ASB App" in SAP S/4HANA. It reads from 1 data source (R_AdvncdSchedgRsceRelshpDetsTP) and exposes 54 fields with key fields AdvncdPlngResourceName, SimulationSessionUUID, AdvncdPlngTimeProfileID, PlanningVersionExternal. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_AdvncdSchedgRsceRelshpDetsTP R_AdvncdSchedgRsceRelshpDetsTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_AdvncdSchedgRsceOvrlp _ResourceOverlaps $projection.AdvncdPlngResourceName = _ResourceOverlaps.AdvncdPlngResourceName

Annotations (9)

NameValueLevelField
EndUserText.label Resource details for ASB App view
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #NONE view
VDM.viewType #CONSUMPTION view
ObjectModel.query.implementedBy ABAP:CL_ASB_RESOURCE_QUERY view

Fields (54)

KeyFieldSource TableSource FieldDescription
KEY AdvncdPlngResourceName AdvncdPlngResourceName Resource
KEY SimulationSessionUUID SimulationSessionUUID Sim. Session
KEY AdvncdPlngTimeProfileID AdvncdPlngTimeProfileID Time Profile
KEY PlanningVersionExternal PlanningVersionExternal
AdvncdPlngExternalSimlnUUID AdvncdPlngExternalSimlnUUID
AdvncdPlngResourceID AdvncdPlngResourceID Internal Resrce
AdvncdPlngApplPrflID AdvncdPlngApplPrflID
Location Location Text
SimulationSessionName SimulationSessionName
ResourcePlanner ResourcePlanner
ResourceIsBottleNeck ResourceIsBottleNeck
RsceIsRelevantForFinitePlng RsceIsRelevantForFinitePlng
ResourceCategory ResourceCategory
ProductPlanningGroup ProductPlanningGroup Planning Group
AdvancedPlanningProductName AdvancedPlanningProductName
ResourceFactoryCalendar ResourceFactoryCalendar
AdvncdPlngResourceText AdvncdPlngResourceText
ResourceGroup ResourceGroup
ResourceUtilizationPercent ResourceUtilizationPercent
ResourceOperatingTimeInHours ResourceOperatingTimeInHours
ResourceType ResourceType
UnitOfMeasure UnitOfMeasure Unit Protected Qty
ResourceTimeZone ResourceTimeZone
ResourceFinitenessLevelValue ResourceFinitenessLevelValue
StockUnit StockUnit
LocationDescription LocationDescription Current Location
UTCTimeZoneDifferenceValue UTCTimeZoneDifferenceValue
UTCDifferenceSign UTCDifferenceSign
AdvncdPlngDisplayHorizonDte AdvncdPlngDisplayHorizonDte
AdvncdPlngPlanningHorizonDte AdvncdPlngPlanningHorizonDte
OperationStatusInternalID OperationStatusInternalID
ResourceSortText ResourceSortText
AdvncdPlngRsceHasStorageCharcs AdvncdPlngRsceHasStorageCharcs
AdvncdPlngOrderInternalNumber AdvncdPlngOrderInternalNumber
AdvncdPlngOrderOperationNumber AdvncdPlngOrderOperationNumber
AdvncdPlngBottleNeckCritlty AdvncdPlngBottleNeckCritlty
AdvncdPlngRsceChildEntityFltr AdvncdPlngRsceChildEntityFltr
AdvncdPlngOperationUITaskID AdvncdPlngOperationUITaskID
ResourceCategoryText ResourceCategoryText
OperationStatusText OperationStatusText
ResourcePlannerName ResourcePlannerName
ProductPlanningGroupDesc ProductPlanningGroupDesc
AdvncdPlngIsOpsOverlapped AdvncdPlngIsOpsOverlapped
AdvncdPlngOrderID AdvncdPlngOrderID
AdvncdPlngNrOfObjectsLoaded AdvncdPlngNrOfObjectsLoaded
AdvncdPlngNrOfObjectsInTotal AdvncdPlngNrOfObjectsInTotal
AdvncdPlngConfignProfileID AdvncdPlngConfignProfileID
AdvncdPlngConfignPrflCustID AdvncdPlngConfignPrflCustID
AdvncdPlngRsceIsSeldFltr AdvncdPlngRsceIsSeldFltr
AdvncdPlngProdIsSeldFltr AdvncdPlngProdIsSeldFltr
AdvncdPlngOrdIsSeldFltr AdvncdPlngOrdIsSeldFltr
PPDSFillLevelResourceID PPDSFillLevelResourceID
PPDSRowFormatID PPDSRowFormatID
_ResourceOverlaps _ResourceOverlaps

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 C_AdvncdSchedgRsceRelshpDetsTP.
-- 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 C_AdvncdSchedgRsceRelshpDetsTP AS
SELECT
  AdvncdPlngResourceName,
  SimulationSessionUUID,
  AdvncdPlngTimeProfileID,
  PlanningVersionExternal,
  AdvncdPlngExternalSimlnUUID,
  AdvncdPlngResourceID,
  AdvncdPlngApplPrflID,
  Location,
  SimulationSessionName,
  ResourcePlanner,
  ResourceIsBottleNeck,
  RsceIsRelevantForFinitePlng,
  ResourceCategory,
  ProductPlanningGroup,
  AdvancedPlanningProductName,
  ResourceFactoryCalendar,
  AdvncdPlngResourceText,
  ResourceGroup,
  ResourceUtilizationPercent,
  ResourceOperatingTimeInHours,
  ResourceType,
  UnitOfMeasure,
  ResourceTimeZone,
  ResourceFinitenessLevelValue,
  StockUnit,
  LocationDescription,
  UTCTimeZoneDifferenceValue,
  UTCDifferenceSign,
  AdvncdPlngDisplayHorizonDte,
  AdvncdPlngPlanningHorizonDte,
  OperationStatusInternalID,
  ResourceSortText,
  AdvncdPlngRsceHasStorageCharcs,
  AdvncdPlngOrderInternalNumber,
  AdvncdPlngOrderOperationNumber,
  AdvncdPlngBottleNeckCritlty,
  AdvncdPlngRsceChildEntityFltr,
  AdvncdPlngOperationUITaskID,
  ResourceCategoryText,
  OperationStatusText,
  ResourcePlannerName,
  ProductPlanningGroupDesc,
  AdvncdPlngIsOpsOverlapped,
  AdvncdPlngOrderID,
  AdvncdPlngNrOfObjectsLoaded,
  AdvncdPlngNrOfObjectsInTotal,
  AdvncdPlngConfignProfileID,
  AdvncdPlngConfignPrflCustID,
  AdvncdPlngRsceIsSeldFltr,
  AdvncdPlngProdIsSeldFltr,
  AdvncdPlngOrdIsSeldFltr,
  PPDSFillLevelResourceID,
  PPDSRowFormatID
FROM R_AdvncdSchedgRsceRelshpDetsTP
LEFT OUTER JOIN C_AdvncdSchedgRsceOvrlp AS _ResourceOverlaps ON AdvncdPlngResourceName = _ResourceOverlaps.AdvncdPlngResourceName  -- association [0..*]
;

Learn More