1. SAP Tutorial
  2. SAP PSM

FMCJ SAP table for – IS-PS: Documents in Cash Desk Subsidiary Ledger

Here we would like to draw your attention to FMCJ table in SAP. As we know it is being mainly used with the SAP PSM-FM (Funds Management in PSM) component which is coming under PSM module (Public Sector Management). FMCJ is a SAP standard transp table used for storing IS-PS: Documents in Cash Desk Subsidiary Ledger related data in SAP. It comes under the package FMCJ.

SAP FMCJ table

Table FMCJ technical data

TableFMCJ
Data storingIS-PS: Documents in Cash Desk Subsidiary Ledger
ModulePSM
Sub ModulePSM-FM-PO
SAP PackageFMCJ
Delivery ClassA – Application table (master and transaction data)
ComponentEA-PS
Table CategoryTRANSP

SAP FMCJ 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 FMCJ table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • BUKRS : Company code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • BELNR : IS-PS: Document number for cash desk subsidiary ledger
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • GJAHR : Fiscal year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • ERNAM : Name of Person who Created the Object
    Its data type is CHAR (Character String) with field length 12
  • CPUDT : Accounting document entry date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CPUTM : Time of data entry
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • BUDAT : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BUVRG : Payment Transaction in Cash Desk Subledger
    Its data type is CHAR (Character String) with field length 10
  • BUSOH : In/out Payment Ind. for Cash Desk Subledger
    Its data type is CHAR (Character String) with field length 1
  • DMBTR : Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • WRBTR : Amount in Document Currency
    Its data type is CURR (Currency Field) with field length 15
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • HWAER : Local Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • KUNNR : Customer Number
    Its data type is CHAR (Character String) with field length 10
  • LIFNR : Account Number of Vendor or Creditor
    Its data type is CHAR (Character String) with field length 10
  • SAKNR : G/L Account Number
    Its data type is CHAR (Character String) with field length 10
  • FIPEX : Commitment item
    Its data type is CHAR (Character String) with field length 24
  • FICTR : Funds Center
    Its data type is CHAR (Character String) with field length 16
  • FUND : Fund
    Its data type is CHAR (Character String) with field length 10
  • PSOEA : Revnue Type
    Its data type is CHAR (Character String) with field length 8
  • KBLNR : Document number for earmarked funds
    Its data type is CHAR (Character String) with field length 10
  • KBLPOS : Earmarked Funds: Document Item
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • XBLNR : Reference Document Number
    Its data type is CHAR (Character String) with field length 16
  • SGTXT : Item Text
    Its data type is CHAR (Character String) with field length 50
  • KVERM : Account Memo
    Its data type is CHAR (Character String) with field length 50
  • STBLG : Reverse Document Number
    Its data type is CHAR (Character String) with field length 10
  • XSTBLG : Indicator for Reverse Document
    Its data type is CHAR (Character String) with field length 1
  • BELST : IS-PS: Document status in cash desk subsidiary ledger
    Its data type is CHAR (Character String) with field length 1
  • KABLG : Cash Desk Closing in Cash Desk Subledger
    Its data type is CHAR (Character String) with field length 1
  • ERZPT
    Its data type is CHAR (Character String) with field length 20
  • FI_BELNR : Accounting Document Number
    Its data type is CHAR (Character String) with field length 10
  • FI_BUZEI : Number of Line Item Within Accounting Document
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • FI_BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • FI_GJAHR : Fiscal Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • FI_UMSKZ : Special G/L Indicator
    Its data type is CHAR (Character String) with field length 1
  • FI_REBZG : Number of the Invoice the Transaction Belongs to
    Its data type is CHAR (Character String) with field length 10
  • FI_REBZJ : Fiscal Year of the Relevant Invoice (for Credit Memo)
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • FI_REBZZ : Line Item in the Relevant Invoice
    Its data type is NUMC (Character String with Digits Only) with field length 3

    • FMCJ related tables

    • FMPY : IS-PS: Payment Transactions
    • FMAC : Assign Cashier Account
    • FMPYT : IS-PS: Payment Transactions
    • FMCJ : IS-PS: Documents in Cash Desk Subsidiary Ledger

    FMCJ related transaction codes under SAP package FMCJ

    • V_FMPY : Table maintenance for FMPY
    • CJNO : Number range maintenance: FMCJ_BELNR
    • FMFI : Execute program RFFMCJFI
    • FMNO : Number range maintenance: FMCJ_BELNR
    • V_FMAC : Table maintenance for FMAC
    • FMCJ : Maintain cash journal

    Related References

    Related Tutorials

    FMCJ SAP tcode for – Maintain cash journal

    FMCJ tcode in SAP PSM (Funds Management in PSM) module. This transaction code is used for Maintain cash journal. See...

    TFK100D SAP table for – Cash Desk: Cash Desk Clearing Accounts

    TFK100D table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    DFKKCJC SAP table for – Cash Desk Closing Data

    DFKKCJC table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    ITAGCYCF SAP table for – Cash Desk Carryforward

    ITAGCYCF table in SAP FS (Collections/Disbursements in FS) module. This table is used for storing data of Cash Desk Carryforward....

    ITAGCYCONTH SAP table for – Header Data for Cash Desk Container

    ITAGCYCONTH table in SAP FS (Collections/Disbursements in FS) module. This table is used for storing data of Header Data for...

    FMPY SAP table for – IS-PS: Payment Transactions

    FMPY table in SAP PSM (Funds Management in PSM) module. This table is used for storing data of IS-PS: Payment...

    ITAGCYCDMODE SAP table for – Mode Within Cash Desk

    ITAGCYCDMODE table in SAP FS (Collections/Disbursements in FS) module. This table is used for storing data of Mode Within Cash...

    «
    »