PNWTYH_D

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

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
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_wtyhdr_incl_eew_ps DUMMY Dummy function in length 1
h_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_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
    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_WTYHDR_INCL_EEW_PS,        -- Dummy function in length 1 [DUMMY]
    H_DUMMY,                         -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, WRNTYCLAIMHEADERUUID)
);

Learn More