I_InspCharacteristicTP_2

DDL: I_INSPCHARACTERISTICTP_2 Type: view_entity TRANSACTIONAL

Inspection Characteristic - TP

I_InspCharacteristicTP_2 is a Transactional CDS View that provides data about "Inspection Characteristic - TP" in SAP S/4HANA. It reads from 1 data source (R_InspectionCharacteristicTP) and exposes 82 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionCharacteristic.

Data Sources (1)

SourceAliasJoin Type
R_InspectionCharacteristicTP R_InspectionCharacteristicTP projection

Annotations (9)

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

Fields (82)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot InspectionLot Inspection Lot
KEY InspPlanOperationInternalID InspPlanOperationInternalID
KEY InspectionCharacteristic InspectionCharacteristic
InspectionSpecificationText InspectionSpecificationText
HasInspCharcPrtlSmpl HasInspCharcPrtlSmpl
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
InspectionSpecificationPlant InspectionSpecificationPlant
InspectionSpecification InspectionSpecification Master IC
InspectionSpecificationVersion InspectionSpecificationVersion
InspCharcPrtlSmpl InspCharcPrtlSmpl
InspectionCharacteristicStatus InspectionCharacteristicStatus
InspSpecDecimalPlaces InspSpecDecimalPlaces
InspectionSpecificationUnit InspectionSpecificationUnit Unit of Meas.
InspSampleValuationRule InspSampleValuationRule
QuantityUnit QuantityUnit Unit of measure
InspCharacteristicSampleSize InspCharacteristicSampleSize
InspCharacteristicSampleUnit InspCharacteristicSampleUnit
InspSpecSampleQuantityFactor InspSpecSampleQuantityFactor
InspSpecTargetValue InspSpecTargetValue Target Value
InspSpecHasTargetValue InspSpecHasTargetValue
InspSpecUpperLimit InspSpecUpperLimit Upper Limit
InspSpecHasUpperLimit InspSpecHasUpperLimit
InspSpecLowerLimit InspSpecLowerLimit Lower Limit
InspSpecHasLowerLimit InspSpecHasLowerLimit
InspSpecImportanceCode InspSpecImportanceCode
CharacteristicAttributeCatalog CharacteristicAttributeCatalog
SelectedCodeSet SelectedCodeSet CodeGrp/SelSet
SelectedCodeSetPlant SelectedCodeSetPlant
InspSpecAdditionalCatalog2 InspSpecAdditionalCatalog2
InspSpecAdditionalCatalog3 InspSpecAdditionalCatalog3
InspSpecAdditionalCatalog4 InspSpecAdditionalCatalog4
InspSpecAdditionalCatalog5 InspSpecAdditionalCatalog5
InspSpecAddlSeldCodeSetPlant2 InspSpecAddlSeldCodeSetPlant2
InspSpecAddlSeldCodeSetPlant3 InspSpecAddlSeldCodeSetPlant3
InspSpecAddlSeldCodeSetPlant4 InspSpecAddlSeldCodeSetPlant4
InspSpecAddlSeldCodeSetPlant5 InspSpecAddlSeldCodeSetPlant5
InspSpecAdditionalSelectedSet2 InspSpecAdditionalSelectedSet2
InspSpecAdditionalCodeGroup2 InspSpecAdditionalCodeGroup2
InspSpecAdditionalSelectedSet3 InspSpecAdditionalSelectedSet3
InspSpecAdditionalCodeGroup3 InspSpecAdditionalCodeGroup3
InspSpecAdditionalSelectedSet4 InspSpecAdditionalSelectedSet4
InspSpecAdditionalCodeGroup4 InspSpecAdditionalCodeGroup4
InspSpecAdditionalSelectedSet5 InspSpecAdditionalSelectedSet5
InspSpecAdditionalCodeGroup5 InspSpecAdditionalCodeGroup5
InspSpecificationHasLongText InspSpecificationHasLongText
InspectorQualification InspectorQualification
InspSpecFormula1 InspSpecFormula1
InspSpecFormula2 InspSpecFormula2
InspSpecInformationField1 InspSpecInformationField1
InspSpecInformationField2 InspSpecInformationField2
InspSpecInformationField3 InspSpecInformationField3
InspSpecDefectCodeGrpRjcnLower InspSpecDefectCodeGrpRjcnLower
InspSpecDefectCodeRjcnLower InspSpecDefectCodeRjcnLower
InspSpecDefectCodeGrpRjcnUpper InspSpecDefectCodeGrpRjcnUpper
InspSpecDefectCodeRjcnUpper InspSpecDefectCodeRjcnUpper
InspSpecDefectCodeGrpRejection InspSpecDefectCodeGrpRejection
InspSpecDefectCodeRejection InspSpecDefectCodeRejection
InspCharcQuantity InspCharcQuantity
UnplndCharcInspSubsetIntID UnplndCharcInspSubsetIntID
InspLotDynamicRule InspLotDynamicRule
QualityLevelInternalID QualityLevelInternalID
SamplingProcedureInspSubset SamplingProcedureInspSubset
ProductionOrderOperationActy ProductionOrderOperationActy
ProductionOrderOpActyVers ProductionOrderOpActyVers
InspCharcConfirmationNumber InspCharcConfirmationNumber
InspCharcCreationDate InspCharcCreationDate

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 I_InspCharacteristicTP_2.
-- 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 I_InspCharacteristicTP_2 AS
SELECT
  InspectionLot,
  InspPlanOperationInternalID,
  InspectionCharacteristic,
  InspectionSpecificationText,
  HasInspCharcPrtlSmpl,
  InspSpecIsQuantitative,
  InspSpecIsMeasuredValueRqd,
  InspSpecIsSelectedSetRequired,
  InspSpecIsLongTermInspection,
  InspSpecRecordingType,
  InspResultIsDocumentationRqd,
  InspSpecCharcCategory,
  InspSpecResultCalculation,
  InspSpecHasSamplingProcedure,
  InspSpecIsDefectRecordingRqd,
  InspSpecIsDefectsRecgAutomatic,
  InspSpecIsChgDocRequired,
  InspSpecHasControlChart,
  InspCharcIsNotPlanned,
  InspectionMethod,
  InspectionMethodPlant,
  InspectionMethodVersion,
  InspectionSpecificationPlant,
  InspectionSpecification,
  InspectionSpecificationVersion,
  InspCharcPrtlSmpl,
  InspectionCharacteristicStatus,
  InspSpecDecimalPlaces,
  InspectionSpecificationUnit,
  InspSampleValuationRule,
  QuantityUnit,
  InspCharacteristicSampleSize,
  InspCharacteristicSampleUnit,
  InspSpecSampleQuantityFactor,
  InspSpecTargetValue,
  InspSpecHasTargetValue,
  InspSpecUpperLimit,
  InspSpecHasUpperLimit,
  InspSpecLowerLimit,
  InspSpecHasLowerLimit,
  InspSpecImportanceCode,
  CharacteristicAttributeCatalog,
  SelectedCodeSet,
  SelectedCodeSetPlant,
  InspSpecAdditionalCatalog2,
  InspSpecAdditionalCatalog3,
  InspSpecAdditionalCatalog4,
  InspSpecAdditionalCatalog5,
  InspSpecAddlSeldCodeSetPlant2,
  InspSpecAddlSeldCodeSetPlant3,
  InspSpecAddlSeldCodeSetPlant4,
  InspSpecAddlSeldCodeSetPlant5,
  InspSpecAdditionalSelectedSet2,
  InspSpecAdditionalCodeGroup2,
  InspSpecAdditionalSelectedSet3,
  InspSpecAdditionalCodeGroup3,
  InspSpecAdditionalSelectedSet4,
  InspSpecAdditionalCodeGroup4,
  InspSpecAdditionalSelectedSet5,
  InspSpecAdditionalCodeGroup5,
  InspSpecificationHasLongText,
  InspectorQualification,
  InspSpecFormula1,
  InspSpecFormula2,
  InspSpecInformationField1,
  InspSpecInformationField2,
  InspSpecInformationField3,
  InspSpecDefectCodeGrpRjcnLower,
  InspSpecDefectCodeRjcnLower,
  InspSpecDefectCodeGrpRjcnUpper,
  InspSpecDefectCodeRjcnUpper,
  InspSpecDefectCodeGrpRejection,
  InspSpecDefectCodeRejection,
  InspCharcQuantity,
  UnplndCharcInspSubsetIntID,
  InspLotDynamicRule,
  QualityLevelInternalID,
  SamplingProcedureInspSubset,
  ProductionOrderOperationActy,
  ProductionOrderOpActyVers,
  InspCharcConfirmationNumber,
  InspCharcCreationDate
FROM R_InspectionCharacteristicTP
;