I_BusinessPartnerGovTP

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_BusinessPartnerGovTP.
-- 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_BusinessPartnerGovTP AS
SELECT
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) AS BusinessPartnerUUID,
  Governance.MasterDataChangeProcess AS MasterDataChangeProcess,
  Governance.MDChgProcessSrceSystem AS MDChgProcessSrceSystem,
  Governance.MDChgProcessSrceObject AS MDChgProcessSrceObject,
  Governance.MDChgProcessStep AS MDChgProcessStep,
  MasterDataChangeProcess AS MasterDataChangeProcessForEdit,
  MasterDataChangeProcess AS MDChangeProcessNumberDisplay,
  cast( '986' as mdc_object_type_code ) AS MDChgProcessSrceObjectTypeCode,
  MDChgProcessGoal,
  BusinessPartner,
  BusinessPartnerCategory,
  AuthorizationGroup,
  PersonNumber,
  cast( 1000 as mdc_process_update_token ) AS ETag,
  _MasterDataChangeProcess.MDChgProcessIsStarted AS MDChgProcessIsStarted,
  _ProcessIsIdle.MDChgProcessIsIdle AS MDChgProcessIsIdle,
  BusinessPartnerName,
  BusinessPartnerFullName,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  BusinessPartnerIsBlocked,
  IsBusinessPurposeCompleted,
  OrganizationBPName1,
  OrganizationBPName2,
  OrganizationBPName3,
  OrganizationBPName4,
  cast(InternationalLocationNumber1 as bu_location1str) AS InternationalLocationNumber1,
  cast(InternationalLocationNumber2 as bu_location2str) AS InternationalLocationNumber2,
  cast(InternationalLocationNumber3 as bu_location3str) AS InternationalLocationNumber3,
  LegalForm,
  OrganizationFoundationDate,
  OrganizationLiquidationDate,
  Industry,
  FormOfAddress AS FormOfAddressPerson,
  FormOfAddress AS FormOfAddressOrganization,
  FormOfAddress AS FormOfAddressGroup,
  FormOfAddress,
  BusinessPartnerGrouping,
  BusinessPartnerType,
  BusinessPartnerPrintFormat,
  BusinessPartnerDataOriginType,
  SearchTerm1,
  SearchTerm2,
  BPLastNameSearchHelp,
  BPFirstNameSearchHelp,
  IndependentAddressID,
  IsMarkedForArchiving,
  ContactPermission,
  LegalEntityOfOrganization,
  BusinessPartnerIsNotReleased,
  IsNotContractuallyCapable,
  ActiveAuthorizationGroup,
  CorrespondenceLanguage,
  IsFemale,
  IsMale,
  IsSexUnknown,
  GenderCodeName,
  FirstName,
  LastName,
  AdditionalLastName,
  BusinessPartnerBirthName,
  MiddleName,
  AcademicTitle,
  AcademicTitle2,
  BusinessPartnerSupplementName,
  LastNamePrefix,
  LastNameSecondPrefix,
  PersonFullName,
  BusinessPartnerNicknameLabel,
  Initials,
  NameFormat,
  NameCountry,
  Language,
  IsNaturalPerson,
  BirthDate,
  BusinessPartnerBirthplaceName,
  BusinessPartnerDeathDate,
  BusinessPartnerBirthDateStatus,
  NaturalPersonEmployerName,
  BusinessPartnerOccupation,
  BusPartMaritalStatus,
  BusPartNationality,
  BusinessPartnerIDByExtSystem,
  NonResidentCompanyOriginCntry,
  GroupBusinessPartnerName1,
  GroupBusinessPartnerName2,
  BusinessPartnerGroupType,
  cast( '' as boole_d preserving type ) AS MDChgBPRelshpHasChanged,
  DataControllerSet,
  DataController1,
  DataController2,
  DataController3,
  DataController4,
  DataController5,
  DataController6,
  DataController7,
  DataController8,
  DataController9,
  DataController10,
  BPDataControllerIsNotRequired,
  Origin
