I_BusinessUserBasic

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_BusinessUserBasic.
-- 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 I_BusinessUserBasic AS
SELECT
  _BusinessPartner.partner AS BusinessPartner,
  _BusinessPartner.partner_guid AS BusinessPartnerUUID,
  _BusinessPartner.name_last AS LastName,
  _BusinessPartner.name_first AS FirstName,
  usr21.techdesc AS PersonFullName,
  _BusinessPartner.title AS FormOfAddress,
  _BusinessPartner.title_aca1 AS AcademicTitle,
  _BusinessPartner.title_aca2 AS AcademicSecondTitle,
  _BusinessPartner.langu_corr AS CorrespondenceLanguage,
  _BusinessPartner.namemiddle AS MiddleName,
  _BusinessPartner.name_lst2 AS AdditionalLastName,
  _BusinessPartner.name_last2 AS BirthName,
  _BusinessPartner.nickname AS NickName,
  _BusinessPartner.initials AS Initials,
  _BusinessPartner.prefix1 AS LastNamePrefix,
  _BusinessPartner.prefix2 AS LastNameSecondPrefix,
  _BusinessPartner.title_royl AS NameSupplement,
  cast( usr21.bname as vdm_userid preserving type ) AS UserID,
  _BusinessPartner.xdele AS IsMarkedForArchiving,
  _BusinessPartner.xblck AS BusinessPartnerIsBlocked,
  _BusinessPartner.crusr AS CreatedByUser,
  _BusinessPartner.crdat AS CreationDate,
  _BusinessPartner.crtim AS CreationTime,
  _BusinessPartner.chusr AS LastChangedByUser,
  _BusinessPartner.chdat AS LastChangeDate,
  _BusinessPartner.chtim AS LastChangeTime,
  _BusinessPartner.xpcpt AS IsBusinessPurposeCompleted,
  _BusinessPartner.augrp AS AuthorizationGroup,
  _BusinessPartner.xdcset AS DataControllerSet,
  _BusinessPartner.data_ctrlr1 AS DataController1,
  _BusinessPartner.data_ctrlr2 AS DataController2,
  _BusinessPartner.data_ctrlr3 AS DataController3,
  _BusinessPartner.data_ctrlr4 AS DataController4,
  _BusinessPartner.data_ctrlr5 AS DataController5,
  _BusinessPartner.data_ctrlr6 AS DataController6,
  _BusinessPartner.data_ctrlr7 AS DataController7,
  _BusinessPartner.data_ctrlr8 AS DataController8,
  _BusinessPartner.data_ctrlr9 AS DataController9,
  _BusinessPartner.data_ctrlr10 AS DataController10
FROM but000 AS _BusinessPartner
INNER JOIN usr21 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_User AS _User ON UserID = _User.UserID  -- association [0..1]
LEFT OUTER JOIN I_WorkplaceAddress AS _WorkplaceAddress ON BusinessPartnerUUID = _WorkplaceAddress.BusinessPartnerUUID  -- association [0..1]
LEFT OUTER JOIN I_BPUsrRole AS _BusinessPartnerRole ON BusinessPartner = _BusinessPartnerRole.BusinessPartner  -- association [0..*]
LEFT OUTER JOIN I_BPUsrExternalID AS _BusinessPartnerExternalID ON BusinessPartner = _BusinessPartnerExternalID.BusinessPartner  -- association [0..*]
;