PVWTY_D

Transparent Table Application Table
47 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 47 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 (47)

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
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field Changes
dummy_wtyitm_incl_eew_ps DUMMY Dummy function in length 1
i_dummy DUMMY Dummy function in length 1

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]
    DRAFTENTITYCREATIONDATETIME,     -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    DUMMY_WTYITM_INCL_EEW_PS,        -- Dummy function in length 1 [DUMMY]
    I_DUMMY,                         -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, WRNTYITEMUUID)
);

Learn More