1. Home
  2. Resources
  3. SAP Tables
  4. QBAAL - Line in list for report RQBAAM10

SAP Table QBAAL

Line in list for report RQBAAM10

QBAAL (Line in list for report RQBAAM10) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link QBAAL to other SAP tables.

QBAAL table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
MATNR Material Number MATNR MARA CHAR 18 0
ZAEHL Internal Counter for DB Objects Q_COUNT NUMC 6 0
ERSTELLER Name of User who Created the Q-Info Record QINFERST CHAR 12 0
ERSTELLDAT Create Date of Q-Info Record QINFERSTDT DATS 8 0
AENDERER Name of User who Most Recently Changed the Q-Info Record QINFAEND CHAR 12 0
AENDERDAT Change Date of Q-Info Record QINFAENDDT DATS 8 0
LIEFERANT Vendor Account Number ELIFN LFA1 CHAR 10 0
WERK Plant WERKS_D T001W CHAR 4 0
FREI_DAT Date Until Which the Release Is Valid QFREIDAT DATS 8 0
FREI_MGKZ Release Quantity Is Active QFREIMGKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
ME Base Unit of Measure for the Material QBSTME T006 UNIT 3 0
FREI_MNG Quantity Released for the Material QFREIMG QUAN 13 3
BEST_MG Quantity Ordered for the Material QBSTMG QUAN 13 3
DAT_RUECK Date when the Ordered Quantity Was Reset QRSDAT DATS 8 0
SPERRGRUND Blocking reason QSPERRGR CHAR 40 0
SPRACHE Language Key SPRAS T002 LANG 1 0
SPERRFKT Function That Will Be Blocked QSPERRFKT TQ04A CHAR 2 0
QVVORH Quality Assurance Agreement Exists QQSVVORH CHAR 1 0
NULL Indicator is not set
X Indicator is set
NOINSP Inspection Control in the QM Info Record QNOINSP CHAR 1 0
NULL Inspection active, if vendor is not certified
X No inspection
1 Inspection active, independent of vendor certification
QSSYSFAM Vendor's QM system QSSYS_IST TQ02B CHAR 4 0
QSSYSDAT Validity date of certification QQSSYSDAT DATS 8 0
VARIABNAHM Inspection Type for Insp. Lot Origin (Source Inspection) QINFVAR1 TQ30 CHAR 8 0
LTEXTKZ Inspection Characteristic Long Text Exists QLTEXTKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
SPRAS Language Key SPRAS T002 LANG 1 0
PLOS Inspection Lot No. in QINF for Current Status QPLOSQINF QALS NUMC 12 0
PLOS2 Inspection Lot No. in QINF for Next Status QPLOSQINF2 QALS NUMC 12 0
STSMA Status Profile Assigned to Quality Info Record QSTSMAQINF TJ20 CHAR 8 0
OBJNR QINF Object Number in Status Management QINFOBJNR ONR00 CHAR 22 0
NOINSPABN No GR Inspection if Source Inspection Lot Exists QNOWEABN CHAR 1 0
NULL Indicator is not set
X Indicator is set
VORLABN Lot Creation Lead Time (in Days) for Source Inspection QVORLABN INT1 3 0
REVLV Revision Level REVLV CHAR 2 0
LOEKZ Deletion Flag QLOEKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
CERTCONTROL Control of Certificate Receipt QCERTCONTROL CHAR 1 0
NULL Standard certificate receipt (print, PDF, or FAX)
1 Electronic certificate with PDF and data transfer
2 Electronic certificate without PDF with data transfer
QINFFEHL QINF Missing QINFFEHL CHAR 1 0
NULL Indicator is not set
X Indicator is set
QVFEHL Quality Assurance Agreement Missing QINFNOQV CHAR 1 0
NULL Indicator is not set
X Indicator is set
DATUM The "Release Until" Date Has Been Exceeded QINFDAT CHAR 1 0
NULL Indicator is not set
X Indicator is set
MENGE Release Quantity Exceeded QINFMNG CHAR 1 0
NULL Indicator is not set
X Indicator is set
QINFQSSYSDAT Validity Date of Certification Has Expired QINFQSSYSDAT CHAR 1 0
NULL Indicator is not set
X Indicator is set
QMATSSQSS Control Key from Material in Customizing Deleted QMATSSQSS CHAR 1 0
NULL Indicator is not set
X Indicator is set

QBAAL foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
QBAAL LIEFERANT QBAAL MANDT LFA1 Vendor Master (General Section) MANDT
QBAAL LIEFERANT QBAAL LIEFERANT LFA1 Vendor Master (General Section) LIFNR
QBAAL MANDT QBAAL MANDT T000 Clients MANDT
QBAAL MATNR QBAAL MANDT MARA General Material Data MANDT
QBAAL MATNR QBAAL MATNR MARA General Material Data MATNR
QBAAL ME QBAAL ME T006 Units of Measurement MSEHI
QBAAL ME QBAAL MANDT T006 Units of Measurement MANDT
QBAAL OBJNR QBAAL OBJNR ONR00 General Object Number OBJNR
QBAAL OBJNR QBAAL MANDT ONR00 General Object Number MANDT
QBAAL PLOS QBAAL MANDT QALS Inspection lot record MANDANT
QBAAL PLOS QBAAL PLOS QALS Inspection lot record PRUEFLOS
QBAAL PLOS2 QBAAL MANDT QALS Inspection lot record MANDANT
QBAAL PLOS2 QBAAL PLOS2 QALS Inspection lot record PRUEFLOS
QBAAL QSSYSFAM QBAAL MANDT TQ02B QM system MANDT
QBAAL QSSYSFAM QBAAL QSSYSFAM TQ02B QM system QSSYSFAM
QBAAL SPERRFKT QBAAL MANDT TQ04A Functions that can be blocked MANDT
QBAAL SPERRFKT QBAAL SPERRFKT TQ04A Functions that can be blocked SPERRFKT
QBAAL SPRACHE QBAAL SPRACHE T002 Language Keys (Component BC-I18) SPRAS
QBAAL SPRAS QBAAL SPRAS T002 Language Keys (Component BC-I18) SPRAS
QBAAL STSMA QBAAL MANDT TJ20 Status profiles MANDT
QBAAL STSMA QBAAL STSMA TJ20 Status profiles STSMA
QBAAL VARIABNAHM QBAAL MANDT TQ30 Inspection types MANDT
QBAAL VARIABNAHM QBAAL VARIABNAHM TQ30 Inspection types ART
QBAAL WERK QBAAL MANDT T001W Plants/Branches MANDT
QBAAL WERK QBAAL WERK T001W Plants/Branches WERKS