SADL_V_AUNIT_SO
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA