Which tables does C_SitnInstanceTP use?

C_SitnInstanceTP reads from 1 data source(s): I_SitnInstceByApplicationTag.

How many fields does C_SitnInstanceTP have?

C_SitnInstanceTP has 23 fields. Key fields: SitnInstanceID.

C_SitnInstanceTP

DDL: C_SITNINSTANCETP SQL: CSITNINSTTP Type: view_entity CONSUMPTION

Enhanced SIT Instance Consumption

C_SitnInstanceTP is a Consumption CDS View that provides data about "Enhanced SIT Instance Consumption" in SAP S/4HANA. It reads from 1 data source (I_SitnInstceByApplicationTag) and exposes 23 fields with key field SitnInstanceID. It has 5 associations to related views. It is exposed through 1 OData service (C_SITNINSTANCETP_CDS). It is used in 16 Fiori applications: Manage Dispute Cases (Version 2), Manage Purchase Requisition Professional, Manage Central Purchase Contracts, ....

Data Sources (1)

Source	Alias	Join Type
I_SitnInstceByApplicationTag	Instance	from

Associations (5)

Cardinality	Target	Alias	Condition
[0..*]	I_SitnDefApplicationTag	_ApplicationTag	`_ApplicationTag.SitnDefTemplateID = Instance.SitnDefTemplateID`
[1..1]	I_SitnDefCondition	_Condition	`Instance.SitnDefinitionID = _Condition.SitnDefinitionID`
[0..1]	I_SitnDefNotif	_Notification	`Instance.SitnDefinitionID = _Notification.SitnDefinitionID and _Notification.SitnDefNotificationID = '0001'`
[1..1]	I_SitnDefTextForSitnInstance	_InstanceText	`_InstanceText.SitnInstanceID = $projection.SitnInstanceID and _InstanceText.Language = $session.system_language`
[1..*]	C_SitnInstceMessageParameter	_InstanceMessageParameter	`_InstanceMessageParameter.SitnInstanceID = $projection.SitnInstanceID`

Annotations (8)

Name	Value	Level
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Enhanced SIT Instance Consumption	view
VDM.viewType	#CONSUMPTION	view
VDM.lifecycle.status	#DEPRECATED	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.query.implementedBy	ABAP:CL_SIT_INST_CUSTOM_QUERY	view

OData Services (1)

Service	Binding	Version	Contract	Release
C_SITNINSTANCETP_CDS	C_SITNINSTANCETP_CDS	V2	C1	NOT_RELEASED

Fiori Apps (16)

App ID	App Name	Type	Description
F0702A	Manage Dispute Cases (Version 2)	Transactional	Use this app to analyze and further process existing dispute cases. This involves dispute cases that are related to open receivables for your customers.
F2229	Manage Purchase Requisition Professional	Transactional	An application to manage Professional Purchase Requisitions
F3144	Manage Central Purchase Contracts	Transactional	A worklist application to manage Central Purchase Contracts. Central Contract Management is used to negotiate a global longer-term agreement between an Organization and a supplier regarding the supply of materials or the performance of services within a certain period as per predefined terms and conditions.
F3201	Reuse Library for Situation Handling	Transactional, Reuse Component	This is a reuse library that contains reuse components that are embedded in selected SAP Fiori V2 / UI5 applications to display situation messages and related situations to the end user in the respective app.
F3548	Run Allocations	Transactional	An app for execution of universal allocation run
F4025	Manage In-House Services	Transactional	You can use this app to create and process in-house services, and add in-house objects (service object) for which you want to perform maintenance or repair. You can filter, sort, and group a list of all in-house services in the system. You can also call up in-house services, and change their data.
F4050	Perform Prechecks	Transactional	You can use this app to decide whether the repair object is marked for repair or whether it is sent back to the customer.
F4152	Plan Repairs	Transactional	You can use this app to schedule the repair of the objects and assign the service employee.
F4241	Perform Repairs	Transactional	You can use this app to access the repair order that contains the details about the repair. You confirm the required service products, service parts, and expenses in this order.
F4263	Prepare for Billing	Transactional	You can use this app to see an overview of the repair objects that are ready for billing.
F4363	Allocation Results	Transactional	An app for display of allocation run results
F4580	Process Repair Quotations	Transactional	You can use this app to access the repair quotation. You process the repair quotation and send it to the customer. When the customer agrees the estimated costs for the repair, you set the repair quotation to Accepted.
F4861	Manage Sourcing Projects	Transactional	An application to create and manage sourcing projects.
F5934	Display Sourcing Project	Transactional	An application to approve Sourcing Projects.
F7345	Display Central Purchase Contract in My Inbox	Transactional	Display variant of Manage Central Purchase Contracts (F3144) used in My Inbox, for the approvers to take necessary action.
F7757	Contribute to Sourcing Projects	Transactional	The app is an application to contribute to sourcing projects as an additional user.

Manage Dispute Cases (Version 2)

Business Role: Accounts Receivable Accountant

Use this app to analyze and further process existing dispute cases. This involves dispute cases that are related to open receivables for your customers.

Manage Purchase Requisition Professional

Business Role: Purchaser

With this app, you can view and maintain purchase requisitions; also, edit the same with necessary authorizations. The app ensures the availability of requested items on time, at the required location, and in the required quantity.

Manage Central Purchase Contracts

Business Role: Purchaser - Central Procurement

With this feature, you can edit specific fields at the header and item levels of distributed purchase outline agreements (purchase contracts and purchase scheduling agreements) in their connected systems. This feature allows you to directly edit the distributed documents within their connected systems instead of editing and redistributing the central purchase contract or central purchase contract hierarchy from the hub system.

Reuse Library for Situation Handling

Business Role: Others

With this app, which isn’t a standalone app but a reuse component, you can see standard object-based situations displayed as a message in a business app that uses Situation Handling.

