C_SADL_V_EXP_FI_PARAM

DDL: C_SADL_V_EXP_FI_PARAM SQL: C_EXP_FI_PARAM Type: view
16 Fields 1 Data Sources

SADLGW: Test view for FI parameters

C_SADL_V_EXP_FI_PARAM is a CDS View that provides data about "SADLGW: Test view for FI parameters" in SAP S/4HANA. It reads from 1 data source (snwd_so) and exposes 16 fields with key fields salesOrderKey, SalesOrder.

Data Sources (1)

SourceAliasJoin Type
snwd_so so from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName C_EXP_FI_PARAM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label SADLGW: Test view for FI parameters view
AbapCatalog.preserveKey true view
OData.entitySet.name SADL_GW_EXP_FI_PARA view
Semantics.personalData.entitySemantics #DATA_SUBJECT view
Semantics.personalData.dataSubjectRole customer view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY salesOrderKey node_key Tree Model: Node Key
KEY SalesOrder snwd_so so_id Sales Order ID
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
OverallStatus snwd_so overall_status Overall Sts
LifecycleStatus snwd_so lifecycle_status Status
BillingStatus snwd_so billing_status SO Confirmation
DeliveryStatus snwd_so delivery_status SO Ordering
CreatedAt snwd_so created_at Uploaded On
CreatedBy snwd_so created_by Version Created By
ChangedAt snwd_so changed_at Timestamp
Buyer buyer_guid Node Key
BillToAddress bill_to_adr_guid Node Key
ChangedBy snwd_so changed_by User Name

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_V_EXP_FI_PARAM.
-- 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: C_EXP_FI_PARAM

CREATE VIEW C_SADL_V_EXP_FI_PARAM AS
SELECT
  node_key AS salesOrderKey,
  so.so_id AS SalesOrder,
  so.currency_code AS CurrencyCode,
  so.gross_amount AS GrossAmount,
  so.net_amount AS NetAmount,
  so.tax_amount AS TaxAmount,
  so.overall_status AS OverallStatus,
  so.lifecycle_status AS LifecycleStatus,
  so.billing_status AS BillingStatus,
  so.delivery_status AS DeliveryStatus,
  so.created_at AS CreatedAt,
  so.created_by AS CreatedBy,
  so.changed_at AS ChangedAt,
  buyer_guid AS Buyer,
  bill_to_adr_guid AS BillToAddress,
  so.changed_by AS ChangedBy
FROM snwd_so AS so
;

Learn More