I_MATERIALSAMPLE

CDS View
19 Fields 9 CDS Views

Material Sample

I_MATERIALSAMPLE is a CDS View in S/4HANA. Material Sample. It contains 19 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
C_InspLotMatlSmplRsltRecg view_entity inner CONSUMPTION Material Sample
C_Materialsampleobjpage view from CONSUMPTION Material Sample
C_MtrlSmplSameDrwbngOp view from CONSUMPTION Samples with Same Sample Drawing
C_Qm_InspectionlotsByMtrSmpl view inner CONSUMPTION Inspection lots for main page - group by material sample
C_Qm_Inspectlot_Filterbar view inner CONSUMPTION Result Recording filter bar
I_InspectionLotValueHelp view inner COMPOSITE Inspection Lot
I_MaterialSampleDetails view from COMPOSITE CDS View for Material Sample Details
I_MaterialSampleStdVH view from COMPOSITE Material Sample
I_MaterialSampleVH view from COMPOSITE Material Sample Value Help

Fields (19)

KeyField CDS FieldsUsed in Views
KEY MaterialSample MaterialSample 1
_MatlSampleStorageLocation _MatlSampleStorageLocation 1
_StorageLocation _StorageLocation 1
InspectionLot InspectionLot 1
MaterialSampleCategory MaterialSampleCategory 1
MaterialSampleChangedBy MaterialSampleChangedBy 1
MaterialSampleDrawing MaterialSampleDrawing 1
MaterialSampleDrawingLocation MaterialSampleDrawingLocation 1
MaterialSampleResponsibleName MaterialSampleResponsibleName 1
MaterialSampleSize MaterialSampleSize 1
MaterialSampleStorageLocation MaterialSampleStorageLocation 2
MaterialSampleType MaterialSampleType 1
MatlQualityAuthorizationGroup MatlQualityAuthorizationGroup 1
MatlSmplDrawingLocDescription MatlSmplDrawingLocDescription 1
MatlSmplStorageDuration MatlSmplStorageDuration 1
MatlSmplStorageEndDate MatlSmplStorageEndDate 1
MatlSmplStorageInformation MatlSmplStorageInformation 1
Plant Plant 1
StorageLocation StorageLocation 2

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.

-- Material Sample
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MATERIALSAMPLE (
    MATERIALSAMPLE,
    _MATLSAMPLESTORAGELOCATION,
    _STORAGELOCATION,
    INSPECTIONLOT,
    MATERIALSAMPLECATEGORY,
    MATERIALSAMPLECHANGEDBY,
    MATERIALSAMPLEDRAWING,
    MATERIALSAMPLEDRAWINGLOCATION,
    MATERIALSAMPLERESPONSIBLENAME,
    MATERIALSAMPLESIZE,
    MATERIALSAMPLESTORAGELOCATION,
    MATERIALSAMPLETYPE,
    MATLQUALITYAUTHORIZATIONGROUP,
    MATLSMPLDRAWINGLOCDESCRIPTION,
    MATLSMPLSTORAGEDURATION,
    MATLSMPLSTORAGEENDDATE,
    MATLSMPLSTORAGEINFORMATION,
    PLANT,
    STORAGELOCATION,
    PRIMARY KEY (MATERIALSAMPLE)
);

Learn More