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

SMSY_DBSYS Table in SAP | Database Instances Table & Fields List

SMSY_DBSYS is a SAP table coming under SV module and ST component.View details, Fields & related tables of SMSY_DBSYS in SAP.

  • Table description : Database Instances
  • Module : SV-SMG-SYS
  • Parent Module : SV
  • Package : AI_S_CUSTOMIZING_LANDSCAPE
  • Software Component : ST
SMSY_DBSYS 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 SMSY_DBSYS Table Fields structure

FieldNoteData ElementDomain
DBNAMEDatenbase NameSMSY_DB_NAMESYCHAR10
KONZSGroup keyKONZSKONZS
VERSIONVersionSMSY_VERSIONSMSY_VERSION
DBVENDORDatabase ManufacturerSMSY_DB_VENDORSMSY_DB_VENDOR
DBRELEASEDatabase ReleaseSMSY_DB_REL  
DBPATCHLEVELSupport Package LevelSMSY_DB_PATCHSMSY_DB_PATCH
DBHOSTNAMEServer NameSMSY_HOSTNAMESMSY_HOSTNAME
PLANNEDFlag: Planned or ExistingSMSY_FLG_PLANNEDSMSY_FLG_PLANNED
ENTITY_KEYSystem Landscape Entity GUIDSMSY_ENTITY_GUIDCHAR32
.INCLUDESystem Landscape History Data    
SYDATUMSystem DateSYDATUMSYDATS
SYUZEITSystem TimeSYUZEITSYTIME
SYUNAMEUser NameSYUNAMESYCHAR12
TRCODETransaction CodeTCODETCODE
GENERATORSystem Landscape Capture FlagSMSY_FLAGSMSY_FLAG
AKT_VERSIONVersionSMSY_VERSIONSMSY_VERSION
DESCRObject DescriptionSMSY_ENTITY_DESCRSMSY_ENTITY_DESCR
AC_FLAGServer managed by ACSMSY_AC_FLG_HOST_AC_ENABLEDX
DB_TYPEDatabaseSLDDBSYSSLDDBSYS
PPMS_IDppms ComponentSMSY_PPMS_COMPONENTSMSYCOMPONENT
.INCLUDESLD Source Description    
SLDHOSTHost Name of System Landscape DirectorySLD_HOSTNAMEPHOST
SLDPORTPort Number of System Landscape DirectorySLD_PORTNUMBER  
SLDNAMESPACESLD NamespaceSMSY_SLD_NSPACESMSY_SLD_NSPACE
SLD_NAMEName in SLDSLDNAME  

SMSY_DBSYS related tables

TableNote
DB6PMHCDMDB6: Database and Database Manager Parameter Changes
FTI_LDB_DDIC_MAPMapping Field from Logical Database in Database Table
/SDF/DB6PMCDDB2 Universal Database: Configuration Database
SMSY_DBSYSDatabase Instances
ASGRPAssignment of SAP instances to DB instances
ACE_DB_EVENTDatabase table for the events
ACE_DB_EVENT_EXPDatabase table for the expiered metrics
ACE_DB_EVENT_GENDatabase table for the events
ACMETAINFO_SAPDatabase Table to store the Content Metainfo
ACPCTHRESDIRAlert configuration: database table for percentage threshold
ACRANGETHRESHDIRdatabase table for range threshold configuration data
ACREGEXDIRAlert configuration: database table for regex threshold
ACSIMPLETHRESDIRAlert configuration: database table for simple thresholds
ADMI_CRITManage critical archiving objects (database conversion)
AFX_TMPL_DBPACKTemplate for Database Table of Package Templates
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