Which tables does C_SitnRelatedSituation use?

C_SitnRelatedSituation reads from 1 data source(s): I_SitnRelatedSituation.

How many fields does C_SitnRelatedSituation have?

C_SitnRelatedSituation has 13 fields. Key fields: SitnInstanceID, SitnDefRelatedObjectID.

C_SitnRelatedSituation

DDL: C_SITNRELATEDSITUATION Type: view CONSUMPTION

Related Situation

C_SitnRelatedSituation is a Consumption CDS View that provides data about "Related Situation" in SAP S/4HANA. It reads from 1 data source (I_SitnRelatedSituation) and exposes 13 fields with key fields SitnInstanceID, SitnDefRelatedObjectID. It has 4 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_SitnRelatedSituation	RelatedSituation	from

Associations (4)

Cardinality	Target	Alias	Condition
[1..1]	I_SitnDefinition	_Definition	`_Definition.SitnDefinitionID = $projection.SitnDefinitionID`
[1..1]	I_SitnInstceWthoutPndgTrans	_Instance	`_Instance.SitnInstanceID = $projection.SitnInstanceID`
[1..1]	I_SitnDefTextForSitnInstance	_InstanceText	`_InstanceText.SitnInstanceID = $projection.SitnInstanceID and _InstanceText.Language = $session.system_language`
[1..1]	I_SitnDefAnchrObjType	_AnchorObjectType	`_AnchorObjectType.SitnDefinitionID = $projection.SitnDefinitionID`

Annotations (11)

Name	Value	Level
AbapCatalog.sqlViewName	CSITNRELSIT	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Related Situation	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.viewType	#CONSUMPTION	view
VDM.lifecycle.status	#DEPRECATED	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MIXED	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 (13)

Key	Field	Source Table	Source Field
KEY	SitnInstanceID	I_SitnRelatedSituation	SitnInstanceID
KEY	SitnDefRelatedObjectID	I_SitnRelatedSituation	SitnDefRelatedObjectID
	SitnDefinitionID	I_SitnRelatedSituation	SitnDefinitionID
	SitnInstceReltdObjKey	I_SitnRelatedSituation	SitnInstceReltdObjKey
	SitnDefReltdObjSOT	I_SitnRelatedSituation	SitnDefReltdObjSOT
	SitnDefReltdObjSONT	I_SitnRelatedSituation	SitnDefReltdObjSONT
	SitnInstceAnchorObjectKey	_Instance	SitnInstceAnchorObjectKey
	SitnAnchorObjectReadableID	_Instance	SitnAnchorObjectReadableID
	CreationDateTime	_Instance	CreationDateTime
	SitnDefAnchorObjectDesc	_AnchorObjectType	SitnDefAnchorObjectDesc
	SitnDefShortText	_InstanceText	SitnDefShortText
	SitnDefAnchorObjectView	_Definition	SitnDefAnchorObjectView
	SitnDefAnchorObject

@AbapCatalog: {
  sqlViewName: 'CSITNRELSIT',
  compiler.compareFilter: true,
  preserveKey:true 
}
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Related Situation'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
 viewType: #CONSUMPTION, 
 lifecycle: {
  status: #DEPRECATED
//  sucessor: <name of successor view>

}}
@ObjectModel: {
  usageType.serviceQuality: #C,
  usageType.sizeCategory: #L,
  usageType.dataClass: #MIXED
}

define view C_SitnRelatedSituation
  as select from I_SitnRelatedSituation as RelatedSituation
  association [1..1] to I_SitnDefinition             as _Definition       on  _Definition.SitnDefinitionID       = $projection.SitnDefinitionID
  association [1..1] to I_SitnInstceWthoutPndgTrans  as _Instance         on  _Instance.SitnInstanceID           = $projection.SitnInstanceID
                                                                          
  association [1..1] to I_SitnDefTextForSitnInstance as _InstanceText     on  _InstanceText.SitnInstanceID       = $projection.SitnInstanceID
                                                                          and _InstanceText.Language             = $session.system_language
                                                                                                                                             
  association [1..1] to I_SitnDefAnchrObjType        as _AnchorObjectType on  _AnchorObjectType.SitnDefinitionID = $projection.SitnDefinitionID
  
{
  key RelatedSituation.SitnInstanceID,
  key RelatedSituation.SitnDefRelatedObjectID,
      RelatedSituation.SitnDefinitionID,
      RelatedSituation.SitnInstceReltdObjKey,
      RelatedSituation.SitnDefReltdObjSOT,
      RelatedSituation.SitnDefReltdObjSONT,

      _Instance.SitnInstceAnchorObjectKey,
      _Instance.SitnAnchorObjectReadableID,
      _Instance.CreationDateTime,

      _AnchorObjectType.SitnDefAnchorObjectDesc,

      _InstanceText.SitnDefShortText,
      
      @Consumption.hidden: true
      _Definition.SitnDefAnchorObjectView, --authorization only (in Custom Query)
      
      @Consumption.hidden: true
      _Definition.SitnDefAnchorObject, --authorization only (in Custom Query)

      @Consumption.hidden: true
      _Definition --authorization only (in DCL)

}
where
  _Instance.SitnInstceStatus = 'OP'

Depth:

C_SitnRelatedSituation view

I_SitnRelatedSituation view