SAP COMS_PR_ORG_REL Settings for Link Tables Table data and field list

COMS_PR_ORG_REL is a standard SAP Table which is used to store Settings for Link Tables data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The COMS_PR_ORG_REL table consists of various fields, each holding specific information or linking keys about Settings for Link Tables data available in SAP. These include LINK_TABLE (Organizational Dependency Link Table), LINK_TABLE_HIST (Link Table of Organizational Dependency, History Table), LINK_TABLE_STRUC (Link Table Name for Organizational-Dependent Set Types), LINK_TABLE_TTYP (Table Type for Link Table)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

COMS_PR_ORG_REL table Technical Details:

Delivery Class: E - Control table, SAP and customer have separate key areas
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP COMS_PR_ORG_REL table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the COMS_PR_ORG_REL table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
ORG_TYPE	Indicator for Organizational Dependency	COMT_PR_ORG_TYPE	CHAR	10	Assigned to domain		COM_PR_ORG_TYPE
LINK_TABLE	Organizational Dependency Link Table	COMT_PR_ORG_LINK_TABLE	CHAR	16			DBOBJ_NAME
LINK_TABLE_HIST	Link Table of Organizational Dependency, History Table	COMT_PR_ORG_LINK_TABLE_HIST	CHAR	16			DBOBJ_NAME
LINK_TABLE_STRUC	Link Table Name for Organizational-Dependent Set Types	COMT_PR_ORG_LINK_STRUC	CHAR	30			DDOBJNAME
LINK_TABLE_TTYP	Table Type for Link Table	COMT_PR_ORG_LINK_TTYP	CHAR	30			DDOBJNAME
FUNC_MAINTAIN_CH	Function Module for Checking if Link May Be Maintained	COMT_PR_FUNC_MAINTAIN_CHECK	CHAR	30	Assigned to domain		FUNCNAME
FUNC_READ_CH_SET	Function Module for Reading Link Entries in Buffer	COMT_PR_FUNC_READ_CH_SET	CHAR	30
FUNC_REFRESH_LOC	Function Module for Deleting Local Buffer of Link Table	COMT_PR_FUNC_REFRESH_LOC_LINK	CHAR	30	Assigned to domain		FUNCNAME
FUNC_REL_CHANGE	Function Module for Changing a Link	COMT_PR_FUNC_REL_CHANGE	CHAR	30	Assigned to domain		FUNCNAME
FUNC_REL_CHANGEM	Function Module for Changing a Link in Local Buffer	COMT_PR_FUNC_REL_CHANGEM	CHAR	30	Assigned to domain		FUNCNAME
FUNC_REL_DELETE	Function Module for Deleting a Link	COMT_PR_FUNC_REL_DELETE	CHAR	30	Assigned to domain		FUNCNAME
FUNC_REL_DELETEM	Function Module for Deleting a Link in Local Buffer	COMT_PR_FUNC_REL_DELETEM	CHAR	30	Assigned to domain		FUNCNAME
FUNC_REL_CHECK	Function Module for Checking a Link	COMT_PR_FUNC_REL_CHECK	CHAR	30	Assigned to domain		FUNCNAME
FUNC_REL_CREATE	Function Module for Creating a Link	COMT_PR_FUNC_REL_CREATE	CHAR	30	Assigned to domain		FUNCNAME
FUNC_REL_CREATEM	Function Module for Creating a Link in Local Buffer	COMT_PR_FUNC_REL_CREATEM	CHAR	30	Assigned to domain		FUNCNAME
FUNC_REL_READ	Function Module for Reading a Link	COMT_PR_FUNC_REL_READ	CHAR	30	Assigned to domain		FUNCNAME
FUNC_REL_READM	Function Module for Reading a Link in Local Buffer	COMT_PR_FUNC_REL_READM	CHAR	30	Assigned to domain		FUNCNAME
FUNC_REL_READ_MU	Function Module for Reading Multiple Links	COMT_PR_FUNC_REL_READ_MULTI	CHAR	30	Assigned to domain		FUNCNAME
FUNC_REL_READ_PM	Function Module for All Links to a Product in Local Buffer	COMT_PR_FUNC_REL_READ_PRODM	CHAR	30	Assigned to domain		FUNCNAME
FUNC_REL_READ_PR	Function Module for All Links to a Product in Local Buffer	COMT_PR_FUNC_REL_READ_PRODM	CHAR	30	Assigned to domain		FUNCNAME
FUNC_REL_READ_SE	Function Module for Reading a Link Using SET_GUID	COMT_PR_FUNC_REL_READ_SETM	CHAR	30	Assigned to domain		FUNCNAME
FUNC_REL_AR_COLL	Function Module for Collecting Links Array Read	COMT_PR_FUNC_REL_ARRREAD_COLL	CHAR	30	Assigned to domain		FUNCNAME
FUNC_REL_AR_PROC	Function Module for Array Read	COMT_PR_FUNC_REL_ARRREAD_PROC	CHAR	30	Assigned to domain		FUNCNAME
FUNC_REL_BUF_FIL	FM for Filling Mainten. Buffer During Active/Inactive Save	COMT_PR_FUNC_REL_BUFFER_FILL	CHAR	30	Assigned to domain		FUNCNAME
FUNC_REL_REFRESH	Function Module for Resetting Buffer	COMT_PR_FUNC_REL_REFRESH	CHAR	30	Assigned to domain		FUNCNAME
FUNC_MAP_TO_ORG	Mapping Link Structure to Field PR_ORG_ID	COMT_PR_FUNC_MAP_TO_ORG	CHAR	30	Assigned to domain		FUNCNAME
FUNC_MAP_ORG	Mapping Field PR_ORG_ID to Link Structure	COMT_PR_FUNC_MAP_ORG	CHAR	30	Assigned to domain		FUNCNAME
FUNC_SAVE_REL	Function Module for Saving a Link	COMT_PR_FUNC_SAVE_REL	CHAR	30	Assigned to domain		FUNCNAME
FUNC_SAVE_DB_REL	Function Module for Saving Links on Database	COMT_PR_FUNC_SAVE_DB_REL	CHAR	30	Assigned to domain		FUNCNAME
FUNC_CHECK_SET_E	Function Module for Checking Existence of a Set	COMT_PR_FUNC_CHECK_SET_E	CHAR	30	Assigned to domain		FUNCNAME
LINK_TABLEH_TTYP	Table Type for History of Links	COMT_PR_ORG_LINKH_TTYP	CHAR	30			DDOBJNAME
FUNC_RELH_READ_P	Function Module for Reading History of All Links to Product	COMT_PR_FUNC_RELH_READ_PRODM	CHAR	30	Assigned to domain		FUNCNAME
LINK_SEL_STRUC	Structure for Selecting Entries from Link Table	COMT_PR_ORG_LINK_SEL	CHAR	30			DDOBJNAME
LINK_SEL_TTYP	Table Type for Selection for Entries of the Link Table	COMT_PR_ORG_LINK_SEL_TTYP	CHAR	30			DDOBJNAME
LINK_KEY_STRUC	Name of Key Structure for Link Table	COMT_PR_ORG_LINK_KEY	CHAR	30			DDOBJNAME
LINK_KEY_TTYP	Table Type for Key Structure of Link Table	COMT_PR_ORG_LINK_KEY_TTYP	CHAR	30			DDOBJNAME
LINK_KEYH_STRUC	Name of Key Structure of Link Table History	COMT_PR_ORG_LINKH_KEY	CHAR	30			DDOBJNAME
FUNC_REL_BUF_EXT	Function Module for External Filling of Link Buffer	COMT_PR_FUNC_REL_BUF_EXT	CHAR	30	Assigned to domain		FUNCNAME

Key field

Non-key field

< COMS_PR_ORG_KEYS - Key Fields of Organizational Units COMS_PR_ORG_RELG - Additional Settings for Link Tables (Gen. Link-Handler) >

How do I retrieve data from SAP table COMS_PR_ORG_REL using ABAP code

The following ABAP code Example will allow you to do a basic selection on COMS_PR_ORG_REL to SELECT all data from the table
DATA: WA_COMS_PR_ORG_REL TYPE COMS_PR_ORG_REL.

SELECT SINGLE *
FROM COMS_PR_ORG_REL
INTO CORRESPONDING FIELDS OF WA_COMS_PR_ORG_REL
WHERE...

How to access SAP table COMS_PR_ORG_REL

Within an ECC or HANA version of SAP you can also view further information about COMS_PR_ORG_REL and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).