What is C_SrvcOrdTmplItemObjPg in SAP S/4HANA?

C_SrvcOrdTmplItemObjPg is a consumption CDS view in SAP S/4HANA. Item It contains 80 fields.

Which tables does C_SrvcOrdTmplItemObjPg read from?

C_SrvcOrdTmplItemObjPg reads data from: I_ServiceDocumentItemEnhcd.

What VDM layer is C_SrvcOrdTmplItemObjPg?

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

C_SrvcOrdTmplItemObjPg

DDL: C_SRVCORDTMPLITEMOBJPG SQL: CSRVCTMPLITEM Type: view CONSUMPTION

80 Fields 1 Data Sources 7 Associations

Item

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

Data Sources (1)

Source	Alias	Join Type
I_ServiceDocumentItemEnhcd	ServiceOrdTmplItem	from

Associations (7)

Cardinality	Target	Alias	Condition
[0..*]	C_SrvcDocItemPartner	_PartiesInvolved	`$projection.ServiceObjectType = _PartiesInvolved.CustMgmtObjectType and $projection.ServiceOrderTemplate = _PartiesInvolved.CustMgmtDocument and $projection.ServiceDocumentItem = _PartiesInvolved.CustMgmtDocumentItem`
[0..1]	E_ServiceDocumentItem	_ServiceDocItemExt	`$projection.ServiceObjectType = _ServiceDocItemExt.ServiceCategory and $projection.ServiceOrderTemplate = _ServiceDocItemExt.ServiceOrderItem and $projection.ServiceDocumentItem = _ServiceDocItemExt.ServiceLineExternalID`
[0..1]	P_ServiceDocumentRefObject	_ServiceDocItemMainRefObj	`$projection.ServiceObjectType = _ServiceDocItemMainRefObj.ServiceObjectType and $projection.ServiceOrderTemplate = _ServiceDocItemMainRefObj.ServiceDocument and $projection.ServiceDocumentItem = _ServiceDocItemMainRefObj.ServiceDocumentItem`
[0..1]	C_SrvcMgmtRespEmplQuickVw	_SrvcMgmtRespEmployeeQuickVw	`$projection.ResponsibleEmployee = _SrvcMgmtRespEmployeeQuickVw.BusinessPartner`
[1..*]	C_SrvcDocDateInformation	_SrvcDateItemInfo	`( $projection.ServiceOrderTemplate = _SrvcDateItemInfo.ServiceDocument and $projection.ServiceObjectType = _SrvcDateItemInfo.ServiceObjectType and $projection.ServiceDocumentItem = _SrvcDateItemInfo.ServiceDocumentItem ) or ( $projection.ServiceOrderTemplateItemUUID = _SrvcDateItemInfo.SrvcMgmtObjectUUID )`
[0..*]	C_SrvcDocItemUserStatus	_SrvcOrdTmpItemUserStatus	`$projection.ServiceOrderTemplateItemUUID = _SrvcOrdTmpItemUserStatus.StatusObjectUUID`
[0..1]	I_CustMgmtLifecycleUserStsText	_SrvcDocItmCustMgmtLCUsrStsTxt	`_SrvcDocItmCustMgmtLCUsrStsTxt.CustMgmtLifecycleUserStatus = $projection.ServiceDocumentItemStatus and _SrvcDocItmCustMgmtLCUsrStsTxt.Language = $session.system_language`

Annotations (12)

Name	Value	Level
AbapCatalog.sqlViewName	CSRVCTMPLITEM	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
EndUserText.label	Item	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Search.searchable	true	view
AccessControl.authorizationCheck	#CHECK	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view
Metadata.allowExtensions	true	view

Fields (80)

