What is C_ServiceDocumentItem in SAP S/4HANA?

C_ServiceDocumentItem is a consumption CDS view in SAP S/4HANA. Service Document Item It contains 77 fields.

Which tables does C_ServiceDocumentItem read from?

C_ServiceDocumentItem reads data from: I_ServiceDocumentItemEnhcd.

What VDM layer is C_ServiceDocumentItem?

C_ServiceDocumentItem is classified as a Consumption view optimized for specific business scenarios and reporting.

C_ServiceDocumentItem

DDL: C_SERVICEDOCUMENTITEM SQL: CSERVICEITEM Type: view CONSUMPTION

77 Fields 1 Data Sources 6 Associations

Service Document Item

C_ServiceDocumentItem is a Consumption CDS View that provides data about "Service Document Item" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentItemEnhcd) and exposes 77 fields with key fields ServiceObjectType, ServiceDocument, ServiceDocumentType, ServiceDocumentItem. It has 6 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_ServiceDocumentItemEnhcd	ServiceDocumentItem	from

Associations (6)

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]	P_ServiceDocumentRefObject	_ServiceDocItemMainRefObj	`$projection.ServiceObjectType = _ServiceDocItemMainRefObj.ServiceObjectType and $projection.ServiceDocument = _ServiceDocItemMainRefObj.ServiceDocument and $projection.ServiceDocumentItem = _ServiceDocItemMainRefObj.ServiceDocumentItem`
[0..*]	C_SrvcDocItemTransHistory	_ServiceDocItemTransHistory	`$projection.ServiceObjectType = _ServiceDocItemTransHistory.ServiceObjectType and $projection.ServiceDocument = _ServiceDocItemTransHistory.ServiceDocument and $projection.ServiceDocumentItem = _ServiceDocItemTransHistory.ServiceDocumentItem`
[1..*]	C_SrvcConfItmObjPgPricingDets	_ServiceConfItmPriceDets	`$projection.ServiceObjectType = _ServiceConfItmPriceDets.ServiceObjectType and $projection.ServiceDocument = _ServiceConfItmPriceDets.ServiceDocument and $projection.ServiceDocumentItem = _ServiceConfItmPriceDets.ServiceDocumentItem`
[0..*]	C_SrvcDocItemPartner	_PartiesInvolved	`$projection.ServiceObjectType = _PartiesInvolved.CustMgmtObjectType and $projection.ServiceDocument = _PartiesInvolved.CustMgmtDocument and $projection.ServiceDocumentItem = _PartiesInvolved.CustMgmtDocumentItem`
[0..1]	I_ServiceDocumentItem	_ServiceDocumentItem	`$projection.ParentServiceDocumentItemUUID = _ServiceDocumentItem.ServiceDocumentItemUUID`

Annotations (18)

Name	Value	Level
AbapCatalog.sqlViewName	CSERVICEITEM	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Service Document Item	view
Search.searchable	true	view
UI.headerInfo.typeName	Service Confirmation Item	view
UI.headerInfo.typeNamePlural	Service Confirmation Items	view
UI.headerInfo.title.type	#STANDARD	view
UI.headerInfo.title.label	Item	view
UI.headerInfo.title.value	ServiceDocumentItem	view
UI.headerInfo.description.type	#STANDARD	view
UI.headerInfo.description.value	ServiceDocumentItemDescription	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view
VDM.lifecycle.status	#DEPRECATED	view

Fields (77)

