SAP EHPRCS_QUERY_SUB_ADVANCED table - Query structure for advanced search details in SAP


SAP EHPRCS_QUERY_SUB_ADVANCED table summary

Object Name: EHPRCS_QUERY_SUB_ADVANCED
Dictionary Type: Structure
Description: Query structure for advanced search


Field list for EHPRCS_QUERY_SUB_ADVANCED table on an SAP system

Details
EHPRCS_QUERY_SUB_ADVANCED-SUBID table field - Substance ID of Pure Substance

Description: Substance ID of Pure Substance
Field Name: SUBID
Data Element: EHPRC_SUBID_PURE
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine: SPEC1
Domain Name: ESDSUBID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: SPEC1

See all SAP tables containing field SUBID

EHPRCS_QUERY_SUB_ADVANCED-ID_TYPE table field - Combined Identifier Type and Category Name

Description: Combined Identifier Type and Category Name
Field Name: ID_TYPE
Data Element: EHPRC_SUB_ID_TYPE_CAT_COMB
Data Type: CHAR
length (Dec): 80(0)
Check table:
Conversion Routine:
Domain Name: EHFND_DESCRIPTION_M
MemoryID:
AppClass:
SHLP: EHPRC_SUB_IDTYPE_IDCAT_COMB
SHLP Field: CODE
ConvExit:

See all SAP tables containing field ID_TYPE

EHPRCS_QUERY_SUB_ADVANCED-ID_VALUE table field - Identifier

Description: Identifier
Field Name: ID_VALUE
Data Element: ESEIDENT
Data Type: CHAR
length (Dec): 132(0)
Check table:
Conversion Routine:
Domain Name: TEXT132
MemoryID: ES5
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ID_VALUE

EHPRCS_QUERY_SUB_ADVANCED-LEAD_LE table field - Leading Legal Entity

Description: Leading Legal Entity
Field Name: LEAD_LE
Data Element: EHPRC_SUBGEN_LEADINGLEGENT
Data Type: CHAR
length (Dec): 4(0)
Check table: *
Conversion Routine:
Domain Name: BUKRS
MemoryID:
AppClass: FB
SHLP: EHPRC_ELM_LEGENT_SRC
SHLP Field: BUKRS
ConvExit:

See all SAP tables containing field LEAD_LE

EHPRCS_QUERY_SUB_ADVANCED-REGDEC table field - Registration Decision

Description: Registration Decision
Field Name: REGDEC
Data Element: EHPRC_SUBGEN_REGDECISION
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: EHPRC_COM_REGDECISION_CODE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REGDEC

EHPRCS_QUERY_SUB_ADVANCED-MAXTOBND table field - Maximum Tonnage Band

Description: Maximum Tonnage Band
Field Name: MAXTOBND
Data Element: EHPRC_SUBGEN_MAXTOBAND
Data Type: CHAR
length (Dec): 2(0)
Check table: *
Conversion Routine:
Domain Name: EHPRC_TOBAND
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MAXTOBND

EHPRCS_QUERY_SUB_ADVANCED-REG_DDLN table field - Registration Deadline

Description: Registration Deadline
Field Name: REG_DDLN
Data Element: EHPRC_SUBGEN_REGDEADLINE
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REG_DDLN

EHPRCS_QUERY_SUB_ADVANCED-BUS_PRIO table field - Business Priority

Description: Business Priority
Field Name: BUS_PRIO
Data Element: EHPRC_SUBGEN_BUSINESSPRIO
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: EHFND_CHAR30
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BUS_PRIO

EHPRCS_QUERY_SUB_ADVANCED-EXEMPTY table field - Exemption Type

Description: Exemption Type
Field Name: EXEMPTY
Data Element: EHPRC_SUBEXM_EXEMPTYPE
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: EHFND_CHAR30
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXEMPTY

EHPRCS_QUERY_SUB_ADVANCED-SVHCTYPE table field - SVHC Type

Description: SVHC Type
Field Name: SVHCTYPE
Data Element: EHPRC_SUBGEN_SVHCTYPE
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: EHFND_CHAR30
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SVHCTYPE

EHPRCS_QUERY_SUB_ADVANCED-MATNR table field - Material Number

Description: Material Number
Field Name: MATNR
Data Element: MATNR
Data Type: CHAR
length (Dec): 40(0)
Check table: *
Conversion Routine: MATN1
Domain Name: MATNR
MemoryID: MAT
AppClass: MG
SHLP: S_MAT1
SHLP Field: MATNR
ConvExit: MATN1

See all SAP tables containing field MATNR

EHPRCS_QUERY_SUB_ADVANCED-AUTH_GRP table field - Authorization Group

Description: Authorization Group
Field Name: AUTH_GRP
Data Element: ESEAUTHGRP
Data Type: CHAR
length (Dec): 10(0)
Check table: *
Conversion Routine:
Domain Name: ESDAUTHGRP
MemoryID: ES2
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AUTH_GRP

