SAP ABAP Table MSR_S_INSP_ITEM (Advanced Returns Management - Inspection Item)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO-ARM-INS (Application Component) Inspection
     ⤷ MSR_INSPECTION (Package) Multi-Step Returns: Inspections

Basic Data

Table Category	INTTAB	Structure
Structure	MSR_S_INSP_ITEM	Table Relationship Diagram
Short Description	Advanced Returns Management - Inspection Item

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	INSPEC_NUMB	☐	/SPE/INSPEC_NO	/SPE/INSPEC_NO	CHAR	12	0	Inspection Outcome number
2	INSPEC_ITEM	☐	/SPE/INSP_ITEM_NO	/SPE/INSP_ITEM_NO	NUMC	4	0	Inspection Item Number
3	DELIV_NUMB	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	*
4	DELIV_ITEM	☐	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	*
5	DELIV_TYPE	☐	MSR_DOC_TYPE	MSR_DOC_TYPE	CHAR	2	0	Document Type
6	EXIDV	☐	EXIDV	EXIDV	CHAR	20	0	External Handling Unit Identification
7	MSR_ID	☐	MSR_PROCESS_ID	MSR_PROCESS_ID	CHAR	10	0	Process Identification Number
8	MSR_ITEM	☐	MSR_PROCESS_ITEM	MSR_PROCESS_ITEM	NUMC	6	0	Item Number
9	MSR_SPLIT_ID	☐	MSR_SPLIT_ID	MSR_SPLIT_ID	NUMC	3	0	Split Identification Number
10	REF_DOC_NR	☐	MSR_DOC_NR	MSR_DOC_NR	CHAR	30	0	Document Number
11	REF_DOC_ITEM	☐	MSR_DOC_ITEM	MSR_DOC_ITEM	NUMC	10	0	Document Item
12	REF_DOC_TYPE	☐	MSR_DOC_TYPE	MSR_DOC_TYPE	CHAR	2	0	Document Type
13	DEC_CODE_CAT	☐	/SPE/DEC_CODE_CAT	/SPE/CODE_CAT	CHAR	1	0	Inspection Outcome: Catalog Decision
14	DEC_CODE_GROUP	☐	/SPE/DEC_CODE_GROUP	/SPE/CODE_GROUP	CHAR	8	0	Inspection Outcome: Code group Decision
15	DEC_CODE	☐	MSR_INSPECTION_CODE	QCODE	CHAR	4	0	Inspection Code	*
16	DEC_CODE_DESC	☐	MSR_INSP_DEC_CODE_DESC	QKURZTEXT	CHAR	40	0	Description of Inspection Decision Code
17	FU_CODE_CAT	☐	/SPE/FU_CODE_CAT	/SPE/CODE_CAT	CHAR	1	0	Inspection Outcome: Catalog Follow-up activity
18	FU_CODE_GROUP	☐	/SPE/FU_CODE_GROUP	/SPE/CODE_GROUP	CHAR	8	0	Inspection Outcome: Code group Follow-up activity
19	FU_CODE	☐	MSR_FU_CODE	MSR_FU_CODE	CHAR	4	0	Follow-Up Activity Code	*
20	FU_CODE_DESC	☐	MSR_FU_CODE_TEXT	TEXT60	CHAR	60	0	Follow-Up Activity Description
21	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
22	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
23	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
24	ARKTX	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
25	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
26	TOTAL_QUAN	☐	MSR_INSP_TOTAL_QTY	MENG13	QUAN	13	3	Total Inspected Quantity
27	ORG_QUAN	☐	MSR_INSP_ORG_QTY	MENG13	QUAN	13	3	Original Quantity
28	INSP_QUAN	☐	MSR_INSP_INSPECTED_QTY	MENG13	QUAN	13	3	Inspected Quantity
29	INSP_UNIT	☐	MSR_INSP_QUAN_UOM	MEINS	UNIT	3	0	Unit of Measure for Inspected Quantity	*
30	UOM_INDICATOR	☐	MSR_INSP_UOM_INDICATOR	MSR_INSP_UOM_INDICATOR	CHAR	1	0	Indicator for Leading UoM in Inspection
31	INSP_QUAN_BUOM	☐	MSR_INSP_QUAN	/SPE/INSPQTY	QUAN	13	3	Inspected Quantity in Base Unit of Measure
32	INSP_BUOM	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
33	INSP_QUAN_SUOM	☐	MSR_INSP_QTY_SALES_UNIT	MENG13	QUAN	13	3	Inspected Quantity in Sales Unit of Measure
34	INSP_SUOM	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
35	UMVKN	☐	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
36	UMVKZ	☐	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
37	LGMNG	☐	LGMNG	MENG13	QUAN	13	3	Actual quantity delivered in stockkeeping units
38	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
39	LFIMG	☐	LFIMG	MENG13	QUAN	13	3	Actual quantity delivered (in sales units)
40	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
41	INSP_OUT_GUID	☐	MSR_INSP_GUID		RAW	16	0	Inspection GUID
42	WADAT_IST	☐	WADAT_IST	DATUM	DATS	8	0	Actual Goods Movement Date
43	RMA_CUSTOMER	☐	MSR_CRMA_NR	MSR_RMA_NR	CHAR	20	0	Customer RMA Number
44	CUSTOMER	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	*
45	CUSTOMER_NAME	☐	NAME1	TEXT30	CHAR	30	0	Name
46	RMA_VENDOR	☐	MSR_VRMA_NR	MSR_RMA_NR	CHAR	20	0	Vendor RMA Number
47	RMA_VENDOR_REQ	☐	MSR_VRMA_REQ	XFELD	CHAR	1	0	Vendor RMA Number Required
48	VENDOR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	*
49	VENDOR_NAME	☐	NAME1	TEXT30	CHAR	30	0	Name
50	ADRNR	☐	ADRN2	AD_ADDRNUM	CHAR	10	0	Number of delivery address	*
51	VENDOR_ADRNR	☐	ADRN2	AD_ADDRNUM	CHAR	10	0	Number of delivery address	*
52	RET_REASON	☐	MSR_RETURNS_REASON	MSR_RETURNS_REASON	CHAR	3	0	Return Reason	*
53	RET_REASON_DESC	☐	BEZEI60	TEXT60	CHAR	60	0	Description of rule
54	INSPECTOR	☐	MSR_INSP_INSPECTOR	MSR_INSP_INSPECTOR	CHAR	80	0	Person Responsible for Inspection
55	INSPECTION_DATE	☐	MSR_INSP_DATE	DATUM	DATS	8	0	Inspection Date
56	INSP_VENDOR	☐	MSR_INSP_VENDOR	LIFNR	CHAR	10	0	Inspecting Vendor	*
57	LFU_RESPONSIBLE	☐	MSR_INSP_LDM_RESP	MSR_INSP_LFU_RESPONSIBLE	CHAR	80	0	Person Responsible for Logistical Follow-Up
58	LFU_DATE	☐	MSR_INSP_LDM_DATE	DATUM	DATS	8	0	Release Date of Logistical Follow-Up
59	SUPPLY_PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
60	SUPPLY_LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
61	NEXT_PLANT	☐	MSR_NEXT_PLANT	WERKS	CHAR	4	0	Next Plant	T001W
62	NEXT_PLANT_NAME	☐	NAME1	TEXT30	CHAR	30	0	Name
63	MULTIPLE_PLANTS	☐	XFELD	XFELD	CHAR	1	0	Checkbox
64	TRANSSHIPMENT	☐	MSR_TRANSSHIPMENT_PLANT	XFELD	CHAR	1	0	Transshipment Plant
65	IM_INSMK	☐	MSR_INSMK_SPECIFIED	INSMK	CHAR	1	0	Target Stock Type for Transfer to Specified Stock
66	IM_PLANT	☐	MSR_PLANT_SPECIFIED	WERKS	CHAR	4	0	Target Plant for Transfer to Specified Stock	T001W
67	IM_PLANT_NAME	☐	NAME1	TEXT30	CHAR	30	0	Name
68	IM_LGORT	☐	MSR_SLOC_SPECIFIED_INSP	LGORT	CHAR	4	0	Storage Location for Transfer to Specified Stock	T001L
69	IM_MATERIAL	☐	MSR_MAT_SPECIFIED	MATNR	CHAR	18	0	Target Material for Transfer to Specified Stock	*
70	IM_MATERIAL_NAME	☐	MAKTX	TEXT40	CHAR	40	0	Material description
71	REFUND_CONTROL	☐	MSR_REFUND_CONTROL_INSP	MSR_REFUND_CONTROL_INSP	CHAR	1	0	Refund Control During Inspection
72	REFUND_CODE	☐	MSR_INSP_REFUND_CODE	MSR_RETURNS_REFUND_CODE	CHAR	3	0	Returns Refund Code
73	REFUND_BLOCK	☐	MSR_REFUND_BLOCK_INSP	XFELD	CHAR	1	0	Refunding After Receipt of Credit Memo
74	BSGRU	☐	BSGRU	BSGRU	CHAR	3	0	Reason for Ordering	TBSG
75	DECISION_LEVEL	☐	MSR_INSP_DECISION_LEVEL	MSR_INSP_DECISION_LEVEL	CHAR	1	0	Decision Level
76	PUBLSTATUS	☐	MSR_INSP_PUBLSTATUS	MSR_INSP_PUBLSTATUS	CHAR	1	0	Publishing Status
77	CREATED_ON	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
78	TZONE	☐	TZNZONE	TZNZONE	CHAR	6	0	Time Zone	*
79	CREATED_ON_DATE	☐	DATE	CHAR8	CHAR	8	0	Date in CHAR format
80	CREATED_ON_TIME	☐	TIME	CHAR6	CHAR	6	0	Time in CHAR Format
81	CREATED_BY	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
82	COMMENT_TEXT	☐	MSR_INSP_COMMENT	TEXT132	CHAR	132	0	Inspection Comment Line
83	COMMENT_AVAILABLE	☐	MSR_INSP_TEXT_AVAILABLE	FLAG	CHAR	1	0	Comment Available
84	ARCHIV_ID	☐	SAEADOKID	SADC40_BL	CHAR	40	0	SAP ArchiveLink: Doc_ID
85	AT_CUSTOMER_SITE	☐	MSR_AT_CUSTOMER_SITE	XFELD	CHAR	1	0	Inspection at Customer Site
86	LOG_HANDLE	☐	BALLOGHNDL	SYSUUID_22	CHAR	22	0	Application Log: Log Handle
87	FUP_BLOCK	☐	MSR_INSP_FUP_BLOCK	MSR_INSP_FUP_BLOCK	CHAR	4	0	Block for Follow-Up Activities	MSR_D_FUP_BLOCK
88	FUP_BLOCK_DESC	☐	MSR_INSP_FUP_BLOCK_DESC	MSR_INSP_FUP_BLOCK_DESC	CHAR	60	0	Description of Follow-Up Activity Block
89	FU_CODE_ERP	☐	MSR_FU_CODE_ERP	MSR_FU_CODE_ERP	CHAR	1	0	Maintenance of Follow-Up Code in ERP
90	INSP_STATUS_ITEM	☐	MSR_INSP_INSP_STATUS	MSR_INSP_INSP_STATUS	CHAR	1	0	Inspection Status
91	LFU_STATUS_ITEM	☐	MSR_INSP_LDM_STATUS	MSR_INSP_LDM_STATUS	CHAR	1	0	Logistical Follow-Up Status
92	SPLIT_GROUP	☐	INT4	INT4	INT4	10	0	Natural number
93	INSP_IN_RO	☐	XFELD	XFELD	CHAR	1	0	Checkbox
94	DB_DELFLAG	☐	/SPE/LSKENZ	/SPE/LSKENZ	CHAR	1	0	Inspection Outcome: Delete flag
95	DELETED	☐	MSR_INSP_DELETE	FLAG	CHAR	1	0	Deleted
96	CANCELLED	☐	MSR_INSP_CANCELLED	FLAG	CHAR	1	0	Inspection Cancelled
97	CHANGEABLE	☐	XFELD	XFELD	CHAR	1	0	Checkbox
98	UPDKZ	☐	MSR_INSP_UPDKZ	MSR_INSP_UPDKZ	CHAR	1	0	Update Update
99	.INCLUDE	☐				0	0	Inspection Replacement Material
100	.INCLUDE	☐				0	0	Replacement Material
101	.INCLUDE	☐				0	0	Replacement Material
102	REPLACE_MATNR	☐	MSR_REPLACE_MATNR	MATNR	CHAR	18	0	Replacement Material	MARA
103	REPLACE_QTY	☐	MSR_REPLACE_QTY	MENG15	QUAN	15	3	Replacement Material Quantity
104	REPLACE_UNIT	☐	MSR_REPLACE_UNIT	MEINS	UNIT	3	0	Replacement Material Unit of Measure	T006
105	POSGUID	☐	POSGUID	SYSUUID_22	CHAR	22	0	ATP: Encryption of DELNR and DELPS
106	REP_AVAIL_DATE	☐	MSR_REPLACE_AVAILABILITY_DATE	DATS	DATS	8	0	Replacement Material Availability Date
107	REP_AVAIL_QTY	☐	MSR_REPLACE_AVAILABILITY_QTY	MENG15	QUAN	15	3	Available Quantity for Replacement Material
108	.INCLUDE	☐				0	0	Replacement Material Financial Fields
109	REPLACED_QTY	☐	MSR_REPLACED_QTY	MENG15	QUAN	15	3	Replaced Quantity if Compensation by Replacement Material
110	REPLACED_UNIT	☐	MSR_REPLACED_UNIT	MEINS	UNIT	3	0	Unit of Measure for Replaced Quantity in Customer Returns	T006
111	CMR_QTY	☐	MSR_CMR_QTY	MENG15	QUAN	15	3	Credit Memo Request Quantity
112	CMR_UNIT	☐	MSR_CMR_UNIT	MEINS	UNIT	3	0	Unit of Measure for Credit Memo Request Quantity	T006
113	ABGRU	☐	ABGRU_VA	ABGRU_VA	CHAR	2	0	Reason for rejection of quotations and sales orders	TVAG
114	.INCLUDE	☐				0	0	Additional Data for Replacement Material handling
115	NFU_CODE	☐	MSR_NFU_CODE	MSR_FU_CODE	CHAR	4	0	Default for Next Follow-Up Activity in Material Inspection	MSR_I_CODE
116	REFUND_TYPE	☐	MSR_REFUND_TYPE	MSR_REFUND_TYPE	CHAR	1	0	Refund Type
117	PAYING_PLANT	☐	MSR_REPLACE_PLANT	WERKS	CHAR	4	0	Supplying Plant for Replacement Material	*
118	PRE_REFUND	☐	MSR_PRELIMINARY_REFUND	XFELD	CHAR	1	0	Preliminary Refund Determined
119	.INCLUDE	☐				0	0	Additional Data for Replacement Material handling
120	REPLACE_RELEASED	☐	MSR_REPLACEMENT_RELEASED	XFELD	CHAR	1	0	Release Subsequent Delivery Free of Charge
121	REFUND_RELEASED	☐	MSR_REFUNDING_RELEASED	XFELD	CHAR	1	0	Release Credit Memo Request
122	REPLACE_REQUEST	☐	MSR_REPLACEMENT_REQUESTED	XFELD	CHAR	1	0	Replacement Material from Vendor Requested
123	REPLACE_MATNRTXT	☐	MAKTX	TEXT40	CHAR	40	0	Material description
124	REPLACEMENT_STATUS	☐	MSR_REPLACEMENT_STATUS	MSR_INSP_LDM_STATUS	CHAR	1	0	Replacement Status UI
125	REFUNDING_STATUS	☐	MSR_REFUNDING_STATUS	MSR_INSP_LDM_STATUS	CHAR	1	0	Refunding Status UI
126	ATP_STATUS	☐	MSR_ATP_STATUS	MSR_ATP_STATUS	CHAR	1	0	ATP Status
127	PAYING_PLANT_TXT	☐	NAME1	TEXT30	CHAR	30	0	Name
128	.INCLUDE	☐				0	0	Customer Inspection
129	CUST_INSP_CODE	☐	MSR_CUST_INSP_CODE	QCODE	CHAR	4	0	Customer Inspection Code	*
130	CUST_INSP_COMM	☐	MSR_CUST_INSP_COMMENT	TEXT132	CHAR	132	0	Customer Inspection Comment
131	CUST_COMMENT_AVAILABLE	☐	MSR_INSP_TEXT_AVAILABLE	FLAG	CHAR	1	0	Comment Available

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MSR_S_INSP_ITEM	ABGRU	TVAG	ABGRU
2	MSR_S_INSP_ITEM	BSGRU	TBSG	BSGRU
3	MSR_S_INSP_ITEM	CMR_UNIT	T006	MSEHI
4	MSR_S_INSP_ITEM	FUP_BLOCK	MSR_D_FUP_BLOCK	FUP_BLOCK
5	MSR_S_INSP_ITEM	IM_LGORT	T001L	LGORT
6	MSR_S_INSP_ITEM	IM_PLANT	T001W	WERKS
7	MSR_S_INSP_ITEM	NEXT_PLANT	T001W	WERKS
8	MSR_S_INSP_ITEM	NFU_CODE	MSR_I_CODE	FU_CODE
9	MSR_S_INSP_ITEM	REPLACED_UNIT	T006	MSEHI
10	MSR_S_INSP_ITEM	REPLACE_MATNR	MARA	MATNR
11	MSR_S_INSP_ITEM	REPLACE_UNIT	T006	MSEHI
12	MSR_S_INSP_ITEM	SUPPLY_PLANT	T001W	WERKS
13	MSR_S_INSP_ITEM	WERKS	T001W	WERKS

History

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