R_InspSubsetCharacteristicTP

DDL: R_INSPSUBSETCHARACTERISTICTP Type: view_entity TRANSACTIONAL
25 Fields 2 Data Sources 2 Associations

Inspection Point Characteristic - TP

R_InspSubsetCharacteristicTP is a Transactional CDS View that provides data about "Inspection Point Characteristic - TP" in SAP S/4HANA. It reads from 2 data sources (I_InspectionLot, I_InspSubsetCharacteristic) and exposes 25 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionSubsetInternalID, InspectionCharacteristic. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_InspectionLot InspectionLot inner
I_InspSubsetCharacteristic InspSubsetCharacteristic from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_InspectionLotTP _InspectionLot $projection.InspectionLot = _InspectionLot.InspectionLot
[1..1] R_InspectionOperationTP _InspectionOperation $projection.InspectionLot = _InspectionOperation.InspectionLot and $projection.InspPlanOperationInternalID = _InspectionOperation.InspPlanOperationInternalID

Annotations (8)

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

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot I_InspSubsetCharacteristic InspectionLot Inspection Lot
KEY InspPlanOperationInternalID I_InspSubsetCharacteristic InspPlanOperationInternalID Node Number
KEY InspectionSubsetInternalID I_InspSubsetCharacteristic InspectionSubsetInternalID Sample Number
KEY InspectionCharacteristic I_InspSubsetCharacteristic InspectionCharacteristic Characteristic
InspectionCharacteristicStatus I_InspSubsetCharacteristic InspectionCharacteristicStatus Status
QualityControlChart I_InspSubsetCharacteristic QualityControlChart Control Chart
InspSampleAcceptanceNumber I_InspSubsetCharacteristic InspSampleAcceptanceNumber Acceptance no.
InspSampleRejectionNumber I_InspSubsetCharacteristic InspSampleRejectionNumber Rejection no.
InspSampleHasAcceptanceFactor I_InspSubsetCharacteristic InspSampleHasAcceptanceFactor Not Initial
InspSampleAcceptanceFactor I_InspSubsetCharacteristic InspSampleAcceptanceFactor K-factor
DefectFractionEstimationProced I_InspSubsetCharacteristic DefectFractionEstimationProced Fraction Calc.
InspSampleValuationRule I_InspSubsetCharacteristic InspSampleValuationRule Valuation Rule
BOOCharcMatlToSampleUnitRate I_InspSubsetCharacteristic BOOCharcMatlToSampleUnitRate MatlConvFactor
BOOCharcSampleToMatlUnitRate I_InspSubsetCharacteristic BOOCharcSampleToMatlUnitRate SmplConvFactor
InspectionSampleSize I_InspSubsetCharacteristic InspectionSampleSize Inspect
InspCharacteristicSampleUnit I_InspSubsetCharacteristic InspCharacteristicSampleUnit Sample Unit
InspSpecSampleQuantityFactor I_InspSubsetCharacteristic InspSpecSampleQuantityFactor Base smpl. qty
InspectionSampleQuantity I_InspSubsetCharacteristic InspectionSampleQuantity Insp. Quantity
InspectionLotSampleUnit I_InspSubsetCharacteristic InspectionLotSampleUnit Sample UOM
InspLotDynRuleStage I_InspSubsetCharacteristic InspLotDynRuleStage Insp. Stage
InspectionSeverity I_InspSubsetCharacteristic InspectionSeverity Insp. Severity
InspSubsetCharcCreationDate I_InspSubsetCharacteristic InspSubsetCharcCreationDate Created On
_InspectionSubset _InspectionSubset
_InspectionLot _InspectionLot
_InspectionOperation _InspectionOperation

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_InspSubsetCharacteristicTP.
-- 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_InspSubsetCharacteristicTP AS
SELECT
  InspSubsetCharacteristic.InspectionLot AS InspectionLot,
  InspSubsetCharacteristic.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  InspSubsetCharacteristic.InspectionSubsetInternalID AS InspectionSubsetInternalID,
  InspSubsetCharacteristic.InspectionCharacteristic AS InspectionCharacteristic,
  InspSubsetCharacteristic.InspectionCharacteristicStatus AS InspectionCharacteristicStatus,
  InspSubsetCharacteristic.QualityControlChart AS QualityControlChart,
  InspSubsetCharacteristic.InspSampleAcceptanceNumber AS InspSampleAcceptanceNumber,
  InspSubsetCharacteristic.InspSampleRejectionNumber AS InspSampleRejectionNumber,
  InspSubsetCharacteristic.InspSampleHasAcceptanceFactor AS InspSampleHasAcceptanceFactor,
  InspSubsetCharacteristic.InspSampleAcceptanceFactor AS InspSampleAcceptanceFactor,
  InspSubsetCharacteristic.DefectFractionEstimationProced AS DefectFractionEstimationProced,
  InspSubsetCharacteristic.InspSampleValuationRule AS InspSampleValuationRule,
  InspSubsetCharacteristic.BOOCharcMatlToSampleUnitRate AS BOOCharcMatlToSampleUnitRate,
  InspSubsetCharacteristic.BOOCharcSampleToMatlUnitRate AS BOOCharcSampleToMatlUnitRate,
  InspSubsetCharacteristic.InspectionSampleSize AS InspectionSampleSize,
  InspSubsetCharacteristic.InspCharacteristicSampleUnit AS InspCharacteristicSampleUnit,
  InspSubsetCharacteristic.InspSpecSampleQuantityFactor AS InspSpecSampleQuantityFactor,
  InspSubsetCharacteristic.InspectionSampleQuantity AS InspectionSampleQuantity,
  InspSubsetCharacteristic.InspectionLotSampleUnit AS InspectionLotSampleUnit,
  InspSubsetCharacteristic.InspLotDynRuleStage AS InspLotDynRuleStage,
  InspSubsetCharacteristic.InspectionSeverity AS InspectionSeverity,
  InspSubsetCharacteristic.InspSubsetCharcCreationDate AS InspSubsetCharcCreationDate
FROM I_InspSubsetCharacteristic AS InspSubsetCharacteristic
INNER JOIN I_InspectionLot AS InspectionLot ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_InspectionLotTP AS _InspectionLot ON InspectionLot = _InspectionLot.InspectionLot  -- association [1..1]
LEFT OUTER JOIN R_InspectionOperationTP AS _InspectionOperation ON InspectionLot = _InspectionOperation.InspectionLot AND InspPlanOperationInternalID = _InspectionOperation.InspPlanOperationInternalID  -- association [1..1]
;

Learn More