Key	Field	Source Table	Source Field	Description
KEY	ServiceObjectType	I_ServiceDocumentItemEnhcd	ServiceObjectType	Object Type
KEY	ServiceOrderTemplate	I_ServiceDocumentItemEnhcd	ServiceDocument	Transaction ID
KEY	ServiceDocumentType	I_ServiceDocumentItemEnhcd	ServiceDocumentType	Transaction Type
KEY	ServiceDocumentItem		ServiceDocumentItem	Service Document
	ServiceOrderTemplateItemUUID		ServiceDocumentItemUUID
	ServiceDocumentUUID	I_ServiceDocumentItemEnhcd	ServiceDocumentUUID	Object GUID
	ServiceDocumentItemObjectType		ServiceDocumentItemObjectType
	ServiceDocumentDescription	ServiceDocument	ServiceDocumentDescription
	ServiceDocumentTypeName
	OriginallyRequestedProduct		OriginallyRequestedProduct
	TechObjIsEquipOrFuncnlLoc	_ServiceDocItemMainRefObj	TechObjIsEquipOrFuncnlLoc	Tech. Obj. Type
	Equipment	_ServiceDocItemMainRefObj	Equipment	Equipment check
	EquipmentName
	FunctionalLocation	_ServiceDocItemMainRefObj	FunctionalLocation	Object ID
	FunctionalLocationName
	ProductID	_ServiceDocItemMainRefObj	ProductID	Product ID
	ProductName
	ServiceDocItemQuantityUnit		ServiceDocItemQuantityUnit
	SrvcOrdTmplItmDescription		ServiceDocumentItemDescription
	SrvcOrdTmplItmCategory		ServiceDocItemCategory
	ServiceDocItemCategoryName
	ServiceDocumentItemQuantity		ServiceDocumentItemQuantity
	TransactionCurrency	I_ServiceDocumentItemEnhcd	TransactionCurrency	Transaction Currency
	ActualServiceDuration		ActualServiceDuration
	ActualServiceDurationUnit		ActualServiceDurationUnit
	ServiceDocumentItemStatus		ServiceDocumentItemStatus
	ServiceDocumentStatus	ServiceDocument	ServiceDocumentStatus
	ServiceDocumentStatusName
	ServiceDocumentIsOpen	ServiceDocument	ServiceDocumentIsOpen
	SrvcOrdTmplIsReleased	ServiceDocument	ServiceDocumentIsReleased
	ParentServiceDocumentItemUUID		ParentServiceDocumentItemUUID
	CustMgmtParentItemProduct	_ParentServiceDocItem	OriginallyRequestedProduct
	CustMgmtParentItemProductName	_ParentServiceDocItem	ServiceDocumentItemDescription
	ResponsibleEmployee	I_ServiceDocumentItemEnhcd	ResponsibleEmployee	Employee Resp.
	ResponsibleEmployeeName
	TimeSheetOvertimeCategory		TimeSheetOvertimeCategory
	SalesOrganization	I_ServiceDocumentItemEnhcd	SalesOrganization	Sales Organization
	DistributionChannel	I_ServiceDocumentItemEnhcd	DistributionChannel	RefDistCh-Cust/Mat.
	Division	I_ServiceDocumentItemEnhcd	Division	Internal Division ID
	SalesOffice	I_ServiceDocumentItemEnhcd	SalesOffice	Sales Office
	SalesGroup	I_ServiceDocumentItemEnhcd	SalesGroup	Sales Group
	ServiceDocumentTemplateType	I_ServiceDocumentItemEnhcd	ServiceDocumentTemplateType
	RequestedServiceStartDateTime	I_ServiceDocumentItemEnhcd	RequestedServiceStartDateTime
	RequestedServiceEndDateTime	I_ServiceDocumentItemEnhcd	RequestedServiceEndDateTime
	PurchaseOrderByCustomer	I_ServiceDocumentItemEnhcd	PurchaseOrderByCustomer	Purchase Order Number
	PostingDate	I_ServiceDocumentItemEnhcd	PostingDate	Posting Date for GR
	ServiceDocumentItemHasError		ServiceDocumentItemHasError
	SalesOrganizationOrgUnitID	I_ServiceDocumentItemEnhcd	SalesOrganizationOrgUnitID
	SalesOfficeOrgUnitID	I_ServiceDocumentItemEnhcd	SalesOfficeOrgUnitID
	SalesGroupOrgUnitID	I_ServiceDocumentItemEnhcd	SalesGroupOrgUnitID
	ServiceOrganization	I_ServiceDocumentItemEnhcd	ServiceOrganization
	_TransactionCurrency		_TransactionCurrency
	_ParentServiceDocItem		_ParentServiceDocItem
	ServiceDocumentHasError	ServiceDocument	ServiceDocumentHasError
	StatusProfile	_ServiceDocItemCategory	StatusProfile	Status Profile
	_ServiceDocItemCategory		_ServiceDocItemCategory
	_ServiceDocItemStatus		_ServiceDocItemStatus
	_SalesOrganizationOrgUnit		_SalesOrganizationOrgUnit
	_SalesOrganizationOrgUnit_2		_SalesOrganizationOrgUnit_2
	_DistributionChannel		_DistributionChannel
	_Division		_Division
	_SalesOffice		_SalesOffice
	_SalesGroup		_SalesGroup
	_SalesOrganization		_SalesOrganization
	_SalesOfficeOrgUnit		_SalesOfficeOrgUnit
	_SalesOfficeOrgUnit_2		_SalesOfficeOrgUnit_2
	_SalesGroupOrgUnit		_SalesGroupOrgUnit
	_SalesGroupOrgUnit_2		_SalesGroupOrgUnit_2
	_ServiceOrganizationOrgUnit		_ServiceOrganizationOrgUnit
	_ServiceOrganizationOrgUnit_2		_ServiceOrganizationOrgUnit_2
	_RespEmployee		_RespEmployee
	_ServiceDocOvertimeCat		_ServiceDocOvertimeCat
	_PartiesInvolved		_PartiesInvolved
	_ServiceDocItemNote		_ServiceDocItemNote
	_ServiceDocItemHasError		_ServiceDocItemHasError
	_ServiceDocHasError	ServiceDocument	_ServiceDocHasError
	_SrvcMgmtRespEmployeeQuickVw		_SrvcMgmtRespEmployeeQuickVw
	_SrvcDateItemInfo		_SrvcDateItemInfo
	_SrvcDocItmCustMgmtLCUsrStsTxt		_SrvcDocItmCustMgmtLCUsrStsTxt
	_SrvcOrdTmpItemUserStatus		_SrvcOrdTmpItemUserStatus

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_SrvcOrdTmplItemObjPg.
-- 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: CSRVCTMPLITEM

