I_BusinessPartnerProcess

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_BusinessPartnerProcess.
-- 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: IBPPROCESS

CREATE VIEW I_BusinessPartnerProcess AS
SELECT
  process_id AS MasterDataChangeProcess,
  process_step_no AS MDChgProcessStep,
  source_system AS MDChgProcessSrceSystem,
  source_id AS MDChgProcessSrceObject,
  partner AS BusinessPartner,
  type AS BusinessPartnerCategory,
  augrp AS AuthorizationGroup,
  partner_guid AS BusinessPartnerUUID,
  persnumber AS PersonNumber,
  crusr AS CreatedByUser,
  crdat AS CreationDate,
  crtim AS CreationTime,
  chusr AS LastChangedByUser,
  chdat AS LastChangeDate,
  chtim AS LastChangeTime,
  xblck AS BusinessPartnerIsBlocked,
  xpcpt AS IsBusinessPurposeCompleted,
  name_first AS FirstName,
  name_last AS LastName,
  name1_text AS PersonFullName,
  name_org1 AS OrganizationBPName1,
  name_org2 AS OrganizationBPName2,
  name_org3 AS OrganizationBPName3,
  name_org4 AS OrganizationBPName4,
  location_1 AS InternationalLocationNumber1,
  location_2 AS InternationalLocationNumber2,
  location_3 AS InternationalLocationNumber3,
  legal_enty AS LegalForm,
  found_dat AS OrganizationFoundationDate,
  liquid_dat AS OrganizationLiquidationDate,
  ind_sector AS Industry,
  natpers AS IsNaturalPerson,
  xsexf AS IsFemale,
  xsexm AS IsMale,
  xsexu AS IsSexUnknown,
  gender AS GenderCodeName,
  title AS FormOfAddress,
  title_aca1 AS AcademicTitle,
  title_aca2 AS AcademicTitle2,
  NameFormat,
  namcountry AS NameCountry,
  bu_group AS BusinessPartnerGrouping,
  partgrptyp AS BusinessPartnerGroupType,
  bpkind AS BusinessPartnerType,
  namemiddle AS MiddleName,
  name_lst2 AS AdditionalLastName,
  name_last2 AS BusinessPartnerBirthName,
  title_royl AS BusinessPartnerSupplementName,
  name_grp1 AS GroupBusinessPartnerName1,
  name_grp2 AS GroupBusinessPartnerName2,
  langu_corr AS CorrespondenceLanguage,
  bu_langu AS Language,
  bu_sort1 AS SearchTerm1,
  bu_sort2 AS SearchTerm2,
  mc_name1 AS BPLastNameSearchHelp,
  mc_name2 AS BPFirstNameSearchHelp,
  nickname AS BusinessPartnerNicknameLabel,
  prefix1 AS LastNamePrefix,
  prefix2 AS LastNameSecondPrefix,
  Initials,
  marst AS BusPartMaritalStatus,
  natio AS BusPartNationality,
  cndsc AS NonResidentCompanyOriginCntry,
  jobgr AS BusinessPartnerOccupation,
  addrcomm AS IndependentAddressID,
  birthdt AS BirthDate,
  birthdt_status AS BusinessPartnerBirthDateStatus,
  birthpl AS BusinessPartnerBirthplaceName,
  emplo AS NaturalPersonEmployerName,
  deathdt AS BusinessPartnerDeathDate,
  xdele AS IsMarkedForArchiving,
  contact AS ContactPermission,
  bpext AS BusinessPartnerIDByExtSystem,
  legal_org AS LegalEntityOfOrganization,
  print_mode AS BusinessPartnerPrintFormat,
  source AS BusinessPartnerDataOriginType,
  not_released AS BusinessPartnerIsNotReleased,
  not_lg_competent AS IsNotContractuallyCapable,
  source_modified AS MDChgProcessSourceModified,
  source_modification_blip AS MDChgProcessSourceModifBinary,
  validation_status AS MDChgProcessValidationStatus,
  source_recency AS MDChgProcSrceLastChgdDateTime,
  xdcset AS DataControllerSet,
  data_ctrlr1 AS DataController1,
  data_ctrlr2 AS DataController2,
  data_ctrlr3 AS DataController3,
  data_ctrlr4 AS DataController4,
  data_ctrlr5 AS DataController5,
  data_ctrlr6 AS DataController6,
  data_ctrlr7 AS DataController7,
  data_ctrlr8 AS DataController8,
  data_ctrlr9 AS DataController9,
  data_ctrlr10 AS DataController10,
  dc_not_req AS BPDataControllerIsNotRequired,
  kbanks AS BankCountry,
  kbankl AS BankKey
FROM but000_prc
LEFT OUTER JOIN E_BusinessPartnerProcess AS _Extension ON MasterDataChangeProcess = _Extension.MasterDataChangeProcess AND MDChgProcessStep = _Extension.MDChgProcessStep AND MDChgProcessSrceSystem = _Extension.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _Extension.MDChgProcessSrceObject  -- association [0..1]
LEFT OUTER JOIN I_BPCountryAddressVariants AS _AddressVariants ON _AddressVariants.BPCountryDepdntAddressVariant = _AddressVariants.BPCountryDepdntAddressVariant  -- association [0..1]
;