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


SAP /SCMB/TMSRES_QUERY_ROOT table summary

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


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

Details
/SCMB/TMSRES_QUERY_ROOT-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_ROOT-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_ROOT-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_ROOT-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_ROOT-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_ROOT-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_ROOT-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_ROOT-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_ROOT-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_ROOT-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_ROOT-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_ROOT-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_ROOT-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_ROOT-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_ROOT-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_ROOT-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_ROOT-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_ROOT-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_ROOT-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_ROOT-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_ROOT-EQUISUPPL table field - Equipment Supplier

Description: Equipment Supplier
Field Name: EQUISUPPL
Data Element: /SCMB/EQUISUPPLIER
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EQUISUPPL

/SCMB/TMSRES_QUERY_ROOT-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_ROOT-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_ROOT-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_ROOT-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_ROOT-PLN_BLOCK table field - Planning Block

Description: Planning Block
Field Name: PLN_BLOCK
Data Element: /SCMB/RES_PLANNING_BLOCK
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: /SCMB/RES_PLANSTAT_REASON_CODE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PLN_BLOCK

/SCMB/TMSRES_QUERY_ROOT-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_ROOT-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_ROOT-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_ROOT-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

/SCMB/TMSRES_QUERY_ROOT-DFLT_DRIVER table field - Default Driver

Description: Default Driver
Field Name: DFLT_DRIVER
Data Element: /SCMB/DEFAULT_DRIVER
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: BU_PARTNER
MemoryID:
AppClass:
SHLP: /SCMB/SH_BPTM_DRIVER
SHLP Field: PARTNER
ConvExit: ALPHA

See all SAP tables containing field DFLT_DRIVER


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table