sfpm_ida_test_cds_adress

DDL: SFPM_IDA_TEST_CDS_ADRESS SQL: SFPM_IDA_TEST_AD Type: view
7 Fields 1 Data Sources

sfpm_ida_test_cds_adress is a CDS View in SAP S/4HANA. It reads from 1 data source (fpm_ida_test_adr) and exposes 7 fields with key field address_key.

Data Sources (1)

SourceAliasJoin Type
fpm_ida_test_adr fpm_ida_test_adr from

Annotations (1)

NameValueLevelField
AbapCatalog.sqlViewName SFPM_IDA_TEST_AD view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY address_key adress_id
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

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 sfpm_ida_test_cds_adress.
-- 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: SFPM_IDA_TEST_AD

CREATE VIEW sfpm_ida_test_cds_adress AS
SELECT
  adress_id AS address_key,
  city,
  postal_code,
  street,
  building,
  country,
  address_type
FROM fpm_ida_test_adr
;

Learn More