PVWTY_D

Transparent Table Application Table
39 Fields 2 CDS Views

Draft table for entity R_WRNTYCLAIMITEMTP

PVWTY_D is an SAP database table in S/4HANA. Draft table for entity R_WRNTYCLAIMITEMTP. It contains 39 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_WarrantyClaimItemDraft view_entity from EXTENSION Warranty item drft - Extension
R_WrntyClaimItemDraft view_entity from BASIC Warranty claim Item Draft

Fields (39)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY wrntyitemuuid wty_pvguid Internal Number
wrntyclaimheaderuuid wty_pnguid Internal Number
wrntyversionuuid wty_pnguid Internal Number
warrantyitemkey wty_itmno Key
warrantyclaimitemnumber wty_posnr Item
wrntycontrollingitemtype wty_poskt ControlItemType
warrantyclaimitemdefectcode wty_defct Defect Code
wrntyclaimquantity wty_quant Quantity
quantityunit wty_meinh Unit of Measure
warrantyclaimitemdecisioncode wty_rejcd Decision
wrntyclmpartsiscausingdamage flag Indicator
wrntyclaimitemshorttext wty_pvtx Description
wrntyclaimantclaimamount wty_valic Amount Claimed
wrntyreimburserclaimamount wty_valov OVAmountClaimed
wrntyreimburseapprovedamount wty_valiv IV Approved
wrntyclaimedapprovedamount wty_valoc OC Approved
material wty_matnr Material
wrntyreturnpartsfrmcuststatus wty_retpa PtsStatusClaim
wrntyreturnpartstosuplrstatus wty_retpa_v PtsStatusReimb.
warrantyclaimitemtaxcode wty_tax_code Tax Code
wrntyitemcustretpartsdate wty_retpa_date Date Parts Return
wrntyitemsuplrretpartsdate wty_retpa_date_v DatePartsReturnReim.
wrntyitmcustretpartsdelivdate wty_retpa_delv_date Date Parts Rtrn
wrntyitmsuplrretpartsdelivdate wty_retpa_delv_date_v Date Parts Return
warrantyclaimcatalog wty_catalog Catalog
warrantyitemtype wty_poskt_cust Item Type
warrantyclaimitempricingstatus wty_status_pricing Pricing Status
warrantyclaimchangedatetime wty_timstmp Time Stamp
wrntyclaimcreationdate wty_creadat Created On
createdbyuser wty_creaby Created by
wrntyclaimchangeddate wty_chngdat Changed On
lastchangedbyuser wty_chngby Changed By
wrntycurrencycode wty_crncy Currency
wrntydocumentcondition knumv Doc. Condition
wrntyclmitmdfltcndntype wty_kschl_soc Cond. Type Amount OC
wrntypriceexchangeratedate wty_prsdt Pricing Date
wrntyclaimitempricecndnamount vfprc_element_amount Amount
wrntyclaimitempricecndncrcy waers Currency

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Draft table for entity R_WRNTYCLAIMITEMTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PVWTY_D (
    MANDT,                           -- Client [mandt]
    WRNTYITEMUUID,                   -- Internal Number [wty_pvguid]
    WRNTYCLAIMHEADERUUID,            -- Internal Number [wty_pnguid]
    WRNTYVERSIONUUID,                -- Internal Number [wty_pnguid]
    WARRANTYITEMKEY,                 -- Key [wty_itmno]
    WARRANTYCLAIMITEMNUMBER,         -- Item [wty_posnr]
    WRNTYCONTROLLINGITEMTYPE,        -- ControlItemType [wty_poskt]
    WARRANTYCLAIMITEMDEFECTCODE,     -- Defect Code [wty_defct]
    WRNTYCLAIMQUANTITY,              -- Quantity [wty_quant]
    QUANTITYUNIT,                    -- Unit of Measure [wty_meinh]
    WARRANTYCLAIMITEMDECISIONCODE,   -- Decision [wty_rejcd]
    WRNTYCLMPARTSISCAUSINGDAMAGE,    -- Indicator [flag]
    WRNTYCLAIMITEMSHORTTEXT,         -- Description [wty_pvtx]
    WRNTYCLAIMANTCLAIMAMOUNT,        -- Amount Claimed [wty_valic]
    WRNTYREIMBURSERCLAIMAMOUNT,      -- OVAmountClaimed [wty_valov]
    WRNTYREIMBURSEAPPROVEDAMOUNT,    -- IV Approved [wty_valiv]
    WRNTYCLAIMEDAPPROVEDAMOUNT,      -- OC Approved [wty_valoc]
    MATERIAL,                        -- Material [wty_matnr]
    WRNTYRETURNPARTSFRMCUSTSTATUS,   -- PtsStatusClaim [wty_retpa]
    WRNTYRETURNPARTSTOSUPLRSTATUS,   -- PtsStatusReimb. [wty_retpa_v]
    WARRANTYCLAIMITEMTAXCODE,        -- Tax Code [wty_tax_code]
    WRNTYITEMCUSTRETPARTSDATE,       -- Date Parts Return [wty_retpa_date]
    WRNTYITEMSUPLRRETPARTSDATE,      -- DatePartsReturnReim. [wty_retpa_date_v]
    WRNTYITMCUSTRETPARTSDELIVDATE,   -- Date Parts Rtrn [wty_retpa_delv_date]
    WRNTYITMSUPLRRETPARTSDELIVDATE,  -- Date Parts Return [wty_retpa_delv_date_v]
    WARRANTYCLAIMCATALOG,            -- Catalog [wty_catalog]
    WARRANTYITEMTYPE,                -- Item Type [wty_poskt_cust]
    WARRANTYCLAIMITEMPRICINGSTATUS,  -- Pricing Status [wty_status_pricing]
    WARRANTYCLAIMCHANGEDATETIME,     -- Time Stamp [wty_timstmp]
    WRNTYCLAIMCREATIONDATE,          -- Created On [wty_creadat]
    CREATEDBYUSER,                   -- Created by [wty_creaby]
    WRNTYCLAIMCHANGEDDATE,           -- Changed On [wty_chngdat]
    LASTCHANGEDBYUSER,               -- Changed By [wty_chngby]
    WRNTYCURRENCYCODE,               -- Currency [wty_crncy]
    WRNTYDOCUMENTCONDITION,          -- Doc. Condition [knumv]
    WRNTYCLMITMDFLTCNDNTYPE,         -- Cond. Type Amount OC [wty_kschl_soc]
    WRNTYPRICEEXCHANGERATEDATE,      -- Pricing Date [wty_prsdt]
    WRNTYCLAIMITEMPRICECNDNAMOUNT,   -- Amount [vfprc_element_amount]
    WRNTYCLAIMITEMPRICECNDNCRCY,     -- Currency [waers]
    PRIMARY KEY (MANDT, WRNTYITEMUUID)
);

Learn More