I_MDQltyBusinessPartner

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_MDQltyBusinessPartner.
-- 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: IMDQBUPA

CREATE VIEW I_MDQltyBusinessPartner AS
SELECT
  BusinessPartner,
  _MDQltyBusinessPartnerRole.BusinessPartnerRole AS BusinessPartnerRole,
  _BusinessPartner.BusinessPartnerUUID AS BusinessPartnerUUID,
  _BusinessPartner.BusinessPartnerCategory AS BusinessPartnerCategory,
  _BusinessPartner.CreatedByUser AS CreatedByUser,
  _BusinessPartner.CreationDate AS CreationDate,
  _BusinessPartner.CreationTime AS CreationTime,
  _BusinessPartner.LastChangedByUser AS LastChangedByUser,
  _BusinessPartner.LastChangeDate AS LastChangeDate,
  _BusinessPartner.LastChangeTime AS LastChangeTime,
  _BusinessPartner.BusinessPartnerIsBlocked AS BusinessPartnerIsBlocked,
  _BusinessPartner.IsMarkedForArchiving AS IsMarkedForArchiving,
  _BusinessPartner.BusinessPartnerIsNotReleased AS BusinessPartnerIsNotReleased,
  _BusinessPartner.ContactPermission AS ContactPermission,
  _BusinessPartner.OrganizationBPName1 AS OrganizationBPName1,
  _BusinessPartner.OrganizationBPName2 AS OrganizationBPName2,
  _BusinessPartner.OrganizationBPName3 AS OrganizationBPName3,
  _BusinessPartner.OrganizationBPName4 AS OrganizationBPName4,
  _BusinessPartner.LegalForm AS LegalForm,
  _BusinessPartner.OrganizationFoundationDate AS OrganizationFoundationDate,
  _BusinessPartner.OrganizationLiquidationDate AS OrganizationLiquidationDate,
  _BusinessPartner.FormOfAddress AS FormOfAddress,
  _BusinessPartner.FormOfAddress AS FormOfAddressPerson,
  _BusinessPartner.FormOfAddress AS FormOfAddressOrganization,
  _BusinessPartner.FormOfAddress AS FormOfAddressGroup,
  _BusinessPartner.ETag AS ETag,
  _BusinessPartner.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _BusinessPartner.AuthorizationGroup AS AuthorizationGroup,
  _BusinessPartner.BusinessPartnerType AS BusinessPartnerType,
  _BusinessPartner.BusinessPartnerPrintFormat AS BusinessPartnerPrintFormat,
  _BusinessPartner.BusinessPartnerGrouping AS BusinessPartnerGrouping,
  _BusinessPartner._CurrentDefaultAddress.AddressID AS AddressID,
  case when _BusinessPartner.BusinessPartnerCategory = '1' then _BusinessPartner.LastName else _BusinessPartner.OrganizationBPName1 end as Name AS OrganizationBPName1endasName,
  case when _BusinessPartner.BusinessPartnerCategory = '1' then _BusinessPartner.FirstName else _BusinessPartner.OrganizationBPName2 end as AdditionalName AS OrganizationBPName2endasAdditionalName,
  _BusinessPartner.PersonNumber AS PersonNumber,
  _BusinessPartner.IsFemale AS IsFemale,
  _BusinessPartner.IsMale AS IsMale,
  _BusinessPartner.IsSexUnknown AS IsSexUnknown,
  _BusinessPartner.FirstName AS FirstName,
  _BusinessPartner.LastName AS LastName,
  _BusinessPartner.AdditionalLastName AS AdditionalLastName,
  _BusinessPartner.BusinessPartnerBirthName AS BusinessPartnerBirthName,
  _BusinessPartner.MiddleName AS MiddleName,
  _BusinessPartner.AcademicTitle AS AcademicTitle,
  _BusinessPartner.AcademicTitle2 AS AcademicTitle2,
  _BusinessPartner.BusinessPartnerSupplementName AS BusinessPartnerSupplementName,
  _BusinessPartner.LastNamePrefix AS LastNamePrefix,
  _BusinessPartner.LastNameSecondPrefix AS LastNameSecondPrefix,
  _BusinessPartner.PersonFullName AS PersonFullName,
  _BusinessPartner.BusinessPartnerNicknameLabel AS BusinessPartnerNicknameLabel,
  _BusinessPartner.Initials AS Initials,
  _BusinessPartner.NameFormat AS NameFormat,
  _BusinessPartner.NameCountry AS NameCountry,
  _BusinessPartner.NaturalPersonEmployerName AS NaturalPersonEmployerName,
  _BusinessPartner.Language AS Language,
  _BusinessPartner.CorrespondenceLanguage AS CorrespondenceLanguage,
  _BusinessPartner.IsNaturalPerson AS IsNaturalPerson,
  _BusinessPartner.BirthDate AS BirthDate,
  _BusinessPartner.BusinessPartnerBirthplaceName AS BusinessPartnerBirthplaceName,
  _BusinessPartner.BusinessPartnerBirthDateStatus AS BusinessPartnerBirthDateStatus,
  _BusinessPartner.BusinessPartnerDeathDate AS BusinessPartnerDeathDate,
  _BusinessPartner.BusinessPartnerOccupation AS BusinessPartnerOccupation,
  _BusinessPartner.BusPartNationality AS BusPartNationality,
  _BusinessPartner.BusPartMaritalStatus AS BusPartMaritalStatus,
  _BusinessPartner.BusinessPartnerIDByExtSystem AS BusinessPartnerIDByExtSystem,
  _BusinessPartner.NonResidentCompanyOriginCntry AS NonResidentCompanyOriginCntry,
  _BusinessPartner.BusinessPartnerSalutation AS BusinessPartnerSalutation,
  _BusinessPartner.GroupBusinessPartnerName1 AS GroupBusinessPartnerName1,
  _BusinessPartner.GroupBusinessPartnerName2 AS GroupBusinessPartnerName2,
  _BusinessPartner.BusinessPartnerGroupType AS BusinessPartnerGroupType,
  _BusinessPartner.SearchTerm1 AS SearchTerm1,
  _BusinessPartner.SearchTerm2 AS SearchTerm2,
  _BusinessPartner.BPFirstNameSearchHelp AS BPFirstNameSearchHelp,
  _BusinessPartner.BPLastNameSearchHelp AS BPLastNameSearchHelp,
  DataControllerSet,
  DataController1,
  DataController2,
  DataController3,
  DataController4,
  DataController5,
  DataController6,
  DataController7,
  DataController8,
  DataController9,
  DataController10,
  _BusinessPartner._CreatedByUser AS _CreatedByUser,
  _BusinessPartner._LastChangedByUser AS _LastChangedByUser,
  _BusinessPartner._AcademicTitleValueHelp AS _AcademicTitleValueHelp,
  _MDQltyBusinessPartnerRole._RoleAllowList AS _RoleAllowList
