SAP ABAP Table MBQSS (Interface between QM and goods receipt posting)

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	MBQSS	Table Relationship Diagram
Short Description	Interface between QM and goods receipt posting

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	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
2	INSMK	☐	QVINSMK	QKZ	CHAR	1	0	Quantity Is or Was in Inspection Stock
3	KZWES	☐	KZWES	KZWES	CHAR	1	0	GR blocked stock
4	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
5	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
6	EMATN	☐	EMATNR	MATNR	CHAR	18	0	Material number	*
7	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
8	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
9	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
10	ZEILE	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
11	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	T156
12	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
13	ERFMG	☐	ERFMG	MENG13	QUAN	13	3	Quantity in unit of entry
14	ERFME	☐	ERFME	MEINS	UNIT	3	0	Unit of entry	T006
15	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
16	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
17	ANZGEB	☐	QANZGEB	QGEBPLOS	QUAN	6	3	QM - No. of Containers
18	GEBEH	☐	QGEBEH	MEINS	UNIT	3	0	Lot Container	T006
19	KZBEW	☐	KZBEW	KZBEW	CHAR	1	0	Movement Indicator
20	BLART	☐	BLART	BLART	CHAR	2	0	Document type	T003
21	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
22	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
23	QSSHK	☐	QHERK	QHERK	CHAR	2	0	Inspection Lot Origin	*
24	MENGU	☐	MENGU	XFELD	CHAR	1	0	Quantity Updating in Material Master Record
25	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
26	MAT_KDAUF	☐	MAT_KDAUF	VBELN	CHAR	10	0	Sales order number of valuated sales order stock	VBUK
27	MAT_KDPOS	☐	MAT_KDPOS	NUM06	NUMC	6	0	Sales Order Item of Valuated Sales Order Stock
28	MAT_PSPNR	☐	MAT_PSPNR	PS_POSNR	NUMC	8	0	Valuated customer stock WBS element	PRPS
29	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
30	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
31	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	T163
32	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
33	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
34	ANLN2	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
35	KONT_KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	*
36	KONT_KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
37	KONT_PSPNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
38	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	AUFK
39	APLZL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
40	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
41	KSTRG	☐	KSTRG	KSTRG	CHAR	12	0	Cost Object	CKPH
42	PAOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
43	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
44	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
45	KONTO	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	SKA1
46	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
47	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
48	SPERQ	☐	QSSPUR	QSSPUR	CHAR	8	0	Control Key for Quality Management in Procurement	TQ08
49	SSQSS	☐	QSSPUR	QSSPUR	CHAR	8	0	Control Key for Quality Management in Procurement	TQ08
50	ZGTYP	☐	QZGTYP	QZGTYP	CHAR	4	0	Certificate Type	TQ05
51	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
52	ABNAHMPRF	☐	QABNAHMPRF	BSTYP	CHAR	1	0	Source Inspection
53	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
54	XCHPF	☐	XCHPF	XFELD	CHAR	1	0	Batch management requirement indicator
55	DABRZ	☐	DABRBEZ	DDAT	DATS	8	0	Reference date for settlement
56	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
57	LICHN	☐	LICHN	LICHN	CHAR	15	0	Vendor Batch Number
58	AUFPS	☐	RSPOS	RSPOS	NUMC	4	0	Item Number of Reservation / Dependent Requirements

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MBQSS	ANLN1	ANLH	ANLN1
2	MBQSS	ANLN2	ANLA	ANLN2
3	MBQSS	AUFNR	AUFK	AUFNR
4	MBQSS	BLART	T003	BLART
5	MBQSS	BWART	T156	BWART
6	MBQSS	CHARG	MCH1	CHARG
7	MBQSS	EBELN	EKKO	EBELN
8	MBQSS	EBELP	EKPO	EBELP
9	MBQSS	EKORG	T024E	EKORG
10	MBQSS	ERFME	T006	MSEHI
11	MBQSS	GEBEH	T006	MSEHI
12	MBQSS	GSBER	TGSB	GSBER
13	MBQSS	KNTTP	T163K	KNTTP
14	MBQSS	KONTO	SKA1	SAKNR
15	MBQSS	KOSTL	CSKS	KOSTL
16	MBQSS	KSTRG	CKPH	KSTRG
17	MBQSS	KUNNR	KNA1	KUNNR
18	MBQSS	LGORT	T001L	LGORT
19	MBQSS	LIFNR	LFA1	LIFNR
20	MBQSS	MATNR	MARA	MATNR
21	MBQSS	MAT_KDAUF	VBUK	VBELN
22	MBQSS	MAT_PSPNR	PRPS	PSPNR
23	MBQSS	MEINS	T006	MSEHI
24	MBQSS	NPLNR	AUFK	AUFNR
25	MBQSS	PRCTR	CEPC	PRCTR
26	MBQSS	PSTYP	T163	PSTYP
27	MBQSS	SOBKZ	T148	SOBKZ
28	MBQSS	SPERQ	TQ08	QM_PUR
29	MBQSS	SSQSS	TQ08	QM_PUR
30	MBQSS	WERKS	T001W	WERKS
31	MBQSS	ZGTYP	TQ05	ZGTYP

History

Last changed by/on	SAP	20110901
SAP Release Created in