R_Sitn2InstceTrggrObjText

DDL: R_SITN2INSTCETRGGROBJTEXT SQL: RSITN2INSTTRGTE Type: view COMPOSITE

Trigger Object Type - Text

R_Sitn2InstceTrggrObjText is a Composite CDS View that provides data about "Trigger Object Type - Text" in SAP S/4HANA. It reads from 2 data sources (P_Sitn2BaseTemplateObjGroup, R_Sitn2ObjectText) and exposes 5 fields with key fields SitnBaseTemplateID, SitnBaseTmplObjectGroupID, Language.

Data Sources (2)

SourceAliasJoin Type
P_Sitn2BaseTemplateObjGroup Trigger from
R_Sitn2ObjectText TriggerText inner

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName RSITN2INSTTRGTE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Trigger Object Type - Text view
ObjectModel.dataCategory #TEXT view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY SitnBaseTemplateID P_Sitn2BaseTemplateObjGroup SitnBaseTemplateID Sit. Scenario ID
KEY SitnBaseTmplObjectGroupID P_Sitn2BaseTemplateObjGroup SitnBaseTmplObjectGroupID Scenario Object Group ID
KEY Language R_Sitn2ObjectText Language Report Text Language
SitnTriggerObjectID P_Sitn2BaseTemplateObjGroup SitnTriggerObjectID Trigger Object ID
SitnTriggerObjectName R_Sitn2ObjectText SitnObjectName Sit. Object Name

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_Sitn2InstceTrggrObjText.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: RSITN2INSTTRGTE

CREATE VIEW R_Sitn2InstceTrggrObjText AS
SELECT
  Trigger.SitnBaseTemplateID AS SitnBaseTemplateID,
  Trigger.SitnBaseTmplObjectGroupID AS SitnBaseTmplObjectGroupID,
  TriggerText.Language AS Language,
  Trigger.SitnTriggerObjectID AS SitnTriggerObjectID,
  TriggerText.SitnObjectName AS SitnTriggerObjectName
FROM P_Sitn2BaseTemplateObjGroup AS Trigger
INNER JOIN R_Sitn2ObjectText AS TriggerText ON /* join condition not captured in parsed metadata */
;