WTY_A_PRC_VERS_D

Transparent Table Application Table
88 Fields 1 CDS Views

Draft table for entity R_WRNTYCLAIMVERSIONPRICINGTP_2

WTY_A_PRC_VERS_D is an SAP database table in S/4HANA. Draft table for entity R_WRNTYCLAIMVERSIONPRICINGTP_2. It contains 88 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_WrntyClmVersionPricingDraft view_entity from BASIC Warranty claim Version Pricing Draft

Fields (88)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY wrntyversionuuid WTY_PNGUID Internal Number
KEY pricingdocument KNUMV Doc. Condition
KEY pricingdocumentitem KPOSN Item
KEY pricingprocedurestep STUNR Step Number
KEY pricingprocedurecounter VFPRC_COND_COUNT Counter
KEY wrntystepnumber STUNR Step Number
wrntyclaimheaderuuid WTY_PNGUID Internal Number
conditionapplication KAPPL Application
conditiontype KSCHA Condition Type
conditiontypename VTXTM Description
priceconditiondeterminationdte KDATU CndnPricingDate
distributionupdatecode UPDKZ_D Update indicator
conditioncalculationtype KRECH_LONG Calculat.Type
conditionbasevalue VFPRC_ELEMENT_BASE_VALUE Cond.Basis
conditionratevalue VFPRC_ELEMENT_AMOUNT Amount
conditioncurrency WAERS Currency
pricedetnexchangerate FIS_EXCHANGE_RATE Exchange Rate
conditionquantity KPEIN Pricing Unit
conditionquantityunit KVMEI Condition Unit
conditiontobaseqtynmrtr VFPRC_NUMERATOR Numerator
conditiontobaseqtydnmntr VFPRC_DENOMINATOR Denominator
conditioncategory KNTYP Condit.Category
conditionisforstatistics KSTAT Statistical
pricingscaletype STFKZ Scale Type
isrelevantforaccrual KRUEK Accruals
cndnisrelevantforinvoicelist KRELI Inv.List Cond.
conditionorigin KHERK Condit.Origin
isgroupcondition KGRPE Group Condition
accessnumberofaccesssequence KOLNR Access
conditionrecord KNUMH Cond.Record No.
conditionsequentialnumber KOPOS_LONG SequNo of Cond.
accountkeyforglaccount KVSL1 Account Key
glaccount SAKNR G/L Account
taxcode MWSKZ Tax Code
acctkeyforaccrualsglaccount KVSL2 Accruals
accrualsglaccount SAKNR_ACCR Accruals Acc.
withholdingtaxcode WT_WITHCD W/Tax Code
freightsupplier LIFNR Supplier
cndnroundingoffdiffamount KDIFF CondRoundDiff.
conditionamount VFPRC_ELEMENT_VALUE Condition Value
transactioncurrency WAERK Doc. Currency
conditioncontrol KSTEU Cond.Control
conditioninactivereason KINAK Inactive
conditionclass KOAID Condition Class
prcgprocedurecounterforheader VFPRC_COND_COUNT_HEAD Counter
factorforconditionbasisvalue KFAKTOR CondFactor
structurecondition KDUPL Structure Cond.
periodfactorforcndnbasisvalue KFAKTOR1 CondFactor
pricingscalebasis KZBZG_LONG Scale Basis
conditionscalebasisvalue VFRPC_SCALE_BASE_VALUE Scale Base Val.
conditionscalebasisunit KONMS Scale UoM
conditionscalebasiscurrency KONWS Scale Currency
conditionalternativecurrency KWAEH Cndn Currency
conditionamountinlocalcrcy VFPRC_ELEMENT_VALUE Condition Value
cndnisrelevantforintcobilling KFKIV IntcoBillCond
conditionismanuallychanged KMPRS Changed Manual.
billingpricesource PRSQU1 Price Source
taxjurisdictionlevel TXJCD_LEVEL Jurisdiction level
conditionbytesequence KBFLAG BitFlags
cndnisrelevantforlimitvalue KOUPD Condit. Update
conditionbasislimitexceeded KMXAW Max Basis Value
conditionamountlimitexceeded KMXWR Maximum Amount
cumulatedconditionbasisvalue VFPRC_ELEMENT_BASE_VALUE Cond.Basis
customerrebaterecipient KUNNR_KO Customer
conditionisforconfiguration KVARC UsedfVarConfig
variantcondition VARCOND Variant Key
conditionacctassgmtrelevance KTREL Rel.Acc.Assig.
conditionmatrixmaintrelevance MDFLG Matrix Maint.
configblparametersandformulas CPF_GUID Form. ID in Document
conditionadjustedquantity KAQTY Adjusted Qty.
cndnvaluezeroprocgcode VAL_ZERO Zero Value Proc.
cndnisacctdetnrelevant IS_ACCT_DETN_RELEVANT Acct Detn Relevant
taxcountry FOT_TAX_COUNTRY Tax Ctry/Reg.
conditionbasevalueunit VFPRC_CNDN_BASE_VALUE_UNIT Cndn Basis Unit
conditionrateamount VFPRC_RATE_AMOUNT Condition Amount
conditionbaseamount VFPRC_BASE_AMOUNT Cndn Bs Amt
conditionbasequantity VFPRC_ELEMENT_QUANTITY Quantity
conditionrateratio VFPRC_ELEMENT_RATIO Ratio
conditionrateratiounit MSEHI Internal UoM
conditionscalebaseamount VFPRC_SCALE_BASE_AMOUNT Scale Base Am.
conditionscalebasequantity VFPRC_SCALE_BASE_QUANTITY Scale Base Qu.
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

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_WRNTYCLAIMVERSIONPRICINGTP_2
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WTY_A_PRC_VERS_D (
    MANDT,                           -- Client [MANDT]
    WRNTYVERSIONUUID,                -- Internal Number [WTY_PNGUID]
    PRICINGDOCUMENT,                 -- Doc. Condition [KNUMV]
    PRICINGDOCUMENTITEM,             -- Item [KPOSN]
    PRICINGPROCEDURESTEP,            -- Step Number [STUNR]
    PRICINGPROCEDURECOUNTER,         -- Counter [VFPRC_COND_COUNT]
    WRNTYSTEPNUMBER,                 -- Step Number [STUNR]
    WRNTYCLAIMHEADERUUID,            -- Internal Number [WTY_PNGUID]
    CONDITIONAPPLICATION,            -- Application [KAPPL]
    CONDITIONTYPE,                   -- Condition Type [KSCHA]
    CONDITIONTYPENAME,               -- Description [VTXTM]
    PRICECONDITIONDETERMINATIONDTE,  -- CndnPricingDate [KDATU]
    DISTRIBUTIONUPDATECODE,          -- Update indicator [UPDKZ_D]
    CONDITIONCALCULATIONTYPE,        -- Calculat.Type [KRECH_LONG]
    CONDITIONBASEVALUE,              -- Cond.Basis [VFPRC_ELEMENT_BASE_VALUE]
    CONDITIONRATEVALUE,              -- Amount [VFPRC_ELEMENT_AMOUNT]
    CONDITIONCURRENCY,               -- Currency [WAERS]
    PRICEDETNEXCHANGERATE,           -- Exchange Rate [FIS_EXCHANGE_RATE]
    CONDITIONQUANTITY,               -- Pricing Unit [KPEIN]
    CONDITIONQUANTITYUNIT,           -- Condition Unit [KVMEI]
    CONDITIONTOBASEQTYNMRTR,         -- Numerator [VFPRC_NUMERATOR]
    CONDITIONTOBASEQTYDNMNTR,        -- Denominator [VFPRC_DENOMINATOR]
    CONDITIONCATEGORY,               -- Condit.Category [KNTYP]
    CONDITIONISFORSTATISTICS,        -- Statistical [KSTAT]
    PRICINGSCALETYPE,                -- Scale Type [STFKZ]
    ISRELEVANTFORACCRUAL,            -- Accruals [KRUEK]
    CNDNISRELEVANTFORINVOICELIST,    -- Inv.List Cond. [KRELI]
    CONDITIONORIGIN,                 -- Condit.Origin [KHERK]
    ISGROUPCONDITION,                -- Group Condition [KGRPE]
    ACCESSNUMBEROFACCESSSEQUENCE,    -- Access [KOLNR]
    CONDITIONRECORD,                 -- Cond.Record No. [KNUMH]
    CONDITIONSEQUENTIALNUMBER,       -- SequNo of Cond. [KOPOS_LONG]
    ACCOUNTKEYFORGLACCOUNT,          -- Account Key [KVSL1]
    GLACCOUNT,                       -- G/L Account [SAKNR]
    TAXCODE,                         -- Tax Code [MWSKZ]
    ACCTKEYFORACCRUALSGLACCOUNT,     -- Accruals [KVSL2]
    ACCRUALSGLACCOUNT,               -- Accruals Acc. [SAKNR_ACCR]
    WITHHOLDINGTAXCODE,              -- W/Tax Code [WT_WITHCD]
    FREIGHTSUPPLIER,                 -- Supplier [LIFNR]
    CNDNROUNDINGOFFDIFFAMOUNT,       -- CondRoundDiff. [KDIFF]
    CONDITIONAMOUNT,                 -- Condition Value [VFPRC_ELEMENT_VALUE]
    TRANSACTIONCURRENCY,             -- Doc. Currency [WAERK]
    CONDITIONCONTROL,                -- Cond.Control [KSTEU]
    CONDITIONINACTIVEREASON,         -- Inactive [KINAK]
    CONDITIONCLASS,                  -- Condition Class [KOAID]
    PRCGPROCEDURECOUNTERFORHEADER,   -- Counter [VFPRC_COND_COUNT_HEAD]
    FACTORFORCONDITIONBASISVALUE,    -- CondFactor [KFAKTOR]
    STRUCTURECONDITION,              -- Structure Cond. [KDUPL]
    PERIODFACTORFORCNDNBASISVALUE,   -- CondFactor [KFAKTOR1]
    PRICINGSCALEBASIS,               -- Scale Basis [KZBZG_LONG]
    CONDITIONSCALEBASISVALUE,        -- Scale Base Val. [VFRPC_SCALE_BASE_VALUE]
    CONDITIONSCALEBASISUNIT,         -- Scale UoM [KONMS]
    CONDITIONSCALEBASISCURRENCY,     -- Scale Currency [KONWS]
    CONDITIONALTERNATIVECURRENCY,    -- Cndn Currency [KWAEH]
    CONDITIONAMOUNTINLOCALCRCY,      -- Condition Value [VFPRC_ELEMENT_VALUE]
    CNDNISRELEVANTFORINTCOBILLING,   -- IntcoBillCond [KFKIV]
    CONDITIONISMANUALLYCHANGED,      -- Changed Manual. [KMPRS]
    BILLINGPRICESOURCE,              -- Price Source [PRSQU1]
    TAXJURISDICTIONLEVEL,            -- Jurisdiction level [TXJCD_LEVEL]
    CONDITIONBYTESEQUENCE,           -- BitFlags [KBFLAG]
    CNDNISRELEVANTFORLIMITVALUE,     -- Condit. Update [KOUPD]
    CONDITIONBASISLIMITEXCEEDED,     -- Max Basis Value [KMXAW]
    CONDITIONAMOUNTLIMITEXCEEDED,    -- Maximum Amount [KMXWR]
    CUMULATEDCONDITIONBASISVALUE,    -- Cond.Basis [VFPRC_ELEMENT_BASE_VALUE]
    CUSTOMERREBATERECIPIENT,         -- Customer [KUNNR_KO]
    CONDITIONISFORCONFIGURATION,     -- UsedfVarConfig [KVARC]
    VARIANTCONDITION,                -- Variant Key [VARCOND]
    CONDITIONACCTASSGMTRELEVANCE,    -- Rel.Acc.Assig. [KTREL]
    CONDITIONMATRIXMAINTRELEVANCE,   -- Matrix Maint. [MDFLG]
    CONFIGBLPARAMETERSANDFORMULAS,   -- Form. ID in Document [CPF_GUID]
    CONDITIONADJUSTEDQUANTITY,       -- Adjusted Qty. [KAQTY]
    CNDNVALUEZEROPROCGCODE,          -- Zero Value Proc. [VAL_ZERO]
    CNDNISACCTDETNRELEVANT,          -- Acct Detn Relevant [IS_ACCT_DETN_RELEVANT]
    TAXCOUNTRY,                      -- Tax Ctry/Reg. [FOT_TAX_COUNTRY]
    CONDITIONBASEVALUEUNIT,          -- Cndn Basis Unit [VFPRC_CNDN_BASE_VALUE_UNIT]
    CONDITIONRATEAMOUNT,             -- Condition Amount [VFPRC_RATE_AMOUNT]
    CONDITIONBASEAMOUNT,             -- Cndn Bs Amt [VFPRC_BASE_AMOUNT]
    CONDITIONBASEQUANTITY,           -- Quantity [VFPRC_ELEMENT_QUANTITY]
    CONDITIONRATERATIO,              -- Ratio [VFPRC_ELEMENT_RATIO]
    CONDITIONRATERATIOUNIT,          -- Internal UoM [MSEHI]
    CONDITIONSCALEBASEAMOUNT,        -- Scale Base Am. [VFPRC_SCALE_BASE_AMOUNT]
    CONDITIONSCALEBASEQUANTITY,      -- Scale Base Qu. [VFPRC_SCALE_BASE_QUANTITY]
    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]
    PRIMARY KEY (MANDT, WRNTYVERSIONUUID, PRICINGDOCUMENT, PRICINGDOCUMENTITEM, PRICINGPROCEDURESTEP, PRICINGPROCEDURECOUNTER, WRNTYSTEPNUMBER)
);

Learn More