GMAVCT

Transparent Table Application Table
94 Fields 2 CDS Views

Summary table

GMAVCT is an SAP database table in S/4HANA. Summary table. It contains 94 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_GMAVCT_Compat view from BASIC
P_GMAVCT_Old view from BASIC

Fields (94)

KeyField Data ElementDescription DomainTypeLength
KEY rclnt mandt Client
KEY rldnr rldnr Ledger
KEY rrcty rrcty Record Type
KEY rvers rvers Version
KEY ryear gjahr Fiscal Year
KEY robjnr gobjnr_r Object number
KEY cobjnr gobjnr_c Trans.objct no.
KEY sobjnr gobjnr_s Partner obj.no.
KEY rtcur rtcur Currency
KEY runit meins Base Unit
KEY drcrk shkzg Debit/Credit
KEY rpmax rpmax Period
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
cspred cspred Distr. key currency
qspred qspred Dist. key quantities

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.

-- Summary table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE GMAVCT (
    RCLNT,             -- Client [mandt]
    RLDNR,             -- Ledger [rldnr]
    RRCTY,             -- Record Type [rrcty]
    RVERS,             -- Version [rvers]
    RYEAR,             -- Fiscal Year [gjahr]
    ROBJNR,            -- Object number [gobjnr_r]
    COBJNR,            -- Trans.objct no. [gobjnr_c]
    SOBJNR,            -- Partner obj.no. [gobjnr_s]
    RTCUR,             -- Currency [rtcur]
    RUNIT,             -- Base Unit [meins]
    DRCRK,             -- Debit/Credit [shkzg]
    RPMAX,             -- Period [rpmax]
    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]
    CSPRED,            -- Distr. key currency [cspred]
    QSPRED,            -- Dist. key quantities [qspred]
    PRIMARY KEY (RCLNT, RLDNR, RRCTY, RVERS, RYEAR, ROBJNR, COBJNR, SOBJNR, RTCUR, RUNIT, DRCRK, RPMAX)
);

Learn More