Sadl_V_Action_Exposure

DDL: SADL_V_ACTION_EXPOSURE SQL: SADLVACEX Type: view

Test View for Action Exposure

Sadl_V_Action_Exposure is a CDS View that provides data about "Test View for Action Exposure" in SAP S/4HANA. It reads from 2 data sources (snwd_bp, snwd_so) and exposes 8 fields with key field Node_Key. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
snwd_bp bp left_outer
snwd_so header from

Associations (1)

CardinalityTargetAliasCondition
[0..*] Sadl_V_Action_Exposure_Item _Items _Items.Parent_Key = $projection.Node_Key

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName SADLVACEX view
EndUserText.label Test View for Action Exposure view
ObjectModel.compositionRoot true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.writeActivePersistence SADLVACEX view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY Node_Key snwd_so node_key Tree Model: Node Key
SalesOrder snwd_so so_id Sales Order ID
BusinessPartner snwd_bp bp_id BusPartner
CurrencyCode snwd_so currency_code Currency Code
GrossAmount snwd_so gross_amount Tax-Inclusive Amount
NetAmount snwd_so net_amount Tax-Exclusive Amount
TaxAmount snwd_so tax_amount VAT Amount Type
_Items _Items

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_V_Action_Exposure.
-- 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: SADLVACEX

CREATE VIEW Sadl_V_Action_Exposure AS
SELECT
  header.node_key AS Node_Key,
  header.so_id AS SalesOrder,
  bp.bp_id AS BusinessPartner,
  header.currency_code AS CurrencyCode,
  header.gross_amount AS GrossAmount,
  header.net_amount AS NetAmount,
  header.tax_amount AS TaxAmount
FROM snwd_so AS header
LEFT OUTER JOIN snwd_bp AS bp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Sadl_V_Action_Exposure_Item AS _Items ON _Items.Parent_Key = Node_Key  -- association [0..*]
;