C_BPFinServicesDetailProcTP

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 C_BPFinServicesDetailProcTP.
-- 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 C_BPFinServicesDetailProcTP AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  BPLetterSalutation,
  BusinessPartnerTargetGroup,
  BusinessPartnerIsVIP,
  TradingPartner,
  BPReportingCountryCode,
  FactoryCalendar,
  BusinessPartnerOfficeCountry,
  BusinessPartnerOfficeRegion,
  BPRegisteredOfficeName,
  BPBalanceSheetCurrency,
  BPLastCptlIncrAmtInBalShtCrcy,
  BPLastCapitalIncreaseYear,
  BPBalanceSheetDisplayType,
  BusinessPartnerCitizenship,
  BPMaritalPropertyRegime,
  BusinessPartnerIncomeCurrency,
  BPNumberOfChildren,
  BPNumberOfHouseholdMembers,
  BPAnnualNetIncAmtInIncomeCrcy,
  BPMonthlyNetIncAmtInIncomeCrcy,
  BPAnnualNetIncomeYear,
  BPMonthlyNetIncomeMonth,
  BPMonthlyNetIncomeYear,
  BusinessPartnerEmployeeGroup,
  BusinessPartnerIsEmployee,
  BPPlaceOfDeathName,
  BPTermnBusRelationsBankDate,
  CustomerIsUnwanted,
  UndesirabilityReason,
  UndesirabilityComment,
  LastCustomerContactDate,
  BPMaxOrderingFileSize,
  BPGroupingCharacter,
  MDChgProcSrceLastChgdDateTime,
  MDChgProcessSourceModified,
  MDChgProcessSourceModifBinary,
  virtual SourceSystem : abap.sstring( 260 ) AS sstring260,
  _RecordType._KPIRecordTypeText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIRecordTypeText,
  _RecordType.MDChgProcKPIRecordType AS MDChgProcKPIRecordType,
  _BusinessPartner._KPIRecordStatusText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIRecordStatusText,
  _BusinessPartner.MDChgProcessValidationStatus AS MDChgProcessValidationStatus,
  _KPIUpdateStatusText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIUpdateStatusText,
  MDChgProcKPIUpdateStatus,
  virtual MDChangeProcessMessageType : symsgty AS virtualMDChangeProcessMessageTypesymsgty,
  virtual MDChangeProcessMessageID : msgid AS virtualMDChangeProcessMessageIDmsgid,
  virtual MDChangeProcessMessageNumber : msgno AS virtualMDChangeProcessMessageNumbermsgno,
  _BusinessPartner.MDChgProcessActivationTarget AS MDChgProcessActivationTarget,
  _BusinessPartner._RecordTargetText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIRecordTargetText,
  _BusinessPartner.MDChgProcessReplicationStatus AS MDChgProcessReplicationStatus,
  _BusinessPartner._ReplicationStatusText.MDChangeProcKPIValueKeyDesc AS MDChgProcReplicationStatusText
FROM I_BPFinServicesDetailProcTP
LEFT OUTER JOIN C_BPFinSrvcsDetailProcChanges AS _Changes ON MasterDataChangeProcess = _Changes.MasterDataChangeProcess AND MDChgProcessStep = _Changes.MDChgProcessStep AND MDChgProcessSrceSystem = _Changes.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _Changes.MDChgProcessSrceObject AND _Changes.MDChgProcessSourceModified = 'X'  -- association [0..*]
LEFT OUTER JOIN I_MDChangeProcessRecordTarget AS _RecordTarget ON MasterDataChangeProcess = _RecordTarget.MasterDataChangeProcess AND MDChgProcessSrceSystem = _RecordTarget.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _RecordTarget.MDChgProcessSrceObject AND _RecordTarget.MDChgProcessSrceObjectTypeCode = '147'  -- association [0..1]
;