SAP ABAP Table TCJ_DOCUMENTS (Cash Journal Documents (Header Data))
Hierarchy
☛
SAP_FIN (Software Component) SAP_FIN
⤷ FI-GL-GL-AP (Application Component) G/L Account Posting
⤷ CAJO (Package) Cash Journal Development
⤷ 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_DOCUMENTS | Table Relationship Diagram |
Short Description | Cash Journal Documents (Header Data) |
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 | ||
6 | CURRENCY | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
7 | H_RECEIPTS | CJAMOUNT | CJAMT | CURR | 15 | 2 | Cash Journal Amount Field with +/- Sign | ||
8 | H_PAYMENTS | CJAMOUNT | CJAMT | CURR | 15 | 2 | Cash Journal Amount Field with +/- Sign | ||
9 | H_NET_AMOUNT | CJNET_AMOUNT | WERTV7 | CURR | 13 | 2 | Cash Journal Document Net Amount - Document Currency | ||
10 | H_NET_PAYMENT_WT | CJNET_PAYMENT_WT | CJAMT | CURR | 15 | 2 | Net Payment Amount (Withholding Tax Deducted) | ||
11 | H_TAX_AMOUNT | WMWST | WERT7 | CURR | 13 | 2 | Tax amount in document currency | ||
12 | BP_NAME | CJBPNAME | NAME | CHAR | 35 | 0 | Name of Receipt Recipient | ||
13 | DOCUMENT_DATE | BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
14 | DOCUMENT_NUMBER | XBLNR1 | XBLNR1 | CHAR | 16 | 0 | Reference Document Number | ||
15 | POSTING_DATE | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
16 | DOCUMENT_STATUS | CJDOCSTAT | CJDOCSTAT | CHAR | 2 | 0 | Cash Journal Entry Document Status | ||
17 | ACCOUNTANT | USNAM | XUBNAME | CHAR | 12 | 0 | User name | * | |
18 | PRINT_IND | CJPRINTIND | BOOLEAN | CHAR | 1 | 0 | Cash Journal Print Indicator | ||
19 | TAX_PERCENT | MSATZ_F05L | PRZ43V | DEC | 7 | 3 | Tax rate | ||
20 | D_POSTING_NUMB | CJBELNR_DISP | BELNR | CHAR | 10 | 0 | Cash Journal Document Number for Display | ||
21 | TEXT1 | CJDOCTEXT100 | TEXT100 | CHAR | 100 | 0 | Additional Field 1 for Cash Journal Document Header | ||
22 | TEXT2 | CJDOCTEXT30 | TEXT30 | CHAR | 30 | 0 | Additional Field 2 for Cash Journal Document Header | ||
23 | MEANS_OF_PAYMENT | CJMOFPAYM | CJMOP | CHAR | 1 | 0 | Cash Journal Means of Payment | ||
24 | CHECK_NUMBER | SCKNR_EB | NUMC13 | NUMC | 13 | 0 | 13-digit check number | ||
25 | CHECK_ISSUER | CJCHECKISSUER | TEXT14 | CHAR | 14 | 0 | Check Issuer (Cash Journal) | ||
26 | BANK_KEY | BANKK | BANKK | CHAR | 15 | 0 | Bank Keys | ||
27 | BANK_ACCT | BANKN | BANKN | CHAR | 18 | 0 | Bank account number | ||
28 | BANK_CTRY | BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | * | |
29 | CHECK_STACK | CJCHECKSTACK | CHAR8 | CHAR | 8 | 0 | Number of Check Lot in Cash Journal | ||
30 | CHECK_STATUS | CJCHECKSTATUS | CJCHSTAT | CHAR | 1 | 0 | Posting Status for Checks in Cash Journal | ||
31 | REVBELNR | CJREVBELNR | BELNR | CHAR | 10 | 0 | Reversal Document Number for Cash Journal Document | ||
32 | EXCH_RATE | KURSF | KURSF | DEC | 9 | 5 | Exchange rate | ||
33 | BUPLA | BUPLA | J_1BBRANCH | CHAR | 4 | 0 | Business Place | * | |
34 | SECCO | SECCO | SECCO | CHAR | 4 | 0 | Section Code | * | |
35 | SPLIT | CJDOCSPLIT | CJDSPLIT | CHAR | 1 | 0 | Split Information for Cash Journal Document | ||
36 | LZBKZ | LZBKZ | LZBKZ | CHAR | 3 | 0 | State central bank indicator | T015L | |
37 | LANDL | LANDL | LAND1 | CHAR | 3 | 0 | Supplying Country | T005 | |
38 | CHECK_FY | CJCHECKSTACKFY | GJAHR | NUMC | 4 | 0 | Fiscal Year of Check Deposit | ||
39 | VALUTA_DATE | VALUT | DATUM | DATS | 8 | 0 | Fixed Value Date | ||
40 | VATDATE | VATDATE | DATUM | DATS | 8 | 0 | Tax Reporting Date |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | TCJ_DOCUMENTS | CAJO_NUMBER | TCJ_C_JOURNALS | CAJO_NUMBER | |||
2 | TCJ_DOCUMENTS | COMP_CODE | T001 | BUKRS | |||
3 | TCJ_DOCUMENTS | CURRENCY | TCURC | WAERS | |||
4 | TCJ_DOCUMENTS | LANDL | T005 | LAND1 | |||
5 | TCJ_DOCUMENTS | LZBKZ | T015L | LZBKZ | |||
6 | TCJ_DOCUMENTS | MANDT | T000 | MANDT |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |