TQ41

Transparent Table Customizing Table
3 Fields 1 CDS Views

Storage Locations for Material Samples

TQ41 is an SAP database table in S/4HANA. Storage Locations for Material Samples. It contains 3 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MatlSampleStorageLocation view_entity from BASIC Material Sample Storage Location

Fields (3)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY werks werks_d Plant
KEY aufbewort qaufbewort Sample Location

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.

-- Storage Locations for Material Samples
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TQ41 (
    MANDT,      -- Client [mandt]
    WERKS,      -- Plant [werks_d]
    AUFBEWORT,  -- Sample Location [qaufbewort]
    PRIMARY KEY (MANDT, WERKS, AUFBEWORT)
);

Learn More