CREATE VIEW C_SrvcOrdTmplItemObjPg AS
SELECT
  ServiceOrdTmplItem.ServiceObjectType AS ServiceObjectType,
  ServiceOrdTmplItem.ServiceDocument AS ServiceOrderTemplate,
  ServiceOrdTmplItem.ServiceDocumentType AS ServiceDocumentType,
  ServiceDocumentItem,
  ServiceDocumentItemUUID AS ServiceOrderTemplateItemUUID,
  ServiceOrdTmplItem.ServiceDocumentUUID AS ServiceDocumentUUID,
  ServiceDocumentItemObjectType,
  ServiceDocument.ServiceDocumentDescription AS ServiceDocumentDescription,
  ServiceDocument._ServiceDocumentType._ServiceDocumentTypeText[1:Language = $session.system_language].ServiceDocumentTypeName AS ServiceDocumentTypeName,
  OriginallyRequestedProduct,
  _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,
  _ServiceDocItemMainRefObj.ProductID AS ProductID,
  _ServiceDocItemMainRefObj._Product._Text[1: Language=$session.system_language].ProductName AS ProductName,
  ServiceDocItemQuantityUnit,
  ServiceDocumentItemDescription AS SrvcOrdTmplItmDescription,
  ServiceDocItemCategory AS SrvcOrdTmplItmCategory,
  _ServiceDocItemCategory._ServiceDocItemCategoryText[1:Language = $session.system_language].ServiceDocItemCategoryName AS ServiceDocItemCategoryName,
  ServiceDocumentItemQuantity,
  ServiceOrdTmplItem.TransactionCurrency AS TransactionCurrency,
  ActualServiceDuration,
  ActualServiceDurationUnit,
  ServiceDocumentItemStatus,
  ServiceDocument.ServiceDocumentStatus AS ServiceDocumentStatus,
  ServiceDocument._ServiceDocumentStatus._ServiceDocumentStatusText[1:Language = $session.system_language].ServiceDocumentStatusName AS ServiceDocumentStatusName,
  ServiceDocument.ServiceDocumentIsOpen AS ServiceDocumentIsOpen,
  ServiceDocument.ServiceDocumentIsReleased AS SrvcOrdTmplIsReleased,
  ParentServiceDocumentItemUUID,
  _ParentServiceDocItem.OriginallyRequestedProduct AS CustMgmtParentItemProduct,
  _ParentServiceDocItem.ServiceDocumentItemDescription AS CustMgmtParentItemProductName,
  ServiceOrdTmplItem.ResponsibleEmployee AS ResponsibleEmployee,
  ServiceOrdTmplItem._RespEmployee.BusinessPartnerName AS ResponsibleEmployeeName,
  TimeSheetOvertimeCategory,
  ServiceOrdTmplItem.SalesOrganization AS SalesOrganization,
  ServiceOrdTmplItem.DistributionChannel AS DistributionChannel,
  ServiceOrdTmplItem.Division AS Division,
  ServiceOrdTmplItem.SalesOffice AS SalesOffice,
  ServiceOrdTmplItem.SalesGroup AS SalesGroup,
  ServiceOrdTmplItem.ServiceDocumentTemplateType AS ServiceDocumentTemplateType,
  ServiceOrdTmplItem.RequestedServiceStartDateTime AS RequestedServiceStartDateTime,
  ServiceOrdTmplItem.RequestedServiceEndDateTime AS RequestedServiceEndDateTime,
  ServiceOrdTmplItem.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  ServiceOrdTmplItem.PostingDate AS PostingDate,
  ServiceDocumentItemHasError,
  ServiceOrdTmplItem.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  ServiceOrdTmplItem.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  ServiceOrdTmplItem.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  ServiceOrdTmplItem.ServiceOrganization AS ServiceOrganization,
  ServiceDocument.ServiceDocumentHasError AS ServiceDocumentHasError,
  _ServiceDocItemCategory.StatusProfile AS StatusProfile,
  ServiceDocument._ServiceDocHasError AS _ServiceDocHasError
