SAP ABAP Table BAPI2045D_IL0 (General Data for Inspection Lot)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ QL (Package) QM inspection lots

Basic Data

Table Category	INTTAB	Structure
Structure	BAPI2045D_IL0	Table Relationship Diagram
Short Description	General Data for Inspection Lot

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	INSPLOT	☐	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number	QALS
2	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
3	INSP_TYPE	☐	QPART	QPART	CHAR	8	0	Inspection Type	TQ30
4	INSPLOT_ORIGIN	☐	QHERK	QHERK	CHAR	2	0	Inspection Lot Origin	*
5	OBJECT_NO	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
6	STAT_PROF	☐	J_STSMA	J_STSMA	CHAR	8	0	Status Profile	TJ20
7	QM_AUTHGRP	☐	QMATAUTH	QMATAUTH	CHAR	6	0	Material authorization group for activities in QM	TQ01B
8	IND_INSPLOT_CREATED_AUTOMATIC	☐	QSTAT01	QKZ	CHAR	1	0	Inspection Lot is Created Automatically
9	IND_PARTIALLOTS_EXIST	☐	QKZQALT	QKZ	CHAR	1	0	Partial Lots Exist
10	IND_DATARECORD_MODIFIED	☐	QUSER_EXIT	QKZ	CHAR	1	0	Data Record Was Changed Using Customer Exit
11	IND_INSPPOINTS	☐	QKZFERTPRF	QKZ	CHAR	1	0	Inspection with Inspection Points
12	IND_AUTOMATIC_UD	☐	QAUTO_VE	QKZ	CHAR	1	0	Automatic Usage Decision Planned
13	IND_SOURCE_INSPECTION	☐	QABNAHMPRF	BSTYP	CHAR	1	0	Source Inspection
14	IND_SPEC_CONFIG	☐	QCONF	QKZ	CHAR	1	0	Inspection Specifications from Configuration
15	IND_SPEC_BATCH	☐	QCHARG	QKZ	CHAR	1	0	Inspection Specifications from Batch Determination
16	IND_DOCU_REQUIRED	☐	QSTAT19	QKZ	CHAR	1	0	Documentation Required for Inspection Lot
17	IND_TASK_LIST_REQUIRED	☐	QSTAT20	QKZ	CHAR	1	0	Inspection Plan Required
18	IND_MANUAL_SAMPLE	☐	QSTAT21	QKZ	CHAR	1	0	Enter Sample Manually
19	IND_SPEC_MATSPEC	☐	QSPEZUEBER	QKZ	CHAR	1	0	Inspect with Material Specification
20	IND_INSPLOT_APPROVAL	☐	QKZGENLOS	QKZGENLOS	CHAR	1	0	Inspection Lot Approval
21	IND_DIG_SIGN_RESULTS_REC	☐	SIG_IL_RES	SIG_IL_RES	CHAR	1	0	Digital Signature for Insp. Lot in Results Recording
22	IND_DIG_SIGN_USAGE_DECISION	☐	SIG_IL_USA	SIG_IL_USA	CHAR	1	0	Digital Signature for Insp. Lot when Usage Decision Made
23	IND_DIG_SIGN_SAMPLE_DRAWING	☐	SIG_IL_SDR	SIG_IL_SDR	CHAR	1	0	Digital Signature for Confirmation of Phys.-Sample Drawing
24	IND_BATCH_RECORD_REQUIRED	☐	XGCHP	XFELD	CHAR	1	0	Indicator: Approved batch record required
25	IND_MAN_SAMPLE_CALCULATION	☐	QSTAT31	QKZ	CHAR	1	0	Trigger Sample Calculation Manually
26	IND_DYN_MODIF_MATERIAL	☐	QSTAT45	QKZ	CHAR	1	0	Material as Dynamic Modification Criterion
27	IND_DYN_MODIF_VENDOR	☐	QSTAT46	QKZ	CHAR	1	0	Vendor as Dynamic Modification Criterion
28	IND_DYN_MODIF_MANUFAC	☐	QSTAT47	QKZ	CHAR	1	0	Manufacturer as Dynamic Modification Criterion
29	IND_DYN_MODIF_CUSTOMER	☐	QSTAT48	QKZ	CHAR	1	0	Customer as Dynamic Modification Criterion
30	IND_SKIPS_ALLOWED	☐	QDYN	QKZ	CHAR	1	0	Skips Allowed
31	IND_100_PERCENT_INSPECTION	☐	QHPZ	QKZ	CHAR	1	0	100% Inspection
32	IND_SINGLE_UNITS_POSSIBLE	☐	QEINZ	QKZ	CHAR	1	0	Serial Number Management Possible
33	SERNO_PROF	☐	SERAIL	SERAIL	CHAR	4	0	Serial Number Profile	T377P
34	NO_OF_SERIAL_NUMBERS	☐	ANZSN	INT4	INT4	10	0	Number of serial numbers
35	IND_UNITS_EXT_NUMBERING	☐	QEXTNUM	QEXTNUM	CHAR	1	0	External Numbering of Units to be Inspected	TQ12
36	DYN_MODIF_LEVEL	☐	QDYNHEAD	QDYNHEAD	CHAR	1	0	Level at Which Dynamic Modification Parameters Are Defined	TQ39A
37	SAMPLING_PROCEDURE	☐	QSTPRVER	QSTPRVER	CHAR	8	0	Sampling Procedure	QDSV
38	DYN_MODIF_RULE	☐	QDYNREGEL	QDYNREGEL	CHAR	3	0	Dynamic Modification Rule	QDDR
39	DYN_MODIF_MOMENT	☐	QDYNTIME	QDYNTIME	CHAR	1	0	Time of Dynamic Modification in Inspection Lot
40	INSPECTION_STAGE	☐	QPRSTUFE	QPRSTUFE	NUMC	4	0	Inspection Stage	QDPS
41	INSPECTION_SEVERITY	☐	QPRSCHAERF	QPRSCHAERF	NUMC	3	0	Inspection Severity	QDEP
42	ORIGINATED_ON_DATE	☐	QENTST	DATUM	DATS	8	0	Date of Lot Creation
43	ORIGINATED_AT_TIME	☐	QENTSTZEIT	QZEIT	TIMS	6	0	Time of Lot Creation
44	CREATED_BY_USER	☐	QERSTELLER	QAENDERER	CHAR	12	0	Name of User Who Created the Data Record
45	CREATED_ON_DATE	☐	QDATUMERST	DATUM	DATS	8	0	Date on Which the Data Record Was Created
46	CREATED_AT_TIME	☐	QERSTEZEIT	QZEIT	TIMS	6	0	Time of Lot Creation
47	CHANGED_BY_USER	☐	QAENDERER	QAENDERER	CHAR	12	0	Name of User who Most Recently Changed the Data Record
48	CHANGED_ON_DATE	☐	QDATUMAEND	DATUM	DATS	8	0	Date on Which Data Record Was Changed
49	CHANGED_AT_TIME	☐	QAENDEZEIT	QZEIT	TIMS	6	0	Time of Lot Change
50	INSPECTION_STARTS_ON_DATE	☐	QPRSTART	DATUM	DATS	8	0	Inspection Start Date
51	INSPECTION_STARTS_AT_TIME	☐	QSTARTZEIT	QZEIT	TIMS	6	0	Inspection Start Time
52	INSPECTION_ENDS_ON_DATE	☐	QPRENDE	DATUM	DATS	8	0	End Date of the Inspection
53	INSPECTION_ENDS_AT_TIME	☐	QENDEZEIT	QZEIT	TIMS	6	0	Inspection End Time
54	INSPPOINT_DESCRIPTION_KEY	☐	QSLWBEZ	QSLWBEZ	CHAR	3	0	Identification for the Inspection Point Field Combination	TQ79
55	INSPPOINT_TYPE	☐	QPPKTTYP	QPPKTTYP	CHAR	1	0	Inspection Point Type
56	INSPPOINT_PARTIALLOT_ASSGNMT	☐	QPPKZTLZU	QPPKZTLZU	CHAR	1	0	Partial Lot Assignment in an Inspection During Production
57	SAMPLE_DRAWING_PROCEDURE	☐	QPRZIEHVER	QPRZIEHVER	CHAR	8	0	Sample-Drawing Procedure	QPRVK
58	SAMPLE_DRAWING_PROC_VERSION	☐	QVERSNPRZV	QVERSNR	CHAR	6	0	Version No. of the Sample-Drawing Procedure
59	IND_PHYS_SAMPLE_CONFIRM_REQD	☐	QKZQUIT	QKZ	CHAR	1	0	Confirmation Required for Physical-Sample Drawing
60	ORDERID	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
61	RUNSCHD_HD	☐	SA_AUFNR	SA_AUFNR	CHAR	12	0	Run schedule header number	SAFK
62	CUSTOMER	☐	QKUNWE	KUNNR	CHAR	10	0	Customer (Ship-To Party)	KNA1
63	VENDOR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
64	MANUFACTURER	☐	QLIFNR	LIFNR	CHAR	10	0	Number of Manufacturer	LFA1
65	IND_MATPARTNO_MGNT_ACTIVE	☐	QHERST	QKZ	CHAR	1	0	Manufacturer Part No. Processing Active
66	MPN_MATERIAL	☐	EMATN	MATNR	CHAR	18	0	Material number corresponding to manufacturer part number	MARA
67	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
68	REV_LEV	☐	REVLV	REVLV	CHAR	2	0	Revision level
69	IND_BATCH_MGNT	☐	XCHPF	XFELD	CHAR	1	0	Batch management requirement indicator
70	BATCH	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
71	BATCH_STGE_LOC	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
72	PURCH_ORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
73	PO_NUMBER	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
74	PO_ITEM	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
75	DELIV_NOTE_SALES_ORD	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
76	DELIV_NOTE_S_ORD_ITEM	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
77	DELIV_NOTE_DELIV_NUMB	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	VBUK
78	DELIV_NOTE_DELIV_ITEM	☐	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	VBUP
79	DELIV_NOTE_DELIV_CATEGORY	☐	QABRVW	ABRVW	CHAR	3	0	Delivery Category	TVLV
80	DELIV_NOTE_ROUTE	☐	ROUTE	ROUTE	CHAR	6	0	Route	TVRO
81	DELIV_NOTE_DEST_COUNTRY	☐	LLAND	LAND1	CHAR	3	0	Destination Country	T005
82	DELIV_NOTE_DEST_COUNTRY_ISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
83	DELIV_NOTE_SOLD_TO	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
84	DELIV_NOTE_SALESORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
85	DELIV_NOTE_CUST_MATERIAL	☐	KDMAT	IDNEX	CHAR	35	0	Material belonging to the customer
86	LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
87	LANGU_ISO	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
88	SHORT_TEXT	☐	QKURZTEXT	QKURZTEXT	CHAR	40	0	Short Text
89	IND_INSPLOT_LONG_TEXT	☐	QLTEXTLOS	QKZ	CHAR	1	0	Long Text Exists For Inspection Lot
90	TXT_INSP_OBJECT	☐	QKTEXTOBJ	QKURZTEXT	CHAR	40	0	Short Text for Inspection Object
91	NO_OF_ADDITIONAL_INSPCHAR	☐	QZUSMKZHL	INT2	INT2	5	0	Number of Characteristics Recorded Additionally
92	NO_OF_OPEN_SHORTTERM_INSPCHAR	☐	QOFFENLZMK	INT2	INT2	5	0	Number of Outstanding Short-Term Chars Which Require Conf.
93	NO_OF_OPEN_LONGTERM_INSPCHAR	☐	QOFFELZMK	INT2	INT2	5	0	Number of Outstanding Long-Term Chars Which Require Conf.
94	INSPLOT_SIZE	☐	QLOSMENGE	QMENGEPLOS	QUAN	13	3	Inspection Lot Quantity
95	INSPLOT_BASE_UOM	☐	QLOSMENGEH	MEINS	UNIT	3	0	Base Unit of Measure for The Inspection Lot Quantity	T006
96	INSPLOT_BASE_UOM_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	T006I
97	NO_OF_CONTAINERS	☐	QANZGEB	QGEBPLOS	QUAN	6	3	QM - No. of Containers
98	INSPLOT_CONTAINER_UOM	☐	QGEBEH	MEINS	UNIT	3	0	Lot Container	T006
99	INSPLOT_CONTAINER_UOM_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	T006I
100	SAMPLE_SIZE	☐	QGESTICH	QMENGEPLOS	QUAN	13	3	Sample Size
101	SAMPLE_BASE_UOM	☐	QPROBEMGEH	MEINS	UNIT	3	0	Base Unit of Measure for the Sample Unit	T006
102	SAMPLE_BASE_UOM_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	T006I
103	SAMPLE_QTY_LONGTERM_INSPCHAR	☐	QLMENGELZ	QMENGEPLOS	QUAN	13	3	Sample Quantity for Long-Term Characteristics
104	SAMPLE_QTY_ACTUALLY_INSPECTED	☐	QLMENGEPR	QMENGEPLOS	QUAN	13	3	Quantity Actually Inspected
105	SAMPLE_QTY_DESTROYED	☐	QLMENGEZER	QMENGEPLOS	QUAN	13	3	Quantity Destroyed During Inspection
106	SAMPLE_QTY_DEFECTIVE	☐	QLMENGESCH	QMENGEPLOS	QUAN	13	3	Defective Quantity in Inspected Quantity
107	IND_UD_LOGS	☐	QLTEXTKZBB	QKZ	CHAR	1	0	Logs Exist for Usage Decision
108	INSPLOT_FRACTION_NONCONFORMING	☐	QAUSANTEIL	QFLTP16	FLTP	16	16	Share of Scrap in Inspection Lot
109	QUAL_SCORE_PROCEDURE	☐	QKZVERF	QKZVERF	CHAR	2	0	Procedure for Calculating Quality Score	TQ06
110	ALLOWED_FRACTION_NONCONFORMING	☐	QPMATLOS	QPMATLOS	FLTP	16	16	Allowed Share of Scrap
111	REF_INSPLOT	☐	QLOS_REF	QPLOS	NUMC	12	0	Inspection Lot Number Which Is Referenced	QALS
112	VERSION	☐	VERID	VERID	CHAR	4	0	Production Version	MKAL
113	SCHED_LINE	☐	EETEN	EETEN	NUMC	4	0	Delivery Schedule Line Counter	EKET
114	MATERIAL_EXTERNAL	☐	MGV_MATERIAL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for MATERIAL Field
115	MATERIAL_GUID	☐	MGV_MATERIAL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for MATERIAL Field
116	MATERIAL_VERSION	☐	MGV_MATERIAL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for MATERIAL Field
117	MPN_MATERIAL_EXTERNAL	☐	MGV_MPN_MATERIAL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for MPN_MATERIAL Field
118	MPN_MATERIAL_GUID	☐	MGV_MPN_MATERIAL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for MPN_MATERIAL Field
119	MPN_MATERIAL_VERSION	☐	MGV_MPN_MATERIAL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for MPN_MATERIAL Field

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BAPI2045D_IL0	BATCH	MCH1	CHARG
2	BAPI2045D_IL0	BATCH_STGE_LOC	T001L	LGORT
3	BAPI2045D_IL0	CUSTOMER	KNA1	KUNNR
4	BAPI2045D_IL0	DELIV_NOTE_DELIV_CATEGORY	TVLV	ABRVW
5	BAPI2045D_IL0	DELIV_NOTE_DELIV_ITEM	VBUP	POSNR
6	BAPI2045D_IL0	DELIV_NOTE_DELIV_NUMB	VBUK	VBELN
7	BAPI2045D_IL0	DELIV_NOTE_DEST_COUNTRY	T005	LAND1
8	BAPI2045D_IL0	DELIV_NOTE_ROUTE	TVRO	ROUTE
9	BAPI2045D_IL0	DELIV_NOTE_SALESORG	TVKO	VKORG
10	BAPI2045D_IL0	DELIV_NOTE_SALES_ORD	VBUK	VBELN
11	BAPI2045D_IL0	DELIV_NOTE_SOLD_TO	KNA1	KUNNR
12	BAPI2045D_IL0	DYN_MODIF_LEVEL	TQ39A	DYNLEVEL
13	BAPI2045D_IL0	DYN_MODIF_RULE	QDDR	DYNREGEL
14	BAPI2045D_IL0	IND_UNITS_EXT_NUMBERING	TQ12	EXTNUM
15	BAPI2045D_IL0	INSPECTION_SEVERITY	QDEP	PRSCHAERFE
16	BAPI2045D_IL0	INSPECTION_STAGE	QDPS	PRSTUFE
17	BAPI2045D_IL0	INSPLOT	QALS	PRUEFLOS
18	BAPI2045D_IL0	INSPLOT_BASE_UOM	T006	MSEHI
19	BAPI2045D_IL0	INSPLOT_BASE_UOM_ISO	T006I	ISOCODE
20	BAPI2045D_IL0	INSPLOT_CONTAINER_UOM	T006	MSEHI
21	BAPI2045D_IL0	INSPLOT_CONTAINER_UOM_ISO	T006I	ISOCODE
22	BAPI2045D_IL0	INSPPOINT_DESCRIPTION_KEY	TQ79	SLWBEZ
23	BAPI2045D_IL0	INSP_TYPE	TQ30	ART
24	BAPI2045D_IL0	LANGU	T002	SPRAS
25	BAPI2045D_IL0	MANUFACTURER	LFA1	LIFNR
26	BAPI2045D_IL0	MATERIAL	MARA	MATNR
27	BAPI2045D_IL0	MPN_MATERIAL	MARA	MATNR
28	BAPI2045D_IL0	OBJECT_NO	ONR00	OBJNR
29	BAPI2045D_IL0	ORDERID	AUFK	AUFNR
30	BAPI2045D_IL0	PLANT	T001W	WERKS
31	BAPI2045D_IL0	PO_ITEM	EKPO	EBELP
32	BAPI2045D_IL0	PO_NUMBER	EKKO	EBELN
33	BAPI2045D_IL0	PURCH_ORG	T024E	EKORG
34	BAPI2045D_IL0	QM_AUTHGRP	TQ01B	QMATAUTH
35	BAPI2045D_IL0	QUAL_SCORE_PROCEDURE	TQ06	QKZVERF
36	BAPI2045D_IL0	REF_INSPLOT	QALS	PRUEFLOS
37	BAPI2045D_IL0	RUNSCHD_HD	SAFK	AUFNR
38	BAPI2045D_IL0	SAMPLE_BASE_UOM	T006	MSEHI
39	BAPI2045D_IL0	SAMPLE_BASE_UOM_ISO	T006I	ISOCODE
40	BAPI2045D_IL0	SAMPLE_DRAWING_PROCEDURE	QPRVK	PRZIEHVERF
41	BAPI2045D_IL0	SAMPLING_PROCEDURE	QDSV	STICHPRVER
42	BAPI2045D_IL0	SCHED_LINE	EKET	ETENR
43	BAPI2045D_IL0	SERNO_PROF	T377P	SERAIL
44	BAPI2045D_IL0	STAT_PROF	TJ20	STSMA
45	BAPI2045D_IL0	VENDOR	LFA1	LIFNR
46	BAPI2045D_IL0	VERSION	MKAL	VERID

History

Last changed by/on	SAP	20140121
SAP Release Created in