What is I_ServiceContractItem in SAP S/4HANA?

I_ServiceContractItem is a basic CDS view in SAP S/4HANA. Service Contract Item It contains 123 fields.

Which tables does I_ServiceContractItem read from?

I_ServiceContractItem reads data from: I_ServiceDocumentItem.

What VDM layer is I_ServiceContractItem?

I_ServiceContractItem is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_ServiceContractItem

DDL: I_SERVICECONTRACTITEM Type: view_entity BASIC Package: CRMS4_REPORT

123 Fields 1 Data Sources 5 Associations

Service Contract Item

I_ServiceContractItem (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

ServiceContractItem · Sales

I_ServiceContractItem is a Basic CDS View that provides data about "Service Contract Item" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentItem) and exposes 123 fields with key fields ServiceContract, ServiceContractItem. It has 5 associations to related views. Part of development package CRMS4_REPORT.

SAP Help Documentation

Category	Service Contract Management
Status	Service Contract Item Status

Purpose
This CDS view provides the prerequisites for answering questions about all transactional basis service contract item data. To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have a role with the following restriction types set to read access: CRM_ORD_OP CRM_CO_SE CRMS4_SLSO CRM_ORD_PR You can use the Display Restriction Types app to find out in which business catalogs these restriction types are included.

Structure
Important Fields Important fields in this view include the following: Field Name Description ServiceContract Transaction ID ServiceContractItem Item Number in Doc PostingDate Posting Date Product Product SoldToParty Sold-To Party SalesOrganization Sales Organization ServiceContractItemStatus Service Contract Item Status ServiceContractItemNetAmount Service Contract Item Net Amount ServiceDocItemGrossAmount Service Document Item Gross Amount

View on SAP Help Portal →

SAP API Hub

Category	Basic
State	C1
Line of Business	Sales
Application Component	CRM-S4-REP-RFW
Capabilities	Analytical Dimension,Data Source for Defining CDS Entities,Association Target for Defining CDS Entities,Data Source in SQL Select
Extensible (Key User)	No
Extensible (Developer)	No
Release State (Key User)	Released
Release State (Developer)	Released
Package	Sales for SAP S/4HANA Cloud Public Edition
Description	<p>This CDS view provides the prerequisites for answering questions about all transactional basis service contract item data.</p> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Public Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Public Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Public Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Custom Communication Scenarios — Create custom communication scenarios to configure custom communication arrangement
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Public Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_ServiceDocumentItem	I_ServiceDocumentItem	from

Associations (5)

Cardinality	Target	Alias	Condition
[0..1]	E_ServiceDocumentItem	_ServiceContractItemExt	`$projection.ServiceObjectType = _ServiceContractItemExt.ServiceCategory and $projection.ServiceContract = _ServiceContractItemExt.ServiceOrderItem and $projection.ServiceContractItem = _ServiceContractItemExt.ServiceLineExternalID`
[1..1]	I_ServiceContract	_ServiceContract	`$projection.ServiceContract = _ServiceContract.ServiceContract`
[0..1]	I_SrvcDocPaymentMethod	_PaymentMethod	`_PaymentMethod.PaymentMethod = $projection.PaymentMethod and _PaymentMethod.SalesOrganization = $projection.SalesOrganization and _PaymentMethod.OrgUnitTypeIDConcatenated = ''`
[0..1]	I_BusinessPartner	_RespEmployee	`_RespEmployee.BusinessPartner = $projection.RespEmployeeBusinessPartnerId`
[0..1]	I_BusinessPartner	_ContactPerson	`_ContactPerson.BusinessPartner = $projection.ContactPersonBusinessPartnerId`

Annotations (12)

Name	Value	Level
EndUserText.label	Service Contract Item	view
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.modelingPattern	#ANALYTICAL_DIMENSION	view
ObjectModel.representativeKey	ServiceContractItem	view
ObjectModel.sapObjectNodeType.name	ServiceContractItem	view
VDM.viewType	#BASIC	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view

