R_PSDAlternativeResourceTP

DDL: R_PSDALTERNATIVERESOURCETP Type: view_entity TRANSACTIONAL
28 Fields 1 Data Sources 1 Associations

PSD Alternative Resource TP

R_PSDAlternativeResourceTP is a Transactional CDS View that provides data about "PSD Alternative Resource TP" in SAP S/4HANA. It reads from 1 data source (I_PSDAlternativeResource) and exposes 28 fields with key fields ProductStorageDefinition, PSDProduct, PSDAlternativeResource. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_PSDAlternativeResource I_PSDAlternativeResource from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_ProductStorageDefinitionTP _ProductStorageDefinition $projection.ProductStorageDefinition = _ProductStorageDefinition.ProductStorageDefinition

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label PSD Alternative Resource TP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY ProductStorageDefinition ProductStorageDefinition Defn Set GUID
KEY PSDProduct PSDProduct Product Identifier
KEY PSDAlternativeResource PSDAlternativeResource Resource ID
ResourceUUID ResourceUUID Internal Resrce
ResourceValidToDateTime ResourceValidToDateTime
ResourceValidFromDateTime ResourceValidFromDateTime
PSDIsSetByExternalSystem PSDIsSetByExternalSystem Created by System
PSDResourcePriority PSDResourcePriority Workflow priority
CreatedByUserName CreatedByUserName Person Resp.
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
PSDAltvRsceVariableDuration PSDAltvRsceVariableDuration Variable Dur.
PSDAltvRsceVarblDurnUnit PSDAltvRsceVarblDurnUnit Duration UoM
PSDAltvRsceFixedDuration PSDAltvRsceFixedDuration Fixed Duration
PSDAltvRsceFxdDurnUnit PSDAltvRsceFxdDurnUnit Duration UoM
TimeDepdntProcParamUUID TimeDepdntProcParamUUID GUID to link PSD with TDPP
PSDAltvRsceMaxShortBreak PSDAltvRsceMaxShortBreak Short Break (Sec)
AdvncdPlngResourceName AdvncdPlngResourceName Resource
AdvncdPlngResourceText AdvncdPlngResourceText User Group
Location Location Text
LocationDescription LocationDescription Current Location
LocationType LocationType Location Type
AdvncdPlngLocationID AdvncdPlngLocationID
StorageLocation StorageLocation StorageLocation
StorageLocationDesc StorageLocationDesc Description
_PSDProduct _PSDProduct
_ProductStorageDefinition _ProductStorageDefinition

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 R_PSDAlternativeResourceTP.
-- 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 R_PSDAlternativeResourceTP AS
SELECT
  ProductStorageDefinition,
  PSDProduct,
  PSDAlternativeResource,
  ResourceUUID,
  ResourceValidToDateTime,
  ResourceValidFromDateTime,
  PSDIsSetByExternalSystem,
  PSDResourcePriority,
  CreatedByUserName,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  PSDAltvRsceVariableDuration,
  PSDAltvRsceVarblDurnUnit,
  PSDAltvRsceFixedDuration,
  PSDAltvRsceFxdDurnUnit,
  TimeDepdntProcParamUUID,
  PSDAltvRsceMaxShortBreak,
  AdvncdPlngResourceName,
  AdvncdPlngResourceText,
  Location,
  LocationDescription,
  LocationType,
  AdvncdPlngLocationID,
  StorageLocation,
  StorageLocationDesc
FROM I_PSDAlternativeResource
LEFT OUTER JOIN R_ProductStorageDefinitionTP AS _ProductStorageDefinition ON ProductStorageDefinition = _ProductStorageDefinition.ProductStorageDefinition  -- association [1..1]
;

Learn More