What is C_SubscriptionContractItemDEX in SAP S/4HANA?

C_SubscriptionContractItemDEX is a consumption CDS view in SAP S/4HANA. Data Extract Subscription Contract Item It contains 119 fields.

Which tables does C_SubscriptionContractItemDEX read from?

C_SubscriptionContractItemDEX reads data from: R_SubscriptionContractItemTP.

What VDM layer is C_SubscriptionContractItemDEX?

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

C_SubscriptionContractItemDEX

DDL: C_SUBSCRIPTIONCONTRACTITEMDEX Type: view_entity CONSUMPTION

119 Fields 1 Data Sources 7 Associations

Data Extract Subscription Contract Item

C_SubscriptionContractItemDEX (Consumption)

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

SubscriptionContractItem · Sales

C_SubscriptionContractItemDEX is a Consumption CDS View (Fact) that provides data about "Data Extract Subscription Contract Item" in SAP S/4HANA. It reads from 1 data source (R_SubscriptionContractItemTP) and exposes 119 fields with key fields SubscriptionContract, SubscriptionContractItem, ServiceObjectType. It has 7 associations to related views.

SAP Help Documentation

Category	Data Extraction
Data Category	Fact
Status	Legal Control Status

Purpose
This CDS view is app-independent and is available for all external consumers who want to extract subscription contract item fields to SAP Business Warehouse (SAP BW) or other external systems. 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 the following authorization objects assigned: Authorization Object ID Description CRMS4_SLSO Sales Organizational Units of Service Transactions CRMS4_SOLO Authorization Object for Solution Order CRM_CON_SE Authorization Object CRM Order - Bus.Ob.Service Confirmation CRM_CO_SE Authorization Object CRM Order - Bus. Ob. Service Contract CRM_ORD_OE Authorization Object CRM Order - Allowed Organ. Units CRM_ORD_OP Authorization Object CRM Order - Own Documents CRM_ORD_PR Authorization Object CRM Order - Business Transaction Type CRM_SEO Authorization Object CRM Order-Business Object Service Order

Structure
Important Fields Important fields in this view include the following: Field Name Description SubscriptionContract Key Transaction ID SubscriptionContractItem Key Item Number in Doc. ServiceObjectType Key Trans. Cat. SubscriptionContractExternalID Contract Number ServiceDocumentType Transaction Type SubscrpnContractItemCategory Item Category Product Product SubscrpnProductSpecification Product Quantity Order Quantity QuantityUnit Sales Unit TransactionCurrency Currency SubscrpnContrItmGrossAmount Gross Order Value SubscrpnContrItmNetAmount Net Value SubscrpnContrItmDspNetAmount Net Value SubscrpnContrItmTaxAmount Tax amount SubscrpnContrItmOneTmeNetAmt Net Value SubscrpnContrItmOneTmeGrossAmt Gross Order Value SubscrpnContrItmOneTmeTaxAmt Tax amount SbscrContrItmRecrrgChrgNetAmt Recurring Charge SbscrContrItmRecrrgChrgGrssAmt Rec.Charg.incl.tax SbscrContrItmRecrrgChrgTaxAmt Recurring Taxes PaymentTerms Terms of Payment CAPartnerSettlementRule Settlement Rule SubscriptionContrItmDesc Product Description SubscriptionContractUUID Object GUID SubscriptionContractItemUUID Object GUID SubscrpnContrItmCharUUID Object GUID ParentSubscrpnContractItemUUID Object GUID SubscrpnOrdProdSelType Prod.Selection Type SubscrpnContrItmIsMainItem Contract Main Item Language Language SalesOrganization Sales Organization DistributionChannel Distribution Channel Division Division SalesOffice Sales Office SalesGroup Sales Group SalesOrganizationOrgUnitID Sales Org. ID SalesOfficeOrgUnitID Sales Office SalesGroupOrgUnitID Sales Group ServiceOrganization Service Organization SubscrpnContractItemIsActive Technically Active SubscrpnContractItemIsRejected Cancellation Status SubscrpnContrItmIsCancelled Cancelled SubscriptionContractItemStatus Life Cycle Status SubscrpnContrItmHasError Error Status SubscrpnContrItmCrdtSts Item Credit Status SubscrpnContrActivationStatus Activation Status SubscrpnContrTimeSliceStatus Time Slice Status SbsConItmGTSEmbargoStatus Embargo Status SbsConItmGTSScreeningStatus Screening Status SbsConItmGTSLglControlStatus Legal Control Status SbscrContrItmCanclnProcedure Cancellation Proced. SbscrContrItemCanclnReason Cancellation Reason SbscrContrItemCanclnParty Cancelling Party SubscrpnContrItmRjcnRsn Cancel. Reason Code SubscrpnContrItmCanclnDteTme Contract End Date SubscrpnContrItmStartDateTime Contract Start Date SubscrpnContrItmEndDateTime Contract End Date SbscrContrTimeSliceStrtDteTme Start of Contract TS SbscrContrTimeSliceEndDteTme End of Contract TS SubscrpnContrAutoRnwlIsActv Enable Auto-Renewal SbscrContrAutoRnwlIsActvForDsp Enable Auto-Renewal SubscrpnContrItmRnwlDteTme Auto Renewal Start SrvcContrItemRnwlDuration

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Sales
Application Component	CRM-S4-SOM
Capabilities	Data Source for Data Extraction
Package	Sales for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view is app-independent and is available for all external consumers who want to extract subscription contract item fields to SAP Business Warehouse (SAP BW) or other external systems. </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 Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
R_SubscriptionContractItemTP	R_SubscriptionContractItemTP	from

