Swx_Sddl_Address

DDL: SWX_SDDL_ADDRESS SQL: SWX_V_ADDRESS Type: view
6 Fields 1 Data Sources

Workflow Demo: User Address (CDS)

Swx_Sddl_Address is a CDS View that provides data about "Workflow Demo: User Address (CDS)" in SAP S/4HANA. It reads from 1 data source (usr21) and exposes 6 fields with key field bname.

Data Sources (1)

SourceAliasJoin Type
usr21 usr21 from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName SWX_V_ADDRESS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Workflow Demo: User Address (CDS) view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY bname usr21 bname User name
persnumber usr21 persnumber Person Number
addrnumber usr21 addrnumber Address Number
kostl usr21 kostl Substitute CC
bpperson usr21 bpperson BP GUID
organization usr21 organization BP GUID

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 Swx_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: SWX_V_ADDRESS

CREATE VIEW Swx_Sddl_Address AS
SELECT
  usr21.bname AS bname,
  usr21.persnumber AS persnumber,
  usr21.addrnumber AS addrnumber,
  usr21.kostl AS kostl,
  usr21.bpperson AS bpperson,
  usr21.organization AS organization
FROM usr21
;

Learn More