Key	Field	Source Table	Source Field	Description
KEY	ServiceObjectType	I_ServiceDocumentItemEnhcd	ServiceObjectType	Object Type
KEY	ServiceDocument	I_ServiceDocumentItemEnhcd	ServiceDocument	Transaction ID
KEY	ServiceDocumentType	I_ServiceDocumentItemEnhcd	ServiceDocumentType	Transaction Type
KEY	ServiceDocumentItem	I_ServiceDocumentItemEnhcd	ServiceDocumentItem	Item Number
	ServiceDocumentItemUUID		ServiceDocumentItemUUID
	OriginallyRequestedProduct	I_ServiceDocumentItemEnhcd	OriginallyRequestedProduct	Product ID
	CustMgmtParentItemProduct	_ServiceDocumentItem	OriginallyRequestedProduct	Higher-Level Product ID
	CustMgmtParentItemProductName	_ServiceDocumentItem	ServiceDocumentItemDescription	Higher-Level Product
	TechObjIsEquipOrFuncnlLoc	_ServiceDocItemMainRefObj	TechObjIsEquipOrFuncnlLoc	Equipment/Functional Location
	Equipment	_ServiceDocItemMainRefObj	Equipment	Equipment check
	EquipmentName
	FunctionalLocation	_ServiceDocItemMainRefObj	FunctionalLocation	Object ID
	FunctionalLocationName
	ServiceDocItemQuantityUnit	I_ServiceDocumentItemEnhcd	ServiceDocItemQuantityUnit	Unit
	ServiceDocumentItemDescription		ServiceDocumentItemDescription	Product
	ServiceDocItemCategory	I_ServiceDocumentItemEnhcd	ServiceDocItemCategory	Item Category
	ServiceDocItemGrossAmount	I_ServiceDocumentItemEnhcd	ServiceDocItemGrossAmount	Gross Value
	ServiceDocumentItemQuantity	I_ServiceDocumentItemEnhcd	ServiceDocumentItemQuantity	Quantity
	TransactionCurrency	I_ServiceDocumentItemEnhcd	TransactionCurrency	Transaction Currency
	ActualServiceDuration		ActualServiceDuration	Actual Duration
	ActualServiceDurationUnit		ActualServiceDurationUnit	Unit
	UxFcActualServiceDuration
	ServiceDocumentItemStatus	I_ServiceDocumentItemEnhcd	ServiceDocumentItemStatus	Status
	BillingPriceSourceName	I_ServiceDocumentItemEnhcd	BillingPriceSourceName
	DocumentDescription	I_ServiceDocumentItemEnhcd	DocumentDescription	Source Of Procurement Price
	MaterialComponentIsSparePart
	BillableControl	I_ServiceDocumentItemEnhcd	BillableControl	Accounting Indicator
	ParentServiceDocumentItemUUID		ParentServiceDocumentItemUUID
	ResponsibleEmployee		ResponsibleEmployee	Executing Employee Responsible
	SoldToParty		SoldToParty	Sold-to Party
	ServiceEmployee		ServiceEmployee
	TimeSheetOvertimeCategory		TimeSheetOvertimeCategory	Overtime Category
	UxFcTimeSheetOvertimeCategory
	ActualServiceStartDateTime		ActualServiceStartDateTime	Start of Work
	UxFcActualServiceStartDateTime
	RequestedServiceStartDateTime		RequestedServiceStartDateTime	Requested Service Start Date
	RequestedServiceEndDateTime		RequestedServiceEndDateTime	Requested Service End Date
	BillingDateTime		BillingDateTime
	BillingDocCreationDateTime		BillingDocCreationDateTime	Billing Document Created On
	ServiceDocItemBillingStatus		ServiceDocItemBillingStatus
	PaymentTerms		PaymentTerms	Pyt Terms
	PayerParty		PayerParty	Payer
	BillToParty		BillToParty	Inv. Recipient
	_ParentServiceDocItem		_ParentServiceDocItem
	_ServiceDocItemCategory		_ServiceDocItemCategory
	_ServiceDocItemStatus		_ServiceDocItemStatus
	_SrvcDocItmLifecycleStatus		_SrvcDocItmLifecycleStatus
	_ServiceDocItemTransHistory		_ServiceDocItemTransHistory
	SalesOrganization		SalesOrganization	Sales Organization
	DistributionChannel		DistributionChannel	RefDistCh-Cust/Mat.
	Division		Division	Internal Division ID
	SalesOffice		SalesOffice	Sales Office
	SalesGroup		SalesGroup	Sales Group
	SalesOrganizationOrgUnitID		SalesOrganizationOrgUnitID
	SalesOfficeOrgUnitID		SalesOfficeOrgUnitID
	SalesGroupOrgUnitID		SalesGroupOrgUnitID
	ServiceOrganization		ServiceOrganization
	_SalesOrganizationOrgUnit		_SalesOrganizationOrgUnit
	_SalesOfficeOrgUnit		_SalesOfficeOrgUnit
	_SalesGroupOrgUnit		_SalesGroupOrgUnit
	_ServiceOrganizationOrgUnit		_ServiceOrganizationOrgUnit
	_SalesOrganizationOrgUnit_2		_SalesOrganizationOrgUnit_2
	_SalesOfficeOrgUnit_2		_SalesOfficeOrgUnit_2
	_SalesGroupOrgUnit_2		_SalesGroupOrgUnit_2
	_ServiceOrganizationOrgUnit_2		_ServiceOrganizationOrgUnit_2
	ServiceOrderNoteText	_ServiceDocItemNote	ServiceOrderNoteText
	_SoldToParty		_SoldToParty
	_PayerParty		_PayerParty
	_BillToParty		_BillToParty
	_ServiceEmployee		_ServiceEmployee
	_ServiceDocItemBillingStatus		_ServiceDocItemBillingStatus
	_PaymentTerms		_PaymentTerms
	_ServiceConfItmPriceDets		_ServiceConfItmPriceDets
	_ServiceDocOvertimeCat		_ServiceDocOvertimeCat
	_ServiceDocumentItem		_ServiceDocumentItem
	_PartiesInvolved		_PartiesInvolved
	_ServiceDocItemNote		_ServiceDocItemNote

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_ServiceDocumentItem.
-- 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: CSERVICEITEM

