FMLT_PRICE

Transparent Table Application Table
45 Fields 10 CDS Views

Material Price

FMLT_PRICE is an SAP database table in S/4HANA. Material Price. It contains 45 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
fmlv_ckmlcr_compat view from Compatibility View for CKMLCR
fmlv_ckmlcr_compat view left_outer Compatibility View for CKMLCR
FMLV_CKMLCR_UNION view union CKMLCR Union FMLT_PRICE
FMLV_CKMLPR_COMPAT_DB view from Compatibility View for CKMLPR
FMLV_EBEWH_CKMLCR_SALKV view union_all CompatView for SALKV in EBEWH
FMLV_MBEWH_CKMLCR_SALKV view union_all CompatView for SALKV in MBEWH
FMLV_OBEWH_CKMLCR_SALKV view union_all CompatView for SALKV in OBEWH
FMLV_QBEWH_CKMLCR_SALKV view union_all CompatView for SALKV in QBEWH
FMLV_XBEW_CKMLCR_SALKV view union_all CompatView for XBEW Redirect Tables
P_MaterialLedgerPrice view from BASIC

Fields (45)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY kalnr CK_KALNR Cost EstimateNo
KEY rldnr FINS_LEDGER Ledger
KEY ext_curtype FINS_EXT_CURTYPE Crcy Type/Valn View
KEY price_type FML_PRICE_TYPE Price Type
KEY price_subtype FML_PRICE_SUBTYPE Price Sub-Type
KEY date_from FML_DATE_FROM Valid From
date_to FML_DATE_TO Valid To
yrper_from FML_PERIOD_YEAR_FROM Fiscal Period From
gjahr_from FML_GJAHR_FROM From FY
period_from FML_PERIOD_FROM From Period
yrper_to FML_PERIOD_YEAR_TO Fiscal Period To
gjahr_to FML_GJAHR_TO To FY
period_to FML_PERIOD_TO To Period
price FML_PRICE Price
waers WAERS Currency
peinh PEINH Price unit
valum VALUM Valuation Unit
price_numerator FML_PR_VALUE Price Value
price_denominator FML_PR_QTY Price Quantity
vprsv VPRSV Price control
price_fixed FML_PRICE_FIXED Price Fixed Portion
lbwst CK_LBWST Curr. Valn Strat.
ce_stage FML_CE_STAGE Stage
salkv_compat FML_SALKV_COMPAT Value/MA price
matnr MATNR Material
bwkey BWKEY Valuation Area
bwtar BWTAR_D Valuation Type
sobkz SOBKZ Special Stock
kdauf MAT_KDAUF Sales order
kdpos MAT_KDPOS Sales ord. item
pspnr MAT_PSPNR WBS Element
lifnr MAT_LIFNR Vendor
bukrs BUKRS Company Code
otype FML_OTYPE Type of Val.
origin_extref_category FML_ORIGIN_EXTREF_CATEGORY Orig Ext Ref Cat
origin_extref_data FML_ORIGIN_EXTREF_DATA Orig. ER Data
init_obj_extref_category FML_INIT_OBJ_EXTREF_CATEGORY I Obj Ext Ref Cat
init_obj_extref_data FML_INIT_OBJ_EXTREF_DATA I Obj. ER Data
created_by_user ANNAM Created by
created_on FML_CREATED_ON_TSL Created on
changed_by_user AENAM Changed By
changed_on FML_CHANGED_ON_TSL Changed on
ccb_id FCO_CCB_ID Cost Comp Brkdwn ID
price_id FML_PRICE_ID ML Price 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.

-- Material Price
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FMLT_PRICE (
    MANDT,                     -- Client [MANDT]
    KALNR,                     -- Cost EstimateNo [CK_KALNR]
    RLDNR,                     -- Ledger [FINS_LEDGER]
    EXT_CURTYPE,               -- Crcy Type/Valn View [FINS_EXT_CURTYPE]
    PRICE_TYPE,                -- Price Type [FML_PRICE_TYPE]
    PRICE_SUBTYPE,             -- Price Sub-Type [FML_PRICE_SUBTYPE]
    DATE_FROM,                 -- Valid From [FML_DATE_FROM]
    DATE_TO,                   -- Valid To [FML_DATE_TO]
    YRPER_FROM,                -- Fiscal Period From [FML_PERIOD_YEAR_FROM]
    GJAHR_FROM,                -- From FY [FML_GJAHR_FROM]
    PERIOD_FROM,               -- From Period [FML_PERIOD_FROM]
    YRPER_TO,                  -- Fiscal Period To [FML_PERIOD_YEAR_TO]
    GJAHR_TO,                  -- To FY [FML_GJAHR_TO]
    PERIOD_TO,                 -- To Period [FML_PERIOD_TO]
    PRICE,                     -- Price [FML_PRICE]
    WAERS,                     -- Currency [WAERS]
    PEINH,                     -- Price unit [PEINH]
    VALUM,                     -- Valuation Unit [VALUM]
    PRICE_NUMERATOR,           -- Price Value [FML_PR_VALUE]
    PRICE_DENOMINATOR,         -- Price Quantity [FML_PR_QTY]
    VPRSV,                     -- Price control [VPRSV]
    PRICE_FIXED,               -- Price Fixed Portion [FML_PRICE_FIXED]
    LBWST,                     -- Curr. Valn Strat. [CK_LBWST]
    CE_STAGE,                  -- Stage [FML_CE_STAGE]
    SALKV_COMPAT,              -- Value/MA price [FML_SALKV_COMPAT]
    MATNR,                     -- Material [MATNR]
    BWKEY,                     -- Valuation Area [BWKEY]
    BWTAR,                     -- Valuation Type [BWTAR_D]
    SOBKZ,                     -- Special Stock [SOBKZ]
    KDAUF,                     -- Sales order [MAT_KDAUF]
    KDPOS,                     -- Sales ord. item [MAT_KDPOS]
    PSPNR,                     -- WBS Element [MAT_PSPNR]
    LIFNR,                     -- Vendor [MAT_LIFNR]
    BUKRS,                     -- Company Code [BUKRS]
    OTYPE,                     -- Type of Val. [FML_OTYPE]
    ORIGIN_EXTREF_CATEGORY,    -- Orig Ext Ref Cat [FML_ORIGIN_EXTREF_CATEGORY]
    ORIGIN_EXTREF_DATA,        -- Orig. ER Data [FML_ORIGIN_EXTREF_DATA]
    INIT_OBJ_EXTREF_CATEGORY,  -- I Obj Ext Ref Cat [FML_INIT_OBJ_EXTREF_CATEGORY]
    INIT_OBJ_EXTREF_DATA,      -- I Obj. ER Data [FML_INIT_OBJ_EXTREF_DATA]
    CREATED_BY_USER,           -- Created by [ANNAM]
    CREATED_ON,                -- Created on [FML_CREATED_ON_TSL]
    CHANGED_BY_USER,           -- Changed By [AENAM]
    CHANGED_ON,                -- Changed on [FML_CHANGED_ON_TSL]
    CCB_ID,                    -- Cost Comp Brkdwn ID [FCO_CCB_ID]
    PRICE_ID,                  -- ML Price ID [FML_PRICE_ID]
    PRIMARY KEY (MANDT, KALNR, RLDNR, EXT_CURTYPE, PRICE_TYPE, PRICE_SUBTYPE, DATE_FROM)
);

Learn More