SOTR_TEXT

Transparent Table System Table (SAP only)
12 Fields 8 CDS Views

Texttabelle im OTR

SOTR_TEXT is an SAP database table in S/4HANA. Texttabelle im OTR. It contains 12 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
ars_demo_badis_c0 view left_outer Demo: BADIs released for C0
CUAN_OFFER_MSG_PI_CONT_SEARCH view left_outer Offer Integration in Content Studio
I_ChmlCmplncIsResearchedText view from BASIC Language-Dependent Description of Is Researched Indicator
I_OTRText view from BASIC OTR Text
I_RAPerfOblgnDeferralMethodTxt view_entity from BASIC RA Deferral Method - Text
N_SBLE_ENH_SHORTTEXT view_entity left_outer BLE: ENHO shorttext
P_EHSOTRText view from COMPOSITE OTR Text
VFCLM_BAM_DDL_REQLOG_WITHDESP view left_outer Change Request Log With Description

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY concept sotr_conc Logical OTR ID
KEY langu sprsl Language
KEY object sotr_objc Physical OTR ID
lfd_num sotr_num Sequence number
flag_cntxt flag Indicator
source_lan sylangu Language Key
flag_com flag Indicator
flag_corr flag Indicator
status sotr_stat OTR status
version sotr_vers Sequence number
length sotr_leng Text Length
text sotr_txt OTR Text

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.

-- Texttabelle im OTR
-- Category TRANSPARENT · Delivery class S
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SOTR_TEXT (
    CONCEPT,     -- Logical OTR ID [sotr_conc]
    LANGU,       -- Language [sprsl]
    OBJECT,      -- Physical OTR ID [sotr_objc]
    LFD_NUM,     -- Sequence number [sotr_num]
    FLAG_CNTXT,  -- Indicator [flag]
    SOURCE_LAN,  -- Language Key [sylangu]
    FLAG_COM,    -- Indicator [flag]
    FLAG_CORR,   -- Indicator [flag]
    STATUS,      -- OTR status [sotr_stat]
    VERSION,     -- Sequence number [sotr_vers]
    LENGTH,      -- Text Length [sotr_leng]
    TEXT,        -- OTR Text [sotr_txt]
    PRIMARY KEY (CONCEPT, LANGU, OBJECT)
);

Learn More