SAP QINSPLOT_D Table in S/4 HANA - I_INSPECTIONLOTTP I_INSPECTIONLOTTP









QINSPLOT_D is a standard SAP Table which is used to store I_INSPECTIONLOTTP I_INSPECTIONLOTTP 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 QINSPLOT_D 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: A - Application table (master and transaction data)
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can Be Enhanced (Deep)
Dictionary Type: Transparent table
Database Table: QINSPLOT_D


QINSPLOT_D table structure field list

Below is the full QINSPLOT_D 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
MANDTClientMANDTCLNT3(0) MANDT
DRAFTUUIDUUID serving as key (parent key, root key)/BOBF/UUIDRAW16(0) SYSUUID
INSPECTIONLOTInspection Lot NumberQPLOSNUMC12(0) QPLOSQLSQALSPRUEFLOS
MATERIALMaterial NumberMATNRCHAR40(0) MATN1MATNRMATS_MAT1MATNR
BATCHBatch NumberCHARG_DCHAR10(0) CHARGCHA
PLANTPlantWERKS_DCHAR4(0) WERKSWRKH_T001W_CWERKS
INSPECTIONLOTORIGINInspection Lot OriginVDM_QHERKCHAR2(0) QHERK
ORDERINTERNALBILLOFOPERATIONSRouting number of operations in the orderCO_AUFPLNUMC10(0) AUFPL
MANUFACTURINGORDEROrder Number (Production Order)VDM_QM_FERTAUFNRCHAR12(0) ALPHAAUFNRANR
INSPECTIONLOTTEXTInspection Lot TextVDM_QPLOS_TEXTCHAR40(0) QKURZTEXT
INSPECTIONLOTTYPEInspection TypeQPARTCHAR8(0) QPARTQLA
INSPECTIONLOTQUANTITYInspection Lot QuantityVDM_QLOSMENGEQUAN13(3) QMENGEPLOS
INSPECTIONLOTACTUALQUANTITYActual Lot QuantityVDM_QLMENGEISTQUAN13(3) QMENGEPLOS
INSPECTIONLOTDEFECTIVEQUANTITYDefective QuantityVDM_QLMENGESCHQUAN13(3) QMENGEPLOS
INSPECTIONLOTQUANTITYUNITBase Unit of Measure for Inspection Lot QuantityQLOSMENGEHUNIT3(0) CUNITMEINS
INSPLOTCREATEDONLOCALDATEDate of Lot CreationQENTSTDATS8(0) DATUM
INSPSUBSETFIELDCOMBINATIONIdentifier for Inspection Point Field CombinationQSLWBEZCHAR3(0) QSLWBEZQBK
INSPLOTNMBROPENLONGTERMCHARCOpen Long-Term CharacteristicsVDM_QOFFELZMKINT25(0) INT2
STATUSOBJECTObject numberJ_OBJNRCHAR22(0) J_OBJNRONR
STATUSOBJECTCATEGORYObject CategoryJ_OBTYPCHAR3(0) J_OBTYP
INSPECTIONLOTOBJECTTEXTShort Text for Inspection ObjectQKTEXTOBJCHAR40(0) QKURZTEXT
STATUSPROFILEStatus ProfileJ_STSMACHAR8(0) J_STSMA
MATLQUALITYAUTHORIZATIONGROUPMaterial Authorization Group for Activities in QMVDM_QMATAUTHCHAR6(0) QMATAUTH
INSPECTIONLOTHASQUANTITYPosted to Inspection StockVDM_QVINSMKCHAR1(0) XFELD
INSPLOTISCREATEDAUTOMATICALLYInspection Lot Is Created AutomaticallyQSTAT01CHAR1(0) QKZ
INSPECTIONLOTHASPARTIALLOTSPartial Lots ExistQKZQALTCHAR1(0) QKZ
INSPECTIONLOTHASAPPRAISALCOSTSRecord Appraisal Costs in Individual QM OrderQKZPRFKOSTCHAR1(0) QKZ
INSPLOTHASSUBSETSInspection with Inspection PointsQKZFERTPRFCHAR1(0) QKZ
INSPLOTISAUTOMUSGEDCSNPOSSIBLEAutomatic Usage Decision PlannedVDM_QAUTO_VECHAR1(0) XFELD
PURCHASINGDOCUMENTCATEGORYSource InspectionQABNAHMPRFCHAR1(0) BSTYP
INSPLOTHASCONFIGNSPECIFICATIONInspection Specifications from ConfigurationQCONFCHAR1(0) QKZ
GOODSRECEIPTISMOVEDTOBLKDSTOCKGR Blocked StockKZWESCHAR1(0) KZWES
INSPLOTISDOCUMENTATIONREQUIREDDocumentation RequiredVDM_QSTAT19CHAR1(0) XFELD
INSPLOTISTASKLISTREQUIREDInspection Plan RequiredVDM_QSTAT20CHAR1(0) XFELD
INSPLOTHASMANUALSAMPLESIZEEnter Sample ManuallyQSTAT21CHAR1(0) QKZ
INSPLOTHASMATERIALSPECInspect with Material SpecificationVDM_QSPEZUEBERCHAR1(0) VDM_QKZ_BOOL
INSPECTIONLOTAPPROVALInspection Lot ApprovalVDM_QKZGENLOSCHAR1(0) QKZGENLOS
INSPLOTDIGITALSGNTRRESULTSRECGDigital Signature for Insp. Lot in Results RecordingSIG_IL_RESCHAR1(0) SIG_IL_RES
INSPLOTDIGITALSGNTRINUSGEDCSNDigital Signature Usage DecisionVDM_QDGTLSGNTRUSGEDCSNCHAR1(0) SIG_IL_USA
INSPLOTISBATCHREQUIREDApproved Batch Record RequiredXGCHPCHAR1(0) XFELD
INSPLOTUSAGEINSTABILITYSTUDYInspection Lot for Stability StudyQSTABICHAR1(0) QSTABI
INSPLOTISSTOCKPOSTINGCOMPLETEDStock Postings CompletedVDM_QSTAT34CHAR1(0) XFELD
INSPECTIONLOTHASUSAGEDECISIONUsage Decision MadeVDM_QSTAT35CHAR1(0) XFELD
NUMBEROFSERIALNUMBERSNumber of serial numbersANZSNINT410(0) INT4
INSPLOTISSERIALNMBRPOSSIBLESerial Number Management PossibleQEINZCHAR1(0) QKZ
INSPECTIONLOTISSKIPPEDSkip LotVDM_QKZSKIPLOTCHAR1(0) XFELD
INSPECTIONLOTISFULLINSPECTION100% InspectionQHPZCHAR1(0) QKZ
INSPECTIONLOTDYNAMICLEVELLevel at Which Dynamic Modification Parameters Are DefinedVDM_QDYNHEADCHAR1(0) QDYNHEAD
SAMPLINGPROCEDURESampling ProcedureQSTPRVERCHAR8(0) QSTPRVERQSV
INSPLOTCREATEDONLOCALTIMECreated At (Local Time)VDM_QENTSTZEITTIMS6(0) QZEIT
INSPECTIONLOTCREATEDBYName of User Who Created the Data RecordQERSTELLERCHAR12(0) QAENDERER
INSPECTIONLOTCREATEDONDate on Which Data Record Was CreatedQDATUMERSTDATS8(0) DATUM
INSPECTIONLOTCREATEDONTIMECreated AtVDM_QERSTEZEITTIMS6(0) QZEIT
INSPECTIONLOTCHANGEDBYName of User Who Last Changed Data RecordQAENDERERCHAR12(0) QAENDERER
INSPECTIONLOTCHANGEDATEDate on Which Data Record Was ChangedQDATUMAENDDATS8(0) DATUM
INSPECTIONLOTCHANGETIMELot Changed AtVDM_QAENDEZEITTIMS6(0) QZEIT
CHANGEDDATETIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)TZNTSTMPSDEC15(0) TZNTSTMPS
INSPECTIONLOTSTARTDATEStart Date of InspectionQPRSTARTDATS8(0) DATUM
INSPECTIONLOTSTARTTIMEInspection Started AtVDM_QSTARTZEITTIMS6(0) QZEIT
INSPECTIONLOTENDDATEEnd Date of InspectionQPRENDEDATS8(0) DATUM
INSPECTIONLOTENDTIMEInspection Ended AtVDM_QENDEZEITTIMS6(0) QZEIT
BILLOFOPERATIONSTYPEBill of Operations TypeVDM_PLNTYCHAR1(0) PLNTYPTYH_TCA01PLNTY
BILLOFOPERATIONSGROUPBill of Operations GroupVDM_PLNNRCHAR8(0) ALPHAPLNNR
BILLOFOPERATIONSUSAGEBill of Operations UsageVDM_PLN_VERWECHAR3(0) PLN_VERWE
BILLOFOPERATIONSVARIANTBill of Operations Group CounterVDM_PLNALCHAR2(0) ALPHAALTNR
BILLOFOPERATIONSCHANGESTATEIDInternal counterCIM_COUNTNUMC8(0) CIM_COUNT
INSPECTIONSUBSETTYPEInspection Point TypeVDM_QPPKTTYPCHAR1(0) QPPKTTYP
SMPLDRAWINGPROCEDURESample-Drawing ProcedureVDM_QPRZIEHVERCHAR8(0) QPRZIEHVER
SMPLDRAWINGPROCEDUREVERSIONVersion No. of the Sample-Drawing ProcedureQVERSNPRZVCHAR6(0) ALPHAQVERSNR
SMPLDRWGPROCEDISCONFREQUIREDConfirmation Required for Sample DrawingVDM_QKZQUITCHAR1(0) XFELD
INSPLOTSELECTIONMATERIALMaterial NumberMATNRCHAR40(0) MATN1MATNRMATS_MAT1MATNR
INSPLOTSELMATLREVISIONLVLRevision levelREVLVCHAR2(0) NUMCVREVLVRVS
INSPLOTSELECTIONPLANTPlantWERKS_DCHAR4(0) WERKSWRKH_T001W_CWERKS
INSPLOTSELECTIONSUPPLIERVendor's account numberELIFNCHAR10(0) ALPHALIFNRLIFKRED_CLIFNR
INSPLOTSELECTIONMANUFACTURERNumber of ManufacturerQLIFNRCHAR10(0) ALPHALIFNRLIF
INSPLOTSELECTIONCUSTOMERAccount number of customerEKUNNCHAR10(0) ALPHAKUNNRKUN
INSPLOTSELBILLOFOPERATIONSUSGETask list usagePLN_VERWECHAR3(0) PLN_VERWEH_T411VERWE
INSPLOTSELECTIONVALIDFROMDATEKey Date for Selecting Records or Changing Task ListsQSTICHTAGDATS8(0) DATUM
PRODUCTIONVERSIONProduction VersionVERIDCHAR4(0) VERIDVER
SALESOPERATIONSPLANNINGORDERRun Schedule HeaderVDM_SA_AUFNRCHAR12(0) ALPHASA_AUFNR
ISBUSINESSPURPOSECOMPLETEDBusiness Purpose Completed FlagCVP_XBLCKCHAR1(0) CVP_XBLCK
CUSTOMERCustomer (Ship-To Party)VDM_QKUNWECHAR10(0) ALPHAKUNNR
SUPPLIERVendor's account numberELIFNCHAR10(0) ALPHALIFNRLIFKRED_CLIFNR
BATCHBYSUPPLIERSupplier Batch NumberLICHNCHAR15(0) LICHN
MANUFACTURERNumber of ManufacturerQLIFNRCHAR10(0) ALPHALIFNRLIF
MANUFACTURERPARTNMBRManufacturer MaterialVDM_EMATNCHAR40(0) MATN1MATNR
MATERIALREVISIONLEVELRevision levelREVLVCHAR2(0) NUMCVREVLVRVS
MATERIALISBATCHMANAGEDBatch RequiredVDM_XCHPFCHAR1(0) XFELD
BATCHSTORAGELOCATIONStorage Location for BatchVDM_LGORT_DCHAR4(0) LGORT
MATERIALCOMPISSPECIALSTOCKSpecial Stock IndicatorSOBKZCHAR1(0) SOBKZ
PURCHASINGORGANIZATIONPurchasing OrganizationEKORG_LLCHAR4(0) EKORGEKO
PURCHASINGDOCUMENTPurchasing DocumentFIS_EBELNCHAR10(0) ALPHAEBELNBESMEKK_CEBELN
PURCHASINGDOCUMENTITEMPurchasing Document ItemVDM_EBELPNUMC5(0) EBELP
SCHEDULELINEDelivery Schedule Line CounterEETENNUMC4(0) EETEN
ACCOUNTINGDOCUMENTTYPEDocument TypeVDM_BLARTCHAR2(0) BLART
MATERIALDOCUMENTYEARMaterial Document YearVDM_MJAHRNUMC4(0) GJAHRGJAHR
MATERIALDOCUMENTNumber of Material DocumentMBLNRCHAR10(0) ALPHABELNRMBN
MATERIALDOCUMENTITEMMaterial Document ItemVDM_MBLPONUMC4(0) MBLPO
MATLDOCLATESTPOSTGDATEPosting Date in the DocumentBUDATDATS8(0) DATUM
GOODSMOVEMENTTYPEMovement type (inventory management)BWARTCHAR3(0) BWARTBWA
INSPECTIONLOTPLANTPlant for Inspection LotVDM_QWERKVORGCHAR4(0) WERKS
INSPECTIONLOTSTORAGELOCATIONStorage Location for Inspection Lot StockVDM_QLGORTVORGCHAR4(0) LGORT
WAREHOUSEWarehouse Number / Warehouse ComplexLGNUMCHAR3(0) LGNUMLGN
STORAGETYPEStorage TypeLGTYPCHAR3(0) LGTYPLGTH_T301LGTYP
STORAGEBINStorage BinLGPLACHAR10(0) LGPLALGPLAG1LGPLA
SALESORDERSales Order NumberKDAUFCHAR10(0) ALPHAVBELNAUN
SALESORDERITEMSales Order ItemVDM_KDPOSNUMC6(0) NUM06
DELIVERYDOCUMENTDelivery DocumentVDM_DELIVERYDOCUMENTCHAR10(0) ALPHAVBELN
DELIVERYDOCUMENTITEMDelivery Document ItemVDM_POSNR_VLNUMC6(0) POSNR
DELIVERYCATEGORYDelivery CategoryQABRVWCHAR3(0) ABRVW
ROUTERouteROUTECHAR6(0) ROUTE
BILLTOPARTYCOUNTRYDestination CountryLLANDCHAR3(0) LAND1VLL
SOLDTOPARTYCustomer (Sold-To Party)VDM_KUNAGCHAR10(0) ALPHAKUNNR
SALESORGANIZATIONSales OrganizationVKORGCHAR4(0) VKORGVKOC_VKORGVKORG
MATERIALBYCUSTOMERCustomer MaterialKDMATCHAR35(0) IDNEX
LANGUAGELanguage KeySPRASLANG1(0) ISOLASPRASSPRH_T002SPRAS
INSPLOTNMBRADDLRECORDEDCHARCNumber of Characteristics Recorded AdditionallyQZUSMKZHLINT25(0) INT2
INSPLOTNMBROPENSHORTTERMCHARCNumber of Outstanding Short-Term Chars That Require Confirm.QOFFENLZMKINT25(0) INT2
INSPECTIONLOTCONTAINERQM - No. of ContainersQANZGEBQUAN6(3) QGEBPLOS
INSPECTIONLOTCONTAINERUNITLot ContainerQGEBEHUNIT3(0) CUNITMEINS
INSPECTIONLOTSAMPLEQUANTITYInspection Sample SizeQGESTICHQUAN13(3) QMENGEPLOS
INSPECTIONLOTSAMPLEUNITSample Unit of MeasureVDM_QPROBEMGEHUNIT3(0) CUNITMEINS
INSPLOTDYNAMICRULEDynamic Modification RuleVDM_QDYNREGELCHAR3(0) QDYNREGEL
INSPLOTDYNAMICTRGGRPOINTTime of Dynamic Modification in Inspection LotQDYNTIMECHAR1(0) QDYNTIME
INSPECTIONDYNAMICSTAGEInspection StageQPRSTUFENUMC4(0) QPRSTUFE
INSPECTIONSEVERITYInspection SeverityQPRSCHAERFNUMC3(0) QPRSCHAERF
INSPLOTQTYTOFREEUnrestricted-Use StockVDM_QLMENGE01FQUAN13(3) QMENGEPLOS
INSPLOTQTYTOSCRAPScrap QuantityVDM_QLMENGE02FQUAN13(3) QMENGEPLOS
INSPLOTQTYTOSAMPLEQuantity Posted to SampleQLMENGE03FQUAN13(3) QMENGEPLOS
INSPLOTQTYTOBLOCKEDBlocked StockVDM_QLMENGE04FQUAN13(3) QMENGEPLOS
INSPLOTQTYTORESERVESQuantity Posted to ReservesQLMENGE05FQUAN13(3) QMENGEPLOS
INSPLOTQTYTOANOTHERMATERIALNew MaterialVDM_QLMENGE06FQUAN13(3) QMENGEPLOS
INSPLOTMATERIALPOSTEDTOMaterial Posted ToVDM_QMATNRNEUCHAR40(0) MATN1MATNR
INSPLOTBATCHTRANSFERREDTOBatch Transferred ToVDM_QCHARGNEUCHAR10(0) CHARG
INSPLOTQTYRETURNEDTOSUPPLIERReturn to SupplierVDM_QLMENGE07FQUAN13(3) QMENGEPLOS
INSPLOTQTYTOSPECIALSTOCKOther QuantityVDM_QLMENGE08FQUAN13(3) QMENGEPLOS
INSPLOTQTYTOOTHERSTOCKOther Quantity 2VDM_QLMENGE09FQUAN13(3) QMENGEPLOS
INSPLOTQTYTOBEPOSTEDQuantity to Be PostedVDM_QLMENGEZUBQUAN13(3) QMENGEPLOS
INSPLOTSMPLQTYFORLONGTERMCHARLong-Term Sample QuantityVDM_QLMENGELZQUAN13(3) QMENGEPLOS
INSPLOTQTYINSPECTEDInspected QuantityVDM_QLMENGEPRQUAN13(3) QMENGEPLOS
INSPLOTQTYDESTROYEDDestroyed QuantityVDM_QLMENGEZERQUAN13(3) QMENGEPLOS
INSPECTIONLOTSCRAPRATIOShare of Scrap in Inspection LotQAUSANTEILFLTP16(16) QFLTP16
INSPLOTUSAGEDECISIONTOOLUsage Decision Mode (UD Origin)QMODUS_UDCHAR1(0) QMODUS_UD
INSPECTIONLOTALLOWEDSCRAPRATIOAllowed Share of ScrapQPMATLOSFLTP16(16) QPMATLOS
QUALITYCOSTCOLLECTOROrder Number for Recording Appraisal CostsQAUFNR_COCHAR12(0) ALPHAAUFNRANR
CONSUMPTIONPOSTINGConsumption postingKZVBRCHAR1(0) KZVBR
ACCOUNTASSIGNMENTCATEGORYAccount Assignment CategoryKNTTPCHAR1(0) KNTTPKNT
PURCHASINGDOCUMENTITEMCATEGORYItem category in purchasing documentPSTYPCHAR1(0) PSTYP
INSPLOTACCTASSGMTKEYAccount Assignment Key: Inspection LotQKZQALSKNTCHAR1(0) QKZQALSKNT
COSTCENTERCost CenterKOSTLCHAR10(0) ALPHAKOSTLKOS
RESERVATIONITEMItem Number of Reservation / Dependent RequirementsRSPOSNUMC4(0) RSPOSRPO
MASTERFIXEDASSETMain Asset NumberANLN1CHAR12(0) ALPHAANLN1AN1
FIXEDASSETAsset SubnumberANLN2CHAR4(0) ALPHAANLN2AN2
SALESORDSTOCKWBSELEMENTValuated Sales Order Stock WBS ElementMAT_PSPNRNUMC8(0) ABPSPPS_POSNR
PROJECTNETWORKNetwork Number for Account AssignmentNPLNRCHAR12(0) ALPHAAUFNRNET
NETWORKACTIVITYINTERNALIDInternal counterCIM_COUNTNUMC8(0) CIM_COUNT
INVENTORYSPCLSTKSALESDOCUMENTInventory Special Stock Sales DocumentVDM_MAT_KDAUFCHAR10(0) ALPHAVBELN
INVENTORYSPCLSTKSALESDOCITMSales Order Item of Valuated Sales Order StockMAT_KDPOSNUMC6(0) NUM06KPO
PROFITABILITYSEGMENTProfitability Segment Number (CO-PA)RKEOBJNRNUMC10(0) RKEOBJNR
PROFITCENTERProfit CenterPRCTRCHAR10(0) ALPHAPRCTRPRCPRCTR_EMPTYPRCTR
BUSINESSAREABusiness AreaGSBERCHAR4(0) GSBERGSB
GLACCOUNTG/L Account NumberSAKNRCHAR10(0) ALPHASAKNRSAKC_SAKNRSAKNR
CONTROLLINGAREAControlling AreaKOKRSCHAR4(0) CACCDCAC
COMPANYCODECompany CodeBUKRSCHAR4(0) BUKRSBUKC_T001BUKRS
SERIALNUMBERPROFILESerial Number ProfileSERAILCHAR4(0) SERAIL
INSPLOTCOSTCOLLECTORSALESORDERSales Order NumberKDAUFCHAR10(0) ALPHAVBELNAUN
INSPLOTCOSTCOLLECTORSLSORDITEMItem number in Sales OrderKDPOSNUMC6(0) NUM06KPO
INSPLOTCOSTCOLLECTORWBSELEMENTWork Breakdown Structure Element (WBS Element)PS_PSP_PNRNUMC8(0) ABPSPPS_POSNR
INSPLOTEXTERNALNUMBERInspection Document NumberVDM_QINSP_DOC_NUMBERCHAR30(0) QPLEXT_INSP_DOC_NUMBER
INSPECTIONLOTPRIORITYPOINTSPriority PointsQPRIO_PUNKTEINT410(0) QPLEXT_PRIOP
MAINTENANCEPLANMaintenance PlanWARPLCHAR12(0) ALPHAWARPLMPLMPLALWARPL
MAINTENANCEPLANITEMINTIDMaintenance itemWAPOSCHAR16(0) ALPHAPOSNUMPSMPOSLWAPOS
MAINTENANCESTRATEGYMaintenance StrategySTRATCHAR6(0) WSTRASTRSTRAASTRAT
HASACTIVEENTITYDraft - Indicator - Has active documentSDRAFT_HAS_ACTIVECHAR1(0) BOOLE
DRAFTENTITYCREATIONDATETIMEDraft Created OnSDRAFT_CREATED_ATDEC21(7) TZNTSTMPL
DRAFTENTITYLASTCHANGEDATETIMEDraft Last Changed OnSDRAFT_LAST_CHANGED_ATDEC21(7) TZNTSTMPL
DRAFTADMINISTRATIVEDATAUUIDTechnical ID for the Administrative Data of a Draft DocumentSDRAFT_ADMIN_UUIDRAW16(0) SYSUUID
DRAFTENTITYCONSISTENCYSTATUSDraft Consistency StatusSDRAFT_CONSISTENCY_STATUSCHAR1(0) SDRAFT_CONSISTENCY_STATUS
DRAFTENTITYOPERATIONCODEDraft - Operation CodeSDRAFT_OPERATION_CODECHAR1(0) SDRAFT_OPERATION_CODE
DUMMY_QALS_INCL_EEW_PSDummy 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!