R_WrntyClaimTP

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_WrntyClaimTP.
-- 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_WrntyClaimTP AS
SELECT
  WrntyClaimHeaderUUID,
  WarrantyClaimNumber,
  WarrantyClaimType,
  WrntyClaimExternalNumber,
  WarrantyObjectType,
  WrntyExternalObjectNumber,
  Plant,
  IsArchived,
  WarrantyClaimChangeDateTime,
  WrntyClaimCreationDate,
  CreatedByUser,
  WrntyClaimChangedDate,
  LastChangedByUser,
  WrntyClaimHeaderText,
  WrntyClaimCreationTime,
  WrntyClaimSourceObjectNumber,
  WrntyClaimSource,
  WrntyClaimDamageDate,
  WrntyClaimRegistrationDate,
  WrntyClaimRepairDate,
  WrntyClaimRepairEndDate,
  WarrantyClaimMileage,
  WrntyClmOperatingDurationInHrs,
  WrntyClmOperatingDurationUnit,
  WarrantyClaimMileageUnit,
  WarrantyCustomerCoverageType,
  WrntyCustClmProcessingStatus,
  WrntyCustClaimRespPerson,
  WarrantyCustomerClaimGroup,
  WarrantyCustomerClaimIsClosed,
  WrntyCustomerClaimClosedDate,
  WarrantyCustomer,
  WarrantyCustomerRole,
  WarrantyCustomerApplicationLog,
  WarrantyCustClmApplLogMessage,
  WrntySupplierCoverageType,
  WrntySuplrClmProcessingStatus,
  WrntySuplrClaimRespPerson,
  WrntySupplierClaimGroup,
  WrntySupplierClaimIsClosed,
  WrntySupplierClaimClosedDate,
  WrntySupplier,
  WrntySupplierRole,
  WrntySupplierApplicationLog,
  WrntySuplrClmApplLogMessage,
  '' AS IsAttachmentsEnabled
FROM I_WrntyClaimHeader
LEFT OUTER JOIN R_WrntyClaimItemTP AS _WrntyClaimActvVersionItem ON WrntyClaimHeaderUUID = _WrntyClaimActvVersionItem.WrntyClaimHeaderUUID  -- association [0..*]
LEFT OUTER JOIN R_WrntyClaimVersionTP AS _WrntySuplrActvVersion ON WrntyClaimHeaderUUID = _WrntySuplrActvVersion.WrntyClaimHeaderUUID AND _WrntySuplrActvVersion.WrntyClmVersIsActvSuplrVersion = 'X'  -- association [0..1]
LEFT OUTER JOIN R_WrntyClaimVersionTP AS _WrntyCustActvVersion ON WrntyClaimHeaderUUID = _WrntyCustActvVersion.WrntyClaimHeaderUUID AND _WrntyCustActvVersion.WrntyClmVersIsActvCustVersion = 'X'  -- association [0..1]
LEFT OUTER JOIN I_WrntyClaimCoverageType AS _ClaimCoverageType ON WarrantyCustomerCoverageType = _ClaimCoverageType.WrntyClaimCoverageType  -- association [1..1]
LEFT OUTER JOIN I_WrntyExternalObjectNumber AS _ExternalObjectNumber ON WrntyExternalObjectNumber = _ExternalObjectNumber.Equipment AND WarrantyObjectType = _ExternalObjectNumber.WarrantyObjectType  -- association [1..1]
LEFT OUTER JOIN I_WrntyClaimAlertCount AS _WrntySuplrClaimAlertCount ON WrntySupplierApplicationLog = _WrntySuplrClaimAlertCount.ApplicationLogHandle  -- association [0..1]
LEFT OUTER JOIN I_WrntyClaimAlertCount AS _WrntySuplrClaimMsgAlertCount ON WrntySuplrClmApplLogMessage = _WrntySuplrClaimMsgAlertCount.ApplicationLogHandle  -- association [0..1]
LEFT OUTER JOIN I_WrntyClaimAlertCount AS _WrntyClaimAlertCount ON WarrantyCustomerApplicationLog = _WrntyClaimAlertCount.ApplicationLogHandle  -- association [0..1]
LEFT OUTER JOIN I_WrntyClaimAlertCount AS _WrntyClaimMsgAlertCount ON WarrantyCustClmApplLogMessage = _WrntyClaimMsgAlertCount.ApplicationLogHandle  -- association [0..1]
LEFT OUTER JOIN I_WrntyClaimSource AS _ClaimSource ON WrntyClaimSource = _ClaimSource.ClaimSource  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _Customer ON WarrantyCustomer = _Customer.Customer  -- association [1..1]
LEFT OUTER JOIN I_WrntyClaimProcessingStatus AS _ProcessingStatus ON WrntyCustClmProcessingStatus = _ProcessingStatus.WrntyClaimProcessingStatus  -- association [1..1]
LEFT OUTER JOIN I_WrntyClaimProcessingStatus AS _SuplrClmProcessingStatus ON WrntySuplrClmProcessingStatus = _SuplrClmProcessingStatus.WrntyClaimProcessingStatus  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON WrntyClmOperatingDurationUnit = _UnitOfMeasure.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _MileageUnitOfMeasure ON WarrantyClaimMileageUnit = _MileageUnitOfMeasure.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN E_WarrantyClaim AS _ExtensionWrntyClaim ON WrntyClaimHeaderUUID = _ExtensionWrntyClaim.WrntyClaimHeaderUUID  -- association [1..1]
LEFT OUTER JOIN R_WrntyClaimVersionTP AS _WrntyClaimVersion ON /* condition not available in parsed metadata */  -- association [1..*]
;