KOTP210

Transparent Table Application Table
9 Fields 1 CDS Views

Material/plant/storage location

KOTP210 is an SAP database table in S/4HANA. Material/plant/storage location. It contains 9 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PaInDetMaterialPlantStorLoc view_entity from BASIC PaInDet for Material/Plant/Storage Loc

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY kappl kappl Application
KEY kschl ksch_pv DetermType
KEY werks werks_d Plant
KEY lgort lgort_d Location
KEY matnr matnr Material
KEY datbi kodatbi Valid To
datab kodatab Valid From
knumh knumh Cond.Record No.

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/plant/storage location
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KOTP210 (
    MANDT,  -- Client [mandt]
    KAPPL,  -- Application [kappl]
    KSCHL,  -- DetermType [ksch_pv]
    WERKS,  -- Plant [werks_d]
    LGORT,  -- Location [lgort_d]
    MATNR,  -- Material [matnr]
    DATBI,  -- Valid To [kodatbi]
    DATAB,  -- Valid From [kodatab]
    KNUMH,  -- Cond.Record No. [knumh]
    PRIMARY KEY (MANDT, KAPPL, KSCHL, WERKS, LGORT, MATNR, DATBI)
);

Learn More