1. SAP Tutorial
  2. SAP PSM

GMAVCT SAP table for – Summary table

Here we would like to draw your attention to GMAVCT table in SAP. As we know it is being mainly used with the SAP PSM-GM (Grants Management in PSM) component which is coming under PSM module (Public Sector Management). GMAVCT is a SAP standard transp table used for storing Summary table related data in SAP. It comes under the package GMBASIS_E.

SAP GMAVCT table

Table GMAVCT technical data

TableGMAVCT
Data storingSummary table
ModulePSM
Sub ModulePSM-GM-GTE
SAP PackageGMBASIS_E
Delivery ClassA – Application table (master and transaction data)
ComponentEA-PS
Table CategoryTRANSP

SAP GMAVCT Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in GMAVCT table.

  • RCLNT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • RLDNR : Ledger
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • RRCTY : Record Type
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • RVERS : Version
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • RYEAR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • ROBJNR : Object number for objects (account assignment elements)
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • COBJNR : Object number for transaction attributes
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • SOBJNR : Object number for partner objects (accnt assignmnt elements)
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • RTCUR : Currency Key
    Its a key field. Its data type is CUKY (Currency key for a currency field) with field length 5
  • RUNIT : Base Unit of Measure
    Its a key field. Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • DRCRK : Debit/Credit Indicator
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • RPMAX : Period
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • RBUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • RGRANT_NBR : Grant
    Its data type is CHAR (Character String) with field length 20
  • RFUND : Fund
    Its data type is CHAR (Character String) with field length 10
  • RSPONSORED_PROG : Sponsored Program
    Its data type is CHAR (Character String) with field length 20
  • RSPONSORED_CLASS : Sponsored Class
    Its data type is CHAR (Character String) with field length 20
  • RBDGT_VLDTY_NBR : Budget Validity Number
    Its data type is CHAR (Character String) with field length 3
  • CEFFYEAR_9 : Year of Cash Effectivity
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • WFSTATE_9 : Workflow Status of a Record in the AVC Totals Table
    Its data type is CHAR (Character String) with field length 1
  • ALLOCTYPE_9 : Amount Type (Availability Control)
    Its data type is CHAR (Character String) with field length 4
  • LOGSYS : Logical system
    Its data type is CHAR (Character String) with field length 10
  • GRANTEE_FY_9 : Fiscal Year of Grantee Organization
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • SBUKRS : Company code of partner
    Its data type is CHAR (Character String) with field length 4
  • TSLVT : Balance carried forward in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL01 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL02 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL03 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL04 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL05 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL06 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL07 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL08 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL09 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL10 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL11 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL12 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL13 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL14 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL15 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL16 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • HSLVT : Balance carried forward in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL01 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL02 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL03 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL04 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL05 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL06 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL07 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL08 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL09 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL10 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL11 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL12 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL13 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL14 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL15 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL16 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • KSLVT : Balance carried forward in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL01 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL02 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL03 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL04 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL05 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL06 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL07 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL08 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL09 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL10 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL11 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL12 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL13 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL14 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL15 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL16 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • MSLVT : Balance carried forward of quantity
    Its data type is QUAN (Quantity field) with field length 15
  • MSL01 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL02 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL03 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL04 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL05 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL06 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL07 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL08 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL09 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL10 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL11 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL12 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL13 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL14 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL15 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL16 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • CSPRED : Distribution key for currency amounts
    Its data type is CHAR (Character String) with field length 4
  • QSPRED : Distribution key for quantities
    Its data type is CHAR (Character String) with field length 4

    • GMAVCT related tables

    • GMIO : Object table GMIO
    • GMVALUETYPE : Value Type definition
    • GMAVCP : Plan line items table
    • GMAVCC : Object table 2
    • GMGRANTNONE : Definition of Grant used as “Non-Relevant”
    • GMIA : Actual Line Item Table
    • GMIP : Plan line items table
    • GMAVCT : Summary table
    • GMIT : Summary table
    • GMCOUPD : CO Settings for Grants Management Update
    • GMCCSETTINGS : Company code settings
    • GMAVCO : Object table 1
    • GMAVCA : Actual line item table
    • GMVALUETYPE_TEXT : Value Type texts
    • GMFIUPD : FI Settings for Grants Management Update
    • GMIC : Object table GMIC

    GMAVCT related transaction codes under SAP package GMBASIS_E

    • GM_UPD_SETTINGS : Maintain Update Settings
    • GM_VALUETYPES : Maintain Value Types
    • S_KI4_38000356 : Program GMCOACTIVATE
    • S_PLN_16000269 : Grants Management: Line Item Display
    • S_ALN_01000079 : Master Data Index for Grant
    • GM_CC_SETTINGS : Maintain Company Code Settings
    • GMNRG : Set Not Relevant Grant
    • S_P7U_18000004 : IMG Activity: SIMG_GM_MM_TO_GM

    Related References

    Related Tutorials

    GMIT SAP table for – Summary table

    GMIT table in SAP PSM (Grants Management in PSM) module. This table is used for storing data of Summary table....

    /CCIS/PBU18T SAP table for – PBU18: Summary table x

    /CCIS/PBU18T table in SAP FI (Special Purpose Ledger in FI) module. This table is used for storing data of PBU18:...

    GLISDET SAP table for – Summary Table for Insurance (DE)

    GLISDET table in SAP FS (Collections/Disbursements in FS) module. This table is used for storing data of Summary Table for...

    GRISDET SAP table for – Summary Table for Insurance (DE) – Rollup

    GRISDET table in SAP FS (Collections/Disbursements in FS) module. This table is used for storing data of Summary Table for...

    GLT3 SAP table for – Summary Data Preparations for Consolidation

    GLT3 table in SAP FI (Consolidation in FI) module. This table is used for storing data of Summary Data Preparations...

    FMRBT SAP table for – Summary table

    FMRBT table in SAP PSM (Funds Management in PSM) module. This table is used for storing data of Summary table....

    J_3RFTAXRVT SAP table for – Tax Accounting: Summary table

    J_3RFTAXRVT table in SAP FI (Localization in FI) module. This table is used for storing data of Tax Accounting: Summary...

    «
    »