SAP ABAP Table TCJ_POSITIONS (Cash Journal Document Items)
Hierarchy
SAP_FIN (Software Component) SAP_FIN
   FI-GL-GL-AP (Application Component) G/L Account Posting
     CAJO (Package) Cash Journal Development
Basic Data
Table Category TRANSP    Transparent table 
Transparent table TCJ_POSITIONS   Table Relationship Diagram
Short Description Cash Journal Document Items    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client T000
2 COMP_CODE BUKRS BUKRS CHAR 4   0   Company Code T001
3 CAJO_NUMBER CJNR CJNR CHAR 4   0   Cash Journal Number TCJ_C_JOURNALS
4 FISC_YEAR GJAHR GJAHR NUMC 4   0   Fiscal Year  
5 POSTING_NUMBER CJBELNR BELNR CHAR 10   0   Cash Journal Document Number TCJ_DOCUMENTS
6 POSITION_NUMBER CJBUZEI BUZEI NUMC 3   0   Number of Line Item within Cash Journal Document  
7 POSITION_TYPE CJPOSTYPE CJPOSTYPE CHAR 2   0   Cash Journal Item Type  
8 TRANSACT_NUMBER CJTRANSNUMB CHAR4 CHAR 4   0   Number of Cash Journal Business Transaction TCJ_TRANSACTIONS
9 TRANSACT_TYPE CJTRANSTYP CJTTYP CHAR 1   0   Business Transaction Type  
10 POSTING_DATE BUDAT DATUM DATS 8   0   Posting Date in the Document  
11 CURRENCY WAERS WAERS CUKY 5   0   Currency Key TCURC
12 P_RECEIPTS CJAMOUNT CJAMT CURR 15   2   Cash Journal Amount Field with +/- Sign  
13 P_PAYMENTS CJAMOUNT CJAMT CURR 15   2   Cash Journal Amount Field with +/- Sign  
14 P_NET_AMOUNT CJNET_AMOUNT WERTV7 CURR 13   2   Cash Journal Document Net Amount - Document Currency  
15 P_NET_PAYMENT_WT CJNET_PAYMENT_WT CJAMT CURR 15   2   Net Payment Amount (Withholding Tax Deducted)  
16 P_TAX_AMOUNT WMWST WERT7 CURR 13   2   Tax amount in document currency  
17 TAX_CODE MWSKZ MWSKZ CHAR 2   0   Tax on sales/purchases code T007A
18 GL_ACCOUNT HKONT SAKNR CHAR 10   0   General Ledger Account SKA1
19 TAX_PERCENT MSATZ_F05L PRZ43V DEC 7   3   Tax rate  
20 POSITION_TEXT CJPOSTEXT TEXT50 CHAR 50   0   Cash Journal Line Item Text  
21 VENDOR_NO LIFNR LIFNR CHAR 10   0   Account Number of Vendor or Creditor LFA1
22 CUSTOMER KUNNR KUNNR CHAR 10   0   Customer Number KNA1
23 .INCLUDE       0   0   Include with Additional Account Assignments for DB Tables  
24 GSBER GSBER GSBER CHAR 4   0   Business Area *
25 PARGB PARGB GSBER CHAR 4   0   Trading partner's business area *
26 VBUND RASSC RCOMP CHAR 6   0   Company ID of trading partner *
27 RMVCT RMVCT RMVCT CHAR 3   0   Transaction type *
28 FKBER FKBER FKBER CHAR 16   0   Functional Area *
29 KOKRS KOKRS CACCD CHAR 4   0   Controlling Area *
30 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center *
31 LSTAR LSTAR LSTAR CHAR 6   0   Activity Type *
32 AUFNR AUFNR AUFNR CHAR 12   0   Order Number *
33 AFPOS CO_POSNR CO_POSNR NUMC 4   0   Order item number  
34 BEMOT BEMOT BEMOT CHAR 2   0   Accounting Indicator *
35 KSTRG KSTRG KSTRG CHAR 12   0   Cost Object *
36 PRZNR CO_PRZNR CO_PRZNR CHAR 12   0   Business Process *
37 PRCTR PRCTR PRCTR CHAR 10   0   Profit Center *
38 PPRCTR PPRCTR PRCTR CHAR 10   0   Partner Profit Center *
39 PS_PSP_PNR PS_PSP_PNR PS_POSNR NUMC 8   0   Work Breakdown Structure Element (WBS Element) *
40 NPLNR NPLNR AUFNR CHAR 12   0   Network Number for Account Assignment *
41 VORNR VORNR VORNR CHAR 4   0   Operation/Activity Number  
42 ANLN1 BF_ANLN1 BF_ANLN1 CHAR 12   0   Main Asset Number  
43 ANLN2 BF_ANLN2 BF_ANLN2 CHAR 4   0   Asset Subnumber  
44 BZDAT BF_BZDAT DATUM DATS 8   0   Reference date  
45 ANBWA BF_ANBWA CHAR3 CHAR 3   0   Asset transaction type  
46 WERKS WERKS_D WERKS CHAR 4   0   Plant *
47 BWTAR BWTAR_D BWTAR CHAR 10   0   Valuation type *
48 BWKEY BWKEY BWKEY CHAR 4   0   Valuation area *
49 MATNR MATNR MATNR CHAR 18   0   Material Number *
50 HRKFT HRKFT HRKFT CHAR 4   0   Origin Group as Subdivision of Cost Element *
51 HKMAT HKMAT HKMAT CHAR 1   0   Material-related origin  
52 KDAUF KDAUF VBELN CHAR 10   0   Sales Order Number *
53 KDEIN KDEIN NUM04 NUMC 4   0   Delivery schedule for sales order  
54 KDPOS KDPOS NUM06 NUMC 6   0   Item number in Sales Order  
55 VNAME JV_NAME JV_NAME CHAR 6   0   Joint venture *
56 RECID JV_RECIND JV_RECIND CHAR 2   0   Recovery Indicator *
57 RECID_MAN JV_RECID_M XFELD CHAR 1   0   Indicator: Recovery Indicator Set Manually.  
58 EGRUP JV_EGROUP JV_EGROUP CHAR 3   0   Equity group *
59 ETYPE JV_ETYPE JV_ETYPE CHAR 3   0   Equity type *
60 VPTNR JV_PART KUNNR CHAR 10   0   Partner account number *
61 CONDI JV_CONDCOD JV_CONDCOD CHAR 2   0   Joint Venture Indicator (Condition Key) *
62 CRPCAL JV_CRPCAL XFELD CHAR 1   0   Flag CRP Calculation: Yes or NO  
63 FIKRS FIKRS FIKRS CHAR 4   0   Financial Management Area *
64 FISTL FISTL FISTL CHAR 16   0   Funds Center *
65 FIPOS FIPOS FIPOS CHAR 14   0   Commitment Item *
66 FIPEX FM_FIPEX FM_FIPEX CHAR 24   0   Commitment item *
67 GEBER BP_GEBER BP_GEBER CHAR 10   0   Fund *
68 KBLNR KBLNR_FI KBLNR CHAR 10   0   Document number for earmarked funds *
69 KBLPOS KBLPOS KBLPOS NUMC 3   0   Earmarked Funds: Document Item *
70 ERLKZ REFSETERLK CHAR1_X CHAR 1   0   Used earmarked funds set to "Complete"  
71 PERNR PERNR_D PERNR NUMC 8   0   Personnel Number  
72 PAOBJNR RKEOBJNR RKEOBJNR NUMC 10   0   Profitability Segment Number (CO-PA)  
73 IMKEY IMKEY IMKEY CHAR 8   0   Internal Key for Real Estate Object  
74 KONTT KONTT_FI KONTT_FI CHAR 2   0   Account Assignment Category for Industry Solution  
75 KONTL KONTL_FI CHAR50 CHAR 50   0   Acct assignment string for industry-specific acct assignmnts  
76 .INCLUDE       0   0    
77 SMIVE SMIVE VVSMIVE CHAR 13   0   Lease-Out Number  
78 GRANT_NBR GM_GRANT_NBR GM_GRANT_NBR CHAR 20   0   Grant  
79 DABRZ DABRBEZ DDAT DATS 8   0   Reference date for settlement  
80 BUDGET_PD FM_BUDGET_PERIOD FM_BUDGET_PERIOD CHAR 10   0   FM: Budget Period *
81 TAXJURCODE TXJCD TXJCD CHAR 15   0   Tax Jurisdiction TTXJ
82 ALLOC_NMBR DZUONR ZUONR CHAR 18   0   Assignment number  
83 BRANCH FILKD MAXKK CHAR 10   0   Account Number of the Branch  
84 P_FWBAS FWBAS WERT7 CURR 13   2   Tax Base Amount in Document Currency  
85 SEGMENT FB_SEGMENT FB_SEGMENT CHAR 10   0   Segment for Segmental Reporting FAGL_SEGM
86 PSEGMENT FB_PSEGMENT FB_SEGMENT CHAR 10   0   Partner Segment for Segmental Reporting FAGL_SEGM
87 STCEG STCEG STCEG CHAR 20   0   VAT Registration Number  
88 UMSKZ UMSKZ UMSKZ CHAR 1   0   Special G/L Indicator *
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 TCJ_POSITIONS CAJO_NUMBER TCJ_C_JOURNALS CAJO_NUMBER    
2 TCJ_POSITIONS COMP_CODE T001 BUKRS    
3 TCJ_POSITIONS CURRENCY TCURC WAERS    
4 TCJ_POSITIONS CUSTOMER KNA1 KUNNR    
5 TCJ_POSITIONS GL_ACCOUNT SKA1 SAKNR    
6 TCJ_POSITIONS MANDT T000 MANDT    
7 TCJ_POSITIONS POSTING_NUMBER TCJ_DOCUMENTS POSTING_NUMBER    
8 TCJ_POSITIONS PSEGMENT FAGL_SEGM SEGMENT    
9 TCJ_POSITIONS SEGMENT FAGL_SEGM SEGMENT    
10 TCJ_POSITIONS TAXJURCODE TTXJ TXJCD REF C CN
11 TCJ_POSITIONS TAX_CODE T007A MWSKZ    
12 TCJ_POSITIONS TRANSACT_NUMBER TCJ_TRANSACTIONS TRANSACT_NUMBER    
13 TCJ_POSITIONS VENDOR_NO LFA1 LIFNR    
History
Last changed by/on SAP  20130529 
SAP Release Created in