PROD_VAL_MLACT

Transparent Table Application Table
20 Fields 1 CDS Views

I_PRODUCTWD I_PRODUCTMLACCOUNTWD

PROD_VAL_MLACT is an SAP database table in S/4HANA. I_PRODUCTWD I_PRODUCTMLACCOUNTWD. It contains 20 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
E_Productmlaccountd view from EXTENSION Extension draft view-product ML Account

Fields (20)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY draftuuid /bobf/uuid Key
parentdraftuuid /bobf/uuid Key
rootdraftuuid /bobf/uuid Key
prodcostestnumber ck_kalnr Cost EstimateNo
product matnr Material
valuationarea bwkey Valuation Area
valuationtype bwtar_d Valuation Type
currencyrole fins_ext_curtype Crcy Type/Valn View
ledger abap.char
currencyroleforedit fins_ext_curtype Crcy Type/Valn View
ledgerforedit abap.char
currency waers Currency
inventoryprice abap.curr
productpricecontrol vprsv Price control
priceunitqty ck_peinh_1 Price Unit
movingaverageprice ck_pvprs_1 Per. Unit Price
standardprice ck_stprs_1 Standard Price
companycode bukrs Company Code
hasactiveentity sdraft_has_active Has active

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.

-- I_PRODUCTWD I_PRODUCTMLACCOUNTWD
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PROD_VAL_MLACT (
    MANDT,                -- Client [mandt]
    DRAFTUUID,            -- Key [/bobf/uuid]
    PARENTDRAFTUUID,      -- Key [/bobf/uuid]
    ROOTDRAFTUUID,        -- Key [/bobf/uuid]
    PRODCOSTESTNUMBER,    -- Cost EstimateNo [ck_kalnr]
    PRODUCT,              -- Material [matnr]
    VALUATIONAREA,        -- Valuation Area [bwkey]
    VALUATIONTYPE,        -- Valuation Type [bwtar_d]
    CURRENCYROLE,         -- Crcy Type/Valn View [fins_ext_curtype]
    LEDGER,               -- abap.char
    CURRENCYROLEFOREDIT,  -- Crcy Type/Valn View [fins_ext_curtype]
    LEDGERFOREDIT,        -- abap.char
    CURRENCY,             -- Currency [waers]
    INVENTORYPRICE,       -- abap.curr
    PRODUCTPRICECONTROL,  -- Price control [vprsv]
    PRICEUNITQTY,         -- Price Unit [ck_peinh_1]
    MOVINGAVERAGEPRICE,   -- Per. Unit Price [ck_pvprs_1]
    STANDARDPRICE,        -- Standard Price [ck_stprs_1]
    COMPANYCODE,          -- Company Code [bukrs]
    HASACTIVEENTITY,      -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More