Associations (7)

Cardinality	Target	Alias	Condition
[0..*]	I_SrvcTransChgProcText	_ChangeProcText	`$projection.SrvcTransChangeProcess = _ChangeProcText.SrvcTransChangeProcess`
[0..*]	I_SrvcTransChgProcGrpText	_ChangeProcGrpText	`$projection.SrvcTransChangeProcessGroup = _ChangeProcGrpText.SrvcTransChangeProcessGroup`
[0..*]	I_SbscrContrItmWthdrwlRsnTxt	_WithdrawReasonText	`$projection.SubscrpnContrItmWthdrwlRsn = _WithdrawReasonText.SubscrpnContrItmWthdrwlRsn`
[0..*]	I_SrvcDocItmGTSStatusText	_GTSEmbargoStatusText	`$projection.SbsConItmGTSEmbargoStatus = _GTSEmbargoStatusText.SrvcDocItmGTSStatus`
[0..*]	I_SrvcDocItmGTSStatusText	_GTSScreeningStatusText	`$projection.SbsConItmGTSScreeningStatus = _GTSScreeningStatusText.SrvcDocItmGTSStatus`
[0..*]	I_SrvcDocItmGTSStatusText	_GTSLglControlStatusText	`$projection.SbsConItmGTSLglControlStatus = _GTSLglControlStatusText.SrvcDocItmGTSStatus`
[0..1]	E_ServiceDocumentItem	_ExtensionItem	`$projection.ServiceObjectType = _ExtensionItem.ServiceCategory and $projection.SubscriptionContract = _ExtensionItem.ServiceOrderItem and $projection.SubscriptionContractItem = _ExtensionItem.ServiceLineExternalID`

Annotations (12)

Name	Value	Level
EndUserText.label	Data Extract Subscription Contract Item	view
Metadata.ignorePropagatedAnnotations	true	view
AccessControl.authorizationCheck	#MANDATORY	view
VDM.viewType	#CONSUMPTION	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
Analytics.dataCategory	#FACT	view
Analytics.technicalName	C_SubscriptionContrctItmDEX	view
Analytics.dataExtraction.enabled	true	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.sapObjectNodeType.name	SubscriptionContractItem	view

Fields (119)

