MMSTOITMPRGELM_D

Transparent Table Application Table
74 Fields 1 CDS Views

Draft table for entity R_STOITEMPRICINGELEMENTTP

MMSTOITMPRGELM_D is an SAP database table in S/4HANA. Draft table for entity R_STOITEMPRICINGELEMENTTP. It contains 74 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_STOItemPricingElementDraft view_entity from BASIC Pricing Element for STO Item - Draft

Fields (74)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY stocktransportorder ebeln Purchasing Doc.
KEY stocktransportorderitem ebelp Item
KEY pricingdocument knumv Doc. Condition
KEY pricingdocumentitem kposn Item
KEY pricingprocedurestep stunr Step Number
KEY pricingprocedurecounter vfprc_cond_count Counter
KEY draftuuid sdraft_uuid Draft Document ID
parentdraftuuid sdraft_uuid Draft Document ID
conditionapplication kappl Application
conditiontype kscha Condition Type
priceconditiondeterminationdte prc_kdatu
conditioncalculationtype krech_long Calculat.Type
conditionbaseamount vfprc_base_amount Cndn Bs Amt
conditionrateamount vfprc_rate_amount Condition Amount
conditionrateratio vfprc_element_ratio Ratio
conditionrateratiounit msehi Internal UoM
conditioncurrency waers Currency
pricedetnexchangerate kursk_not_converted 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
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
customerrebaterecipient kunnr_ko Customer
conditionisforconfiguration kvarc UsedfVarConfig
variantcondition varcond Variant Key
conditionacctassgmtrelevance ktrel Rel.Acc.Assig.
conditionmatrixmaintrelevance wty_mdflg
configblparametersandformulas cpf_guid Form. ID in Document
conditionadjustedquantity kaqty Adjusted Qty.
conditiontypename vtxtm Description
taxcodename price_element_tax_code_descr Tax Code Descr.
conditionisdeletable abap.char
pricingprocedure kalsm_d Procedure
stktransptorddraftuuid sdraft_uuid Draft Document ID

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_STOITEMPRICINGELEMENTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSTOITMPRGELM_D (
    MANDT,                           -- Client [mandt]
    STOCKTRANSPORTORDER,             -- Purchasing Doc. [ebeln]
    STOCKTRANSPORTORDERITEM,         -- Item [ebelp]
    PRICINGDOCUMENT,                 -- Doc. Condition [knumv]
    PRICINGDOCUMENTITEM,             -- Item [kposn]
    PRICINGPROCEDURESTEP,            -- Step Number [stunr]
    PRICINGPROCEDURECOUNTER,         -- Counter [vfprc_cond_count]
    DRAFTUUID,                       -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,                 -- Draft Document ID [sdraft_uuid]
    CONDITIONAPPLICATION,            -- Application [kappl]
    CONDITIONTYPE,                   -- Condition Type [kscha]
    PRICECONDITIONDETERMINATIONDTE,  -- prc_kdatu
    CONDITIONCALCULATIONTYPE,        -- Calculat.Type [krech_long]
    CONDITIONBASEAMOUNT,             -- Cndn Bs Amt [vfprc_base_amount]
    CONDITIONRATEAMOUNT,             -- Condition Amount [vfprc_rate_amount]
    CONDITIONRATERATIO,              -- Ratio [vfprc_element_ratio]
    CONDITIONRATERATIOUNIT,          -- Internal UoM [msehi]
    CONDITIONCURRENCY,               -- Currency [waers]
    PRICEDETNEXCHANGERATE,           -- Exchange Rate [kursk_not_converted]
    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]
    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]
    CUSTOMERREBATERECIPIENT,         -- Customer [kunnr_ko]
    CONDITIONISFORCONFIGURATION,     -- UsedfVarConfig [kvarc]
    VARIANTCONDITION,                -- Variant Key [varcond]
    CONDITIONACCTASSGMTRELEVANCE,    -- Rel.Acc.Assig. [ktrel]
    CONDITIONMATRIXMAINTRELEVANCE,   -- wty_mdflg
    CONFIGBLPARAMETERSANDFORMULAS,   -- Form. ID in Document [cpf_guid]
    CONDITIONADJUSTEDQUANTITY,       -- Adjusted Qty. [kaqty]
    CONDITIONTYPENAME,               -- Description [vtxtm]
    TAXCODENAME,                     -- Tax Code Descr. [price_element_tax_code_descr]
    CONDITIONISDELETABLE,            -- abap.char
    PRICINGPROCEDURE,                -- Procedure [kalsm_d]
    STKTRANSPTORDDRAFTUUID,          -- Draft Document ID [sdraft_uuid]
    PRIMARY KEY (MANDT, STOCKTRANSPORTORDER, STOCKTRANSPORTORDERITEM, PRICINGDOCUMENT, PRICINGDOCUMENTITEM, PRICINGPROCEDURESTEP, PRICINGPROCEDURECOUNTER, DRAFTUUID)
);

Learn More