I_Sadl_Voc_Address

DDL: I_SADL_VOC_ADDRESS SQL: ISADL_VOC_AD Type: view
11 Fields 1 Data Sources

Vocan Core View: Address

I_Sadl_Voc_Address is a CDS View that provides data about "Vocan Core View: Address" in SAP S/4HANA. It reads from 1 data source (snwd_ad) and exposes 11 fields with key field AddressKey.

Data Sources (1)

SourceAliasJoin Type
snwd_ad snwd_ad from

Annotations (2)

NameValueLevelField
AbapCatalog.sqlViewName ISADL_VOC_AD view
EndUserText.label Vocan Core View: Address view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY AddressKey Tree Model: Node Key
City city Location
PostalCode postal_code Postal Code
Street street Street Code
Building building Building code
Country country Venue: Ctry/Reg
AddressType address_type Address Type
ValidityStartDate val_start_date Validity Start Date
ValidityEndDate val_end_date Validity End Date
Latitude latitude Latitude
Longitude longitude Longitude

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 I_Sadl_Voc_Address.
-- 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: ISADL_VOC_AD

CREATE VIEW I_Sadl_Voc_Address AS
SELECT
  cast( node_key as sysuuid_x preserving type ) AS AddressKey,
  City,
  postal_code AS PostalCode,
  Street,
  Building,
  Country,
  address_type AS AddressType,
  val_start_date AS ValidityStartDate,
  val_end_date AS ValidityEndDate,
  Latitude,
  Longitude
FROM snwd_ad
;

Learn More