I_BusinessPartner

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_BusinessPartner.
-- 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: IBUSINESSPARTNER

CREATE VIEW I_BusinessPartner AS
SELECT
  but000.partner AS BusinessPartner,
  but000.type AS BusinessPartnerCategory,
  but000.augrp AS AuthorizationGroup,
  but000.partner_guid AS BusinessPartnerUUID,
  but000.persnumber AS PersonNumber,
  case when but000.chusr <> '' then concat(but000.chusr, concat( but000.chdat, but000.chtim ) ) else concat(but000.crusr, concat( but000.crdat, but000.crtim ) ) end as ETag AS crtimendasETag,
  but000.crusr AS CreatedByUser,
  but000.crdat AS CreationDate,
  but000.crtim AS CreationTime,
  but000.chusr AS LastChangedByUser,
  but000.chdat AS LastChangeDate,
  but000.chtim AS LastChangeTime,
  but000.xblck AS BusinessPartnerIsBlocked,
  but000.xpcpt AS IsBusinessPurposeCompleted,
  but000.name_first AS FirstName,
  but000.name_last AS LastName,
  but000.name1_text AS PersonFullName,
  but000.name_org1 AS OrganizationBPName1,
  but000.name_org2 AS OrganizationBPName2,
  but000.name_org3 AS OrganizationBPName3,
  but000.name_org4 AS OrganizationBPName4,
  but000.location_1 AS InternationalLocationNumber1,
  but000.location_2 AS InternationalLocationNumber2,
  but000.location_3 AS InternationalLocationNumber3,
  but000.legal_enty AS LegalForm,
  but000.found_dat AS OrganizationFoundationDate,
  but000.liquid_dat AS OrganizationLiquidationDate,
  but000.ind_sector AS Industry,
  but000.natpers AS IsNaturalPerson,
  but000.xsexf AS IsFemale,
  but000.xsexm AS IsMale,
  but000.xsexu AS IsSexUnknown,
  but000.title AS FormOfAddress,
  but000.title_aca1 AS AcademicTitle,
  but000.title_aca2 AS AcademicTitle2,
  but000.nameformat AS NameFormat,
  but000.namcountry AS NameCountry,
  but000.bu_group AS BusinessPartnerGrouping,
  but000.bpkind AS BusinessPartnerType,
  but000.namemiddle AS MiddleName,
  but000.name_lst2 AS AdditionalLastName,
  but000.name_grp1 AS GroupBusinessPartnerName1,
  but000.name_grp2 AS GroupBusinessPartnerName2,
  but000.langu_corr AS CorrespondenceLanguage,
  but000.bu_langu AS Language,
  but000.bu_sort1 AS SearchTerm1,
  but000.bu_sort2 AS SearchTerm2,
  but000.mc_name1 AS BPLastNameSearchHelp,
  but000.mc_name2 AS BPFirstNameSearchHelp,
  but000.nickname AS BusinessPartnerNicknameLabel,
  but000.addrcomm AS IndependentAddressID,
  cast( 'X' as sdraft_is_active preserving type ) AS IsActiveEntity,
  but000.birthdt AS BirthDate,
  but000.xdele AS IsMarkedForArchiving,
  but000.contact AS ContactPermission,
  but000.bpext AS BusinessPartnerIDByExtSystem,
  but000.legal_org AS LegalEntityOfOrganization,
  but000.print_mode AS BusinessPartnerPrintFormat,
  but000.source AS BusinessPartnerDataOriginType,
  but000.not_released AS BusinessPartnerIsNotReleased,
  but000.not_lg_competent AS IsNotContractuallyCapable,
  but000.jobgr AS BusinessPartnerOccupation,
  but000.marst AS BusPartMaritalStatus,
  but000.natio AS BusPartNationality,
  but000.cndsc AS NonResidentCompanyOriginCntry,
  but000.title_let AS BusinessPartnerSalutation,
  but000.name_last2 AS BusinessPartnerBirthName,
  but000.title_royl AS BusinessPartnerSupplementName,
  but000.birthpl AS BusinessPartnerBirthplaceName,
  but000.emplo AS NaturalPersonEmployerName,
  but000.deathdt AS BusinessPartnerDeathDate,
  but000.birthdt_status AS BusinessPartnerBirthDateStatus,
  but000.partgrptyp AS BusinessPartnerGroupType,
  but000.prefix1 AS LastNamePrefix,
  but000.prefix2 AS LastNameSecondPrefix,
  but000.initials AS Initials,
  but000.gender AS GenderCodeName,
  but000.xdcset AS DataControllerSet,
  but000.data_ctrlr1 AS DataController1,
  but000.data_ctrlr2 AS DataController2,
  but000.data_ctrlr3 AS DataController3,
  but000.data_ctrlr4 AS DataController4,
  but000.data_ctrlr5 AS DataController5,
  but000.data_ctrlr6 AS DataController6,
  but000.data_ctrlr7 AS DataController7,
  but000.data_ctrlr8 AS DataController8,
  but000.data_ctrlr9 AS DataController9,
  but000.data_ctrlr10 AS DataController10,
  but000.dc_not_req AS BPDataControllerIsNotRequired
