SAP table TCJ_CHECK_STACKS (Check Lists in Cash Journal)
SAP table TCJ_CHECK_STACKS has 5 primary key fields being MANDT,COMP_CODE,CAJO_NUMBER,FISC_YEAR,CHECK_STACK.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | MANDT | ||
| COMP_CODE | Company Code | CHAR | 4 | 0 | BUKRS | ||
| CAJO_NUMBER | Cash Journal Number | CHAR | 4 | 0 | CJNR | ||
| FISC_YEAR | Fiscal Year | NUMC | 4 | 0 | GJAHR | ||
| CHECK_STACK | Number of Check Lot in Cash Journal | CHAR | 8 | 0 | CJCHECKSTACK | ||
| TRANSACT_NUMBER | Number of Cash Journal Business Transaction | CHAR | 4 | 0 | CJTRANSNUMB | ||
| POSTING_DATE | Posting Date in the Document | DATS | 8 | 0 | BUDAT | ||
| VALUTA_DATE | Value date | DATS | 8 | 0 | VALUT | ||
| CHECK_STATUS | Posting Status for Checks in Cash Journal | CHAR | 1 | 0 | CJCHECKSTATUS | ||
| GL_ACCOUNT | General Ledger Account | CHAR | 10 | 0 | HKONT |