C_SADL_VOC_Namespace

DDL: C_SADL_VOC_NAMESPACE SQL: SADLVOCNS Type: view
17 Fields 1 Data Sources

Namespace conversion

C_SADL_VOC_Namespace is a CDS View that provides data about "Namespace conversion" in SAP S/4HANA. It reads from 1 data source (I_Sadl_Voc_Salesorder) and exposes 17 fields with key field node_key.

Data Sources (1)

SourceAliasJoin Type
I_Sadl_Voc_Salesorder I_Sadl_Voc_Salesorder from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName SADLVOCNS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Namespace conversion view
OData.publish true view
OData.entitySet.name /TEST/Namespace_x view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.compositionRoot true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY node_key node_key Tree Model: Node Key
SalesOrderId SalesOrderId Sales Order ID
CreatedBy CreatedBy User Name
CreatedAt CreatedAt Time Stamp
ChangedBy ChangedBy User Name
ChangedAt ChangedAt Time Stamp
BusinessPartnerGuid BusinessPartnerGuid
CurrencyCode CurrencyCode Currency Code
GrossAmount GrossAmount Gross value
NetAmount NetAmount Stated Amount
TaxAmount TaxAmount Tax Amt in Rptg Crcy
LifecycleStatus LifecycleStatus Life Cycle Status
BillingStatus BillingStatus SO Confirmation
DeliveryStatus DeliveryStatus Delivery Status
OpportunityId OpportunityId Opportunity ID
OverallStatus 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_Namespace.
-- 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: SADLVOCNS

CREATE VIEW C_SADL_VOC_Namespace AS
SELECT
  node_key,
  SalesOrderId,
  CreatedBy,
  CreatedAt,
  ChangedBy,
  ChangedAt,
  BusinessPartnerGuid,
  CurrencyCode,
  GrossAmount,
  NetAmount,
  TaxAmount,
  LifecycleStatus,
  BillingStatus,
  DeliveryStatus,
  OpportunityId,
  OverallStatus
FROM I_Sadl_Voc_Salesorder
;

Learn More