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