SAP ABAP Table CRMS_TM_FWQ (Forwarding Quotation)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BF-TMS (Application Component) Integration to Transportation Management
     ⤷ CRM_TM_INTEGRATION (Package) CRM-TM Integration

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_TM_FWQ	Table Relationship Diagram
Short Description	Forwarding Quotation

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	KEY	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
2	TRQ_ID	☐	CRM_TM_TRQ_ID	CRM_TM_TRQ_ID	CHAR	20	0	Document ID
3	TRQ_TYPE	☐	CRM_TM_TRQ_FWQ_TYPE	CHAR4	CHAR	4	0	Forwarding Quotation Type
4	TRQ_TYPE_DESCR	☐	CRM_TM_TRQ_TYPE_DESC	CHAR40	CHAR	40	0	Type Description (FWO/FWQ/Transportation Request)
5	ORDERING_PARTY	☐	CRM_TM_PTY_ORDERING_PARTY	BU_PARTNER	CHAR	10	0	Ordering Party	*
6	FORMATTED_ADDR_ORDPTY	☐	CRM_TM_FORM_NAME_CITY_ADD		SSTR	80	0	Name and Address
7	ORDPTY_CONTACT_PERSON	☐	CRM_TM_ORDPTY_CONTACT_PERSON		SSTR	80	0	Ordering Party Contact Person
8	SHIPPER_ID	☐	CRM_TM_PTY_SHIPPER	BU_PARTNER	CHAR	10	0	Shipper	*
9	FORMATTED_ADDR_SHIP	☐	CRM_TM_FORM_NAME_CITY_ADD		SSTR	80	0	Name and Address
10	SHIP_CONTACT_PERSON	☐	CRM_TM_SHIP_CONTACT_PERSON		SSTR	80	0	Shipper's Contact Person
11	CONSIGNEE_ID	☐	CRM_TM_PTY_CONSIGNEE	BU_PARTNER	CHAR	10	0	Consignee	*
12	FORMATTED_ADDR_CONS	☐	CRM_TM_FORM_NAME_CITY_ADD		SSTR	80	0	Name and Address
13	CONS_CONTACT_PERSON	☐	CRM_TM_CONS_CONTACT_PERSON		SSTR	80	0	Consignee Contact Person
14	SALES_ORG_ID	☐	CRM_TM_SALES_ORG_ID	CHAR20	CHAR	20	0	Sales Organization
15	SALES_ORG_DESCR	☐	CRM_TM_SALES_ORG_DESCR	CRM_TM_ORG_UNIT_DESCR	CHAR	40	0	Sales Organization Description
16	SALES_OFF_ID	☐	CRM_TM_SALES_OFF_ID	CHAR20	CHAR	20	0	Sales Office
17	SALES_OFFICE_DESCR	☐	CRM_TM_SALES_OFF_DESCR	CRM_TM_ORG_UNIT_DESCR	CHAR	40	0	Sales Office Description
18	SALES_GROUP_ID	☐	CRM_TM_SALES_GRP_ID	CHAR20	CHAR	20	0	Sales Group
19	SALES_GROUP_DESCR	☐	CRM_TM_SALES_GRP_DESCR	CRM_TM_ORG_UNIT_DESCR	CHAR	40	0	Sales Group Description
20	SRC_LOC_ID	☐	CRM_TM_SOURCE_LOCATION		CHAR	20	0	Source Location
21	COUNTRY_FROM	☐	CRM_TM_COUNTRY_FROM	LAND1	CHAR	3	0	From Country	*
22	DES_LOC_ID	☐	CRM_TM_DESTINATION_LOCATION		CHAR	20	0	Destination Location
23	COUNTRY_TO	☐	CRM_TM_COUNTRY_TO	LAND1	CHAR	3	0	To Country	*
24	ORDER_DATE	☐	CRM_TM_ORDER_DATE	DATS	DATS	8	0	Order Date of FWO or FWQ
25	QUOT_VALID_FROM	☐	CRM_TM_TRQ_QUOT_VALID_FROM	CRM_TM_TSTMP_CREATION_TIME	DEC	15	0	Quotation Valid From
26	QUOT_VALID_TO	☐	CRM_TM_TRQ_QUOT_VALID_TO	CRM_TM_TSTMP_CREATION_TIME	DEC	15	0	Quotation Valid To
27	QUOTATION_PRICE_VAL	☐	CRM_TM_QUOT_PRICE_VAL	CRM_TM_AMOUNT	CURR	28	6	Quotation Price
28	QUOTATION_PRICE_CURR	☐	CRM_TM_QUOT_PRICE_CURR	WAERS	CUKY	5	0	Quotation Currency	*
29	GRO_WEI_VAL	☐	CRM_TM_GRO_WEI_VAL	CRM_TM_QUANTITY	QUAN	31	14	Gross Weight
30	GRO_WEI_UNI	☐	CRM_TM_GRO_WEI_UNI	MEINS	UNIT	3	0	Gross Weight Unit of Measure	*
31	GRO_VOL_VAL	☐	CRM_TM_QUA_GRO_VOL_VAL	CRM_TM_QUANTITY	QUAN	31	14	Gross Volume
32	GRO_VOL_UNI	☐	CRM_TM_QUA_GRO_VOL_UNI	MEINS	UNIT	3	0	Gross Volume Unit of Measure	*
33	CONT_CNT_VAL	☐	CRM_TM_CONT_CNT_VAL	CRM_TM_QUANTITY	QUAN	31	14	Number of TEU
34	CONT_CNT_UNI	☐	CRM_TM_CONT_CNT_UNI	MEINS	UNIT	3	0	Number of TEU Unit of Measure	*
35	QUA_PCS_VAL	☐	CRM_TM_QUA_PCS_VAL	CRM_TM_QUANTITY	QUAN	31	14	Quantity
36	QUA_PCS_UNI	☐	CRM_TM_QUA_PCS_UNI	MEINS	UNIT	3	0	Quantity Unit of Measure	*
37	MOVEM_TYPE	☐	CRM_TM_MOVEMENT_TYPE	CRM_TM_MOVEMENT_TYPE	CHAR	3	0	Movement Type
38	MOVEM_TYPE_DESC	☐	CRM_TM_MOVEM_TYPE_DESC	CHAR40	CHAR	40	0	Movement Type Description
39	INC_CLASS_CODE	☐	CRM_TM_INC_CLASS_CODE		CHAR	3	0	Incoterm
40	MOT	☐	CRM_TM_TRMODCODE		CHAR	2	0	Transportation Mode
41	MOT_DESC	☐	CRM_TM_MOT_DESC	CHAR40	CHAR	40	0	Transportation Mode Description
42	SHIPPING_TYPE	☐	CRM_TM_SHIPPING_TYPE	CRM_TM_SHIPPING_TYPE	CHAR	3	0	Shipping Type
43	SHIPPING_TYPE_DESC	☐	CRM_TM_SHIPPING_TYPE_DESC	CHAR40	CHAR	40	0	Shipping Type Description
44	SERVICE_PRODUCT_ID	☐	CRM_TM_SERVICE_PRODUCT_ID	CRM_TM_SERVICE_PRODUCT_ID	CHAR	40	0	Service Product
45	SP_DESC	☐	CRM_TM_SP_DESC	CHAR75	CHAR	75	0	Service Product Description
46	DGO_INDICATOR	☐	CRM_TM_DANG_GOODS_IND	SAP_BOOL	CHAR	1	0	Dangerous Goods
47	LIFECYCLE	☐	CRM_TM_LIFECYCLE	CHAR2	CHAR	2	0	Life Cycle Status of FWO/FWQ/Transportation Request
48	LIFECYCLE_DESC	☐	CRM_TM_LIFECYCLE_DESC	DDTEXT	CHAR	60	0	Lifecycle Status Description
49	RFQ_RESP_CODE	☐	CRM_TM_RESPONSE_CODE	CRM_TM_RESPONSE_CODE	CHAR	2	0	Response
50	RESP_CODE_DESC	☐	CRM_TM_RESP_CODE_DESC	DDTEXT	CHAR	60	0	Response Code Description
51	ARCHIVING	☐	CRM_TM_ARCHIVING_STATUS_CODE	CRM_TM_ARCHIVING_STATUS_CODE	CHAR	2	0	Archiving Status
52	ARCHIVING_DESC	☐	CRM_TM_ARCHIVING_ST_DESC	DDTEXT	CHAR	60	0	Archiving Status Description
53	CHANGED_BY	☐	CRM_TM_USER_ID_CHANGED_BY	XUBNAME	CHAR	12	0	Changed By	*
54	CHANGED_ON	☐	CRM_TM_TSTMP_CHANGED_TIME	CRM_TM_TSTMP_CREATION_TIME	DEC	15	0	Changed On
55	CREATED_BY	☐	CRM_TM_USER_ID_CREATED_BY	XUBNAME	CHAR	12	0	Created By	*
56	CREATED_ON	☐	CRM_TM_TSTMP_CREATION_TIME	CRM_TM_TSTMP_CREATION_TIME	DEC	15	0	Created on

History

Last changed by/on	SAP	20140117
SAP Release Created in	714