P_SITNINSTANCETEXTVERSION
The text version of a situation instance
P_SITNINSTANCETEXTVERSION is a CDS View in S/4HANA. The text version of a situation instance. It contains 3 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_SitnDefTextForSitnInstance | view | from | COMPOSITE | Situation instance text by relevant version |
Fields (3)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | SitnInstanceID | SitnInstanceID | 1 |
| SitnDefinitionID | SitnDefinitionID | 1 | |
| SitnMsgTextVersion | SitnMsgTextVersion | 1 |
@AbapCatalog.sqlViewName: 'PSITNINSTTXT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
//@EndUserText.label: 'The text version of a situation instance'
@VDM.viewType: #COMPOSITE
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_SitnInstanceTextVersion as select distinct from I_SitnInstceMessageParameter as InstTextVersion
association [1..1] to I_SitnInstance as _Instance on _Instance.SitnInstanceID = $projection.SitnInstanceID
{
key InstTextVersion.SitnInstanceID,
_Instance.SitnDefinitionID,
max(SitnMsgTextVersion) as SitnMsgTextVersion
} group by InstTextVersion.SitnInstanceID, _Instance.SitnDefinitionID