FROM I_ServiceDocumentItemEnhcd AS ServiceOrdTmplItem
LEFT OUTER JOIN C_SrvcDocItemPartner AS _PartiesInvolved ON ServiceObjectType = _PartiesInvolved.CustMgmtObjectType AND ServiceOrderTemplate = _PartiesInvolved.CustMgmtDocument AND ServiceDocumentItem = _PartiesInvolved.CustMgmtDocumentItem  -- association [0..*]
LEFT OUTER JOIN E_ServiceDocumentItem AS _ServiceDocItemExt ON ServiceObjectType = _ServiceDocItemExt.ServiceCategory AND ServiceOrderTemplate = _ServiceDocItemExt.ServiceOrderItem AND ServiceDocumentItem = _ServiceDocItemExt.ServiceLineExternalID  -- association [0..1]
LEFT OUTER JOIN P_ServiceDocumentRefObject AS _ServiceDocItemMainRefObj ON ServiceObjectType = _ServiceDocItemMainRefObj.ServiceObjectType AND ServiceOrderTemplate = _ServiceDocItemMainRefObj.ServiceDocument AND ServiceDocumentItem = _ServiceDocItemMainRefObj.ServiceDocumentItem  -- association [0..1]
LEFT OUTER JOIN C_SrvcMgmtRespEmplQuickVw AS _SrvcMgmtRespEmployeeQuickVw ON ResponsibleEmployee = _SrvcMgmtRespEmployeeQuickVw.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN C_SrvcDocDateInformation AS _SrvcDateItemInfo ON ( ServiceOrderTemplate = _SrvcDateItemInfo.ServiceDocument AND ServiceObjectType = _SrvcDateItemInfo.ServiceObjectType AND ServiceDocumentItem = _SrvcDateItemInfo.ServiceDocumentItem ) OR ( ServiceOrderTemplateItemUUID = _SrvcDateItemInfo.SrvcMgmtObjectUUID )  -- association [1..*]
LEFT OUTER JOIN C_SrvcDocItemUserStatus AS _SrvcOrdTmpItemUserStatus ON ServiceOrderTemplateItemUUID = _SrvcOrdTmpItemUserStatus.StatusObjectUUID  -- association [0..*]
LEFT OUTER JOIN I_CustMgmtLifecycleUserStsText AS _SrvcDocItmCustMgmtLCUsrStsTxt ON _SrvcDocItmCustMgmtLCUsrStsTxt.CustMgmtLifecycleUserStatus = ServiceDocumentItemStatus AND _SrvcDocItmCustMgmtLCUsrStsTxt.Language = $session.system_language  -- association [0..1]
;

Depth:

C_SrvcOrdTmplItemObjPg view

I_ServiceDocumentItemEnhcd view