SADL_V_AUNIT_SO

CDS View

SalesOrder for local unit tests

SADL_V_AUNIT_SO is a CDS View in S/4HANA. SalesOrder for local unit tests. It contains 10 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
Sadl_V_AUnit_P_SO_C view from Sales Order Consumption
Sadl_V_Aunit_So_Agg view from Analytical View
Sadl_V_Aunit_So_C_Expr view from Consumption View with an Expression
Sadl_V_Aunit_So_C_PathExpr view from Path Expressions
Sadl_V_Aunit_So_Cvb view from Consumption View with View Building
SADL_V_AUnit_SO_TP view from SO with faked transacational processing
Sadl_V_Aunit_SoW_C view from Sales Order Consumption View for AUTs
SADL_V_CONSUMPTION_PARSE_Test view from Sales Order Consumption View for AUTs

Fields (10)

KeyField CDS FieldsUsed in Views
KEY node_key node_key 2
_Items _BoItems 1
buyer_guid CONS_BUYER_BUID 1
created_at created_at,created_at_base 2
created_by created_by 4
currency_code currency_code,CurrencyConsumption 2
gross_amount gross_amount 1
net_amount net_amount 1
SalesOrderID SalesOrderID 1
tax_amount tax_amount 1

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.

-- SalesOrder for local unit tests
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SADL_V_AUNIT_SO (
    NODE_KEY,
    _ITEMS,
    BUYER_GUID,
    CREATED_AT,
    CREATED_BY,
    CURRENCY_CODE,
    GROSS_AMOUNT,
    NET_AMOUNT,
    SALESORDERID,
    TAX_AMOUNT,
    PRIMARY KEY (NODE_KEY)
);