GMIP

Transparent Table Application Table
90 Fields 2 CDS Views

Plan line items table

GMIP is an SAP database table in S/4HANA. Plan line items table. It contains 90 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_GteeMBdgtChgDocItemBasic view from BASIC Grantee Management Budget Change Document Items Basic
P_Gmip_sum_view view from BASIC

Fields (90)

KeyField Data ElementDescription DomainTypeLength
KEY rclnt mandt Client
KEY gl_sirid gu_recid Record number
rldnr rldnr Ledger
rrcty rrcty Record Type
rvers rvers Version
ryear gjahr Fiscal Year
rtcur rtcur Currency
runit meins Base Unit
rpmax rpmax Period
docct docct Document Categ.
docnr belnr_d Document Number
docln docln6 G/L Line Item
rbukrs bukrs Company Code
rgrant_nbr gm_grant_nbr Grant
rsponsored_prog gm_sponsored_prog Sponsored Program
rsponsored_class gm_sponsored_class Sponsored Class
rbdgt_vldty_nbr gm_bdgt_vldty_nbr Bdgt Validty No.
rfund bp_geber Fund
rvaluetype_9 gm_valuetype GM Value Type
rtrans j_vorgang Bus.transaction
rstats_ind gm_stats Stat. Indicator
rgrantee_fy_9 gm_grantee_fy Grantee Fisc. Year
logsys logsys Logical system
bdgt_state gm_bdgt_state Workflow State
tslvt tslvt9_cs Bal. c/f TC
tsl01 tslxx9_cs Total TC
tsl02 tslxx9_cs Total TC
tsl03 tslxx9_cs Total TC
tsl04 tslxx9_cs Total TC
tsl05 tslxx9_cs Total TC
tsl06 tslxx9_cs Total TC
tsl07 tslxx9_cs Total TC
tsl08 tslxx9_cs Total TC
tsl09 tslxx9_cs Total TC
tsl10 tslxx9_cs Total TC
tsl11 tslxx9_cs Total TC
tsl12 tslxx9_cs Total TC
tsl13 tslxx9_cs Total TC
tsl14 tslxx9_cs Total TC
tsl15 tslxx9_cs Total TC
tsl16 tslxx9_cs Total TC
hslvt hslvt9_cs Bal. c/f LC
hsl01 hslxx9_cs Total LC
hsl02 hslxx9_cs Total LC
hsl03 hslxx9_cs Total LC
hsl04 hslxx9_cs Total LC
hsl05 hslxx9_cs Total LC
hsl06 hslxx9_cs Total LC
hsl07 hslxx9_cs Total LC
hsl08 hslxx9_cs Total LC
hsl09 hslxx9_cs Total LC
hsl10 hslxx9_cs Total LC
hsl11 hslxx9_cs Total LC
hsl12 hslxx9_cs Total LC
hsl13 hslxx9_cs Total LC
hsl14 hslxx9_cs Total LC
hsl15 hslxx9_cs Total LC
hsl16 hslxx9_cs Total LC
mslvt mslvt Qty c/f balance
msl01 mslxx Quantity
msl02 mslxx Quantity
msl03 mslxx Quantity
msl04 mslxx Quantity
msl05 mslxx Quantity
msl06 mslxx Quantity
msl07 mslxx Quantity
msl08 mslxx Quantity
msl09 mslxx Quantity
msl10 mslxx Quantity
msl11 mslxx Quantity
msl12 mslxx Quantity
msl13 mslxx Quantity
msl14 mslxx Quantity
msl15 mslxx Quantity
msl16 mslxx Quantity
sgtxt sgtxt Text
docty docty Document Type
activ glvor Bus.transaction
budat budat Posting Date
wsdat wsdat Value Date
refdocnr refbelnr Ref. document
refryear refgjahr Reference year
refdocln refbuzei6 Reference Item
refdocct refdocct Ref. Doc. Cat.
refactiv refglvor Ref. Transactn
cpudt cpudt Entered On
cputm cputm Entered at
usnam usnam User Name
awtyp awtyp Ref. procedure
aworg aworg Refer. Org.Unit

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.

