ACMTST_DB_SO

Transparent Table Temporary Data
11 Fields 1 CDS Views

ACMTST: Sales Order Header (DB-Table)

ACMTST_DB_SO is an SAP database table in S/4HANA. ACMTST: Sales Order Header (DB-Table). It contains 11 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
ACMTST_CDSV_UN view from

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY uuid acmtst_id ID
so_id acmtst_so_id Sales Order ID
customer_uuid acmtst_id ID
currency_code abap.cuky Currency Code
gross_amount abap.curr Total Gross Amount
net_amount abap.curr Total Net Amount
tax_amount abap.curr Total Tax Amount
lifecycle_status acmtst_so_lc_status SO Lifecycle
billing_status acmtst_so_cf_status SO Confirmation
delivery_status acmtst_so_or_status SO Ordering

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.

-- ACMTST: Sales Order Header (DB-Table)
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ACMTST_DB_SO (
    CLIENT,            -- Client [mandt]
    UUID,              -- ID [acmtst_id]
    SO_ID,             -- Sales Order ID [acmtst_so_id]
    CUSTOMER_UUID,     -- ID [acmtst_id]
    CURRENCY_CODE,     -- Currency Code [abap.cuky]
    GROSS_AMOUNT,      -- Total Gross Amount [abap.curr]
    NET_AMOUNT,        -- Total Net Amount [abap.curr]
    TAX_AMOUNT,        -- Total Tax Amount [abap.curr]
    LIFECYCLE_STATUS,  -- SO Lifecycle [acmtst_so_lc_status]
    BILLING_STATUS,    -- SO Confirmation [acmtst_so_cf_status]
    DELIVERY_STATUS,   -- SO Ordering [acmtst_so_or_status]
    PRIMARY KEY (CLIENT, UUID)
);

Learn More