C_Sadl_DraftItemCore_WOA

DDL: C_SADL_DRAFT_ITEM_CORE_WOA SQL: CSADL_DRFTIM_WOA Type: view

Consumption-View without own Annotations

C_Sadl_DraftItemCore_WOA is a CDS View that provides data about "Consumption-View without own Annotations" in SAP S/4HANA. It reads from 1 data source (I_Sadl_DraftItemCore) and exposes 7 fields with key fields SalesOrder, ItemPosition. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_Sadl_DraftItemCore Document from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_Sadl_DraftRootCore_WOA _Sadl_DraftRootCore $projection.SalesOrder = _Sadl_DraftRootCore.SalesOrder

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName CSADL_DRFTIM_WOA view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Consumption-View without own Annotations view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder I_Sadl_DraftItemCore SalesOrder SD Document
KEY ItemPosition I_Sadl_DraftItemCore ItemPosition
CurrencyCode I_Sadl_DraftItemCore CurrencyCode
GrossAmount I_Sadl_DraftItemCore GrossAmount Gross value
netAmount I_Sadl_DraftItemCore netAmount Stated Amount
taxAmount I_Sadl_DraftItemCore taxAmount Tax Amt in Rptg Crcy
_Sadl_DraftRootCore _Sadl_DraftRootCore

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 C_Sadl_DraftItemCore_WOA.
-- 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: CSADL_DRFTIM_WOA

CREATE VIEW C_Sadl_DraftItemCore_WOA AS
SELECT
  Document.SalesOrder AS SalesOrder,
  Document.ItemPosition AS ItemPosition,
  Document.CurrencyCode AS CurrencyCode,
  Document.GrossAmount AS GrossAmount,
  Document.netAmount AS netAmount,
  Document.taxAmount AS taxAmount
FROM I_Sadl_DraftItemCore AS Document
LEFT OUTER JOIN C_Sadl_DraftRootCore_WOA AS _Sadl_DraftRootCore ON SalesOrder = _Sadl_DraftRootCore.SalesOrder  -- association [1..1]
;