TCJ_POSITIONS SAP (Cash Journal Document Items) Table details
Dictionary Type: Table
Description: Cash Journal Document Items
Description: Cash Journal Document Items
ABAP Code to SELECT data from TCJ_POSITIONS
Related tables to TCJ_POSITIONS
Access table TCJ_POSITIONS
Related tables to TCJ_POSITIONS
Access table TCJ_POSITIONS
Table field list including key, data, relationships and ABAP select examples
TCJ_POSITIONS is a standard SAP Table which is used to store Cash Journal Document Items data and is available within R/3 SAP systems depending on the version and release level.
The TCJ_POSITIONS table consists of various fields, each holding specific information or linking keys about Cash Journal Document Items data available in SAP. These include COMP_CODE (Company Code), CAJO_NUMBER (Cash Journal Number), FISC_YEAR (Fiscal Year), POSTING_NUMBER (Cash Journal Document Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP TCJ_POSITIONS table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
COMP_CODE | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
CAJO_NUMBER | Cash Journal Number | CJNR | CHAR | 4 | TCJ_C_JOURNALS | CJNR | CJCAJONR | H_CAJO_NUMBER | |
FISC_YEAR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
POSTING_NUMBER | Cash Journal Document Number | CJBELNR | CHAR | 10 | TCJ_DOCUMENTS | ALPHA | BELNR | ||
POSITION_NUMBER | Number of Line Item within Cash Journal Document | CJBUZEI | NUMC | 3 | BUZEI | ||||
POSITION_TYPE | Cash Journal Item Type | CJPOSTYPE | CHAR | 2 | CJPOSTYPE | ||||
TRANSACT_NUMBER | Number of Cash Journal Business Transaction | CJTRANSNUMB | CHAR | 4 | TCJ_TRANSACTIONS | CHAR4 | |||
TRANSACT_TYPE | Business Transaction Type | CJTRANSTYP | CHAR | 1 | CJTTYP | ||||
POSTING_DATE | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
CURRENCY | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
P_RECEIPTS | Cash Journal Amount Field with +/- Sign | CJAMOUNT | CURR | 15(2) | CJAMT | ||||
P_PAYMENTS | Cash Journal Amount Field with +/- Sign | CJAMOUNT | CURR | 15(2) | CJAMT | ||||
P_NET_AMOUNT | Cash Journal Document Net Amount - Document Currency | CJNET_AMOUNT | CURR | 13(2) | WERTV7 | ||||
P_NET_PAYMENT_WT | Net Payment Amount (Withholding Tax Deducted) | CJNET_PAYMENT_WT | CURR | 15(2) | CJAMT | ||||
P_TAX_AMOUNT | Tax amount in document currency | WMWST | CURR | 13(2) | WERT7 | ||||
TAX_CODE | Tax on sales/purchases code | MWSKZ | CHAR | 2 | T007A | MWSKZ | |||
GL_ACCOUNT | General Ledger Account | HKONT | CHAR | 10 | SKA1 | ALPHA | SAKNR | ||
TAX_PERCENT | Tax rate | MSATZ_F05L | DEC | 7(3) | PRZ43V | ||||
POSITION_TEXT | Cash Journal Line Item Text | CJPOSTEXT | CHAR | 50 | TEXT50 | ||||
VENDOR_NO | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
CUSTOMER | Customer Numbers | KUNNR | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | C_KUNNR |
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
PARGB | Trading partner's business area | PARGB | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
VBUND | Company ID of trading partner | RASSC | CHAR | 6 | Assigned to domain | ALPHA | RCOMP | PGS | |
RMVCT | Transaction Type | RMVCT | CHAR | 3 | Assigned to domain | RMVCT | |||
FKBER | Functional Area | FKBER | CHAR | 16 | Assigned to domain | FKBER | FBE | ||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | Assigned to domain | CACCD | CAC | ||
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
LSTAR | Activity Type | LSTAR | CHAR | 6 | Assigned to domain | LSTAR | LAR | LART_EMPTY | |
AUFNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
AFPOS | Order Item Number | CO_POSNR | NUMC | 4 | CO_POSNR | ||||
BEMOT | Accounting Indicator | BEMOT | CHAR | 2 | Assigned to domain | BEMOT | |||
KSTRG | Cost Object | KSTRG | CHAR | 12 | Assigned to domain | KSTRG | KTR | ||
PRZNR | Business Process | CO_PRZNR | CHAR | 12 | Assigned to domain | ALPHA | CO_PRZNR | KWP | |
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
PPRCTR | Partner Profit Center | PPRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PPC | |
PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
NPLNR | Network Number for Account Assignment | NPLNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | NET | |
VORNR | Operation/Activity Number | VORNR | CHAR | 4 | NUMCV | VORNR | VGN | ||
ANLN1 | Main Asset Number | BF_ANLN1 | CHAR | 12 | ALPHA | BF_ANLN1 | AN1 | ||
ANLN2 | Asset Subnumber | BF_ANLN2 | CHAR | 4 | ALPHA | BF_ANLN2 | AN2 | ||
BZDAT | Reference Date | BF_BZDAT | DATS | 8 | DATUM | ||||
ANBWA | Asset Transaction Type | BF_ANBWA | CHAR | 3 | CHAR3 | SSH_TABW | |||
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
BWTAR | Valuation Type | BWTAR_D | CHAR | 10 | Assigned to domain | BWTAR | BWT | ||
BWKEY | Valuation Area | BWKEY | CHAR | 4 | Assigned to domain | BWKEY | BWK | ||
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
HRKFT | Origin Group as Subdivision of Cost Element | HRKFT | CHAR | 4 | Assigned to domain | HRKFT | |||
HKMAT | Material-related origin | HKMAT | CHAR | 1 | HKMAT | ||||
KDAUF | Sales Order Number | KDAUF | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
KDEIN | Delivery Schedule for Sales Order | KDEIN | NUMC | 4 | NUM04 | ||||
KDPOS | Item Number in Sales Order | KDPOS | NUMC | 6 | NUM06 | KPO | |||
VNAME | Joint Venture | JV_NAME | CHAR | 6 | Assigned to domain | ALPHA | JV_NAME | JVV | |
RECID | Recovery Indicator | JV_RECIND | CHAR | 2 | Assigned to domain | ALPHA | JV_RECIND | ||
RECID_MAN | Indicator: Recovery Indicator Set Manually. | JV_RECID_M | CHAR | 1 | XFELD | ||||
EGRUP | Equity group | JV_EGROUP | CHAR | 3 | Assigned to domain | ALPHA | JV_EGROUP | GJE | |
ETYPE | Equity type | JV_ETYPE | CHAR | 3 | Assigned to domain | ALPHA | JV_ETYPE | ||
VPTNR | Partner account number | JV_PART | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
CONDI | Joint Venture Indicator (Condition Key) | JV_CONDCOD | CHAR | 2 | Assigned to domain | ALPHA | JV_CONDCOD | ||
CRPCAL | Flag CRP Calculation: Yes or NO | JV_CRPCAL | CHAR | 1 | XFELD | ||||
FIKRS | Financial Management Area | FIKRS | CHAR | 4 | Assigned to domain | FIKRS | FIK | ||
FISTL | Funds Center | FISTL | CHAR | 16 | Assigned to domain | FISTL | FIS | ||
FIPOS | Commitment Item | FIPOS | CHAR | 14 | Assigned to domain | FIPOS | FIP | ||
FIPEX | Commitment Item | FM_FIPEX | CHAR | 24 | Assigned to domain | FM_FIPEX | FPS | ||
GEBER | Fund | BP_GEBER | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
KBLNR | Document Number for Earmarked Funds | KBLNR_FI | CHAR | 10 | Assigned to domain | ALPHA | KBLNR | KBL | |
KBLPOS | Earmarked Funds: Document Item | KBLPOS | NUMC | 3 | Assigned to domain | KBLPOS | KBP | ||
ERLKZ | Used earmarked funds set to 'Complete' | REFSETERLK | CHAR | 1 | CHAR1_X | ||||
PERNR | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER | |||
PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | RKEOBJNR | ||||
IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8 | IMKEY | ||||
KONTT | Account Assignment Category for Industry Solution | KONTT_FI | CHAR | 2 | KONTT_FI | ||||
KONTL | Acct assignment string for industry-specific acct assignmnts | KONTL_FI | CHAR | 50 | CHAR50 | ||||
SMIVE | Lease-Out Number | SMIVE | CHAR | 13 | ALPHA | VVSMIVE | MIV | MRTA | |
GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | |
DABRZ | Reference Date for Settlement | DABRBEZ | DATS | 8 | DDAT | ||||
BUDGET_PD | FM: Budget Period | FM_BUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | BUDPER | ||
TAXJURCODE | Tax Jurisdiction | TXJCD | CHAR | 15 | TTXJ | TXJCD | TXJ | ||
ALLOC_NMBR | Assignment Number | DZUONR | CHAR | 18 | ZUONR | ||||
BRANCH | Account Number of the Branch | FILKD | CHAR | 10 | ALPHA | MAXKK | |||
P_FWBAS | Tax Base Amount in Document Currency | FWBAS | CURR | 13(2) | WERT7 | ||||
SEGMENT | Segment for Segmental Reporting | FB_SEGMENT | CHAR | 10 | FAGL_SEGM | ALPHA | FB_SEGMENT | ||
PSEGMENT | Partner Segment for Segmental Reporting | FB_PSEGMENT | CHAR | 10 | FAGL_SEGM | ALPHA | FB_SEGMENT | ||
STCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
UMSKZ | Special G/L Indicator | UMSKZ | CHAR | 1 | Assigned to domain | UMSKZ |
Key field | Non-key field |
How do I retrieve data from SAP table TCJ_POSITIONS using ABAP code
The following ABAP code Example will allow you to do a basic selection on TCJ_POSITIONS to SELECT all data from the tableDATA: WA_TCJ_POSITIONS TYPE TCJ_POSITIONS.
SELECT SINGLE *
FROM TCJ_POSITIONS
INTO CORRESPONDING FIELDS OF WA_TCJ_POSITIONS
WHERE...
How to access SAP table TCJ_POSITIONS
Within an ECC or HANA version of SAP you can also view further information about TCJ_POSITIONS and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects