C_SFIPlanInspCharInfo

SFI Plan Insp Char Information | view: CSFIPICINFO | Extraction: Not supported | Component: Shop Floor Execution
Column Name Description
InspectionLot Inspection Lot Number
InspPlanOperationInternalID General counter for order
InspectionSubsetInternalID Inspection Sample Number
InspectionCharacteristic Inspection Characteristic Number
ShopFloorItem ID of Serialized Material
Column Name Description
Column Name Description
Column Name Description
InspectionLotStartTime Inspection Started At
Column Name Description
InspLotHasSubsets Inspection with Inspection Points Show values
InspResultIsDocumentationRqd Documentation Required for Inspection Results Show values
InspSpecAddlDecimalPlaces Number of Additional Decimal Places for Statistical Values Show values
InspSpecDecimalPlaces Number of Places to the Right of a Decimal Point (Accuracy) Show values
InspSpecHasLowerLimit Boolean Variable (X = True, - = False, Space = Unknown) Show values
InspSpecHasTargetValue Value Not Initial if Set Show values
InspSpecHasUpperLimit Boolean Variable (X = True, - = False, Space = Unknown) Show values
InspSpecIsMeasuredValueRqd Measured Values Must Be Recorded Show values
InspSpecSummarizedDcmlPlaces Number of Places to the Right of a Decimal Point (Accuracy) Show values
InspectionResultAttribute Attribute of the Results Record (Valid, Invalid,...) Show values
InspectionResultHasLongText Inspection Characteristic Long Text Exists Show values
InspectionValuationResult Inspection Result Valuation Show values
InspSpecIsSelectedSetRequired Reference to Characteristic Attribute Required Show values
InspSpecHasControlChart SPC Characteristic Show values
InspSpecHasSamplingProcedure Sampling Procedure Is Required Show values
InspectionResultHasMeanValue Value Not Initial if Set Show values
InspSpecInspectedIsEnabled Boolean Variable (X = True, - = False, Space = Unknown) Show values
InspSpecNonConformingIsEnabled Boolean Variable (X = True, - = False, Space = Unknown) Show values
NrOfRsltsAboveIsVisible Boolean Variable (X = True, - = False, Space = Unknown) Show values
NrOfRsltsBelowIsVisible Boolean Variable (X = True, - = False, Space = Unknown) Show values
InspCharcIsNotPlanned Unplanned Characteristic Show values
InspSpecIsDefectsRecgAutomatic Defects Recording Automatically Called Up Show values
Column Name Description Domain name
ShopFloorItemExternalID Shop Floor Item Number (External Identifier)
ManufacturingOrder Manufacturing Order ID AUFNR
OperationActivity Identifies an Operation Activity MPE_OAN_ELEMENT_ID
ProductionOrderOpActyVers Number of an Operation Actiivity Version
CharacteristicAttributeCode Code QCODE
CharacteristicAttributeCodeGrp Code Group QCODEGRP
InspCharacteristicSampleSize Sample Size that Has to Be Inspected for a Characteristic QANZAHL4
InspLotTestEquipInternalID Assigned Test Equipment PZLFH
InspResultValidValuesNumber Number of Inspected Sample Units QANZAHL2
InspResultValueCount null
InspectionNonconformingRatio null
InspRsltBelowToleranceValsNmbr Number of Measured Values Below Tolerance Range QANZAHL2
InspRsltAboveToleranceValsNmbr Number of Measured Values Above Tolerance Range QANZAHL2
InspRsltNonconformingValsNmbr Number of Nonconforming Sample Units QANZAHL2
InspSampleAcceptanceNumber Acceptance Number QINT2NEG
InspSampleRejectionNumber Rejection Number QANZAHL2
InspSpecCharcCategory null
InspSpecControlIndicators Cntrl Indicator String for Insp. Char./Master Insp. Char. QMKCONTROL
InspSpecImportanceCodeText Short Text QKURZTEXT
InspSpecIsLongTermInspection null
InspSpecIsQuantitative null
InspSpecLowerLimit Lower Specification Limit QSOLLWERTE
InspSpecRecordingType null
InspSpecResultCalculation null
InspSpecSampleQuantityFactor Sample Quantity Factor for Sample(Mult. Sample Unit of Msr.) QPROBEFAK
InspSpecTargetValue Target Value for a Quantitative Characteristic QSOLLWERTE
InspSpecUpperLimit Upper Specification Limit QSOLLWERTE
InspectionMethodText Short Text QKURZTEXT
InspectionMethodVersion Version Number of Inspection Method QVERSNR
InspectionOperation Operation/Activity Number VORNR
InspectionResultMeanValue Arithmetic Mean of Valid Measured Values QSTATWERT
InspectionResultStatusText Inspection Result Status Text QKURZTEXT
InspectionResultStatus Specification Record Status QSTATUS
InspectionResultText Inspection Description for Sample Result QKURZTEXT
InspectionSampleSize Sample Size that Must Be Inspected QANZAHL4
InspectionSpecificationPlant Plant for Master Inspection Characteristic QZAEHLER
InspectionSpecificationText Short Text for Inspection Characteristic QKURZTEXT
InspectionSpecificationVersion Version Number of Master Inspection Characteristic QVERSNR
InspectionValuationResultText Inspection Result Valuation Text DDTEXT
LastChangedByUser Name of User Who Last Changed Data Record QAENDERER
SelectedCodeSet Assigned Code Group or Selected Set QCGRAUSW
SelectedCodeSetText Short Description of Selected Set QKURZTEXT
UnitOfMeasureTechnicalName External Unit of Measurement in Technical Format (6-Char.) MSEH6
WorkCenter Work Center ARBPL
OpActyNtwkElement Internal OAN Element Number
OpActyNtwkInstance Operation Activity Network: Instance ID
BOOCharcGroup Characteristic Group QCHARGROUP
BOOCharcGroupDivision Internal Division ID QDIVISIONINT
BOOCharcSourceCharc Source Characteristic of Characteristic Group Division QMERKNRP
InspCharcGrpDesc Characteristic Group Description TEXT40
InspCharcGrpDivnCnt Number of Characteristic Divisions QDIVISIONNO
InspCharcGrpDivnDesc Division Description TEXT40
InspCharcGrpDivnExt Division ID QDIVISIONEXT
OpActyCharcDivnSqnc Division Sequence Number MPE_SEQUENCE_NO
OpActyCharcGrpSqnc Group Column Number MPE_SEQUENCE_NO
OpActyCharacteristicItem Characteristic Item Number MPE_ITEM_NO
InspRsltRecgViewTemplate null
BOOOpBOMItemInternalID No. for material comp. allocation to task list KNTNR
DgtlMockUpCharcsUUID Internal Identification for DMU Objects of Type RAW 16 DMU_GUID16
MaterialName Material Description TEXT40
ReferenceDesignatorValue Reference Designator CHAR128
Master Data Relations Join Conditions
Sample Unit of Measure
  • Client
  • Sample Unit of Measure
  • Sample Unit of Measure
  • C_SFIPLANINSPCHARINFO.MANDT == T006.MANDT
  • C_SFIPLANINSPCHARINFO.INSPCHARACTERISTICSAMPLEUNIT == T006.MSEHI
  • C_SFIPLANINSPCHARINFO.QUANTITYUNIT == T006.MSEHI
