SOCIALDATA

Transparent Table Application Table
26 Fields 1 CDS Views

Social Data Definition

SOCIALDATA is an SAP database table in S/4HANA. Social Data Definition. It contains 26 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SocialPost view from BASIC View to fetch data from SOCIALDATA

Fields (26)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY socialdatauuid SMI_SOCIALDATAUUID Social Data ID
socialpost SMI_SOCIALPOST Social Media Data ID
language SMI_LANGUAGE Language Description
socialmediachannel SMI_SOCIALMEDIACHANNEL Channel Code
createdbyuser SMI_CREATEDBYUSER Created By User ID
creationdatetime SMI_CREATIONDATETIME Creation Timestamp
socialposttype SMI_SOCIALPOSTTYPE Social Post Type
socialpostlink SMI_SOCIALPOSTLINK Social Post Link
numberofpositivevotes SMI_NUMBEROFPOSITIVEVOTES Positive Votes Count
locationname SMI_LOCATIONNAME Location
countryname SMI_COUNTRYNAME Country
longitudemeasure SMI_LONGITUDEMEASURE Longitude
latitudemeasure SMI_LATITUDEMEASURE Latitude
socialpostactionstatus SMI_SOCIALPOSTACTIONSTATUS Post Action Status
socialpostcategory SMI_SOCIALPOSTCATEGORY Post Category
creationusername SMI_CREATIONUSERNAME Social User Name
socialpostretrivedbyuser SMI_SOCIALPOSTRETRIEVEDBYUSER Retrieved By User
socialpostsearchtermtext SMI_SOCIALPOSTSEARCHTERMTEXT Search Term Text
createdat SMI_CREATEDAT Creation Date-Time
socialposttext SMI_SOCIALPOSTTEXT Social Post Text
creationdatetime_utc SMI_CREATIONDATETIME_UTC Creation Date-Time
socialpostparent SMI_SOCIALPOST Social Media Data ID
socialpostroot SMI_SOCIALPOST Social Media Data ID
countrycode LAND1 Country/Reg.
socialdataretrievalmode SMI_SOCIALDATARETRIEVALMODE Retrieval Mode

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.

-- Social Data Definition
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SOCIALDATA (
    CLIENT,                    -- Client [MANDT]
    SOCIALDATAUUID,            -- Social Data ID [SMI_SOCIALDATAUUID]
    SOCIALPOST,                -- Social Media Data ID [SMI_SOCIALPOST]
    LANGUAGE,                  -- Language Description [SMI_LANGUAGE]
    SOCIALMEDIACHANNEL,        -- Channel Code [SMI_SOCIALMEDIACHANNEL]
    CREATEDBYUSER,             -- Created By User ID [SMI_CREATEDBYUSER]
    CREATIONDATETIME,          -- Creation Timestamp [SMI_CREATIONDATETIME]
    SOCIALPOSTTYPE,            -- Social Post Type [SMI_SOCIALPOSTTYPE]
    SOCIALPOSTLINK,            -- Social Post Link [SMI_SOCIALPOSTLINK]
    NUMBEROFPOSITIVEVOTES,     -- Positive Votes Count [SMI_NUMBEROFPOSITIVEVOTES]
    LOCATIONNAME,              -- Location [SMI_LOCATIONNAME]
    COUNTRYNAME,               -- Country [SMI_COUNTRYNAME]
    LONGITUDEMEASURE,          -- Longitude [SMI_LONGITUDEMEASURE]
    LATITUDEMEASURE,           -- Latitude [SMI_LATITUDEMEASURE]
    SOCIALPOSTACTIONSTATUS,    -- Post Action Status [SMI_SOCIALPOSTACTIONSTATUS]
    SOCIALPOSTCATEGORY,        -- Post Category [SMI_SOCIALPOSTCATEGORY]
    CREATIONUSERNAME,          -- Social User Name [SMI_CREATIONUSERNAME]
    SOCIALPOSTRETRIVEDBYUSER,  -- Retrieved By User [SMI_SOCIALPOSTRETRIEVEDBYUSER]
    SOCIALPOSTSEARCHTERMTEXT,  -- Search Term Text [SMI_SOCIALPOSTSEARCHTERMTEXT]
    CREATEDAT,                 -- Creation Date-Time [SMI_CREATEDAT]
    SOCIALPOSTTEXT,            -- Social Post Text [SMI_SOCIALPOSTTEXT]
    CREATIONDATETIME_UTC,      -- Creation Date-Time [SMI_CREATIONDATETIME_UTC]
    SOCIALPOSTPARENT,          -- Social Media Data ID [SMI_SOCIALPOST]
    SOCIALPOSTROOT,            -- Social Media Data ID [SMI_SOCIALPOST]
    COUNTRYCODE,               -- Country/Reg. [LAND1]
    SOCIALDATARETRIEVALMODE,   -- Retrieval Mode [SMI_SOCIALDATARETRIEVALMODE]
    PRIMARY KEY (CLIENT, SOCIALDATAUUID)
);

Learn More