CREATE VIEW C_ServiceDocumentItem AS
SELECT
  ServiceDocumentItem.ServiceObjectType AS ServiceObjectType,
  ServiceDocumentItem.ServiceDocument AS ServiceDocument,
  ServiceDocumentItem.ServiceDocumentType AS ServiceDocumentType,
  ServiceDocumentItem.ServiceDocumentItem AS ServiceDocumentItem,
  ServiceDocumentItemUUID,
  ServiceDocumentItem.OriginallyRequestedProduct AS OriginallyRequestedProduct,
  _ServiceDocumentItem.OriginallyRequestedProduct AS CustMgmtParentItemProduct,
  _ServiceDocumentItem.ServiceDocumentItemDescription AS CustMgmtParentItemProductName,
  _ServiceDocItemMainRefObj.TechObjIsEquipOrFuncnlLoc AS TechObjIsEquipOrFuncnlLoc,
  _ServiceDocItemMainRefObj.Equipment AS Equipment,
  _ServiceDocItemMainRefObj._Equipment._EquipmentText[1: Language=$session.system_language].EquipmentName AS EquipmentName,
  _ServiceDocItemMainRefObj.FunctionalLocation AS FunctionalLocation,
  _ServiceDocItemMainRefObj._FunctionalLocation._FunctionalLocationText[1:Language = $session.system_language].FunctionalLocationName AS FunctionalLocationName,
  ServiceDocumentItem.ServiceDocItemQuantityUnit AS ServiceDocItemQuantityUnit,
  ServiceDocumentItemDescription,
  ServiceDocumentItem.ServiceDocItemCategory AS ServiceDocItemCategory,
  ServiceDocumentItem.ServiceDocItemGrossAmount AS ServiceDocItemGrossAmount,
  ServiceDocumentItem.ServiceDocumentItemQuantity AS ServiceDocumentItemQuantity,
  ServiceDocumentItem.TransactionCurrency AS TransactionCurrency,
  ActualServiceDuration,
  ActualServiceDurationUnit,
  cast(3 as abap.int4) AS UxFcActualServiceDuration,
  ServiceDocumentItem.ServiceDocumentItemStatus AS ServiceDocumentItemStatus,
  ServiceDocumentItem.BillingPriceSourceName AS BillingPriceSourceName,
  ServiceDocumentItem.DocumentDescription AS DocumentDescription,
  cast( '' as crmt_boolean ) AS MaterialComponentIsSparePart,
  ServiceDocumentItem.BillableControl AS BillableControl,
  ParentServiceDocumentItemUUID,
  ResponsibleEmployee,
  SoldToParty,
  ServiceEmployee,
  TimeSheetOvertimeCategory,
  cast(3 as abap.int4) AS UxFcTimeSheetOvertimeCategory,
  ActualServiceStartDateTime,
  cast(3 as abap.int4) AS UxFcActualServiceStartDateTime,
  RequestedServiceStartDateTime,
  RequestedServiceEndDateTime,
  BillingDateTime,
  BillingDocCreationDateTime,
  ServiceDocItemBillingStatus,
  PaymentTerms,
  PayerParty,
  BillToParty,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization,
  _ServiceDocItemNote.ServiceOrderNoteText AS ServiceOrderNoteText
FROM I_ServiceDocumentItemEnhcd AS ServiceDocumentItem
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 P_ServiceDocumentRefObject AS _ServiceDocItemMainRefObj ON ServiceObjectType = _ServiceDocItemMainRefObj.ServiceObjectType AND ServiceDocument = _ServiceDocItemMainRefObj.ServiceDocument AND ServiceDocumentItem = _ServiceDocItemMainRefObj.ServiceDocumentItem  -- association [0..1]
LEFT OUTER JOIN C_SrvcDocItemTransHistory AS _ServiceDocItemTransHistory ON ServiceObjectType = _ServiceDocItemTransHistory.ServiceObjectType AND ServiceDocument = _ServiceDocItemTransHistory.ServiceDocument AND ServiceDocumentItem = _ServiceDocItemTransHistory.ServiceDocumentItem  -- association [0..*]
LEFT OUTER JOIN C_SrvcConfItmObjPgPricingDets AS _ServiceConfItmPriceDets ON ServiceObjectType = _ServiceConfItmPriceDets.ServiceObjectType AND ServiceDocument = _ServiceConfItmPriceDets.ServiceDocument AND ServiceDocumentItem = _ServiceConfItmPriceDets.ServiceDocumentItem  -- association [1..*]
LEFT OUTER JOIN C_SrvcDocItemPartner AS _PartiesInvolved ON ServiceObjectType = _PartiesInvolved.CustMgmtObjectType AND ServiceDocument = _PartiesInvolved.CustMgmtDocument AND ServiceDocumentItem = _PartiesInvolved.CustMgmtDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_ServiceDocumentItem AS _ServiceDocumentItem ON ParentServiceDocumentItemUUID = _ServiceDocumentItem.ServiceDocumentItemUUID  -- association [0..1]
;

Depth:

C_ServiceDocumentItem view

I_ServiceDocumentItemEnhcd view