I_BPCustSalesAreaProcChanges

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_BPCustSalesAreaProcChanges.
-- 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_BPCustSalesAreaProcChanges AS
SELECT
  Current.MasterDataChangeProcess AS MasterDataChangeProcess,
  Current.MDChgProcessStep AS MDChgProcessStep,
  Current.MDChgProcessSrceSystem AS MDChgProcessSrceSystem,
  Current.MDChgProcessSrceObject AS MDChgProcessSrceObject,
  Current.SalesOrganization AS SalesOrganization,
  Current.DistributionChannel AS DistributionChannel,
  Current.Division AS Division,
  Current.BPAssignmentID AS BPAssignmentID,
  ModelTable.MDChgProcessModelTableName AS MDChgProcessModelTableName,
  cast ( '' as fieldname ) AS MDChangeProcessModelFieldName,
  cast( concat( concat ( concat( concat( concat( Current.MDChgProcessSrceSystem, concat( '%%', Current.MDChgProcessSrceObject )), concat( '%%', Current.SalesOrganization )), concat( '%%', Current.DistributionChannel )), concat( '%%', Current.Division )), concat( '%%', Current.BPAssignmentID )) as abap.char(1000) ) as MDChgProcessRecordObjectID AS char1000asMDChgProcessRecordObjectID,
  ModelTable.MDChangeProcModelTableDesc AS MDChangeProcModelTableDesc,
  cast ('' as as4text ) AS MDChangeProcessModelFieldDesc,
  cast( 'BusinessPartnerSalesArea' as fieldname ) AS MDChgProcModelNodeExternalName,
  cast( 'I_BPCustomerSalesAreaProcessTP' as fieldname ) AS MDChgProcModTableExternalName,
  cast( '' as fieldname ) AS MDChgProcModFieldExternalName,
  cast( '' as abap.char( 260 ) ) AS MDChgProcCurrentAttributeValue,
  cast( '' as abap.char( 260 ) ) AS MDChgProcPrevAttributeValue,
  cast( '' as boolean ) AS MDChgProcessAttributeIsChanged,
  Current.MDChgProcessSourceModified AS MDChgProcessSourceModified
FROM I_BPCustomerSalesAreaProcess AS Current
LEFT OUTER JOIN I_BPCustomerProcess AS _Customer ON MasterDataChangeProcess = _Customer.MasterDataChangeProcess AND MDChgProcessStep = _Customer.MDChgProcessStep AND MDChgProcessSrceSystem = _Customer.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _Customer.MDChgProcessSrceObject  -- association [1..1]
LEFT OUTER JOIN I_SalesOrganizationText AS _SalesOrganizationText ON SalesOrganization = _SalesOrganizationText.SalesOrganization AND _SalesOrganizationText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannelText AS _DistributionChannelText ON DistributionChannel = _DistributionChannelText.DistributionChannel AND _DistributionChannelText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_DivisionText AS _DivisionText ON Division = _DivisionText.Division AND _DivisionText.Language = $session.system_language  -- association [0..1]
-- UNION ALL with additional select branch(es): I_BPCustomerSalesAreaProcess
;