SADL_GwVAunitV2So

DDL: SADL_GW_V_AUNIT_V2_SO SQL: SADLGWVAUV2SO Type: view
17 Fields 1 Data Sources 2 Associations

CDS View for Unit Testing of SADL Bundle

SADL_GwVAunitV2So 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 17 fields with key field SalesOrderUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
snwd_so SalesOrder from

Associations (2)

CardinalityTargetAliasCondition
[0..*] SADL_GwVAunitV2Soi _Items $projection.SalesOrderUUID = _Items.parent_key
[0..*] SADL_GwVAunitV2Soi _OtherItems__AssocWithLongName $projection.SalesOrderUUID = _OtherItems__AssocWithLongName.parent_key

Annotations (4)

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

Fields (17)

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
_Items _Items
_OtherItems__AssocWithLongName _OtherItems__AssocWithLongName
_Self _Self
_Currency _Currency

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_GwVAunitV2So.
-- 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: SADLGWVAUV2SO

CREATE VIEW SADL_GwVAunitV2So 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
LEFT OUTER JOIN SADL_GwVAunitV2Soi AS _Items ON SalesOrderUUID = _Items.parent_key  -- association [0..*]
LEFT OUTER JOIN SADL_GwVAunitV2Soi AS _OtherItems__AssocWithLongName ON SalesOrderUUID = _OtherItems__AssocWithLongName.parent_key  -- association [0..*]
;

Learn More