SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

SOCIALDATA Table in SAP | Social Data Definition Table & Fields List

SOCIALDATA is a SAP table coming under CA module and SAP_BS_FND component.View details, Fields & related tables of SOCIALDATA in SAP.

  • Table description : Social Data Definition
  • Module : CA-EPT-SMI
  • Parent Module : CA
  • Package : BS_SOMI_DATA_MODELS
  • Software Component : SAP_BS_FND
SOCIALDATA table in SAP

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

Definitions

What is SAP ?

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

What is table in SAP ?

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.

SAP SOCIALDATA Table Fields structure

FieldNoteData ElementDomain
CLIENTClientMANDTMANDT
SOCIALDATAUUIDSocial Data IdentifierSMI_SOCIALDATAUUIDSMI_SOCIALDATAUUID
SOCIALPOSTSocial Media Data ID StringSMI_SOCIALPOSTSMI_SOCIALPOST
LANGUAGELanguage DescriptionSMI_LANGUAGESMI_LANGUAGE
SOCIALMEDIACHANNELSocial Media Channel CodeSMI_SOCIALMEDIACHANNELSMI_UNIQUE_ID
CREATEDBYUSERCreated By User IDSMI_CREATEDBYUSERSMI_USER
CREATIONDATETIMEPost Creation TimestampSMI_CREATIONDATETIMESMI_DATETIME
SOCIALPOSTTYPEType of Feeds Like Video, Photo, Status, Etc.SMI_SOCIALPOSTTYPESMI_SOCIALPOSTTYPE
SOCIALPOSTLINKLink to the Post in a Particular Social Media ChannelSMI_SOCIALPOSTLINKSMI_SOCIALPOSTLINK
NUMBEROFPOSITIVEVOTESCount of Likes or Shares for a Post in Media ChannelSMI_NUMBEROFPOSITIVEVOTESSMI_NUMBEROFPOSITIVEVOTES
LOCATIONNAMELocationSMI_LOCATIONNAMESMI_LOCATIONNAME
COUNTRYNAMECountrySMI_COUNTRYNAMESMI_COUNTRYNAME
LONGITUDEMEASURELongitudeSMI_LONGITUDEMEASURESMI_GEOMEASURE
LATITUDEMEASURELatitudeSMI_LATITUDEMEASURESMI_GEOMEASURE
SOCIALPOSTACTIONSTATUSSocial Post Action StatusSMI_SOCIALPOSTACTIONSTATUSSMI_SOCIALPOSTACTIONSTATUS
SOCIALPOSTCATEGORYCategorization of Social PostSMI_SOCIALPOSTCATEGORYSMI_SOCIALPOSTCATEGORY
CREATIONUSERNAMESocial Media User NameSMI_CREATIONUSERNAMESMI_USERNAME
SOCIALPOSTRETRIVEDBYUSERUser Details Used to Retrieve Social PostSMI_SOCIALPOSTRETRIEVEDBYUSERSMI_USERNAME
SOCIALPOSTSEARCHTERMTEXTSearch TermSMI_SOCIALPOSTSEARCHTERMTEXTSMI_SOCIALPOSTSEARCHTERMTEXT
CREATEDATCreation Date and Time in System (UTC Timestamp)SMI_CREATEDATTZNTSTMPS
SOCIALPOSTTEXTMention TextSMI_SOCIALPOSTTEXTSMI_SOCIALPOSTTEXT
CREATIONDATETIME_UTCCreation Date and Time in Socl Media Channel (UTC Timestamp)SMI_CREATIONDATETIME_UTCTZNTSTMPS
SOCIALPOSTPARENTSocial Media Data ID StringSMI_SOCIALPOSTSMI_SOCIALPOST
SOCIALPOSTROOTSocial Media Data ID StringSMI_SOCIALPOSTSMI_SOCIALPOST
COUNTRYCODECountry KeyLAND1LAND1
SOCIALDATARETRIEVALMODESocial Media Data Retrieval ModeSMI_SOCIALDATARETRIEVALMODESMI_SOCIALDATARETRIEVALMODE
.INCLU--APAppend strcuture of CRM social media post    
.INCLUDEReuse strcuture to include CRM post fields into BS_FND layer    
INTERNAL_IDInternal ID of Social Media PostCRMT_SOC_POST_INTERNAL_IDCRM_SOC_POST_INTERNAL_ID
TYPESocial Media Post TypeCRMT_SOC_DATA_TYPECRM_SOC_DATA_TYPE
POST_STATUSObject StatusCRM_J_STATUSCRM_J_STATUS
MAIN_CATEGORYAssigned Main CategoryCRMT_SOC_MAIN_CATEGORYCHAR10
SENTIMENTSentiment of Social Media PostCRMT_SOC_DATA_SENTIMENTCRM_SOC_DATA_SENTIMENT
SOCIAL_ACC_CODEID of Social Media User AccountCRMT_SOC_ACC_CODECHAR4
PROCESSORUser Name in User Master RecordXUBNAMEXUBNAME
REPLY_CREATED_BYUser Name in User Master RecordXUBNAMEXUBNAME
CONTENT_UCSocial data content upper caseCRMT_SOC_DATA_CONTENT_UCCHAR255
SENDER_USER_ACCOUNT_UCUpper case of social user accountCRMT_SOC_USER_ACCOUNT_UCCHAR100
SENDER_USER_ACCOUNTSocial Media User AccountSMI_SOCIALUSERACCOUNTSMI_SOCIALUSERACCOUNT
RECEIVER_USER_ACCOUNTSocial Media User AccountSMI_SOCIALUSERACCOUNTSMI_SOCIALUSERACCOUNT
RECEIVER_USER_IDSocial Media User IDSMI_SOCIALUSERSMI_USER
RECEIVER_USER_ACCOUNT_UCUpper case of social user accountCRMT_SOC_USER_ACCOUNT_UCCHAR100

SOCIALDATA related tables

TableNote
T5F5G'Bilan Social' social and professional categories
SOCIALDATASocial Data Definition
CRMC_SOC_SENTIDefinition of Social Media Sentiment
SMI_CHNLDEFSocial Media Channel Definition
SMI_SOCIALUSERSSpecific Social User Definition
SOCIALUSERINFOSocial User Info Definition
CRMD_MKTLIST_SMOStaging - Import Partner BP Social Media Data Organization
CRMD_MKTLIST_SMPStaging - Import Partner BP Social Media Data Person
PA0154HR master record, infotype 0154 (social security data)
PA0392Social Security: General data
PD3DBSVHR-DDU: Social Insurance Card Data Module
PDBKANConstruction Industry Social Fund Proced: ANMEL Data Records
PDBKAUConstruction Industry Social Fund Proced: AUMEL Data Records
PDBKLOConstruction Industry Social Fund Proced: LOMEL Data Records
PDBKNEConstruction Industry Social Fund Proced: NEMEL Data Records
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2024 sapstack.com