What is R_ServiceDocumentItemTP in SAP S/4HANA?

R_ServiceDocumentItemTP is a transactional CDS view in SAP S/4HANA. Transaction Process: Service Item It contains 71 fields.

Which tables does R_ServiceDocumentItemTP read from?

R_ServiceDocumentItemTP reads data from: I_ServiceDocumentItemEnhcd.

What VDM layer is R_ServiceDocumentItemTP?

R_ServiceDocumentItemTP is classified as a Transactional view that supports create, update, and delete operations.

R_ServiceDocumentItemTP

DDL: R_SERVICEDOCUMENTITEMTP SQL: RSRVCDOCITEMTP Type: view TRANSACTIONAL

71 Fields 1 Data Sources 2 Associations

Transaction Process: Service Item

R_ServiceDocumentItemTP is a Transactional CDS View that provides data about "Transaction Process: Service Item" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentItemEnhcd) and exposes 71 fields with key fields ServiceObjectType, ServiceDocument, ServiceDocumentItem. It has 2 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_ServiceDocumentItemEnhcd	ServiceDocumentItemEnhcd	from

Associations (2)

Cardinality	Target	Alias	Condition
[0..1]	E_ServiceDocumentItem	_ServiceDocItemExt	`$projection.ServiceObjectType = _ServiceDocItemExt.ServiceCategory and $projection.ServiceDocument = _ServiceDocItemExt.ServiceOrderItem and $projection.ServiceDocumentItem = _ServiceDocItemExt.ServiceLineExternalID`
[0..1]	I_StatusObjectUUIDStatus	_SrvcDocSystemStatus	`$projection.ServiceDocumentItemUUID = _SrvcDocSystemStatus.StatusObjectUUID and ( _SrvcDocSystemStatus.StatusCode = 'I1002' or _SrvcDocSystemStatus.StatusCode = 'I1003' or _SrvcDocSystemStatus.StatusCode = 'I1004' or _SrvcDocSystemStatus.StatusCode = 'I1005' ) and _SrvcDocSystemStatus.StatusIsActive = 'X'`

Annotations (14)

Name	Value	Level
AbapCatalog.sqlViewName	RSRVCDOCITEMTP	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
EndUserText.label	Transaction Process: Service Item	view
VDM.viewType	#TRANSACTIONAL	view
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view
VDM.lifecycle.status	#DEPRECATED	view
AccessControl.authorizationCheck	#CHECK	view
Metadata.ignorePropagatedAnnotations	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.representativeKey	ServiceDocumentItem	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XXL	view

Fields (71)