Key	Field	Source Field	Description
KEY	SubscriptionContract	SubscriptionContract	Transaction ID
KEY	SubscriptionContractItem	SubscriptionContractItem	Shortened Item Number in Document
KEY	ServiceObjectType	ServiceObjectType	Business Trans. Cat.
	SubscriptionContractExternalID	SubscriptionContractExternalID	IS-T Contract Number
	ServiceDocumentType	ServiceDocumentType	Business Transaction Type
	SubscrpnContractItemCategory	SubscrpnContractItemCategory	Item Category
	Product	Product	Product Number
	SubscrpnProductSpecification	SubscrpnProductSpecification	Product Number
	Quantity	Quantity	CRM: Order Quantity
	QuantityUnit	QuantityUnit	Unit of Measure in Which the Product Is Sold
	TransactionCurrency	TransactionCurrency	Transaction Currency
	SubscrpnContrItmGrossAmount	SubscrpnContrItmGrossAmount	Gross Order Value in PO Currency
	SubscrpnContrItmNetAmount	SubscrpnContrItmNetAmount	Net Value
	SubscrpnContrItmDspNetAmount	SubscrpnContrItmDspNetAmount	Net Value
	SubscrpnContrItmTaxAmount	SubscrpnContrItmTaxAmount	Tax amount in document currency
	SubscrpnContrItmOneTmeNetAmt	SubscrpnContrItmOneTmeNetAmt	Net Value
	SubscrpnContrItmOneTmeGrossAmt	SubscrpnContrItmOneTmeGrossAmt	Gross Order Value in PO Currency
	SubscrpnContrItmOneTmeTaxAmt	SubscrpnContrItmOneTmeTaxAmt	Tax amount in document currency
	SbscrContrItmRecrrgChrgNetAmt	SbscrContrItmRecrrgChrgNetAmt	Periodically charged values
	SbscrContrItmRecrrgChrgGrssAmt	SbscrContrItmRecrrgChrgGrssAmt	Periodically charged values including taxes
	SbscrContrItmRecrrgChrgTaxAmt	SbscrContrItmRecrrgChrgTaxAmt	Periodically charged taxes
	PaymentTerms	PaymentTerms	Terms of Payment
	CAPartnerSettlementRule	CAPartnerSettlementRule	Partner Settlement Rule
	SubscriptionContrItmDesc	SubscriptionContrItmDesc	Product Description
	SubscriptionContractUUID	SubscriptionContractUUID	GUID of a CRM Order Object
	SubscriptionContractItemUUID	SubscriptionContractItemUUID	GUID of a CRM Order Object
	SubscrpnContrItmCharUUID	SubscrpnContrItmCharUUID	32 Character CRM Object GUID (Converted)
	ParentSubscrpnContractItemUUID	ParentSubscrpnContractItemUUID	GUID of a CRM Order Object
	SubscrpnOrdProdSelType	SubscrpnOrdProdSelType	Product Selection Type
	SubscrpnContrItmIsMainItem	SubscrpnContrItmIsMainItem	Contract Main Item
	Language	Language	Short Text Language for an Item
	SalesOrganization	SalesOrganization	Sales Organization
	DistributionChannel	DistributionChannel	Distribution Channel
	Division	Division	Internal Division ID
	SalesOffice	SalesOffice	Sales Office
	SalesGroup	SalesGroup	Sales Group
	SalesOrganizationOrgUnitID	SalesOrganizationOrgUnitID	Sales Organization ID
	SalesOfficeOrgUnitID	SalesOfficeOrgUnitID	Sales Office
	SalesGroupOrgUnitID	SalesGroupOrgUnitID	Sales Group
	ServiceOrganization	ServiceOrganization	Service Organization
	SubscrpnContractItemIsActive	SubscrpnContractItemIsActive	Technically Active
	SubscrpnContractItemIsRejected	SubscrpnContractItemIsRejected	Cancellation Status
	SubscrpnContrItmIsCancelled	SubscrpnContrItmIsCancelled	Cancelled
	SubscriptionContractItemStatus	SubscriptionContractItemStatus	Life Cycle Status
	SubscrpnContrItmHasError	SubscrpnContrItmHasError	Error Status
	SubscrpnContrItmCrdtSts	SubscrpnContrItmCrdtSts	Credit Status of Item
	SubscrpnContrActivationStatus	SubscrpnContrActivationStatus	Activation Status of Subscription Order/Contract
	SubscrpnContrTimeSliceStatus	SubscrpnContrTimeSliceStatus	Status of Contract Time Slice
	SbsConItmGTSEmbargoStatus	SbsConItmGTSEmbargoStatus	Embargo Status (Item)
	SbsConItmGTSScreeningStatus	SbsConItmGTSScreeningStatus	Screening Status (Item)
	SbsConItmGTSLglControlStatus	SbsConItmGTSLglControlStatus	Legal Control Check Status
	SbscrContrItmCanclnProcedure	SbscrContrItmCanclnProcedure	Cancellation Procedure
	SbscrContrItemCanclnReason	SbscrContrItemCanclnReason	CRM Service : Reason for Cancellation
	SbscrContrItemCanclnParty	SbscrContrItemCanclnParty	Cancelling Party
	SubscrpnContrItmRjcnRsn	SubscrpnContrItmRjcnRsn	Cancellation Reason Code
	SubscrpnContrItmCanclnDteTme	SubscrpnContrItmCanclnDteTme	Contract End Date
	SubscrpnContrItmStartDateTime	SubscrpnContrItmStartDateTime	Contract Start date
	SubscrpnContrItmEndDateTime	SubscrpnContrItmEndDateTime	Contract End Date
	SbscrContrTimeSliceStrtDteTme	SbscrContrTimeSliceStrtDteTme	Start of Contract Time Slice
	SbscrContrTimeSliceEndDteTme	SbscrContrTimeSliceEndDteTme	End of Contract Time Slice
	SubscrpnContrAutoRnwlIsActv	SubscrpnContrAutoRnwlIsActv	Auto-Renewal Indicator
	SbscrContrAutoRnwlIsActvForDsp	SbscrContrAutoRnwlIsActvForDsp	Auto-Renewal Indicator
	SubscrpnContrItmRnwlDteTme	SubscrpnContrItmRnwlDteTme	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
	PurchaseOrderByCustomer	PurchaseOrderByCustomer	Sold-To Party's External Reference Number
	PurchaseOrderByShipToParty	PurchaseOrderByShipToParty	Ship-To Party's External Reference Number
	SrvcTransChangeProcess	SrvcTransChangeProcess	Process of Maint. FW
	SrvcTransChangeProcessType	SrvcTransChangeProcessType	Process Type
	SrvcTransChangeProcessGroup	SrvcTransChangeProcessGroup	BTMF Process Group
	SoldToParty	SoldToParty	Sold-to Party
	ShipToParty	ShipToParty	Ship-To Party (obsolete)
	BillToParty	BillToParty	Inv. Recipient
	PayerParty	PayerParty	Payer
	ContactPersonBusinessPartnerId	ContactPersonBusinessPartnerId	Customer Contact Person
	RespEmployeeBusinessPartnerId	RespEmployeeBusinessPartnerId	Employee Responsible
	ContractAccount	ContractAccount	Contract Account Number
	CABillgCycle	CABillgCycle	Billing Cycle
	SubscrpnContrItmBillgPlnCyc	SubscrpnContrItmBillgPlnCyc	Billing Plan Cycle
	CrsCatalogMappingVersionNumber	CrsCatalogMappingVersionNumber	Version
	SbscrContrItmRecrrgChrgDurn	SbscrContrItmRecrrgChrgDurn	Duration of a recurrence period
	SbscrContrItmRcrChrDurUnit	SbscrContrItmRcrChrDurUnit	Time unit of a recurrence period
	CustMgmtMasterAgreement	CustMgmtMasterAgreement	Transaction ID
	CustMgmtMstrAgrmtItem	CustMgmtMstrAgrmtItem	Shortened Item Number in Document
	CustMgmtMstrAgrmtParentItem	CustMgmtMstrAgrmtParentItem	Shortened Item Number in Document
	SbscrShContrSvTrMtAgrItmUUID	SbscrShContrSvTrMtAgrItmUUID	Sharing Order/Contract: Reference to Master Agreement
	SbscrShContrSvTrMtAgrItmCstPrd	SbscrShContrSvTrMtAgrItmCstPrd	Sharing Order/Contract: Reference to Master Agreement Prod.
	SvTrMtAgrItmIsFxdConfign	SvTrMtAgrItmIsFxdConfign	Fixed Configuration
	SharingContractID	SharingContractID	Reference to Sharing Contract
	SubscrpnContractSharingGroupID	SubscrpnContractSharingGroupID	Sharing Group ID
	ConfigurationNumber	ConfigurationNumber	Configuration (Internal Object Number)
	SubscrpnContrItmHasConfign	SubscrpnContrItmHasConfign	Configuration
	SubscrpnContrItemIsPhased	SubscrpnContrItemIsPhased	Phase Indicator
	SbscrContrItmPhasedPrdcssrItm	SbscrContrItmPhasedPrdcssrItm	Shortened Item Number in Document
	SubscrpnContrItmPostgDte	SubscrpnContrItmPostgDte	Posting Date for a Business Transaction
	SubscrpnContrItmCrtedByUsr	SubscrpnContrItmCrtedByUsr	User that Created the Transaction
	SubscrpnContrItmChgdByUsr	SubscrpnContrItmChgdByUsr	Transaction Last Changed By
	SubscrpnContrItmCrtnDteTme	SubscrpnContrItmCrtnDteTme	Created At
	SubscrpnContrItmChgdDteTme	SubscrpnContrItmChgdDteTme	Changed At
	SubscrpnContrItmPrtnRefItm	SubscrpnContrItmPrtnRefItm	Shortened Item Number in Document
	SubscrpnContrItmApptRefObjUUID	SubscrpnContrItmApptRefObjUUID	GUID of a CRM Order Object
	SubscrpnContrItmApptRefItm	SubscrpnContrItmApptRefItm	Shortened Item Number in Document
	SubscrpnContrItmIsWithdrawn	SubscrpnContrItmIsWithdrawn	Withdrawal Status
	SubscrpnContrItmWthdrwlRsn	SubscrpnContrItmWthdrwlRsn	Reason for Withdrawal of Subscription Contract
	SubscrpnContrItmRfndType	SubscrpnContrItmRfndType	Refund Code for Withdrawal of Subscription Contract
	SbscrContrItmAcctAssgmtObjType	SbscrContrItmAcctAssgmtObjType	Obj.Type for Sett.Acc.Assgnmnt for Search Help or Cust.Exit
	SbscrContrItmAcctAssgmtObject	SbscrContrItmAcctAssgmtObject	Settlement Account Assignment
	WBSElementExternalID	WBSElementExternalID	Work Breakdown Structure Element (WBS Element) Edited
	SubscrpnContrSubitemOrigin	SubscrpnContrSubitemOrigin	Usage of Higher-Level Item
	SubscrpnContrItmBillgPlnType	SubscrpnContrItmBillgPlnType	Billing Plan Type
	_SubscriptionContractDEX	_SubscriptionContractDEX
	_ChangeProcText	_ChangeProcText
	_ChangeProcGrpText	_ChangeProcGrpText
	_WithdrawReasonText	_WithdrawReasonText
	_GTSEmbargoStatusText	_GTSEmbargoStatusText
	_GTSLglControlStatusText	_GTSLglControlStatusText
	_GTSScreeningStatusText	_GTSScreeningStatusText

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_SubscriptionContractItemDEX.
-- 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 C_SubscriptionContractItemDEX AS
SELECT
  SubscriptionContract,
  SubscriptionContractItem,
  ServiceObjectType,
  SubscriptionContractExternalID,
  ServiceDocumentType,
  SubscrpnContractItemCategory,
  Product,
  SubscrpnProductSpecification,
  Quantity,
  QuantityUnit,
  TransactionCurrency,
  SubscrpnContrItmGrossAmount,
  SubscrpnContrItmNetAmount,
  SubscrpnContrItmDspNetAmount,
  SubscrpnContrItmTaxAmount,
  SubscrpnContrItmOneTmeNetAmt,
  SubscrpnContrItmOneTmeGrossAmt,
  SubscrpnContrItmOneTmeTaxAmt,
  SbscrContrItmRecrrgChrgNetAmt,
  SbscrContrItmRecrrgChrgGrssAmt,
  SbscrContrItmRecrrgChrgTaxAmt,
  PaymentTerms,
  CAPartnerSettlementRule,
  SubscriptionContrItmDesc,
  SubscriptionContractUUID,
  SubscriptionContractItemUUID,
  SubscrpnContrItmCharUUID,
  ParentSubscrpnContractItemUUID,
  SubscrpnOrdProdSelType,
  SubscrpnContrItmIsMainItem,
  Language,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization,
  SubscrpnContractItemIsActive,
  SubscrpnContractItemIsRejected,
  SubscrpnContrItmIsCancelled,
  SubscriptionContractItemStatus,
  SubscrpnContrItmHasError,
  SubscrpnContrItmCrdtSts,
  SubscrpnContrActivationStatus,
  SubscrpnContrTimeSliceStatus,
  SbsConItmGTSEmbargoStatus,
  SbsConItmGTSScreeningStatus,
  SbsConItmGTSLglControlStatus,
  SbscrContrItmCanclnProcedure,
  SbscrContrItemCanclnReason,
  SbscrContrItemCanclnParty,
  SubscrpnContrItmRjcnRsn,
  SubscrpnContrItmCanclnDteTme,
  SubscrpnContrItmStartDateTime,
  SubscrpnContrItmEndDateTime,
  SbscrContrTimeSliceStrtDteTme,
  SbscrContrTimeSliceEndDteTme,
  SubscrpnContrAutoRnwlIsActv,
  SbscrContrAutoRnwlIsActvForDsp,
  SubscrpnContrItmRnwlDteTme,
  SrvcContrItemRnwlDuration,
  SrvcContrItemRnwlDurationUnit,
  SrvcContrItemExtensionDuration,
  SrvcContrItemExtnDurationUnit,
  PurchaseOrderByCustomer,
  PurchaseOrderByShipToParty,
  SrvcTransChangeProcess,
  SrvcTransChangeProcessType,
  SrvcTransChangeProcessGroup,
  SoldToParty,
  ShipToParty,
  BillToParty,
  PayerParty,
  ContactPersonBusinessPartnerId,
  RespEmployeeBusinessPartnerId,
  ContractAccount,
  CABillgCycle,
  SubscrpnContrItmBillgPlnCyc,
  CrsCatalogMappingVersionNumber,
  SbscrContrItmRecrrgChrgDurn,
  SbscrContrItmRcrChrDurUnit,
  CustMgmtMasterAgreement,
  CustMgmtMstrAgrmtItem,
  CustMgmtMstrAgrmtParentItem,
  SbscrShContrSvTrMtAgrItmUUID,
  SbscrShContrSvTrMtAgrItmCstPrd,
  SvTrMtAgrItmIsFxdConfign,
  SharingContractID,
  SubscrpnContractSharingGroupID,
  ConfigurationNumber,
  SubscrpnContrItmHasConfign,
  SubscrpnContrItemIsPhased,
  SbscrContrItmPhasedPrdcssrItm,
  SubscrpnContrItmPostgDte,
  SubscrpnContrItmCrtedByUsr,
  SubscrpnContrItmChgdByUsr,
  SubscrpnContrItmCrtnDteTme,
  SubscrpnContrItmChgdDteTme,
  SubscrpnContrItmPrtnRefItm,
  SubscrpnContrItmApptRefObjUUID,
  SubscrpnContrItmApptRefItm,
  SubscrpnContrItmIsWithdrawn,
  SubscrpnContrItmWthdrwlRsn,
  SubscrpnContrItmRfndType,
  SbscrContrItmAcctAssgmtObjType,
  SbscrContrItmAcctAssgmtObject,
  WBSElementExternalID,
  SubscrpnContrSubitemOrigin,
  SubscrpnContrItmBillgPlnType
