PROD_VAL_MLACT

Transparent Table Application Table
26 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 26 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 (26)

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
draftentitycreationdatetime SDRAFT_CREATED_AT Draft Created On
draftentitylastchangedatetime SDRAFT_LAST_CHANGED_AT Draft Last Changed On
draftadministrativedatauuid SDRAFT_ADMIN_UUID Draft Adminv Data ID
draftentityconsistencystatus SDRAFT_CONSISTENCY_STATUS Consistency Status
draftentityoperationcode SDRAFT_OPERATION_CODE Draft - Operation Code
dummy_val_incl_eew_ps VAL_INCL_EEW MD Product valuation extension field element

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]
    DRAFTENTITYCREATIONDATETIME,    -- Draft Created On [SDRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Draft Last Changed On [SDRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- Draft Adminv Data ID [SDRAFT_ADMIN_UUID]
    DRAFTENTITYCONSISTENCYSTATUS,   -- Consistency Status [SDRAFT_CONSISTENCY_STATUS]
    DRAFTENTITYOPERATIONCODE,       -- Draft - Operation Code [SDRAFT_OPERATION_CODE]
    DUMMY_VAL_INCL_EEW_PS,          -- MD Product valuation extension field element [VAL_INCL_EEW]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More