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
demo_sales_cds_inv_header view_entity inner
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
DEMO_SALES_CDS_SO_VE_SIMPLE view_entity from
DEMO_SALES_ORDER_WHERE view_entity from

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