I_CmmdtyHedgeSpecUserDetails

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 I_CmmdtyHedgeSpecUserDetails.
-- 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: ICMMHDGSPECUSRDT

CREATE VIEW I_CmmdtyHedgeSpecUserDetails AS
SELECT
  _User.bname AS UserID,
  _User.persnumber AS Person,
  _User.bpperson AS BusinessPartnerUUID,
  _Person.name_first AS FirstName,
  _Person.name_last AS LastName,
  cast(coalesce( _Person.name_text , _User.techdesc ) as ad_namtext preserving type ) AS FullName,
  _User.addrnumber AS AddressID,
  cast(_DefaultPhoneNumber.telnr_long as contactcardphonenumber preserving type ) AS PhoneNumber,
  cast(_DefaultMobilePhoneNumber.telnr_long as contactcardmobilephonenumber preserving type ) AS MobilePhoneNumber,
  cast(_DefaultEmailAddress.smtp_addr as contactcardemailaddress preserving type ) AS EmailAddress,
  _OrgData.department AS Department
FROM usr21 AS _User
LEFT OUTER JOIN adrp AS _Person ON Person = _Person.persnumber AND _Person.persnumber <> ''  -- association [0..*]
LEFT OUTER JOIN adcp AS _OrgData ON _OrgData.addrnumber = AddressID AND _OrgData.persnumber = Person  -- association [0..*]
LEFT OUTER JOIN adr2 AS _DefaultPhoneNumber ON _DefaultPhoneNumber.addrnumber = AddressID AND _DefaultPhoneNumber.persnumber = Person AND _DefaultPhoneNumber.r3_user = '1'  -- association [0..*]
LEFT OUTER JOIN adr2 AS _DefaultMobilePhoneNumber ON _DefaultMobilePhoneNumber.addrnumber = AddressID AND _DefaultMobilePhoneNumber.persnumber = Person AND _DefaultMobilePhoneNumber.r3_user = '3'  -- association [0..*]
LEFT OUTER JOIN adr6 AS _DefaultEmailAddress ON _DefaultEmailAddress.addrnumber = AddressID AND _DefaultEmailAddress.persnumber = Person AND _DefaultEmailAddress.flgdefault = 'X'  -- association [0..*]
;