I_INSPSPECIFICATIONVERSION

CDS View
86 Fields 17 CDS Views

Version of Master Insp Characteristic

I_INSPSPECIFICATIONVERSION is a CDS View in S/4HANA. Version of Master Insp Characteristic. It contains 86 fields. 17 CDS views read from this table.

CDS Views using this table (17)

ViewTypeJoinVDMDescription
A_AssgmtInspMethInspSpec view inner BASIC Assignmt Inspection Specification-Method
A_InspectionSpecification view from COMPOSITE Master Inspection Characteristics
C_InspLotOpUnplndCharcRsltRecg view from CONSUMPTION Unplanned Characteristic
C_InspSpecVersionsObjPage view from CONSUMPTION Inspection Specification Versions
C_InspSpecVH view from CONSUMPTION Value-Help for Inspection Specification
C_Qm_Mic_F4 view from CONSUMPTION Master Inspection Characteristics
C_Qm_Mic_Methods view from CONSUMPTION Methods assigned to Master Inspection Characteristics
C_UnplndInspCharcRsltRecg view from CONSUMPTION Unplanned Characteristics in Rslt Recg
ESH_N_MASTERINSPCHAR view from
I_InspMethInspSpec view from COMPOSITE Master Charcs. of Inspection Method
I_Inspspecificationfieldctrlex view from COMPOSITE Inspection Spec. Field Ctrl. Extn.
I_InspSpecificationFldCtrlCstm view from COMPOSITE Master Insp. Charc Field Control Custom
I_InspSpecificationVersionTP view_entity from TRANSACTIONAL Master Inspection Characteristic
I_InspSpecificationVersionVH view from COMPOSITE Master Inspection Characteristic Version
I_InspSpecVersReldVH view from COMPOSITE Insp Specification Released Versions VH
I_ProdnRtgVersInspSpecVH view from COMPOSITE MIC Value Help
P_InspSpecificationFieldCtrl view from COMPOSITE

Fields (86)

