I_PRODNRTGINSPCHARCSASSGMT
Inspection Characteristics Assignment
I_PRODNRTGINSPCHARCSASSGMT is a CDS View in S/4HANA. Inspection Characteristics Assignment. It contains 128 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_ProdnRtgOpInspCharcsToOp | view_entity | from | COMPOSITE | Prodn Rtg Inspection Charcs to Operation |
| R_ProdnRtgInspCharcsAssgmtTP | view_entity | from | TRANSACTIONAL | Inspection Characteristics Assignment |
| R_ProdnRtgInspCharcsAssgmtTP_2 | view_entity | from | TRANSACTIONAL | Inspection Characteristics Assignment |
Fields (128)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | BillOfOperationsGroup | ProductionRoutingGroup | 2 |
| KEY | BillOfOperationsSequence | ProductionRoutingSequence | 2 |
| KEY | BillOfOperationsVariant | ProductionRouting | 2 |
| KEY | BOOCharacteristic | BOOCharacteristic | 2 |
| KEY | BOOCharacteristicVersion | BOOCharacteristicVersion | 2 |
| KEY | BOOOperationInternalID | ProductionRoutingOpIntID | 2 |
| BillOfOperationsVersion | BillOfOperationsVersion | 1 | |
| BOOCharcGroup | BOOCharcGroup | 1 | |
| BOOCharcGroupDivision | BOOCharcGroupDivision | 1 | |
| BOOCharcHasInspSpecReference | BOOCharcHasInspSpecReference | 1 | |
| BOOCharcSampleQuantity | BOOCharcSampleQuantity | 1 | |
| BOOCharcSourceCharc | BOOCharcSourceCharc | 1 | |
| BOOOperationPRTInternalID | BOOOperationPRTInternalID | 1 | |
| ChangeNumber | ChangeNumber | 1 | |
| CreatedByUser | CreatedByUser | 1 | |
| CreationDate | CreationDate | 1 | |
| CustIsConsideredForDynModif | CustIsConsideredForDynModif | 1 | |
| InspCharacteristicSampleUnit | InspCharacteristicSampleUnit | 1 | |
| InspCharcDynModifRef | InspCharcDynModifRef | 1 | |
| InspectionMethod | InspectionMethod | 1 | |
| InspectionMethodPlant | InspectionMethodPlant | 1 | |
| InspectionMethodVersion | InspectionMethodVersion | 1 | |
| InspectionScope | InspectionScope | 1 | |
| InspectionSpecification | InspectionSpecification | 1 | |
| InspectionSpecificationPlant | InspectionSpecificationPlant | 1 | |
| InspectionSpecificationText | InspectionSpecificationText | 1 | |
| InspectionSpecificationUnit | InspectionSpecificationUnit | 1 | |
| InspectionSpecificationVersion | InspectionSpecificationVersion | 1 | |
| InspectorQualification | InspectorQualification | 1 | |
| InspLotDynamicRule | InspLotDynamicRule | 1 | |
| InspResultIsDocumentationRqd | InspResultIsDocumentationRqd | 1 | |
| InspSpecAdditionalCatalog2 | InspSpecAdditionalCatalog2 | 1 | |
| InspSpecAdditionalCatalog3 | InspSpecAdditionalCatalog3 | 1 | |
| InspSpecAdditionalCatalog4 | InspSpecAdditionalCatalog4 | 1 | |
| InspSpecAdditionalCatalog5 | InspSpecAdditionalCatalog5 | 1 | |
| InspSpecAdditionalCodeGroup2 | InspSpecAdditionalCodeGroup2 | 1 | |
| InspSpecAdditionalCodeGroup3 | InspSpecAdditionalCodeGroup3 | 1 | |
| InspSpecAdditionalCodeGroup4 | InspSpecAdditionalCodeGroup4 | 1 | |
| InspSpecAdditionalCodeGroup5 | InspSpecAdditionalCodeGroup5 | 1 | |
| InspSpecAdditionalSelectedSet2 | InspSpecAdditionalSelectedSet2 | 1 | |
| InspSpecAdditionalSelectedSet3 | InspSpecAdditionalSelectedSet3 | 1 | |
| InspSpecAdditionalSelectedSet4 | InspSpecAdditionalSelectedSet4 | 1 | |
| InspSpecAdditionalSelectedSet5 | InspSpecAdditionalSelectedSet5 | 1 | |
| InspSpecAddlSeldCodeSetPlant2 | InspSpecAddlSeldCodeSetPlant2 | 1 | |
| InspSpecAddlSeldCodeSetPlant3 | InspSpecAddlSeldCodeSetPlant3 | 1 | |
| InspSpecAddlSeldCodeSetPlant4 | InspSpecAddlSeldCodeSetPlant4 | 1 | |
| InspSpecAddlSeldCodeSetPlant5 | InspSpecAddlSeldCodeSetPlant5 | 1 | |
| InspSpecCharcCategory | InspSpecCharcCategory | 1 | |
| InspSpecClassMidpointQty | InspSpecClassMidpointQty | 1 | |
| InspSpecClassWidthQty | InspSpecClassWidthQty | 1 | |
| InspSpecControlIndicators | InspSpecControlIndicators | 1 | |
| InspSpecDecimalPlaces | InspSpecDecimalPlaces | 1 | |
| InspSpecDefectCodeGrpRejection | InspSpecDefectCodeGrpRejection | 1 | |
| InspSpecDefectCodeGrpRjcnLower | InspSpecDefectCodeGrpRjcnLower | 1 | |
| InspSpecDefectCodeGrpRjcnUpper | InspSpecDefectCodeGrpRjcnUpper | 1 | |
| InspSpecDefectCodeRejection | InspSpecDefectCodeRejection | 1 | |
| InspSpecDefectCodeRjcnLower | InspSpecDefectCodeRjcnLower | 1 | |
| InspSpecDefectCodeRjcnUpper | InspSpecDefectCodeRjcnUpper | 1 | |
| InspSpecFirstLowerSpecLimit | InspSpecFirstLowerSpecLimit | 1 | |
| InspSpecFirstUpperSpecLimit | InspSpecFirstUpperSpecLimit | 1 | |
| InspSpecFormula1 | InspSpecFormula1 | 1 | |
| InspSpecFormula2 | InspSpecFormula2 | 1 | |
| InspSpecHasClassMidpoint | InspSpecHasClassMidpoint | 1 | |
| InspSpecHasClassWidth | InspSpecHasClassWidth | 1 | |
| InspSpecHasFirstLowerSpecLimit | InspSpecHasFirstLowerSpecLimit | 1 | |
| InspSpecHasFirstUpperSpecLimit | InspSpecHasFirstUpperSpecLimit | 1 | |
| InspSpecHasFixedCtrlIndicators | InspSpecHasFixedCtrlIndicators | 1 | |
| InspSpecHasFormula | InspSpecHasFormula | 1 | |
| InspSpecHasLowerLimit | InspSpecHasLowerLimit | 1 | |
| InspSpecHasLowrPlausibilityLmt | InspSpecHasLowrPlausibilityLmt | 1 | |
| InspSpecHasLowrSpecLimitChange | InspSpecHasLowrSpecLimitChange | 1 | |
| InspSpecHasNoFormula | InspSpecHasNoFormula | 1 | |
| InspSpecHasSecondLowrSpecLimit | InspSpecHasSecondLowrSpecLimit | 1 | |
| InspSpecHasSecondUprSpecLimit | InspSpecHasSecondUprSpecLimit | 1 | |
| InspSpecHasTargetValue | InspSpecHasTargetValue | 1 | |
| InspSpecHasUpperLimit | InspSpecHasUpperLimit | 1 | |
| InspSpecHasUprPlausibilityLmt | InspSpecHasUprPlausibilityLmt | 1 | |
| InspSpecHasUprSpecLimitChange | InspSpecHasUprSpecLimitChange | 1 | |
| InspSpecImportanceCode | InspSpecImportanceCode | 1 | |
| InspSpecInformationField1 | InspSpecInformationField1 | 1 | |
| InspSpecInformationField2 | InspSpecInformationField2 | 1 | |
| InspSpecInformationField3 | InspSpecInformationField3 | 1 | |
| InspSpecInputProcedure | InspSpecInputProcedure | 1 | |
| InspSpecIsChgDocRequired | InspSpecIsChgDocRequired | 1 | |
| InspSpecIsControlChartUsed | InspSpecIsControlChartUsed | 1 | |
| InspSpecIsDefectRecordingRqd | InspSpecIsDefectRecordingRqd | 1 | |
| InspSpecIsDefectsRecgAutomatic | InspSpecIsDefectsRecgAutomatic | 1 | |
| InspSpecIsDestructive | InspSpecIsDestructive | 1 | |
| InspSpecIsLongTermInspection | InspSpecIsLongTermInspection | 1 | |
| InspSpecIsLowerLimitRequired | InspSpecIsLowerLimitRequired | 1 | |
| InspSpecIsMeasuredValueRqd | InspSpecIsMeasuredValueRqd | 1 | |
| InspSpecIsQualitative | InspSpecIsQualitative | 1 | |
| InspSpecIsQuantitative | InspSpecIsQuantitative | 1 | |
| InspSpecIsSampleQtyAdditive | InspSpecIsSampleQtyAdditive | 1 | |
| InspSpecIsSamplingProcedRqd | InspSpecIsSamplingProcedRqd | 1 | |
| InspSpecIsScrapRelevant | InspSpecIsScrapRelevant | 1 | |
| InspSpecIsSelectedSetRequired | InspSpecIsSelectedSetRequired | 1 | |
| InspSpecIsTargetValueInLimit | InspSpecIsTargetValueInLimit | 1 | |
| InspSpecIsTestEquipmentRqd | InspSpecIsTestEquipmentRqd | 1 | |
| InspSpecIsUpperLimitRequired | InspSpecIsUpperLimitRequired | 1 | |
| InspSpecLowerLimit | InspSpecLowerLimit | 1 | |
| InspSpecLowerPlausibilityLimit | InspSpecLowerPlausibilityLimit | 1 | |
| InspSpecLowerSpecLimitChange | InspSpecLowerSpecLimitChange | 1 | |
| InspSpecNumberOfClasses | InspSpecNumberOfClasses | 1 | |
| InspSpecPrintControl | InspSpecPrintControl | 1 | |
| InspSpecRecordingType | InspSpecRecordingType | 1 | |
| InspSpecResultCalculation | InspSpecResultCalculation | 1 | |
| InspSpecSecondLowerSpecLimit | InspSpecSecondLowerSpecLimit | 1 | |
| InspSpecSecondUpperSpecLimit | InspSpecSecondUpperSpecLimit | 1 | |
| InspSpecTargetValue | InspSpecTargetValue | 1 | |
| InspSpecToleranceChgValidFrom | InspSpecToleranceChgValidFrom | 1 | |
| InspSpecToleranceChgValidTo | InspSpecToleranceChgValidTo | 1 | |
| InspSpecUpperLimit | InspSpecUpperLimit | 1 | |
| InspSpecUpperPlausibilityLimit | InspSpecUpperPlausibilityLimit | 1 | |
| InspSpecUpperSpecLimitChange | InspSpecUpperSpecLimitChange | 1 | |
| InspToleranceSpecification | InspToleranceSpecification | 1 | |
| IsDeleted | IsDeleted | 1 | |
| LastChangeDate | LastChangeDate | 1 | |
| LastChangedByUser | LastChangedByUser | 1 | |
| MatlIsConsideredForDynModif | MatlIsConsideredForDynModif | 1 | |
| MfrIsConsideredForDynModif | MfrIsConsideredForDynModif | 1 | |
| QltyCtrlChartAggrgnCriterion | QltyCtrlChartAggrgnCriterion | 1 | |
| SamplingProcedure | SamplingProcedure | 1 | |
| SelectedCodeSet | SelectedCodeSet | 1 | |
| SelectedCodeSetPlant | SelectedCodeSetPlant | 1 | |
| SuplrIsConsideredForDynModif | SuplrIsConsideredForDynModif | 1 | |
| ValidityEndDate | ValidityEndDate | 1 | |
| ValidityStartDate | ValidityStartDate | 1 |
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.
-- Inspection Characteristics Assignment
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PRODNRTGINSPCHARCSASSGMT (
BILLOFOPERATIONSGROUP,
BILLOFOPERATIONSSEQUENCE,
BILLOFOPERATIONSVARIANT,
BOOCHARACTERISTIC,
BOOCHARACTERISTICVERSION,
BOOOPERATIONINTERNALID,
BILLOFOPERATIONSVERSION,
BOOCHARCGROUP,
BOOCHARCGROUPDIVISION,
BOOCHARCHASINSPSPECREFERENCE,
BOOCHARCSAMPLEQUANTITY,
BOOCHARCSOURCECHARC,
BOOOPERATIONPRTINTERNALID,
CHANGENUMBER,
CREATEDBYUSER,
CREATIONDATE,
CUSTISCONSIDEREDFORDYNMODIF,
INSPCHARACTERISTICSAMPLEUNIT,
INSPCHARCDYNMODIFREF,
INSPECTIONMETHOD,
INSPECTIONMETHODPLANT,
INSPECTIONMETHODVERSION,
INSPECTIONSCOPE,
INSPECTIONSPECIFICATION,
INSPECTIONSPECIFICATIONPLANT,
INSPECTIONSPECIFICATIONTEXT,
INSPECTIONSPECIFICATIONUNIT,
INSPECTIONSPECIFICATIONVERSION,
INSPECTORQUALIFICATION,
INSPLOTDYNAMICRULE,
INSPRESULTISDOCUMENTATIONRQD,
INSPSPECADDITIONALCATALOG2,
INSPSPECADDITIONALCATALOG3,
INSPSPECADDITIONALCATALOG4,
INSPSPECADDITIONALCATALOG5,
INSPSPECADDITIONALCODEGROUP2,
INSPSPECADDITIONALCODEGROUP3,
INSPSPECADDITIONALCODEGROUP4,
INSPSPECADDITIONALCODEGROUP5,
INSPSPECADDITIONALSELECTEDSET2,
INSPSPECADDITIONALSELECTEDSET3,
INSPSPECADDITIONALSELECTEDSET4,
INSPSPECADDITIONALSELECTEDSET5,
INSPSPECADDLSELDCODESETPLANT2,
INSPSPECADDLSELDCODESETPLANT3,
INSPSPECADDLSELDCODESETPLANT4,
INSPSPECADDLSELDCODESETPLANT5,
INSPSPECCHARCCATEGORY,
INSPSPECCLASSMIDPOINTQTY,
INSPSPECCLASSWIDTHQTY,
INSPSPECCONTROLINDICATORS,
INSPSPECDECIMALPLACES,
INSPSPECDEFECTCODEGRPREJECTION,
INSPSPECDEFECTCODEGRPRJCNLOWER,
INSPSPECDEFECTCODEGRPRJCNUPPER,
INSPSPECDEFECTCODEREJECTION,
INSPSPECDEFECTCODERJCNLOWER,
INSPSPECDEFECTCODERJCNUPPER,
INSPSPECFIRSTLOWERSPECLIMIT,
INSPSPECFIRSTUPPERSPECLIMIT,
INSPSPECFORMULA1,
INSPSPECFORMULA2,
INSPSPECHASCLASSMIDPOINT,
INSPSPECHASCLASSWIDTH,
INSPSPECHASFIRSTLOWERSPECLIMIT,
INSPSPECHASFIRSTUPPERSPECLIMIT,
INSPSPECHASFIXEDCTRLINDICATORS,
INSPSPECHASFORMULA,
INSPSPECHASLOWERLIMIT,
INSPSPECHASLOWRPLAUSIBILITYLMT,
INSPSPECHASLOWRSPECLIMITCHANGE,
INSPSPECHASNOFORMULA,
INSPSPECHASSECONDLOWRSPECLIMIT,
INSPSPECHASSECONDUPRSPECLIMIT,
INSPSPECHASTARGETVALUE,
INSPSPECHASUPPERLIMIT,
INSPSPECHASUPRPLAUSIBILITYLMT,
INSPSPECHASUPRSPECLIMITCHANGE,
INSPSPECIMPORTANCECODE,
INSPSPECINFORMATIONFIELD1,
INSPSPECINFORMATIONFIELD2,
INSPSPECINFORMATIONFIELD3,
INSPSPECINPUTPROCEDURE,
INSPSPECISCHGDOCREQUIRED,
INSPSPECISCONTROLCHARTUSED,
INSPSPECISDEFECTRECORDINGRQD,
INSPSPECISDEFECTSRECGAUTOMATIC,
INSPSPECISDESTRUCTIVE,
INSPSPECISLONGTERMINSPECTION,
INSPSPECISLOWERLIMITREQUIRED,
INSPSPECISMEASUREDVALUERQD,
INSPSPECISQUALITATIVE,
INSPSPECISQUANTITATIVE,
INSPSPECISSAMPLEQTYADDITIVE,
INSPSPECISSAMPLINGPROCEDRQD,
INSPSPECISSCRAPRELEVANT,
INSPSPECISSELECTEDSETREQUIRED,
INSPSPECISTARGETVALUEINLIMIT,
INSPSPECISTESTEQUIPMENTRQD,
INSPSPECISUPPERLIMITREQUIRED,
INSPSPECLOWERLIMIT,
INSPSPECLOWERPLAUSIBILITYLIMIT,
INSPSPECLOWERSPECLIMITCHANGE,
INSPSPECNUMBEROFCLASSES,
INSPSPECPRINTCONTROL,
INSPSPECRECORDINGTYPE,
INSPSPECRESULTCALCULATION,
INSPSPECSECONDLOWERSPECLIMIT,
INSPSPECSECONDUPPERSPECLIMIT,
INSPSPECTARGETVALUE,
INSPSPECTOLERANCECHGVALIDFROM,
INSPSPECTOLERANCECHGVALIDTO,
INSPSPECUPPERLIMIT,
INSPSPECUPPERPLAUSIBILITYLIMIT,
INSPSPECUPPERSPECLIMITCHANGE,
INSPTOLERANCESPECIFICATION,
ISDELETED,
LASTCHANGEDATE,
LASTCHANGEDBYUSER,
MATLISCONSIDEREDFORDYNMODIF,
MFRISCONSIDEREDFORDYNMODIF,
QLTYCTRLCHARTAGGRGNCRITERION,
SAMPLINGPROCEDURE,
SELECTEDCODESET,
SELECTEDCODESETPLANT,
SUPLRISCONSIDEREDFORDYNMODIF,
VALIDITYENDDATE,
VALIDITYSTARTDATE,
PRIMARY KEY (BILLOFOPERATIONSGROUP, BILLOFOPERATIONSSEQUENCE, BILLOFOPERATIONSVARIANT, BOOCHARACTERISTIC, BOOCHARACTERISTICVERSION, BOOOPERATIONINTERNALID)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA