OIJTSMAT

Transparent Table Application Table
6 Fields 1 CDS Views

OIL-TSW: TS Rundown/Planning material table

OIJTSMAT is an SAP database table in S/4HANA. OIL-TSW: TS Rundown/Planning material table. It contains 6 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
OIJ09_SourceNominationSchedule view inner Source Schedule

Fields (6)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY tsyst oij_tsyst Trans system
KEY pmatnr matnr Material
tsnam oij_tsnam TS name
pmatname maktx Description
pwerk oij_werk Intr. plant

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.

-- OIL-TSW: TS Rundown/Planning material table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIJTSMAT (
    MANDT,     -- Client [mandt]
    TSYST,     -- Trans system [oij_tsyst]
    PMATNR,    -- Material [matnr]
    TSNAM,     -- TS name [oij_tsnam]
    PMATNAME,  -- Description [maktx]
    PWERK,     -- Intr. plant [oij_werk]
    PRIMARY KEY (MANDT, TSYST, PMATNR)
);

Learn More