FROM I_BusinessPartnerGov AS Governance
LEFT OUTER JOIN I_BusPartAddressUsageGovTP AS _BusinessPartnerAddressUsage ON BusinessPartnerUUID = _BusinessPartnerAddressUsage.BusinessPartnerUUID AND MasterDataChangeProcess = _BusinessPartnerAddressUsage.MasterDataChangeProcess AND MDChgProcessSrceSystem = _BusinessPartnerAddressUsage.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _BusinessPartnerAddressUsage.MDChgProcessSrceObject  -- association [0..*]
LEFT OUTER JOIN I_BPRoleCategoryAllowListGovTP AS _RoleAllowList ON MasterDataChangeProcess = _RoleAllowList.MasterDataChangeProcess AND MDChgProcessSrceSystem = _RoleAllowList.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _RoleAllowList.MDChgProcessSrceObject  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerAddressGovTP AS _BusinessPartnerStandardAddr ON BusinessPartnerUUID = _BusinessPartnerStandardAddr.BusinessPartnerUUID AND MasterDataChangeProcess = _BusinessPartnerStandardAddr.MasterDataChangeProcess AND MDChgProcessSrceSystem = _BusinessPartnerStandardAddr.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _BusinessPartnerStandardAddr.MDChgProcessSrceObject AND _BusinessPartnerStandardAddr.StandardUsage = 'X'  -- association [0..1]
LEFT OUTER JOIN C_BusinessPartnerAddressDspGov AS _BusinessPartnerAddressDsp ON MasterDataChangeProcess = _BusinessPartnerAddressDsp.MasterDataChangeProcess AND MDChgProcessSrceSystem = _BusinessPartnerAddressDsp.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _BusinessPartnerAddressDsp.MDChgProcessSrceObject  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerGrouping AS _BusinessPartnerGrouping ON BusinessPartnerGrouping = _BusinessPartnerGrouping.BusinessPartnerGrouping  -- association [0..1]
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_BuPaLegalEntity AS _BusinessPartnerLegalEntity ON LegalEntityOfOrganization = _BusinessPartnerLegalEntity.BPOrganisationLegalEntity  -- 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_BusPartDataOriginType AS _DataOriginType ON BusinessPartnerDataOriginType = _DataOriginType.BusinessPartnerDataOriginType  -- 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_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_BusPartPersonFullName AS _BusPartPersonFullName ON PersonNumber = _BusPartPersonFullName.PersonNumber AND _BusPartPersonFullName.AddressRepresentationCode = ' ' AND _BusPartPersonFullName.ValidityStartDateTime = '00010101'  -- association [0..1]
LEFT OUTER JOIN I_BPGenderValueHelp AS _GenderCode ON GenderCodeName = _GenderCode.GenderCodeName  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_AcademicTitle AS _AcademicTitleValueHelp ON AcademicTitle = _AcademicTitleValueHelp.AcademicTitle  -- association [0..1]
LEFT OUTER JOIN I_MasterDataChangeProcess AS _MasterDataChangeProcess ON MasterDataChangeProcess = _MasterDataChangeProcess.MasterDataChangeProcess  -- association [0..1]
LEFT OUTER JOIN I_MDChangeProcessIsIdleTP AS _ProcessIsIdle ON MasterDataChangeProcess = _ProcessIsIdle.MasterDataChangeProcess  -- association [0..1]
LEFT OUTER JOIN E_BP_D AS _ExtensionActive ON MDChgProcessSrceObject = _ExtensionActive.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN E_BusinessPartnerProcess AS _ExtensionProcess ON MasterDataChangeProcess = _ExtensionProcess.MasterDataChangeProcess AND MDChgProcessSrceSystem = _ExtensionProcess.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _ExtensionProcess.MDChgProcessSrceObject AND MDChgProcessStep = _ExtensionProcess.MDChgProcessStep  -- association [0..1]
LEFT OUTER JOIN I_ExtlyPrvddBPInfoRFCDestAvail AS _DpiRFCDestAvailable ON _DpiRFCDestAvailable.ExtlyPrvddBPInfoRFCDestAvaily = 'X'  -- association [0..1]
LEFT OUTER JOIN I_BPChangeProcessGovTP AS _Process ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerRoleGovTP AS _BusinessPartnerRole ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BusinessPartnerAddressGovTP AS _BusinessPartnerAddress ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BusPartIdentificationGovTP AS _BusinessPartnerIdentification ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BusPartTaxNumberGovTP AS _BusinessPartnerTaxNumber ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BusPartIndustryGovTP AS _BusinessPartnerIndustry ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BusinessPartnerBankGovTP AS _BusinessPartnerBank ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BPDataControllerGovernanceTP AS _BusinessPartnerDataController ON /* condition not available in parsed metadata */  -- association [0..*]
;