SAP ABAP Table MSR_S_COMM_CTRL_DB (Multi-step returns - communication Controller TRC_DB)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO-ARM (Application Component) Advanced Returns Management
     ⤷ MSR_TRACKING (Package) Multi-Step Returns: Tracking

Basic Data

Table Category	INTTAB	Structure
Structure	MSR_S_COMM_CTRL_DB	Table Relationship Diagram
Short Description	Multi-step returns - communication Controller TRC_DB

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	DOC_TYPE	☐	MSR_DOC_TYPE	MSR_DOC_TYPE	CHAR	2	0	Document Type
2	DOC_NR	☐	MSR_DOC_NR	MSR_DOC_NR	CHAR	30	0	Document Number
3	DOC_ITEM	☐	MSR_DOC_ITEM	MSR_DOC_ITEM	NUMC	10	0	Document Item
4	APPLICATION	☐	MSR_APPLICATION	MSR_APPLICATION	CHAR	2	0	Application
5	MSR_ID	☐	MSR_PROCESS_ID	MSR_PROCESS_ID	CHAR	10	0	Process Identification Number
6	ITEM	☐	MSR_PROCESS_ITEM	MSR_PROCESS_ITEM	NUMC	6	0	Item Number
7	SPLIT_ID	☐	MSR_SPLIT_ID	MSR_SPLIT_ID	NUMC	3	0	Split Identification Number
8	ITEM_COMPLETE	☐	MSR_COMPLETE	XFELD	CHAR	1	0	Completed
9	FU_CODE	☐	MSR_FU_CODE	MSR_FU_CODE	CHAR	4	0	Follow-Up Activity Code	*
10	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
11	MAT_RECEIVED	☐	MSR_MATERIAL_RECEIVED	XFELD	CHAR	1	0	Material Received
12	QUANTITY	☐	MSR_QUANTITY	MENG13	QUAN	13	3	Return Quantity in Base UoM
13	UNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
14	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
15	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
16	INSMK	☐	INSMK	INSMK	CHAR	1	0	Stock Type
17	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
18	RMA_CUSTOMER	☐	MSR_CRMA_NR	MSR_RMA_NR	CHAR	20	0	Customer RMA Number
19	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
20	LIFNR_ADRNR	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
21	RMA_VENDOR	☐	MSR_VRMA_NR	MSR_RMA_NR	CHAR	20	0	Vendor RMA Number
22	RMA_VENDOR_REQ	☐	MSR_VRMA_REQ	XFELD	CHAR	1	0	Vendor RMA Number Required
23	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
24	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
25	RESWK	☐	RESWK	WERKS	CHAR	4	0	Supplying (issuing) plant in case of stock transport order	*
26	NEXT_PLANTS	☐	MSR_T_NEXT_PLANTS		TTYP	0	0
27	REF_DOC_TYPE	☐	MSR_DOC_TYPE	MSR_DOC_TYPE	CHAR	2	0	Document Type
28	REF_DOC_NR	☐	MSR_DOC_NR	MSR_DOC_NR	CHAR	30	0	Document Number
29	REF_DOC_ITEM	☐	MSR_DOC_ITEM	MSR_DOC_ITEM	NUMC	10	0	Document Item
30	PAYING_STATUS	☐	MSR_FIN_STATUS	MSR_FIN_STATUS	CHAR	1	0	Status of Returns Refund Determination
31	EARNING_STATUS	☐	MSR_FIN_STATUS	MSR_FIN_STATUS	CHAR	1	0	Status of Returns Refund Determination
32	PRE_ORDER_TYPE	☐	MSR_DOC_TYPE	MSR_DOC_TYPE	CHAR	2	0	Document Type
33	PRE_ORDER_NR	☐	MSR_DOC_NR	MSR_DOC_NR	CHAR	30	0	Document Number
34	PRE_ORDER_ITEM	☐	MSR_DOC_ITEM	MSR_DOC_ITEM	NUMC	10	0	Document Item
35	PROCESS_TYPE	☐	MSR_DOC_TYPE	MSR_DOC_TYPE	CHAR	2	0	Document Type
36	FOLLOW_UP_EXISTS	☐	XFELD	XFELD	CHAR	1	0	Checkbox
37	INSPECTION_CODE	☐	MSR_INSPECTION_CODE	QCODE	CHAR	4	0	Inspection Code	*
38	LFU_PUBLISHED	☐	MSR_INSP_PUBLSTATUS	MSR_INSP_PUBLSTATUS	CHAR	1	0	Publishing Status
39	REFUND_CODE	☐	MSR_RETURNS_REFUND_CODE	MSR_RETURNS_REFUND_CODE	CHAR	3	0	Returns Refund Code
40	REFUND_CONTROL	☐	MSR_REFUND_CONTROL	MSR_REFUND_CONTROL	CHAR	1	0	Refund Control
41	REFUNDING	☐	MSR_REFUND_PROCEDURE	MSR_REFUND_PROCEDURE	CHAR	1	0	Refunding Procedure
42	RET_REASON	☐	MSR_RETURNS_REASON	MSR_RETURNS_REASON	CHAR	3	0	Return Reason	*
43	APPROVAL	☐	MSR_APPROVAL_STATUS	MSR_APPROVAL_STATUS	CHAR	1	0	Approval Status of Returns Process
44	DOC_STATUS	☐	MSR_DOC_STATUS	MSR_DOC_STATUS	CHAR	1	0	Status of Document Item
45	SAVE_INCOMPLETE	☐	XFELD	XFELD	CHAR	1	0	Checkbox
46	UPDATE_INDICATOR	☐	MSR_UPDATE_INDICATOR	MSR_UPDATE_INDICATOR	CHAR	1	0	Update Indicator
47	CREATED_ON	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
48	CREATED_BY	☐	USER	CHAR12	CHAR	12	0	Changed by
49	WAIT_FOR_CREDIT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
50	DEVIATION	☐	XFELD	XFELD	CHAR	1	0	Checkbox
51	VRM_COMPLETE	☐	MSR_VRM_COMPLETE	BOOLE	CHAR	1	0	Complete Logistical Process with GR of Replacement Material
52	LIFEX	☐	LIFEX	TEXT35	CHAR	35	0	External Identification of Delivery Note
53	.INCLUDE	☐				0	0	Replacement Material
54	.INCLUDE	☐				0	0	Replacement Material
55	REPLACE_MATNR	☐	MSR_REPLACE_MATNR	MATNR	CHAR	18	0	Replacement Material	MARA
56	REPLACE_QTY	☐	MSR_REPLACE_QTY	MENG15	QUAN	15	3	Replacement Material Quantity
57	REPLACE_UNIT	☐	MSR_REPLACE_UNIT	MEINS	UNIT	3	0	Replacement Material Unit of Measure	T006
58	POSGUID	☐	POSGUID	SYSUUID_22	CHAR	22	0	ATP: Encryption of DELNR and DELPS
59	REP_AVAIL_DATE	☐	MSR_REPLACE_AVAILABILITY_DATE	DATS	DATS	8	0	Replacement Material Availability Date
60	REP_AVAIL_QTY	☐	MSR_REPLACE_AVAILABILITY_QTY	MENG15	QUAN	15	3	Available Quantity for Replacement Material
61	.INCLUDE	☐				0	0	Replacement Material Financial Fields
62	REPLACED_QTY	☐	MSR_REPLACED_QTY	MENG15	QUAN	15	3	Replaced Quantity if Compensation by Replacement Material
63	REPLACED_UNIT	☐	MSR_REPLACED_UNIT	MEINS	UNIT	3	0	Unit of Measure for Replaced Quantity in Customer Returns	T006
64	CMR_QTY	☐	MSR_CMR_QTY	MENG15	QUAN	15	3	Credit Memo Request Quantity
65	CMR_UNIT	☐	MSR_CMR_UNIT	MEINS	UNIT	3	0	Unit of Measure for Credit Memo Request Quantity	T006
66	ABGRU	☐	ABGRU_VA	ABGRU_VA	CHAR	2	0	Reason for rejection of quotations and sales orders	TVAG
67	.INCLUDE	☐				0	0	Additional Data for Replacement Material handling
68	NFU_CODE	☐	MSR_NFU_CODE	MSR_FU_CODE	CHAR	4	0	Default for Next Follow-Up Activity in Material Inspection	MSR_I_CODE
69	REFUND_TYPE	☐	MSR_REFUND_TYPE	MSR_REFUND_TYPE	CHAR	1	0	Refund Type
70	PAYING_PLANT	☐	MSR_REPLACE_PLANT	WERKS	CHAR	4	0	Supplying Plant for Replacement Material	*
71	PRE_REFUND	☐	MSR_PRELIMINARY_REFUND	XFELD	CHAR	1	0	Preliminary Refund Determined
72	.INCLUDE	☐				0	0	Additional Data for Replacement Material handling
73	REPLACE_RELEASED	☐	MSR_REPLACEMENT_RELEASED	XFELD	CHAR	1	0	Release Subsequent Delivery Free of Charge
74	REFUND_RELEASED	☐	MSR_REFUNDING_RELEASED	XFELD	CHAR	1	0	Release Credit Memo Request
75	REPLACE_REQUEST	☐	MSR_REPLACEMENT_REQUESTED	XFELD	CHAR	1	0	Replacement Material from Vendor Requested
76	.INCLUDE	☐				0	0	Customer Inspection
77	CUST_INSP_CODE	☐	MSR_CUST_INSP_CODE	QCODE	CHAR	4	0	Customer Inspection Code	*
78	CUST_INSP_COMM	☐	MSR_CUST_INSP_COMMENT	TEXT132	CHAR	132	0	Customer Inspection Comment
79	CUST_COMMENT_AVAILABLE	☐	MSR_INSP_TEXT_AVAILABLE	FLAG	CHAR	1	0	Comment Available
80	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
81	BILLING_BLOCK	☐	MSR_BILLING_BLOCK	FAKSP	CHAR	2	0	Billing Block	*
82	DELIVERY_BLOCK	☐	MSR_DELIVERY_BLOCK	LIFSP	CHAR	2	0	Delivery Block	*
83	IS_VALUATION	☐	XFELD	XFELD	CHAR	1	0	Checkbox
84	FU_CODE_ERP	☐	MSR_FU_CODE_ERP	MSR_FU_CODE_ERP	CHAR	1	0	Maintenance of Follow-Up Code in ERP
85	INSP_IN_RO	☐	XFELD	XFELD	CHAR	1	0	Checkbox
86	MSR_PO_TYPE	☐	MSR_PO_TYPE	MSR_PO_TYPE	CHAR	1	0	Purchase Order Type for Advanced Returns
87	.INCLUDE	☐				0	0	CRM Identification
88	CRM_LOGSYS	☐	MSR_CRM_LOGSYS	LOGSYS	CHAR	10	0	CRM Logical System	*
89	CRM_OBJ_GUID	☐	MSR_CRM_OBJ_GUID	SYCHAR32	CHAR	32	0	CRM Object GUID
90	CRM_OBJ_ID	☐	MSR_CRM_OBJ_ID	VBELN	CHAR	10	0	CRM Object ID	*
91	CRM_OBJ_TYPE	☐	MSR_CRM_OBJ_TYPE	CHAR10	CHAR	10	0	CRM Object Type
92	RECEIVED_MATNR	☐	MSR_REP_REPLACE_MATNR	MATNR	CHAR	18	0	Replacement Material Received from Vendor	*
93	IM_PLANT	☐	MSR_PLANT_SPECIFIED	WERKS	CHAR	4	0	Target Plant for Transfer to Specified Stock	*
94	IM_MATERIAL	☐	MSR_MAT_SPECIFIED	MATNR	CHAR	18	0	Target Material for Transfer to Specified Stock	*
95	START_DOC_TYPE	☐	MSR_DOC_TYPE	MSR_DOC_TYPE	CHAR	2	0	Document Type
96	START_DOC_NR	☐	MSR_DOC_NR	MSR_DOC_NR	CHAR	30	0	Document Number
97	START_DOC_ITEM	☐	MSR_DOC_ITEM	MSR_DOC_ITEM	NUMC	10	0	Document Item
98	CMR_ABGRU	☐	MSR_CMR_ABGRU	ABGRU_VA	CHAR	2	0	Rejection Reason for Credit Memo Request	*
99	EWM_DECSY	☐	/SPE/DECSY	/SPE/DECSY	CHAR	1	0	Reference to External Warehouse Management

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MSR_S_COMM_CTRL_DB	ABGRU	TVAG	ABGRU
2	MSR_S_COMM_CTRL_DB	CMR_UNIT	T006	MSEHI
3	MSR_S_COMM_CTRL_DB	NFU_CODE	MSR_I_CODE	FU_CODE
4	MSR_S_COMM_CTRL_DB	REPLACED_UNIT	T006	MSEHI
5	MSR_S_COMM_CTRL_DB	REPLACE_MATNR	MARA	MATNR
6	MSR_S_COMM_CTRL_DB	REPLACE_UNIT	T006	MSEHI

History

Last changed by/on	SAP	20130529
SAP Release Created in	100