SAP /SCMB/TMSRES_QUERY_ALL table - Query structure for TMS resources - root node details in SAP


SAP /SCMB/TMSRES_QUERY_ALL table summary

Object Name: /SCMB/TMSRES_QUERY_ALL
Dictionary Type: Structure
Description: Query structure for TMS resources - root node


Field list for /SCMB/TMSRES_QUERY_ALL table on an S/4 SAP system

Details
/SCMB/TMSRES_QUERY_ALL-NAME table field - Resource Name

Description: Resource Name
Field Name: NAME
Data Element: /SAPAPO/CRES_NAME
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: /SAPAPO/CRES_NAME
MemoryID: /SAPAPO/RESOURCE
AppClass:
SHLP: /SAPAPO/RESOURCEAPP
SHLP Field: NAME
ConvExit:

See all SAP tables containing field NAME

/SCMB/TMSRES_QUERY_ALL-TMSRESUID table field - Global Unique ID for table

Description: Global Unique ID for table
Field Name: TMSRESUID
Data Element: UUID
Data Type: RAW
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: UUID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TMSRESUID

/SCMB/TMSRES_QUERY_ALL-RESTYPE table field - Resource Type

Description: Resource Type
Field Name: RESTYPE
Data Element: /SCMB/TMSRESTYPE
Data Type: NUMC
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: /SCMB/TMSRESTYPE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RESTYPE

/SCMB/TMSRES_QUERY_ALL-HOMELOCNO table field - Location

Description: Location
Field Name: HOMELOCNO
Data Element: /SAPAPO/LOCNO
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: /SAPAPO/LOCNO
MemoryID: /SAPAPO/LOCNO
AppClass:
SHLP: /SAPAPO/LOC
SHLP Field: LOCNO
ConvExit:

See all SAP tables containing field HOMELOCNO

/SCMB/TMSRES_QUERY_ALL-LOCID table field - Internal Location Number for Customer, Supplier, or Plant

Description: Internal Location Number for Customer, Supplier, or Plant
Field Name: LOCID
Data Element: /SAPAPO/LOCID
Data Type: CHAR
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: /SAPAPO/LOCID
MemoryID: /SAPAPO/LOCID
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOCID

/SCMB/TMSRES_QUERY_ALL-CALENDAR table field - Factory Calendar ID

Description: Factory Calendar ID
Field Name: CALENDAR
Data Element: /SAPAPO/CRES_CALENDAR
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: WFCID
MemoryID: FCI
AppClass: SCAL
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CALENDAR

/SCMB/TMSRES_QUERY_ALL-ORGCENTRE table field - Organizational Unit ID

Description: Organizational Unit ID
Field Name: ORGCENTRE
Data Element: /SCMB/ORGANISATIONALCENTRE
Data Type: NUMC
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: HROBJID
MemoryID:
AppClass:
SHLP: /SCMB/SH_ORGUNIT_ALL_FUNCT2
SHLP Field: INTERNAL_ID
ConvExit:

See all SAP tables containing field ORGCENTRE

/SCMB/TMSRES_QUERY_ALL-TZONE table field - Time Zone

Description: Time Zone
Field Name: TZONE
Data Element: TIMEZONE
Data Type: CHAR
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: TZNZONE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TZONE

/SCMB/TMSRES_QUERY_ALL-TRATY table field - Means of Transport

Description: Means of Transport
Field Name: TRATY
Data Element: /SAPAPO/TR_TRATY
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: /SAPAPO/TR_TRATY
MemoryID: /SAPAPO/TTYPE
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TRATY

/SCMB/TMSRES_QUERY_ALL-OWNER table field - Business Partner Number

Description: Business Partner Number
Field Name: OWNER
Data Element: BU_PARTNER
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: BU_PARTNER
MemoryID: BPA
AppClass:
SHLP: BUPA
SHLP Field: PARTNER
ConvExit: ALPHA

See all SAP tables containing field OWNER

/SCMB/TMSRES_QUERY_ALL-ENTITLED table field - Business Partner Number

