R_ServiceRequestTP

DDL: R_SERVICEREQUESTTP Type: view_entity TRANSACTIONAL
32 Fields 1 Data Sources 1 Associations

Service Request - TP

R_ServiceRequestTP is a Transactional CDS View that provides data about "Service Request - TP" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentEnhcd) and exposes 32 fields with key field ServiceRequest. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocumentEnhcd I_ServiceDocumentEnhcd from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_StatusObjectUUIDStatus _SrvcReqStatus $projection.ServiceRequestUUID = _SrvcReqStatus.StatusObjectUUID and ( _SrvcReqStatus.StatusCode = 'I1002' or _SrvcReqStatus.StatusCode = 'I1003' or _SrvcReqStatus.StatusCode = 'I1004' or _SrvcReqStatus.StatusCode = 'I1005' ) and _SrvcReqStatus.StatusIsActive = 'X'

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Service Request - TP view
ObjectModel.sapObjectNodeType.name ServiceRequest view
ObjectModel.representativeKey ServiceRequest view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY ServiceRequest ServiceDocument Transaction ID
ServiceObjectType ServiceObjectType Object Type
ServiceRequestType ServiceDocumentType Transaction Type
ServiceRequestUUID ServiceDocumentUUID Object GUID
ServiceRequestDescription ServiceDocumentDescription
Language Language Report Text Language
ServiceDocumentPriority ServiceDocumentPriority
ServiceDocumentCategory BusinessActivityCategory
RequestedServiceStartDateTime RequestedServiceStartDateTime
RequestedServiceEndDateTime RequestedServiceEndDateTime
ServiceFirstResponseByDateTime ServiceFirstResponseByDateTime
ServiceDueByDateTime ServiceDueByDateTime
PurchaseOrderByCustomer PurchaseOrderByCustomer Purchase Order Number
CustomerPurchaseOrderDate CustomerPurchaseOrderDate Purchase Order Date
RecommendedServicePriority RecommendedServicePriority
ServiceRequestUrgency ServiceDocumentUrgency
ServiceRequestImpact ServiceDocumentImpact
ServiceRequestProblemCategory ServiceDocumentProblemCategory
ServiceRequestIsCanceled ServiceDocumentIsRejected
ServiceDocChangedDateTime ServiceDocChangedDateTime
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
SoldToParty SoldToParty Sold-to Party
ServiceRequestReporter ContactPerson Contact Person Key
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID
ServiceOrganization ServiceOrganization
SalesOfficeOrgUnitID SalesOfficeOrgUnitID
SalesGroupOrgUnitID SalesGroupOrgUnitID
_ServiceObjType _ServiceObjType

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_ServiceRequestTP.
-- 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_ServiceRequestTP AS
SELECT
  ServiceDocument AS ServiceRequest,
  ServiceObjectType,
  ServiceDocumentType AS ServiceRequestType,
  ServiceDocumentUUID AS ServiceRequestUUID,
  ServiceDocumentDescription AS ServiceRequestDescription,
  Language,
  ServiceDocumentPriority,
  BusinessActivityCategory AS ServiceDocumentCategory,
  RequestedServiceStartDateTime,
  RequestedServiceEndDateTime,
  ServiceFirstResponseByDateTime,
  ServiceDueByDateTime,
  PurchaseOrderByCustomer,
  CustomerPurchaseOrderDate,
  RecommendedServicePriority,
  ServiceDocumentUrgency AS ServiceRequestUrgency,
  ServiceDocumentImpact AS ServiceRequestImpact,
  ServiceDocumentProblemCategory AS ServiceRequestProblemCategory,
  ServiceDocumentIsRejected AS ServiceRequestIsCanceled,
  ServiceDocChangedDateTime,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SoldToParty,
  ContactPerson AS ServiceRequestReporter,
  SalesOrganizationOrgUnitID,
  ServiceOrganization,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID
FROM I_ServiceDocumentEnhcd
LEFT OUTER JOIN I_StatusObjectUUIDStatus AS _SrvcReqStatus ON ServiceRequestUUID = _SrvcReqStatus.StatusObjectUUID AND ( _SrvcReqStatus.StatusCode = 'I1002' OR _SrvcReqStatus.StatusCode = 'I1003' OR _SrvcReqStatus.StatusCode = 'I1004' OR _SrvcReqStatus.StatusCode = 'I1005' ) AND _SrvcReqStatus.StatusIsActive = 'X'  -- association [0..1]
;

Learn More