R_WrntyClaimItemDraft

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_WrntyClaimItemDraft.
-- 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_WrntyClaimItemDraft AS
SELECT
  WarrantyClaimItemDraft.wrntyitemuuid AS WrntyItemUUID,
  WarrantyClaimItemDraft.wrntyclaimheaderuuid AS WrntyClaimHeaderUUID,
  WarrantyClaimItemDraft.wrntyversionuuid AS WrntyVersionUUID,
  WarrantyClaimItemDraft.warrantyitemkey AS WarrantyItemKey,
  WarrantyClaimItemDraft.warrantyclaimitemnumber AS WarrantyClaimItemNumber,
  WarrantyClaimItemDraft.wrntycontrollingitemtype AS WrntyControllingItemType,
  WarrantyClaimItemDraft.warrantyclaimitemdefectcode AS WarrantyClaimItemDefectCode,
  WarrantyClaimItemDraft.wrntyclaimquantity AS WrntyClaimQuantity,
  WarrantyClaimItemDraft.quantityunit AS QuantityUnit,
  WarrantyClaimItemDraft.warrantyclaimitemdecisioncode AS WarrantyClaimItemDecisionCode,
  WarrantyClaimItemDraft.wrntyclmpartsiscausingdamage AS WrntyClmPartsIsCausingDamage,
  WarrantyClaimItemDraft.wrntyclaimitemshorttext AS WrntyClaimItemShortText,
  WarrantyClaimItemDraft.wrntyclaimantclaimamount AS WrntyClaimantClaimAmount,
  WarrantyClaimItemDraft.wrntyreimburserclaimamount AS WrntyReimburserClaimAmount,
  WarrantyClaimItemDraft.wrntyreimburseapprovedamount AS WrntyReimburseApprovedAmount,
  WarrantyClaimItemDraft.wrntyclaimedapprovedamount AS WrntyClaimedApprovedAmount,
  WarrantyClaimItemDraft.material AS Material,
  WarrantyClaimItemDraft.wrntyreturnpartsfrmcuststatus AS WrntyReturnPartsFrmCustStatus,
  WarrantyClaimItemDraft.wrntyreturnpartstosuplrstatus AS WrntyReturnPartsToSuplrStatus,
  WarrantyClaimItemDraft.warrantyclaimitemtaxcode AS WarrantyClaimItemTaxCode,
  WarrantyClaimItemDraft.wrntyitemcustretpartsdate AS WrntyItemCustRetPartsDate,
  WarrantyClaimItemDraft.wrntyitemsuplrretpartsdate AS WrntyItemSuplrRetPartsDate,
  WarrantyClaimItemDraft.wrntyitmcustretpartsdelivdate AS WrntyItmCustRetPartsDelivDate,
  WarrantyClaimItemDraft.wrntyitmsuplrretpartsdelivdate AS WrntyItmSuplrRetPartsDelivDate,
  WarrantyClaimItemDraft.warrantyclaimcatalog AS WarrantyClaimCatalog,
  WarrantyClaimItemDraft.warrantyitemtype AS WarrantyItemType,
  WarrantyClaimItemDraft.warrantyclaimitempricingstatus AS WarrantyClaimItemPricingStatus,
  WarrantyClaimItemDraft.warrantyclaimchangedatetime AS WarrantyClaimChangeDateTime,
  WarrantyClaimItemDraft.wrntyclaimcreationdate AS WrntyClaimCreationDate,
  WarrantyClaimItemDraft.createdbyuser AS CreatedByUser,
  WarrantyClaimItemDraft.wrntyclaimchangeddate AS WrntyClaimChangedDate,
  WarrantyClaimItemDraft.lastchangedbyuser AS LastChangedByUser,
  WarrantyClaimItemDraft.wrntycurrencycode AS WrntyCurrencyCode,
  WarrantyClaimItemDraft.wrntydocumentcondition AS WrntyDocumentCondition,
  WarrantyClaimItemDraft.wrntyclmitmdfltcndntype AS WrntyClmItmDfltCndnType,
  WarrantyClaimItemDraft.wrntypriceexchangeratedate AS WrntyPriceExchangeRateDate,
  WarrantyClaimItemDraft.wrntyclaimitempricecndnamount AS WrntyClaimItemPriceCndnAmount,
  WarrantyClaimItemDraft.wrntyclaimitempricecndncrcy AS WrntyClaimItemPriceCndnCrcy,
  WarrantyClaimItemDraft.draftentitycreationdatetime AS DraftEntityCreationDateTime,
  WarrantyClaimItemDraft.draftentitylastchangedatetime AS DraftEntityLastChangeDateTime,
  WarrantyClaimItemDraft.draftadministrativedatauuid AS DraftAdministrativeDataUUID,
  WarrantyClaimItemDraft.draftentityoperationcode AS DraftEntityOperationCode,
  WarrantyClaimItemDraft.hasactiveentity AS HasActiveEntity
FROM pvwty_d AS WarrantyClaimItemDraft
LEFT OUTER JOIN E_WarrantyClaimItemDraft AS _ExtensionWrntyItem ON WrntyItemUUID = _ExtensionWrntyItem.WrntyItemUUID  -- association [1..1]
;