I_InspectionSubsetTP_21

DDL: I_INSPECTIONSUBSETTP_21 Type: view_entity TRANSACTIONAL Package: VDM_QM_INSPECTION

Inspection Point - TP

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

Data Sources (1)

SourceAliasJoin Type
R_InspectionSubsetTP R_InspectionSubsetTP projection

Annotations (7)

NameValueLevelField
EndUserText.label Inspection Point - TP view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot InspectionLot Inspection Lot
KEY InspectionSubsetInternalID InspectionSubsetInternalID
KEY InspPlanOperationInternalID InspPlanOperationInternalID
InspectionSubsetSortKey InspectionSubsetSortKey
MaterialSample MaterialSample
InspSbstMatlSmplProperty InspSbstMatlSmplProperty
Equipment Equipment Equipment check
InspSbstEquipProperty InspSbstEquipProperty
FunctionalLocation FunctionalLocation Object ID
InspSbstFuncnlLocProperty InspSbstFuncnlLocProperty
ShopFloorItem ShopFloorItem Serial.Mat. ID
InspSbstShopFloorItemProperty InspSbstShopFloorItemProperty
SelectedCodeSetPlant SelectedCodeSetPlant
SelectedCodeSet SelectedCodeSet CodeGrp/SelSet
InspSubsetUsageDcsnCodeGroup InspSubsetUsageDcsnCodeGroup
InspSubsetUsageDcsnCode InspSubsetUsageDcsnCode
InspSubsetUsageDcsnValuation InspSubsetUsageDcsnValuation
InspectionSubsetTime InspectionSubsetTime
InspSbstTimeFldProperty InspSbstTimeFldProperty
InspectionSubsetDate InspectionSubsetDate
InspSbstDateFldProperty InspSbstDateFldProperty
InspSubsetLongNumericKey InspSubsetLongNumericKey
InspSbstLongNmbrFldProperty InspSbstLongNmbrFldProperty
InspSubsetShortNumericKey InspSubsetShortNumericKey
InspSbstShrtNmbrFldProperty InspSbstShrtNmbrFldProperty
InspectionSubsetLongCharKey InspectionSubsetLongCharKey
InspSbstLongTxtFldProperty InspSbstLongTxtFldProperty
InspectionSubsetShortCharKey InspectionSubsetShortCharKey
InspSbstShrtTxtFldProperty InspSbstShrtTxtFldProperty
InspectionPartialLot InspectionPartialLot
InspectionSubsetYieldQty InspectionSubsetYieldQty
InspectionSubsetScrapQty InspectionSubsetScrapQty
InspectionSubsetReworkQty InspectionSubsetReworkQty
InspectionSubsetQtyUnit InspectionSubsetQtyUnit
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

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_InspectionSubsetTP_21.
-- 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_InspectionSubsetTP_21 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 R_InspectionSubsetTP
;