Sadl_C_Action_Exposure

DDL: SADL_C_ACTION_EXPOSURE SQL: SADLCACEX Type: view
8 Fields 1 Data Sources 1 Associations

Consumption View for Action Exposure

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

Data Sources (1)

SourceAliasJoin Type
Sadl_V_Action_Exposure Sadl_V_Action_Exposure from

Associations (1)

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

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName SADLCACEX view
EndUserText.label Consumption View for Action Exposure view
ObjectModel.compositionRoot true view
ObjectModel.transactionalProcessingDelegated true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY Node_Key Sadl_V_Action_Exposure Node_Key Tree Model: Node Key
SalesOrder Sadl_V_Action_Exposure SalesOrder SD Document
BusinessPartner Sadl_V_Action_Exposure BusinessPartner Issuing Authority
CurrencyCode Sadl_V_Action_Exposure CurrencyCode Currency Code
GrossAmount Sadl_V_Action_Exposure GrossAmount Gross value
NetAmount Sadl_V_Action_Exposure NetAmount Stated Amount
TaxAmount Sadl_V_Action_Exposure TaxAmount Tax Amt in Rptg Crcy
_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_C_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: SADLCACEX

CREATE VIEW Sadl_C_Action_Exposure AS
SELECT
  Sadl_V_Action_Exposure.Node_Key AS Node_Key,
  Sadl_V_Action_Exposure.SalesOrder AS SalesOrder,
  Sadl_V_Action_Exposure.BusinessPartner AS BusinessPartner,
  Sadl_V_Action_Exposure.CurrencyCode AS CurrencyCode,
  Sadl_V_Action_Exposure.GrossAmount AS GrossAmount,
  Sadl_V_Action_Exposure.NetAmount AS NetAmount,
  Sadl_V_Action_Exposure.TaxAmount AS TaxAmount
FROM Sadl_V_Action_Exposure
LEFT OUTER JOIN Sadl_C_Action_Exposure_Item AS _Items ON _Items.Parent_Key = Node_Key  -- association [0..*]
;

Learn More