Description: Business Partner Number
Field Name: ENTITLED
Data Element: BU_PARTNER
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: BU_PARTNER
MemoryID: BPA
AppClass:
SHLP: BUPA
SHLP Field: PARTNER
ConvExit: ALPHA

See all SAP tables containing field ENTITLED

/SCMB/TMSRES_QUERY_ALL-PLATENUMBER table field - Registration Number

Description: Registration Number
Field Name: PLATENUMBER
Data Element: /SCMB/RESPLATENR
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PLATENUMBER

/SCMB/TMSRES_QUERY_ALL-PLATECOUNTRY table field - Registration Number Country/Region

Description: Registration Number Country/Region
Field Name: PLATECOUNTRY
Data Element: /SCMB/RESPLATECTRY
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: LAND1
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PLATECOUNTRY

/SCMB/TMSRES_QUERY_ALL-HDLTMPTYP table field - Resource Template Type

Description: Resource Template Type
Field Name: HDLTMPTYP
Data Element: /SCMB/RESTMPLTP
Data Type: CHAR
length (Dec): 18(0)
Check table:
Conversion Routine:
Domain Name: /SCMB/RESTMPLTP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HDLTMPTYP

/SCMB/TMSRES_QUERY_ALL-VALID_FROM table field - UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

Description: UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
Field Name: VALID_FROM
Data Element: TZNTSTMPS
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 VALID_FROM

/SCMB/TMSRES_QUERY_ALL-VALID_TO table field - UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

Description: UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
Field Name: VALID_TO
Data Element: TZNTSTMPS
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 VALID_TO

/SCMB/TMSRES_QUERY_ALL-CHANGEUSER table field - User Name

Description: User Name
Field Name: CHANGEUSER
Data Element: SYUNAME
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: SYCHAR12
MemoryID:
AppClass: SYST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHANGEUSER

/SCMB/TMSRES_QUERY_ALL-CHANGEDATE table field - UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

Description: UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
Field Name: CHANGEDATE
Data Element: TZNTSTMPS
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 CHANGEDATE

/SCMB/TMSRES_QUERY_ALL-IDTYPE table field - Category of Alternative Name

Description: Category of Alternative Name
Field Name: IDTYPE
Data Element: /SCMB/RESAIDTP
Data Type: CHAR
length (Dec): 18(0)
Check table:
Conversion Routine:
Domain Name: /SCMB/RESAIDTP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field IDTYPE

/SCMB/TMSRES_QUERY_ALL-ID table field - Alternative Name

Description: Alternative Name
Field Name: ID
Data Element: /SCMB/RESAID
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: CHAR20S
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ID

/SCMB/TMSRES_QUERY_ALL-ATTEQUTP table field - Attached Equipment Category

Description: Attached Equipment Category
Field Name: ATTEQUTP
Data Element: /SCMB/RESAETYPE
Data Type: CHAR
length (Dec): 18(0)
Check table:
Conversion Routine:
Domain Name: /SCMB/RESAETYPE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ATTEQUTP

/SCMB/TMSRES_QUERY_ALL-ATTEQU table field - Attached Equipment

Description: Attached Equipment
Field Name: ATTEQU
Data Element: /SCMB/RESATTEQU
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: CHAR20S
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ATTEQU

/SCMB/TMSRES_QUERY_ALL-GRTYPE table field - Category of Grouping Attribute

Description: Category of Grouping Attribute
Field Name: GRTYPE
Data Element: /SCMB/RESGRTP
Data Type: CHAR
length (Dec): 18(0)
Check table:
Conversion Routine:
Domain Name: /SCMB/RESGRTP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field GRTYPE

/SCMB/TMSRES_QUERY_ALL-GRATTR table field - Grouping Attribute of a Resource

Description: Grouping Attribute of a Resource
Field Name: GRATTR
Data Element: /SCMB/RESGRATTR
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: /SCMB/RESGRATTR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field GRATTR

/SCMB/TMSRES_QUERY_ALL-QUALITYPE table field - Qualification Type

Description: Qualification Type
Field Name: QUALITYPE
Data Element: /SCMB/RESQUTP
Data Type: CHAR
length (Dec): 18(0)
Check table:
Conversion Routine:
Domain Name: /SCMB/RESQUTP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QUALITYPE

