I_INSPECTIONSUBSET

CDS View
46 Fields 24 CDS Views

Inspection Point of Inspection Operation

I_INSPECTIONSUBSET is a CDS View in S/4HANA. Inspection Point of Inspection Operation. It contains 46 fields. 24 CDS views read from this table.

CDS Views using this table (24)

ViewTypeJoinVDMDescription
C_DefectMngCharacteristicsSbst view inner CONSUMPTION Defect: Characteristics with Insp. Point
C_InspCharcSubsetResults view inner CONSUMPTION RRIP: Characteristics Subset Results
C_InspSubsetChar view inner CONSUMPTION Inspection Characteristic for Inspection Points
C_InspSubsetValuation view from CONSUMPTION IPRR: Inspection Point Valuation
C_InspUsgeSbst view inner CONSUMPTION Insp Usage Decision Subset
ESH_N_INSPECTIONSUBSET view from
ESH_N_INSPECTIONSUBSETEQUI view from
ESH_N_INSPECTIONSUBSETFUNLOC view from
ESH_N_INSPECTIONSUBSETSAMPLE view from
ESH_N_INSPECTIONSUBSETSFI view from
I_InspectionSubsetTP view from TRANSACTIONAL Inspection Point of Inspection Operation
I_InspectionSubsetTP_2 view from TRANSACTIONAL Inspection Subset 2
I_InspOperMatlSampleAggregate view inner COMPOSITE Aggregation on insp op mat sample level
I_MfgInspCharcHistory view inner COMPOSITE Inspection Characteristic History
I_MfgOrderOpActyInspCharcs view_entity left_outer COMPOSITE Inspection Char for OA in MfgOrder
I_SFIOpActyInspCharcsAggrg view_entity inner COMPOSITE Insp Chars for SFI in MFG Order
I_SFIPlanInspCharInfo view inner COMPOSITE SFI Plan Insp Char Info Interface
P_InspMatlSmplCharAggregate view from COMPOSITE
P_InspOperationAggregate1 view from COMPOSITE
P_InspSubsetValnAggregate view from CONSUMPTION
P_MfgInspCharcSumzdRslt view_entity inner COMPOSITE
P_MPEInspectionSubset view_entity from COMPOSITE Inspection Point of Inspection Operation
P_SFOInspSubsetCharcInfo view_entity inner COMPOSITE
R_InspectionSubsetTP view_entity from TRANSACTIONAL Inspection Point - TP

Fields (46)

KeyField CDS FieldsUsed in Views
KEY InspectionLot InspectionLot 14
KEY InspectionSubsetInternalID InspectionSubsetInternalID 8
KEY InspPlanOperationInternalID InspPlanOperationInternalID 10
KEY MaterialSample MaterialSample 9
_InspectionLot _InspectionLot 5
_InspectionOperation _InspectionOperation 5
_InspSubsetUsageDcsnValn _InspSubsetUsageDcsnValn 1
_Unit _Unit 1
ChangedDateTime ChangedDateTime 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
CreationTime CreationTime 1
Equipment Equipment 2
FunctionalLocation FunctionalLocation 2
InspectionPartialLot InspectionPartialLot 1
InspectionSubsetDate InspectionSubsetDate 2
InspectionSubsetLongCharKey InspectionSubsetLongCharKey 2
InspectionSubsetQtyUnit InspectionSubsetQtyUnit 1
InspectionSubsetReworkQty InspectionSubsetReworkQty 1
InspectionSubsetScrapQty InspectionSubsetScrapQty 1
InspectionSubsetShortCharKey InspectionSubsetShortCharKey 2
InspectionSubsetSortKey InspectionSubsetSortKey 2
InspectionSubsetTime InspectionSubsetTime 1
InspectionSubsetYieldQty InspectionSubsetYieldQty 1
Inspector Inspector 1
InspSbstDateFldProperty InspSbstDateFldProperty 1
InspSbstEquipProperty InspSbstEquipProperty 1
InspSbstFuncnlLocProperty InspSbstFuncnlLocProperty 1
InspSbstLongNmbrFldProperty InspSbstLongNmbrFldProperty 1
InspSbstLongTxtFldProperty InspSbstLongTxtFldProperty 1
InspSbstMatlSmplProperty InspSbstMatlSmplProperty 1
InspSbstShrtNmbrFldProperty InspSbstShrtNmbrFldProperty 1
InspSbstShrtTxtFldProperty InspSbstShrtTxtFldProperty 1
InspSbstTimeFldProperty InspSbstTimeFldProperty 1
InspSubsetLongNumericKey InspSubsetLongNumericKey 2
InspSubsetShortNumericKey InspSubsetShortNumericKey 2
InspSubsetUsageDcsnCode InspSubsetUsageDcsnCode 2
InspSubsetUsageDcsnCodeGroup InspSubsetUsageDcsnCodeGroup 2
InspSubsetUsageDcsnValuation InspSubsetUsageDcsnValuation 4
InspSubsetUsageDecisionCatalog InspSubsetUsageDecisionCatalog 1
LastChangeDate LastChangeDate 1
LastChangedByUser ContactCardID,LastChangedByUser 2
LastChangeTime LastChangeTime 1
SelectedCodeSet SelectedCodeSet 1
SelectedCodeSetPlant SelectedCodeSetPlant 1
ShopFloorItem ShopFloorItem 5

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Inspection Point of Inspection Operation
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_INSPECTIONSUBSET (
    INSPECTIONLOT,
    INSPECTIONSUBSETINTERNALID,
    INSPPLANOPERATIONINTERNALID,
    MATERIALSAMPLE,
    _INSPECTIONLOT,
    _INSPECTIONOPERATION,
    _INSPSUBSETUSAGEDCSNVALN,
    _UNIT,
    CHANGEDDATETIME,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    EQUIPMENT,
    FUNCTIONALLOCATION,
    INSPECTIONPARTIALLOT,
    INSPECTIONSUBSETDATE,
    INSPECTIONSUBSETLONGCHARKEY,
    INSPECTIONSUBSETQTYUNIT,
    INSPECTIONSUBSETREWORKQTY,
    INSPECTIONSUBSETSCRAPQTY,
    INSPECTIONSUBSETSHORTCHARKEY,
    INSPECTIONSUBSETSORTKEY,
    INSPECTIONSUBSETTIME,
    INSPECTIONSUBSETYIELDQTY,
    INSPECTOR,
    INSPSBSTDATEFLDPROPERTY,
    INSPSBSTEQUIPPROPERTY,
    INSPSBSTFUNCNLLOCPROPERTY,
    INSPSBSTLONGNMBRFLDPROPERTY,
    INSPSBSTLONGTXTFLDPROPERTY,
    INSPSBSTMATLSMPLPROPERTY,
    INSPSBSTSHRTNMBRFLDPROPERTY,
    INSPSBSTSHRTTXTFLDPROPERTY,
    INSPSBSTTIMEFLDPROPERTY,
    INSPSUBSETLONGNUMERICKEY,
    INSPSUBSETSHORTNUMERICKEY,
    INSPSUBSETUSAGEDCSNCODE,
    INSPSUBSETUSAGEDCSNCODEGROUP,
    INSPSUBSETUSAGEDCSNVALUATION,
    INSPSUBSETUSAGEDECISIONCATALOG,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LASTCHANGETIME,
    SELECTEDCODESET,
    SELECTEDCODESETPLANT,
    SHOPFLOORITEM,
    PRIMARY KEY (INSPECTIONLOT, INSPECTIONSUBSETINTERNALID, INSPPLANOPERATIONINTERNALID, MATERIALSAMPLE)
);

Learn More