SAP ABAP Table V_QALS_SEL (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_QALS_SEL	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster	QALS
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	MANDANT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	PRUEFLOS	☑	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number
3	WERK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
4	ART	☐	QPART	QPART	CHAR	8	0	Inspection Type	TQ30
5	HERKUNFT	☐	QHERK	QHERK	CHAR	2	0	Inspection Lot Origin	TQ31
6	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
7	OBTYP	☐	J_OBTYP	J_OBTYP	CHAR	3	0	Object Category	TJ03
8	STAT14	☐	QSTAT14	QKZ	CHAR	1	0	Completion of Short-Term Inspection
9	STAT35	☐	QSTAT35	QKZ	CHAR	1	0	Usage Decision Has Been Made
10	ENSTEHDAT	☐	QENTST	DATUM	DATS	8	0	Date of Lot Creation
11	ERSTELDAT	☐	QDATUMERST	DATUM	DATS	8	0	Date on Which the Data Record Was Created
12	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
13	VERID	☐	VERID	VERID	CHAR	4	0	Production Version	MKAL
14	KUNNR	☐	QKUNWE	KUNNR	CHAR	10	0	Customer (Ship-To Party)	KNA1
15	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
16	HERSTELLER	☐	QLIFNR	LIFNR	CHAR	10	0	Number of Manufacturer	LFA1
17	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
18	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
19	LAGORTCHRG	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	MCHB
20	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
21	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
22	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
23	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
24	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
25	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
26	ZEILE	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
27	LS_VBELN	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	VBUK
28	LS_POSNR	☐	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	VBUP
29	KTEXTLOS	☐	QKURZTEXT	QKURZTEXT	CHAR	40	0	Short Text
30	KTEXTMAT	☐	QKTEXTOBJ	QKURZTEXT	CHAR	40	0	Short Text for Inspection Object

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_QALS_SEL	ART	TQ30	ART	KEY	1	CN
2	V_QALS_SEL	AUFNR	AUFK	AUFNR	REF	C	CN
3	V_QALS_SEL	CHARG	MCH1	CHARG	REF	C	CN
4	V_QALS_SEL	EBELN	EKKO	EBELN	REF	C	CN
5	V_QALS_SEL	EBELP	EKPO	EBELP	REF	C	CN
6	V_QALS_SEL	EKORG	T024E	EKORG	REF	C	CN
7	V_QALS_SEL	HERKUNFT	TQ31	HERKUNFT	KEY	1	CN
8	V_QALS_SEL	HERSTELLER	LFA1	LIFNR	REF	C	CN
9	V_QALS_SEL	KUNNR	KNA1	KUNNR	REF	C	CN
10	V_QALS_SEL	LAGORTCHRG	MCHB	LGORT	REF	C	CN
11	V_QALS_SEL	LIFNR	LFA1	LIFNR	REF	C	CN
12	V_QALS_SEL	LS_POSNR	VBUP	POSNR	REF	C	CN
13	V_QALS_SEL	LS_VBELN	VBUK	VBELN	REF	C	CN
14	V_QALS_SEL	MANDANT	T000	MANDT	KEY	1	CN
15	V_QALS_SEL	MATNR	MARA	MATNR	REF	C	CN
16	V_QALS_SEL	OBJNR	ONR00	OBJNR	KEY	1	C
17	V_QALS_SEL	OBTYP	TJ03	OBTYP	KEY	1	CN
18	V_QALS_SEL	SOBKZ	T148	SOBKZ	REF	C	CN
19	V_QALS_SEL	VERID	MKAL	VERID
20	V_QALS_SEL	WERK	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in