PRCD_ELEM_DRAFT

Transparent Table Application Table

Pricing Elements Draft

PRCD_ELEM_DRAFT is an SAP database table in S/4HANA. Pricing Elements Draft. It contains 73 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
v_konv_draft view from CDS-View for PRCD_ELEM_DRAFT to KONV conversion

Fields (73)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY draft_key VFPRC_ELEMENT_DRAFT_KEY GUID Draft
KEY knumv KNUMV Doc. Condition
KEY kposn KPOSN Item
KEY stunr STUNR Step Number
KEY zaehk VFPRC_COND_COUNT Counter
kappl KAPPL Application
kschl KSCHA Condition Type
kdatu VFPRC_TIMESTAMP Valid From
krech KRECH_LONG Calculat.Type
kawrt VFPRC_ELEMENT_BASE_VALUE Cond.Basis
kbetr VFPRC_ELEMENT_AMOUNT Amount
waers WAERS Currency
kkurs KKURS Cond.exch.rate
kpein KPEIN Pricing Unit
kmein KVMEI Condition Unit
kumza VFPRC_NUMERATOR Numerator
kumne VFPRC_DENOMINATOR Denominator
kntyp KNTYP Condit.Category
kstat KSTAT Statistical
knprs STFKZ Scale Type
kruek KRUEK Accruals
kreli KRELI Inv.List Cond.
kherk KHERK Condit.Origin
kgrpe KGRPE Group Condition
kolnr KOLNR Access
knumh KNUMH Cond.Record No.
kopos KOPOS_LONG SequNo of Cond.
kvsl1 KVSL1 Account Key
sakn1 SAKNR G/L Account
mwsk1 MWSKZ Tax Code
kvsl2 KVSL2 Accruals
sakn2 SAKNR_ACCR Accruals Acc.
mwsk2 WT_WITHCD W/Tax Code
lifnr LIFNR Supplier
kdiff KDIFF CondRoundDiff.
kwert VFPRC_ELEMENT_VALUE Condition Value
waerk WAERK Doc. Currency
ksteu KSTEU Cond.Control
kinak KINAK Inactive
koaid KOAID Condition Class
zaeko VFPRC_COND_COUNT_HEAD Counter
kfaktor KFAKTOR CondFactor
kdupl KDUPL Structure Cond.
kfaktor1 KFAKTOR1 CondFactor
kzbzg KZBZG_LONG Scale Basis
kstbs VFRPC_SCALE_BASE_VALUE Scale Base Val.
konms KONMS Scale UoM
konws KONWS Scale Currency
kwaeh KWAEH Cndn Currency
kwert_k VFPRC_ELEMENT_VALUE Condition Value
kfkiv KFKIV IntcoBillCond
kmprs KMPRS Changed Manual.
prsqu PRSQU1 Price Source
txjlv TXJCD_LEVEL Jurisdiction level
kbflag KBFLAG BitFlags
koupd KOUPD Condit. Update
kmxaw KMXAW Max Basis Value
kmxwr KMXWR Maximum Amount
kawrt_k VFPRC_ELEMENT_BASE_VALUE Cond.Basis
kunnr KUNNR_KO Customer
kvarc KVARC UsedfVarConfig
varcond VARCOND Variant Key
ktrel KTREL Rel.Acc.Assig.
mdflg MDFLG Matrix Maint.
_dataaging DATA_TEMPERATURE Data Aging
cpf_guid CPF_GUID Form. ID in Document
kaqty KAQTY Adjusted Qty.
val_zero VAL_ZERO Zero Value Proc.
is_acct_detn_relevant IS_ACCT_DETN_RELEVANT Acct Detn Relevant
tax_country FOT_TAX_COUNTRY Tax Ctry/Reg.
common_suppl_data COMMON_SUPPL_DATA Com. Suppl. Data
pricingsubprocedure VFPRC_PRICING_SUB_PROCEDURE Subprocedure

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.

