C_PCSrvcReqFailureReasonReq

DDL: C_PCSRVCREQFAILUREREASONREQ SQL: CPCSRFAILRSNR Type: view CONSUMPTION
16 Fields 1 Data Sources 1 Associations

Service Request Failure Reasons

C_PCSrvcReqFailureReasonReq is a Consumption CDS View that provides data about "Service Request Failure Reasons" in SAP S/4HANA. It reads from 1 data source (I_PCSrvcReqFailureReasonReq) and exposes 16 fields with key field ProdCmplncSrvcReqFailureUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_PCSrvcReqFailureReasonReq I_PCSrvcReqFailureReasonReq from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ProdCmplncTask _ProdCmplncTask $projection.ProdCmplncTaskUUID = _ProdCmplncTask.ProdCmplncTaskUUID

Annotations (11)

NameValueLevelField
EndUserText.label Service Request Failure Reasons view
AbapCatalog.sqlViewName CPCSRFAILRSNR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ProdCmplncSrvcReqFailureUUID ProdCmplncSrvcReqFailureUUID Request Failure Reason ID
ProdCmplncServiceRequestUUID ProdCmplncServiceRequestUUID Request ID
ProdCmplncTaskUUID ProdCmplncTaskUUID Product Compliance Task
ProdCmplncTaskType _ProdCmplncTask ProdCmplncTaskType Task Type
ProdCmplncSrvcReqFailureReason ProdCmplncSrvcReqFailureReason Reason
SystemMessageNumber SystemMessageNumber Message Number
SystemMessageIdentification SystemMessageIdentification Message ID
SystemMessageType SystemMessageType Message type
SystemMessageVariable1 SystemMessageVariable1 Variable 1
SystemMessageVariable2 SystemMessageVariable2 Variable 2
SystemMessageVariable3 SystemMessageVariable3 Variable 3
SystemMessageVariable4 SystemMessageVariable4 Variable 4
ProdCmplncSrvcReqFailureRsnLbl
ProdCmplncSrvcReqFlreRsnDetTxt
_ProdCmplncTask _ProdCmplncTask
_ProdCmplncTaskTypeText _ProdCmplncTask _ProdCmplncTaskTypeText

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_PCSrvcReqFailureReasonReq.
-- 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.
-- SQL view name: CPCSRFAILRSNR

CREATE VIEW C_PCSrvcReqFailureReasonReq AS
SELECT
  ProdCmplncSrvcReqFailureUUID,
  ProdCmplncServiceRequestUUID,
  ProdCmplncTaskUUID,
  _ProdCmplncTask.ProdCmplncTaskType AS ProdCmplncTaskType,
  ProdCmplncSrvcReqFailureReason,
  SystemMessageNumber,
  SystemMessageIdentification,
  SystemMessageType,
  SystemMessageVariable1,
  SystemMessageVariable2,
  SystemMessageVariable3,
  SystemMessageVariable4,
  cast( ' ' as prodcmplncsrvcreqflrersndettxt ) AS ProdCmplncSrvcReqFailureRsnLbl,
  cast( ' ' as prodcmplncsrvcreqflrersndettxt ) AS ProdCmplncSrvcReqFlreRsnDetTxt,
  _ProdCmplncTask._ProdCmplncTaskTypeText AS _ProdCmplncTaskTypeText
FROM I_PCSrvcReqFailureReasonReq
LEFT OUTER JOIN I_ProdCmplncTask AS _ProdCmplncTask ON ProdCmplncTaskUUID = _ProdCmplncTask.ProdCmplncTaskUUID  -- association [1..1]
;

Learn More