PNWTYH_D

Transparent Table Application Table
47 Fields 2 CDS Views

Draft table for entity R_WRNTYCLAIMTP

PNWTYH_D is an SAP database table in S/4HANA. Draft table for entity R_WRNTYCLAIMTP. It contains 47 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_WarrantyClaimDraft view_entity from EXTENSION Warranty header drft - Extension
R_WrntyClaimDraft view_entity from BASIC Warranty claim Draft

Fields (47)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY wrntyclaimheaderuuid wty_pnguid Internal Number
warrantyclaimnumber wty_clmno Claim
warrantyclaimtype wty_clmty WtyClmType
wrntyclaimexternalnumber wty_refno External Number
warrantyobjecttype wty_relty Object type
wrntyexternalobjectnumber wty_relob_ext Ext. Obj. No.
plant wty_werks Plant
isarchived wty_arch_flag Archiving
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
wrntyclaimheadertext wty_pnhtx Info. Clm Head.
wrntyclaimcreationtime wty_time Creation Time
wrntyclaimsourceobjectnumber wty_source_object Source object
wrntyclaimsource wty_claim_source Claim Source
wrntyclaimdamagedate wty_damage_date Damage date
wrntyclaimregistrationdate wty_registration_date Registration date
wrntyclaimrepairdate wty_repair_date Repair start date
wrntyclaimrepairenddate wty_repair_end_date Repair end date
warrantyclaimmileage wty_mileage Wrnty Mileage
wrntyclmoperatingdurationinhrs wty_operating_hour Duration
wrntyclmoperatingdurationunit wty_operating_hrs_unit Duration
warrantyclaimmileageunit wty_mileage_unit Mileage Unit
warrantycustomercoveragetype wty_coverage_type Coverage type
wrntycustclmprocessingstatus wty_astate Processing Status
wrntycustclaimrespperson wty_clerk Person Respons.
warrantycustomerclaimgroup wty_clmgrp Claim Group
warrantycustomerclaimisclosed wty_closed Completed
wrntycustomerclaimcloseddate wty_close_date Completion Date
warrantycustomer wty_parnr Partner
warrantycustomerrole parvw_unv Partner Funct.
warrantycustomerapplicationlog wty_log_handle Message
warrantycustclmappllogmessage balloghndl Handle
wrntysuppliercoveragetype wty_coverage_type_sup Coverage type(Suplr)
wrntysuplrclmprocessingstatus wty_astate_sup ProcgStatus(Suplr)
wrntysuplrclaimrespperson wty_clerk_sup PersnRespSuplr
wrntysupplierclaimgroup wty_clmgrp_sup ClaimGrp(Suplr)
wrntysupplierclaimisclosed wty_closed_sup Completed(Supplier)
wrntysupplierclaimcloseddate wty_close_date_sup CmplDate(Suplr)
wrntysupplier wty_parnr_sup Partner(Suplr)
wrntysupplierrole parvw_unv Partner Funct.
wrntysupplierapplicationlog wty_log_handle Message
wrntysuplrclmappllogmessage wty_balloghndl_msg_sup Appl Log Msg
isattachmentsenabled abap.char

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_WRNTYCLAIMTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PNWTYH_D (
    MANDT,                           -- Client [mandt]
    WRNTYCLAIMHEADERUUID,            -- Internal Number [wty_pnguid]
    WARRANTYCLAIMNUMBER,             -- Claim [wty_clmno]
    WARRANTYCLAIMTYPE,               -- WtyClmType [wty_clmty]
    WRNTYCLAIMEXTERNALNUMBER,        -- External Number [wty_refno]
    WARRANTYOBJECTTYPE,              -- Object type [wty_relty]
    WRNTYEXTERNALOBJECTNUMBER,       -- Ext. Obj. No. [wty_relob_ext]
    PLANT,                           -- Plant [wty_werks]
    ISARCHIVED,                      -- Archiving [wty_arch_flag]
    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]
    WRNTYCLAIMHEADERTEXT,            -- Info. Clm Head. [wty_pnhtx]
    WRNTYCLAIMCREATIONTIME,          -- Creation Time [wty_time]
    WRNTYCLAIMSOURCEOBJECTNUMBER,    -- Source object [wty_source_object]
    WRNTYCLAIMSOURCE,                -- Claim Source [wty_claim_source]
    WRNTYCLAIMDAMAGEDATE,            -- Damage date [wty_damage_date]
    WRNTYCLAIMREGISTRATIONDATE,      -- Registration date [wty_registration_date]
    WRNTYCLAIMREPAIRDATE,            -- Repair start date [wty_repair_date]
    WRNTYCLAIMREPAIRENDDATE,         -- Repair end date [wty_repair_end_date]
    WARRANTYCLAIMMILEAGE,            -- Wrnty Mileage [wty_mileage]
    WRNTYCLMOPERATINGDURATIONINHRS,  -- Duration [wty_operating_hour]
    WRNTYCLMOPERATINGDURATIONUNIT,   -- Duration [wty_operating_hrs_unit]
    WARRANTYCLAIMMILEAGEUNIT,        -- Mileage Unit [wty_mileage_unit]
    WARRANTYCUSTOMERCOVERAGETYPE,    -- Coverage type [wty_coverage_type]
    WRNTYCUSTCLMPROCESSINGSTATUS,    -- Processing Status [wty_astate]
    WRNTYCUSTCLAIMRESPPERSON,        -- Person Respons. [wty_clerk]
    WARRANTYCUSTOMERCLAIMGROUP,      -- Claim Group [wty_clmgrp]
    WARRANTYCUSTOMERCLAIMISCLOSED,   -- Completed [wty_closed]
    WRNTYCUSTOMERCLAIMCLOSEDDATE,    -- Completion Date [wty_close_date]
    WARRANTYCUSTOMER,                -- Partner [wty_parnr]
    WARRANTYCUSTOMERROLE,            -- Partner Funct. [parvw_unv]
    WARRANTYCUSTOMERAPPLICATIONLOG,  -- Message [wty_log_handle]
    WARRANTYCUSTCLMAPPLLOGMESSAGE,   -- Handle [balloghndl]
    WRNTYSUPPLIERCOVERAGETYPE,       -- Coverage type(Suplr) [wty_coverage_type_sup]
    WRNTYSUPLRCLMPROCESSINGSTATUS,   -- ProcgStatus(Suplr) [wty_astate_sup]
    WRNTYSUPLRCLAIMRESPPERSON,       -- PersnRespSuplr [wty_clerk_sup]
    WRNTYSUPPLIERCLAIMGROUP,         -- ClaimGrp(Suplr) [wty_clmgrp_sup]
    WRNTYSUPPLIERCLAIMISCLOSED,      -- Completed(Supplier) [wty_closed_sup]
    WRNTYSUPPLIERCLAIMCLOSEDDATE,    -- CmplDate(Suplr) [wty_close_date_sup]
    WRNTYSUPPLIER,                   -- Partner(Suplr) [wty_parnr_sup]
    WRNTYSUPPLIERROLE,               -- Partner Funct. [parvw_unv]
    WRNTYSUPPLIERAPPLICATIONLOG,     -- Message [wty_log_handle]
    WRNTYSUPLRCLMAPPLLOGMESSAGE,     -- Appl Log Msg [wty_balloghndl_msg_sup]
    ISATTACHMENTSENABLED,            -- abap.char
    PRIMARY KEY (MANDT, WRNTYCLAIMHEADERUUID)
);

Learn More