SADL_V_ExpVoc_Customer

DDL: SADL_V_EXPVOC_CUSTOMER SQL: SADL_V_E_CUST Type: view
8 Fields 1 Data Sources

Integration Test CDS View

SADL_V_ExpVoc_Customer is a CDS View that provides data about "Integration Test CDS View" in SAP S/4HANA. It reads from 1 data source (scustom) and exposes 8 fields with key field CustomerID.

Data Sources (1)

SourceAliasJoin Type
scustom scustom from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName SADL_V_E_CUST view
ClientDependent true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Integration Test CDS View view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY CustomerID id WorklistID
FullName name Zone name
Country country Venue: Ctry/Reg
City city Location
Street street Street Code
PostBox postbox PO Box
PhoneNumber telephone Tel.
EmailAdress email Rec. Doc. per e-Mail

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 SADL_V_ExpVoc_Customer.
-- 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: SADL_V_E_CUST

CREATE VIEW SADL_V_ExpVoc_Customer AS
SELECT
  id AS CustomerID,
  name AS FullName,
  Country,
  City,
  Street,
  PostBox,
  telephone AS PhoneNumber,
  email AS EmailAdress
FROM scustom
;

Learn More