C_ProdCmplncServiceRequest

DDL: C_PRODCMPLNCSERVICEREQUEST SQL: CPRODCMPLSERVREQ Type: view CONSUMPTION
36 Fields 1 Data Sources 9 Associations

Product Compliance Service Requests

C_ProdCmplncServiceRequest is a Consumption CDS View that provides data about "Product Compliance Service Requests" in SAP S/4HANA. It reads from 1 data source (I_ProdCmplncServiceRequest) and exposes 36 fields with key field ProdCmplncServiceRequestUUID. It has 9 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ProdCmplncServiceRequest ServiceRequest from

Associations (9)

CardinalityTargetAliasCondition
[0..1] I_ChmlCmplncInfo _ChemicalComplianceInfo _ChemicalComplianceInfo.ChmlCmplncInfoUUID = ServiceRequest.ChmlCmplncInfoUUID
[0..1] I_Substance _Substance _Substance.SubstanceUUID = ServiceRequest.SubstanceUUID
[0..*] C_ProdCmplncSrvcReqSendData _ProdCmplncSrvcReqSendData _ProdCmplncSrvcReqSendData.ProdCmplncServiceRequestUUID = $projection.ProdCmplncServiceRequestUUID
[0..*] C_PCSrvcReqFailureReasonReq _PCSrvcReqFailureReasonReq _PCSrvcReqFailureReasonReq.ProdCmplncServiceRequestUUID = $projection.ProdCmplncServiceRequestUUID
[0..*] C_PCSrvcReqReqSftyDataSht _PCSrvcReqReqSftyDataSht $projection.ProdCmplncServiceRequestUUID = _PCSrvcReqReqSftyDataSht.ProdCmplncServiceRequestUUID
[0..*] C_PCSrvcReqRcvdData _PCSrvcReqRcvdData $projection.ProdCmplncServiceRequestUUID = _PCSrvcReqRcvdData.ProdCmplncServiceRequestUUID
[0..1] C_ProdCmplncServiceRequestProd _RecentProductData $projection.ChmlCmplncInfoUUID = _RecentProductData.ChmlCmplncInfoUUID
[0..1] C_ProdCmplncServiceReqSubst _RecentPrivateSubstanceData $projection.SubstanceUUID = _RecentPrivateSubstanceData.SubstanceUUID
[0..1] I_UserContactCard _CreatedByUserContactCard $projection.CreatedByUser = _CreatedByUserContactCard.ContactCardID

Annotations (12)