FROM I_BusinessPartner AS _BusinessPartner
LEFT OUTER JOIN I_MDQltyBusinessPartnerRole AS _MDQltyBusinessPartnerRole ON BusinessPartner = _MDQltyBusinessPartnerRole.BusinessPartner  -- association [0..*]
LEFT OUTER JOIN I_BusPartCategory AS _BusinessPartnerCategory ON BusinessPartnerCategory = _BusinessPartnerCategory.BusinessPartnerCategory  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerLegalForm AS _BusinessPartnerLegalForm ON LegalForm = _BusinessPartnerLegalForm.LegalForm  -- association [0..1]
LEFT OUTER JOIN I_BusPartAuthorizationGroup AS _AuthorizationGroup ON AuthorizationGroup = _AuthorizationGroup.AuthorizationGroup AND _AuthorizationGroup.AuthorizationObject = 'BUPA'  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerType AS _BusinessPartnerType ON BusinessPartnerType = _BusinessPartnerType.BusinessPartnerType  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerPrintFormat AS _PrintFormat ON BusinessPartnerPrintFormat = _PrintFormat.BusinessPartnerPrintFormat  -- association [0..1]
LEFT OUTER JOIN I_BusPartContactPermission AS _ContactPermission ON ContactPermission = _ContactPermission.ContactPermission  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerFormOfAddress AS _FormOfAddress ON FormOfAddressPerson = _FormOfAddress.FormOfAddress AND BusinessPartnerCategory = _FormOfAddress.BusinessPartnerCategory  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerGroupType AS _GroupType ON BusinessPartnerGroupType = _GroupType.BusinessPartnerGroupType  -- association [0..1]
LEFT OUTER JOIN I_BusPartAcademicTitle AS _AcademicTitle2 ON AcademicTitle2 = _AcademicTitle2.AcademicTitle  -- association [0..1]
LEFT OUTER JOIN I_BPGenderValueHelp AS _BusinessPartnerGender ON GenderCodeName = _BusinessPartnerGender.GenderCodeName  -- association [0..1]
LEFT OUTER JOIN I_BusPartPrefixName AS _BusPartPrefixName ON LastNamePrefix = _BusPartPrefixName.LastNamePrefix  -- association [0..1]
LEFT OUTER JOIN I_BusPartPrefixName AS _LastNameSecondPrefixName ON LastNameSecondPrefix = _LastNameSecondPrefixName.LastNamePrefix  -- association [0..1]
LEFT OUTER JOIN I_LanguageText AS _Language ON Language = _Language.LanguageCode AND _Language.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LanguageText AS _CorrespondenceLanguage ON CorrespondenceLanguage = _CorrespondenceLanguage.LanguageCode AND _CorrespondenceLanguage.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Country AS _NameCountry ON NameCountry = _NameCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Nationality ON BusPartNationality = _Nationality.Country  -- association [0..1]
LEFT OUTER JOIN I_Country AS _NonResidentCompOriginCntry ON NonResidentCompanyOriginCntry = _NonResidentCompOriginCntry.Country  -- association [0..1]
LEFT OUTER JOIN I_BusPartNameFormat AS _NameFormat ON NameFormat = _NameFormat.NameFormat AND NameCountry = _NameFormat.Country  -- association [0..1]
LEFT OUTER JOIN I_BusPartSupplementName AS _BusPartSupplementName ON BusinessPartnerSupplementName = _BusPartSupplementName.BusinessPartnerSupplementName  -- association [0..1]
LEFT OUTER JOIN I_BusPartMaritalStatus AS _MaritalStatus ON BusPartMaritalStatus = _MaritalStatus.MaritalStatus  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerOccupation AS _Occupation ON BusinessPartnerOccupation = _Occupation.BusinessPartnerOccupation  -- association [0..1]
LEFT OUTER JOIN I_BusPartBirthDateStatus AS _BusPartBirthDateStatus ON BusinessPartnerBirthDateStatus = _BusPartBirthDateStatus.BusinessPartnerBirthDateStatus  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _NationalityText ON BusPartNationality = _NationalityText.Country AND _NationalityText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _NameCountryText ON NameCountry = _NameCountryText.Country AND _NameCountryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_AcademicTitleText AS _AcademicTitleText ON AcademicTitle = _AcademicTitleText.AcademicTitle AND _AcademicTitleText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BPGenderValueHelpText AS _BPGenderValueHelpText ON GenderCodeName = _BPGenderValueHelpText.GenderCodeName AND _BPGenderValueHelpText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_AcademicTitleText AS _AcademicTitle2Text ON AcademicTitle2 = _AcademicTitle2Text.AcademicTitle AND _AcademicTitle2Text.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusPartSuplmntNameText AS _BusPartSuplmntNameText ON BusinessPartnerSupplementName = _BusPartSuplmntNameText.BusinessPartnerSupplementName AND _BusPartSuplmntNameText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerPrintFormatT AS _BusinessPartnerPrintFormatT ON BusinessPartnerPrintFormat = _BusinessPartnerPrintFormatT.BusinessPartnerPrintFormat AND _BusinessPartnerPrintFormatT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusPartContactPermissionText AS _BusPartContactPermissionText ON ContactPermission = _BusPartContactPermissionText.ContactPermission AND _BusPartContactPermissionText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _CompanyOriginCntryText ON NonResidentCompanyOriginCntry = _CompanyOriginCntryText.Country AND _CompanyOriginCntryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusPartNameFormatName AS _NameFormatText ON NameCountry = _NameFormatText.NameFormatDescription AND NameFormat = _NameFormatText.NameFormat AND _NameFormatText.Language = $session.system_language  -- association [0..1]
;