P_GMAVCT

CDS View

P_GMAVCT is a CDS View in S/4HANA. It contains 93 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_GMAVCT_Compat view union_all BASIC

Fields (93)

KeyField CDS FieldsUsed in Views
KEY alloctype_9 alloctype_9 1
KEY ceffyear_9 ceffyear_9 1
KEY cobjnr cobjnr 1
KEY drcrk drcrk 1
KEY grantee_fy_9 grantee_fy_9 1
KEY logsys logsys 1
KEY rbdgt_vldty_nbr rbdgt_vldty_nbr 1
KEY rbukrs rbukrs 1
KEY rfund rfund 1
KEY rgrant_nbr rgrant_nbr 1
KEY rldnr rldnr 1
KEY robjnr robjnr 1
KEY rpmax rpmax 1
KEY rrcty rrcty 1
KEY rsponsored_class rsponsored_class 1
KEY rsponsored_prog rsponsored_prog 1
KEY rtcur rtcur 1
KEY runit runit 1
KEY rvers rvers 1
KEY ryear ryear 1
KEY sbukrs sbukrs 1
KEY sobjnr sobjnr 1
KEY wfstate_9 wfstate_9 1
cspred cspred 1
hsl01 hsl01 1
hsl02 hsl02 1
hsl03 hsl03 1
hsl04 hsl04 1
hsl05 hsl05 1
hsl06 hsl06 1
hsl07 hsl07 1
hsl08 hsl08 1
hsl09 hsl09 1
hsl10 hsl10 1
hsl11 hsl11 1
hsl12 hsl12 1
hsl13 hsl13 1
hsl14 hsl14 1
hsl15 hsl15 1
hsl16 hsl16 1
hslvt hslvt 1
ksl01 ksl01 1
ksl02 ksl02 1
ksl03 ksl03 1
ksl04 ksl04 1
ksl05 ksl05 1
ksl06 ksl06 1
ksl07 ksl07 1
ksl08 ksl08 1
ksl09 ksl09 1
ksl10 ksl10 1
ksl11 ksl11 1
ksl12 ksl12 1
ksl13 ksl13 1
ksl14 ksl14 1
ksl15 ksl15 1
ksl16 ksl16 1
kslvt kslvt 1
msl01 msl01 1
msl02 msl02 1
msl03 msl03 1
msl04 msl04 1
msl05 msl05 1
msl06 msl06 1
msl07 msl07 1
msl08 msl08 1
msl09 msl09 1
msl10 msl10 1
msl11 msl11 1
msl12 msl12 1
msl13 msl13 1
msl14 msl14 1
msl15 msl15 1
msl16 msl16 1
mslvt mslvt 1
qspred qspred 1
tsl01 tsl01 1
tsl02 tsl02 1
tsl03 tsl03 1
tsl04 tsl04 1
tsl05 tsl05 1
tsl06 tsl06 1
tsl07 tsl07 1
tsl08 tsl08 1
tsl09 tsl09 1
tsl10 tsl10 1
tsl11 tsl11 1
tsl12 tsl12 1
tsl13 tsl13 1
tsl14 tsl14 1
tsl15 tsl15 1
tsl16 tsl16 1
tslvt tslvt 1

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_GMAVCT (
    ALLOCTYPE_9,
    CEFFYEAR_9,
    COBJNR,
    DRCRK,
    GRANTEE_FY_9,
    LOGSYS,
    RBDGT_VLDTY_NBR,
    RBUKRS,
    RFUND,
    RGRANT_NBR,
    RLDNR,
    ROBJNR,
    RPMAX,
    RRCTY,
    RSPONSORED_CLASS,
    RSPONSORED_PROG,
    RTCUR,
    RUNIT,
    RVERS,
    RYEAR,
    SBUKRS,
    SOBJNR,
    WFSTATE_9,
    CSPRED,
    HSL01,
    HSL02,
    HSL03,
    HSL04,
    HSL05,
    HSL06,
    HSL07,
    HSL08,
    HSL09,
    HSL10,
    HSL11,
    HSL12,
    HSL13,
    HSL14,
    HSL15,
    HSL16,
    HSLVT,
    KSL01,
    KSL02,
    KSL03,
    KSL04,
    KSL05,
    KSL06,
    KSL07,
    KSL08,
    KSL09,
    KSL10,
    KSL11,
    KSL12,
    KSL13,
    KSL14,
    KSL15,
    KSL16,
    KSLVT,
    MSL01,
    MSL02,
    MSL03,
    MSL04,
    MSL05,
    MSL06,
    MSL07,
    MSL08,
    MSL09,
    MSL10,
    MSL11,
    MSL12,
    MSL13,
    MSL14,
    MSL15,
    MSL16,
    MSLVT,
    QSPRED,
    TSL01,
    TSL02,
    TSL03,
    TSL04,
    TSL05,
    TSL06,
    TSL07,
    TSL08,
    TSL09,
    TSL10,
    TSL11,
    TSL12,
    TSL13,
    TSL14,
    TSL15,
    TSL16,
    TSLVT,
    PRIMARY KEY (ALLOCTYPE_9, CEFFYEAR_9, COBJNR, DRCRK, GRANTEE_FY_9, LOGSYS, RBDGT_VLDTY_NBR, RBUKRS, RFUND, RGRANT_NBR, RLDNR, ROBJNR, RPMAX, RRCTY, RSPONSORED_CLASS, RSPONSORED_PROG, RTCUR, RUNIT, RVERS, RYEAR, SBUKRS, SOBJNR, WFSTATE_9)
);