SAP SDEVI5 EBR: Inspection Scope of Insp. Lot in Deviation Analysis Table data and field list

SDEVI5 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "EBR: Inspection Scope of Insp. Lot in Deviation Analysis" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_SDEVI5 TYPE SDEVI5.

The SDEVI5 table consists of various fields, each holding specific information or linking keys about EBR: Inspection Scope of Insp. Lot in Deviation Analysis data available in SAP. These include HERKUNFT (Inspection Lot Origin), FLG_EXIST (Missing inspection lot of inspection type is deviation), FLG_VE (UD with valuation other than 'acceptance' is deviation), FLG_VE_LT (Long Text on Usage Decision is Deviation)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

SDEVI5 structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)


SAP SDEVI5 structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the SDEVI5 table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
DEVPROFDeviation profile for batch records DEVPROFCHAR8DEVPROF
HERKUNFTInspection Lot Origin QHERKCHAR2Assigned to domainQHERKQHK
FLG_EXISTMissing inspection lot of inspection type is deviation FLG_EXISTCHAR1FLAG
FLG_VEUD with valuation other than 'acceptance' is deviation FLG_VECHAR1FLAG
FLG_VE_LTLong Text on Usage Decision is Deviation FLG_VE_LTCHAR1FLAG
FLG_PEInsp. Result Valuation other than 'Acceptance' is Deviation FLG_PECHAR1FLAG
FLG_PE_DSComment on Dig. Signature for Inspection Result is Deviation FLG_PE_DSCHAR1FLAG
FLG_PE_LTLong Text for Inspection Result is Deviation FLG_PE_LTCHAR1FLAG
FLG_FE_PLDefects Found for Inspection Lot is Deviation FLG_FE_PLCHAR1FLAG
FLG_FE_MEDefects Found for Inspection Characteristic is Deviation FLG_FE_MECHAR1FLAG
FLG_FE_VGDefects Found for Operation/Phase is Deviation FLG_FE_VGCHAR1FLAG

Key field Non-key field



How do I retrieve data from SAP structure SDEVI5 using ABAP code?

As SDEVI5 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on SDEVI5 as there is no data to select.

How to access SAP table SDEVI5

Within an ECC or HANA version of SAP you can also view further information about SDEVI5 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).