A028

Transparent Table Application Table
11 Fields 3 CDS Views

Info Record for Non-Stock Item

A028 is an SAP database table in S/4HANA. Info Record for Non-Stock Item. It contains 11 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_PurInfCndHelpr view left_outer BASIC Helper View For CDS
I_PurInfoRecdNonStkItmPrcgCndn view union BASIC Purch Info Record Non Stock Item Cond
SDM_IR_A0XX view union_all SDM View for Blank A table entries

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY kappl kappl Application
KEY kschl kscha Condition Type
KEY lifnr elifn Supplier
KEY ekorg ekorg Purchasing Org.
KEY matkl matkl Material Group
KEY infnr infnr Info Record
KEY esokz esokz Infotype
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.

-- Info Record for Non-Stock Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE A028 (
    MANDT,  -- Client [mandt]
    KAPPL,  -- Application [kappl]
    KSCHL,  -- Condition Type [kscha]
    LIFNR,  -- Supplier [elifn]
    EKORG,  -- Purchasing Org. [ekorg]
    MATKL,  -- Material Group [matkl]
    INFNR,  -- Info Record [infnr]
    ESOKZ,  -- Infotype [esokz]
    DATBI,  -- Valid To [kodatbi]
    DATAB,  -- Valid From [kodatab]
    KNUMH,  -- Cond.Record No. [knumh]
    PRIMARY KEY (MANDT, KAPPL, KSCHL, LIFNR, EKORG, MATKL, INFNR, ESOKZ, DATBI)
);

Learn More