I_BPFinServicesDetailProc

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_BPFinServicesDetailProc.
-- 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_BPFinServicesDetailProc AS
SELECT
  process_id AS MasterDataChangeProcess,
  process_step_no AS MDChgProcessStep,
  source_system AS MDChgProcessSrceSystem,
  source_id AS MDChgProcessSrceObject,
  title_let AS BPLetterSalutation,
  group_d AS BusinessPartnerTargetGroup,
  vip AS BusinessPartnerIsVIP,
  vbund AS TradingPartner,
  country_rep AS BPReportingCountryCode,
  calendarid AS FactoryCalendar,
  cntry_comp AS BusinessPartnerOfficeCountry,
  regio AS BusinessPartnerOfficeRegion,
  comp_head AS BPRegisteredOfficeName,
  bal_sh_cur AS BPBalanceSheetCurrency,
  cap_incr_a AS BPLastCptlIncrAmtInBalShtCrcy,
  cap_incr_y AS BPLastCapitalIncreaseYear,
  balance_fl AS BPBalanceSheetDisplayType,
  state AS BusinessPartnerCitizenship,
  proprty_st AS BPMaritalPropertyRegime,
  income_cur AS BusinessPartnerIncomeCurrency,
  children AS BPNumberOfChildren,
  mem_house AS BPNumberOfHouseholdMembers,
  net_income AS BPAnnualNetIncAmtInIncomeCrcy,
  mo_net_inc AS BPMonthlyNetIncAmtInIncomeCrcy,
  net_inc_y AS BPAnnualNetIncomeYear,
  mo_inc_m AS BPMonthlyNetIncomeMonth,
  mo_inc_y AS BPMonthlyNetIncomeYear,
  staff_grp AS BusinessPartnerEmployeeGroup,
  staff_ref AS BusinessPartnerIsEmployee,
  dying_place AS BPPlaceOfDeathName,
  bank_del_d AS BPTermnBusRelationsBankDate,
  unw_customer AS CustomerIsUnwanted,
  unw_reason AS UndesirabilityReason,
  unw_remark AS UndesirabilityComment,
  last_cust_cont AS LastCustomerContactDate,
  max_file_size AS BPMaxOrderingFileSize,
  group_feature AS BPGroupingCharacter,
  source_recency AS MDChgProcSrceLastChgdDateTime,
  source_modified AS MDChgProcessSourceModified,
  source_modification_blip AS MDChgProcessSourceModifBinary
FROM bp001_prc
LEFT OUTER JOIN I_BusinessPartnerProcess AS _BusinessPartner ON bp001_prc.process_id = _BusinessPartner.MasterDataChangeProcess AND bp001_prc.process_step_no = _BusinessPartner.MDChgProcessStep AND bp001_prc.source_system = _BusinessPartner.MDChgProcessSrceSystem AND bp001_prc.source_id = _BusinessPartner.MDChgProcessSrceObject  -- association [1..1]
;