T149

Transparent Table Customizing Table
10 Fields 4 CDS Views

Valuation type/valuation class

T149 is an SAP database table in S/4HANA. Valuation type/valuation class. It contains 10 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_InvtryValnCatTemp view from CONSUMPTION Inventory valuation category value help
I_ProductValuationCategoryVH view from BASIC Product Valuation Category
P_BatchValuationCategory view inner BASIC Valuation category by material plant
P_Invtryvalncat view from BASIC

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bwkey bwkey Valuation Area
KEY bwtty bwtty_d Valuation Cat.
vbwaf vbwaf Default:ext.pr.
kzvbf kzvbf Ext.proc.mand.
vbwae vbwae_d Default: in-hse
kzvbe kzvbe Inhse mandatory
kzbaa kzbaa Val. type auto.
vbwaa vbwaa Proposal: Promo
kzvba kzvba Promotion mand.

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.

-- Valuation type/valuation class
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T149 (
    MANDT,  -- Client [mandt]
    BWKEY,  -- Valuation Area [bwkey]
    BWTTY,  -- Valuation Cat. [bwtty_d]
    VBWAF,  -- Default:ext.pr. [vbwaf]
    KZVBF,  -- Ext.proc.mand. [kzvbf]
    VBWAE,  -- Default: in-hse [vbwae_d]
    KZVBE,  -- Inhse mandatory [kzvbe]
    KZBAA,  -- Val. type auto. [kzbaa]
    VBWAA,  -- Proposal: Promo [vbwaa]
    KZVBA,  -- Promotion mand. [kzvba]
    PRIMARY KEY (MANDT, BWKEY, BWTTY)
);

Learn More