PRCD_ELEM_DRAFT
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| v_konv_draft | view | from | CDS-View for PRCD_ELEM_DRAFT to KONV conversion |
Fields (73)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA