SAP Table TCJ_POSITIONS
Cash Journal Document Items
TCJ_POSITIONS (Cash Journal Document Items) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link TCJ_POSITIONS to other SAP tables.
TCJ_POSITIONS table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||||
|
COMP_CODE
Company Code
|
BUKRS | T001 |
CHAR
|
4 | 0 | |||||||||||||||
|
CAJO_NUMBER
Cash Journal Number
|
CJNR | TCJ_C_JOURNALS |
CHAR
|
4 | 0 | |||||||||||||||
|
FISC_YEAR
Fiscal Year
|
GJAHR |
NUMC
|
4 | 0 | ||||||||||||||||
|
POSTING_NUMBER
Cash Journal Document Number
|
CJBELNR | TCJ_DOCUMENTS |
CHAR
|
10 | 0 | |||||||||||||||
|
POSITION_NUMBER
Number of Line Item within Cash Journal Document
|
CJBUZEI |
NUMC
|
3 | 0 | ||||||||||||||||
|
POSITION_TYPE
Cash Journal Item Type
|
CJPOSTYPE |
CHAR
|
2 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
TRANSACT_NUMBER
Number of Cash Journal Business Transaction
|
CJTRANSNUMB | TCJ_TRANSACTIONS |
CHAR
|
4 | 0 | |||||||||||||||
|
TRANSACT_TYPE
Business Transaction Type
|
CJTRANSTYP |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
POSTING_DATE
Posting Date in the Document
|
BUDAT |
DATS
|
8 | 0 | ||||||||||||||||
|
CURRENCY
Currency Key
|
WAERS | TCURC |
CUKY
|
5 | 0 | |||||||||||||||
|
P_RECEIPTS
Cash Journal Amount Field with +/- Sign
|
CJAMOUNT |
CURR
|
15 | 2 | ||||||||||||||||
|
P_PAYMENTS
Cash Journal Amount Field with +/- Sign
|
CJAMOUNT |
CURR
|
15 | 2 | ||||||||||||||||
|
P_NET_AMOUNT
Cash Journal Document Net Amount - Document Currency
|
CJNET_AMOUNT |
CURR
|
13 | 2 | ||||||||||||||||
|
P_NET_PAYMENT_WT
Net Payment Amount (Withholding Tax Deducted)
|
CJNET_PAYMENT_WT |
CURR
|
15 | 2 | ||||||||||||||||
|
P_TAX_AMOUNT
Tax amount in document currency
|
WMWST |
CURR
|
13 | 2 | ||||||||||||||||
|
TAX_CODE
Tax on sales/purchases code
|
MWSKZ | T007A |
CHAR
|
2 | 0 | |||||||||||||||
|
GL_ACCOUNT
General Ledger Account
|
HKONT | SKA1 |
CHAR
|
10 | 0 | |||||||||||||||
|
TAX_PERCENT
Tax rate
|
MSATZ_F05L |
DEC
|
7 | 3 | ||||||||||||||||
|
POSITION_TEXT
Cash Journal Line Item Text
|
CJPOSTEXT |
CHAR
|
50 | 0 | ||||||||||||||||
|
VENDOR_NO
Account Number of Vendor or Creditor
|
LIFNR | LFA1 |
CHAR
|
10 | 0 | |||||||||||||||
|
CUSTOMER
Customer Number
|
KUNNR | KNA1 |
CHAR
|
10 | 0 | |||||||||||||||
|
GSBER
Business Area
|
GSBER |
CHAR
|
4 | 0 | ||||||||||||||||
|
PARGB
Trading partner's business area
|
PARGB |
CHAR
|
4 | 0 | ||||||||||||||||
|
VBUND
Company ID of trading partner
|
RASSC |
CHAR
|
6 | 0 | ||||||||||||||||
|
RMVCT
Transaction Type
|
RMVCT |
CHAR
|
3 | 0 | ||||||||||||||||
|
FKBER
Functional Area
|
FKBER |
CHAR
|
16 | 0 | ||||||||||||||||
|
KOKRS
Controlling Area
|
KOKRS |
CHAR
|
4 | 0 | ||||||||||||||||
|
KOSTL
Cost Center
|
KOSTL |
CHAR
|
10 | 0 | ||||||||||||||||
|
LSTAR
Activity Type
|
LSTAR |
CHAR
|
6 | 0 | ||||||||||||||||
|
AUFNR
Order Number
|
AUFNR |
CHAR
|
12 | 0 | ||||||||||||||||
|
AFPOS
Order Item Number
|
CO_POSNR |
NUMC
|
4 | 0 | ||||||||||||||||
|
BEMOT
Accounting Indicator
|
BEMOT |
CHAR
|
2 | 0 | ||||||||||||||||
|
KSTRG
Cost Object
|
KSTRG |
CHAR
|
12 | 0 | ||||||||||||||||
|
PRZNR
Business Process
|
CO_PRZNR |
CHAR
|
12 | 0 | ||||||||||||||||
|
PRCTR
Profit Center
|
PRCTR |
CHAR
|
10 | 0 | ||||||||||||||||
|
PPRCTR
Partner Profit Center
|
PPRCTR |
CHAR
|
10 | 0 | ||||||||||||||||
|
PS_PSP_PNR
Work Breakdown Structure Element (WBS Element)
|
PS_PSP_PNR |
NUMC
|
8 | 0 | ||||||||||||||||
|
NPLNR
Network Number for Account Assignment
|
NPLNR |
CHAR
|
12 | 0 | ||||||||||||||||
|
VORNR
Operation/Activity Number
|
VORNR |
CHAR
|
4 | 0 | ||||||||||||||||
|
ANLN1
Main Asset Number
|
BF_ANLN1 |
CHAR
|
12 | 0 | ||||||||||||||||
|
ANLN2
Asset Subnumber
|
BF_ANLN2 |
CHAR
|
4 | 0 | ||||||||||||||||
|
BZDAT
Reference Date
|
BF_BZDAT |
DATS
|
8 | 0 | ||||||||||||||||
|
ANBWA
Asset Transaction Type
|
BF_ANBWA |
CHAR
|
3 | 0 | ||||||||||||||||
|
WERKS
Plant
|
WERKS_D |
CHAR
|
4 | 0 | ||||||||||||||||
|
BWTAR
Valuation Type
|
BWTAR_D |
CHAR
|
10 | 0 | ||||||||||||||||
|
BWKEY
Valuation Area
|
BWKEY |
CHAR
|
4 | 0 | ||||||||||||||||
|
MATNR
Material Number
|
MATNR |
CHAR
|
18 | 0 | ||||||||||||||||
|
HRKFT
Origin Group as Subdivision of Cost Element
|
HRKFT |
CHAR
|
4 | 0 | ||||||||||||||||
|
HKMAT
Material-related origin
|
HKMAT |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
KDAUF
Sales Order Number
|
KDAUF |
CHAR
|
10 | 0 | ||||||||||||||||
|
KDEIN
Delivery Schedule for Sales Order
|
KDEIN |
NUMC
|
4 | 0 | ||||||||||||||||
|
KDPOS
Item Number in Sales Order
|
KDPOS |
NUMC
|
6 | 0 | ||||||||||||||||
|
VNAME
Joint Venture
|
JV_NAME |
CHAR
|
6 | 0 | ||||||||||||||||
|
RECID
Recovery Indicator
|
JV_RECIND |
CHAR
|
2 | 0 | ||||||||||||||||
|
RECID_MAN
Indicator: Recovery Indicator Set Manually.
|
JV_RECID_M |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
EGRUP
Equity group
|
JV_EGROUP |
CHAR
|
3 | 0 | ||||||||||||||||
|
ETYPE
Equity type
|
JV_ETYPE |
CHAR
|
3 | 0 | ||||||||||||||||
|
VPTNR
Partner account number
|
JV_PART |
CHAR
|
10 | 0 | ||||||||||||||||
|
CONDI
Joint Venture Indicator (Condition Key)
|
JV_CONDCOD |
CHAR
|
2 | 0 | ||||||||||||||||
|
CRPCAL
Flag CRP Calculation: Yes or NO
|
JV_CRPCAL |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
FIKRS
Financial Management Area
|
FIKRS |
CHAR
|
4 | 0 | ||||||||||||||||
|
FISTL
Funds Center
|
FISTL |
CHAR
|
16 | 0 | ||||||||||||||||
|
FIPOS
Commitment Item
|
FIPOS |
CHAR
|
14 | 0 | ||||||||||||||||
|
FIPEX
Commitment Item
|
FM_FIPEX |
CHAR
|
24 | 0 | ||||||||||||||||
|
GEBER
Fund
|
BP_GEBER |
CHAR
|
10 | 0 | ||||||||||||||||
|
KBLNR
Document Number for Earmarked Funds
|
KBLNR_FI |
CHAR
|
10 | 0 | ||||||||||||||||
|
KBLPOS
Earmarked Funds: Document Item
|
KBLPOS |
NUMC
|
3 | 0 | ||||||||||||||||
|
ERLKZ
Used earmarked funds set to "Complete"
|
REFSETERLK |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
PERNR
Personnel Number
|
PERNR_D |
NUMC
|
8 | 0 | ||||||||||||||||
|
PAOBJNR
Profitability Segment Number (CO-PA)
|
RKEOBJNR |
NUMC
|
10 | 0 | ||||||||||||||||
|
IMKEY
Internal Key for Real Estate Object
|
IMKEY |
CHAR
|
8 | 0 | ||||||||||||||||
|
KONTT
Account Assignment Category for Industry Solution
|
KONTT_FI |
CHAR
|
2 | 0 | ||||||||||||||||
|
KONTL
Acct assignment string for industry-specific acct assignmnts
|
KONTL_FI |
CHAR
|
50 | 0 | ||||||||||||||||
|
SMIVE
Lease-Out Number
|
SMIVE |
CHAR
|
13 | 0 | ||||||||||||||||
|
GRANT_NBR
Grant
|
GM_GRANT_NBR |
CHAR
|
20 | 0 | ||||||||||||||||
|
DABRZ
Reference Date for Settlement
|
DABRBEZ |
DATS
|
8 | 0 | ||||||||||||||||
|
BUDGET_PD
FM: Budget Period
|
FM_BUDGET_PERIOD |
CHAR
|
10 | 0 | ||||||||||||||||
|
TAXJURCODE
Tax Jurisdiction
|
TXJCD | TTXJ |
CHAR
|
15 | 0 | |||||||||||||||
|
ALLOC_NMBR
Assignment Number
|
DZUONR |
CHAR
|
18 | 0 | ||||||||||||||||
|
BRANCH
Account Number of the Branch
|
FILKD |
CHAR
|
10 | 0 | ||||||||||||||||
|
P_FWBAS
Tax Base Amount in Document Currency
|
FWBAS |
CURR
|
13 | 2 | ||||||||||||||||
|
SEGMENT
Segment for Segmental Reporting
|
FB_SEGMENT | FAGL_SEGM |
CHAR
|
10 | 0 | |||||||||||||||
|
PSEGMENT
Partner Segment for Segmental Reporting
|
FB_PSEGMENT | FAGL_SEGM |
CHAR
|
10 | 0 | |||||||||||||||
|
STCEG
VAT Registration Number
|
STCEG |
CHAR
|
20 | 0 | ||||||||||||||||
|
UMSKZ
Special G/L Indicator
|
UMSKZ |
CHAR
|
1 | 0 | ||||||||||||||||
TCJ_POSITIONS foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| TCJ_POSITIONS | CAJO_NUMBER | TCJ_POSITIONS | CAJO_NUMBER |
TCJ_C_JOURNALS
Cash Journals
|
CAJO_NUMBER |
| TCJ_POSITIONS | CAJO_NUMBER | * |
TCJ_C_JOURNALS
Cash Journals
|
MANDT | |
| TCJ_POSITIONS | CAJO_NUMBER | * |
TCJ_C_JOURNALS
Cash Journals
|
COMP_CODE | |
| TCJ_POSITIONS | COMP_CODE | * |
T001
Company Codes
|
MANDT | |
| TCJ_POSITIONS | COMP_CODE | TCJ_POSITIONS | COMP_CODE |
T001
Company Codes
|
BUKRS |
| TCJ_POSITIONS | CURRENCY | TCJ_POSITIONS | CURRENCY |
TCURC
Currency Codes
|
WAERS |
| TCJ_POSITIONS | CURRENCY | TCJ_POSITIONS | MANDT |
TCURC
Currency Codes
|
MANDT |
| TCJ_POSITIONS | CUSTOMER | TCJ_POSITIONS | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| TCJ_POSITIONS | CUSTOMER | TCJ_POSITIONS | CUSTOMER |
KNA1
General Data in Customer Master
|
KUNNR |
| TCJ_POSITIONS | GL_ACCOUNT | * |
SKA1
G/L Account Master (Chart of Accounts)
|
MANDT | |
| TCJ_POSITIONS | GL_ACCOUNT | * |
SKA1
G/L Account Master (Chart of Accounts)
|
KTOPL | |
| TCJ_POSITIONS | GL_ACCOUNT | TCJ_POSITIONS | GL_ACCOUNT |
SKA1
G/L Account Master (Chart of Accounts)
|
SAKNR |
| TCJ_POSITIONS | MANDT | TCJ_POSITIONS | MANDT |
T000
Clients
|
MANDT |
| TCJ_POSITIONS | POSTING_NUMBER | TCJ_POSITIONS | POSTING_NUMBER |
TCJ_DOCUMENTS
Cash Journal Documents (Header Data)
|
POSTING_NUMBER |
| TCJ_POSITIONS | POSTING_NUMBER | TCJ_POSITIONS | MANDT |
TCJ_DOCUMENTS
Cash Journal Documents (Header Data)
|
MANDT |
| TCJ_POSITIONS | POSTING_NUMBER | TCJ_POSITIONS | COMP_CODE |
TCJ_DOCUMENTS
Cash Journal Documents (Header Data)
|
COMP_CODE |
| TCJ_POSITIONS | POSTING_NUMBER | TCJ_POSITIONS | CAJO_NUMBER |
TCJ_DOCUMENTS
Cash Journal Documents (Header Data)
|
CAJO_NUMBER |
| TCJ_POSITIONS | POSTING_NUMBER | TCJ_POSITIONS | FISC_YEAR |
TCJ_DOCUMENTS
Cash Journal Documents (Header Data)
|
FISC_YEAR |
| TCJ_POSITIONS | PSEGMENT | TCJ_POSITIONS | MANDT |
FAGL_SEGM
Master Data for Segments
|
MANDT |
| TCJ_POSITIONS | PSEGMENT | TCJ_POSITIONS | PSEGMENT |
FAGL_SEGM
Master Data for Segments
|
SEGMENT |
| TCJ_POSITIONS | SEGMENT | TCJ_POSITIONS | MANDT |
FAGL_SEGM
Master Data for Segments
|
MANDT |
| TCJ_POSITIONS | SEGMENT | TCJ_POSITIONS | SEGMENT |
FAGL_SEGM
Master Data for Segments
|
SEGMENT |
| TCJ_POSITIONS | TAXJURCODE | TCJ_POSITIONS | MANDT |
TTXJ
Check Table for Tax Jurisdiction
|
MANDT |
| TCJ_POSITIONS | TAXJURCODE | T005 | KALSM |
TTXJ
Check Table for Tax Jurisdiction
|
KALSM |
| TCJ_POSITIONS | TAXJURCODE | TCJ_POSITIONS | TAXJURCODE |
TTXJ
Check Table for Tax Jurisdiction
|
TXJCD |
| TCJ_POSITIONS | TAX_CODE | * |
T007A
Tax Keys
|
MANDT | |
| TCJ_POSITIONS | TAX_CODE | * |
T007A
Tax Keys
|
KALSM | |
| TCJ_POSITIONS | TAX_CODE | TCJ_POSITIONS | TAX_CODE |
T007A
Tax Keys
|
MWSKZ |
| TCJ_POSITIONS | TRANSACT_NUMBER | * |
TCJ_TRANSACTIONS
Cash Journal Business Transactions
|
MANDT | |
| TCJ_POSITIONS | TRANSACT_NUMBER | * |
TCJ_TRANSACTIONS
Cash Journal Business Transactions
|
COMP_CODE | |
| TCJ_POSITIONS | TRANSACT_NUMBER | TCJ_POSITIONS | TRANSACT_NUMBER |
TCJ_TRANSACTIONS
Cash Journal Business Transactions
|
TRANSACT_NUMBER |
| TCJ_POSITIONS | VENDOR_NO | TCJ_POSITIONS | MANDT |
LFA1
Vendor Master (General Section)
|
MANDT |
| TCJ_POSITIONS | VENDOR_NO | TCJ_POSITIONS | VENDOR_NO |
LFA1
Vendor Master (General Section)
|
LIFNR |
| TCJ_POSITIONS | ZZREGION | SYST | MANDT |
ZREG
User Defined Regions
|
MANDT |
| TCJ_POSITIONS | ZZREGION | TCJ_POSITIONS | ZZREGION |
ZREG
User Defined Regions
|
ZZREGION |
| TCJ_POSITIONS | ZZSPREG | SYST | MANDT |
ZZSPREG
Check table for ZZSPREG = Special Region
|
MANDT |
| TCJ_POSITIONS | ZZSPREG | TCJ_POSITIONS | ZZSPREG |
ZZSPREG
Check table for ZZSPREG = Special Region
|
ZZSPREG |
| TCJ_POSITIONS | ZZSTATE | TCJ_POSITIONS | ZZSTATE |
T005S
Taxes: Region (Province) Key
|
BLAND |
| TCJ_POSITIONS | ZZSTATE | SYST | MANDT |
T005S
Taxes: Region (Province) Key
|
MANDT |
| TCJ_POSITIONS | ZZSTATE | * |
T005S
Taxes: Region (Province) Key
|
LAND1 | |
| TCJ_POSITIONS | ZZUSERFLD1 | SYST | MANDT |
ZFU1
Check Table for User Field 1
|
MANDT |
| TCJ_POSITIONS | ZZUSERFLD1 | TCJ_POSITIONS | ZZUSERFLD1 |
ZFU1
Check Table for User Field 1
|
ZZUSERFLD1 |