R_WorkPermitPartnerTP

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 R_WorkPermitPartnerTP.
-- 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 R_WorkPermitPartnerTP AS
SELECT
  I_WorkPermit.WorkPermitInternalID AS MaintObjectInternalID,
  cast(I_PlantMaintenancePartner.PartnerFunction as parvw_unv preserving type ) AS PartnerFunction,
  I_PlantMaintenancePartner.MaintenancePartnerObjectNumber AS MaintenancePartnerObjectNumber,
  I_WorkPermit.WorkPermit AS WorkPermit,
  I_WorkPermit.WorkPermitType AS WorkPermitType,
  I_WorkPermit.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  I_PlantMaintenancePartner.MaintenancePartner AS CustomerResponsible,
  I_PlantMaintenancePartner.MaintenancePartner AS SupplierResponsible,
  I_PlantMaintenancePartner._ContactPerson.Customer AS Customer,
  I_PlantMaintenancePartner.MaintenancePartner AS PersonResponsible,
  I_PlantMaintenancePartner.MaintenancePartner AS ContactPersonResponsible,
  I_PlantMaintenancePartner.MaintenancePartner AS UserResponsible,
  I_PlantMaintenancePartner.MaintenancePartner AS PositionResponsible,
  I_PlantMaintenancePartner.MaintenancePartner AS DepartmentResponsible,
  I_PlantMaintenancePartner.MaintenancePartner AS MaintenancePartner,
  I_PlantMaintenancePartner.MaintObjectCategory AS MaintObjectCategory,
  I_PlantMaintenancePartner.CreatedByUser AS CreatedByUser,
  I_PlantMaintenancePartner.CreationDate AS CreationDate,
  I_PlantMaintenancePartner.CreationTime AS CreationTime,
  I_PlantMaintenancePartner.LastChangeDate AS LastChangeDate,
  I_PlantMaintenancePartner.LastChangeTime AS LastChangeTime,
  I_PlantMaintenancePartner.LastChangedByUser AS LastChangedByUser,
  I_PlantMaintenancePartner._PartnerFunction.SDDocumentPartnerType AS SDDocumentPartnerType,
  _CustomerVH.BPCustomerName AS BPCustomerName,
  _SupplierVH.BPSupplierName AS BPSupplierName,
  _PMPersonResponsible.FullName AS PersonResponsibleName,
  _PMUserResponsible.FullName AS UserName,
  _PMContactPerson.FullName AS ContactPersonName,
  _PMPositionResponsible.HCMEmployeePositionText AS HCMEmployeePositionText,
  _PMDepartmentResponsible.OrganizationalUnitShortName AS HCMOrganizationalUnitText
FROM I_WorkPermit
INNER JOIN I_PlantMaintenancePartner ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PartnerFunctionText AS _PartnerFunctionText ON PartnerFunction = _PartnerFunctionText.PartnerFunction AND _PartnerFunctionText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PartnerFunction AS _PartnerFunction ON _PartnerFunction.PartnerFunction = PartnerFunction  -- association [0..1]
LEFT OUTER JOIN I_PMPersonResponsible AS _PMPersonResponsible ON PersonResponsible = _PMPersonResponsible.PersonnelNumber  -- association [0..1]
LEFT OUTER JOIN I_Customer_VH AS _CustomerVH ON CustomerResponsible = _CustomerVH.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier_VH AS _SupplierVH ON SupplierResponsible = _SupplierVH.Supplier  -- association [0..1]
LEFT OUTER JOIN I_PMUserResponsible AS _PMUserResponsible ON UserResponsible = _PMUserResponsible.UserID  -- association [0..1]
LEFT OUTER JOIN I_PMContactPerson AS _PMContactPerson ON MaintenancePartner = _PMContactPerson.ContactPerson  -- association [0..1]
LEFT OUTER JOIN I_PMPositionResponsible AS _PMPositionResponsible ON PositionResponsible = _PMPositionResponsible.PositionResponsible  -- association [0..1]
LEFT OUTER JOIN I_PMDepartmentResponsible AS _PMDepartmentResponsible ON DepartmentResponsible = _PMDepartmentResponsible.DepartmentResponsible  -- association [0..1]
;