R_InspectionCharacteristicTP

DDL: R_INSPECTIONCHARACTERISTICTP Type: view_entity TRANSACTIONAL
132 Fields 1 Data Sources 2 Associations

Inspection Characteristic - TP

R_InspectionCharacteristicTP is a Transactional CDS View that provides data about "Inspection Characteristic - TP" in SAP S/4HANA. It reads from 1 data source (I_InspectionCharacteristic) and exposes 132 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionCharacteristic. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_InspectionCharacteristic I_InspectionCharacteristic from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_InspectionLotTP _InspectionLot $projection.InspectionLot = _InspectionLot.InspectionLot
[0..1] R_InspectionResultTP _InspectionResult

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
EndUserText.label Inspection Characteristic - TP view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (132)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot InspectionLot Inspection Lot
KEY InspPlanOperationInternalID InspPlanOperationInternalID Node Number
KEY InspectionCharacteristic InspectionCharacteristic Characteristic
InspectionSpecificationText InspectionSpecificationText
InspCharcLongTextLanguage InspCharcLongTextLanguage Language
HasInspCharcPrtlSmpl HasInspCharcPrtlSmpl Partial Samples
BOOCharacteristicInspRelevance BOOCharacteristicInspRelevance Insp. Relevance
InspCharcUnplannedProcessing InspCharcUnplannedProcessing Use chars.
InspSpecIsQuantitative InspSpecIsQuantitative Quant.charac.
InspSpecIsMeasuredValueRqd InspSpecIsMeasuredValueRqd
InspSpecIsSelectedSetRequired InspSpecIsSelectedSetRequired
InspSpecIsLongTermInspection InspSpecIsLongTermInspection
InspSpecRecordingType InspSpecRecordingType
InspResultIsDocumentationRqd InspResultIsDocumentationRqd
InspSpecCharcCategory InspSpecCharcCategory
InspSpecResultCalculation InspSpecResultCalculation
InspSpecHasSamplingProcedure InspSpecHasSamplingProcedure
InspSpecIsDefectRecordingRqd InspSpecIsDefectRecordingRqd
InspSpecIsDefectsRecgAutomatic InspSpecIsDefectsRecgAutomatic
InspSpecIsChgDocRequired InspSpecIsChgDocRequired
InspSpecHasControlChart InspSpecHasControlChart SPC character.
InspCharcIsNotPlanned InspCharcIsNotPlanned
InspectionMethod InspectionMethod Insp. Method
InspectionMethodPlant InspectionMethodPlant
InspectionMethodVersion InspectionMethodVersion Version
InspectionSpecificationPlant InspectionSpecificationPlant
InspectionSpecification InspectionSpecification Master IC
InspectionSpecificationVersion InspectionSpecificationVersion Version
InspCharcPrtlSmpl InspCharcPrtlSmpl Partial Sample
InspectionCharacteristicStatus InspectionCharacteristicStatus Status
InspSpecDecimalPlaces InspSpecDecimalPlaces Decimal Places
SamplingProcedure SamplingProcedure Smpl.procedure
InspectionSpecificationUnit InspectionSpecificationUnit Unit of Meas.
BOOCharcMatlToSampleUnitRate BOOCharcMatlToSampleUnitRate MatlConvFactor
BOOCharcSampleToMatlUnitRate BOOCharcSampleToMatlUnitRate SmplConvFactor
DefectFractionEstimationProced DefectFractionEstimationProced Fraction Calc.
InspSampleValuationRule InspSampleValuationRule Valuation Rule
QuantityUnit QuantityUnit Unit of measure
InspCharacteristicSampleSize InspCharacteristicSampleSize Inspect
InspCharacteristicSampleUnit InspCharacteristicSampleUnit Sample Unit
InspSpecSampleQuantityFactor InspSpecSampleQuantityFactor Base smpl. qty
InspSpecTargetValue InspSpecTargetValue Target Value
InspSpecHasTargetValue InspSpecHasTargetValue Not Initial
InspSpecUpperLimit InspSpecUpperLimit Upper Limit
InspSpecHasUpperLimit InspSpecHasUpperLimit Not Initial
InspSpecLowerLimit InspSpecLowerLimit Lower Limit
InspSpecHasLowerLimit InspSpecHasLowerLimit Not Initial
InspSpecImportanceCode InspSpecImportanceCode Weighting
InspLotTestEquipInternalID InspLotTestEquipInternalID Test equipment
CharacteristicAttributeCatalog CharacteristicAttributeCatalog Catalog Type
SelectedCodeSet SelectedCodeSet CodeGrp/SelSet
SelectedCodeSetPlant SelectedCodeSetPlant Plant
InspSpecAdditionalCatalog2 InspSpecAdditionalCatalog2 Catalog Type
InspSpecAdditionalCatalog3 InspSpecAdditionalCatalog3 Catalog Type
InspSpecAdditionalCatalog4 InspSpecAdditionalCatalog4 Catalog Type
InspSpecAdditionalCatalog5 InspSpecAdditionalCatalog5 Catalog Type
InspSpecAddlSeldCodeSetPlant2 InspSpecAddlSeldCodeSetPlant2 Plant
InspSpecAddlSeldCodeSetPlant3 InspSpecAddlSeldCodeSetPlant3 Plant
InspSpecAddlSeldCodeSetPlant4 InspSpecAddlSeldCodeSetPlant4 Plant
InspSpecAddlSeldCodeSetPlant5 InspSpecAddlSeldCodeSetPlant5 Plant
InspSpecAdditionalSelectedSet2 InspSpecAdditionalSelectedSet2
InspSpecAdditionalCodeGroup2 InspSpecAdditionalCodeGroup2
InspSpecAdditionalSelectedSet3 InspSpecAdditionalSelectedSet3
InspSpecAdditionalCodeGroup3 InspSpecAdditionalCodeGroup3
InspSpecAdditionalSelectedSet4 InspSpecAdditionalSelectedSet4
InspSpecAdditionalCodeGroup4 InspSpecAdditionalCodeGroup4
InspSpecAdditionalSelectedSet5 InspSpecAdditionalSelectedSet5
InspSpecAdditionalCodeGroup5 InspSpecAdditionalCodeGroup5
InspSpecificationHasLongText InspSpecificationHasLongText
InspectorQualification InspectorQualification Inspctr qualif.
InspSpecHasFormula InspSpecHasFormula Formula calc.
InspSpecFormula1 InspSpecFormula1 Formula
InspSpecFormula2 InspSpecFormula2 Formula
InspSpecInformationField1 InspSpecInformationField1 Info Field 1
InspSpecInformationField2 InspSpecInformationField2 Info Field 2
InspSpecInformationField3 InspSpecInformationField3 Info Field 3
InspSpecDefectCodeGrpRjcnLower InspSpecDefectCodeGrpRjcnLower LoLim defect
InspSpecDefectCodeRjcnLower InspSpecDefectCodeRjcnLower DefCodeLowSpecL
InspSpecDefectCodeGrpRjcnUpper InspSpecDefectCodeGrpRjcnUpper UpLim defect
InspSpecDefectCodeRjcnUpper InspSpecDefectCodeRjcnUpper DefCodeUpperSpL
InspSpecDefectCodeGrpRejection InspSpecDefectCodeGrpRejection DefCodeGrp Rej.
InspSpecDefectCodeRejection InspSpecDefectCodeRejection Defect Code: Gen
InspCharcQuantity InspCharcQuantity Insp. Quantity
InspectionLotSampleUnit InspectionLotSampleUnit Sample UOM
InspSpecControlIndicators InspSpecControlIndicators CharCntrl ind.
UnplndCharcInspSubsetIntID UnplndCharcInspSubsetIntID SmpNo UCh
InspLotDynamicRule InspLotDynamicRule
QualityLevelInternalID QualityLevelInternalID Counter
SamplingProcedureInspSubset SamplingProcedureInspSubset With insp. pts.
ProductionOrderOperationActy ProductionOrderOperationActy Operation Activity
ProductionOrderOpActyVers ProductionOrderOpActyVers OA Version
InspCharcConfirmationNumber InspCharcConfirmationNumber ConfirmationNo.
BOOCharacteristicVersion BOOCharacteristicVersion Sort pos.
InspCharcCreationDate InspCharcCreationDate Created On
InspectionsNotSkippedDnmntr InspectionsNotSkippedDnmntr Insp. Frequency
QltyCtrlChartAggrgnCriterion QltyCtrlChartAggrgnCriterion SPC Criterion
BOOCharcGroup BOOCharcGroup Characteristic Group
BOOCharcSourceCharc BOOCharcSourceCharc Source Charc
BOOCharcGroupDivision BOOCharcGroupDivision Internal Division ID
InspSpecUpperPlausibilityLimit InspSpecUpperPlausibilityLimit UpPlaus. Limit
InspSpecHasUprPlausibilityLmt InspSpecHasUprPlausibilityLmt Not Initial
InspSpecLowerPlausibilityLimit InspSpecLowerPlausibilityLimit LoPlaus. Limit
InspSpecHasLowrPlausibilityLmt InspSpecHasLowrPlausibilityLmt Not Initial
QualityControlChart _InspSubsetCharacteristic QualityControlChart
InspSampleAcceptanceNumber _InspSubsetCharacteristic InspSampleAcceptanceNumber
InspSampleRejectionNumber _InspSubsetCharacteristic InspSampleRejectionNumber
InspSingleSampleValuationRule _InspSubsetCharacteristic InspSampleValuationRule Valuation Rule
InspectionSampleSize _InspSubsetCharacteristic InspectionSampleSize
InspLotDynRuleStage _InspSubsetCharacteristic InspLotDynRuleStage
InspectionSeverity _InspSubsetCharacteristic InspectionSeverity
InspSampleAcceptanceFactor _InspSubsetCharacteristic InspSampleAcceptanceFactor
InspSampleHasAcceptanceFactor _InspSubsetCharacteristic InspSampleHasAcceptanceFactor
InspectionSampleStatus _InspSubsetCharacteristic InspectionCharacteristicStatus Status
InspectionSampleQuantity _InspSubsetCharacteristic InspectionSampleQuantity
_CharcAttribSelectedCodeSet _CharcAttribSelectedCodeSet
_InspCharacteristic _InspCharacteristic
_InspCharacteristicSampleUnit _InspCharacteristicSampleUnit
_InspCharacteristicStatus _InspCharacteristicStatus
_InspectionLot _InspectionLot
_InspectionMethodPlant _InspectionMethodPlant
_InspectionMethodVersion _InspectionMethodVersion
_InspectionOperation _InspectionOperation
_InspectionResult _InspectionResult
_InspectionResultValue _InspectionResultValue
_InspectionSpecificationPlant _InspectionSpecificationPlant
_InspectionSpecificationUnit _InspectionSpecificationUnit
_InspLotDynamicRule _InspLotDynamicRule
_InspSampleResult _InspSampleResult
_InspSpecificationVersion _InspSpecificationVersion
_InspSpecImportanceCode _InspSpecImportanceCode
_QuantityUnit _QuantityUnit
_BOOCharcInspRelevance _BOOCharcInspRelevance

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_InspectionCharacteristicTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_InspectionCharacteristicTP AS
SELECT
  InspectionLot,
  InspPlanOperationInternalID,
  InspectionCharacteristic,
  InspectionSpecificationText,
  InspCharcLongTextLanguage,
  HasInspCharcPrtlSmpl,
  BOOCharacteristicInspRelevance,
  InspCharcUnplannedProcessing,
  InspSpecIsQuantitative,
  InspSpecIsMeasuredValueRqd,
  InspSpecIsSelectedSetRequired,
  InspSpecIsLongTermInspection,
  InspSpecRecordingType,
  InspResultIsDocumentationRqd,
  InspSpecCharcCategory,
  InspSpecResultCalculation,
  InspSpecHasSamplingProcedure,
  InspSpecIsDefectRecordingRqd,
  InspSpecIsDefectsRecgAutomatic,
  InspSpecIsChgDocRequired,
  InspSpecHasControlChart,
  InspCharcIsNotPlanned,
  InspectionMethod,
  InspectionMethodPlant,
  InspectionMethodVersion,
  InspectionSpecificationPlant,
  InspectionSpecification,
  InspectionSpecificationVersion,
  InspCharcPrtlSmpl,
  InspectionCharacteristicStatus,
  InspSpecDecimalPlaces,
  SamplingProcedure,
  InspectionSpecificationUnit,
  BOOCharcMatlToSampleUnitRate,
  BOOCharcSampleToMatlUnitRate,
  DefectFractionEstimationProced,
  InspSampleValuationRule,
  QuantityUnit,
  InspCharacteristicSampleSize,
  InspCharacteristicSampleUnit,
  InspSpecSampleQuantityFactor,
  InspSpecTargetValue,
  InspSpecHasTargetValue,
  InspSpecUpperLimit,
  InspSpecHasUpperLimit,
  InspSpecLowerLimit,
  InspSpecHasLowerLimit,
  InspSpecImportanceCode,
  InspLotTestEquipInternalID,
  CharacteristicAttributeCatalog,
  SelectedCodeSet,
  SelectedCodeSetPlant,
  InspSpecAdditionalCatalog2,
  InspSpecAdditionalCatalog3,
  InspSpecAdditionalCatalog4,
  InspSpecAdditionalCatalog5,
  InspSpecAddlSeldCodeSetPlant2,
  InspSpecAddlSeldCodeSetPlant3,
  InspSpecAddlSeldCodeSetPlant4,
  InspSpecAddlSeldCodeSetPlant5,
  InspSpecAdditionalSelectedSet2,
  InspSpecAdditionalCodeGroup2,
  InspSpecAdditionalSelectedSet3,
  InspSpecAdditionalCodeGroup3,
  InspSpecAdditionalSelectedSet4,
  InspSpecAdditionalCodeGroup4,
  InspSpecAdditionalSelectedSet5,
  InspSpecAdditionalCodeGroup5,
  InspSpecificationHasLongText,
  InspectorQualification,
  InspSpecHasFormula,
  InspSpecFormula1,
  InspSpecFormula2,
  InspSpecInformationField1,
  InspSpecInformationField2,
  InspSpecInformationField3,
  InspSpecDefectCodeGrpRjcnLower,
  InspSpecDefectCodeRjcnLower,
  InspSpecDefectCodeGrpRjcnUpper,
  InspSpecDefectCodeRjcnUpper,
  InspSpecDefectCodeGrpRejection,
  InspSpecDefectCodeRejection,
  InspCharcQuantity,
  InspectionLotSampleUnit,
  InspSpecControlIndicators,
  UnplndCharcInspSubsetIntID,
  InspLotDynamicRule,
  QualityLevelInternalID,
  SamplingProcedureInspSubset,
  ProductionOrderOperationActy,
  ProductionOrderOpActyVers,
  InspCharcConfirmationNumber,
  BOOCharacteristicVersion,
  InspCharcCreationDate,
  InspectionsNotSkippedDnmntr,
  QltyCtrlChartAggrgnCriterion,
  BOOCharcGroup,
  BOOCharcSourceCharc,
  BOOCharcGroupDivision,
  InspSpecUpperPlausibilityLimit,
  InspSpecHasUprPlausibilityLmt,
  InspSpecLowerPlausibilityLimit,
  InspSpecHasLowrPlausibilityLmt,
  _InspSubsetCharacteristic.QualityControlChart AS QualityControlChart,
  _InspSubsetCharacteristic.InspSampleAcceptanceNumber AS InspSampleAcceptanceNumber,
  _InspSubsetCharacteristic.InspSampleRejectionNumber AS InspSampleRejectionNumber,
  _InspSubsetCharacteristic.InspSampleValuationRule AS InspSingleSampleValuationRule,
  _InspSubsetCharacteristic.InspectionSampleSize AS InspectionSampleSize,
  _InspSubsetCharacteristic.InspLotDynRuleStage AS InspLotDynRuleStage,
  _InspSubsetCharacteristic.InspectionSeverity AS InspectionSeverity,
  _InspSubsetCharacteristic.InspSampleAcceptanceFactor AS InspSampleAcceptanceFactor,
  _InspSubsetCharacteristic.InspSampleHasAcceptanceFactor AS InspSampleHasAcceptanceFactor,
  _InspSubsetCharacteristic.InspectionCharacteristicStatus AS InspectionSampleStatus,
  _InspSubsetCharacteristic.InspectionSampleQuantity AS InspectionSampleQuantity
FROM I_InspectionCharacteristic
LEFT OUTER JOIN R_InspectionLotTP AS _InspectionLot ON InspectionLot = _InspectionLot.InspectionLot  -- association [1..1]
LEFT OUTER JOIN R_InspectionResultTP AS _InspectionResult ON /* condition not available in parsed metadata */  -- association [0..1]
;

Learn More