TCJ_POSITIONS SAP (Cash Journal Document Items) Table details

Dictionary Type: Table
Description: Cash Journal Document Items




ABAP Code to SELECT data from 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
MANDTClient MANDTCLNT3T000MANDT
COMP_CODECompany Code BUKRSCHAR4T001BUKRSBUKC_T001
CAJO_NUMBERCash Journal Number CJNRCHAR4TCJ_C_JOURNALSCJNRCJCAJONRH_CAJO_NUMBER
FISC_YEARFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
POSTING_NUMBERCash Journal Document Number CJBELNRCHAR10TCJ_DOCUMENTSALPHABELNR
POSITION_NUMBERNumber of Line Item within Cash Journal Document CJBUZEINUMC3BUZEI
POSITION_TYPECash Journal Item Type CJPOSTYPECHAR2CJPOSTYPE
TRANSACT_NUMBERNumber of Cash Journal Business Transaction CJTRANSNUMBCHAR4TCJ_TRANSACTIONSCHAR4
TRANSACT_TYPEBusiness Transaction Type CJTRANSTYPCHAR1CJTTYP
POSTING_DATEPosting Date in the Document BUDATDATS8DATUM
CURRENCYCurrency Key WAERSCUKY5TCURCWAERSFWS
P_RECEIPTSCash Journal Amount Field with +/- Sign CJAMOUNTCURR15(2) CJAMT
P_PAYMENTSCash Journal Amount Field with +/- Sign CJAMOUNTCURR15(2) CJAMT
P_NET_AMOUNTCash Journal Document Net Amount - Document Currency CJNET_AMOUNTCURR13(2) WERTV7
P_NET_PAYMENT_WTNet Payment Amount (Withholding Tax Deducted) CJNET_PAYMENT_WTCURR15(2) CJAMT
P_TAX_AMOUNTTax amount in document currency WMWSTCURR13(2) WERT7
TAX_CODETax on sales/purchases code MWSKZCHAR2T007AMWSKZ
GL_ACCOUNTGeneral Ledger Account HKONTCHAR10SKA1ALPHASAKNR
TAX_PERCENTTax rate MSATZ_F05LDEC7(3) PRZ43V
POSITION_TEXTCash Journal Line Item Text CJPOSTEXTCHAR50TEXT50
VENDOR_NOAccount Number of Vendor or Creditor LIFNRCHAR10LFA1ALPHALIFNRLIFKRED_C
CUSTOMERCustomer Numbers KUNNRCHAR10KNA1ALPHAKUNNRKUNC_KUNNR
GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
PARGBTrading partner's business area PARGBCHAR4Assigned to domainGSBERGSB
VBUNDCompany ID of trading partner RASSCCHAR6Assigned to domainALPHARCOMPPGS
RMVCTTransaction Type RMVCTCHAR3Assigned to domainRMVCT
FKBERFunctional Area FKBERCHAR16Assigned to domainFKBERFBE
KOKRSControlling Area KOKRSCHAR4Assigned to domainCACCDCAC
KOSTLCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
LSTARActivity Type LSTARCHAR6Assigned to domainLSTARLARLART_EMPTY
AUFNROrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
AFPOSOrder Item Number CO_POSNRNUMC4CO_POSNR
BEMOTAccounting Indicator BEMOTCHAR2Assigned to domainBEMOT
KSTRGCost Object KSTRGCHAR12Assigned to domainKSTRGKTR
PRZNRBusiness Process CO_PRZNRCHAR12Assigned to domainALPHACO_PRZNRKWP
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
PPRCTRPartner Profit Center PPRCTRCHAR10Assigned to domainALPHAPRCTRPPC
PS_PSP_PNRWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8Assigned to domainKONPRPS_POSNR
NPLNRNetwork Number for Account Assignment NPLNRCHAR12Assigned to domainALPHAAUFNRNET
VORNROperation/Activity Number VORNRCHAR4NUMCVVORNRVGN
ANLN1Main Asset Number BF_ANLN1CHAR12ALPHABF_ANLN1AN1
ANLN2Asset Subnumber BF_ANLN2CHAR4ALPHABF_ANLN2AN2
BZDATReference Date BF_BZDATDATS8DATUM
ANBWAAsset Transaction Type BF_ANBWACHAR3CHAR3SSH_TABW
WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
BWTARValuation Type BWTAR_DCHAR10Assigned to domainBWTARBWT
BWKEYValuation Area BWKEYCHAR4Assigned to domainBWKEYBWK
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
HRKFTOrigin Group as Subdivision of Cost Element HRKFTCHAR4Assigned to domainHRKFT
HKMATMaterial-related origin HKMATCHAR1HKMAT
KDAUFSales Order Number KDAUFCHAR10Assigned to domainALPHAVBELNAUN
KDEINDelivery Schedule for Sales Order KDEINNUMC4NUM04
KDPOSItem Number in Sales Order KDPOSNUMC6NUM06KPO
VNAMEJoint Venture JV_NAMECHAR6Assigned to domainALPHAJV_NAMEJVV
RECIDRecovery Indicator JV_RECINDCHAR2Assigned to domainALPHAJV_RECIND
RECID_MANIndicator: Recovery Indicator Set Manually. JV_RECID_MCHAR1XFELD
EGRUPEquity group JV_EGROUPCHAR3Assigned to domainALPHAJV_EGROUPGJE
ETYPEEquity type JV_ETYPECHAR3Assigned to domainALPHAJV_ETYPE
VPTNRPartner account number JV_PARTCHAR10Assigned to domainALPHAKUNNR
CONDIJoint Venture Indicator (Condition Key) JV_CONDCODCHAR2Assigned to domainALPHAJV_CONDCOD
CRPCALFlag CRP Calculation: Yes or NO JV_CRPCALCHAR1XFELD
FIKRSFinancial Management Area FIKRSCHAR4Assigned to domainFIKRSFIK
FISTLFunds Center FISTLCHAR16Assigned to domainFISTLFIS
FIPOSCommitment Item FIPOSCHAR14Assigned to domainFIPOSFIP
FIPEXCommitment Item FM_FIPEXCHAR24Assigned to domainFM_FIPEXFPS
GEBERFund BP_GEBERCHAR10Assigned to domainBP_GEBERFIC
KBLNRDocument Number for Earmarked Funds KBLNR_FICHAR10Assigned to domainALPHAKBLNRKBL
KBLPOSEarmarked Funds: Document Item KBLPOSNUMC3Assigned to domainKBLPOSKBP
ERLKZUsed earmarked funds set to 'Complete' REFSETERLKCHAR1CHAR1_X
PERNRPersonnel Number PERNR_DNUMC8PERNRPER
PAOBJNRProfitability Segment Number (CO-PA) RKEOBJNRNUMC10RKEOBJNR
IMKEYInternal Key for Real Estate Object IMKEYCHAR8IMKEY
KONTTAccount Assignment Category for Industry Solution KONTT_FICHAR2KONTT_FI
KONTLAcct assignment string for industry-specific acct assignmnts KONTL_FICHAR50CHAR50
SMIVELease-Out Number SMIVECHAR13ALPHAVVSMIVEMIVMRTA
GRANT_NBRGrant GM_GRANT_NBRCHAR20ALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERIC
DABRZReference Date for Settlement DABRBEZDATS8DDAT
BUDGET_PDFM: Budget Period FM_BUDGET_PERIODCHAR10Assigned to domainFM_BUDGET_PERIODBUDPER
TAXJURCODETax Jurisdiction TXJCDCHAR15TTXJTXJCDTXJ
ALLOC_NMBRAssignment Number DZUONRCHAR18ZUONR
BRANCHAccount Number of the Branch FILKDCHAR10ALPHAMAXKK
P_FWBASTax Base Amount in Document Currency FWBASCURR13(2) WERT7
SEGMENTSegment for Segmental Reporting FB_SEGMENTCHAR10FAGL_SEGMALPHAFB_SEGMENT
PSEGMENTPartner Segment for Segmental Reporting FB_PSEGMENTCHAR10FAGL_SEGMALPHAFB_SEGMENT
STCEGVAT Registration Number STCEGCHAR20STCEG
UMSKZSpecial G/L Indicator UMSKZCHAR1Assigned to domainUMSKZ

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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!