C_MfgBusinessPartnerTP

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_MfgBusinessPartnerTP.
-- 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: CMFGBPTP

CREATE VIEW C_MfgBusinessPartnerTP AS
SELECT
  I_MfgBusinessPartnerTP.MfgBusinessPartner AS MfgBusinessPartner,
  cast(_BusinessPartner.BusinessPartnerName as mpe_user_name preserving type) AS BusinessPartnerName,
  _BusinessPartner.FirstName AS FirstName,
  _BusinessPartner.LastName AS LastName,
  I_MfgBusinessPartnerTP.Plant AS Plant,
  _PlantValueHelp.PlantName AS PlantName,
  I_MfgBusinessPartnerTP.WorkCenter AS WorkCenter,
  WorkplaceAddress.DefaultEmailAddress AS EmailAddress,
  WorkplaceAddress.PhoneNumber AS PhoneNumber,
  _BusinessPartner.CreatedByUser AS UserID,
  I_MfgBusinessPartnerTP.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  I_MfgBusinessPartnerTP.AuthorizationGroup AS AuthorizationGroup,
  I_MfgBusinessPartnerTP.BusinessPartnerUUID AS BusinessPartnerUUID,
  I_MfgBusinessPartnerTP._Plant AS _Plant,
  I_MfgBusinessPartnerTP._WorkCenter AS _WorkCenter
FROM I_MfgBusinessPartnerTP
LEFT OUTER JOIN C_MfgBPQualifnCertAssgmtTP AS _MfgBPCert ON MfgBusinessPartner = _MfgBPCert.MfgBusinessPartner  -- association [1..*]
LEFT OUTER JOIN C_MfgBPWrkCtrAssgmtTP AS _MfgBPWrkCtr ON MfgBusinessPartner = _MfgBPWrkCtr.MfgBusinessPartner  -- association [1..*]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON MfgBusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_MfgBusinessPartnerVH AS _BPValueHelp ON MfgBusinessPartner = _BPValueHelp.MfgBusinessPartner AND BusinessPartnerName = _BPValueHelp.BusinessPartnerName  -- association [1..1]
LEFT OUTER JOIN C_MfgWorkCenterVH AS _WorkCenterValueHelp ON WorkCenter = _WorkCenterValueHelp.WorkCenter  -- association [1..*]
LEFT OUTER JOIN I_Plant AS _PlantValueHelp ON Plant = _PlantValueHelp.Plant  -- association [1..1]
;