SAP ABAP Table QALTS (Selection table of partial lots in production)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ QM-IM (Application Component) Quality Inspection
     ⤷ QLPP (Package) QM inspection points

Basic Data

Table Category	INTTAB	Structure
Structure	QALTS	Table Relationship Diagram
Short Description	Selection table of partial lots in production

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	KZSEL	☐	QKZ	QKZ	CHAR	1	0	X and Blank (Indicator)
2	.INCLUDE	☐				0	0	Partial lot
3	MANDANT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	PRUEFLOS	☐	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number	QALS
5	TEILLOS	☐	QTLOS	QTLOS	NUMC	6	0	Partial lot number	*
6	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
7	LS_POSNR	☐	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	VBUP
8	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
9	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
10	LAGORTCHRG	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
11	MENGENEINH	☐	QLOSMENGEH	MEINS	UNIT	3	0	Base Unit of Measure for The Inspection Lot Quantity	T006
12	MENGE	☐	QMENGETLOS	MENG13	QUAN	13	3	Partial lot quantity
13	MENGEIST	☐	QLMENGEIST	QMENGEPLOS	QUAN	13	3	Actual Lot Quantity
14	KTEXTTLOS	☐	QTXTTL	QKURZTEXT	CHAR	40	0	Short Text for Partial Lot
15	LTEXTKZ	☐	QLTEXTTLOS	QKZ	CHAR	1	0	ID: Long text exists for partial lot
16	PRUEFER	☐	QPRUEFER	QPRUEFER	CHAR	12	0	Name of the Inspector
17	ENSTEHDAT	☐	QENTST	DATUM	DATS	8	0	Date of Lot Creation
18	ENSTEHZEIT	☐	QZEITENSTE	QZEIT	TIMS	6	0	Time at which partial lot was created
19	ERSTELLER	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
20	ERSTELDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
21	ERSTELZEIT	☐	QZEITERSTL	QZEIT	TIMS	6	0	Time at which data record was created
22	AENDERER	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
23	AENDERDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
24	AENDERZEIT	☐	QZEITAEND	QZEIT	TIMS	6	0	Time at which data record was last changed
25	VETEXT	☐	QKURZTEXT	QKURZTEXT	CHAR	40	0	Short Text

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	QALTS	CHARG	MCH1	CHARG	KEY	1	CN
2	QALTS	LAGORTCHRG	T001L	LGORT
3	QALTS	LS_POSNR	VBUP	POSNR	REF	C	CN
4	QALTS	MANDANT	T000	MANDT	KEY	1	CN
5	QALTS	MATNR	MARA	MATNR	REF	C	CN
6	QALTS	MENGENEINH	T006	MSEHI	KEY	1	CN
7	QALTS	OBJNR	ONR00	OBJNR	REF	C	C
8	QALTS	PRUEFLOS	QALS	PRUEFLOS	KEY	1	CN

History

Last changed by/on	SAP	19980706
SAP Release Created in