P_SITNINSTANCETEXTVERSION

CDS View

P_SITNINSTANCETEXTVERSION is a CDS View in S/4HANA. It contains 3 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 3 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SitnDefTextForSitnInstance view from COMPOSITE Situation instance text by relevant version

Fields (3)

KeyField CDS FieldsUsed 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

Learn More