SAP CMS_REL table - Relationship details details in SAP


SAP CMS_REL table summary

Object Name: CMS_REL
Dictionary Type: Transparent table
Description: Relationship details


Field list for CMS_REL table on an S/4 SAP system

Details
CMS_REL-MANDT table field - Client

Description: Client
Field Name: MANDT
Data Element: MANDT
Data Type: CLNT
length (Dec): 3(0)
Check table: T000
Conversion Routine:
Domain Name: MANDT
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MANDT

CMS_REL-REL_GUID table field - GUID for Table CMS_REL

Description: GUID for Table CMS_REL
Field Name: REL_GUID
Data Element: CMS_DTE_REL_GUID
Data Type: RAW
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: SYSUUID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REL_GUID

CMS_REL-REL_TYP table field - Relationship type

Description: Relationship type
Field Name: REL_TYP
Data Element: CMS_DTE_REL_TYP
Data Type: CHAR
length (Dec): 6(0)
Check table: TCMS_REL_TYP
Conversion Routine:
Domain Name: CMS_REL_TYP
MemoryID:
AppClass:
SHLP: CMS_REL_TYP
SHLP Field: REL_TYP
ConvExit:

See all SAP tables containing field REL_TYP

CMS_REL-SOURCE_GUID table field - Relationship Source GUID

Description: Relationship Source GUID
Field Name: SOURCE_GUID
Data Element: CMS_DTE_REL_SOURCE_GUID
Data Type: RAW
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: SYSUUID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SOURCE_GUID

CMS_REL-SRC_SEC_GUID table field - Relationship Source Secondary GUID

Description: Relationship Source Secondary GUID
Field Name: SRC_SEC_GUID
Data Element: CMS_DTE_REL_SRC_SEC_GUID
Data Type: RAW
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: SYSUUID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SRC_SEC_GUID

CMS_REL-DESTINATION_GUID table field - Relationship destination GUID

Description: Relationship destination GUID
Field Name: DESTINATION_GUID
Data Element: CMS_DTE_REL_DESTINATION_GUID
Data Type: RAW
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: SYSUUID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DESTINATION_GUID

CMS_REL-DST_SEC_GUID table field - Relationship destination GUID

Description: Relationship destination GUID
Field Name: DST_SEC_GUID
Data Element: CMS_DTE_REL_DST_SEC_GUID
Data Type: RAW
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: SYSUUID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DST_SEC_GUID

CMS_REL-VALID_FROM table field - Date from which the relationship came into effect

Description: Date from which the relationship came into effect
Field Name: VALID_FROM
Data Element: CMS_DTE_REL_VALID_FROM
Data Type: NUMC
length (Dec): 15(0)
Check table:
Conversion Routine: TSTPS
Domain Name: TZNTSTMPSL
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: TSTPS

See all SAP tables containing field VALID_FROM

CMS_REL-VALID_TO table field - Date until which the relationship stands valid

Description: Date until which the relationship stands valid
Field Name: VALID_TO
Data Element: CMS_DTE_REL_VALID_TO
Data Type: NUMC
length (Dec): 15(0)
Check table:
Conversion Routine: TSTPS
Domain Name: TZNTSTMPSL
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: TSTPS

See all SAP tables containing field VALID_TO

CMS_REL-REL_RANK table field - Relationship Rank-Order of the source linked to destination

Description: Relationship Rank-Order of the source linked to destination
Field Name: REL_RANK
Data Element: CMS_DTE_REL_RANK
Data Type: NUMC
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: CMS_PRIORITY
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REL_RANK

CMS_REL-REL_PRIORITY table field - Priority of a Relationship

Description: Priority of a Relationship
Field Name: REL_PRIORITY
Data Element: CMS_DTE_REL_PRIORITY
Data Type: NUMC
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: CMS_PRIORITY
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REL_PRIORITY

CMS_REL-CALC_TYP table field - Calculation type for relations of collateral agreements

Description: Calculation type for relations of collateral agreements
Field Name: CALC_TYP
Data Element: CMS_DTE_CALC_TYP
Data Type: CHAR
length (Dec): 6(0)
Check table: *
Conversion Routine:
Domain Name: CMS_CALC_TYP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CALC_TYP

CMS_REL-REL_OBJ table field - Relationship Object

Description: Relationship Object
Field Name: REL_OBJ
Data Element: CMS_DTE_REL_OBJ
Data Type: CHAR
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: CMS_CAT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REL_OBJ

CMS_REL-CREATED_BY table field - Login ID of the User who created the Record

Description: Login ID of the User who created the Record
Field Name: CREATED_BY
Data Element: CMS_DTE_USER
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: CMS_USER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CREATED_BY

CMS_REL-CREATED_AT table field - Creation Timestamp

Description: Creation Timestamp
Field Name: CREATED_AT
Data Element: CMS_DTE_CREATED_AT
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: TZNTSTMPS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CREATED_AT

CMS_REL-CHANGED_BY table field - Last Changed By

Description: Last Changed By
Field Name: CHANGED_BY
Data Element: CMS_DTE_LAST_CHNG_USER
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: CMS_USER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHANGED_BY

CMS_REL-CHANGED_AT table field - Change Timestamp

Description: Change Timestamp
Field Name: CHANGED_AT
Data Element: CMS_DTE_CHANGED_AT
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: TZNTSTMPS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHANGED_AT

CMS_REL-SOURCEOFENTRY table field - Source of Entry

Description: Source of Entry
Field Name: SOURCEOFENTRY
Data Element: CMS_DTE_SOURCE_OF_ENTRY
Data Type: CHAR
length (Dec): 32(0)
Check table:
Conversion Routine:
Domain Name: CMS_SOURCE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SOURCEOFENTRY


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table