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


SAP /SCMTMS/S_FAG_ROOT_Q_SP table summary

Object Name: /SCMTMS/S_FAG_ROOT_Q_SP
Dictionary Type: Structure
Description: query freight agreement by servcie product


Field list for /SCMTMS/S_FAG_ROOT_Q_SP table on an S/4 SAP system

Details
/SCMTMS/S_FAG_ROOT_Q_SP-FAGRMNTID044 table field - Service Product Catalog

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

/SCMTMS/S_FAG_ROOT_Q_SP-FAGTYPEID103 table field - Service Product Catalog Type

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

/SCMTMS/S_FAG_ROOT_Q_SP-FAGCATEID111 table field - Agreement Category

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

/SCMTMS/S_FAG_ROOT_Q_SP-MNEMONIC table field - Agreement Description

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

/SCMTMS/S_FAG_ROOT_Q_SP-VERSION_NO table field - Existing Agreement Version

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

/SCMTMS/S_FAG_ROOT_Q_SP-SHIPPING_TYPE table field - Shipping Type

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

/SCMTMS/S_FAG_ROOT_Q_SP-TRAFFIC_DIRECT table field - Traffic Direction

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

/SCMTMS/S_FAG_ROOT_Q_SP-MODEOFTRANSP_CAT table field - Transportation Mode Category

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

/SCMTMS/S_FAG_ROOT_Q_SP-PAR_KEY table field - NodeID

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

/SCMTMS/S_FAG_ROOT_Q_SP-CREATED_BY table field - Created By

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

/SCMTMS/S_FAG_ROOT_Q_SP-CREATED_ON table field - Created on

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

/SCMTMS/S_FAG_ROOT_Q_SP-CHANGED_BY table field - Changed By

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

/SCMTMS/S_FAG_ROOT_Q_SP-CHANGED_ON table field - Changed On

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

/SCMTMS/S_FAG_ROOT_Q_SP-SP_ID table field - Service Product ID

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

/SCMTMS/S_FAG_ROOT_Q_SP-CREATED_ON_D table field - Created On

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

/SCMTMS/S_FAG_ROOT_Q_SP-CHANGED_ON_D table field - Changed On

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

/SCMTMS/S_FAG_ROOT_Q_SP-STATUS table field - Agreement Status

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

/SCMTMS/S_FAG_ROOT_Q_SP-FAGUSAGEID105 table field - Agreement Usage

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

/SCMTMS/S_FAG_ROOT_Q_SP-VALIDITY_START_TS table field - Validity Date Start (UTC)

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

/SCMTMS/S_FAG_ROOT_Q_SP-VALIDITY_END_TS table field - End Date of Validity (UTC)

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

/SCMTMS/S_FAG_ROOT_Q_SP-TIMESTAMP_RELEVANT table field - Timestamp Relevant

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


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table