OIUVL_MTAH

Transparent Table Application Table
13 Fields 1 CDS Views

Marketing Cost Tax Exemption - Header

OIUVL_MTAH is an SAP database table in S/4HANA. Marketing Cost Tax Exemption - Header. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PRAValnMktgCostTxExmpHdr view_entity from BASIC Valn Hdr for Mktg Cost Tax Exemption

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bukrs bukrs Company Code
KEY vname jv_name Joint venture
KEY doi_no oiu_doi_no Venture/DOI
KEY own_no oiu_own_no Owner
KEY majpd_cd oiu_majpd_cd Major Product
KEY matnr matnr Material
KEY eff_from_dt oiu_eff_from_dt Effective From
eff_to_dt oiu_eff_to_dt Effective To
land land1 Country/Reg.
pri_geo_loc oiu_pri_geo_loc Primary geo.loc
sevt_tax_ty oiu_sevt_tax_ty Severance Tax
mtah_no oiuvl_mtah_no Market. Rt. Num

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.

-- Marketing Cost Tax Exemption - Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIUVL_MTAH (
    MANDT,        -- Client [mandt]
    BUKRS,        -- Company Code [bukrs]
    VNAME,        -- Joint venture [jv_name]
    DOI_NO,       -- Venture/DOI [oiu_doi_no]
    OWN_NO,       -- Owner [oiu_own_no]
    MAJPD_CD,     -- Major Product [oiu_majpd_cd]
    MATNR,        -- Material [matnr]
    EFF_FROM_DT,  -- Effective From [oiu_eff_from_dt]
    EFF_TO_DT,    -- Effective To [oiu_eff_to_dt]
    LAND,         -- Country/Reg. [land1]
    PRI_GEO_LOC,  -- Primary geo.loc [oiu_pri_geo_loc]
    SEVT_TAX_TY,  -- Severance Tax [oiu_sevt_tax_ty]
    MTAH_NO,      -- Market. Rt. Num [oiuvl_mtah_no]
    PRIMARY KEY (MANDT, BUKRS, VNAME, DOI_NO, OWN_NO, MAJPD_CD, MATNR, EFF_FROM_DT)
);

Learn More