NameValueLevelField
EndUserText.label Product Compliance Service Requests view
AbapCatalog.sqlViewName CPRODCMPLSERVREQ view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY ProdCmplncServiceRequestUUID I_ProdCmplncServiceRequest ProdCmplncServiceRequestUUID Request ID
ProdCmplncServiceRequestType I_ProdCmplncServiceRequest ProdCmplncServiceRequestType Service Request Type
ProdCmplncSrvcReqTypeName
ProdCmplncServiceRequestOrigin I_ProdCmplncServiceRequest ProdCmplncServiceRequestOrigin Origin
ProdCmplncSrvcReqOriginName
ProdCmplncServiceRequestStatus I_ProdCmplncServiceRequest ProdCmplncServiceRequestStatus Request Status
ProdCmplncSrvcReqStatusName
ProdCmplncSrvcReqExtStatus I_ProdCmplncServiceRequest ProdCmplncSrvcReqExtStatus Processing Status
ProdCmplncSrvcReqExtStatusName
ProdCmplncSrvcReqExtStsCritlty
ProdCmplncSrvcReqFailureReason I_ProdCmplncServiceRequest ProdCmplncSrvcReqFailureReason Reason
ProdCmplncSrvcReqFailureRsnLbl
LastChangeDateTime I_ProdCmplncServiceRequest LastChangeDateTime Timestamp
CreatedByUser I_ProdCmplncServiceRequest CreatedByUser User Name
ChmlCmplncInfoUUID I_ProdCmplncServiceRequest ChmlCmplncInfoUUID Chemical Compliance Information PP
SubstanceUUID I_ProdCmplncServiceRequest SubstanceUUID Substance
ProdCmplncProductOrCompName I_ProdCmplncServiceRequest ProdCmplncProductOrCompName Product / Substance
SubstanceInternalName I_ProdCmplncServiceRequest SubstanceInternalName Internal Name
ProdCmplncServiceRequestNote I_ProdCmplncServiceRequest ProdCmplncServiceRequestNote Status Note
CASNumber I_ProdCmplncServiceRequest CASNumber CAS Number
ECNumber I_ProdCmplncServiceRequest ECNumber EC Number
ProdCmplncSrvcReqChgIsNeeded
_PCSrvcReqReqSftyDataSht _PCSrvcReqReqSftyDataSht
_ProdCmplncSrvcReqSendData _ProdCmplncSrvcReqSendData
_PCSrvcReqRcvdData _PCSrvcReqRcvdData
_PCSrvcReqFailureReasonReq _PCSrvcReqFailureReasonReq
_RecentProductData _RecentProductData
_RecentPrivateSubstanceData _RecentPrivateSubstanceData
LastName _CreatedByUserContactCard LastName Last Name
FirstName _CreatedByUserContactCard FirstName First Name
_CreatedByUserContactCard _CreatedByUserContactCard
_ProdCmplncSrvcReqType I_ProdCmplncServiceRequest _ProdCmplncSrvcReqType
_ProdCmplncSrvcReqOrigin I_ProdCmplncServiceRequest _ProdCmplncSrvcReqOrigin
_ProdCmplncSrvcReqStatus I_ProdCmplncServiceRequest _ProdCmplncSrvcReqStatus
_ProdCmplncSrvcReqExtStatus I_ProdCmplncServiceRequest _ProdCmplncSrvcReqExtStatus
_ProdCmplncSrvcReqFailureRsn I_ProdCmplncServiceRequest _ProdCmplncSrvcReqFailureRsn

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_ProdCmplncServiceRequest.
-- 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: CPRODCMPLSERVREQ

