_MTRSAMPLE

_MTRSAMPLE is an SAP database table in S/4HANA. It contains 10 fields.

Fields (10)

KeyField CDS FieldsUsed in Views
MaterialSampleCategory MaterialSampleCategory 1
MaterialSampleChangedOn MaterialSampleChangedOn 1
MaterialSampleDrawing MaterialSampleDrawing 1
MaterialSampleDrawingLocation MaterialSampleDrawingLocation 1
MaterialSampleDrawingOnDate MaterialSampleDrawingOnDate 1
MaterialSampleDrawingOnTime MaterialSampleDrawingOnTime 1
MaterialSampleResponsibleName MaterialSampleResponsibleName 1
MaterialSampleStorageLocation MaterialSampleStorageLocation 1
MaterialSampleType MaterialSampleType 1
MatlSmplDrawingLocDescription MatlSmplDrawingLocDescription 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _MTRSAMPLE (
    MATERIALSAMPLECATEGORY,
    MATERIALSAMPLECHANGEDON,
    MATERIALSAMPLEDRAWING,
    MATERIALSAMPLEDRAWINGLOCATION,
    MATERIALSAMPLEDRAWINGONDATE,
    MATERIALSAMPLEDRAWINGONTIME,
    MATERIALSAMPLERESPONSIBLENAME,
    MATERIALSAMPLESTORAGELOCATION,
    MATERIALSAMPLETYPE,
    MATLSMPLDRAWINGLOCDESCRIPTION
);