C_Sadl_Voc_Salesorder_DFA

DDL: C_SADL_VOC_SALESORDER_DFA SQL: CSADL_VOC_SODFA Type: view CONSUMPTION Package: SADL_GW_EXPOSURE_VOCAN_MOCK
17 Fields 1 Data Sources 1 Associations

Sales Order - DataField For Annotation

C_Sadl_Voc_Salesorder_DFA is a Consumption CDS View that provides data about "Sales Order - DataField For Annotation" in SAP S/4HANA. It reads from 1 data source (I_Sadl_Voc_Salesorder) and exposes 17 fields with key field node_key. It has 1 association to related views. Part of development package SADL_GW_EXPOSURE_VOCAN_MOCK.

Data Sources (1)

SourceAliasJoin Type
I_Sadl_Voc_Salesorder so from

Associations (1)

CardinalityTargetAliasCondition
[0..1] C_Sadl_Voc_Businesspartner _BusinessPartner _BusinessPartner.BusinessPartnerKey = $projection.BusinessPartnerGuid

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName CSADL_VOC_SODFA view
EndUserText.label Sales Order - DataField For Annotation view
VDM.viewType #CONSUMPTION view
UI.headerInfo.typeName Sales Order view
UI.headerInfo.title.value SalesOrderId view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY node_key I_Sadl_Voc_Salesorder node_key Tree Model: Node Key
SalesOrderId I_Sadl_Voc_Salesorder SalesOrderId Sales Order ID
CreatedBy I_Sadl_Voc_Salesorder CreatedBy User Name
CreatedAt I_Sadl_Voc_Salesorder CreatedAt Time Stamp
ChangedBy I_Sadl_Voc_Salesorder ChangedBy User Name
ChangedAt I_Sadl_Voc_Salesorder ChangedAt Time Stamp
BusinessPartnerGuid I_Sadl_Voc_Salesorder BusinessPartnerGuid
CurrencyCode I_Sadl_Voc_Salesorder CurrencyCode Currency Code
GrossAmount I_Sadl_Voc_Salesorder GrossAmount Gross value
NetAmount I_Sadl_Voc_Salesorder NetAmount Stated Amount
TaxAmount I_Sadl_Voc_Salesorder TaxAmount Tax Amt in Rptg Crcy
LifecycleStatus I_Sadl_Voc_Salesorder LifecycleStatus Life Cycle Status
BillingStatus I_Sadl_Voc_Salesorder BillingStatus SO Confirmation
DeliveryStatus I_Sadl_Voc_Salesorder DeliveryStatus Delivery Status
OpportunityId I_Sadl_Voc_Salesorder OpportunityId Opportunity ID
OverallStatus I_Sadl_Voc_Salesorder OverallStatus Status Criticality
_BusinessPartner _BusinessPartner

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_Voc_Salesorder_DFA.
-- 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_VOC_SODFA

CREATE VIEW C_Sadl_Voc_Salesorder_DFA AS
SELECT
  so.node_key AS node_key,
  so.SalesOrderId AS SalesOrderId,
  so.CreatedBy AS CreatedBy,
  so.CreatedAt AS CreatedAt,
  so.ChangedBy AS ChangedBy,
  so.ChangedAt AS ChangedAt,
  so.BusinessPartnerGuid AS BusinessPartnerGuid,
  so.CurrencyCode AS CurrencyCode,
  so.GrossAmount AS GrossAmount,
  so.NetAmount AS NetAmount,
  so.TaxAmount AS TaxAmount,
  so.LifecycleStatus AS LifecycleStatus,
  so.BillingStatus AS BillingStatus,
  so.DeliveryStatus AS DeliveryStatus,
  so.OpportunityId AS OpportunityId,
  so.OverallStatus AS OverallStatus
FROM I_Sadl_Voc_Salesorder AS so
LEFT OUTER JOIN C_Sadl_Voc_Businesspartner AS _BusinessPartner ON _BusinessPartner.BusinessPartnerKey = BusinessPartnerGuid  -- association [0..1]
;

Learn More