R_WrntyClaimDraft

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_WrntyClaimDraft.
-- 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_WrntyClaimDraft AS
SELECT
  WarrantyClaimDraft.wrntyclaimheaderuuid AS WrntyClaimHeaderUUID,
  WarrantyClaimDraft.warrantyclaimnumber AS WarrantyClaimNumber,
  WarrantyClaimDraft.warrantyclaimtype AS WarrantyClaimType,
  WarrantyClaimDraft.wrntyclaimexternalnumber AS WrntyClaimExternalNumber,
  WarrantyClaimDraft.warrantyobjecttype AS WarrantyObjectType,
  WarrantyClaimDraft.wrntyexternalobjectnumber AS WrntyExternalObjectNumber,
  WarrantyClaimDraft.plant AS Plant,
  WarrantyClaimDraft.isarchived AS IsArchived,
  WarrantyClaimDraft.warrantyclaimchangedatetime AS WarrantyClaimChangeDateTime,
  WarrantyClaimDraft.wrntyclaimcreationdate AS WrntyClaimCreationDate,
  WarrantyClaimDraft.createdbyuser AS CreatedByUser,
  WarrantyClaimDraft.wrntyclaimchangeddate AS WrntyClaimChangedDate,
  WarrantyClaimDraft.lastchangedbyuser AS LastChangedByUser,
  WarrantyClaimDraft.wrntyclaimheadertext AS WrntyClaimHeaderText,
  WarrantyClaimDraft.wrntyclaimcreationtime AS WrntyClaimCreationTime,
  WarrantyClaimDraft.wrntyclaimsourceobjectnumber AS WrntyClaimSourceObjectNumber,
  WarrantyClaimDraft.wrntyclaimsource AS WrntyClaimSource,
  WarrantyClaimDraft.wrntyclaimdamagedate AS WrntyClaimDamageDate,
  WarrantyClaimDraft.wrntyclaimregistrationdate AS WrntyClaimRegistrationDate,
  WarrantyClaimDraft.wrntyclaimrepairdate AS WrntyClaimRepairDate,
  WarrantyClaimDraft.wrntyclaimrepairenddate AS WrntyClaimRepairEndDate,
  WarrantyClaimDraft.warrantyclaimmileage AS WarrantyClaimMileage,
  WarrantyClaimDraft.wrntyclmoperatingdurationinhrs AS WrntyClmOperatingDurationInHrs,
  WarrantyClaimDraft.wrntyclmoperatingdurationunit AS WrntyClmOperatingDurationUnit,
  WarrantyClaimDraft.warrantyclaimmileageunit AS WarrantyClaimMileageUnit,
  WarrantyClaimDraft.warrantycustomercoveragetype AS WarrantyCustomerCoverageType,
  WarrantyClaimDraft.wrntycustclmprocessingstatus AS WrntyCustClmProcessingStatus,
  WarrantyClaimDraft.wrntycustclaimrespperson AS WrntyCustClaimRespPerson,
  WarrantyClaimDraft.warrantycustomerclaimgroup AS WarrantyCustomerClaimGroup,
  WarrantyClaimDraft.warrantycustomerclaimisclosed AS WarrantyCustomerClaimIsClosed,
  WarrantyClaimDraft.wrntycustomerclaimcloseddate AS WrntyCustomerClaimClosedDate,
  WarrantyClaimDraft.warrantycustomer AS WarrantyCustomer,
  WarrantyClaimDraft.warrantycustomerrole AS WarrantyCustomerRole,
  WarrantyClaimDraft.warrantycustomerapplicationlog AS WarrantyCustomerApplicationLog,
  WarrantyClaimDraft.warrantycustclmappllogmessage AS WarrantyCustClmApplLogMessage,
  WarrantyClaimDraft.wrntysuppliercoveragetype AS WrntySupplierCoverageType,
  WarrantyClaimDraft.wrntysuplrclmprocessingstatus AS WrntySuplrClmProcessingStatus,
  WarrantyClaimDraft.wrntysuplrclaimrespperson AS WrntySuplrClaimRespPerson,
  WarrantyClaimDraft.wrntysupplierclaimgroup AS WrntySupplierClaimGroup,
  WarrantyClaimDraft.wrntysupplierclaimisclosed AS WrntySupplierClaimIsClosed,
  WarrantyClaimDraft.wrntysupplierclaimcloseddate AS WrntySupplierClaimClosedDate,
  WarrantyClaimDraft.wrntysupplier AS WrntySupplier,
  WarrantyClaimDraft.wrntysupplierrole AS WrntySupplierRole,
  WarrantyClaimDraft.wrntysupplierapplicationlog AS WrntySupplierApplicationLog,
  WarrantyClaimDraft.wrntysuplrclmappllogmessage AS WrntySuplrClmApplLogMessage,
  WarrantyClaimDraft.isattachmentsenabled AS IsAttachmentsEnabled,
  WarrantyClaimDraft.draftentitycreationdatetime AS DraftEntityCreationDateTime,
  WarrantyClaimDraft.draftentitylastchangedatetime AS DraftEntityLastChangeDateTime,
  WarrantyClaimDraft.draftadministrativedatauuid AS DraftAdministrativeDataUUID,
  WarrantyClaimDraft.draftentityoperationcode AS DraftEntityOperationCode,
  WarrantyClaimDraft.hasactiveentity AS HasActiveEntity
FROM pnwtyh_d AS WarrantyClaimDraft
LEFT OUTER JOIN E_WarrantyClaimDraft AS _ExtensionWrntyClaim ON WrntyClaimHeaderUUID = _ExtensionWrntyClaim.WrntyClaimHeaderUUID  -- association [1..1]
;