ISCJ_E_SPLIT_POSTINGS SAP (Structure for Split Cash Journal Expenses) Structure details
Description: Structure for Split Cash Journal Expenses
Related tables to ISCJ_E_SPLIT_POSTINGS
Access table ISCJ_E_SPLIT_POSTINGS
Structure field list including key, data, relationships and ABAP select examples
ISCJ_E_SPLIT_POSTINGS is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Structure for Split Cash Journal Expenses" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_ISCJ_E_SPLIT_POSTINGS TYPE ISCJ_E_SPLIT_POSTINGS.
The ISCJ_E_SPLIT_POSTINGS table consists of various fields, each holding specific information or linking keys about Structure for Split Cash Journal Expenses data available in SAP. These include CAJO_NUMBER (Cash Journal Number), COMP_CODE (Company Code), FISC_YEAR (Fiscal Year), POSTING_NUMBER (Cash Journal Document Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP ISCJ_E_SPLIT_POSTINGS structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
CAJO_NUMBER | Cash Journal Number | CJNR | CHAR | 4 | Assigned to domain | CJNR | CJCAJONR | H_CAJO_NUMBER | |
COMP_CODE | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
FISC_YEAR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
POSTING_NUMBER | Cash Journal Document Number | CJBELNR | CHAR | 10 | ALPHA | BELNR | |||
H_RECEIPTS | Cash Journal Amount Field with +/- Sign | CJAMOUNT | CURR | 15(2) | CJAMT | ||||
H_PAYMENTS | Cash Journal Amount Field with +/- Sign | CJAMOUNT | CURR | 15(2) | CJAMT | ||||
H_NET_AMOUNT | Cash Journal Document Net Amount - Document Currency | CJNET_AMOUNT | CURR | 13(2) | WERTV7 | ||||
H_NET_PAYMENT_WT | Net Payment Amount (Withholding Tax Deducted) | CJNET_PAYMENT_WT | CURR | 15(2) | CJAMT | ||||
H_TOTAL_AMOUNT | Cash Journal Amount Field with +/- Sign | CJAMOUNT | CURR | 15(2) | CJAMT | ||||
H_TAX_AMOUNT | Tax Amount in Document Currency | FWSTE | CURR | 13(2) | WERT7 | ||||
BP_NAME | Name of Receipt Recipient | CJBPNAME | CHAR | 35 | NAME | ||||
DOCUMENT_DATE | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
DOCUMENT_NUMBER | Reference Document Number | XBLNR1 | CHAR | 16 | XBLNR1 | ||||
POSTING_DATE | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
DOCUMENT_STATUS | Cash Journal Entry Document Status | CJDOCSTAT | CHAR | 2 | CJDOCSTAT | ||||
ACCOUNTANT | User name | USNAM | CHAR | 12 | Assigned to domain | XUBNAME | USR | ||
PRINT_IND | Cash Journal Print Indicator | CJPRINTIND | CHAR | 1 | BOOLEAN | ||||
TAX_CODE | Tax on sales/purchases code | MWSKZ | CHAR | 2 | T007A | MWSKZ | |||
TAX_PERCENT | Tax rate | MSATZ_F05L | DEC | 7(3) | PRZ43V | ||||
TRANSACT_NAME | Cash Journal Business Transaction | CJTRANSTXT | CHAR | 25 | CHAR_25 | ||||
POSITION_TEXT | Cash Journal Line Item Text | CJPOSTEXT | CHAR | 50 | TEXT50 | ||||
PROCESS_STATUS | Cash Journal Entry Document Status | CJDOCSTAT | CHAR | 2 | CJDOCSTAT | ||||
VENDOR_NO | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
CUSTOMER | Customer Numbers | KUNNR | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | C_KUNNR |
D_POSTING_NUMB | Cash Journal Document Number for Display | CJBELNR_DISP | CHAR | 10 | ALPHA | BELNR | |||
TEMP_POSTING_NUMB | Temporary Number for Cash Journal Document | CJBELNR_TEMP | CHAR | 10 | ALPHA | BELNR | |||
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
PARGB | Trading partner's business area | PARGB | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
VBUND | Company ID of trading partner | RASSC | CHAR | 6 | Assigned to domain | ALPHA | RCOMP | PGS | |
RMVCT | Transaction Type | RMVCT | CHAR | 3 | Assigned to domain | RMVCT | |||
FKBER | Functional Area | FKBER | CHAR | 16 | Assigned to domain | FKBER | FBE | ||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | Assigned to domain | CACCD | CAC | ||
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
LSTAR | Activity Type | LSTAR | CHAR | 6 | Assigned to domain | LSTAR | LAR | LART_EMPTY | |
AUFNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
AFPOS | Order Item Number | CO_POSNR | NUMC | 4 | CO_POSNR | ||||
BEMOT | Accounting Indicator | BEMOT | CHAR | 2 | Assigned to domain | BEMOT | |||
KSTRG | Cost Object | KSTRG | CHAR | 12 | Assigned to domain | KSTRG | KTR | ||
PRZNR | Business Process | CO_PRZNR | CHAR | 12 | Assigned to domain | ALPHA | CO_PRZNR | KWP | |
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
PPRCTR | Partner Profit Center | PPRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PPC | |
PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
NPLNR | Network Number for Account Assignment | NPLNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | NET | |
VORNR | Operation/Activity Number | VORNR | CHAR | 4 | NUMCV | VORNR | VGN | ||
ANLN1 | Main Asset Number | BF_ANLN1 | CHAR | 12 | ALPHA | BF_ANLN1 | AN1 | ||
ANLN2 | Asset Subnumber | BF_ANLN2 | CHAR | 4 | ALPHA | BF_ANLN2 | AN2 | ||
BZDAT | Reference Date | BF_BZDAT | DATS | 8 | DATUM | ||||
ANBWA | Asset Transaction Type | BF_ANBWA | CHAR | 3 | CHAR3 | SSH_TABW | |||
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
BWTAR | Valuation Type | BWTAR_D | CHAR | 10 | Assigned to domain | BWTAR | BWT | ||
BWKEY | Valuation Area | BWKEY | CHAR | 4 | Assigned to domain | BWKEY | BWK | ||
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
HRKFT | Origin Group as Subdivision of Cost Element | HRKFT | CHAR | 4 | Assigned to domain | HRKFT | |||
HKMAT | Material-related origin | HKMAT | CHAR | 1 | HKMAT | ||||
KDAUF | Sales Order Number | KDAUF | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
KDEIN | Delivery Schedule for Sales Order | KDEIN | NUMC | 4 | NUM04 | ||||
KDPOS | Item Number in Sales Order | KDPOS | NUMC | 6 | NUM06 | KPO | |||
VNAME | Joint Venture | JV_NAME | CHAR | 6 | Assigned to domain | ALPHA | JV_NAME | JVV | |
RECID | Recovery Indicator | JV_RECIND | CHAR | 2 | Assigned to domain | ALPHA | JV_RECIND | ||
RECID_MAN | Indicator: Recovery Indicator Set Manually. | JV_RECID_M | CHAR | 1 | XFELD | ||||
EGRUP | Equity group | JV_EGROUP | CHAR | 3 | Assigned to domain | ALPHA | JV_EGROUP | GJE | |
ETYPE | Equity type | JV_ETYPE | CHAR | 3 | Assigned to domain | ALPHA | JV_ETYPE | ||
VPTNR | Partner account number | JV_PART | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
CONDI | Joint Venture Indicator (Condition Key) | JV_CONDCOD | CHAR | 2 | Assigned to domain | ALPHA | JV_CONDCOD | ||
CRPCAL | Flag CRP Calculation: Yes or NO | JV_CRPCAL | CHAR | 1 | XFELD | ||||
FIKRS | Financial Management Area | FIKRS | CHAR | 4 | Assigned to domain | FIKRS | FIK | ||
FISTL | Funds Center | FISTL | CHAR | 16 | Assigned to domain | FISTL | FIS | ||
FIPOS | Commitment Item | FIPOS | CHAR | 14 | Assigned to domain | FIPOS | FIP | ||
FIPEX | Commitment Item | FM_FIPEX | CHAR | 24 | Assigned to domain | FM_FIPEX | FPS | ||
GEBER | Fund | BP_GEBER | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
KBLNR | Document Number for Earmarked Funds | KBLNR_FI | CHAR | 10 | Assigned to domain | ALPHA | KBLNR | KBL | |
KBLPOS | Earmarked Funds: Document Item | KBLPOS | NUMC | 3 | Assigned to domain | KBLPOS | KBP | ||
ERLKZ | Used earmarked funds set to 'Complete' | REFSETERLK | CHAR | 1 | CHAR1_X | ||||
PERNR | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER | |||
PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | RKEOBJNR | ||||
IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8 | IMKEY | ||||
KONTT | Account Assignment Category for Industry Solution | KONTT_FI | CHAR | 2 | KONTT_FI | ||||
KONTL | Acct assignment string for industry-specific acct assignmnts | KONTL_FI | CHAR | 50 | CHAR50 | ||||
SMIVE | Lease-Out Number | SMIVE | CHAR | 13 | ALPHA | VVSMIVE | MIV | MRTA | |
GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | |
DABRZ | Reference Date for Settlement | DABRBEZ | DATS | 8 | DDAT | ||||
BUDGET_PD | FM: Budget Period | FM_BUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | BUDPER | ||
TAXJURCODE | Tax Jurisdiction | TXJCD | CHAR | 15 | TTXJ | TXJCD | TXJ | ||
TEXT1 | Additional Field 1 for Cash Journal Document Header | CJDOCTEXT100 | CHAR | 100 | TEXT100 | ||||
TEXT2 | Additional Field 2 for Cash Journal Document Header | CJDOCTEXT30 | CHAR | 30 | TEXT30 | ||||
LINE_NUMBER | Line Number in Cash Journal Document Table | CJLINENUMB | INT4 | 10 | TABIX | ||||
MEANS_OF_PAYMENT | Cash Journal Means of Payment | CJMOFPAYM | CHAR | 1 | CJMOP | ||||
CHECK_NUMBER | 13-digit check number | SCKNR_EB | NUMC | 13 | NUMC13 | ||||
CHECK_ISSUER | Check Issuer (Cash Journal) | CJCHECKISSUER | CHAR | 14 | TEXT14 | ||||
BANK_KEY | Bank Keys | BANKK | CHAR | 15 | BNKA | BANKK | BNK | ||
BANK_ACCT | Bank account number | BANKN | CHAR | 18 | BANKN | ||||
BANK_CTRY | Bank country key | BANKS | CHAR | 3 | T005 | LAND1 | BKL | ||
CHECK_STACK | Number of Check Lot in Cash Journal | CJCHECKSTACK | CHAR | 8 | CHAR8 | ||||
CHECK_STATUS | Posting Status for Checks in Cash Journal | CJCHECKSTATUS | CHAR | 1 | CJCHSTAT | ||||
CHECK_FY | Fiscal Year of Check Deposit | CJCHECKSTACKFY | NUMC | 4 | GJAHR | GJAHR | |||
TEXT | Additional Field for Cash Journal | CJCJTEXT30 | CHAR | 30 | TEXT30 | ||||
VALUTA_DATE | Value date | VALUT | DATS | 8 | DATUM | ||||
ALLOC_NMBR | Assignment Number | DZUONR | CHAR | 18 | ZUONR | ||||
LINE_SEL | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | CHAR | 1 | BOOLEAN | ||||
BRANCH | Account Number of the Branch | FILKD | CHAR | 10 | ALPHA | MAXKK | |||
REVBELNR | Reversal Document Number for Cash Journal Document | CJREVBELNR | CHAR | 10 | ALPHA | BELNR | |||
EXCH_RATE | Exchange rate | KURSF | DEC | 9(5) | EXCRT | KURSF | |||
BUPLA | Business Place | BUPLA | CHAR | 4 | Assigned to domain | J_1BBRANCH | |||
SECCO | Section Code | SECCO | CHAR | 4 | Assigned to domain | SECCO | SECCO_ABA | ||
POSITION_NUMBER | Number of Line Item within Cash Journal Document | CJBUZEI | NUMC | 3 | BUZEI | ||||
POSITION_TYPE | Cash Journal Item Type | CJPOSTYPE | CHAR | 2 | CJPOSTYPE | ||||
P_RECEIPTS | Cash Journal Amount Field with +/- Sign | CJAMOUNT | CURR | 15(2) | CJAMT | ||||
P_PAYMENTS | Cash Journal Amount Field with +/- Sign | CJAMOUNT | CURR | 15(2) | CJAMT | ||||
P_NET_AMOUNT | Cash Journal Document Net Amount - Document Currency | CJNET_AMOUNT | CURR | 13(2) | WERTV7 | ||||
P_NET_PAYMENT_WT | Net Payment Amount (Withholding Tax Deducted) | CJNET_PAYMENT_WT | CURR | 15(2) | CJAMT | ||||
P_TAX_AMOUNT | Tax amount in document currency | WMWST | CURR | 13(2) | WERT7 | ||||
SPLIT | Split Information for Cash Journal Document | CJDOCSPLIT | CHAR | 1 | CJDSPLIT | ||||
LZBKZ | State Central Bank Indicator | LZBKZ | CHAR | 3 | T015L | LZBKZ | |||
LANDL | Supplying Country | LANDL | CHAR | 3 | T005 | LAND1 | |||
P_FWBAS | Tax Base Amount in Document Currency | FWBAS | CURR | 13(2) | WERT7 | ||||
GL_ACCOUNT | General Ledger Account | HKONT | CHAR | 10 | SKB1 | ALPHA | SAKNR | ||
SEGMENT | Segment for Segmental Reporting | FB_SEGMENT | CHAR | 10 | FAGL_SEGM | ALPHA | FB_SEGMENT | ||
PSEGMENT | Partner Segment for Segmental Reporting | FB_PSEGMENT | CHAR | 10 | FAGL_SEGM | ALPHA | FB_SEGMENT | ||
VATDATE | Tax Reporting Date | VATDATE | DATS | 8 | DATUM | ||||
MAN_TAX | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | CHAR | 1 | BOOLEAN | ||||
STCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
UMSKZ | Special G/L Indicator | UMSKZ | CHAR | 1 | Assigned to domain | UMSKZ |
Key field | Non-key field |
How do I retrieve data from SAP structure ISCJ_E_SPLIT_POSTINGS using ABAP code?
As ISCJ_E_SPLIT_POSTINGS is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on ISCJ_E_SPLIT_POSTINGS as there is no data to select.How to access SAP table ISCJ_E_SPLIT_POSTINGS
Within an ECC or HANA version of SAP you can also view further information about ISCJ_E_SPLIT_POSTINGS and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects