SAP MBQSS Table in S/4 HANA - Interface between QM and goods receipt posting
MBQSS is a standard SAP Table which is used to store Interface between QM and goods receipt posting data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the MBQSS table(ECC)
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Structure
Database Table: MBQSS
MBQSS table structure field list
Below is the full MBQSS field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
| WERKS | Plant | WERKS_D | CHAR | 4(0) | T001W | WERKS | WRK | H_T001W_C | WERKS | |
| INSMK | Quantity Is or Was in Inspection Stock | QVINSMK | CHAR | 1(0) | QKZ | |||||
| KZWES | GR Blocked Stock | KZWES | CHAR | 1(0) | KZWES | |||||
| LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10(0) | LFA1 | ALPHA | LIFNR | LIF | KRED_C | LIFNR |
| MATNR | Material Number | MATNR | CHAR | 40(0) | MARA | MATN1 | MATNR | MAT | S_MAT1 | MATNR |
| EMATN | Material number | EMATNR | CHAR | 40(0) | MATN1 | MATNR | MAT | |||
| EBELN | Purchasing Document Number | EBELN | CHAR | 10(0) | EKKO | ALPHA | EBELN | BES | MEKK_C | EBELN |
| EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5(0) | EKPO | EBELP | BSP | |||
| MBLNR | Number of Material Document | MBLNR | CHAR | 10(0) | ALPHA | BELNR | MBN | |||
| ZEILE | Item in Material Document | MBLPO | NUMC | 4(0) | MBLPO | POS | ||||
| BWART | Movement type (inventory management) | BWART | CHAR | 3(0) | T156 | BWART | BWA | |||
| LGORT | Storage location | LGORT_D | CHAR | 4(0) | T001L | LGORT | LAG | |||
| ERFMG | Quantity in unit of entry | ERFMG | QUAN | 13(3) | MENG13 | |||||
| ERFME | Unit of entry | ERFME | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
| MENGE | Quantity | MENGE_D | QUAN | 13(3) | MENG13 | |||||
| MEINS | Base Unit of Measure | MEINS | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
| ANZGEB | QM - No. of Containers | QANZGEB | QUAN | 6(3) | QGEBPLOS | |||||
| GEBEH | Lot Container | QGEBEH | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
| KZBEW | Movement Indicator | KZBEW | CHAR | 1(0) | KZBEW | |||||
| BLART | Document type | BLART | CHAR | 2(0) | T003 | BLART | BAR | |||
| BUDAT | Posting Date in the Document | BUDAT | DATS | 8(0) | DATUM | |||||
| CHARG | Batch Number | CHARG_D | CHAR | 10(0) | MCH1 | CHARG | CHA | |||
| QSSHK | Inspection Lot Origin | QHERK | CHAR | 2(0) | QHERK | QHK | ||||
| MENGU | Quantity Updating in Material Master Record | MENGU | CHAR | 1(0) | XFELD | |||||
| SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 1(0) | T148 | SOBKZ | ||||
| MAT_KDAUF | Sales order number of valuated sales order stock | MAT_KDAUF | CHAR | 10(0) | ALPHA | VBELN | AUN | |||
| MAT_KDPOS | Sales Order Item of Valuated Sales Order Stock | MAT_KDPOS | NUMC | 6(0) | NUM06 | KPO | ||||
| MAT_PSPNR | Valuated Sales Order Stock WBS Element | MAT_PSPNR | NUMC | 8(0) | PRPS | ABPSP | PS_POSNR | |||
| KZVBR | Consumption posting | KZVBR | CHAR | 1(0) | KZVBR | |||||
| KNTTP | Account Assignment Category | KNTTP | CHAR | 1(0) | T163K | KNTTP | KNT | |||
| PSTYP | Item category in purchasing document | PSTYP | CHAR | 1(0) | T163 | PSTYP | ||||
| KOSTL | Cost Center | KOSTL | CHAR | 10(0) | CSKS | ALPHA | KOSTL | KOS | ||
| ANLN1 | Main Asset Number | ANLN1 | CHAR | 12(0) | ANLH | ALPHA | ANLN1 | AN1 | ||
| ANLN2 | Asset Subnumber | ANLN2 | CHAR | 4(0) | ANLA | ALPHA | ANLN2 | AN2 | ||
| KONT_KDAUF | Sales Order Number | KDAUF | CHAR | 10(0) | ALPHA | VBELN | AUN | |||
| KONT_KDPOS | Item number in Sales Order | KDPOS | NUMC | 6(0) | NUM06 | KPO | ||||
| KONT_PSPNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8(0) | ABPSP | PS_POSNR | ||||
| NPLNR | Network Number for Account Assignment | NPLNR | CHAR | 12(0) | AUFK | ALPHA | AUFNR | NET | ||
| APLZL | Internal counter | CIM_COUNT | NUMC | 8(0) | CIM_COUNT | |||||
| IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8(0) | IMKEY | IMKEY | ||||
| KSTRG | Cost Object | KSTRG | CHAR | 12(0) | CKPH | KSTRG | KTR | |||
| PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10(0) | RKEOBJNR | |||||
| PRCTR | Profit Center | PRCTR | CHAR | 10(0) | CEPC | ALPHA | PRCTR | PRC | PRCTR_EMPTY | PRCTR |
| GSBER | Business Area | GSBER | CHAR | 4(0) | TGSB | GSBER | GSB | |||
| KONTO | G/L Account Number | SAKNR | CHAR | 10(0) | SKA1 | ALPHA | SAKNR | SAK | C_SAKNR | SAKNR |
| AUFNR | Order Number | AUFNR | CHAR | 12(0) | AUFK | ALPHA | AUFNR | ANR | ||
| EKORG | Purchasing organization | EKORG | CHAR | 4(0) | T024E | EKORG | EKO | |||
| SPERQ | Control Key for Quality Management in Procurement | QSSPUR | CHAR | 8(0) | TQ08 | QSSPUR | ||||
| SSQSS | Control Key for Quality Management in Procurement | QSSPUR | CHAR | 8(0) | TQ08 | QSSPUR | ||||
| ZGTYP | Certificate Type | QZGTYP | CHAR | 4(0) | TQ05 | QZGTYP | QCT | |||
| KUNNR | Customer Number | KUNNR | CHAR | 10(0) | KNA1 | ALPHA | KUNNR | KUN | C_KUNNR | KUNNR |
| ABNAHMPRF | Source Inspection | QABNAHMPRF | CHAR | 1(0) | BSTYP | |||||
| REVLV | Revision level | REVLV | CHAR | 2(0) | NUMCV | REVLV | RVS | |||
| XCHPF | Batch management requirement indicator | XCHPF | CHAR | 1(0) | XFELD | |||||
| DABRZ | Reference date for settlement | DABRBEZ | DATS | 8(0) | DDAT | |||||
| CUOBJ | Configuration (internal object number) | CUOBJ | NUMC | 18(0) | CUOBJ | CUX | ||||
| LICHN | Supplier Batch Number | LICHN | CHAR | 15(0) | LICHN | |||||
| AUFPS | Item Number of Reservation / Dependent Requirements | RSPOS | NUMC | 4(0) | RSPOS | RPO | ||||
| .INCLU--AP | 0(0) | |||||||||
| /CWM/MENGE | Quantity in Parallel Unit of Measure | /CWM/MENGE | QUAN | 13(3) | MENG13 | |||||
| /CWM/MEINS | Parallel Unit of Measure | /CWM/MEINS | UNIT | 3(0) | Assigned to domain | CUNIT | MEINS | |||
| /CWM/ERFMG | Quantity in Parallel Unit of Entry | /CWM/ERFMG | QUAN | 13(3) | MENG13 | |||||
| /CWM/ERFME | PUoM Entry Unit of Measure | /CWM/ERFME | UNIT | 3(0) | Assigned to domain | CUNIT | MEINS |
Search for further information about these or an SAP related objects