SAP QALS_QAVE_EXT Table in S/4 HANA - Structure for RQEEAL10 + Custom fields from QALS and QAVE









QALS_QAVE_EXT is a standard SAP Table which is used to store Structure for RQEEAL10 + Custom fields from QALS and QAVE data and is available within S/4 HANA SAP systems depending on the version and release level. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system

Even using an S/4 Hana system you can still view further information about the SAP QALS_QAVE_EXT table and the data within it using standard SAP GUI transactions such as SE11, SE80 or SE16. Or you can use the ADT (ABAP development tools within eclipse).

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: QALS_QAVE_EXT


QALS_QAVE_EXT table structure field list

Below is the full QALS_QAVE_EXT 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
PRUEFLOSInspection Lot NumberQPLOSNUMC12(0) QALSQPLOSQLSQALSPRUEFLOS
STTXTSystem StatusCO_STTXTCHAR40(0) CHAR40
USTXTField displaying user statusCO_ASTTXCHAR40(0) CHAR40
WERKPlantWERKS_DCHAR4(0) WERKSWRKH_T001W_CWERKS
ARTInspection TypeQPARTCHAR8(0) Assigned to domainQPARTQLA
HERKUNFTInspection Lot OriginQHERKCHAR2(0) Assigned to domainQHERKQHK
OBJNRObject numberJ_OBJNRCHAR22(0) Assigned to domainJ_OBJNRONR
OBTYPObject CategoryJ_OBTYPCHAR3(0) Assigned to domainJ_OBTYP
AUFPLRouting number of operations in the orderCO_AUFPLNUMC10(0) AUFPL
KTEXTMATShort Text for Inspection ObjectQKTEXTOBJCHAR40(0) QKURZTEXT
STSMAStatus ProfileJ_STSMACHAR8(0) Assigned to domainJ_STSMA
QMATAUTHMaterial Authorization Group for Activities in QMQMATAUTHCHAR6(0) Assigned to domainQMATAUTH
STAT11GR Blocked StockKZWESCHAR1(0) KZWES
INSMKQuantity Is or Was in Inspection StockQVINSMKCHAR1(0) QKZ
STAT02Partial Lots ExistQKZQALTCHAR1(0) QKZ
STAT07Inspection with Inspection PointsQKZFERTPRFCHAR1(0) QKZ
STAT06Record Appraisal Costs in Individual QM OrderQKZPRFKOSTCHAR1(0) QKZ
STAT09Source InspectionQABNAHMPRFCHAR1(0) BSTYP
STAT19Documentation Required for Inspection LotQSTAT19CHAR1(0) QKZ
STAT23Inspection Lot ApprovalQKZGENLOSCHAR1(0) QKZGENLOS
STAT24Digital Signature for Insp. Lot in Results RecordingSIG_IL_RESCHAR1(0) SIG_IL_RES
STAT25Digital Signature for Insp. Lot when Usage Decision MadeSIG_IL_USACHAR1(0) SIG_IL_USA
KZSKIPLOTLot SkippedQKZSKIPLOTCHAR1(0) QKZ
HPZ100% InspectionQHPZCHAR1(0) QKZ
DYNHEADLevel at Which Dynamic Modification Parameters Are DefinedQDYNHEADCHAR1(0) Assigned to domainQDYNHEAD
STPRVERSampling ProcedureQSTPRVERCHAR8(0) Assigned to domainQSTPRVERQSV
ENSTEHDATDate of Lot CreationQENTSTDATS8(0) DATUM
ENTSTEZEITTime of Lot CreationQENTSTZEITTIMS6(0) QZEIT
ERSTELLERName of User Who Created the Data RecordQERSTELLERCHAR12(0) QAENDERER
ERSTELDATDate on Which Data Record Was CreatedQDATUMERSTDATS8(0) DATUM
ERSTELZEITTime of Lot CreationQERSTEZEITTIMS6(0) QZEIT
AENDERERName of User Who Last Changed Data RecordQAENDERERCHAR12(0) QAENDERER
AENDERDATDate on Which Data Record Was ChangedQDATUMAENDDATS8(0) DATUM
AENDERZEITTime of Lot ChangeQAENDEZEITTIMS6(0) QZEIT
PASTRTERMStart Date of InspectionQPRSTARTDATS8(0) DATUM
PASTRZEITInspection Start TimeQSTARTZEITTIMS6(0) QZEIT
PAENDTERMEnd Date of InspectionQPRENDEDATS8(0) DATUM
PAENDZEITInspection End TimeQENDEZEITTIMS6(0) QZEIT
PLNTYTask List TypePLNTYCHAR1(0) PLNTYPTYH_TCA01PLNTY
PLNNRKey for Task List GroupPLNNRCHAR8(0) ALPHAPLNNRPLNPLKSPLNNR
PPLVERWTask list usagePLN_VERWECHAR3(0) PLN_VERWEH_T411VERWE
PLNALGroup CounterPLNALCHAR2(0) ALPHAALTNRPAL
SLWBEZIdentifier for Inspection Point Field CombinationQSLWBEZCHAR3(0) Assigned to domainQSLWBEZQBK
STAT13Inspection Point TypeQPPKTTYPCHAR1(0) QPPKTTYP
PRBNAVERFSample-Drawing ProcedureQPRZIEHVERCHAR8(0) Assigned to domainQPRZIEHVERQPV
PRBNAVVVersion No. of the Sample-Drawing ProcedureQVERSNPRZVCHAR6(0) ALPHAQVERSNR
STAT12Confirmation Required for Sample DrawingQKZQUITCHAR1(0) QKZ
SELMATNRMaterial NumberMATNRCHAR40(0) MATN1MATNRMATS_MAT1MATNR
SELREVLVRevision levelREVLVCHAR2(0) NUMCVREVLVRVS
SELWERKPlantWERKS_DCHAR4(0) WERKSWRKH_T001W_CWERKS
SELLIFNRVendor's account numberELIFNCHAR10(0) ALPHALIFNRLIFKRED_CLIFNR
SELHERSTNumber of ManufacturerQLIFNRCHAR10(0) Assigned to domainALPHALIFNRLIF
SELKUNNRAccount number of customerEKUNNCHAR10(0) Assigned to domainALPHAKUNNRKUN
SELPPLVERWTask list usagePLN_VERWECHAR3(0) PLN_VERWEH_T411VERWE
GUELTIGABValid-From DateDATUVDATS8(0) DATUM
AUFNROrder NumberAUFNRCHAR12(0) Assigned to domainALPHAAUFNRANR
VERIDProduction VersionVERIDCHAR4(0) Assigned to domainVERIDVER
SA_AUFNRRun schedule header numberSA_AUFNRCHAR12(0) Assigned to domainALPHASA_AUFNR
KUNNRCustomer (Ship-To Party)QKUNWECHAR10(0) ALPHAKUNNRDEBIKUNNR
LIFNRVendor's account numberELIFNCHAR10(0) ALPHALIFNRLIFKRED_CLIFNR
HERSTELLERNumber of ManufacturerQLIFNRCHAR10(0) Assigned to domainALPHALIFNRLIF
EMATNRMaterial numberEMATNRCHAR40(0) Assigned to domainMATN1MATNRMAT
MATNRMaterial NumberMATNRCHAR40(0) MATN1MATNRMATS_MAT1MATNR
REVLVRevision levelREVLVCHAR2(0) NUMCVREVLVRVS
XCHPFBatch management requirement indicatorXCHPFCHAR1(0) XFELD
CHARGBatch NumberCHARG_DCHAR10(0) Assigned to domainCHARGCHA
LAGORTCHRGStorage locationLGORT_DCHAR4(0) Assigned to domainLGORTLAG
SOBKZSpecial Stock IndicatorSOBKZCHAR1(0) Assigned to domainSOBKZ
EKORGPurchasing organizationEKORGCHAR4(0) Assigned to domainEKORGEKO
EBELNPurchasing Document NumberEBELNCHAR10(0) ALPHAEBELNBESMEKK_CEBELN
EBELPItem Number of Purchasing DocumentEBELPNUMC5(0) Assigned to domainEBELPBSP
ETENRDelivery Schedule Line CounterEETENNUMC4(0) Assigned to domainEETEN
BLARTDocument typeBLARTCHAR2(0) Assigned to domainBLARTBAR
MJAHRMaterial Document YearMJAHRNUMC4(0) GJAHRGJAHRMJA
MBLNRNumber of Material DocumentMBLNRCHAR10(0) ALPHABELNRMBN
ZEILEItem in Material DocumentMBLPONUMC4(0) MBLPOPOS
BUDATPosting Date in the DocumentBUDATDATS8(0) DATUM
BWARTMovement type (inventory management)BWARTCHAR3(0) Assigned to domainBWARTBWA
WERKVORGPlant Where Stock for Inspection Lot Is HeldQWERKVORGCHAR4(0) Assigned to domainWERKS
LAGORTVORGStorage Location for Inspection Lot StockQLGORTVORGCHAR4(0) Assigned to domainLGORT
LGNUMWarehouse Number / Warehouse ComplexLGNUMCHAR3(0) Assigned to domainLGNUMLGN
LGTYPStorage TypeLGTYPCHAR3(0) LGTYPLGTH_T301LGTYP
LGPLAStorage BinLGPLACHAR10(0) LGPLALGPLAG1LGPLA
LS_KDAUFSales Order NumberKDAUFCHAR10(0) ALPHAVBELNAUN
LS_KDPOSItem number in Sales OrderKDPOSNUMC6(0) NUM06KPO
LS_VBELNDeliveryVBELN_VLCHAR10(0) ALPHAVBELNVL
LS_POSNRDelivery ItemPOSNR_VLNUMC6(0) POSNR
LS_ABRVWDelivery CategoryQABRVWCHAR3(0) Assigned to domainABRVW
LS_ROUTERouteROUTECHAR6(0) Assigned to domainROUTE
LS_LLANDDestination CountryLLANDCHAR3(0) Assigned to domainLAND1VLL
LS_KUNAGSold-To PartyKUNAGCHAR10(0) Assigned to domainALPHAKUNNRVAG
LS_VKORGSales OrganizationVKORGCHAR4(0) VKORGVKOC_VKORGVKORG
LS_KDMATCustomer MaterialKDMATCHAR35(0) IDNEX
SPRACHELanguage KeySPRASLANG1(0) ISOLASPRASSPRH_T002SPRAS
KTEXTLOSShort TextQKURZTEXTCHAR40(0) QKURZTEXT
ZUSMKZAEHLNumber of Characteristics Recorded AdditionallyQZUSMKZHLINT25(0) INT2
OFFENNLZMKNumber of Outstanding Short-Term Chars That Require Confirm.QOFFENLZMKINT25(0) INT2
OFFEN_LZMKNumber of Outstanding Long-Term Chars That Require Confirm.QOFFELZMKINT25(0) INT2
LOSMENGEInspection Lot QuantityQLOSMENGEQUAN13(3) QMENGEPLOS
MENGENEINHBase Unit of Measure for Inspection Lot QuantityQLOSMENGEHUNIT3(0) Assigned to domainCUNITMEINS
ANZGEBQM - No. of ContainersQANZGEBQUAN6(3) QGEBPLOS
GEBEHLot ContainerQGEBEHUNIT3(0) Assigned to domainCUNITMEINS
GESSTICHPRInspection Sample SizeQGESTICHQUAN13(3) QMENGEPLOS
EINHPROBEBase Unit of Measure for Sample UnitQPROBEMGEHUNIT3(0) Assigned to domainCUNITMEINS
DYNREGELDynamic Modification RuleQDYNREGELCHAR3(0) Assigned to domainQDYNREGELQDR
STAT44Immediate Dynamic Modification at Inspection Lot CreationQKZDYNAUTCHAR1(0) QKZ
PRSTUFEInspection StageQPRSTUFENUMC4(0) Assigned to domainQPRSTUFE
PRSCHAERFEInspection SeverityQPRSCHAERFNUMC3(0) Assigned to domainQPRSCHAERF
LMENGE01Quantity Posted to Unrestricted-Use StockQLMENGE01FQUAN13(3) QMENGEPLOS
LMENGE02Quantity Posted to ScrapQLMENGE02FQUAN13(3) QMENGEPLOS
LMENGE03Quantity Posted to SampleQLMENGE03FQUAN13(3) QMENGEPLOS
LMENGE04Quantity Posted to Blocked StockQLMENGE04FQUAN13(3) QMENGEPLOS
LMENGE05Quantity Posted to ReservesQLMENGE05FQUAN13(3) QMENGEPLOS
LMENGE06Quantity Posted to Another MaterialQLMENGE06FQUAN13(3) QMENGEPLOS
MATNRNEUMaterial Number to Which the Quantity is PostedQMATNRNEUCHAR40(0) Assigned to domainMATN1MATNRMAT
CHARGNEUBatch to Which Goods Are TransferredQCHARGNEUCHAR10(0) Assigned to domainCHARGCHA
LMENGE07Quantity Returned to VendorQLMENGE07FQUAN13(3) QMENGEPLOS
LMENGE08Other Quantity Posted from Inspection Lot StockQLMENGE08FQUAN13(3) QMENGEPLOS
LMENGE09Other Quantity (2) Posted from Inspection Lot StockQLMENGE09FQUAN13(3) QMENGEPLOS
LMENGEZUBQuantity That Must Be PostedQLMENGEZUBQUAN13(3) QMENGEPLOS
LMENGELZSample Quantity for Long-Term CharacteristicsQLMENGELZQUAN13(3) QMENGEPLOS
LMENGEPRQuantity Actually InspectedQLMENGEPRQUAN13(3) QMENGEPLOS
LMENGEZERQuantity Destroyed During InspectionQLMENGEZERQUAN13(3) QMENGEPLOS
LMENGEISTActual Lot QuantityQLMENGEISTQUAN13(3) QMENGEPLOS
LMENGESCHDefective Quantity in Inspected QuantityQLMENGESCHQUAN13(3) QMENGEPLOS
ANTEILShare of Scrap in Inspection LotQAUSANTEILFLTP16(16) QFLTP16
STAT03Usage Decision Mode (UD Origin)QMODUS_UDCHAR1(0) QMODUS_UD
QPMATLOSAllowed Share of ScrapQPMATLOSFLTP16(16) QPMATLOS
AUFNR_COOrder Number for Recording Appraisal CostsQAUFNR_COCHAR12(0) Assigned to domainALPHAAUFNRANR
KZVBRConsumption postingKZVBRCHAR1(0) KZVBR
KNTTPAccount Assignment CategoryKNTTPCHAR1(0) Assigned to domainKNTTPKNT
STAT05Account Assignment Key: Inspection LotQKZQALSKNTCHAR1(0) QKZQALSKNT
KOSTLCost CenterKOSTLCHAR10(0) Assigned to domainALPHAKOSTLKOS
AUFPSItem Number of Reservation / Dependent RequirementsRSPOSNUMC4(0) RSPOSRPO
ANLN1Main Asset NumberANLN1CHAR12(0) Assigned to domainALPHAANLN1AN1
ANLN2Asset SubnumberANLN2CHAR4(0) Assigned to domainALPHAANLN2AN2
PS_PSP_PNRValuated Sales Order Stock WBS ElementMAT_PSPNRNUMC8(0) Assigned to domainABPSPPS_POSNR
NPLNRNetwork Number for Account AssignmentNPLNRCHAR12(0) Assigned to domainALPHAAUFNRNET
APLZLInternal counterCIM_COUNTNUMC8(0) CIM_COUNT
KDAUFSales order number of valuated sales order stockMAT_KDAUFCHAR10(0) ALPHAVBELNAUN
KDPOSSales Order Item of Valuated Sales Order StockMAT_KDPOSNUMC6(0) NUM06KPO
PAOBJNRProfitability Segment Number (CO-PA)RKEOBJNRNUMC10(0) RKEOBJNR
PRCTRProfit CenterPRCTRCHAR10(0) ALPHAPRCTRPRCPRCTR_EMPTYPRCTR
GSBERBusiness AreaGSBERCHAR4(0) Assigned to domainGSBERGSB
KONTOG/L Account NumberSAKNRCHAR10(0) ALPHASAKNRSAKC_SAKNRSAKNR
KOKRSControlling AreaKOKRSCHAR4(0) Assigned to domainCACCDCAC
BUKRSCompany CodeBUKRSCHAR4(0) BUKRSBUKC_T001BUKRS
SERNPSerial Number ProfileSERAILCHAR4(0) Assigned to domainSERAIL
KONT_PSPNRWork Breakdown Structure Element (WBS Element)PS_PSP_PNRNUMC8(0) Assigned to domainABPSPPS_POSNR
KONT_KDAUFSales Order NumberKDAUFCHAR10(0) ALPHAVBELNAUN
KONT_KDPOSItem number in Sales OrderKDPOSNUMC6(0) NUM06KPO
STAT16Field Not Used as of 3.0 Field Reserved for SAPQ_UNUSED01CHAR1(0) CHAR1
INSP_DOC_NUMBERInspection Document Number from External SystemQINSP_DOC_NUMBERCHAR30(0) QPLEXT_INSP_DOC_NUMBER
PRIO_PUNKTEPriority PointsQPRIO_PUNKTEINT410(0) QPLEXT_PRIOP
LICHNSupplier Batch NumberLICHNCHAR15(0) LICHN
STAT36Lot Has Partial Lots Without Insp. Point and Insp. SpecsQTLS_WO_INSPPOINTCHAR1(0) QKZ
.INCLU--AP0(0)
/CWM/LOSMENGEInspection Lot Quantity in Parallel Unit of Measure/CWM/LOSMENGEQUAN13(3) MENG13
/CWM/MENGEINH2QParallel Unit of Measure/CWM/MEINSUNIT3(0) Assigned to domainCUNITMEINS
VBEWERTUNGCode ValuationQBEWERTUNGCHAR1(0) QBEWERTUNG
QKENNZAHLQuality ScoreQKENNZAHLDEC3(0) QKENNZAHL
KZARTInspection Lot, Partial Lot, Single Unit, IntervalQKZARTCHAR1(0) QKZART
VKATARTCatalogQKATARTCHAR1(0) Assigned to domainQKATARTQKT
VAUSWAHLMGSelected Set of the Usage DecisionQVMENGECHAR8(0) Assigned to domainQAUSWAHLMG
VCODEGRPCode Group of the Usage DecisionQVGRUPPECHAR8(0) Assigned to domainQCODEGRPCGP
VCODEUsage Decision CodeQVCODECHAR4(0) Assigned to domainQCODE
DBEWERTUNGValuation RuleQBEWERTCHAR2(0) Assigned to domainQKEY1
VFOLGEAKTIFollow-Up ActionQFOLGEAKTICHAR8(0) Assigned to domainQFOLGEAKTI
VNAMEPerson Who Made the Usage DecisionQVNAMECHAR12(0) QAENDERER
VDATUMDate when Usage Decision Was RecordedQVEDATUMDATS8(0) DATUM
VEZEITERFTime when Usage Decision Was RecordedQVEZEITERFTIMS6(0) QZEIT
VAENAMEPerson Who Changed the Usage DecisionQVAENAMECHAR12(0) QAENDERER
VAEDATUMChange Date of Usage DecisionQVAEDATUMDATS8(0) DATUM
VEZEITAENTime when Usage Decision ChangedQVEZEITAENTIMS6(0) QZEIT
DUMMY_QAVE_INCL_EEW_PSDummy function in length 1DUMMYCHAR1(0) DUMMY
DUMMY_QALS_INCL_EEW_PSDummy function in length 1DUMMYCHAR1(0) DUMMY
DUMMY_QAVE_INCL_EEW_TRDummy function in length 1DUMMYCHAR1(0) DUMMY
DUMMY_QALS_INCL_EEW_TRDummy function in length 1DUMMYCHAR1(0) DUMMY




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!