KOTP472

Transparent Table Application Table
11 Fields 1 CDS Views

WhseNmbr/Rte/Shp-to-Pty/Carr/Matl

KOTP472 is an SAP database table in S/4HANA. WhseNmbr/Rte/Shp-to-Pty/Carr/Matl. It contains 11 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PaDeWaRouteSh2PCarrierMatl view_entity from BASIC PaDeWa for Route/ShpToPty/Carrier/Matl

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY kappl kappl Application
KEY kschl ksch_pv DetermType
KEY ewm_warehouse_number /scwm/lgnum Warehouse No.
KEY ewm_route /scwm/de_routeid_pi Route
KEY kunwe pl_kunwe Ship-to party
KEY carrier lo_hu_carrier Carrier
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.

-- WhseNmbr/Rte/Shp-to-Pty/Carr/Matl
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KOTP472 (
    MANDT,                 -- Client [mandt]
    KAPPL,                 -- Application [kappl]
    KSCHL,                 -- DetermType [ksch_pv]
    EWM_WAREHOUSE_NUMBER,  -- Warehouse No. [/scwm/lgnum]
    EWM_ROUTE,             -- Route [/scwm/de_routeid_pi]
    KUNWE,                 -- Ship-to party [pl_kunwe]
    CARRIER,               -- Carrier [lo_hu_carrier]
    MATNR,                 -- Material [matnr]
    DATBI,                 -- Valid To [kodatbi]
    DATAB,                 -- Valid From [kodatab]
    KNUMH,                 -- Cond.Record No. [knumh]
    PRIMARY KEY (MANDT, KAPPL, KSCHL, EWM_WAREHOUSE_NUMBER, EWM_ROUTE, KUNWE, CARRIER, MATNR, DATBI)
);

Learn More