QINSPPL_D - I_INSPECTIONPLANTP I_INSPECTIONPLANTP

I_INSPECTIONPLANTP I_INSPECTIONPLANTP information is stored in SAP table QINSPPL_D.
It is part of development package VDM_QM_PLANNING in software component QM-PT. This development package consists of objects that can be grouped under "CDS views for Inspection Planning".

Fields for table QINSPPL_D

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6
DRAFTUUIDUUID serving as key (parent key, root key)X/BOBF/UUIDRAW16
INSPECTIONPLANGROUPKey for Task List GroupPLNNRCHAR16
INSPECTIONPLANGroup CounterPLNALCHAR4
INSPECTIONPLANINTERNALVERSIONInternal counterCIM_COUNTNUMC16
BILLOFOPERATIONSTYPETask List TypePLNTYCHAR2
INSPECTIONPLANGROUPFOREDITKey for Task List GroupPLNNRCHAR16
INSPECTIONPLANFOREDITGroup CounterPLNALCHAR4
KEYDATEKey DateVDM_V_KEY_DATEDATS16
ISDELETEDDeletion IndicatorLKENZCHAR2
BILLOFOPERATIONSDESCRouting DescriptionPLANTEXTCHAR80
PLANTPlantWERKS_DCHAR8
BILLOFOPERATIONSUSAGETask List UsagePLN_VERWECHAR6
BILLOFOPERATIONSSTATUSStatusPLNSTCHAR6
RESPONSIBLEPLANNERGROUPResponsible Planner Group or DepartmentVAGRPCHAR6
MINIMUMLOTSIZEQUANTITYMinimum Lot SizeLOSGRVONQUAN7
MAXIMUMLOTSIZEQUANTITYMaximum Lot SizeLOSGRBISQUAN7
BILLOFOPERATIONSUNITTask List Unit of MeasurePLNMEUNIT6
INSPSUBSETFIELDCOMBINATIONIdentification for the Inspection Point Field CombinationVDM_QSLWBEZCHAR6
INSPECTIONPARTIALLOTASSIGNMENTPartial Lot Assignment in an Inspection During ProductionVDM_QPPKZTLZUCHAR2
SMPLDRAWINGPROCEDURESample-Drawing ProcedureVDM_QPRZIEHVERCHAR16
SMPLDRAWINGPROCEDUREVERSIONVersion No. of the Sample-Drawing ProcedureQVERSNPRZVCHAR12
INSPECTIONLOTDYNAMICLEVELLevel at Which Dynamic Modification Parameters Are DefinedVDM_QDYNHEADCHAR2
INSPLOTDYNAMICRULEDynamic Modification RuleQDYNREGELCHAR6
INSPEXTERNALNUMBERINGOFVALUESExternal Numbering of Units to Be InspectedQEXTNUMCHAR2
INSPLOTDYNAMICCRITERIAString for Dynamic Modification Criteria (Database Relevant)QDYNSTRINGCHAR20
MATLISCONSIDEREDFORDYNMODIFMaterial Considered for Dynamic ModificationQMATKZCHAR2
SUPLRISCONSIDEREDFORDYNMODIFSupplier Considered for Dynamic ModificationQLIFKZCHAR2
MFRISCONSIDEREDFORDYNMODIFManufacturer Considered for Dynamic ModificationQHERSTKZCHAR2
CUSTISCONSIDEREDFORDYNMODIFCustomer Considered for Dynamic ModificationQKUNDKZCHAR2
CREATIONDATEDate Record Created OnANDATDATS16
CREATEDBYUSERCreated By UserVDM_CREATEDBYUSERIDCHAR24
LASTCHANGEDATELast Changed OnAEDATDATS16
LASTCHANGEDBYUSERLast Changed By UserVDM_LASTCHANGEDBYUSERIDCHAR24
CHANGENUMBERChange NumberAENNRCHAR24
VALIDITYSTARTDATEValid-From DatePPH_BEGDADATS16
VALIDITYENDDATEValid-To DatePPH_ENDDADATS16
CHANGEDDATETIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)TZNTSTMPSDEC8
HASACTIVEENTITYDraft - Indicator - Has active documentSDRAFT_HAS_ACTIVECHAR2
.INCLUDESDRAFT_WRITE_DRAFT_ADMIN0
DRAFTENTITYCREATIONDATETIMEDraft Created OnSDRAFT_CREATED_ATDEC11
DRAFTENTITYLASTCHANGEDATETIMEDraft Last Changed OnSDRAFT_LAST_CHANGED_ATDEC11
DRAFTADMINISTRATIVEDATAUUIDTechnical ID for the Administrative Data of a Draft DocumentSDRAFT_ADMIN_UUIDRAW16
DRAFTENTITYCONSISTENCYSTATUSDraft - Consistency StatusSDRAFT_CONSISTENCY_STATUSCHAR2
DRAFTENTITYOPERATIONCODEDraft - Operation CodeSDRAFT_OPERATION_CODECHAR2
Privacy Policy