TCJ_POSITIONS

Cash Journal Document Items | #transactional | Component: Payment Transactions
Column Name Description
MANDT FK Client
COMP_CODE FK Company Code
CAJO_NUMBER FK Cash Journal Number
FISC_YEAR Fiscal Year
POSTING_NUMBER FK Cash Journal Document Number
POSITION_NUMBER Number of Line Item within Cash Journal Document
Column Name Description
💲 Currency Key (CURRENCY):
P_RECEIPTS Cash Journal Amount Field with +/- Sign
P_PAYMENTS Cash Journal Amount Field with +/- Sign
P_NET_AMOUNT Cash Journal Document Net Amount - Document Currency
P_NET_PAYMENT_WT Net Payment Amount (Withholding Tax Deducted)
P_TAX_AMOUNT Tax Amount in Document Currency
P_FWBAS Tax Base Amount in Document Currency
Column Name Description
Column Name Description
POSTING_DATE Posting Date in the Document
TAXCALCDATE Date for Determining Tax Rates
BZDAT Reference date
DABRZ Reference date for settlement
Column Name Description
POSITION_TYPE Cash Journal Item Type Show values
TRANSACT_TYPE Business Transaction Type Show values
HKMAT Material-related origin Show values
RECID_MAN Indicator: Recovery Indicator Set Manually. Show values
CRPCAL Flag CRP Calculation: Yes or NO Show values
ERLKZ Used earmarked funds are set to "Completed". Show values
Column Name Description Domain name
TAX_PERCENT Tax rate PRZ43V
POSITION_TEXT Cash Journal Line Item Text TEXT50
GSBER Business Area GSBER
PARGB Trading partner's business area GSBER
VBUND Company ID of Trading Partner RCOMP
RMVCT Transaction type RMVCT
FKBER Functional Area FKBER
KOKRS Controlling Area CACCD
KOSTL Cost Center KOSTL
LSTAR Activity Type LSTAR
AUFNR Order Number AUFNR
AFPOS Order item number CO_POSNR
BEMOT Accounting Indicator BEMOT
KSTRG Cost Object KSTRG
PRZNR Business Process CO_PRZNR
PRCTR Profit Center PRCTR
PPRCTR Partner Profit Center PRCTR
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_POSNR
NPLNR Network Number for Account Assignment AUFNR
VORNR Operation/Activity Number VORNR
ANLN1 Main Asset Number BF_ANLN1
ANLN2 Asset Subnumber BF_ANLN2
ANBWA Asset transaction type CHAR3
WERKS Plant WERKS
BWTAR Valuation Type BWTAR
BWKEY Valuation area BWKEY
MATNR Material Number MATNR
HRKFT Origin Group as Subdivision of Cost Element HRKFT
KDAUF Sales Order Number VBELN
KDEIN Delivery schedule for sales order NUM04
KDPOS Item number in Sales Order NUM06
VNAME Joint venture JV_NAME
RECID Recovery Indicator JV_RECIND
EGRUP Equity group JV_EGROUP
ETYPE Equity type JV_ETYPE
VPTNR Partner account number KUNNR
CONDI Joint Venture Indicator (Condition Key) JV_CONDCOD
FIKRS Financial Management Area FIKRS
FISTL Funds Center FISTL
FIPOS Commitment Item FIPOS
FIPEX Commitment Item FM_FIPEX
GEBER Fund BP_GEBER
KBLNR Document Number for Earmarked Funds KBLNR
KBLPOS Earmarked Funds: Document Item KBLPOS
PERNR Personnel Number PERNR
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR
IMKEY Internal Key for Real Estate Object IMKEY
KONTT Account Assignment Category for Industry Solution KONTT_FI
KONTL Acct assignment string for industry-specific acct assignmnts CHAR50
DUMMY_INCL_EEW_COBL Custom Fields: Dummy for Use in Extension Includes
SMIVE Lease-Out Number VVSMIVE
GRANT_NBR Grant GM_GRANT_NBR
BUDGET_PD Budget Period FM_BUDGET_PERIOD
MONAT Fiscal period MONAT
ALLOC_NMBR Assignment number ZUONR
BRANCH Account Number of the Branch MAXKK
STCEG VAT Registration Number STCEG
UMSKZ Special G/L Indicator UMSKZ
BVTYP Partner bank type BVTYP
TAX_COUNTRY Tax Reporting Country/Region LAND1
Master Data Relations Join Conditions
Cash Journal Number
  • ?
  • Cash Journal Number
Company Code
  • TCJ_POSITIONS.MANDT == T001.MANDT
  • TCJ_POSITIONS.COMP_CODE == T001.BUKRS
Currency Key
  • TCJ_POSITIONS.MANDT == TCURC.MANDT
  • TCJ_POSITIONS.CURRENCY == TCURC.WAERS
Customer Number
  • TCJ_POSITIONS.MANDT == KNA1.MANDT
  • TCJ_POSITIONS.CUSTOMER == KNA1.KUNNR
General Ledger Account
  • ?
  • Client
  • General Ledger Account
  • TCJ_POSITIONS.[column in domain "KTOPL"] == SKA1.KTOPL
  • TCJ_POSITIONS.MANDT == SKA1.MANDT
  • TCJ_POSITIONS.GL_ACCOUNT == SKA1.SAKNR
Short Key for a House Bank
  • Short Key for a House Bank
  • Company Code
  • TCJ_POSITIONS.MANDT == T012.MANDT
  • TCJ_POSITIONS.HBKID == T012.HBKID
  • TCJ_POSITIONS.COMP_CODE == T012.BUKRS
ID for Account Details
  • Company Code
  • ID for Account Details
  • Client
  • Short Key for a House Bank
  • TCJ_POSITIONS.COMP_CODE == T012K.BUKRS
  • TCJ_POSITIONS.HKTID == T012K.HKTID
  • TCJ_POSITIONS.MANDT == T012K.MANDT
  • TCJ_POSITIONS.HBKID == T012K.HBKID
Client TCJ_POSITIONS.MANDT == T000.MANDT
Partner Segment for Segmental Reporting
Segment for Segmental Reporting
Tax Jurisdiction
  • ?
  • Tax Jurisdiction
  • TCJ_POSITIONS.MANDT == TTXJ.MANDT
  • TCJ_POSITIONS.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • TCJ_POSITIONS.TAXJURCODE == TTXJ.TXJCD
Tax on sales/purchases code
  • ?
  • Tax on sales/purchases code
  • TCJ_POSITIONS.MANDT == T007A.MANDT
  • TCJ_POSITIONS.[column in domain "KALSM_D"] == T007A.KALSM
  • TCJ_POSITIONS.TAX_CODE == T007A.MWSKZ
Number of Cash Journal Business Transaction
  • ?
  • Number of Cash Journal Business Transaction
Account Number of Supplier
  • TCJ_POSITIONS.MANDT == LFA1.MANDT
  • TCJ_POSITIONS.VENDOR_NO == LFA1.LIFNR