Key	Field	Source Table	Source Field	Description
KEY	ServiceObjectType	I_ServiceDocumentItemEnhcd	ServiceObjectType	Object Type
KEY	ServiceDocument		ServiceDocument	Transaction ID
KEY	ServiceDocumentItem		ServiceDocumentItem	Service Document
	ServiceDocumentType	I_ServiceDocumentItemEnhcd	ServiceDocumentType	Transaction Type
	ServiceDocumentItemDescription		ServiceDocumentItemDescription
	ServiceDocumentItemUUID		ServiceDocumentItemUUID
	ServiceDocumentItemCharUUID		ServiceDocumentItemCharUUID
	ServiceDocumentItemObjectType
	ServiceDocumentItemQuantity		ServiceDocumentItemQuantity
	ServiceDocItemQuantityUnit		ServiceDocItemQuantityUnit
	ServiceDocumentItemNetAmount		ServiceDocumentItemNetAmount
	ServiceDocItemCategory		ServiceDocItemCategory
	OriginallyRequestedProduct		OriginallyRequestedProduct
	MaintSrvcOrdExecutionStatus		MaintSrvcOrdExecutionStatus
	ResponsibleEmployee	I_ServiceDocumentItemEnhcd	ResponsibleEmployee	Employee Resp.
	BillToParty		BillToParty	Inv. Recipient
	PayerParty		PayerParty	Payer
	ShipToParty		ShipToParty	Ship-To Party (obsolete)
	ServiceTeam		ServiceTeam
	SalesOrganization	I_ServiceDocumentItemEnhcd	SalesOrganization	Sales Organization
	SalesOffice	I_ServiceDocumentItemEnhcd	SalesOffice	Sales Office
	SalesGroup	I_ServiceDocumentItemEnhcd	SalesGroup	Sales Group
	DistributionChannel	I_ServiceDocumentItemEnhcd	DistributionChannel	RefDistCh-Cust/Mat.
	Division	I_ServiceDocumentItemEnhcd	Division	Internal Division ID
	ServiceDocumentItemStatus	I_ServiceDocumentItemEnhcd	ServiceDocumentItemStatus
	SalesOfficeOrgUnitID	I_ServiceDocumentItemEnhcd	SalesOfficeOrgUnitID
	SalesOrganizationOrgUnitID	I_ServiceDocumentItemEnhcd	SalesOrganizationOrgUnitID
	SalesGroupOrgUnitID	I_ServiceDocumentItemEnhcd	SalesGroupOrgUnitID
	ServiceOrganization	I_ServiceDocumentItemEnhcd	ServiceOrganization
	TransactionCurrency	I_ServiceDocumentItemEnhcd	TransactionCurrency	Transaction Currency
	Project	EnterpriseProjectItem	Project	WBS Element
	ProjectStartDate	ProjectItems	ProjectStartDate	Latest Planned Start
	ProjectEndDate	ProjectItems	ProjectEndDate	Ltst Planned Finish
	ProcessingStatusText	ProcessingStsTxt	ProcessingStatusText
	LtstConfirmedDeliveryDateTime	I_ServiceDocumentItemEnhcd	LtstConfirmedDeliveryDateTime
	SrvcDocItmDeliveryStatus	I_ServiceDocumentItemEnhcd	SrvcDocItmDeliveryStatus
	PlannedServiceStartDateTime	I_ServiceDocumentItemEnhcd	PlannedServiceStartDateTime
	PlannedServiceEndDateTime	I_ServiceDocumentItemEnhcd	PlannedServiceEndDateTime
	RequestedServiceStartDateTime	I_ServiceDocumentItemEnhcd	RequestedServiceStartDateTime
	RequestedServiceEndDateTime	I_ServiceDocumentItemEnhcd	RequestedServiceEndDateTime
	ServiceContractItemStartDate	I_ServiceDocumentItemEnhcd	ServiceContractItemStartDate
	ServiceContractItemEndDate	I_ServiceDocumentItemEnhcd	ServiceContractItemEndDate
	SoldToParty	I_ServiceDocumentItemEnhcd	SoldToParty	Sold-to Party
	ServiceDocItemGrossAmount	I_ServiceDocumentItemEnhcd	ServiceDocItemGrossAmount
	ServiceDocNetAmount	_ServiceDocumentTP	ServiceDocNetAmount
	SystemStatus	_SrvcDocSystemStatus	StatusCode	Statuscode
	_ServiceObjType	I_ServiceDocumentItemEnhcd	_ServiceObjType
	_ServiceDocItemStatus	I_ServiceDocumentItemEnhcd	_ServiceDocItemStatus
	_SrvcDocItmLifecycleStatus	I_ServiceDocumentItemEnhcd	_SrvcDocItmLifecycleStatus
	_ServiceDocument	I_ServiceDocumentItemEnhcd	_ServiceDocument
	_ServiceDocItemCategory	I_ServiceDocumentItemEnhcd	_ServiceDocItemCategory
	_ServiceDocumentTP		_ServiceDocumentTP
	_ServiceDocItemRefObj	I_ServiceDocumentItemEnhcd	_ServiceDocItemRefObj
	_ServiceDocumentType	I_ServiceDocumentItemEnhcd	_ServiceDocumentType
	_RespEmployee	I_ServiceDocumentItemEnhcd	_RespEmployee
	_SalesOrganization	I_ServiceDocumentItemEnhcd	_SalesOrganization
	_SalesOffice	I_ServiceDocumentItemEnhcd	_SalesOffice
	_SalesGroup	I_ServiceDocumentItemEnhcd	_SalesGroup
	_DistributionChannel	I_ServiceDocumentItemEnhcd	_DistributionChannel
	_Division	I_ServiceDocumentItemEnhcd	_Division
	_TransactionCurrency	I_ServiceDocumentItemEnhcd	_TransactionCurrency
	_SalesOrganizationOrgUnit	I_ServiceDocumentItemEnhcd	_SalesOrganizationOrgUnit
	_SalesOfficeOrgUnit	I_ServiceDocumentItemEnhcd	_SalesOfficeOrgUnit
	_SalesGroupOrgUnit	I_ServiceDocumentItemEnhcd	_SalesGroupOrgUnit
	_ServiceOrganizationOrgUnit	I_ServiceDocumentItemEnhcd	_ServiceOrganizationOrgUnit
	_SalesOrganizationOrgUnit_2	I_ServiceDocumentItemEnhcd	_SalesOrganizationOrgUnit_2
	_SalesOfficeOrgUnit_2	I_ServiceDocumentItemEnhcd	_SalesOfficeOrgUnit_2
	_SalesGroupOrgUnit_2	I_ServiceDocumentItemEnhcd	_SalesGroupOrgUnit_2
	_ServiceOrganizationOrgUnit_2	I_ServiceDocumentItemEnhcd	_ServiceOrganizationOrgUnit_2
	_SoldToParty	I_ServiceDocumentItemEnhcd	_SoldToParty
	_SrvcDocSystemStatus		_SrvcDocSystemStatus

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_ServiceDocumentItemTP.
-- 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: RSRVCDOCITEMTP

