OIUVL_MTAH

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

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
oiu_cruser ERNAM Created By
oiu_timestamp TZNTSTMPS Time Stamp

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]
    OIU_CRUSER,     -- Created By [ERNAM]
    OIU_TIMESTAMP,  -- Time Stamp [TZNTSTMPS]
    PRIMARY KEY (MANDT, BUKRS, VNAME, DOI_NO, OWN_NO, MAJPD_CD, MATNR, EFF_FROM_DT)
);

Learn More