SADL_GwVAunitSo

DDL: SADL_GW_V_AUNIT_SO SQL: SADLGWVAUSO Type: view Package: SADL_GW_V4_DT_EXPOSURE_BUNDLE
13 Fields 1 Data Sources

CDS View for Unit Testing of SADL Bundle

SADL_GwVAunitSo is a CDS View that provides data about "CDS View for Unit Testing of SADL Bundle" in SAP S/4HANA. It reads from 1 data source (snwd_so) and exposes 13 fields with key field SalesOrderUUID. Part of development package SADL_GW_V4_DT_EXPOSURE_BUNDLE.

Data Sources (1)

SourceAliasJoin Type
snwd_so SalesOrder from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName SADLGWVAUSO view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CDS View for Unit Testing of SADL Bundle view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY SalesOrderUUID snwd_so node_key Tree Model: Node Key
SalesOrderID snwd_so so_id Sales Order ID
created_by snwd_so created_by Version Created By
created_at snwd_so created_at Uploaded On
changed_by snwd_so changed_by User Name
changed_at snwd_so changed_at Timestamp
note_guid snwd_so note_guid Node Key
buyer_guid snwd_so buyer_guid Node Key
CurrencyCode snwd_so currency_code Currency Code
gross_amount snwd_so gross_amount Tax-Inclusive Amount
net_amount snwd_so net_amount Tax-Exclusive Amount
tax_amount snwd_so tax_amount VAT Amount Type
op_id snwd_so op_id Opportunity ID

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view SADL_GwVAunitSo.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: SADLGWVAUSO

CREATE VIEW SADL_GwVAunitSo AS
SELECT
  SalesOrder.node_key AS SalesOrderUUID,
  SalesOrder.so_id AS SalesOrderID,
  SalesOrder.created_by AS created_by,
  SalesOrder.created_at AS created_at,
  SalesOrder.changed_by AS changed_by,
  SalesOrder.changed_at AS changed_at,
  SalesOrder.note_guid AS note_guid,
  SalesOrder.buyer_guid AS buyer_guid,
  SalesOrder.currency_code AS CurrencyCode,
  SalesOrder.gross_amount AS gross_amount,
  SalesOrder.net_amount AS net_amount,
  SalesOrder.tax_amount AS tax_amount,
  SalesOrder.op_id AS op_id
FROM snwd_so AS SalesOrder
;

Learn More