CREATE VIEW R_ServiceDocumentItemTP AS
SELECT
  ServiceDocumentItemEnhcd.ServiceObjectType AS ServiceObjectType,
  ServiceDocument,
  ServiceDocumentItem,
  ServiceDocumentItemEnhcd.ServiceDocumentType AS ServiceDocumentType,
  ServiceDocumentItemDescription,
  ServiceDocumentItemUUID,
  ServiceDocumentItemCharUUID,
  ServiceDocumentItemEnhcd. ServiceDocumentItemObjectType AS ServiceDocumentItemObjectType,
  ServiceDocumentItemQuantity,
  ServiceDocItemQuantityUnit,
  ServiceDocumentItemNetAmount,
  ServiceDocItemCategory,
  OriginallyRequestedProduct,
  MaintSrvcOrdExecutionStatus,
  ServiceDocumentItemEnhcd.ResponsibleEmployee AS ResponsibleEmployee,
  BillToParty,
  PayerParty,
  ShipToParty,
  ServiceTeam,
  ServiceDocumentItemEnhcd.SalesOrganization AS SalesOrganization,
  ServiceDocumentItemEnhcd.SalesOffice AS SalesOffice,
  ServiceDocumentItemEnhcd.SalesGroup AS SalesGroup,
  ServiceDocumentItemEnhcd.DistributionChannel AS DistributionChannel,
  ServiceDocumentItemEnhcd.Division AS Division,
  ServiceDocumentItemEnhcd.ServiceDocumentItemStatus AS ServiceDocumentItemStatus,
  ServiceDocumentItemEnhcd.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  ServiceDocumentItemEnhcd.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  ServiceDocumentItemEnhcd.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  ServiceDocumentItemEnhcd.ServiceOrganization AS ServiceOrganization,
  ServiceDocumentItemEnhcd.TransactionCurrency AS TransactionCurrency,
  EnterpriseProjectItem.Project AS Project,
  ProjectItems.ProjectStartDate AS ProjectStartDate,
  ProjectItems.ProjectEndDate AS ProjectEndDate,
  ProcessingStsTxt.ProcessingStatusText AS ProcessingStatusText,
  ServiceDocumentItemEnhcd.LtstConfirmedDeliveryDateTime AS LtstConfirmedDeliveryDateTime,
  ServiceDocumentItemEnhcd.SrvcDocItmDeliveryStatus AS SrvcDocItmDeliveryStatus,
  ServiceDocumentItemEnhcd.PlannedServiceStartDateTime AS PlannedServiceStartDateTime,
  ServiceDocumentItemEnhcd.PlannedServiceEndDateTime AS PlannedServiceEndDateTime,
  ServiceDocumentItemEnhcd.RequestedServiceStartDateTime AS RequestedServiceStartDateTime,
  ServiceDocumentItemEnhcd.RequestedServiceEndDateTime AS RequestedServiceEndDateTime,
  ServiceDocumentItemEnhcd.ServiceContractItemStartDate AS ServiceContractItemStartDate,
  ServiceDocumentItemEnhcd.ServiceContractItemEndDate AS ServiceContractItemEndDate,
  ServiceDocumentItemEnhcd.SoldToParty AS SoldToParty,
  ServiceDocumentItemEnhcd.ServiceDocItemGrossAmount AS ServiceDocItemGrossAmount,
  _ServiceDocumentTP.ServiceDocNetAmount AS ServiceDocNetAmount,
  _SrvcDocSystemStatus.StatusCode AS SystemStatus,
  ServiceDocumentItemEnhcd._ServiceObjType AS _ServiceObjType,
  ServiceDocumentItemEnhcd._ServiceDocItemStatus AS _ServiceDocItemStatus,
  ServiceDocumentItemEnhcd._SrvcDocItmLifecycleStatus AS _SrvcDocItmLifecycleStatus,
  ServiceDocumentItemEnhcd._ServiceDocument AS _ServiceDocument,
  ServiceDocumentItemEnhcd._ServiceDocItemCategory AS _ServiceDocItemCategory,
  ServiceDocumentItemEnhcd._ServiceDocItemRefObj AS _ServiceDocItemRefObj,
  ServiceDocumentItemEnhcd._ServiceDocumentType AS _ServiceDocumentType,
  ServiceDocumentItemEnhcd._RespEmployee AS _RespEmployee,
  ServiceDocumentItemEnhcd._SalesOrganization AS _SalesOrganization,
  ServiceDocumentItemEnhcd._SalesOffice AS _SalesOffice,
  ServiceDocumentItemEnhcd._SalesGroup AS _SalesGroup,
  ServiceDocumentItemEnhcd._DistributionChannel AS _DistributionChannel,
  ServiceDocumentItemEnhcd._Division AS _Division,
  ServiceDocumentItemEnhcd._TransactionCurrency AS _TransactionCurrency,
  ServiceDocumentItemEnhcd._SalesOrganizationOrgUnit AS _SalesOrganizationOrgUnit,
  ServiceDocumentItemEnhcd._SalesOfficeOrgUnit AS _SalesOfficeOrgUnit,
  ServiceDocumentItemEnhcd._SalesGroupOrgUnit AS _SalesGroupOrgUnit,
  ServiceDocumentItemEnhcd._ServiceOrganizationOrgUnit AS _ServiceOrganizationOrgUnit,
  ServiceDocumentItemEnhcd._SalesOrganizationOrgUnit_2 AS _SalesOrganizationOrgUnit_2,
  ServiceDocumentItemEnhcd._SalesOfficeOrgUnit_2 AS _SalesOfficeOrgUnit_2,
  ServiceDocumentItemEnhcd._SalesGroupOrgUnit_2 AS _SalesGroupOrgUnit_2,
  ServiceDocumentItemEnhcd._ServiceOrganizationOrgUnit_2 AS _ServiceOrganizationOrgUnit_2,
  ServiceDocumentItemEnhcd._SoldToParty AS _SoldToParty
FROM I_ServiceDocumentItemEnhcd AS ServiceDocumentItemEnhcd
LEFT OUTER JOIN E_ServiceDocumentItem AS _ServiceDocItemExt ON ServiceObjectType = _ServiceDocItemExt.ServiceCategory AND ServiceDocument = _ServiceDocItemExt.ServiceOrderItem AND ServiceDocumentItem = _ServiceDocItemExt.ServiceLineExternalID  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectUUIDStatus AS _SrvcDocSystemStatus ON ServiceDocumentItemUUID = _SrvcDocSystemStatus.StatusObjectUUID AND ( _SrvcDocSystemStatus.StatusCode = 'I1002' OR _SrvcDocSystemStatus.StatusCode = 'I1003' OR _SrvcDocSystemStatus.StatusCode = 'I1004' OR _SrvcDocSystemStatus.StatusCode = 'I1005' ) AND _SrvcDocSystemStatus.StatusIsActive = 'X'  -- association [0..1]
;

Depth:

R_ServiceDocumentItemTP view

I_ServiceDocumentItemEnhcd view