fiscds_userdefaultcontactdata

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 fiscds_userdefaultcontactdata.
-- 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: FISV_USRDFLTDTA
-- Parameters: p_keydate : abap.char( 14 )

CREATE VIEW fiscds_userdefaultcontactdata AS
SELECT
  fiscds_adrp.bname AS UserKey,
  fiscds_adrp.addrnumber AS AddressId,
  cast( ' ' as abap.char(30)) AS FormOfAddress,
  tsad2.title_text AS AcademicTitleName,
  fiscds_adrp.title AS title,
  fiscds_adrp.name_first AS FirstName,
  fiscds_adrp.name_last AS LastName,
  fiscds_adrp.name_text AS PersonFullName,
  fiscds_adrp.department AS Department,
  fiscds_adrp.function AS FunctionalTitleName,
  fiscds_adrp.building AS Building,
  fiscds_adrp.floor AS Floor,
  fiscds_adrp.roomnumber AS RoomNumber,
  fiscds_adrp.id_code AS CorrespondenceShortName,
  fiscds_adrp.ih_mail AS InhouseMail,
  fiscds_adr2_phone.country AS CountryPhone,
  fiscds_adr2_phone.country_dialing_code_phone AS CountryDialingCodePhone,
  fiscds_adr2_phone.spras AS CountryPhoneLangu,
  fiscds_adr2_phone.landx AS CountryPhoneName,
  fiscds_adr2_phone.phone_number AS PhoneNumber,
  fiscds_adr2_phone.phone_number_extension AS PhoneNumberExtension,
  fiscds_adr2_phone.international_phone_number AS InternationalPhoneNumber,
  fiscds_adr2_phone.dft_receiv AS PhoneIsSMSEnabled,
  fiscds_adr2_mphone.country AS CountryMobilePhone,
  fiscds_adr2_mphone.country_dialing_code_mobile AS CountryDialingCodeMobilePhone,
  fiscds_adr2_mphone.spras AS CountryMobilePhoneLangu,
  fiscds_adr2_mphone.landx AS CountryMobilePhoneName,
  fiscds_adr2_mphone.mobile_phone_number AS MobilePhoneNumber,
  fiscds_adr2_mphone.international_mobile_phone AS InternationalMobilePhoneNumber,
  fiscds_adr3_fax.country_fax AS CountryFax,
  fiscds_adr3_fax.country_dialing_code_fax AS CountryDialingCodeFax,
  fiscds_adr3_fax.spras AS CountryFaxLangu,
  fiscds_adr3_fax.landx AS CountryFaxName,
  fiscds_adr3_fax.fax_number AS FaxNumber,
  fiscds_adr3_fax.fax_number_extension AS FaxNumberExtension,
  fiscds_adr3_fax.international_fax_number AS InternationalFaxNumber,
  fiscds_adr6_email.smtp_addr AS EmailAddress,
  case fiscds_adrp.deflt_comm when 'TEL' then case fiscds_adr2_phone.flagdefault_phone when 'X' then cast( fiscds_adrp.deflt_comm as abap.char(3)) else cast( 'MOB' as abap.char(3)) end else fiscds_adrp.deflt_comm end as PrfrdCommMediumType AS deflt_commendasPrfrdCommMediumType
LEFT OUTER JOIN fiscds_adr2_phone ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fiscds_adr2_mphone ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fiscds_adr3_fax ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fiscds_adr6_email ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tsad2 ON /* join condition not captured in parsed metadata */
;