/SCMB/TMSRES_QUERY_ALL-QUALIVALUE table field - Qualification

Description: Qualification
Field Name: QUALIVALUE
Data Element: /SCMB/RESQUALIF
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: /SCMB/RESQUALIF
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QUALIVALUE

/SCMB/TMSRES_QUERY_ALL-RES_CLASS table field - Resource Class

Description: Resource Class
Field Name: RES_CLASS
Data Element: /SCMB/RES_CLASS
Data Type: NUMC
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: /SCMB/RES_CLASS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RES_CLASS

/SCMB/TMSRES_QUERY_ALL-REFMATID table field - Packaging Material

Description: Packaging Material
Field Name: REFMATID
Data Element: /SCMB/MDL_PMATID
Data Type: RAW
length (Dec): 16(0)
Check table:
Conversion Routine: MDLPD
Domain Name: /SCMB/MDL_MATID_CE
MemoryID:
AppClass:
SHLP: /SCMB/MDL_PROD
SHLP Field: MATID
ConvExit: MDLPD

See all SAP tables containing field REFMATID

/SCMB/TMSRES_QUERY_ALL-PACKMATNR table field - Packaging Material

Description: Packaging Material
Field Name: PACKMATNR
Data Element: /SCMB/MDL_PMATNR
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine: MATN1
Domain Name: /SCMB/MDL_PRODUCT_NO
MemoryID:
AppClass:
SHLP: /SCMB/MDL_PROD
SHLP Field: MATNR
ConvExit: MATN1

See all SAP tables containing field PACKMATNR

/SCMB/TMSRES_QUERY_ALL-TRMODCODE table field - Mode of Transport

Description: Mode of Transport
Field Name: TRMODCODE
Data Element: VKTRA
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: VKTRA
MemoryID:
AppClass: VV
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TRMODCODE

/SCMB/TMSRES_QUERY_ALL-EQUITYPE table field - Equipment Group

Description: Equipment Group
Field Name: EQUITYPE
Data Element: /SCMB/DE_EQUI_TYPE
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: /SCMB/EQUI_TYPE
MemoryID:
AppClass:
SHLP: /SCMB/EQUI_TYPE
SHLP Field: EQUI_TYPE
ConvExit:

See all SAP tables containing field EQUITYPE

/SCMB/TMSRES_QUERY_ALL-EQUISZTP table field - Equipment Type

Description: Equipment Type
Field Name: EQUISZTP
Data Element: /SCMB/DE_EQUI_CODE
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: /SCMB/EQUI_CODE
MemoryID:
AppClass:
SHLP: /SCMB/EQUI_CODE
SHLP Field: EQUI_CODE
ConvExit:

See all SAP tables containing field EQUISZTP

/SCMB/TMSRES_QUERY_ALL-OWNERSHIP_CODE table field - Ownership

Description: Ownership
Field Name: OWNERSHIP_CODE
Data Element: /SCMB/OWNERSHIP_CODE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: /SCMB/OWNERSHIP_CODE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OWNERSHIP_CODE

/SCMB/TMSRES_QUERY_ALL-RESOURCE_CONDITION table field - Resource Condition

Description: Resource Condition
Field Name: RESOURCE_CONDITION
Data Element: /SCMB/RESOURCE_CONDITION
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: /SCMB/RESOURCE_CONDITION
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RESOURCE_CONDITION

/SCMB/TMSRES_QUERY_ALL-FOOD_GRADE_IND table field - Food-Grade Resource Indicator

Description: Food-Grade Resource Indicator
Field Name: FOOD_GRADE_IND
Data Element: /SCMB/FOOD_GRADE_RESOURCE_IND
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: XFELD
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FOOD_GRADE_IND

/SCMB/TMSRES_QUERY_ALL-SPECIAL_INSTRUCTION table field - Special Instruction

Description: Special Instruction
Field Name: SPECIAL_INSTRUCTION
Data Element: /SCMB/SPECIAL_INSTRUCTION
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: /SCMB/SPECIAL_INSTRUCTION
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SPECIAL_INSTRUCTION


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table