1. SAP Tutorial
  2. FI Module

TCJ_POSITIONS SAP table for – Cash Journal Document Items

Here we would like to draw your attention to TCJ_POSITIONS table in SAP. As we know it is being mainly used with the SAP FI-GL (General Ledger Accounting in FI) component which is coming under FI module (Financial Accounting). TCJ_POSITIONS is a SAP standard transp table used for storing Cash Journal Document Items related data in SAP. It comes under the package CAJO.

SAP TCJ_POSITIONS table

Table TCJ_POSITIONS technical data

TableTCJ_POSITIONS
Data storingCash Journal Document Items
ModuleFI
Sub ModuleFI-GL-GL-AP
SAP PackageCAJO
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • COMP_CODE : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • CAJO_NUMBER : Cash Journal Number
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • FISC_YEAR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • POSTING_NUMBER : Cash Journal Document Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • POSITION_NUMBER : Number of Line Item within Cash Journal Document
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • POSITION_TYPE : Cash Journal Item Type
    Its data type is CHAR (Character String) with field length 2
  • TRANSACT_NUMBER : Number of Cash Journal Business Transaction
    Its data type is CHAR (Character String) with field length 4
  • TRANSACT_TYPE : Business Transaction Type
    Its data type is CHAR (Character String) with field length 1
  • POSTING_DATE : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CURRENCY : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • P_RECEIPTS : Cash Journal Amount Field with +/- Sign
    Its data type is CURR (Currency Field) with field length 15
  • P_PAYMENTS : Cash Journal Amount Field with +/- Sign
    Its data type is CURR (Currency Field) with field length 15
  • P_NET_AMOUNT : Cash Journal Document Net Amount – Document Currency
    Its data type is CURR (Currency Field) with field length 13
  • P_NET_PAYMENT_WT : Net Payment Amount (Withholding Tax Deducted)
    Its data type is CURR (Currency Field) with field length 15
  • P_TAX_AMOUNT : Tax amount in document currency
    Its data type is CURR (Currency Field) with field length 13
  • TAX_CODE : Tax on sales/purchases code
    Its data type is CHAR (Character String) with field length 2
  • GL_ACCOUNT : General Ledger Account
    Its data type is CHAR (Character String) with field length 10
  • TAX_PERCENT : Tax rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • POSITION_TEXT : Cash Journal Line Item Text
    Its data type is CHAR (Character String) with field length 50
  • VENDOR_NO : Account Number of Vendor or Creditor
    Its data type is CHAR (Character String) with field length 10
  • CUSTOMER : Customer Number
    Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : Include with Additional Account Assignments for DB Tables
  • GSBER : Business Area
    Its data type is CHAR (Character String) with field length 4
  • PARGB : Trading partner’s business area
    Its data type is CHAR (Character String) with field length 4
  • VBUND : Company ID of trading partner
    Its data type is CHAR (Character String) with field length 6
  • RMVCT : Transaction type
    Its data type is CHAR (Character String) with field length 3
  • FKBER : Functional Area
    Its data type is CHAR (Character String) with field length 16
  • KOKRS : Controlling Area
    Its data type is CHAR (Character String) with field length 4
  • KOSTL : Cost Center
    Its data type is CHAR (Character String) with field length 10
  • LSTAR : Activity Type
    Its data type is CHAR (Character String) with field length 6
  • AUFNR : Order Number
    Its data type is CHAR (Character String) with field length 12
  • AFPOS : Order item number
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • BEMOT : Accounting Indicator
    Its data type is CHAR (Character String) with field length 2
  • KSTRG : Cost Object
    Its data type is CHAR (Character String) with field length 12
  • PRZNR : Business Process
    Its data type is CHAR (Character String) with field length 12
  • PRCTR : Profit Center
    Its data type is CHAR (Character String) with field length 10
  • PPRCTR : Partner Profit Center
    Its data type is CHAR (Character String) with field length 10
  • PS_PSP_PNR : Work Breakdown Structure Element (WBS Element)
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • NPLNR : Network Number for Account Assignment
    Its data type is CHAR (Character String) with field length 12
  • VORNR : Operation/Activity Number
    Its data type is CHAR (Character String) with field length 4
  • ANLN1 : Main Asset Number
    Its data type is CHAR (Character String) with field length 12
  • ANLN2 : Asset Subnumber
    Its data type is CHAR (Character String) with field length 4
  • BZDAT : Reference date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ANBWA : Asset transaction type
    Its data type is CHAR (Character String) with field length 3
  • WERKS : Plant
    Its data type is CHAR (Character String) with field length 4
  • BWTAR : Valuation type
    Its data type is CHAR (Character String) with field length 10
  • BWKEY : Valuation area
    Its data type is CHAR (Character String) with field length 4
  • MATNR : Material Number
    Its data type is CHAR (Character String) with field length 18
  • HRKFT : Origin Group as Subdivision of Cost Element
    Its data type is CHAR (Character String) with field length 4
  • HKMAT : Material-related origin
    Its data type is CHAR (Character String) with field length 1
  • KDAUF : Sales Order Number
    Its data type is CHAR (Character String) with field length 10
  • KDEIN : Delivery schedule for sales order
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • KDPOS : Item number in Sales Order
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • VNAME : Joint venture
    Its data type is CHAR (Character String) with field length 6
  • RECID : Recovery Indicator
    Its data type is CHAR (Character String) with field length 2
  • RECID_MAN : Indicator: Recovery Indicator Set Manually.
    Its data type is CHAR (Character String) with field length 1
  • EGRUP : Equity group
    Its data type is CHAR (Character String) with field length 3
  • ETYPE : Equity type
    Its data type is CHAR (Character String) with field length 3
  • VPTNR : Partner account number
    Its data type is CHAR (Character String) with field length 10
  • CONDI : Joint Venture Indicator (Condition Key)
    Its data type is CHAR (Character String) with field length 2
  • CRPCAL : Flag CRP Calculation: Yes or NO
    Its data type is CHAR (Character String) with field length 1
  • FIKRS : Financial Management Area
    Its data type is CHAR (Character String) with field length 4
  • FISTL : Funds Center
    Its data type is CHAR (Character String) with field length 16
  • FIPOS : Commitment Item
    Its data type is CHAR (Character String) with field length 14
  • FIPEX : Commitment item
    Its data type is CHAR (Character String) with field length 24
  • GEBER : Fund
    Its data type is CHAR (Character String) with field length 10
  • 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
  • ERLKZ : Used earmarked funds set to “Complete”
    Its data type is CHAR (Character String) with field length 1
  • PERNR : Personnel Number
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • PAOBJNR : Profitability Segment Number (CO-PA)
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • IMKEY : Internal Key for Real Estate Object
    Its data type is CHAR (Character String) with field length 8
  • KONTT : Account Assignment Category for Industry Solution
    Its data type is CHAR (Character String) with field length 2
  • KONTL : Acct assignment string for industry-specific acct assignmnts
    Its data type is CHAR (Character String) with field length 50
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • SMIVE : Lease-Out Number
    Its data type is CHAR (Character String) with field length 13
  • GRANT_NBR : Grant
    Its data type is CHAR (Character String) with field length 20
  • DABRZ : Reference date for settlement
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BUDGET_PD : FM: Budget Period
    Its data type is CHAR (Character String) with field length 10
  • TAXJURCODE : Tax Jurisdiction
    Its data type is CHAR (Character String) with field length 15
  • ALLOC_NMBR : Assignment number
    Its data type is CHAR (Character String) with field length 18
  • BRANCH : Account Number of the Branch
    Its data type is CHAR (Character String) with field length 10
  • P_FWBAS : Tax Base Amount in Document Currency
    Its data type is CURR (Currency Field) with field length 13
  • SEGMENT : Segment for Segmental Reporting
    Its data type is CHAR (Character String) with field length 10
  • PSEGMENT : Partner Segment for Segmental Reporting
    Its data type is CHAR (Character String) with field length 10
  • STCEG : VAT Registration Number
    Its data type is CHAR (Character String) with field length 20
  • UMSKZ : Special G/L Indicator
    Its data type is CHAR (Character String) with field length 1

    • TCJ_POSITIONS related tables

    • TCJ_C_JOURNALS : Cash Journals
    • TCJ_NUMB_GROUP : Numbering Group for Cash Documents
    • TCJ_PRINT : Cash Journal Print Parameters
    • TCJ_WTAX_ITEMS : Withholding Tax Items for Cash Journal Document Items
    • TCJ_NUMB_GROUPT : Numbering Group for Cash Documents (Text)
    • TCJ_CHECK_STACKS : Check Lists in Cash Journal
    • TCJ_DOCUMENTS : Cash Journal Documents (Header Data)
    • TCJ_CPD : FBCJ: One-Time Account Data of Cash Journal Document Items
    • TCJ_MAX_AMOUNT : Cash Journal: Amount Limit
    • TCJ_TRANS_NAMES : Cash Journal Business Transaction Names
    • TCJ_TRANSACTIONS : Cash Journal Business Transactions
    • TCJ_CJ_NAMES : Cash Journal Names
    • TCJ_POSITIONS : Cash Journal Document Items

    TCJ_POSITIONS related transaction codes under SAP package CAJO

    • FBCJ : Cash Journal
    • FBCJC6 : Number range maintenance: CAJO_DOC3
    • FBCJC5 : Maintain Numb. Groups for Cash Docs
    • FBCJ3 : Display Cash Journal
    • FBCJC3 : C FI Maintain Tables TCJ_PRINT
    • FBCJC0 : C FI Maintain Tables TCJ_C_JOURNALS
    • FBCJC1 : Cash Journal Document Number Range
    • FBCJC2 : C FI Maint. Tables TCJ_TRANSACTIONS

    Related References

    Related Tutorials

    TCJ_WTAX_ITEMS SAP table for – Withholding Tax Items for Cash Journal Document Items

    TCJ_WTAX_ITEMS table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of Withholding...

    TCJ_CPD SAP table for – FBCJ: One-Time Account Data of Cash Journal Document Items

    TCJ_CPD table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of FBCJ:...

    TCJ_DOCUMENTS SAP table for – Cash Journal Documents (Header Data)

    TCJ_DOCUMENTS table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of Cash...

    TCJ_MAX_AMOUNT SAP table for – Cash Journal: Amount Limit

    TCJ_MAX_AMOUNT table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of Cash...

    TCJ_CHECK_STACKS SAP table for – Check Lists in Cash Journal

    TCJ_CHECK_STACKS table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of Check...

    FBCJC1 SAP tcode for – Cash Journal Document Number Range

    FBCJC1 tcode in SAP FI (General Ledger Accounting in FI) module. This transaction code is used for Cash Journal Document...

    TCJ_TRANSACTIONS SAP table for – Cash Journal Business Transactions

    TCJ_TRANSACTIONS table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of Cash...

    «
    »