-- Plan line items table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE GMIP (
    RCLNT,             -- Client [mandt]
    GL_SIRID,          -- Record number [gu_recid]
    RLDNR,             -- Ledger [rldnr]
    RRCTY,             -- Record Type [rrcty]
    RVERS,             -- Version [rvers]
    RYEAR,             -- Fiscal Year [gjahr]
    RTCUR,             -- Currency [rtcur]
    RUNIT,             -- Base Unit [meins]
    RPMAX,             -- Period [rpmax]
    DOCCT,             -- Document Categ. [docct]
    DOCNR,             -- Document Number [belnr_d]
    DOCLN,             -- G/L Line Item [docln6]
    RBUKRS,            -- Company Code [bukrs]
    RGRANT_NBR,        -- Grant [gm_grant_nbr]
    RSPONSORED_PROG,   -- Sponsored Program [gm_sponsored_prog]
    RSPONSORED_CLASS,  -- Sponsored Class [gm_sponsored_class]
    RBDGT_VLDTY_NBR,   -- Bdgt Validty No. [gm_bdgt_vldty_nbr]
    RFUND,             -- Fund [bp_geber]
    RVALUETYPE_9,      -- GM Value Type [gm_valuetype]
    RTRANS,            -- Bus.transaction [j_vorgang]
    RSTATS_IND,        -- Stat. Indicator [gm_stats]
    RGRANTEE_FY_9,     -- Grantee Fisc. Year [gm_grantee_fy]
    LOGSYS,            -- Logical system [logsys]
    BDGT_STATE,        -- Workflow State [gm_bdgt_state]
    TSLVT,             -- Bal. c/f TC [tslvt9_cs]
    TSL01,             -- Total TC [tslxx9_cs]
    TSL02,             -- Total TC [tslxx9_cs]
    TSL03,             -- Total TC [tslxx9_cs]
    TSL04,             -- Total TC [tslxx9_cs]
    TSL05,             -- Total TC [tslxx9_cs]
    TSL06,             -- Total TC [tslxx9_cs]
    TSL07,             -- Total TC [tslxx9_cs]
    TSL08,             -- Total TC [tslxx9_cs]
    TSL09,             -- Total TC [tslxx9_cs]
    TSL10,             -- Total TC [tslxx9_cs]
    TSL11,             -- Total TC [tslxx9_cs]
    TSL12,             -- Total TC [tslxx9_cs]
    TSL13,             -- Total TC [tslxx9_cs]
    TSL14,             -- Total TC [tslxx9_cs]
    TSL15,             -- Total TC [tslxx9_cs]
    TSL16,             -- Total TC [tslxx9_cs]
    HSLVT,             -- Bal. c/f LC [hslvt9_cs]
    HSL01,             -- Total LC [hslxx9_cs]
    HSL02,             -- Total LC [hslxx9_cs]
    HSL03,             -- Total LC [hslxx9_cs]
    HSL04,             -- Total LC [hslxx9_cs]
    HSL05,             -- Total LC [hslxx9_cs]
    HSL06,             -- Total LC [hslxx9_cs]
    HSL07,             -- Total LC [hslxx9_cs]
    HSL08,             -- Total LC [hslxx9_cs]
    HSL09,             -- Total LC [hslxx9_cs]
    HSL10,             -- Total LC [hslxx9_cs]
    HSL11,             -- Total LC [hslxx9_cs]
    HSL12,             -- Total LC [hslxx9_cs]
    HSL13,             -- Total LC [hslxx9_cs]
    HSL14,             -- Total LC [hslxx9_cs]
    HSL15,             -- Total LC [hslxx9_cs]
    HSL16,             -- Total LC [hslxx9_cs]
    MSLVT,             -- Qty c/f balance [mslvt]
    MSL01,             -- Quantity [mslxx]
    MSL02,             -- Quantity [mslxx]
    MSL03,             -- Quantity [mslxx]
    MSL04,             -- Quantity [mslxx]
    MSL05,             -- Quantity [mslxx]
    MSL06,             -- Quantity [mslxx]
    MSL07,             -- Quantity [mslxx]
    MSL08,             -- Quantity [mslxx]
    MSL09,             -- Quantity [mslxx]
    MSL10,             -- Quantity [mslxx]
    MSL11,             -- Quantity [mslxx]
    MSL12,             -- Quantity [mslxx]
    MSL13,             -- Quantity [mslxx]
    MSL14,             -- Quantity [mslxx]
    MSL15,             -- Quantity [mslxx]
    MSL16,             -- Quantity [mslxx]
    SGTXT,             -- Text [sgtxt]
    DOCTY,             -- Document Type [docty]
    ACTIV,             -- Bus.transaction [glvor]
    BUDAT,             -- Posting Date [budat]
    WSDAT,             -- Value Date [wsdat]
    REFDOCNR,          -- Ref. document [refbelnr]
    REFRYEAR,          -- Reference year [refgjahr]
    REFDOCLN,          -- Reference Item [refbuzei6]
    REFDOCCT,          -- Ref. Doc. Cat. [refdocct]
    REFACTIV,          -- Ref. Transactn [refglvor]
    CPUDT,             -- Entered On [cpudt]
    CPUTM,             -- Entered at [cputm]
    USNAM,             -- User Name [usnam]
    AWTYP,             -- Ref. procedure [awtyp]
    AWORG,             -- Refer. Org.Unit [aworg]
    PRIMARY KEY (RCLNT, GL_SIRID)
);

Learn More