I_BusinessPartnerPartFuncTP

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_BusinessPartnerPartFuncTP.
-- 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: IBUPAPARTFUNCTP

CREATE VIEW I_BusinessPartnerPartFuncTP AS
SELECT
  BusinessPartnerPartFunc.SalesOrganization AS SalesOrganization,
  BusinessPartnerPartFunc.DistributionChannel AS DistributionChannel,
  BusinessPartnerPartFunc.Division AS Division,
  BusinessPartnerPartFunc.PartnerFunction AS PartnerFunction,
  BusinessPartnerPartFunc.PartnerCounter AS PartnerCounter,
  BusinessPartnerPartFunc.BusinessPartner AS BusinessPartner,
  BusinessPartnerPartFunc.BusinessPartner AS BusinessPartnerForEdit,
  BusinessPartnerPartFunc.Customer AS Customer,
  BusinessPartnerPartFunc.SalesOrganization AS SalesOrganizationForEdit,
  BusinessPartnerPartFunc.DistributionChannel AS DistributionChannelForEdit,
  BusinessPartnerPartFunc.Division AS DivisionForEdit,
  _BusinessPartner.BusinessPartnerGrouping AS BusinessPartnerGrouping,
  BusinessPartnerPartFunc.PartnerFunction AS PartnerFunctionForEdit,
  BusinessPartnerPartFunc.PartnerCounter AS PartnerCounterForEdit,
  BusinessPartnerPartFunc.PartnerFunctionType AS PartnerFunctionType,
  BusinessPartnerPartFunc.BPCustomerNumber AS BPCustomerNumber,
  BusinessPartnerPartFunc.CustomerPartnerDescription AS CustomerPartnerDescription,
  BusinessPartnerPartFunc.DefaultPartner AS DefaultPartner,
  BusinessPartnerPartFunc.ContactPerson AS ContactPerson,
  BusinessPartnerPartFunc.BusinessPartnerUUID AS BusinessPartnerUUID,
  BusinessPartnerPartFunc.AddressID AS AddressID,
  _PartnerFunctionText.PartnerFunctionName AS PartnerFunctionName,
  cast( ' ' as abap.sstring( 260 ) ) AS FormattedAddress
FROM I_BusinessPartnerPartFunc AS BusinessPartnerPartFunc
LEFT OUTER JOIN I_BusinessPartnerTP AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartnerSalesAreaTP AS _BusinessPartnerSalesArea ON BusinessPartner = _BusinessPartnerSalesArea.BusinessPartner AND SalesOrganization = _BusinessPartnerSalesArea.SalesOrganization AND DistributionChannel = _BusinessPartnerSalesArea.DistributionChannel AND Division = _BusinessPartnerSalesArea.Division  -- association [1..1]
LEFT OUTER JOIN I_PartnerFunctionText AS _PartnerFunctionText ON PartnerFunctionForEdit = _PartnerFunctionText.PartnerFunction AND _PartnerFunctionText.Language = $session.system_language  -- association [0..1]
;