C_WarrantyCustomerClaimTP

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_WarrantyCustomerClaimTP.
-- 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 C_WarrantyCustomerClaimTP AS
SELECT
  WrntyCustClaimBO.WrntyClaimHeaderUUID AS WrntyClaimHeaderUUID,
  _WrntyCustActvVersion.WrntyVersionUUID AS WrntyClmCustActvVersionUUID,
  WrntyCustClaimBO.WarrantyClaimNumber AS WarrantyClaimNumber,
  WrntyCustClaimBO.WarrantyClaimType AS WarrantyClaimType,
  WrntyCustClaimBO.WrntyClaimExternalNumber AS WrntyClaimExternalNumber,
  WrntyCustClaimBO.WrntyCustClaimRespPerson AS WrntyCustClaimRespPerson,
  _CustResponsiblePerson.FullName AS FullName,
  WrntyCustClaimBO.WarrantyObjectType AS WarrantyObjectType,
  WrntyCustClaimBO.WrntyExternalObjectNumber AS WrntyExternalObjectNumber,
  _ExternalObjectNumber.EquipmentName AS EquipmentName,
  WrntyCustClaimBO.WarrantyCustomer AS WarrantyCustomer,
  WrntyCustClaimBO.WarrantyCustomerRole AS WarrantyCustomerRole,
  WrntyCustClaimBO.WrntyCustClmProcessingStatus AS WrntyCustClmProcessingStatus,
  WrntyCustClaimBO.Plant AS Plant,
  WrntyCustClaimBO.WarrantyCustomerApplicationLog AS WarrantyCustomerApplicationLog,
  WrntyCustClaimBO.WarrantyCustClmApplLogMessage AS WarrantyCustClmApplLogMessage,
  WrntyCustClaimBO.WrntyCustomerClaimClosedDate AS WrntyCustomerClaimClosedDate,
  WrntyCustClaimBO.IsArchived AS IsArchived,
  WrntyCustClaimBO.WarrantyCustomerClaimIsClosed AS WarrantyCustomerClaimIsClosed,
  WrntyCustClaimBO.WarrantyClaimChangeDateTime AS ValidToDateTime,
  WrntyCustClaimBO.WrntyClaimCreationDate AS WrntyClaimCreationDate,
  WrntyCustClaimBO.CreatedByUser AS CreatedByUser,
  _CreatedByUser.FullName AS CreatedByUserFullName,
  WrntyCustClaimBO.WrntyClaimChangedDate AS WrntyClaimChangedDate,
  WrntyCustClaimBO.LastChangedByUser AS LastChangedByUser,
  _LastChangedByUser.FullName AS LastChangedByUserFullName,
  WrntyCustClaimBO.WrntyClaimHeaderText AS WrntyClaimHeaderText,
  WrntyCustClaimBO.WrntyClaimCreationTime AS WrntyClaimCreationTime,
  WrntyCustClaimBO.WrntyClaimSourceObjectNumber AS WrntyClaimSourceObjectNumber,
  WrntyCustClaimBO.WrntyClaimSource AS WrntyClaimSource,
  WrntyCustClaimBO.WrntyClaimDamageDate AS WrntyClaimDamageDate,
  WrntyCustClaimBO.WrntyClaimRegistrationDate AS WrntyClaimRegistrationDate,
  WrntyCustClaimBO.WarrantyCustomerCoverageType AS WarrantyCustomerCoverageType,
  WrntyCustClaimBO.WrntyClaimRepairEndDate AS WrntyClaimRepairEndDate,
  WrntyCustClaimBO.WrntyClaimRepairDate AS WrntyClaimRepairDate,
  _WrntyCustActvVersion.WrntyPriceExchangeRateDate AS WrntyPriceExchangeRateDate,
  _WrntyCustActvVersion.WrntyDocumentCondition AS WrntyDocumentCondition,
  _WrntyCustActvVersion.WrntyVersionUUID AS WrntyVersionUUID,
  _WrntyCustActvVersion.WrntyBillingDocumentDate AS WrntyBillingDocumentDate,
  cast(_WrntyCustActvVersion.WrntyVersionNumber as wty_versn preserving type ) AS WrntyVersionNumber,
  _WrntyCustActvVersion.WarrantyClaimVersionCategory AS WarrantyClaimVersionCategory,
  virtual WarrantyClaimHasCreateHide : boolean AS virtualWarrantyClaimHasCreateHideboolean,
  _WrntyCustActvVersion.WrntyDecisionCode AS WrntyDecisionCode,
  WrntyCustClaimBO.WarrantyClaimMileage AS WarrantyClaimMileage,
  WrntyCustClaimBO.WrntyClmOperatingDurationInHrs AS WrntyClmOperatingDurationInHrs,
  WrntyCustClaimBO.WrntyClmOperatingDurationUnit AS WrntyClmOperatingDurationUnit,
  WrntyCustClaimBO.WarrantyClaimMileageUnit AS WarrantyClaimMileageUnit,
  virtual TransactionCurrency : waerk AS virtualTransactionCurrencywaerk,
  _WrntyCustActvVersion.WrntyCurrencyCode AS WrntyCurrencyCode,
  _WrntyCustActvVersion.PurchasingOrganization AS PurchasingOrganization,
  _WrntyCustActvVersion.SalesOrganization AS SalesOrganization,
  _WrntyCustActvVersion.DistributionChannel AS DistributionChannel,
  _WrntyCustActvVersion.Division AS Division,
  virtual WrntyRequestedAmount : wty_valiv AS virtualWrntyRequestedAmountwty_valiv,
  virtual WrntyApprovedAmount : abap.dec( 10, 2) AS dec102,
  virtual WrntyTotalLaborAmount : wty_sum_fr AS virtualWrntyTotalLaborAmountwty_sum_fr,
  virtual WrntyTotalAmount : wty_sum_subl AS virtualWrntyTotalAmountwty_sum_subl,
  virtual TotalNetAmount : netwr_ak AS virtualTotalNetAmountnetwr_ak,
  virtual WrntyClaimTaxAmount : wertv8 AS virtualWrntyClaimTaxAmountwertv8,
  virtual NoteText : nte_cont AS virtualNoteTextnte_cont,
  virtual ServiceDocNoteText : nte_cont AS virtualServiceDocNoteTextnte_cont,
  virtual WarrantyClaimIsEditable : boolean AS virtualWarrantyClaimIsEditableboolean,
  _WrntyCustActvVersion.WarrantyVersionRprstvID AS ExternalDocumentID,
  _WrntyClaimAlertCount.NumberOfAlerts AS NumberOfAlerts,
  _WrntyClaimAlertCount.NumberOfErrorMessages AS NumberOfErrorMessages,
  _WrntyClaimMsgAlertCount.NumberOfAlerts AS NumberOfAlertsLogMessage,
  _WrntyClaimMsgAlertCount.NumberOfErrorMessages AS NumberOfErrorLogMessages,
  IsAttachmentsEnabled,
  _Customer.CustomerFullName AS CustomerFullName,
  WrntyCustClaimBO.WrntySupplier AS WrntySupplier
FROM R_WrntyClaimTP
LEFT OUTER JOIN C_WrntyCustomerPricingElement AS _PricingElement ON WrntyClaimHeaderUUID = _PricingElement.WrntyClaimHeaderUUID AND wrntyversionuuid = _PricingElement.WrntyVersionUUID  -- association [1..*]
LEFT OUTER JOIN C_WrntyClaimApplicationLog AS _WrntyClaimApplicationLog ON WarrantyClaimNumber = _WrntyClaimApplicationLog.ApplicationJobDescription  -- association [0..*]
LEFT OUTER JOIN C_WrntyClaimApplicationLog AS _WrntyClaimApplicationLogMsg ON WarrantyClaimNumber = _WrntyClaimApplicationLogMsg.ApplicationJobDescription  -- association [0..*]
LEFT OUTER JOIN C_WrntyCustomerClaimVersionTP AS _WrntyClaimVersionForDisplay ON WrntyClaimHeaderUUID = _WrntyClaimVersionForDisplay.WrntyClaimHeaderUUID AND ( _WrntyClaimVersionForDisplay.WarrantyClaimVersionCategory = 'OC' OR _WrntyClaimVersionForDisplay.WarrantyClaimVersionCategory = 'IC' )  -- association [0..*]
;