-- Pricing Elements Draft
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PRCD_ELEM_DRAFT (
    CLIENT,                 -- Client [MANDT]
    DRAFT_KEY,              -- GUID Draft [VFPRC_ELEMENT_DRAFT_KEY]
    KNUMV,                  -- Doc. Condition [KNUMV]
    KPOSN,                  -- Item [KPOSN]
    STUNR,                  -- Step Number [STUNR]
    ZAEHK,                  -- Counter [VFPRC_COND_COUNT]
    KAPPL,                  -- Application [KAPPL]
    KSCHL,                  -- Condition Type [KSCHA]
    KDATU,                  -- Valid From [VFPRC_TIMESTAMP]
    KRECH,                  -- Calculat.Type [KRECH_LONG]
    KAWRT,                  -- Cond.Basis [VFPRC_ELEMENT_BASE_VALUE]
    KBETR,                  -- Amount [VFPRC_ELEMENT_AMOUNT]
    WAERS,                  -- Currency [WAERS]
    KKURS,                  -- Cond.exch.rate [KKURS]
    KPEIN,                  -- Pricing Unit [KPEIN]
    KMEIN,                  -- Condition Unit [KVMEI]
    KUMZA,                  -- Numerator [VFPRC_NUMERATOR]
    KUMNE,                  -- Denominator [VFPRC_DENOMINATOR]
    KNTYP,                  -- Condit.Category [KNTYP]
    KSTAT,                  -- Statistical [KSTAT]
    KNPRS,                  -- Scale Type [STFKZ]
    KRUEK,                  -- Accruals [KRUEK]
    KRELI,                  -- Inv.List Cond. [KRELI]
    KHERK,                  -- Condit.Origin [KHERK]
    KGRPE,                  -- Group Condition [KGRPE]
    KOLNR,                  -- Access [KOLNR]
    KNUMH,                  -- Cond.Record No. [KNUMH]
    KOPOS,                  -- SequNo of Cond. [KOPOS_LONG]
    KVSL1,                  -- Account Key [KVSL1]
    SAKN1,                  -- G/L Account [SAKNR]
    MWSK1,                  -- Tax Code [MWSKZ]
    KVSL2,                  -- Accruals [KVSL2]
    SAKN2,                  -- Accruals Acc. [SAKNR_ACCR]
    MWSK2,                  -- W/Tax Code [WT_WITHCD]
    LIFNR,                  -- Supplier [LIFNR]
    KDIFF,                  -- CondRoundDiff. [KDIFF]
    KWERT,                  -- Condition Value [VFPRC_ELEMENT_VALUE]
    WAERK,                  -- Doc. Currency [WAERK]
    KSTEU,                  -- Cond.Control [KSTEU]
    KINAK,                  -- Inactive [KINAK]
    KOAID,                  -- Condition Class [KOAID]
    ZAEKO,                  -- Counter [VFPRC_COND_COUNT_HEAD]
    KFAKTOR,                -- CondFactor [KFAKTOR]
    KDUPL,                  -- Structure Cond. [KDUPL]
    KFAKTOR1,               -- CondFactor [KFAKTOR1]
    KZBZG,                  -- Scale Basis [KZBZG_LONG]
    KSTBS,                  -- Scale Base Val. [VFRPC_SCALE_BASE_VALUE]
    KONMS,                  -- Scale UoM [KONMS]
    KONWS,                  -- Scale Currency [KONWS]
    KWAEH,                  -- Cndn Currency [KWAEH]
    KWERT_K,                -- Condition Value [VFPRC_ELEMENT_VALUE]
    KFKIV,                  -- IntcoBillCond [KFKIV]
    KMPRS,                  -- Changed Manual. [KMPRS]
    PRSQU,                  -- Price Source [PRSQU1]
    TXJLV,                  -- Jurisdiction level [TXJCD_LEVEL]
    KBFLAG,                 -- BitFlags [KBFLAG]
    KOUPD,                  -- Condit. Update [KOUPD]
    KMXAW,                  -- Max Basis Value [KMXAW]
    KMXWR,                  -- Maximum Amount [KMXWR]
    KAWRT_K,                -- Cond.Basis [VFPRC_ELEMENT_BASE_VALUE]
    KUNNR,                  -- Customer [KUNNR_KO]
    KVARC,                  -- UsedfVarConfig [KVARC]
    VARCOND,                -- Variant Key [VARCOND]
    KTREL,                  -- Rel.Acc.Assig. [KTREL]
    MDFLG,                  -- Matrix Maint. [MDFLG]
    _DATAAGING,             -- Data Aging [DATA_TEMPERATURE]
    CPF_GUID,               -- Form. ID in Document [CPF_GUID]
    KAQTY,                  -- Adjusted Qty. [KAQTY]
    VAL_ZERO,               -- Zero Value Proc. [VAL_ZERO]
    IS_ACCT_DETN_RELEVANT,  -- Acct Detn Relevant [IS_ACCT_DETN_RELEVANT]
    TAX_COUNTRY,            -- Tax Ctry/Reg. [FOT_TAX_COUNTRY]
    COMMON_SUPPL_DATA,      -- Com. Suppl. Data [COMMON_SUPPL_DATA]
    PRICINGSUBPROCEDURE,    -- Subprocedure [VFPRC_PRICING_SUB_PROCEDURE]
    PRIMARY KEY (CLIENT, DRAFT_KEY, KNUMV, KPOSN, STUNR, ZAEHK)
);