SAP ABAP Table V_QIBP_QALS_SEL (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_QIBP_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	STAT02	☐	QKZQALT	QKZ	CHAR	1	0	Partial Lots Exist
8	STAT07	☐	QKZFERTPRF	QKZ	CHAR	1	0	Inspection with Inspection Points
9	STAT35	☐	QSTAT35	QKZ	CHAR	1	0	Usage Decision Has Been Made
10	KZSKIPLOT	☐	QKZSKIPLOT	QKZ	CHAR	1	0	Lot Skipped
11	ENSTEHDAT	☐	QENTST	DATUM	DATS	8	0	Date of Lot Creation
12	ERSTELLER	☐	QERSTELLER	QAENDERER	CHAR	12	0	Name of User Who Created the Data Record
13	ERSTELDAT	☐	QDATUMERST	DATUM	DATS	8	0	Date on Which the Data Record Was Created
14	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
15	VERID	☐	VERID	VERID	CHAR	4	0	Production Version	MKAL
16	SA_AUFNR	☐	SA_AUFNR	SA_AUFNR	CHAR	12	0	Run schedule header number	SAFK
17	KUNNR	☐	QKUNWE	KUNNR	CHAR	10	0	Customer (Ship-To Party)	KNA1
18	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
19	HERSTELLER	☐	QLIFNR	LIFNR	CHAR	10	0	Number of Manufacturer	LFA1
20	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
21	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
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_QIBP_QALS_SEL	ART	TQ30	ART	KEY	1	CN
2	V_QIBP_QALS_SEL	AUFNR	AUFK	AUFNR	REF	C	CN
3	V_QIBP_QALS_SEL	CHARG	MCH1	CHARG	REF	C	CN
4	V_QIBP_QALS_SEL	EBELN	EKKO	EBELN	REF	C	CN
5	V_QIBP_QALS_SEL	EBELP	EKPO	EBELP	REF	C	CN
6	V_QIBP_QALS_SEL	HERKUNFT	TQ31	HERKUNFT	KEY	1	CN
7	V_QIBP_QALS_SEL	HERSTELLER	LFA1	LIFNR	REF	C	CN
8	V_QIBP_QALS_SEL	KUNNR	KNA1	KUNNR	REF	C	CN
9	V_QIBP_QALS_SEL	LIFNR	LFA1	LIFNR	REF	C	CN
10	V_QIBP_QALS_SEL	LS_POSNR	VBUP	POSNR	REF	C	CN
11	V_QIBP_QALS_SEL	LS_VBELN	VBUK	VBELN	REF	C	CN
12	V_QIBP_QALS_SEL	MANDANT	T000	MANDT	KEY	1	CN
13	V_QIBP_QALS_SEL	MATNR	MARA	MATNR	REF	C	CN
14	V_QIBP_QALS_SEL	OBJNR	ONR00	OBJNR	KEY	1	C
15	V_QIBP_QALS_SEL	SA_AUFNR	SAFK	AUFNR
16	V_QIBP_QALS_SEL	VERID	MKAL	VERID
17	V_QIBP_QALS_SEL	WERK	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in