R_InspectionSubsetTP

DDL: R_INSPECTIONSUBSETTP Type: view_entity TRANSACTIONAL Package: VDM_QM_INSPECTION
45 Fields 1 Data Sources 2 Associations

Inspection Point - TP

R_InspectionSubsetTP is a Transactional CDS View that provides data about "Inspection Point - TP" in SAP S/4HANA. It reads from 1 data source (I_InspectionSubset) and exposes 45 fields with key fields InspectionLot, InspectionSubsetInternalID, InspPlanOperationInternalID. It has 2 associations to related views. Part of development package VDM_QM_INSPECTION.

Data Sources (1)

SourceAliasJoin Type
I_InspectionSubset InspectionSubset from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_InspectionLotTP _InspectionLot $projection.InspectionLot = _InspectionLot.InspectionLot
[0..*] R_InspSubsetCharacteristicTP _InspSubsetCharacteristic

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
EndUserText.label Inspection Point - 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 (45)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot InspectionLot Inspection Lot
KEY InspectionSubsetInternalID InspectionSubsetInternalID Sample Number
KEY InspPlanOperationInternalID InspPlanOperationInternalID Node Number
InspectionSubsetSortKey InspectionSubsetSortKey Inspection pt
MaterialSample MaterialSample Sample
InspSbstMatlSmplProperty InspSbstMatlSmplProperty User Fld Active
Equipment Equipment Equipment check
InspSbstEquipProperty InspSbstEquipProperty User Fld Active
FunctionalLocation FunctionalLocation Object ID
InspSbstFuncnlLocProperty InspSbstFuncnlLocProperty User Fld Active
ShopFloorItem ShopFloorItem Serial.Mat. ID
InspSbstShopFloorItemProperty InspSbstShopFloorItemProperty User Fld Active
SelectedCodeSetPlant SelectedCodeSetPlant Plant
SelectedCodeSet SelectedCodeSet CodeGrp/SelSet
InspSubsetUsageDcsnCodeGroup InspSubsetUsageDcsnCodeGroup UD Code Group
InspSubsetUsageDcsnCode InspSubsetUsageDcsnCode UD Code
InspSubsetUsageDcsnValuation InspSubsetUsageDcsnValuation Code Valuation
InspectionSubsetTime InspectionSubsetTime
InspSbstTimeFldProperty InspSbstTimeFldProperty User Fld Active
InspectionSubsetDate InspectionSubsetDate
InspSbstDateFldProperty InspSbstDateFldProperty User Fld Active
InspSubsetLongNumericKey InspSubsetLongNumericKey
InspSbstLongNmbrFldProperty InspSbstLongNmbrFldProperty User Fld Active
InspSubsetShortNumericKey InspSubsetShortNumericKey
InspSbstShrtNmbrFldProperty InspSbstShrtNmbrFldProperty User Fld Active
InspectionSubsetLongCharKey InspectionSubsetLongCharKey
InspSbstLongTxtFldProperty InspSbstLongTxtFldProperty User Fld Active
InspectionSubsetShortCharKey InspectionSubsetShortCharKey
InspSbstShrtTxtFldProperty InspSbstShrtTxtFldProperty User Fld Active
InspectionPartialLot InspectionPartialLot Partial Lot
InspectionSubsetYieldQty InspectionSubsetYieldQty WarrCountValue
InspectionSubsetScrapQty InspectionSubsetScrapQty Insp. Pt Scrap
InspectionSubsetReworkQty InspectionSubsetReworkQty Rework Quantity
InspectionSubsetQtyUnit InspectionSubsetQtyUnit Sample UOM
Inspector Inspector Inspector
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Time changed
ChangedDateTime ChangedDateTime Time Stamp
_InspectionOperation _InspectionOperation
_InspectionLot _InspectionLot
_InspSubsetCharacteristic _InspSubsetCharacteristic

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_InspectionSubsetTP.
-- 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_InspectionSubsetTP AS
SELECT
  InspectionLot,
  InspectionSubsetInternalID,
  InspPlanOperationInternalID,
  InspectionSubsetSortKey,
  MaterialSample,
  InspSbstMatlSmplProperty,
  Equipment,
  InspSbstEquipProperty,
  FunctionalLocation,
  InspSbstFuncnlLocProperty,
  ShopFloorItem,
  InspSbstShopFloorItemProperty,
  SelectedCodeSetPlant,
  SelectedCodeSet,
  InspSubsetUsageDcsnCodeGroup,
  InspSubsetUsageDcsnCode,
  InspSubsetUsageDcsnValuation,
  InspectionSubsetTime,
  InspSbstTimeFldProperty,
  InspectionSubsetDate,
  InspSbstDateFldProperty,
  InspSubsetLongNumericKey,
  InspSbstLongNmbrFldProperty,
  InspSubsetShortNumericKey,
  InspSbstShrtNmbrFldProperty,
  InspectionSubsetLongCharKey,
  InspSbstLongTxtFldProperty,
  InspectionSubsetShortCharKey,
  InspSbstShrtTxtFldProperty,
  InspectionPartialLot,
  InspectionSubsetYieldQty,
  InspectionSubsetScrapQty,
  InspectionSubsetReworkQty,
  InspectionSubsetQtyUnit,
  Inspector,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  ChangedDateTime
FROM I_InspectionSubset AS InspectionSubset
LEFT OUTER JOIN R_InspectionLotTP AS _InspectionLot ON InspectionLot = _InspectionLot.InspectionLot  -- association [1..1]
LEFT OUTER JOIN R_InspSubsetCharacteristicTP AS _InspSubsetCharacteristic ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More