FROM but000
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_BusinessPartnerDefaultAddr AS _DefaultAddress ON BusinessPartner = _DefaultAddress.BusinessPartner  -- association [0..*]
LEFT OUTER JOIN I_BPCurrentDefaultAddress AS _CurrentDefaultAddress ON BusinessPartner = _CurrentDefaultAddress.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner_to_BP_Role AS _BusinessPartnerRole ON BusinessPartner = _BusinessPartnerRole.BusinessPartner  -- association [0..*]
LEFT OUTER JOIN I_Addressindependentemail AS _AddressIndependentEmail ON IndependentAddressID = _AddressIndependentEmail.AddressID  -- association [0..*]
LEFT OUTER JOIN I_BPAddressIndependentEmail AS _BPAddressIndependentEmail ON BusinessPartner = _BPAddressIndependentEmail.BusinessPartner AND IndependentAddressID = _BPAddressIndependentEmail.AddressID  -- association [0..*]
LEFT OUTER JOIN I_Addressindependentfax AS _AddressIndependentFax ON IndependentAddressID = _AddressIndependentFax.AddressID  -- association [0..*]
LEFT OUTER JOIN I_BPAddressIndependentFax AS _BPAddressIndependentFax ON BusinessPartner = _BPAddressIndependentFax.BusinessPartner AND IndependentAddressID = _BPAddressIndependentFax.AddressID  -- association [0..*]
LEFT OUTER JOIN I_Addressindependentphone AS _AddressIndependentPhone ON IndependentAddressID = _AddressIndependentPhone.AddressID  -- association [0..*]
LEFT OUTER JOIN I_BPAddressIndependentPhone AS _BPAddressIndependentPhone ON BusinessPartner = _BPAddressIndependentPhone.BusinessPartner AND IndependentAddressID = _BPAddressIndependentPhone.AddressID  -- association [0..*]
LEFT OUTER JOIN I_Addressindependentmobile AS _AddressIndependentMobile ON IndependentAddressID = _AddressIndependentMobile.AddressID  -- association [0..*]
LEFT OUTER JOIN I_BPAddressIndependentMobile AS _BPAddressIndependentMobile ON BusinessPartner = _BPAddressIndependentMobile.BusinessPartner AND IndependentAddressID = _BPAddressIndependentMobile.AddressID  -- association [0..*]
LEFT OUTER JOIN I_BPAddressIndependentWebsite AS _BPAddressIndependentWebsite ON BusinessPartner = _BPAddressIndependentWebsite.BusinessPartner AND IndependentAddressID = _BPAddressIndependentWebsite.AddressID  -- association [0..*]
LEFT OUTER JOIN I_Industries AS _Industries ON Industry = _Industries.IndustrySector  -- association [0..*]
LEFT OUTER JOIN I_BusinessPartnerIndustry AS _BusinessPartnerIndustry ON BusinessPartner = _BusinessPartnerIndustry.BusinessPartner  -- association [0..*]
LEFT OUTER JOIN I_BPFinancialServicesExtn AS _BPFinancialServicesExtn ON BusinessPartner = _BPFinancialServicesExtn.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerRating AS _BPRating ON BusinessPartner = _BPRating.BusinessPartner  -- association [0..*]
LEFT OUTER JOIN I_BPCreditWorthiness AS _BPCreditWorthiness ON BusinessPartner = _BPCreditWorthiness.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BPEmployment AS _BPEmployment ON BusinessPartner = _BPEmployment.BusinessPartner  -- association [0..*]
LEFT OUTER JOIN E_BP_D AS _BusinessPartnerExt ON BusinessPartner = _BusinessPartnerExt.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_AcademicTitleText AS _AcademicTitleText ON AcademicTitle = _AcademicTitleText.AcademicTitle  -- association [0..*]
LEFT OUTER JOIN I_AcademicTitle AS _AcademicTitleValueHelp ON AcademicTitle = _AcademicTitleValueHelp.AcademicTitle  -- association [0..1]
LEFT OUTER JOIN I_BPFinancialServicesExtn AS _BPFinancialServicesExt ON BusinessPartner = _BPFinancialServicesExt.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BuPaIdentification AS _BuPaIdentification ON BusinessPartner = _BuPaIdentification.BusinessPartner  -- association [0..*]
LEFT OUTER JOIN I_BPRelationship_2 AS _BPRelationship ON BusinessPartner = _BPRelationship.BusinessPartner1  -- association [0..*]
LEFT OUTER JOIN I_FormOfAddress AS _FormOfAddress ON FormOfAddress = _FormOfAddress.FormOfAddress  -- association [0..1]
LEFT OUTER JOIN I_Paymentcard AS _Paymentcard ON BusinessPartner = _Paymentcard.BusinessPartner  -- association [0..*]
LEFT OUTER JOIN I_BPDataController AS _BPDataController ON BusinessPartner = _BPDataController.BusinessPartner  -- association [0..*]
;