SAP /SRMSMC/SQR_PUC_RT table - Query result structure for Purchasing Categories details in SAP

SAP /SRMSMC/SQR_PUC_RT table summary

Object Name: /SRMSMC/SQR_PUC_RT
Dictionary Type: Structure
Description: Query result structure for Purchasing Categories

Field list for /SRMSMC/SQR_PUC_RT table on an S/4 SAP system

Details

/SRMSMC/SQR_PUC_RT-MANDT table field - Client ▼

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

See all SAP tables containing field MANDT

/SRMSMC/SQR_PUC_RT-DB_KEY table field - NodeID ▼

Description: NodeID
Field Name: DB_KEY
Data Element: /BOBF/CONF_KEY
Data Type: RAW
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: /BOBF/CONF_KEY
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DB_KEY

/SRMSMC/SQR_PUC_RT-NAME table field - Medium-Size Name ▼

Description: Medium-Size Name
Field Name: NAME
Data Element: /SRMSMC/MEDIUM_NAME
Data Type: CHAR
length (Dec): 60(0)
Check table:
Conversion Routine:
Domain Name: /SRMSMC/MEDIUM_NAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME

/SRMSMC/SQR_PUC_RT-NAME_UPPER table field - Search Field: Medium-Length Name In Upper Case ▼

Description: Search Field: Medium-Length Name In Upper Case
Field Name: NAME_UPPER
Data Element: /SRMSMC/MEDIUM_NAME_UPPER
Data Type: CHAR
length (Dec): 60(0)
Check table:
Conversion Routine:
Domain Name: /SRMSMC/MEDIUM_NAME_UPPER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME_UPPER

/SRMSMC/SQR_PUC_RT-CREA_DATE_TIME table field - UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) ▼

Description: UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
Field Name: CREA_DATE_TIME
Data Element: TIMESTAMPL
Data Type: DEC
length (Dec): 21(7)
Check table:
Conversion Routine:
Domain Name: TZNTSTMPL
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CREA_DATE_TIME

/SRMSMC/SQR_PUC_RT-CREA_UNAME table field - User Name ▼

Description: User Name
Field Name: CREA_UNAME
Data Element: UNAME
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: UNAME
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CREA_UNAME

/SRMSMC/SQR_PUC_RT-LCHG_DATE_TIME table field - UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) ▼

Description: UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
Field Name: LCHG_DATE_TIME
Data Element: TIMESTAMPL
Data Type: DEC
length (Dec): 21(7)
Check table:
Conversion Routine:
Domain Name: TZNTSTMPL
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LCHG_DATE_TIME

/SRMSMC/SQR_PUC_RT-LCHG_UNAME table field - User Name ▼

Description: User Name
Field Name: LCHG_UNAME
Data Element: UNAME
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: UNAME
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LCHG_UNAME

/SRMSMC/SQR_PUC_RT-PARENT_KEY table field - NodeID ▼

Description: NodeID
Field Name: PARENT_KEY
Data Element: /BOBF/CONF_KEY
Data Type: RAW
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: /BOBF/CONF_KEY
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARENT_KEY

/SRMSMC/SQR_PUC_RT-PARTY_TYPE table field - Party Type (such as Employee, Supplier) ▼

Description: Party Type (such as Employee, Supplier)
Field Name: PARTY_TYPE
Data Element: /SRMSMC/PARTY_TYPE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: /SRMSMC/PARTY_TYPE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARTY_TYPE

/SRMSMC/SQR_PUC_RT-PARTY_ROLE_CODE table field - SLC: Party Role Code ▼

Description: SLC: Party Role Code
Field Name: PARTY_ROLE_CODE
Data Element: /SRMSMC/PARTY_ROLE_CODE
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: /SRMSMC/PARTY_ROLE_CODE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARTY_ROLE_CODE

/SRMSMC/SQR_PUC_RT-PARTY_ID table field - Generic Party ID (for Partner GUID / ID / User / ...) ▼

Description: Generic Party ID (for Partner GUID / ID / User / ...)
Field Name: PARTY_ID
Data Element: /SRMSMC/PARTY_ID
Data Type: CHAR
length (Dec): 32(0)
Check table:
Conversion Routine:
Domain Name: /SRMSMC/PARTY_ID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARTY_ID

/SRMSMC/SQR_PUC_RT-PARTY_ID_TYPE table field - SLC Party ID Type (Supplier, Vendor, or User ID) ▼

Description: SLC Party ID Type (Supplier, Vendor, or User ID)
Field Name: PARTY_ID_TYPE
Data Element: /SRMSMC/PARTY_ID_TYPE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: /SRMSMC/PARTY_ID_TYPE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARTY_ID_TYPE

/SRMSMC/SQR_PUC_RT-LANGUAGE_CODE table field - Language Key ▼

Description: Language Key
Field Name: LANGUAGE_CODE
Data Element: LANGU
Data Type: LANG
length (Dec): 1(0)
Check table: *
Conversion Routine: ISOLA
Domain Name: SPRAS
MemoryID:
AppClass: STXD
SHLP:
SHLP Field:
ConvExit: ISOLA

See all SAP tables containing field LANGUAGE_CODE

/SRMSMC/SQR_PUC_RT-INACTIVE table field - Indicator ▼

Description: Indicator
Field Name: INACTIVE
Data Element: /SRMSMC/INDICATOR
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: /SRMSMC/INDICATOR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INACTIVE

/SRMSMC/SQR_PUC_RT-TRANS_STATUS table field - Translation Relevance and Status ▼

Description: Translation Relevance and Status
Field Name: TRANS_STATUS
Data Element: /SRMSMC/TRANSLATION_STATUS
Data Type: NUMC
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: /SRMSMC/TRANSLATION_STATUS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TRANS_STATUS