Inspection Type
  • Client
  • Inspection Type
  • C_SFIPLANINSPCHARINFO.MANDT == TQ30.MANDT
  • C_SFIPLANINSPCHARINFO.INSPECTIONLOTTYPE == TQ30.ART
Inspection Method
  • Client
  • Version Number of Inspection Method
  • Inspection Method
  • Plant for Inspection Method
  • C_SFIPLANINSPCHARINFO.MANDT == QMTB.MANDT
  • C_SFIPLANINSPCHARINFO.INSPECTIONMETHODVERSION == QMTB.VERSION
  • C_SFIPLANINSPCHARINFO.INSPECTIONMETHOD == QMTB.PMTNR
  • C_SFIPLANINSPCHARINFO.INSPECTIONMETHODPLANT == QMTB.WERKS
Plant for Inspection Method
  • Client
  • Plant for Inspection Method
  • C_SFIPLANINSPCHARINFO.MANDT == T001W.MANDT
  • C_SFIPLANINSPCHARINFO.INSPECTIONMETHODPLANT == T001W.WERKS
Master Inspection Characteristic
  • Client
  • Version Number of Inspection Method
  • Plant for Master Inspection Characteristic
  • Master Inspection Characteristic
  • C_SFIPLANINSPCHARINFO.MANDT == QPMK.MANDT
  • C_SFIPLANINSPCHARINFO.INSPECTIONMETHODVERSION == QPMK.VERSION
  • C_SFIPLANINSPCHARINFO.INSPECTIONSPECIFICATIONPLANT == QPMK.ZAEHLER
  • C_SFIPLANINSPCHARINFO.INSPECTIONSPECIFICATION == QPMK.MKMNR
Unit of Measurement in Which Quantitative Data Is Stored
  • Client
  • Unit of Measurement in Which Quantitative Data Is Stored
  • C_SFIPLANINSPCHARINFO.MANDT == T006.MANDT
  • C_SFIPLANINSPCHARINFO.INSPECTIONSPECIFICATIONUNIT == T006.MSEHI
Valuation Rule
  • Valuation Rule
  • Client
  • C_SFIPLANINSPCHARINFO.INSPSAMPLEVALUATIONRULE == QDFM.FBKEY
  • C_SFIPLANINSPCHARINFO.MANDT == QDFM.MANDT
Material Number
  • Material Number
  • Client
  • C_SFIPLANINSPCHARINFO.MATERIAL == MARA.MATNR
  • C_SFIPLANINSPCHARINFO.MANDT == MARA.MANDT
Material Authorization Group for Activities in QM
  • Client
  • Material Authorization Group for Activities in QM
  • C_SFIPLANINSPCHARINFO.MANDT == TQ01B.MANDT
  • C_SFIPLANINSPCHARINFO.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
Plant
  • Client
  • Plant
  • C_SFIPLANINSPCHARINFO.MANDT == T001W.MANDT
  • C_SFIPLANINSPCHARINFO.PLANT == T001W.WERKS
SPC Criterion
  • Client
  • SPC Criterion
  • C_SFIPLANINSPCHARINFO.MANDT == QPSP.MANDT
  • C_SFIPLANINSPCHARINFO.QLTYCTRLCHARTAGGRGNCRITERION == QPSP.SPCKRIT
Sample Unit of Measure
  • Client
  • Sample Unit of Measure
  • Sample Unit of Measure
  • C_SFIPLANINSPCHARINFO.MANDT == T006.MANDT
  • C_SFIPLANINSPCHARINFO.INSPCHARACTERISTICSAMPLEUNIT == T006.MSEHI
  • C_SFIPLANINSPCHARINFO.QUANTITYUNIT == T006.MSEHI