Fields (123)

Key	Field	Source Field	Description
KEY	ServiceContract	ServiceDocument	Transaction ID
KEY	ServiceContractItem	ServiceDocumentItem	Shortened Item Number in Document
	ServiceObjectType	ServiceObjectType	Business Trans. Cat.
	ServiceContractItemCategory	ServiceDocItemCategory	Item Category
	ServiceContractDescription	ServiceDocumentDescription	Transaction Description
	ServiceDocumentType	ServiceDocumentType	Business Transaction Type
	PostingDate	PostingDate	Posting Date for a Business Transaction
	ServiceContractItemUUID	ServiceDocumentItemUUID	GUID of a CRM Order Object
	ServiceContractItemCharUUID		UUID in Character Format
	ServiceDocumentItemObjectType	ServiceDocumentItemObjectType	CRM Item Object Type
	ServiceContractUUID	ServiceDocumentUUID	GUID of a CRM Order Object
	ServiceContractItemDescription	ServiceDocumentItemDescription	Product Description
	Language	Language	Short Text Language for an Item
	ServiceDocItemCreationDateTime	ServiceDocItemCreationDateTime	Created On
	ServiceDocItemChangedDateTime	ServiceDocItemChangedDateTime	Changed On
	ServiceDocItemCreatedByUser	ServiceDocItemCreatedByUser	User that Created the Transaction
	ServiceDocItemChangedByUser	ServiceDocItemChangedByUser	Transaction Last Changed By
	Product	Product	Product Sold
	ControllingArea	ControllingArea	Controlling Area
	ProfitCenter	ProfitCenter	Profit Center
	ProfitCenterDeterminationDate	ProfitCenterDeterminationDate	Date
	RefBusinessSolutionOrder	RefBusinessSolutionOrder	Reference Solution Order ID
	RefBusinessSolutionOrderItem	RefBusinessSolutionOrderItem	Item Number in Referenced Solution Order
	ServiceContractItemQuantity	ServiceDocumentItemQuantity	CRM: Order Quantity
	ServiceContrItemQuantityUnit	ServiceDocItemQuantityUnit	Unit of Measure in Which the Product Is Sold
	BillingPlanTimeZone	BillingPlanTimeZone	Time Zone of Billing Plan Set
	BillingPriceSourceName	BillingPriceSourceName	Source of price in service confirmation
	SoldToParty	SoldToParty	Sold-to Party
	SoldToPartyCountry	SoldToPartyCountry	Country/Region
	SoldToPartyRegion	SoldToPartyRegion	Region (State, Province, County)
	RespEmployeeBusinessPartnerId		Employee Responsible
	ServiceEmployee	ServiceEmployee	Executing Service Employee
	ContactPersonBusinessPartnerId		Customer Contact Person
	PayerParty	PayerParty	Payer
	BillToParty	BillToParty	Inv. Recipient
	ShipToParty	ShipToParty	Ship-To Party (obsolete)
	ServiceContractItemStatus	ServiceDocumentItemStatus	Unique Custom Status
	ServiceContractItemHasError	ServiceDocumentItemHasError	Error Status
	ServiceContrItemBillingStatus	ServiceDocItemBillingStatus	Billing Status
	ServiceDocumentItemIsOpen	ServiceDocumentItemIsOpen	Status "Open"
	ServiceContractItemIsReleased	ServiceDocumentItemIsReleased	Release Status
	ServiceContractItemIsRejected	ServiceDocumentItemIsRejected	Cancellation Status
	SrvcDocItemTransferStatus	SrvcDocItemTransferStatus	Transfer Status
	TransactionCurrency	TransactionCurrency	Transaction Currency
	PaymentTerms	PaymentTerms	Terms of Payment
	PaymentMethod	PaymentMethod	Payment Method
	SrvcSEPAMandateRelevance	SrvcSEPAMandateRelevance	Indicator for SEPA-Relevant Transactions
	SEPAMandate	SEPAMandate	Unique Reference to Mandate per Payment Recipient
	BillableControl	BillableControl	Accounting Indicator
	ServiceContractItemNetAmount	ServiceDocumentItemNetAmount	Net Value
	ServiceDocumentItemTaxAmount	ServiceDocumentItemTaxAmount	Tax amount in document currency
	ServiceContractItemGrossAmount	ServiceDocItemGrossAmount	Gross Order Value in PO Currency
	BillingBlockReason	BillingBlockReason	Business Partner: Billing Block Reason
	PurchaseOrderByCustomer	PurchaseOrderByCustomer	Sold-To Party's External Reference Number
	PurchaseOrderByShipToParty	PurchaseOrderByShipToParty	Ship-To Party's External Reference Number
	SrvcContrItemRejectionReason	ServiceDocItemRejectionReason	Cancellation Reason Code
	SettlementPeriodRuleUUID	SettlementPeriodRuleUUID	Rule for Determining the Period Date
	BillingPlanBillingDateRuleUUID	BillingPlanBillingDateRuleUUID	Rule for Determining the Next Billing Date
	BillingPlanPriceDateRule	BillingPlanPriceDateRule	Rule for Determining the Pricing Date
	BillingPlanIsFinalized	BillingPlanIsFinalized	Billing Plan Is Finalized
	DistributionChannel	DistributionChannel	Distribution Channel
	Division	Division	Internal Division ID
	SalesOrganization	SalesOrganization	Sales Organization
	SalesOffice	SalesOffice	Sales Office
	SalesGroup	SalesGroup	Sales Group
	ServiceContrItemStartDateTime	ServiceContrItemStartDateTime	Contract Start Date
	ServiceContrItemEndDateTime	ServiceContrItemEndDateTime	Contract End Date
	SrvcContrItemRenewalDateTime	SrvcContrItemRenewalDateTime	Start Date of Auto Renewal Period
	SrvcContrItemRnwlDuration	SrvcContrItemRnwlDuration	Unit for Auto Renewal Period
	SrvcContrItemRnwlDurationUnit	SrvcContrItemRnwlDurationUnit	UOM for Auto Renewal Period
	SrvcContrItemExtensionDuration	SrvcContrItemExtensionDuration	Unit for Contract Extension
	SrvcContrItemExtnDurationUnit	SrvcContrItemExtnDurationUnit	UOM for Contract Extension
	ResponseProfile	ResponseProfile	Response Profile
	ServiceProfile	ServiceProfile	Service Profile
	SubscrpnContrTrmsAreSpecified	SubscrpnContrTrmsAreSpecified	Overwrite Default Terms
	MidBillgCycExprtnIsAllowed	MidBillgCycExprtnIsAllowed	Allow Mid-Bill-Cycle Expiration
	ServiceContractItemCanclnParty	ServiceDocumentItemCanclnParty	Cancelling Party
	ServiceContractItmCanclnReason	ServiceDocumentItmCanclnReason	CRM Service : Reason for Cancellation
	SrvcContrItmCanclnProcedure	SrvcDocItmCanclnProcedure	Cancellation Procedure
	SrvcContrRenewalDuration	ServiceDocumentRnwlDuration	Unit for Auto Renewal Period
	SrvcContrRenewalDurationUnit	ServiceDocRnwlDurationUnit	UOM for Auto Renewal Period
	SrvcContrExtensionDuration	ServiceDocExtensionDuration	Unit for Contract Extension
	SrvcContrExtensionDurationUnit	ServiceDocExtnDurationUnit	UOM for Contract Extension
	SrvcContrItemCreditStatus	SrvcDocItemCreditStatus	Credit Status of Item
	WBSElementInternalID	WBSElementInternalID	WBS Internal ID
	SrvcDocItmPartReferenceItem	SrvcDocItmPartReferenceItem	Shortened Item Number in Document
	_ServiceContract	_ServiceContract
	_PaymentMethod	_PaymentMethod
	_ServiceObjType	_ServiceObjType
	_ServiceDocumentType	_ServiceDocumentType
	_ServiceContractItemCategory	_ServiceDocItemCategory
	_Product	_Product
	_ProfitCenter	_ProfitCenter
	_SrvcDocItmLifecycleStatus	_SrvcDocItmLifecycleStatus
	_SoldToParty	_SoldToParty
	_SoldToPartyCountry	_SoldToPartyCountry
	_SoldToPartyRegion	_SoldToPartyRegion
	_PayerParty	_PayerParty
	_BillToParty	_BillToParty
	_ShipToParty	_ShipToParty
	_RespEmployee	_RespEmployee
	_ServiceEmployee	_ServiceEmployee
	_ContactPerson	_ContactPerson
	_ServiceContractItemHasError	_ServiceDocItemHasError
	_ServiceContrItemBillingStatus	_ServiceDocItemBillingStatus
	_ServiceDocumentIsOpen	_ServiceDocumentIsOpen
	_SrvcDocItemTransferStatus	_SrvcDocItemTransferStatus
	_TransactionCurrency	_TransactionCurrency
	_PaymentTerms	_PaymentTerms
	_SrvcSEPAMandateRelevance	_SrvcSEPAMandateRelevance
	_BillingBlockReason	_BillingBlockReason
	_SrvcContrItemRejectionReason	_ServiceDocItemRejectionReason
	_DistributionChannel	_DistributionChannel
	_Division	_Division
	_SalesOrganization	_SalesOrganization
	_SalesOffice	_SalesOffice
	_SalesGroup	_SalesGroup
	_SrvcContrItemRnwlDurationUnit	_SrvcContrItemRnwlDurationUnit
	_SrvcContrItemExtnDurationUnit	_SrvcContrItemExtnDurationUnit
	_ResponseProfile	_ResponseProfile
	_ServiceProfile	_ServiceProfile
	_SrvcContrItemCreditStatus	_SrvcDocItemCreditStatus
	_BillableControl	_BillableControl

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 I_ServiceContractItem.
-- 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 I_ServiceContractItem AS
SELECT
  ServiceDocument AS ServiceContract,
  ServiceDocumentItem AS ServiceContractItem,
  ServiceObjectType,
  ServiceDocItemCategory AS ServiceContractItemCategory,
  ServiceDocumentDescription AS ServiceContractDescription,
  ServiceDocumentType,
  PostingDate,
  ServiceDocumentItemUUID AS ServiceContractItemUUID,
  cast( ServiceDocumentItemCharUUID as sysuuid_c preserving type ) AS ServiceContractItemCharUUID,
  ServiceDocumentItemObjectType,
  ServiceDocumentUUID AS ServiceContractUUID,
  ServiceDocumentItemDescription AS ServiceContractItemDescription,
  Language,
  ServiceDocItemCreationDateTime,
  ServiceDocItemChangedDateTime,
  ServiceDocItemCreatedByUser,
  ServiceDocItemChangedByUser,
  Product,
  ControllingArea,
  ProfitCenter,
  ProfitCenterDeterminationDate,
  RefBusinessSolutionOrder,
  RefBusinessSolutionOrderItem,
  ServiceDocumentItemQuantity AS ServiceContractItemQuantity,
  ServiceDocItemQuantityUnit AS ServiceContrItemQuantityUnit,
  BillingPlanTimeZone,
  BillingPriceSourceName,
  SoldToParty,
  SoldToPartyCountry,
  SoldToPartyRegion,
  cast( ResponsibleEmployee as crmt_person_resp preserving type ) AS RespEmployeeBusinessPartnerId,
  ServiceEmployee,
  cast( ContactPerson as crmt_contact_person preserving type ) AS ContactPersonBusinessPartnerId,
  PayerParty,
  BillToParty,
  ShipToParty,
  ServiceDocumentItemStatus AS ServiceContractItemStatus,
  ServiceDocumentItemHasError AS ServiceContractItemHasError,
  ServiceDocItemBillingStatus AS ServiceContrItemBillingStatus,
  ServiceDocumentItemIsOpen,
  ServiceDocumentItemIsReleased AS ServiceContractItemIsReleased,
  ServiceDocumentItemIsRejected AS ServiceContractItemIsRejected,
  SrvcDocItemTransferStatus,
  TransactionCurrency,
  PaymentTerms,
  PaymentMethod,
  SrvcSEPAMandateRelevance,
  SEPAMandate,
  BillableControl,
  ServiceDocumentItemNetAmount AS ServiceContractItemNetAmount,
  ServiceDocumentItemTaxAmount,
  ServiceDocItemGrossAmount AS ServiceContractItemGrossAmount,
  BillingBlockReason,
  PurchaseOrderByCustomer,
  PurchaseOrderByShipToParty,
  ServiceDocItemRejectionReason AS SrvcContrItemRejectionReason,
  SettlementPeriodRuleUUID,
  BillingPlanBillingDateRuleUUID,
  BillingPlanPriceDateRule,
  BillingPlanIsFinalized,
  DistributionChannel,
  Division,
  SalesOrganization,
  SalesOffice,
  SalesGroup,
  ServiceContrItemStartDateTime,
  ServiceContrItemEndDateTime,
  SrvcContrItemRenewalDateTime,
  SrvcContrItemRnwlDuration,
  SrvcContrItemRnwlDurationUnit,
  SrvcContrItemExtensionDuration,
  SrvcContrItemExtnDurationUnit,
  ResponseProfile,
  ServiceProfile,
  SubscrpnContrTrmsAreSpecified,
  MidBillgCycExprtnIsAllowed,
  ServiceDocumentItemCanclnParty AS ServiceContractItemCanclnParty,
  ServiceDocumentItmCanclnReason AS ServiceContractItmCanclnReason,
  SrvcDocItmCanclnProcedure AS SrvcContrItmCanclnProcedure,
  ServiceDocumentRnwlDuration AS SrvcContrRenewalDuration,
  ServiceDocRnwlDurationUnit AS SrvcContrRenewalDurationUnit,
  ServiceDocExtensionDuration AS SrvcContrExtensionDuration,
  ServiceDocExtnDurationUnit AS SrvcContrExtensionDurationUnit,
  SrvcDocItemCreditStatus AS SrvcContrItemCreditStatus,
  WBSElementInternalID,
  SrvcDocItmPartReferenceItem
FROM I_ServiceDocumentItem
LEFT OUTER JOIN E_ServiceDocumentItem AS _ServiceContractItemExt ON ServiceObjectType = _ServiceContractItemExt.ServiceCategory AND ServiceContract = _ServiceContractItemExt.ServiceOrderItem AND ServiceContractItem = _ServiceContractItemExt.ServiceLineExternalID  -- association [0..1]
LEFT OUTER JOIN I_ServiceContract AS _ServiceContract ON ServiceContract = _ServiceContract.ServiceContract  -- association [1..1]
LEFT OUTER JOIN I_SrvcDocPaymentMethod AS _PaymentMethod ON _PaymentMethod.PaymentMethod = PaymentMethod AND _PaymentMethod.SalesOrganization = SalesOrganization AND _PaymentMethod.OrgUnitTypeIDConcatenated = ''  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _RespEmployee ON _RespEmployee.BusinessPartner = RespEmployeeBusinessPartnerId  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _ContactPerson ON _ContactPerson.BusinessPartner = ContactPersonBusinessPartnerId  -- association [0..1]
;

Depth:

I_ServiceContractItem view_entity

I_ServiceDocumentItem view

I_ServiceContractItemEnhcd view_entity
I_SrvcContrItemWithAutoRenewal view_entity