I_SITNINSTANCE

CDS View
12 Fields 9 CDS Views

Situation Instance

I_SITNINSTANCE is a CDS View in S/4HANA. Situation Instance. It contains 12 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
I_RFMSlsOrdSitnInstance view from BASIC Sales Order Situation Instance
I_SitnInstanceAPI view_entity from COMPOSITE Situation Instance API
I_SitnInstanceTP view from TRANSACTIONAL Situation Instance
I_SitnInstceIndicator view from COMPOSITE No. of Instances for a Spec. Anchor Obj.
I_SitnInstceWthoutPndgTrans view from COMPOSITE Filtered Situation Instances
I_SupAssgmtDmndSitn view from COMPOSITE Supply Assignment Demand Situations
P_SitnMblInstance view_entity from COMPOSITE
R_SitnInstceUnion view from COMPOSITE Instance union
R_SitnInstceWithPndgStatus view from COMPOSITE Situation Instances with Pending Status

Fields (12)

KeyField CDS FieldsUsed in Views
KEY SitnInstanceID SitnInstanceID 3
KEY SitnInstceAnchorObjectKey SitnInstceAnchorObjectKey 3
CreatedByUser CreatedByUser 2
CreationDateTime CreationDateTime,SitnInstceCreatedAtDateTime 3
LastChangeDateTime LastChangeDateTime 2
LastChangedByUser LastChangedByUser 2
SitnAnchorObjectReadableID SitnAnchorObjectReadableID 2
SitnDefinitionID SitnDefinitionID 3
SitnInstceStatus SitnInstceStatus 2
SitnInstceTriggerObjectKey SitnInstceTriggerObjectKey 2
SitnNotifSendDateTime SitnNotifSendDateTime 2
SitnTriggerObjectReadableID SitnTriggerObjectReadableID 2

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Situation Instance
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SITNINSTANCE (
    SITNINSTANCEID,
    SITNINSTCEANCHOROBJECTKEY,
    CREATEDBYUSER,
    CREATIONDATETIME,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    SITNANCHOROBJECTREADABLEID,
    SITNDEFINITIONID,
    SITNINSTCESTATUS,
    SITNINSTCETRIGGEROBJECTKEY,
    SITNNOTIFSENDDATETIME,
    SITNTRIGGEROBJECTREADABLEID,
    PRIMARY KEY (SITNINSTANCEID, SITNINSTCEANCHOROBJECTKEY)
);

Learn More