SAP ABAP Table MSR_S_SALES_ITEM (Advanced Returns: Item data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-BF-IF (Application Component) R/3 Interface for Business Transactions
     ⤷ VA (Package) Application development R/3 Sales

Basic Data

Table Category	INTTAB	Structure
Structure	MSR_S_SALES_ITEM	Table Relationship Diagram
Short Description	Advanced Returns: Item data

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	MSR_ID	☐	MSR_PROCESS_ID	MSR_PROCESS_ID	CHAR	10	0	Process Identification Number
2	POSNR	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	*
3	MAT_RECEIVED	☐	MSR_MATERIAL_RECEIVED	XFELD	CHAR	1	0	Material Received
4	FU_CODE	☐	MSR_FU_CODE	MSR_FU_CODE	CHAR	4	0	Follow-Up Activity Code	MSR_I_CODE
5	REFUND_CONTROL	☐	MSR_REFUND_CONTROL	MSR_REFUND_CONTROL	CHAR	1	0	Refund Control
6	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	*
7	VENDOR_NAME	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
8	VENDOR_ADRNR	☐	ADRN2	AD_ADDRNUM	CHAR	10	0	Number of delivery address	*
9	VENDOR_DIFF_ADR	☐	ADRN2	AD_ADDRNUM	CHAR	10	0	Number of delivery address	*
10	RMA_VENDOR	☐	MSR_VRMA_NR	MSR_RMA_NR	CHAR	20	0	Vendor RMA Number
11	RMA_VENDOR_REQ	☐	MSR_VRMA_REQ	XFELD	CHAR	1	0	Vendor RMA Number Required
12	INSPECTION_CODE	☐	MSR_INSPECTION_CODE	QCODE	CHAR	4	0	Inspection Code	*
13	AT_CUSTOMER_SITE	☐	MSR_AT_CUSTOMER_SITE	XFELD	CHAR	1	0	Inspection at Customer Site
14	INSPECTION_COMMENT	☐	MSR_INSPECTION_COMMENT	MSR_INSPECTION_COMMENT	CHAR	40	0	Inspection Comment
15	INSP_SHORT_TEXT	☐	MSR_INSP_COMMENT	TEXT132	CHAR	132	0	Inspection Comment Line
16	NEXT_PLANT	☐	MSR_NEXT_PLANT	WERKS	CHAR	4	0	Next Plant	T001W
17	NEXT_PLANT_NAME	☐	NAME1	TEXT30	CHAR	30	0	Name
18	TRANSSHIPMENT	☐	MSR_TRANSSHIPMENT_PLANT	XFELD	CHAR	1	0	Transshipment Plant
19	RMA_CUSTOMER	☐	MSR_CRMA_NR	MSR_RMA_NR	CHAR	20	0	Customer RMA Number
20	DISPLAY_ONLY	☐	XFELD	XFELD	CHAR	1	0	Checkbox
21	MULTIPLE_PLANTS	☐	XFELD	XFELD	CHAR	1	0	Checkbox
22	REF_DOC_TYPE	☐	MSR_DOC_TYPE	MSR_DOC_TYPE	CHAR	2	0	Document Type
23	REF_DOC_NR	☐	MSR_DOC_NR	MSR_DOC_NR	CHAR	30	0	Document Number
24	REF_DOC_ITEM	☐	MSR_DOC_ITEM	MSR_DOC_ITEM	NUMC	10	0	Document Item
25	.INCLUDE	☐				0	0	Replacement Material
26	.INCLUDE	☐				0	0	Replacement Material
27	REPLACE_MATNR	☐	MSR_REPLACE_MATNR	MATNR	CHAR	18	0	Replacement Material	MARA
28	REPLACE_QTY	☐	MSR_REPLACE_QTY	MENG15	QUAN	15	3	Replacement Material Quantity
29	REPLACE_UNIT	☐	MSR_REPLACE_UNIT	MEINS	UNIT	3	0	Replacement Material Unit of Measure	T006
30	POSGUID	☐	POSGUID	SYSUUID_22	CHAR	22	0	ATP: Encryption of DELNR and DELPS
31	REP_AVAIL_DATE	☐	MSR_REPLACE_AVAILABILITY_DATE	DATS	DATS	8	0	Replacement Material Availability Date
32	REP_AVAIL_QTY	☐	MSR_REPLACE_AVAILABILITY_QTY	MENG15	QUAN	15	3	Available Quantity for Replacement Material
33	REPLACE_MATNRTXT	☐	MAKTX	TEXT40	CHAR	40	0	Material description
34	PAYING_PLANT_TXT	☐	NAME1	TEXT30	CHAR	30	0	Name
35	.INCLUDE	☐				0	0	Additional Data for Replacement Material handling
36	NFU_CODE	☐	MSR_NFU_CODE	MSR_FU_CODE	CHAR	4	0	Default for Next Follow-Up Activity in Material Inspection	MSR_I_CODE
37	REFUND_TYPE	☐	MSR_REFUND_TYPE	MSR_REFUND_TYPE	CHAR	1	0	Refund Type
38	PAYING_PLANT	☐	MSR_REPLACE_PLANT	WERKS	CHAR	4	0	Supplying Plant for Replacement Material	*
39	PRE_REFUND	☐	MSR_PRELIMINARY_REFUND	XFELD	CHAR	1	0	Preliminary Refund Determined
40	.INCLUDE	☐				0	0	Customer Inspection
41	CUST_INSP_CODE	☐	MSR_CUST_INSP_CODE	QCODE	CHAR	4	0	Customer Inspection Code	*
42	CUST_INSP_COMM	☐	MSR_CUST_INSP_COMMENT	TEXT132	CHAR	132	0	Customer Inspection Comment
43	CUST_COMMENT_AVAILABLE	☐	MSR_INSP_TEXT_AVAILABLE	FLAG	CHAR	1	0	Comment Available
44	ATP_STATUS	☐	MSR_ATP_STATUS	MSR_ATP_STATUS	CHAR	1	0	ATP Status
45	REPLACE_REQUEST	☐	MSR_REPLACEMENT_REQUESTED	XFELD	CHAR	1	0	Replacement Material from Vendor Requested
46	.INCLUDE	☐				0	0	CRM Identification
47	CRM_LOGSYS	☐	MSR_CRM_LOGSYS	LOGSYS	CHAR	10	0	CRM Logical System	*
48	CRM_OBJ_GUID	☐	MSR_CRM_OBJ_GUID	SYCHAR32	CHAR	32	0	CRM Object GUID
49	CRM_OBJ_ID	☐	MSR_CRM_OBJ_ID	VBELN	CHAR	10	0	CRM Object ID	*
50	CRM_OBJ_TYPE	☐	MSR_CRM_OBJ_TYPE	CHAR10	CHAR	10	0	CRM Object Type
51	REPLACED_MATNR	☐	MSR_REPLACED_MATNR	MATNR	CHAR	18	0	Returned Material	*
52	REPLACED_MATNRTXT	☐	MAKTX	TEXT40	CHAR	40	0	Material description
53	REPLACED_QTY	☐	MSR_REPLACED_QTY	MENG15	QUAN	15	3	Replaced Quantity if Compensation by Replacement Material
54	REPLACED_UNIT	☐	MSR_REPLACED_UNIT	MEINS	UNIT	3	0	Unit of Measure for Replaced Quantity in Customer Returns	*
55	CMR_ABGRU	☐	MSR_CMR_ABGRU	ABGRU_VA	CHAR	2	0	Rejection Reason for Credit Memo Request	TVAG

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MSR_S_SALES_ITEM	CMR_ABGRU	TVAG	ABGRU	REF	C	CN
2	MSR_S_SALES_ITEM	FU_CODE	MSR_I_CODE	FU_CODE
3	MSR_S_SALES_ITEM	NEXT_PLANT	T001W	WERKS
4	MSR_S_SALES_ITEM	NFU_CODE	MSR_I_CODE	FU_CODE
5	MSR_S_SALES_ITEM	REPLACE_MATNR	MARA	MATNR
6	MSR_S_SALES_ITEM	REPLACE_UNIT	T006	MSEHI

History

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