FMCJ

IS-PS: Documents in Cash Desk Subsidiary Ledger | #transactional | Component: Funds Management-Specific Postings
Column Name Description
MANDT FK Client
BUKRS FK Company code
BELNR IS-PS: Document number for cash desk subsidiary ledger
GJAHR Fiscal year
Column Name Description
💲 Local Currency (HWAER):
DMBTR Amount in Local Currency
💲 Currency Key (WAERS):
WRBTR Amount in Document Currency
Column Name Description
Column Name Description
CPUDT Day On Which Accounting Document Was Entered
CPUTM Time of Entry
BUDAT Posting Date in the Document
Column Name Description
BUSOH In/out Payment Ind. for Cash Desk Subledger Show values
XSTBLG Indicator for Reverse Document Show values
BELST IS-PS: Document status in cash desk subsidiary ledger Show values
KABLG Cash Desk Closing in Cash Desk Subledger Show values
Column Name Description Domain name
ERNAM Name of Person Responsible for Creating the Object USNAM
FIPEX Commitment Item FM_FIPEX
FICTR Funds Center FISTL
BUDGET_PD Budget Period FM_BUDGET_PERIOD
XBLNR Reference Document Number XBLNR1
SGTXT Item Text TEXT50
KVERM Account Memo TEXT50
STBLG Reverse Document Number BELNR
ERZPT CHAR20
FI_BELNR Document Number of an Accounting Document BELNR
FI_BUZEI Number of Line Item Within Accounting Document BUZEI
FI_BUKRS Company Code BUKRS
FI_GJAHR Fiscal Year GJAHR
FI_UMSKZ Special G/L Indicator UMSKZ
FI_REBZG Document No. of the Invoice to Which the Transaction Belongs BELNR
FI_REBZJ Fiscal Year of the Relevant Invoice (for Credit Memo) GJAHR
FI_REBZZ Line Item in the Relevant Invoice BUZEI
Master Data Relations Join Conditions
Foreign Key for Company Code
  • FMCJ.MANDT == T001.MANDT
  • FMCJ.BUKRS == T001.BUKRS
Payment Transaction
  • Payment Transaction in Cash Desk Subledger
  • Client
  • FMCJ.BUVRG == FMPY.BUVRG
  • FMCJ.MANDT == FMPY.MANDT
Fund
  • ?
  • Fund
  • Client
Foreign Key for Customer
  • Company code
  • Customer Number
  • Client
  • FMCJ.BUKRS == KNB1.BUKRS
  • FMCJ.KUNNR == KNB1.KUNNR
  • FMCJ.MANDT == KNB1.MANDT
Foreign Key for Vendor
  • Account Number of Supplier
  • Company code
  • Client
  • FMCJ.LIFNR == LFB1.LIFNR
  • FMCJ.BUKRS == LFB1.BUKRS
  • FMCJ.MANDT == LFB1.MANDT
Client FMCJ.MANDT == T000.MANDT
Foreign Key for Revenue Type
  • Revnue Type
  • Client
  • FMCJ.PSOEA == PSO04.PSOEA
  • FMCJ.MANDT == PSO04.MANDT
Foreign Key for General Ledger
  • Company code
  • Client
  • G/L Account Number
  • FMCJ.BUKRS == SKB1.BUKRS
  • FMCJ.MANDT == SKB1.MANDT
  • FMCJ.SAKNR == SKB1.SAKNR
Test
  • FMCJ.MANDT == TCURC.MANDT
  • FMCJ.WAERS == TCURC.WAERS