KeyField CDS FieldsUsed in Views
KEY InspectionSpecification InspectionSpecification 8
KEY InspectionSpecificationPlant InspectionSpecificationPlant 7
KEY InspectionSpecificationVersion InspectionSpecificationVersion 8
KEY Plant Plant 3
_InspSpecCharcType _InspSpecCharcType 1
_InspSpecificationPlant _InspSpecificationPlant 1
_InspSpecStatus _InspSpecStatus 1
_Text _InspSpecVersionText 1
ChangedDateTime ChangedDateTime 1
CharcInternalID CharacteristicInternalID,CharcInternalID 1
DefectFractionEstimationProced DefectFractionEstimationProced 2
InspectionScope InspectionScope 2
InspectionSpecificationSrchTxt InspectionSpecificationSrchTxt 2
InspectionSpecificationStatus InspectionSpecificationStatus 6
InspectionSpecificationUnit InspectionSpecificationUnit 2
InspectorQualification InspectorQualification 2
InspResultIsDocumentationRqd InspResultIsDocumentationRqd 2
InspSpecChangeDate InspSpecChangeDate 2
InspSpecChangedByUser InspSpecChangedByUser 2
InspSpecCharacteristicType InspSpecCharacteristicType 3
InspSpecCharcCategory InspSpecCharcCategory 2
InspSpecControlIndicators InspSpecControlIndicators 2
InspSpecCreatedByUser InspSpecCreatedByUser 2
InspSpecCreationDate InspSpecCreationDate 2
InspSpecDecimalPlaces InspSpecDecimalPlaces 2
InspSpecDefectCodeGrpRejection InspSpecDefectCodeGrpRejection 2
InspSpecDefectCodeGrpRjcnLower InspSpecDefectCodeGrpRjcnLower 2
InspSpecDefectCodeGrpRjcnUpper InspSpecDefectCodeGrpRjcnUpper 2
InspSpecDefectCodeRejection InspSpecDefectCodeRejection 2
InspSpecDefectCodeRjcnLower InspSpecDefectCodeRjcnLower 2
InspSpecDefectCodeRjcnUpper InspSpecDefectCodeRjcnUpper 2
InspSpecDeterminationRule InspSpecDeterminationRule 1
InspSpecFirstLowerSpecLimit InspSpecFirstLowerSpecLimit 2
InspSpecFirstUpperSpecLimit InspSpecFirstUpperSpecLimit 2
InspSpecGlobalName InspSpecGlobalName 2
InspSpecHasFirstLowerSpecLimit InspSpecHasFirstLowerSpecLimit 2
InspSpecHasFirstUpperSpecLimit InspSpecHasFirstUpperSpecLimit 2
InspSpecHasFixedCtrlIndicators InspSpecHasFixedCtrlIndicators 1
InspSpecHasLowerLimit InspSpecHasLowerLimit 2
InspSpecHasLowrPlausibilityLmt InspSpecHasLowrPlausibilityLmt 2
InspSpecHasLowrSpecLimitChange InspSpecHasLowrSpecLimitChange 2
InspSpecHasSecondLowrSpecLimit InspSpecHasSecondLowrSpecLimit 2
InspSpecHasSecondUprSpecLimit InspSpecHasSecondUprSpecLimit 2
InspSpecHasTargetValue InspSpecHasTargetValue 2
InspSpecHasUpperLimit InspSpecHasUpperLimit 2
InspSpecHasUprPlausibilityLmt InspSpecHasUprPlausibilityLmt 2
InspSpecHasUprSpecLimitChange InspSpecHasUprSpecLimitChange 2
InspSpecImportanceCode InspSpecImportanceCode 2
InspSpecInformationField1 InspSpecInformationField1 2
InspSpecInformationField2 InspSpecInformationField2 2
InspSpecInformationField3 InspSpecInformationField3 2
InspSpecIsChgDocRequired InspSpecIsChgDocRequired 2
InspSpecIsControlChartUsed InspSpecIsControlChartUsed 2
InspSpecIsDefectRecordingRqd InspSpecIsDefectRecordingRqd 1
InspSpecIsDefectsRecgAutomatic InspSpecIsDefectsRecgAutomatic 2
InspSpecIsDestructive InspSpecIsDestructive 2
InspSpecIsDetnRuleActive InspSpecIsDetnRuleActive 1
InspSpecIsLongTermInspection InspSpecIsLongTermInspection 2
InspSpecIsLowerLimitRequired InspSpecIsLowerLimitRequired 2
InspSpecIsMeasuredValueRqd InspSpecIsMeasuredValueRqd 2
InspSpecIsQuantitative InspSpecIsQuantitative 2
InspSpecIsSampleQtyAdditive InspSpecIsSampleQtyAdditive 2
InspSpecIsSamplingProcedRqd InspSpecIsSamplingProcedRqd 2
InspSpecIsScrapRelevant InspSpecIsScrapRelevant 2
InspSpecIsSelectedSetRequired InspSpecIsSelectedSetRequired 2
InspSpecIsTargetValueInLimit InspSpecIsTargetValueInLimit 2
InspSpecIsTestEquipmentRqd InspSpecIsTestEquipmentRqd 2
InspSpecIsUpperLimitRequired InspSpecIsUpperLimitRequired 2
InspSpecLowerLimit InspSpecLowerLimit 2
InspSpecLowerPlausibilityLimit InspSpecLowerPlausibilityLimit 2
InspSpecLowerSpecLimitChange InspSpecLowerSpecLimitChange 2
InspSpecPrintControl InspSpecPrintControl 2
InspSpecRecordingType InspSpecRecordingType 2
InspSpecResultCalculation InspSpecResultCalculation 2
InspSpecSecondLowerSpecLimit InspSpecSecondLowerSpecLimit 2
InspSpecSecondUpperSpecLimit InspSpecSecondUpperSpecLimit 2
InspSpecTargetValue InspSpecTargetValue 2
InspSpecToleranceChgValidFrom InspSpecToleranceChgValidFrom 2
InspSpecToleranceChgValidTo InspSpecToleranceChgValidTo 2
InspSpecTransferType InspSpecTransferType 3
InspSpecUpperLimit InspSpecUpperLimit 2
InspSpecUpperPlausibilityLimit InspSpecUpperPlausibilityLimit 2
InspSpecUpperSpecLimitChange InspSpecUpperSpecLimitChange 2
InspToleranceSpecification InspToleranceSpecification 2
QltyMstrDataAuthorizationGroup QltyMstrDataAuthorizationGroup 5
ValidityStartDate ValidityStartDate 3

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Version of Master Insp Characteristic
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_INSPSPECIFICATIONVERSION (
    INSPECTIONSPECIFICATION,
    INSPECTIONSPECIFICATIONPLANT,
    INSPECTIONSPECIFICATIONVERSION,
    PLANT,
    _INSPSPECCHARCTYPE,
    _INSPSPECIFICATIONPLANT,
    _INSPSPECSTATUS,
    _TEXT,
    CHANGEDDATETIME,
    CHARCINTERNALID,
    DEFECTFRACTIONESTIMATIONPROCED,
    INSPECTIONSCOPE,
    INSPECTIONSPECIFICATIONSRCHTXT,
    INSPECTIONSPECIFICATIONSTATUS,
    INSPECTIONSPECIFICATIONUNIT,
    INSPECTORQUALIFICATION,
    INSPRESULTISDOCUMENTATIONRQD,
    INSPSPECCHANGEDATE,
    INSPSPECCHANGEDBYUSER,
    INSPSPECCHARACTERISTICTYPE,
    INSPSPECCHARCCATEGORY,
    INSPSPECCONTROLINDICATORS,
    INSPSPECCREATEDBYUSER,
    INSPSPECCREATIONDATE,
    INSPSPECDECIMALPLACES,
    INSPSPECDEFECTCODEGRPREJECTION,
    INSPSPECDEFECTCODEGRPRJCNLOWER,
    INSPSPECDEFECTCODEGRPRJCNUPPER,
    INSPSPECDEFECTCODEREJECTION,
    INSPSPECDEFECTCODERJCNLOWER,
    INSPSPECDEFECTCODERJCNUPPER,
    INSPSPECDETERMINATIONRULE,
    INSPSPECFIRSTLOWERSPECLIMIT,
    INSPSPECFIRSTUPPERSPECLIMIT,
    INSPSPECGLOBALNAME,
    INSPSPECHASFIRSTLOWERSPECLIMIT,
    INSPSPECHASFIRSTUPPERSPECLIMIT,
    INSPSPECHASFIXEDCTRLINDICATORS,
    INSPSPECHASLOWERLIMIT,
    INSPSPECHASLOWRPLAUSIBILITYLMT,
    INSPSPECHASLOWRSPECLIMITCHANGE,
    INSPSPECHASSECONDLOWRSPECLIMIT,
    INSPSPECHASSECONDUPRSPECLIMIT,
    INSPSPECHASTARGETVALUE,
    INSPSPECHASUPPERLIMIT,
    INSPSPECHASUPRPLAUSIBILITYLMT,
    INSPSPECHASUPRSPECLIMITCHANGE,
    INSPSPECIMPORTANCECODE,
    INSPSPECINFORMATIONFIELD1,
    INSPSPECINFORMATIONFIELD2,
    INSPSPECINFORMATIONFIELD3,
    INSPSPECISCHGDOCREQUIRED,
    INSPSPECISCONTROLCHARTUSED,
    INSPSPECISDEFECTRECORDINGRQD,
    INSPSPECISDEFECTSRECGAUTOMATIC,
    INSPSPECISDESTRUCTIVE,
    INSPSPECISDETNRULEACTIVE,
    INSPSPECISLONGTERMINSPECTION,
    INSPSPECISLOWERLIMITREQUIRED,
    INSPSPECISMEASUREDVALUERQD,
    INSPSPECISQUANTITATIVE,
    INSPSPECISSAMPLEQTYADDITIVE,
    INSPSPECISSAMPLINGPROCEDRQD,
    INSPSPECISSCRAPRELEVANT,
    INSPSPECISSELECTEDSETREQUIRED,
    INSPSPECISTARGETVALUEINLIMIT,
    INSPSPECISTESTEQUIPMENTRQD,
    INSPSPECISUPPERLIMITREQUIRED,
    INSPSPECLOWERLIMIT,
    INSPSPECLOWERPLAUSIBILITYLIMIT,
    INSPSPECLOWERSPECLIMITCHANGE,
    INSPSPECPRINTCONTROL,
    INSPSPECRECORDINGTYPE,
    INSPSPECRESULTCALCULATION,
    INSPSPECSECONDLOWERSPECLIMIT,
    INSPSPECSECONDUPPERSPECLIMIT,
    INSPSPECTARGETVALUE,
    INSPSPECTOLERANCECHGVALIDFROM,
    INSPSPECTOLERANCECHGVALIDTO,
    INSPSPECTRANSFERTYPE,
    INSPSPECUPPERLIMIT,
    INSPSPECUPPERPLAUSIBILITYLIMIT,
    INSPSPECUPPERSPECLIMITCHANGE,
    INSPTOLERANCESPECIFICATION,
    QLTYMSTRDATAAUTHORIZATIONGROUP,
    VALIDITYSTARTDATE,
    PRIMARY KEY (INSPECTIONSPECIFICATION, INSPECTIONSPECIFICATIONPLANT, INSPECTIONSPECIFICATIONVERSION, PLANT)
);

Learn More