P_GMAVCT
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_GMAVCT_Compat | view | union_all | BASIC |
Fields (93)
| Key | Field | CDS Fields | Used 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA