SAP ABAP Table /SPE/INSPECRESH_LAMA (Inspection Outcome: Header including long material number)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO-SPM-RET (Application Component) Complaints and Returns
     ⤷ /SPE/RET_INSPECTIONS (Package) Service Parts Management Returns Process Inspection Outcome

Basic Data

Table Category	INTTAB	Structure
Structure	/SPE/INSPECRESH_LAMA	Table Relationship Diagram
Short Description	Inspection Outcome: Header including long material number

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	.INCLUDE	☐				0	0	Inspection Outcome: Header
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	INSPEC_NO	☐	/SPE/INSPEC_NO	/SPE/INSPEC_NO	CHAR	12	0	Inspection Outcome number
4	RMA_NUMBER	☐	/SPE/RET_RMA	/SPE/RET_RMA	CHAR	20	0	Return Material Authorization Number
5	PUBLSTATUS	☐	/SPE/INSP_PUBL_STAT	/SPE/INSP_PUBL_STAT	CHAR	1	0	Inspection Outcome: Publishing Status
6	HUSTATUS	☐	/SPE/INSP_HU_STAT	/SPE/INSP_HU_STAT	CHAR	1	0	Inspection Outcome: Confirmation status of handling units
7	DELIV_NUMB	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	*
8	DELIV_ITEM	☐	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	*
9	HU_EXID	☐	EXIDV	EXIDV	CHAR	20	0	External Handling Unit Identification
10	WHSENUMBER	☐	LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex	T300
11	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
12	STGE_LOC	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
13	TZONE	☐	TZNZONE	TZNZONE	CHAR	6	0	Time Zone	TTZZ
14	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
15	DELFLAG	☐	/SPE/LSKENZ	/SPE/LSKENZ	CHAR	1	0	Inspection Outcome: Delete flag
16	.INCLUDE	☐				0	0	Inspection Outcome: Administration fields(header)
17	CREATED_ON	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
18	CREATED_BY	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
19	CHANGED_ON	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
20	CHANGED_BY	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
21	.INCLUDE	☐				0	0	Multistep Returns - Additional Data for Inspection Header
22	MSR_ID	☐	MSR_PROCESS_ID	MSR_PROCESS_ID	CHAR	10	0	Process Identification Number
23	REF_DOC	☐	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	REF_DOC_TYPE	☐	MSR_DOC_TYPE	MSR_DOC_TYPE	CHAR	2	0	Document Type
26	INSP_VENDOR	☐	MSR_INSP_VENDOR	LIFNR	CHAR	10	0	Inspecting Vendor	*
27	AT_CUSTOMER_SITE	☐	MSR_AT_CUSTOMER_SITE	XFELD	CHAR	1	0	Inspection at Customer Site
28	INSP_CANCELLED	☐	MSR_INSP_CANCELLED	FLAG	CHAR	1	0	Inspection Cancelled
29	FUP_BLOCK	☐	MSR_INSP_FUP_BLOCK	MSR_INSP_FUP_BLOCK	CHAR	4	0	Block for Follow-Up Activities	*
30	.INCLUDE	☐				0	0	Inspection Outcome: Fields for long material number
31	MATNR_EXT	☐	MGV_MATERIAL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for MATERIAL Field
32	MATNR_VERS	☐	MGV_MATERIAL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for MATERIAL Field
33	MATNR_GUID	☐	MGV_MATERIAL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for MATERIAL Field

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/SPE/INSPECRESH_LAMA	MANDT	T000	MANDT	KEY	1	CN
2	/SPE/INSPECRESH_LAMA	TZONE	TTZZ	TZONE	REF	1	CN
3	/SPE/INSPECRESH_LAMA	WHSENUMBER	T300	LGNUM	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in