C_InspSubsetValuation

DDL: C_INSPSUBSETVALUATION Type: view_entity CONSUMPTION Package: ODATA_QM_INSPSUBSET_RR
19 Fields 1 Data Sources 1 Associations

IPRR: Inspection Point Valuation

C_InspSubsetValuation is a Consumption CDS View that provides data about "IPRR: Inspection Point Valuation" in SAP S/4HANA. It reads from 1 data source (I_InspectionSubset) and exposes 19 fields with key fields InspectionLot, InspectionSubsetInternalID, InspPlanOperationInternalID. It has 1 association to related views. Part of development package ODATA_QM_INSPSUBSET_RR.

Data Sources (1)

SourceAliasJoin Type
I_InspectionSubset InspSubset from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_InspLotUsgeDcsnValn _InspSubsetUsageDcsnValn $projection.InspSubsetUsageDcsnValuation = _InspSubsetUsageDcsnValn.InspLotUsageDecisionValuation

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
EndUserText.label IPRR: Inspection Point Valuation view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot I_InspectionSubset InspectionLot Inspection Lot
KEY InspectionSubsetInternalID I_InspectionSubset InspectionSubsetInternalID Sample Number
KEY InspPlanOperationInternalID I_InspectionSubset InspPlanOperationInternalID Node Number
InspSubsetUsageDcsnValuation I_InspectionSubset InspSubsetUsageDcsnValuation Code Valuation
InspSubsetCharcOpenCount InspSubsetCharcAggregate InspSubsetCharcOpenCount
InspSubsetCharcAcceptedCount InspSubsetCharcAggregate InspSubsetCharcAcceptedCount
InspSubsetCharcRejectedCount InspSubsetCharcAggregate InspSubsetCharcRejectedCount
InspectionSubsetTime I_InspectionSubset InspectionSubsetTime
InspectionSubsetDate I_InspectionSubset InspectionSubsetDate
InspSubsetDateTime
Plant
InspectionLotType
InspectionSubsetType
MatlQualityAuthorizationGroup
IsBusinessPurposeCompleted
WorkCenter
_InspectionLot I_InspectionSubset _InspectionLot
_InspectionOperation I_InspectionSubset _InspectionOperation
_InspSubsetUsageDcsnValn _InspSubsetUsageDcsnValn

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 C_InspSubsetValuation.
-- 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 C_InspSubsetValuation AS
SELECT
  InspSubset.InspectionLot AS InspectionLot,
  InspSubset.InspectionSubsetInternalID AS InspectionSubsetInternalID,
  InspSubset.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  InspSubset.InspSubsetUsageDcsnValuation AS InspSubsetUsageDcsnValuation,
  InspSubsetCharcAggregate.InspSubsetCharcOpenCount AS InspSubsetCharcOpenCount,
  InspSubsetCharcAggregate.InspSubsetCharcAcceptedCount AS InspSubsetCharcAcceptedCount,
  InspSubsetCharcAggregate.InspSubsetCharcRejectedCount AS InspSubsetCharcRejectedCount,
  InspSubset.InspectionSubsetTime AS InspectionSubsetTime,
  InspSubset.InspectionSubsetDate AS InspectionSubsetDate,
  cast ('' as abap.char(50)) AS InspSubsetDateTime,
  InspSubset._InspectionLot.Plant AS Plant,
  InspSubset._InspectionLot.InspectionLotType AS InspectionLotType,
  InspSubset._InspectionLot.InspectionSubsetType AS InspectionSubsetType,
  InspSubset._InspectionLot.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup,
  InspSubset._InspectionLot.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  InspSubset._InspectionOperation._WorkCenter.WorkCenter AS WorkCenter,
  InspSubset._InspectionLot AS _InspectionLot,
  InspSubset._InspectionOperation AS _InspectionOperation
FROM I_InspectionSubset AS InspSubset
LEFT OUTER JOIN I_InspLotUsgeDcsnValn AS _InspSubsetUsageDcsnValn ON InspSubsetUsageDcsnValuation = _InspSubsetUsageDcsnValn.InspLotUsageDecisionValuation  -- association [0..1]
;

Learn More