OIURV_DOC_FRMMKT

Transparent Table Application Table
21 Fields 1 CDS Views

Valuation Transactions Level 3 - Marketing Detail

OIURV_DOC_FRMMKT is an SAP database table in S/4HANA. Valuation Transactions Level 3 - Marketing Detail. It contains 21 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PRAValnDocTransFmlaMktgDet view_entity from BASIC Valuation Tran Level 3 Marketing Detail

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY doc_no OIURV_DOCNR DocNr
KEY doc_year OIU_DOC_YEAR Document year
KEY line_no OIU_DOC_LINENR Doc Line No.
KEY pos_no OIU_DOC_POS_NO Position
KEY mkt_type OIU_MK_TYPE_CD Mrktg Type Code
KEY aes_cd OIU_AES_CD AES Code
mkt_cost_chg_lvl OIU_MKT_COST_CHG_LVL Mkt Cst Chg Lvl
trnsp_no OIUVL_TRNSP_NO Transporter nbr
trnsp_ct_no OIUVL_TRNSP_CT_NO Trnsp ct nbr
int_bukrs OIUVL_INT_BUKRS Int. Comp. Cd
int_vname OIUVL_INT_VNAME Internal vname
int_doi_no OIUVL_INT_DOI_NO Int doi nbr
ext_bukrs OIUVL_EXT_BUKRS Ext. Comp. Cd
ext_vname OIUVL_EXT_VNAME Ext vent name
ext_doi_no OIUVL_EXT_DOI_NO Ext doi nbr
mkct_ext OIUVL_ACTL_MKCT_EXT Actl mkct ext
mkct_int OIUVL_ACTL_MKCT_INT Act mkct int
mcr_ext OIUVL_ACTL_MCR_EXT Actl mcr ext
gr_val_curr WAERS Currency
ext_recoup_fl OIU_RECOUP_FL Recoup Fl

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 Transactions Level 3 - Marketing Detail
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIURV_DOC_FRMMKT (
    MANDT,             -- Client [MANDT]
    DOC_NO,            -- DocNr [OIURV_DOCNR]
    DOC_YEAR,          -- Document year [OIU_DOC_YEAR]
    LINE_NO,           -- Doc Line No. [OIU_DOC_LINENR]
    POS_NO,            -- Position [OIU_DOC_POS_NO]
    MKT_TYPE,          -- Mrktg Type Code [OIU_MK_TYPE_CD]
    AES_CD,            -- AES Code [OIU_AES_CD]
    MKT_COST_CHG_LVL,  -- Mkt Cst Chg Lvl [OIU_MKT_COST_CHG_LVL]
    TRNSP_NO,          -- Transporter nbr [OIUVL_TRNSP_NO]
    TRNSP_CT_NO,       -- Trnsp ct nbr [OIUVL_TRNSP_CT_NO]
    INT_BUKRS,         -- Int. Comp. Cd [OIUVL_INT_BUKRS]
    INT_VNAME,         -- Internal vname [OIUVL_INT_VNAME]
    INT_DOI_NO,        -- Int doi nbr [OIUVL_INT_DOI_NO]
    EXT_BUKRS,         -- Ext. Comp. Cd [OIUVL_EXT_BUKRS]
    EXT_VNAME,         -- Ext vent name [OIUVL_EXT_VNAME]
    EXT_DOI_NO,        -- Ext doi nbr [OIUVL_EXT_DOI_NO]
    MKCT_EXT,          -- Actl mkct ext [OIUVL_ACTL_MKCT_EXT]
    MKCT_INT,          -- Act mkct int [OIUVL_ACTL_MKCT_INT]
    MCR_EXT,           -- Actl mcr ext [OIUVL_ACTL_MCR_EXT]
    GR_VAL_CURR,       -- Currency [WAERS]
    EXT_RECOUP_FL,     -- Recoup Fl [OIU_RECOUP_FL]
    PRIMARY KEY (MANDT, DOC_NO, DOC_YEAR, LINE_NO, POS_NO, MKT_TYPE, AES_CD)
);

Learn More