SAP TABLES | Financial Accounting | General Ledger Accounting | G/L Account Posting(FI-GL-GL-AP) SAP FI

TCJ_POSITIONS SAP Cash Journal Document Items Table and data







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.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP TCJ_POSITIONS Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories


SAP TCJ_POSITIONS Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3 T000Client
COMP_CODEBUKRSCHAR4 T001Company Code
CAJO_NUMBERCJNRCHAR4 TCJ_C_JOURNALSCash Journal Number
FISC_YEARGJAHRNUMC4 Fiscal YearGJAHR
POSTING_NUMBERCJBELNRCHAR10 TCJ_DOCUMENTSCash Journal Document NumberALPHA
POSITION_NUMBERCJBUZEINUMC3 Number of Line Item within Cash Journal Document
POSITION_TYPECJPOSTYPECHAR2 Cash Journal Item Type
TRANSACT_NUMBERCJTRANSNUMBCHAR4 TCJ_TRANSACTIONSNumber of Cash Journal Business Transaction
TRANSACT_TYPECJTRANSTYPCHAR1 Business Transaction Type
POSTING_DATEBUDATDATS8 Posting Date in the Document
CURRENCYWAERSCUKY5 TCURCCurrency Key
P_RECEIPTSCJAMOUNTCURR15(2) Cash Journal Amount Field with +/- Sign
P_PAYMENTSCJAMOUNTCURR15(2) Cash Journal Amount Field with +/- Sign
P_NET_AMOUNTCJNET_AMOUNTCURR13(2) Cash Journal Document Net Amount - Document Currency
P_NET_PAYMENT_WTCJNET_PAYMENT_WTCURR15(2) Net Payment Amount (Withholding Tax Deducted)
P_TAX_AMOUNTWMWSTCURR13(2) Tax amount in document currency
TAX_CODEMWSKZCHAR2 T007ATax on sales/purchases code
GL_ACCOUNTHKONTCHAR10 SKA1General Ledger AccountALPHA
TAX_PERCENTMSATZ_F05LDEC7(3) Tax rate
POSITION_TEXTCJPOSTEXTCHAR50 Cash Journal Line Item Text
VENDOR_NOLIFNRCHAR10 LFA1Account Number of Vendor or CreditorALPHA
CUSTOMERKUNNRCHAR10 KNA1Customer NumberALPHA
.INCLUDECOBL_DB_INCLUDE Include with Additional Account Assignments for DB Tables
GSBERGSBERCHAR4
*
Business Area
PARGBPARGBCHAR4
*
Trading partner's business area
VBUNDRASSCCHAR6
*
Company ID of trading partnerALPHA
RMVCTRMVCTCHAR3
*
Transaction Type
FKBERFKBERCHAR16
*
Functional Area
KOKRSKOKRSCHAR4
*
Controlling Area
KOSTLKOSTLCHAR10
*
Cost CenterALPHA
LSTARLSTARCHAR6
*
Activity Type
AUFNRAUFNRCHAR12
*
Order NumberALPHA
AFPOSCO_POSNRNUMC4 Order Item Number
BEMOTBEMOTCHAR2
*
Accounting Indicator
KSTRGKSTRGCHAR12
*
Cost Object
PRZNRCO_PRZNRCHAR12
*
Business ProcessALPHA
PRCTRPRCTRCHAR10
*
Profit CenterALPHA
PPRCTRPPRCTRCHAR10
*
Partner Profit CenterALPHA
PS_PSP_PNRPS_PSP_PNRNUMC8
*
Work Breakdown Structure Element (WBS Element)ABPSP


NPLNRNPLNRCHAR12
*
Network Number for Account AssignmentALPHA
VORNRVORNRCHAR4 Operation/Activity NumberNUMCV
ANLN1BF_ANLN1CHAR12 Main Asset NumberALPHA
ANLN2BF_ANLN2CHAR4 Asset SubnumberALPHA
BZDATBF_BZDATDATS8 Reference Date
ANBWABF_ANBWACHAR3 Asset Transaction Type
WERKSWERKS_DCHAR4
*
Plant
BWTARBWTAR_DCHAR10
*
Valuation Type
BWKEYBWKEYCHAR4
*
Valuation Area
MATNRMATNRCHAR18
*
Material NumberMATN1
HRKFTHRKFTCHAR4
*
Origin Group as Subdivision of Cost Element
HKMATHKMATCHAR1 Material-related origin
KDAUFKDAUFCHAR10
*
Sales Order NumberALPHA
KDEINKDEINNUMC4 Delivery Schedule for Sales Order
KDPOSKDPOSNUMC6 Item Number in Sales Order
VNAMEJV_NAMECHAR6
*
Joint VentureALPHA
RECIDJV_RECINDCHAR2
*
Recovery IndicatorALPHA
RECID_MANJV_RECID_MCHAR1 Indicator: Recovery Indicator Set Manually.
EGRUPJV_EGROUPCHAR3
*
Equity groupALPHA
ETYPEJV_ETYPECHAR3
*
Equity typeALPHA
VPTNRJV_PARTCHAR10
*
Partner account numberALPHA
CONDIJV_CONDCODCHAR2
*
Joint Venture Indicator (Condition Key)ALPHA
CRPCALJV_CRPCALCHAR1 Flag CRP Calculation: Yes or NO
FIKRSFIKRSCHAR4
*
Financial Management Area
FISTLFISTLCHAR16
*
Funds Center
FIPOSFIPOSCHAR14
*
Commitment ItemFMCIS
FIPEXFM_FIPEXCHAR24
*
Commitment ItemFMCIL
GEBERBP_GEBERCHAR10
*
Fund
KBLNRKBLNR_FICHAR10
*
Document Number for Earmarked FundsALPHA
KBLPOSKBLPOSNUMC3
*
Earmarked Funds: Document Item
ERLKZREFSETERLKCHAR1 Used earmarked funds set to "Complete"
PERNRPERNR_DNUMC8 Personnel Number
PAOBJNRRKEOBJNRNUMC10 Profitability Segment Number (CO-PA)
IMKEYIMKEYCHAR8 Internal Key for Real Estate ObjectIMKEY
KONTTKONTT_FICHAR2 Account Assignment Category for Industry Solution
KONTLKONTL_FICHAR50 Acct assignment string for industry-specific acct assignmnts
SMIVESMIVECHAR13 Lease-Out NumberALPHA
GRANT_NBRGM_GRANT_NBRCHAR20 GrantALPHA
DABRZDABRBEZDATS8 Reference Date for Settlement


BUDGET_PDFM_BUDGET_PERIODCHAR10
*
FM: Budget Period
TAXJURCODETXJCDCHAR15 TTXJTax Jurisdiction
ALLOC_NMBRDZUONRCHAR18 Assignment Number
BRANCHFILKDCHAR10 Account Number of the BranchALPHA
P_FWBASFWBASCURR13(2) Tax Base Amount in Document Currency
SEGMENTFB_SEGMENTCHAR10 FAGL_SEGMSegment for Segmental ReportingALPHA
PSEGMENTFB_PSEGMENTCHAR10 FAGL_SEGMPartner Segment for Segmental ReportingALPHA
STCEGSTCEGCHAR20 VAT Registration Number
UMSKZUMSKZCHAR1
*
Special G/L Indicator



Key field
Non-key field