C_InspLotCertificate

Quality Certificate for Insplot | view: CINSPLOTCERTI | Extraction: Not supported | Component: Certificate Creation
Tables used: QALS, QAVE, JSTO, JEST, T001, TKA02, TQ30T, MAKT, T001W
Column Name Description
InspectionLot Inspection Lot Number
Column Name Description
Column Name Description
📏 Base Unit of Measure for Inspection Lot Quantity (InspectionLotQuantityUnit):
InspectionLotQuantity Inspection Lot Quantity
Column Name Description
InspectionLotCreatedOn System Date on Which Data Record Was Created
InspectionLotEndDate End Date of Inspection in Local Time Zone
Column Name Description
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
QltyCertRecipientType Quality Certificate Message Partner Type Show values
Column Name Description Domain name
InspectionLotText Inspection Lot Text QKURZTEXT
MaterialName Material Description TEXT40
PlantName Plant Name TEXT30
UsageDecisionValuation null
UsageDecisionCodeCriticality null
InspectionLotTypeText Inspection Type Text QKURZTEXT
AddressID Address ADRNR
BatchShortDescription Short text for batch TEXT40
Customer Customer Number KUNNR
CustomerName Name of Customer TEXT80
Country Country/Region Key LAND1
CityName City TEXT35
PostalCode Postal Code PSTLZ
EmailAddress E-Mail Address AD_SMTPADR
QltyCertificateProfile Certificate Profile ID QVORLNR
QualityCertificateType Certificate Type QZGTYP
QltyCertProfileVersion Version Number of Certificate Profile QVERSNR
QltyCertRecipientNumber Message partner NA_PARNR
Master Data Relations Join Conditions
Batch Number
  • Batch Number
  • Material Number
  • Client
  • C_INSPLOTCERTIFICATE.BATCH == MCH1.CHARG
  • C_INSPLOTCERTIFICATE.MATERIAL == MCH1.MATNR
  • C_INSPLOTCERTIFICATE.MANDT == MCH1.MANDT
Company Code
  • Client
  • Company Code
  • C_INSPLOTCERTIFICATE.MANDT == T001.MANDT
  • C_INSPLOTCERTIFICATE.COMPANYCODE == T001.BUKRS
Inspection Lot Origin C_INSPLOTCERTIFICATE.INSPECTIONLOTORIGIN == TQ31.HERKUNFT
Base Unit of Measure for Inspection Lot Quantity
  • Client
  • Base Unit of Measure for Inspection Lot Quantity
  • C_INSPLOTCERTIFICATE.MANDT == T006.MANDT
  • C_INSPLOTCERTIFICATE.INSPECTIONLOTQUANTITYUNIT == T006.MSEHI
Inspection Type
  • Inspection Type
  • Client
  • C_INSPLOTCERTIFICATE.INSPECTIONLOTTYPE == TQ30.ART
  • C_INSPLOTCERTIFICATE.MANDT == TQ30.MANDT
Usage Decision Code
  • Client
  • ?
  • ?
  • Usage Decision Code
  • ?
  • C_INSPLOTCERTIFICATE.MANDT == QPCD.MANDT
  • C_INSPLOTCERTIFICATE.[column in domain "QCODEGRP"] == QPCD.CODEGRUPPE
  • C_INSPLOTCERTIFICATE.[column in domain "QKATART"] == QPCD.KATALOGART
  • C_INSPLOTCERTIFICATE.INSPECTIONLOTUSAGEDECISIONCODE == QPCD.CODE
  • C_INSPLOTCERTIFICATE.[column in domain "QVERSNR"] == QPCD.VERSION
Order Number (Production Order)
  • Client
  • Order Number (Production Order)
  • C_INSPLOTCERTIFICATE.MANDT == AUFK.MANDT
  • C_INSPLOTCERTIFICATE.MANUFACTURINGORDER == AUFK.AUFNR
Material Number
  • Material Number
  • Client
  • C_INSPLOTCERTIFICATE.MATERIAL == MARA.MATNR
  • C_INSPLOTCERTIFICATE.MANDT == MARA.MANDT
Material Authorization Group for Activities in QM
  • Client
  • Material Authorization Group for Activities in QM
  • C_INSPLOTCERTIFICATE.MANDT == TQ01B.MANDT
  • C_INSPLOTCERTIFICATE.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
Plant
  • Client
  • Plant
  • C_INSPLOTCERTIFICATE.MANDT == T001W.MANDT
  • C_INSPLOTCERTIFICATE.PLANT == T001W.WERKS