SAP /SCMTMS/S_FAG_ROOT_Q_SP table - query freight agreement by servcie product details in SAP

Description: Service Product Catalog
Field Name: FAGRMNTID044
Data Element: /SCMTMS/SP_UI_ID
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine: ALPHA
Domain Name: /SCMTMS/FAG_ID
MemoryID:
AppClass:
SHLP: /SCMTMS/SH_SP_UI_ID
SHLP Field: FAGRMNTID044
ConvExit: ALPHA

See all SAP tables containing field FAGRMNTID044

Description: Service Product Catalog Type
Field Name: FAGTYPEID103
Data Element: /SCMTMS/SP_TYPE_CODE
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: /SCMTMS/FAG_TYPE_CODE
MemoryID:
AppClass:
SHLP: /SCMTMS/SH_SP_TYPE
SHLP Field: FAGTYPEID103
ConvExit:

See all SAP tables containing field FAGTYPEID103

Description: Agreement Category
Field Name: FAGCATEID111
Data Element: /SCMTMS/FAG_CATEGORY_CODE
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: /SCMTMS/FAG_CATEGORY_CODE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FAGCATEID111

Description: Agreement Description
Field Name: MNEMONIC
Data Element: /SCMTMS/FAG_DESCRIPTION
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: /SCMTMS/FAG_DESCRIPTION
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MNEMONIC

Description: Existing Agreement Version
Field Name: VERSION_NO
Data Element: /SCMTMS/FAG_VERSION_NO
Data Type: NUMC
length (Dec): 4(0)
Check table:
Conversion Routine: ALPHA
Domain Name: /SCMTMS/FAG_VERSION_NO
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field VERSION_NO

Description: Shipping Type
Field Name: SHIPPING_TYPE
Data Element: /SCMTMS/SHIPPING_TYPE
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: /SCMTMS/SHIPPING_TYPE
MemoryID:
AppClass:
SHLP: /SCMTMS/SH_SHTYPE
SHLP Field: SHIPPING_TYPE
ConvExit:

See all SAP tables containing field SHIPPING_TYPE

Description: Traffic Direction
Field Name: TRAFFIC_DIRECT
Data Element: /SCMTMS/TRAFFIC_DIRECTION
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: /SCMTMS/TRAFFIC_DIRECTION
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TRAFFIC_DIRECT

Description: Transportation Mode Category
Field Name: MODEOFTRANSP_CAT
Data Element: /SCMTMS/TRMODCAT
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: /SAPAPO/TRMODCAT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MODEOFTRANSP_CAT

Description: NodeID
Field Name: PAR_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 PAR_KEY

Description: Created By
Field Name: CREATED_BY
Data Element: /BOFU/USER_ID_CREATED_BY
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: XUBNAME
MemoryID:
AppClass: SUSR
SHLP: USER_COMP
SHLP Field: BNAME
ConvExit:

See all SAP tables containing field CREATED_BY

Description: Created on
Field Name: CREATED_ON
Data Element: /BOFU/TSTMP_CREATION_TIME
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine: TSTLC
Domain Name: /BOFU/TSTMP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: TSTLC

See all SAP tables containing field CREATED_ON

Description: Changed By
Field Name: CHANGED_BY
Data Element: /BOFU/USER_ID_CHANGED_BY
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: XUBNAME
MemoryID:
AppClass: SUSR
SHLP: USER_COMP
SHLP Field: BNAME
ConvExit:

See all SAP tables containing field CHANGED_BY

Description: Changed On
Field Name: CHANGED_ON
Data Element: /BOFU/TSTMP_CHANGED_TIME
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine: TSTLC
Domain Name: /BOFU/TSTMP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: TSTLC

See all SAP tables containing field CHANGED_ON

Description: Service Product ID
Field Name: SP_ID
Data Element: /SCMTMS/SP_ID
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: /SCMTMS/SERVICE_PRODUCT_ID
MemoryID:
AppClass:
SHLP: /SCMTMS/SH_SP_ID
SHLP Field: SERVICE_PRODUCT_ID
ConvExit:

See all SAP tables containing field SP_ID

Description: Created On
Field Name: CREATED_ON_D
Data Element: /SCMTMS/CREATED_ON_D
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CREATED_ON_D

Description: Changed On
Field Name: CHANGED_ON_D
Data Element: /SCMTMS/CHANGED_ON_D
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHANGED_ON_D

Description: Agreement Status
Field Name: STATUS
Data Element: /SCMTMS/FAG_ROOT_STATUS
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: /SCMTMS/FAG_ROOT_STATUS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STATUS

Description: Agreement Usage
Field Name: FAGUSAGEID105
Data Element: /SCMTMS/FAG_USAGE_CODE
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: /SCMTMS/TRCHARG_USAGE_CODE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FAGUSAGEID105

Description: Validity Date Start (UTC)
Field Name: VALIDITY_START_TS
Data Element: /SCMTMS/VALIDITY_DATE_FROM_TS
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 VALIDITY_START_TS

Description: End Date of Validity (UTC)
Field Name: VALIDITY_END_TS
Data Element: /SCMTMS/VALIDITY_DATE_TO_TS
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 VALIDITY_END_TS

Description: Timestamp Relevant
Field Name: TIMESTAMP_RELEVANT
Data Element: /SCMTMS/TIMESTAMP_RELEVANT
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: /SCMTMS/INDICATOR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TIMESTAMP_RELEVANT