EHPRCS_QUERY_SUB_ADVANCED-SUB_TYPE table field - REACH Substance Type

Description: REACH Substance Type
Field Name: SUB_TYPE
Data Element: EHPRC_SUBGEN_SUBTYPE
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: EHFND_CHAR30
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SUB_TYPE

EHPRCS_QUERY_SUB_ADVANCED-PHASEIN table field - Phase-In

Description: Phase-In
Field Name: PHASEIN
Data Element: EHPRC_SUBGEN_PHASEIN
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: EHFND_CHAR30
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PHASEIN

EHPRCS_QUERY_SUB_ADVANCED-LEAD_ORG table field - Leading Organizational Unit

Description: Leading Organizational Unit
Field Name: LEAD_ORG
Data Element: EHPRC_SUBGEN_LEADINGORGUNIT
Data Type: CHAR
length (Dec): 29(0)
Check table:
Conversion Routine:
Domain Name: EHPRC_CODE
MemoryID:
AppClass:
SHLP: EHPRC_ELM_ORGUNITCODE
SHLP Field: ORGUNITCODE
ConvExit:

See all SAP tables containing field LEAD_ORG

EHPRCS_QUERY_SUB_ADVANCED-ORGUNIT table field - Organizational Unit Code

Description: Organizational Unit Code
Field Name: ORGUNIT
Data Element: EHPRC_ORGUNIT_CODE
Data Type: CHAR
length (Dec): 29(0)
Check table:
Conversion Routine:
Domain Name: EHPRC_CODE
MemoryID:
AppClass:
SHLP: EHPRC_ELM_ORGUNITCODE
SHLP Field: ORGUNITCODE
ConvExit:

See all SAP tables containing field ORGUNIT

EHPRCS_QUERY_SUB_ADVANCED-LEGENT table field - Legal Entity

Description: Legal Entity
Field Name: LEGENT
Data Element: EHPRC_LEGENT_ADV_SEARCH
Data Type: CHAR
length (Dec): 4(0)
Check table: *
Conversion Routine:
Domain Name: BUKRS
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LEGENT

EHPRCS_QUERY_SUB_ADVANCED-PREGSTAT table field - Preregistration Status

Description: Preregistration Status
Field Name: PREGSTAT
Data Element: EHPRC_SUB_LEGPRE_STATUS
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: TEXT30
MemoryID:
AppClass: SAP
SHLP: EHPRC_ELM_PREREG_STATUS
SHLP Field: CODE
ConvExit:

See all SAP tables containing field PREGSTAT

EHPRCS_QUERY_SUB_ADVANCED-REG_NO table field - Registration Number

Description: Registration Number
Field Name: REG_NO
Data Element: EHPRC_REG_REGNO
Data Type: CHAR
length (Dec): 29(0)
Check table:
Conversion Routine:
Domain Name: TEXT29
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REG_NO

EHPRCS_QUERY_SUB_ADVANCED-REG_STAT table field - Registration Project Status

Description: Registration Project Status
Field Name: REG_STAT
Data Element: EHPRC_REG_STATUS
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: EHPRC_REG_STATUS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REG_STAT

EHPRCS_QUERY_SUB_ADVANCED-TOBAND table field - Tonnage Band

Description: Tonnage Band
Field Name: TOBAND
Data Element: EHPRC_TOBAND
Data Type: CHAR
length (Dec): 2(0)
Check table: *
Conversion Routine:
Domain Name: EHPRC_TOBAND
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOBAND

EHPRCS_QUERY_SUB_ADVANCED-INT_DDLN table field - Internal Deadline

Description: Internal Deadline
Field Name: INT_DDLN
Data Element: EHPRC_REG_INTDEADLINE
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INT_DDLN

EHPRCS_QUERY_SUB_ADVANCED-SUB_NAME table field - Substance Name in Legal Entity

Description: Substance Name in Legal Entity
Field Name: SUB_NAME
Data Element: EHPRC_REG_LEGENT_SUBNAME
Data Type: CHAR
length (Dec): 132(0)
Check table:
Conversion Routine:
Domain Name: EHFND_DESCRIPTION_L
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SUB_NAME

EHPRCS_QUERY_SUB_ADVANCED-INT_TYPE table field - Role Type

Description: Role Type
Field Name: INT_TYPE
Data Element: EHPRC_REG_LEGINT_ROLETYPE
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: EHFND_CHAR30
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INT_TYPE

EHPRCS_QUERY_SUB_ADVANCED-INT_CTRL table field - Strictly Controlled

Description: Strictly Controlled
Field Name: INT_CTRL
Data Element: EHPRC_REG_LEGINT_ISSCNTRL
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: EHPRC_TRISTATE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INT_CTRL

EHPRCS_QUERY_SUB_ADVANCED-EEW_EHPRC_ADV_SEARCH table field - Dummy function in length 1

Description: Dummy function in length 1
Field Name: EEW_EHPRC_ADV_SEARCH
Data Element: DUMMY
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: DUMMY
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EEW_EHPRC_ADV_SEARCH


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table