P_BPUsrEEWASmtpSrchNonUnique

DDL: P_BPUSREEWASMTPSRCHNONUNIQUE Type: view_entity BASIC
6 Fields 2 Data Sources

Workplace Address SmtpSrch NonUnique

P_BPUsrEEWASmtpSrchNonUnique is a Basic CDS View that provides data about "Workplace Address SmtpSrch NonUnique" in SAP S/4HANA. It reads from 2 data sources (P_BPUsrEEWASmtpSrch, P_BPUsrEEWASmtpSrchNonUniSub) and exposes 6 fields with key field UserID.

Data Sources (2)

SourceAliasJoin Type
P_BPUsrEEWASmtpSrch P_BPUsrEEWASmtpSrch from
P_BPUsrEEWASmtpSrchNonUniSub P_BPUsrEEWASmtpSrchNonUniSub inner

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Workplace Address SmtpSrch NonUnique view
VDM.private true view
VDM.viewType #BASIC view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY UserID P_BPUsrEEWASmtpSrch UserID User Name
BusinessPartnerUUID P_BPUsrEEWASmtpSrch BusinessPartnerUUID UUID
EMail P_BPUsrEEWASmtpSrch EMail Rec. Doc. per e-Mail
EMailMatchCode P_BPUsrEEWASmtpSrch EMailMatchCode E-Mail Address
ValidFrom P_BPUsrEEWASmtpSrch ValidFrom Vers.Valid From
ValidTo P_BPUsrEEWASmtpSrch ValidTo Vers.Valid To

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 P_BPUsrEEWASmtpSrchNonUnique.
-- 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.

CREATE VIEW P_BPUsrEEWASmtpSrchNonUnique AS
SELECT
  P_BPUsrEEWASmtpSrch.UserID AS UserID,
  P_BPUsrEEWASmtpSrch.BusinessPartnerUUID AS BusinessPartnerUUID,
  P_BPUsrEEWASmtpSrch.EMail AS EMail,
  P_BPUsrEEWASmtpSrch.EMailMatchCode AS EMailMatchCode,
  P_BPUsrEEWASmtpSrch.ValidFrom AS ValidFrom,
  P_BPUsrEEWASmtpSrch.ValidTo AS ValidTo
FROM P_BPUsrEEWASmtpSrch
INNER JOIN P_BPUsrEEWASmtpSrchNonUniSub ON /* join condition not captured in parsed metadata */
;

Learn More