CREATE VIEW C_ProdCmplncServiceRequest AS
SELECT
  ServiceRequest.ProdCmplncServiceRequestUUID AS ProdCmplncServiceRequestUUID,
  ServiceRequest.ProdCmplncServiceRequestType AS ProdCmplncServiceRequestType,
  ServiceRequest._ProdCmplncSrvcReqType._Text[1: Language = $session.system_language].ProdCmplncSrvcReqTypeName AS ProdCmplncSrvcReqTypeName,
  ServiceRequest.ProdCmplncServiceRequestOrigin AS ProdCmplncServiceRequestOrigin,
  ServiceRequest._ProdCmplncSrvcReqOrigin._Text[1: Language = $session.system_language].ProdCmplncSrvcReqOriginName AS ProdCmplncSrvcReqOriginName,
  ServiceRequest.ProdCmplncServiceRequestStatus AS ProdCmplncServiceRequestStatus,
  ServiceRequest._ProdCmplncSrvcReqStatus._Text[1: Language = $session.system_language].ProdCmplncSrvcReqStatusName AS ProdCmplncSrvcReqStatusName,
  ServiceRequest.ProdCmplncSrvcReqExtStatus AS ProdCmplncSrvcReqExtStatus,
  ServiceRequest._ProdCmplncSrvcReqExtStatus._Text[1: Language = $session.system_language].ProdCmplncSrvcReqExtStatusName AS ProdCmplncSrvcReqExtStatusName,
  ServiceRequest._ProdCmplncSrvcReqExtStatus.ProdCmplncSrvcReqExtStsCritlty AS ProdCmplncSrvcReqExtStsCritlty,
  ServiceRequest.ProdCmplncSrvcReqFailureReason AS ProdCmplncSrvcReqFailureReason,
  ServiceRequest._ProdCmplncSrvcReqFailureRsn._Text[1: Language = $session.system_language].ProdCmplncSrvcReqFailureRsnLbl AS ProdCmplncSrvcReqFailureRsnLbl,
  ServiceRequest.LastChangeDateTime AS LastChangeDateTime,
  ServiceRequest.CreatedByUser AS CreatedByUser,
  ServiceRequest.ChmlCmplncInfoUUID AS ChmlCmplncInfoUUID,
  ServiceRequest.SubstanceUUID AS SubstanceUUID,
  ServiceRequest.ProdCmplncProductOrCompName AS ProdCmplncProductOrCompName,
  ServiceRequest.SubstanceInternalName AS SubstanceInternalName,
  ServiceRequest.ProdCmplncServiceRequestNote AS ProdCmplncServiceRequestNote,
  ServiceRequest.CASNumber AS CASNumber,
  ServiceRequest.ECNumber AS ECNumber,
  cast( '' as prodcmplncsrvcreqchgisneeded preserving type ) AS ProdCmplncSrvcReqChgIsNeeded,
  _CreatedByUserContactCard.LastName AS LastName,
  _CreatedByUserContactCard.FirstName AS FirstName,
  ServiceRequest._ProdCmplncSrvcReqType AS _ProdCmplncSrvcReqType,
  ServiceRequest._ProdCmplncSrvcReqOrigin AS _ProdCmplncSrvcReqOrigin,
  ServiceRequest._ProdCmplncSrvcReqStatus AS _ProdCmplncSrvcReqStatus,
  ServiceRequest._ProdCmplncSrvcReqExtStatus AS _ProdCmplncSrvcReqExtStatus,
  ServiceRequest._ProdCmplncSrvcReqFailureRsn AS _ProdCmplncSrvcReqFailureRsn
FROM I_ProdCmplncServiceRequest AS ServiceRequest
LEFT OUTER JOIN I_ChmlCmplncInfo AS _ChemicalComplianceInfo ON _ChemicalComplianceInfo.ChmlCmplncInfoUUID = ServiceRequest.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN I_Substance AS _Substance ON _Substance.SubstanceUUID = ServiceRequest.SubstanceUUID  -- association [0..1]
LEFT OUTER JOIN C_ProdCmplncSrvcReqSendData AS _ProdCmplncSrvcReqSendData ON _ProdCmplncSrvcReqSendData.ProdCmplncServiceRequestUUID = ProdCmplncServiceRequestUUID  -- association [0..*]
LEFT OUTER JOIN C_PCSrvcReqFailureReasonReq AS _PCSrvcReqFailureReasonReq ON _PCSrvcReqFailureReasonReq.ProdCmplncServiceRequestUUID = ProdCmplncServiceRequestUUID  -- association [0..*]
LEFT OUTER JOIN C_PCSrvcReqReqSftyDataSht AS _PCSrvcReqReqSftyDataSht ON ProdCmplncServiceRequestUUID = _PCSrvcReqReqSftyDataSht.ProdCmplncServiceRequestUUID  -- association [0..*]
LEFT OUTER JOIN C_PCSrvcReqRcvdData AS _PCSrvcReqRcvdData ON ProdCmplncServiceRequestUUID = _PCSrvcReqRcvdData.ProdCmplncServiceRequestUUID  -- association [0..*]
LEFT OUTER JOIN C_ProdCmplncServiceRequestProd AS _RecentProductData ON ChmlCmplncInfoUUID = _RecentProductData.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN C_ProdCmplncServiceReqSubst AS _RecentPrivateSubstanceData ON SubstanceUUID = _RecentPrivateSubstanceData.SubstanceUUID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUserContactCard ON CreatedByUser = _CreatedByUserContactCard.ContactCardID  -- association [0..1]
;

Learn More