WLF_D_SDOPRCCH_D
Draft table for entity R_SETTLMTDOCCUSTPRCGELMNTTP
WLF_D_SDOPRCCH_D is an SAP database table in S/4HANA. Draft table for entity R_SETTLMTDOCCUSTPRCGELMNTTP. It contains 62 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| R_SettlmtDocCustPrcgElmntDraft | view_entity | from | BASIC | Settlmt Doc Cust Prcg Elmnt Draft Query |
Fields (62)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | settlmtdoc | WBELN_ZR | Settlement Doc. | |||
| KEY | pricingprocedurestep | STUNR | Step Number | |||
| KEY | pricingprocedurecounter | WLF_VFPRC_COND_COUNT | Pricing Procedure Counter | |||
| KEY | draftuuid | SDRAFT_UUID | Draft Document ID | |||
| parentdraftuuid | SDRAFT_UUID | Draft Document ID | ||||
| conditionapplication | KAPPL | Application | ||||
| conditiontype | KSCHA | Condition Type | ||||
| priceconditiondeterminationdte | WLF_KDATU | Condition Pricing Date | ||||
| conditioncalculationtype | KRECH_LONG | Calculat.Type | ||||
| conditioncurrency | WAERS | Currency | ||||
| conditionquantity | KPEIN | Pricing Unit | ||||
| conditionquantityunit | KVMEI | Condition Unit | ||||
| conditioncategory | KNTYP | Condit.Category | ||||
| conditionisforstatistics | KSTAT | Statistical | ||||
| pricingscaletype | STFKZ | Scale Type | ||||
| isrelevantforaccrual | KRUEK | Accruals | ||||
| cndnisrelevantforinvoicelist | WLF_SETTLMT_DOC_LIST_CNDN | Settlement Document List Condition | ||||
| conditionorigin | KHERK | Condit.Origin | ||||
| isgroupcondition | KGRPE | Group Condition | ||||
| conditionrecord | KNUMH | Cond.Record No. | ||||
| conditionsequentialnumber | KOPOS_LONG | SequNo of Cond. | ||||
| taxcode | MWSKZ | Tax Code | ||||
| withholdingtaxcode | WT_WITHCD | W/Tax Code | ||||
| 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 | WLF_VFPRC_COND_COUNT_HEAD | Pricing Procedure Counter for Header | ||||
| factorforconditionbasisvalue | WLF_KFAKTOR | Factor for Condition Basis Value | ||||
| structurecondition | KDUPL | Structure Cond. | ||||
| periodfactorforcndnbasisvalue | WLF_KFAKTOR1 | Period Factor for Condition Basis Value | ||||
| pricingscalebasis | KZBZG_LONG | Scale Basis | ||||
| conditionscalebasisunit | KONMS | Scale UoM | ||||
| conditionscalebasiscurrency | KONWS | Scale Currency | ||||
| cndnisrelevantforintcobilling | KFKIV | IntcoBillCond | ||||
| conditionismanuallychanged | KMPRS | Changed Manual. | ||||
| conditionisforconfiguration | KVARC | UsedfVarConfig | ||||
| variantcondition | VARCOND | Variant Key | ||||
| conditionrateamount | VFPRC_RATE_AMOUNT | Condition Amount | ||||
| conditionbaseamount | WLF_PRCG_ELEMENT_BASE_AMOUNT | Condition Basis Amount | ||||
| conditionbasequantity | VFPRC_ELEMENT_QUANTITY | Quantity | ||||
| conditionrateratio | WLF_PRCG_ELEMENT_RATIO | Condition Ratio | ||||
| conditionrateratiounit | WLF_RATIOUNIT | Condition Rate Ratio Unit | ||||
| conditionscalebaseamount | VFPRC_SCALE_BASE_AMOUNT | Scale Base Am. | ||||
| conditionscalebasequantity | VFPRC_SCALE_BASE_QUANTITY | Scale Base Qu. | ||||
| taxcountry | FOT_TAX_COUNTRY | Tax Ctry/Reg. | ||||
| conditiontobaseqtydnmntr | VFPRC_DENOMINATOR | Denominator | ||||
| conditiontobaseqtynmrtr | VFPRC_NUMERATOR | Numerator | ||||
| conditionalternativecurrency | KWAEH | Cndn Currency | ||||
| conditionamountinlocalcrcy | WLF_CNDN_CUMLTV_AMT | Cumulative Condition Value | ||||
| expensesupplier | WLF_EXPENSE_SUPPLIER | Expense Supplier | ||||
| expensecustomer | WLF_EXPENSE_CUSTOMER | Expense Customer | ||||
| pricedetnexchangerate | WLF_KKURS_CURR_NO_CNEXT | Condition Exchange Rate | ||||
| 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_SETTLMTDOCCUSTPRCGELMNTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WLF_D_SDOPRCCH_D (
MANDT, -- Client [MANDT]
SETTLMTDOC, -- Settlement Doc. [WBELN_ZR]
PRICINGPROCEDURESTEP, -- Step Number [STUNR]
PRICINGPROCEDURECOUNTER, -- Pricing Procedure Counter [WLF_VFPRC_COND_COUNT]
DRAFTUUID, -- Draft Document ID [SDRAFT_UUID]
PARENTDRAFTUUID, -- Draft Document ID [SDRAFT_UUID]
CONDITIONAPPLICATION, -- Application [KAPPL]
CONDITIONTYPE, -- Condition Type [KSCHA]
PRICECONDITIONDETERMINATIONDTE, -- Condition Pricing Date [WLF_KDATU]
CONDITIONCALCULATIONTYPE, -- Calculat.Type [KRECH_LONG]
CONDITIONCURRENCY, -- Currency [WAERS]
CONDITIONQUANTITY, -- Pricing Unit [KPEIN]
CONDITIONQUANTITYUNIT, -- Condition Unit [KVMEI]
CONDITIONCATEGORY, -- Condit.Category [KNTYP]
CONDITIONISFORSTATISTICS, -- Statistical [KSTAT]
PRICINGSCALETYPE, -- Scale Type [STFKZ]
ISRELEVANTFORACCRUAL, -- Accruals [KRUEK]
CNDNISRELEVANTFORINVOICELIST, -- Settlement Document List Condition [WLF_SETTLMT_DOC_LIST_CNDN]
CONDITIONORIGIN, -- Condit.Origin [KHERK]
ISGROUPCONDITION, -- Group Condition [KGRPE]
CONDITIONRECORD, -- Cond.Record No. [KNUMH]
CONDITIONSEQUENTIALNUMBER, -- SequNo of Cond. [KOPOS_LONG]
TAXCODE, -- Tax Code [MWSKZ]
WITHHOLDINGTAXCODE, -- W/Tax Code [WT_WITHCD]
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, -- Pricing Procedure Counter for Header [WLF_VFPRC_COND_COUNT_HEAD]
FACTORFORCONDITIONBASISVALUE, -- Factor for Condition Basis Value [WLF_KFAKTOR]
STRUCTURECONDITION, -- Structure Cond. [KDUPL]
PERIODFACTORFORCNDNBASISVALUE, -- Period Factor for Condition Basis Value [WLF_KFAKTOR1]
PRICINGSCALEBASIS, -- Scale Basis [KZBZG_LONG]
CONDITIONSCALEBASISUNIT, -- Scale UoM [KONMS]
CONDITIONSCALEBASISCURRENCY, -- Scale Currency [KONWS]
CNDNISRELEVANTFORINTCOBILLING, -- IntcoBillCond [KFKIV]
CONDITIONISMANUALLYCHANGED, -- Changed Manual. [KMPRS]
CONDITIONISFORCONFIGURATION, -- UsedfVarConfig [KVARC]
VARIANTCONDITION, -- Variant Key [VARCOND]
CONDITIONRATEAMOUNT, -- Condition Amount [VFPRC_RATE_AMOUNT]
CONDITIONBASEAMOUNT, -- Condition Basis Amount [WLF_PRCG_ELEMENT_BASE_AMOUNT]
CONDITIONBASEQUANTITY, -- Quantity [VFPRC_ELEMENT_QUANTITY]
CONDITIONRATERATIO, -- Condition Ratio [WLF_PRCG_ELEMENT_RATIO]
CONDITIONRATERATIOUNIT, -- Condition Rate Ratio Unit [WLF_RATIOUNIT]
CONDITIONSCALEBASEAMOUNT, -- Scale Base Am. [VFPRC_SCALE_BASE_AMOUNT]
CONDITIONSCALEBASEQUANTITY, -- Scale Base Qu. [VFPRC_SCALE_BASE_QUANTITY]
TAXCOUNTRY, -- Tax Ctry/Reg. [FOT_TAX_COUNTRY]
CONDITIONTOBASEQTYDNMNTR, -- Denominator [VFPRC_DENOMINATOR]
CONDITIONTOBASEQTYNMRTR, -- Numerator [VFPRC_NUMERATOR]
CONDITIONALTERNATIVECURRENCY, -- Cndn Currency [KWAEH]
CONDITIONAMOUNTINLOCALCRCY, -- Cumulative Condition Value [WLF_CNDN_CUMLTV_AMT]
EXPENSESUPPLIER, -- Expense Supplier [WLF_EXPENSE_SUPPLIER]
EXPENSECUSTOMER, -- Expense Customer [WLF_EXPENSE_CUSTOMER]
PRICEDETNEXCHANGERATE, -- Condition Exchange Rate [WLF_KKURS_CURR_NO_CNEXT]
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, SETTLMTDOC, PRICINGPROCEDURESTEP, PRICINGPROCEDURECOUNTER, DRAFTUUID)
);
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