I_INSPMATERIALSAMPLEAGGREGATE

CDS View
5 Fields 2 CDS Views

Inspection Material Sample Aggregate

I_INSPMATERIALSAMPLEAGGREGATE is a CDS View in S/4HANA. Inspection Material Sample Aggregate. It contains 5 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_InspLotMatlSmplRsltRecg view_entity inner CONSUMPTION Material Sample
C_Qm_InspectionlotsByMtrSmpl view inner CONSUMPTION Inspection lots for main page - group by material sample

Fields (5)

KeyField CDS FieldsUsed in Views
KEY MaterialSample MaterialSample 1
InspCharAcceptedCount InspCharAcceptedCount 1
InspCharOpenCount InspCharOpenCount 1
InspCharRejectedCount InspCharRejectedCount 1
NumberOfSkipInspCharcs NumberOfSkipInspCharcs 1

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 Material Sample Aggregate
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_INSPMATERIALSAMPLEAGGREGATE (
    MATERIALSAMPLE,
    INSPCHARACCEPTEDCOUNT,
    INSPCHAROPENCOUNT,
    INSPCHARREJECTEDCOUNT,
    NUMBEROFSKIPINSPCHARCS,
    PRIMARY KEY (MATERIALSAMPLE)
);

Learn More