DEMO_SALES_ORDER

Transparent Table Application Table
17 Fields 14 CDS Views

Sales Order Header

DEMO_SALES_ORDER is an SAP database table in S/4HANA. Sales Order Header. It contains 17 fields. 14 CDS views read from this table.

CDS Views using this table (14)

ViewTypeJoinVDMDescription
DEMO_CDS_CLIENT_HANDLING view_entity left_outer CDS View entity_client handling
DEMO_CDS_CLIENT_HANDLING view_entity inner CDS View entity_client handling
DEMO_CDS_CLIENT_HANDLING view_entity right_outer CDS View entity_client handling
DEMO_CDS_CUBE_VIEW view_entity from SDDL: Analytical Cube for SO Header
DEMO_RAP_EXTENSIBILITY_DET_ACT view_entity from CDS view entity, so, RAP managed
DEMO_SALES_CDS_ELEM_ANNOT view_entity inner CDS view entity, example for element annotations
demo_sales_cds_inv_header view_entity inner CDS view entity, sales order invoice header
DEMO_SALES_CDS_SO view from SDDL: Interface (BO) View for SO Header
DEMO_SALES_CDS_SO_1 view_entity from CDS view entity, so, RAP managed
DEMO_SALES_CDS_SO_2 view_entity from CDS view entity, so, RAP managed
DEMO_SALES_CDS_SO_3 view_entity from CDS view entity, so, RAP managed
DEMO_SALES_CDS_SO_VE view_entity from CDS view entity, sales order header
DEMO_SALES_CDS_SO_VE_SIMPLE view_entity from CDS view entity, sales order, simple
DEMO_SALES_ORDER_WHERE view_entity from CDS view entity, example for WHERE condition

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY client abap.clnt
KEY so_key demo_sales_raw16 GUID
id char10 Character Field with Length 10
lifecycle_status demo_sales_lc_status SDDL: DTEL Lifecycle Status
created_by char12 Character Field of Length 12
created_on abap.dats
created_at abap.tims
last_changed_by char12 Character Field of Length 12
last_changed_on abap.dats
last_changed_at abap.tims
buyer_id demo_sales_bupa_id Business Partner ID
ship_to_id demo_sales_bupa_id Business Partner ID
quantity_sum abap.quan
uom_sum abap.unit
amount_sum abap.curr
currency_sum abap.cuky
company_code abap.char

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 Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DEMO_SALES_ORDER (
    CLIENT,            -- abap.clnt
    SO_KEY,            -- GUID [demo_sales_raw16]
    ID,                -- Character Field with Length 10 [char10]
    LIFECYCLE_STATUS,  -- SDDL: DTEL Lifecycle Status [demo_sales_lc_status]
    CREATED_BY,        -- Character Field of Length 12 [char12]
    CREATED_ON,        -- abap.dats
    CREATED_AT,        -- abap.tims
    LAST_CHANGED_BY,   -- Character Field of Length 12 [char12]
    LAST_CHANGED_ON,   -- abap.dats
    LAST_CHANGED_AT,   -- abap.tims
    BUYER_ID,          -- Business Partner ID [demo_sales_bupa_id]
    SHIP_TO_ID,        -- Business Partner ID [demo_sales_bupa_id]
    QUANTITY_SUM,      -- abap.quan
    UOM_SUM,           -- abap.unit
    AMOUNT_SUM,        -- abap.curr
    CURRENCY_SUM,      -- abap.cuky
    COMPANY_CODE,      -- abap.char
    PRIMARY KEY (CLIENT, SO_KEY)
);

Learn More