DEMO_SALES_SO_I

Transparent Table Application Table
9 Fields 7 CDS Views

Sales Order Item Table

DEMO_SALES_SO_I is an SAP database table in S/4HANA. Sales Order Item Table. It contains 9 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
DEMO_RAP_EXT_DET_ACT_CHILD view_entity from CDS view entity, o_,i RAP managed
DEMO_SALES_CDS_SO_I view from SDDL: Interface (BO) View for SOI
DEMO_SALES_CDS_SO_I_2 view_entity from CDS view entity, o_,i RAP managed
DEMO_SALES_CDS_SO_I_3 view_entity from CDS view entity, o_,i RAP managed
DEMO_SALES_CDS_SO_I_VE view_entity from CDS view entity, sales order item
DEMO_SALES_CDS_SO_I1 view_entity from SDDL: Interface (BO) View for SOI
DEMO_SALES_CDS_VIEW_ANALYTICS view from CDS View for Sales Order

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY client abap.clnt
KEY so_item_key demo_sales_raw16 GUID
parent_key demo_sales_raw16 GUID
material abap.char
posnr int2 INT2
gross_amount abap.curr
currency abap.cuky
quantity abap.quan
unit abap.unit

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.

-- Sales Order Item Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DEMO_SALES_SO_I (
    CLIENT,        -- abap.clnt
    SO_ITEM_KEY,   -- GUID [demo_sales_raw16]
    PARENT_KEY,    -- GUID [demo_sales_raw16]
    MATERIAL,      -- abap.char
    POSNR,         -- INT2 [int2]
    GROSS_AMOUNT,  -- abap.curr
    CURRENCY,      -- abap.cuky
    QUANTITY,      -- abap.quan
    UNIT,          -- abap.unit
    PRIMARY KEY (CLIENT, SO_ITEM_KEY)
);

Learn More