Key Features: The app provides the following key features: Display of a message text in the business app that has embedded the reuse component. The message text can contain variables and a link to further information, such as a process handbook. Users can close the situation directly from the reuse component by selecting an appropriate status.

Run Allocations

Business Role: Cost Accountant - Overhead

You use this app to run your allocation cycles. It allows you to perform a test run or actual run of any existing allocation cycle. You can access the app from the Manage Allocations app or from the Fiori launchpad. When you access this app from Manage Allocations, you go directly to your worklist. When you access the app from the Fiori launchpad, you go directly to the results of your completed allocation runs. Key Features Initiate runs for multiple allocation cycles at the same time Perform test runs on allocation cycles for a specific period

Fields (23)

Key	Field	Source Table	Source Field
KEY	SitnInstanceID	I_SitnInstceByApplicationTag	SitnInstanceID
	SitnDefinitionID	I_SitnInstceByApplicationTag	SitnDefinitionID
	SitnInstceAnchorObjectKey	I_SitnInstceByApplicationTag	SitnInstceAnchorObjectKey
	SitnInstceTriggerObjectKey	I_SitnInstceByApplicationTag	SitnInstceTriggerObjectKey
	CreationDateTime	I_SitnInstceByApplicationTag	CreationDateTime
	SitnDefRank	I_SitnInstceByApplicationTag	SitnDefRank
	SitnDefAnchorObject	I_SitnInstceByApplicationTag	SitnDefAnchorObject
	SitnDefPageVariantIsEnabled	I_SitnInstceByApplicationTag	SitnDefPageVariantIsEnabled
	SitnDefTemplateID	I_SitnInstceByApplicationTag	SitnDefTemplateID
	SitnDefAnchorObjectView
	SitnFioriID	I_SitnInstceByApplicationTag	SitnFioriID
	SitnPageID	I_SitnInstceByApplicationTag	SitnPageID
	SitnElementID	I_SitnInstceByApplicationTag	SitnElementID
	SitnDefShortText	_InstanceText	SitnDefShortText
	SitnDefLongText	_InstanceText	SitnDefLongText
	SitnDefDetailsLink	_InstanceText	SitnDefDetailsLink
	SitnDefDetailsLinkText	_InstanceText	SitnDefDetailsLinkText
	SitnDefName	_InstanceText	SitnDefName
	SitnTriggerObjectKeyField	_Condition	SitnTriggerObjectKeyField
	SitnDefPageVariantID	_Notification	SitnDefPageVariantID
	_Definition	I_SitnInstceByApplicationTag	_Definition
	_ApplicationTag		_ApplicationTag
	_InstanceMessageParameter		_InstanceMessageParameter

//@AbapCatalog.sqlViewName: 'CSITNINSTTP'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Enhanced SIT Instance Consumption'
//@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM: {
 viewType: #CONSUMPTION, 
 usage.type: [#TRANSACTIONAL_PROCESSING_SERVICE],
 lifecycle: {
  status: #DEPRECATED
// successor: <name of successor view>

}}

@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED

@ObjectModel.query.implementedBy: 'ABAP:CL_SIT_INST_CUSTOM_QUERY'

define root view entity C_SitnInstanceTP
  as select from    I_SitnInstceByApplicationTag     as Instance
    
  association [0..*] to I_SitnDefApplicationTag      as _ApplicationTag           on  _ApplicationTag.SitnDefTemplateID       = Instance.SitnDefTemplateID
  association [1..1] to I_SitnDefCondition           as _Condition                on  Instance.SitnDefinitionID               = _Condition.SitnDefinitionID
  association [0..1] to I_SitnDefNotif               as _Notification             on  Instance.SitnDefinitionID               = _Notification.SitnDefinitionID
                                                                                 and _Notification.SitnDefNotificationID      = '0001'
  association [1..1] to I_SitnDefTextForSitnInstance as _InstanceText             on  _InstanceText.SitnInstanceID            = $projection.SitnInstanceID     
                                                                                 and  _InstanceText.Language                  = $session.system_language

  association [1..*] to C_SitnInstceMessageParameter as _InstanceMessageParameter on _InstanceMessageParameter.SitnInstanceID = $projection.SitnInstanceID

{
  key Instance.SitnInstanceID,
      Instance.SitnDefinitionID,
      Instance.SitnInstceAnchorObjectKey,
      Instance.SitnInstceTriggerObjectKey,
      Instance.CreationDateTime,

      Instance.SitnDefRank,
      Instance.SitnDefAnchorObject,
      Instance.SitnDefPageVariantIsEnabled,
      
      Instance.SitnDefTemplateID, 
      @Consumption.hidden: true
      Instance._Definition.SitnDefAnchorObjectView,
      
      Instance.SitnFioriID,
      Instance.SitnPageID,
      Instance.SitnElementID,
      
      _InstanceText.SitnDefShortText,
      _InstanceText.SitnDefLongText,
      _InstanceText.SitnDefDetailsLink,
      _InstanceText.SitnDefDetailsLinkText,
      _InstanceText.SitnDefName,

      _Condition.SitnTriggerObjectKeyField, // SitnTriggerObject was replaced with SitnTriggerObjectKeyField


      _Notification.SitnDefPageVariantID,
      
      /* Associations */
          
      @Consumption.hidden: true
      @ObjectModel.filter.enabled: false
      @ObjectModel.sort.enabled: false
      Instance._Definition,
      
      @ObjectModel.filter.enabled: false
      _ApplicationTag,
      
      @ObjectModel.filter.enabled: false
      _InstanceMessageParameter

}
where
  Instance.SitnInstceStatus = 'OP'

Depth:

C_SitnInstanceTP view_entity

I_SitnInstceByApplicationTag view