/SRMSMC/SQR_PUC_RT-EMPR_UNAME table field - User Name ▼

Description: User Name
Field Name: EMPR_UNAME
Data Element: UNAME
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: UNAME
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EMPR_UNAME

/SRMSMC/SQR_PUC_RT-CREATED_ON_DATE table field - Date ▼

Description: Date
Field Name: CREATED_ON_DATE
Data Element: /SRMSMC/DATE
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: /SRMSMC/DATE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CREATED_ON_DATE

/SRMSMC/SQR_PUC_RT-CHANGED_ON_DATE table field - Date ▼

Description: Date
Field Name: CHANGED_ON_DATE
Data Element: /SRMSMC/DATE
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: /SRMSMC/DATE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHANGED_ON_DATE

/SRMSMC/SQR_PUC_RT-IS_ACTIVE table field - Boolean Variable (X = True, - = False, Space = Unknown) ▼

Description: Boolean Variable (X = True, - = False, Space = Unknown)
Field Name: IS_ACTIVE
Data Element: BOOLEAN
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: BOOLEAN
MemoryID:
AppClass: KA
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field IS_ACTIVE

/SRMSMC/SQR_PUC_RT-PUC_DESC table field - Search Field: Medium-Length Name In Upper Case ▼

Description: Search Field: Medium-Length Name In Upper Case
Field Name: PUC_DESC
Data Element: /SRMSMC/MEDIUM_NAME_UPPER
Data Type: CHAR
length (Dec): 60(0)
Check table:
Conversion Routine:
Domain Name: /SRMSMC/MEDIUM_NAME_UPPER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PUC_DESC

/SRMSMC/SQR_PUC_RT-TRANS_DESC table field - Search Field: Medium-Length Name In Upper Case ▼

Description: Search Field: Medium-Length Name In Upper Case
Field Name: TRANS_DESC
Data Element: /SRMSMC/MEDIUM_NAME_UPPER
Data Type: CHAR
length (Dec): 60(0)
Check table:
Conversion Routine:
Domain Name: /SRMSMC/MEDIUM_NAME_UPPER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TRANS_DESC

/SRMSMC/SQR_PUC_RT-CREA_PERSON_NAME table field - Person Name ▼

Description: Person Name
Field Name: CREA_PERSON_NAME
Data Element: /SRMSMC/PERSON_NAME
Data Type: CHAR
length (Dec): 80(0)
Check table:
Conversion Routine:
Domain Name: /SRMSMC/PERSON_NAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CREA_PERSON_NAME

/SRMSMC/SQR_PUC_RT-LCHG_PERSON_NAME table field - Person Name ▼

Description: Person Name
Field Name: LCHG_PERSON_NAME
Data Element: /SRMSMC/PERSON_NAME
Data Type: CHAR
length (Dec): 80(0)
Check table:
Conversion Routine:
Domain Name: /SRMSMC/PERSON_NAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LCHG_PERSON_NAME

/SRMSMC/SQR_PUC_RT-CREATED_ON_TIME table field - Time ▼

Description: Time
Field Name: CREATED_ON_TIME
Data Element: UZEIT
Data Type: TIMS
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: UZEIT
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CREATED_ON_TIME

/SRMSMC/SQR_PUC_RT-CHANGED_ON_TIME table field - Time ▼

Description: Time
Field Name: CHANGED_ON_TIME
Data Element: UZEIT
Data Type: TIMS
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: UZEIT
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHANGED_ON_TIME

/SRMSMC/SQR_PUC_RT-PERSON_NAME table field - Person Name ▼

Description: Person Name
Field Name: PERSON_NAME
Data Element: /SRMSMC/PERSON_NAME
Data Type: CHAR
length (Dec): 80(0)
Check table:
Conversion Routine:
Domain Name: /SRMSMC/PERSON_NAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PERSON_NAME

/SRMSMC/SQR_PUC_RT-PERSON_EMAIL table field - E-Mail Address ▼

Description: E-Mail Address
Field Name: PERSON_EMAIL
Data Element: AD_SMTPADR
Data Type: CHAR
length (Dec): 241(0)
Check table:
Conversion Routine: SXIDN
Domain Name: AD_SMTPADR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: SXIDN

See all SAP tables containing field PERSON_EMAIL

/SRMSMC/SQR_PUC_RT-PERSON_FUNCTION table field - Function ▼

Description: Function
Field Name: PERSON_FUNCTION
Data Element: AD_FNCTN
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PERSON_FUNCTION

/SRMSMC/SQR_PUC_RT-PERSON_DEPARTMNT table field - Department ▼

Description: Department
Field Name: PERSON_DEPARTMNT
Data Element: AD_DPRTMNT
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PERSON_DEPARTMNT

/SRMSMC/SQR_PUC_RT-PERSON_PHONE table field - Complete Number: Dialling Code+Number+Extension ▼

Description: Complete Number: Dialling Code+Number+Extension
Field Name: PERSON_PHONE
Data Element: AD_TELNRLG
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: CHAR30
MemoryID:
AppClass: KKEK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PERSON_PHONE

/SRMSMC/SQR_PUC_RT-KEY table field - NodeID ▼

Description: NodeID
Field Name: KEY
Data Element: /BOBF/CONF_KEY
Data Type: RAW
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: /BOBF/CONF_KEY
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field KEY

/SRMSMC/SQR_PUC_RT-ROOT_KEY table field - NodeID ▼

Description: NodeID
Field Name: ROOT_KEY
Data Element: /BOBF/CONF_KEY
Data Type: RAW
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: /BOBF/CONF_KEY
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ROOT_KEY

View list of all SAP tables(S4H/ECC)

Select data from SAP table