GMAVCP

Transparent Table Application Table
108 Fields 1 CDS Views

Plan line items table

GMAVCP is an SAP database table in S/4HANA. Plan line items table. It contains 108 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_GMAVCT view from BASIC

Fields (108)

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
drcrk SHKZG Debit/Credit
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
rfund BP_GEBER Fund
rsponsored_prog GM_SPONSORED_PROG Sponsored Program
rsponsored_class GM_SPONSORED_CLASS Sponsored Class
rbdgt_vldty_nbr GM_BDGT_VLDTY_NBR Bdgt Validty No.
ceffyear_9 GNJHR YCE
wfstate_9 BUAVC_WFSTATE Workflow Status
alloctype_9 BUAVC_ALLOCTYPE Amount Type
logsys LOGSYS Logical system
grantee_fy_9 GM_GRANTEE_FY Grantee Fisc. Year
sbukrs PBUKRS Partner CoCode
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
kslvt KSLVT9_CS Bal. c/f GC
ksl01 KSLXX9_CS Total GC
ksl02 KSLXX9_CS Total GC
ksl03 KSLXX9_CS Total GC
ksl04 KSLXX9_CS Total GC
ksl05 KSLXX9_CS Total GC
ksl06 KSLXX9_CS Total GC
ksl07 KSLXX9_CS Total GC
ksl08 KSLXX9_CS Total GC
ksl09 KSLXX9_CS Total GC
ksl10 KSLXX9_CS Total GC
ksl11 KSLXX9_CS Total GC
ksl12 KSLXX9_CS Total GC
ksl13 KSLXX9_CS Total GC
ksl14 KSLXX9_CS Total GC
ksl15 KSLXX9_CS Total GC
ksl16 KSLXX9_CS Total GC
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 GMAVCP (
    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]
    DRCRK,             -- Debit/Credit [SHKZG]
    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]
    RFUND,             -- Fund [BP_GEBER]
    RSPONSORED_PROG,   -- Sponsored Program [GM_SPONSORED_PROG]
    RSPONSORED_CLASS,  -- Sponsored Class [GM_SPONSORED_CLASS]
    RBDGT_VLDTY_NBR,   -- Bdgt Validty No. [GM_BDGT_VLDTY_NBR]
    CEFFYEAR_9,        -- YCE [GNJHR]
    WFSTATE_9,         -- Workflow Status [BUAVC_WFSTATE]
    ALLOCTYPE_9,       -- Amount Type [BUAVC_ALLOCTYPE]
    LOGSYS,            -- Logical system [LOGSYS]
    GRANTEE_FY_9,      -- Grantee Fisc. Year [GM_GRANTEE_FY]
    SBUKRS,            -- Partner CoCode [PBUKRS]
    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]
    KSLVT,             -- Bal. c/f GC [KSLVT9_CS]
    KSL01,             -- Total GC [KSLXX9_CS]
    KSL02,             -- Total GC [KSLXX9_CS]
    KSL03,             -- Total GC [KSLXX9_CS]
    KSL04,             -- Total GC [KSLXX9_CS]
    KSL05,             -- Total GC [KSLXX9_CS]
    KSL06,             -- Total GC [KSLXX9_CS]
    KSL07,             -- Total GC [KSLXX9_CS]
    KSL08,             -- Total GC [KSLXX9_CS]
    KSL09,             -- Total GC [KSLXX9_CS]
    KSL10,             -- Total GC [KSLXX9_CS]
    KSL11,             -- Total GC [KSLXX9_CS]
    KSL12,             -- Total GC [KSLXX9_CS]
    KSL13,             -- Total GC [KSLXX9_CS]
    KSL14,             -- Total GC [KSLXX9_CS]
    KSL15,             -- Total GC [KSLXX9_CS]
    KSL16,             -- Total GC [KSLXX9_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