sepm_sddl_address

DDL: SEPM_SDDL_ADDRESS SQL: SEPM_V_ADDRESS Type: view
9 Fields 1 Data Sources 1 Associations

sepm_sddl_address is a CDS View in SAP S/4HANA. It reads from 1 data source (snwd_ad) and exposes 9 fields with key field address_key. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
snwd_ad snwd_ad from

Associations (1)

CardinalityTargetAliasCondition
[1] t005 address_country country = address_country.land1

Annotations (1)

NameValueLevelField
AbapCatalog.sqlViewName SEPM_V_ADDRESS view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY address_key node_key Tree Model: Node Key
city city Location
postal_code postal_code Postal Code
street street Street Code
building building Building code
country country Venue: Ctry/Reg
address_type address_type Address Type
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 sepm_sddl_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: SEPM_V_ADDRESS

CREATE VIEW sepm_sddl_address AS
SELECT
  node_key AS address_key,
  city,
  postal_code,
  street,
  building,
  country,
  address_type,
  latitude,
  longitude
FROM snwd_ad
LEFT OUTER JOIN t005 AS address_country ON country = address_country.land1  -- association [1]
;

Learn More