WLF_D_SDOPRCCI_D

Transparent Table Application Table
68 Fields 1 CDS Views

Draft table for entity R_SETTLMTDOCITMCUSTPRCGELMNTTP

WLF_D_SDOPRCCI_D is an SAP database table in S/4HANA. Draft table for entity R_SETTLMTDOCITMCUSTPRCGELMNTTP. It contains 68 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_SettlmtDocItmCustPrcgElmntD view_entity from BASIC Settlmt Doc Itm Cust Prcg Elmnt Draft Query

Fields (68)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY settlmtdoc WBELN_ZR Settlement Doc.
KEY settlmtdocitem WPOSNR_LF Item
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
accountkeyforglaccount KVSL1 Account Key
glaccount SAKNR G/L Account
acctkeyforaccrualsglaccount KVSL2 Accruals
accrualsglaccount SAKNR_ACCR Accruals Acc.
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
settlmtdocdraftuuid SDRAFT_UUID Draft Document ID
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_SETTLMTDOCITMCUSTPRCGELMNTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WLF_D_SDOPRCCI_D (
    MANDT,                           -- Client [MANDT]
    SETTLMTDOC,                      -- Settlement Doc. [WBELN_ZR]
    SETTLMTDOCITEM,                  -- Item [WPOSNR_LF]
    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]
    ACCOUNTKEYFORGLACCOUNT,          -- Account Key [KVSL1]
    GLACCOUNT,                       -- G/L Account [SAKNR]
    ACCTKEYFORACCRUALSGLACCOUNT,     -- Accruals [KVSL2]
    ACCRUALSGLACCOUNT,               -- Accruals Acc. [SAKNR_ACCR]
    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]
    SETTLMTDOCDRAFTUUID,             -- Draft Document ID [SDRAFT_UUID]
    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, SETTLMTDOCITEM, PRICINGPROCEDURESTEP, PRICINGPROCEDURECOUNTER, DRAFTUUID)
);

Learn More