cancel
Showing results for 
Search instead for 
Did you mean: 

How to know which ones are the internal tables of SAP DS?

0 Kudos

Hello,

In my system, the development database schema is the same as the one used by SAP to manage its internal tables.

As I didn't made all the user tables inside, I would like to know if there is a way to differenciate the ones creates by SAP from the ones that weren't.

I'll attach the list of tables I'm not sure from who they come:

ADDRINFOCODEDATA
ADDRINFOCODESUMMARY
ADDRSCRIPTCODESUMMARY
ADDRSTATUSCODEDATA
ADDRTYPESUMMARY
ADDRVALIDATESUMMARY
AL_ATTR
AL_AUDIT
AL_AUDIT_INFO
AL_BREAKPOINT
AL_BW_REQUEST
AL_CACHE
AL_CACHE_STATS
AL_CDC_CHECKPOINT
AL_CDC_RS_CDB_CHECKPOINT
AL_CDC_RS_QUEUE
AL_CDC_RS_REPDEF_COLUMN
AL_CDC_RS_TABLE_REPDEF
AL_CDC_RS_TABLE_SUBSCRIPTION
AL_CEN_USERS
AL_CERTS
AL_CLASSATTR
AL_CMS_BV
AL_CMS_BV_FIELDS
AL_CMS_FOLDER
AL_CMS_REPORTS
AL_CMS_REPORTUSAGE
AL_CMS_UNV
AL_CMS_UNV_OBJ
AL_COLMAP
AL_COLMAP_NAMES
AL_COLMAP_TEXT
AL_COLUMN
AL_COLUMNPROFILE
AL_DATATYPE_NAMES
AL_DBNAME_MAPPING
AL_DOMAIN_INFO
AL_DOMAIN_VALUES
AL_EXPORT_HISTORY
AL_EXT_FUNCTEXT
AL_FKPKREL
AL_FUNCINFO
AL_FUNCPARAM
AL_GROUPS
AL_GROUP_MEMBERS
AL_HISTORY
AL_HISTORY_INFO
AL_IMPORT_HISTORY
AL_INDEX
AL_LABEL
AL_LANG
AL_LANGTEXT
AL_LANGXMLTEXT
AL_LDB_INFO
AL_LEVEL1_SEQUENCE
AL_LEVEL2_SEQUENCE
AL_MACHINE_INFO
AL_OBJECT_ATTR
AL_OBJ_PERMS
AL_OFLOW_EXPORT_HISTORY
AL_OFLOW_IMPORT_HISTORY
AL_OFLOW_OPTIONS
AL_OPTIONS
AL_OPTION_DESC
AL_OPTION_VALUES
AL_OVERFLOW_ATTR
AL_OVERFLOW_STAG
AL_PARENT_CHILD
AL_PCOLUMN
AL_PKEY
AL_PROJECTS
AL_PROJMEMS
AL_PVALUE
AL_QD_COLINFO
AL_QD_ROW
AL_QD_ROW_DATA
AL_QD_STATS
AL_QD_VRULE
AL_QD_VRULE_OFLOW
AL_RELATION
AL_REPOTYPE_NAMES
AL_REPO_128BITS_UUID
AL_RESOURCE
AL_RESOURCE_POOL
AL_RF_INFO
AL_ROLLFORWARD
AL_RUNTIME_PARAM
AL_SAP_JOB
AL_SCHED_INFO
AL_SCHEMA
AL_SETOPTIONS
AL_STAGING_INFO
AL_STATISTICS
AL_TABLEPROFILE
AL_USAGE
AL_USERS
AL_VARPARAM
AL_VERSION
AMASADDRPROCSUMMARY
CONTENT_TYPE_SAMPLE_DATA
CONTENT_TYPE_SAMPLE_REL
CONTENT_TYPE_SUMMARY
CSLSTATS
DPVLACSLINKSUMMARY
DSFAUGMENTSTATS
DSFSEQUENCESTATS
GEO_ASSIGN_LEVEL
GEO_INFO_CODE
MATCHED
MEDSTATS
MTBRACTION
MTBRINFO
MTBRKGRP
MTBRKGRPINFO
MTCMPCRIT
MTCMPPATRN
MTCRITDEF
MTDUPESDATA
MTGSSRCBYSRCSTS
MTGSSRCSTS
MTINFO
MTINSRCBYSRC
MTINSRCGRPINFO
MTINSRCINFO
MTINSRCMSRC
MTINSRCSELECT
MTINSRCSTATS
MTKEYDEF
MTPATRNDEF
MTPATRNRES
MTPROCESS
MTRULESRES
NCOALCERTIFICATIONDATA
NCOALINKSUMMARY
PAFBALASTATS
PF_ATTR_DETAIL
PF_ATTR_STRUCTURE
PF_ATTR_SUMMARY
PF_CONFIG
PF_DATA
PF_ID_MAPPING
PF_ITEM
PF_TABLE_ID_EXT
PF_TASK
PF_TEXT
PSFORM3553DATA
RECORDSAMPLINGFLDNAMES
REPORT_NAME
REPORT_STATSINFO
REPORT_STATSTABLEIDS
REPORT_STATSTABLENAME
SAMPLE_TRANSFORM_REPORT_TABLE
SENDRIGHTADDRACCURACY
SERPADDRACCURACY
STATS_UNIQUECOUNTER
UDCINFOCODESUMMARY
UDCOVERALLSUMMARY
UDCSTATUSCODESUMMARY
USREGULATORYLOCKING

I would like to know if I delete one tables from SAP, will the tool stop working or it will generate it again?

Also, is there a pattern or prefix or anything to differenciate this tables from the others?

Thanks and regards

Accepted Solutions (0)

Answers (0)