SAP ABAP Table QAMB (QM: Link Between Inspection Lot and Material Document)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ QM-IM-UD (Application Component) Inspection Lot Completion
     ⤷ QV (Package) QM usage decision

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	QAMB	Table Relationship Diagram
Short Description	QM: Link Between Inspection Lot and Material Document

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	QALS
3	ZAEHLER	☑	Q_COUNT	Q_COUNT	NUMC	6	0	Internal Counter for DB Objects
4	TYP	☐	QAMBTYPE	QAMBTYPE	CHAR	1	0	Type of Reference Between Inspection Lot and Material Doc.
5	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document	MKPF
6	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document	MKPF
7	ZEILE	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document	MSEG
8	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
9	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	QAMB	MANDANT	T000	MANDT
2	QAMB	MBLNR	MKPF	MBLNR	KEY	1	CN
3	QAMB	MJAHR	MKPF	MJAHR	KEY	1	CN
4	QAMB	PRUEFLOS	QALS	PRUEFLOS	KEY	1	CN
5	QAMB	ZEILE	MSEG	ZEILE	REF	1	CN

History

Last changed by/on	SAP	20020219
SAP Release Created in