FROM R_SubscriptionContractItemTP
LEFT OUTER JOIN I_SrvcTransChgProcText AS _ChangeProcText ON SrvcTransChangeProcess = _ChangeProcText.SrvcTransChangeProcess  -- association [0..*]
LEFT OUTER JOIN I_SrvcTransChgProcGrpText AS _ChangeProcGrpText ON SrvcTransChangeProcessGroup = _ChangeProcGrpText.SrvcTransChangeProcessGroup  -- association [0..*]
LEFT OUTER JOIN I_SbscrContrItmWthdrwlRsnTxt AS _WithdrawReasonText ON SubscrpnContrItmWthdrwlRsn = _WithdrawReasonText.SubscrpnContrItmWthdrwlRsn  -- association [0..*]
LEFT OUTER JOIN I_SrvcDocItmGTSStatusText AS _GTSEmbargoStatusText ON SbsConItmGTSEmbargoStatus = _GTSEmbargoStatusText.SrvcDocItmGTSStatus  -- association [0..*]
LEFT OUTER JOIN I_SrvcDocItmGTSStatusText AS _GTSScreeningStatusText ON SbsConItmGTSScreeningStatus = _GTSScreeningStatusText.SrvcDocItmGTSStatus  -- association [0..*]
LEFT OUTER JOIN I_SrvcDocItmGTSStatusText AS _GTSLglControlStatusText ON SbsConItmGTSLglControlStatus = _GTSLglControlStatusText.SrvcDocItmGTSStatus  -- association [0..*]
LEFT OUTER JOIN E_ServiceDocumentItem AS _ExtensionItem ON ServiceObjectType = _ExtensionItem.ServiceCategory AND SubscriptionContract = _ExtensionItem.ServiceOrderItem AND SubscriptionContractItem = _ExtensionItem.ServiceLineExternalID  -- association [0..1]
;

Depth:

C_SubscriptionContractItemDEX view_entity

R_SubscriptionContractItemTP view_entity