MBQSSZ SAP (Assignment table for the item number) Structure details

Dictionary Type: Structure
Description: Assignment table for the item number




ABAP Code to SELECT data from MBQSSZ
Related tables to MBQSSZ
Access table MBQSSZ




Structure field list including key, data, relationships and ABAP select examples

MBQSSZ is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Assignment table for the item number" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_MBQSSZ TYPE MBQSSZ.

The MBQSSZ table consists of various fields, each holding specific information or linking keys about Assignment table for the item number data available in SAP. These include XZGVH (Processing of certificate in procurement active), ZEILEALT (Item in Material Document), ZEILENEU (Item in Material Document), LGNUM (Warehouse Number / Warehouse Complex).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)


SAP MBQSSZ structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
KZPLOSInspection Lot is Created Automatically QSTAT01CHAR1QKZ
XZGVHProcessing of certificate in procurement active XZGVHCHAR1QXZGVH
ZEILEALTItem in Material Document MBLPONUMC4MBLPOPOS
ZEILENEUItem in Material Document MBLPONUMC4MBLPOPOS
LGNUMWarehouse Number / Warehouse Complex LGNUMCHAR3T300LGNUMLGN
LGTYPStorage Type LGTYPCHAR3T301LGTYPLGTH_T301
LGPLAStorage Bin LGPLACHAR10LAGPLGPLALGPLAG1
CHARGBatch Number CHARG_DCHAR10MCH1CHARGCHA
LGORTStorage Location LGORT_DCHAR4T001LLGORTLAG
EBELNPurchasing Document Number EBELNCHAR10EKKOALPHAEBELNBESMEKK_C
EBELPItem Number of Purchasing Document EBELPNUMC5EKPOEBELPBSP
LICHNVendor Batch Number LICHNCHAR15LICHN
LFSNRNumber of External Delivery Note LFSNR1CHAR16XBLNR1

Key field Non-key field



How do I retrieve data from SAP structure MBQSSZ using ABAP code?

As MBQSSZ is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on MBQSSZ as there is no data to select.

How to access SAP table MBQSSZ

Within an ECC or HANA version of SAP you can also view further information about MBQSSZ and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!