1. Home
  2. Resources
  3. SAP Tables
  4. ISCJ_R_POSTINGS - Structure for Cash Journal receipts

SAP Table ISCJ_R_POSTINGS

Structure for Cash Journal receipts

ISCJ_R_POSTINGS (Structure for Cash Journal receipts) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link ISCJ_R_POSTINGS to other SAP tables.

ISCJ_R_POSTINGS table fields

Field Data element Checktable Datatype Length Decimals
CAJO_NUMBER Cash Journal Number CJNR CHAR 4 0
COMP_CODE Company Code BUKRS CHAR 4 0
FISC_YEAR Fiscal Year GJAHR NUMC 4 0
POSTING_NUMBER Cash Journal Document Number CJBELNR CHAR 10 0
H_RECEIPTS Cash Journal Amount Field with +/- Sign CJAMOUNT CURR 15 2
H_PAYMENTS Cash Journal Amount Field with +/- Sign CJAMOUNT CURR 15 2
H_NET_AMOUNT Cash Journal Document Net Amount - Document Currency CJNET_AMOUNT CURR 13 2
H_NET_PAYMENT_WT Net Payment Amount (Withholding Tax Deducted) CJNET_PAYMENT_WT CURR 15 2
H_TOTAL_AMOUNT Cash Journal Amount Field with +/- Sign CJAMOUNT CURR 15 2
H_TAX_AMOUNT Tax Amount in Document Currency FWSTE CURR 13 2
BP_NAME Name of Receipt Recipient CJBPNAME CHAR 35 0
DOCUMENT_DATE Document Date in Document BLDAT DATS 8 0
DOCUMENT_NUMBER Reference Document Number XBLNR1 CHAR 16 0
POSTING_DATE Posting Date in the Document BUDAT DATS 8 0
DOCUMENT_STATUS Cash Journal Entry Document Status CJDOCSTAT CHAR 2 0
P Successfully posted (FI/CO interface)
S Successfully saved (in cash journal)
E Online checks for data entry were carried out
D Document was deleted
C Document was copied
R Document has been reversed
ACCOUNTANT User name USNAM CHAR 12 0
PRINT_IND Cash Journal Print Indicator CJPRINTIND CHAR 1 0
X true
- false
NULL unknown
TAX_CODE Tax on sales/purchases code MWSKZ T007A CHAR 2 0
TAX_PERCENT Tax rate MSATZ_F05L DEC 7 3
TRANSACT_NAME Cash Journal Business Transaction CJTRANSTXT CHAR 25 0
POSITION_TEXT Cash Journal Line Item Text CJPOSTEXT CHAR 50 0
PROCESS_STATUS Cash Journal Entry Document Status CJDOCSTAT CHAR 2 0
P Successfully posted (FI/CO interface)
S Successfully saved (in cash journal)
E Online checks for data entry were carried out
D Document was deleted
C Document was copied
R Document has been reversed
VENDOR_NO Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
CUSTOMER Customer Number KUNNR KNA1 CHAR 10 0
D_POSTING_NUMB Cash Journal Document Number for Display CJBELNR_DISP CHAR 10 0
TEMP_POSTING_NUMB Temporary Number for Cash Journal Document CJBELNR_TEMP CHAR 10 0
GSBER Business Area GSBER CHAR 4 0
PARGB Trading partner's business area PARGB CHAR 4 0
VBUND Company ID of trading partner RASSC CHAR 6 0
RMVCT Transaction Type RMVCT CHAR 3 0
FKBER Functional Area FKBER CHAR 16 0
KOKRS Controlling Area KOKRS CHAR 4 0
KOSTL Cost Center KOSTL CHAR 10 0
LSTAR Activity Type LSTAR CHAR 6 0
AUFNR Order Number AUFNR CHAR 12 0
AFPOS Order Item Number CO_POSNR NUMC 4 0
BEMOT Accounting Indicator BEMOT CHAR 2 0
KSTRG Cost Object KSTRG CHAR 12 0
PRZNR Business Process CO_PRZNR CHAR 12 0
PRCTR Profit Center PRCTR CHAR 10 0
PPRCTR Partner Profit Center PPRCTR CHAR 10 0
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
NPLNR Network Number for Account Assignment NPLNR CHAR 12 0
VORNR Operation/Activity Number VORNR CHAR 4 0
ANLN1 Main Asset Number BF_ANLN1 CHAR 12 0
ANLN2 Asset Subnumber BF_ANLN2 CHAR 4 0
BZDAT Reference Date BF_BZDAT DATS 8 0
ANBWA Asset Transaction Type BF_ANBWA CHAR 3 0
WERKS Plant WERKS_D CHAR 4 0
BWTAR Valuation Type BWTAR_D CHAR 10 0
BWKEY Valuation Area BWKEY CHAR 4 0
MATNR Material Number MATNR CHAR 18 0
HRKFT Origin Group as Subdivision of Cost Element HRKFT CHAR 4 0
HKMAT Material-related origin HKMAT CHAR 1 0
NULL No material-related origin
X Keep costs/quantities under material number
KDAUF Sales Order Number KDAUF CHAR 10 0
KDEIN Delivery Schedule for Sales Order KDEIN NUMC 4 0
KDPOS Item Number in Sales Order KDPOS NUMC 6 0
VNAME Joint Venture JV_NAME CHAR 6 0
RECID Recovery Indicator JV_RECIND CHAR 2 0
RECID_MAN Indicator: Recovery Indicator Set Manually. JV_RECID_M CHAR 1 0
X Yes
NULL No
EGRUP Equity group JV_EGROUP CHAR 3 0
ETYPE Equity type JV_ETYPE CHAR 3 0
VPTNR Partner account number JV_PART CHAR 10 0
CONDI Joint Venture Indicator (Condition Key) JV_CONDCOD CHAR 2 0
CRPCAL Flag CRP Calculation: Yes or NO JV_CRPCAL CHAR 1 0
X Yes
NULL No
FIKRS Financial Management Area FIKRS CHAR 4 0
FISTL Funds Center FISTL CHAR 16 0
FIPOS Commitment Item FIPOS CHAR 14 0
FIPEX Commitment Item FM_FIPEX CHAR 24 0
GEBER Fund BP_GEBER CHAR 10 0
KBLNR Document Number for Earmarked Funds KBLNR_FI CHAR 10 0
KBLPOS Earmarked Funds: Document Item KBLPOS NUMC 3 0
ERLKZ Used earmarked funds set to "Complete" REFSETERLK CHAR 1 0
NULL Not Selected
X Selected
PERNR Personnel Number PERNR_D NUMC 8 0
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR NUMC 10 0
IMKEY Internal Key for Real Estate Object IMKEY CHAR 8 0
KONTT Account Assignment Category for Industry Solution KONTT_FI CHAR 2 0
KONTL Acct assignment string for industry-specific acct assignmnts KONTL_FI CHAR 50 0
SMIVE Lease-Out Number SMIVE CHAR 13 0
GRANT_NBR Grant GM_GRANT_NBR CHAR 20 0
DABRZ Reference Date for Settlement DABRBEZ DATS 8 0
BUDGET_PD FM: Budget Period FM_BUDGET_PERIOD CHAR 10 0
TAXJURCODE Tax Jurisdiction TXJCD TTXJ CHAR 15 0
TEXT1 Additional Field 1 for Cash Journal Document Header CJDOCTEXT100 CHAR 100 0
TEXT2 Additional Field 2 for Cash Journal Document Header CJDOCTEXT30 CHAR 30 0
LINE_NUMBER Line Number in Cash Journal Document Table CJLINENUMB INT4 10 0
MEANS_OF_PAYMENT Cash Journal Means of Payment CJMOFPAYM CHAR 1 0
B Cash
C Check
CHECK_NUMBER 13-digit check number SCKNR_EB NUMC 13 0
CHECK_ISSUER Check Issuer (Cash Journal) CJCHECKISSUER CHAR 14 0
BANK_KEY Bank Keys BANKK BNKA CHAR 15 0
BANK_ACCT Bank account number BANKN CHAR 18 0
BANK_CTRY Bank country key BANKS T005 CHAR 3 0
CHECK_STACK Number of Check Lot in Cash Journal CJCHECKSTACK CHAR 8 0
CHECK_STATUS Posting Status for Checks in Cash Journal CJCHECKSTATUS CHAR 1 0
S Check lot successfully saved (in cash journal)
P Check lot successfully posted (Acc interface)
E Online checks for data entry were carried out
D Check lot was deleted
C Check lot was copied
R Check lot was reversed
CHECK_FY Fiscal Year of Check Deposit CJCHECKSTACKFY NUMC 4 0
TEXT Additional Field for Cash Journal CJCJTEXT30 CHAR 30 0
VALUTA_DATE Value date VALUT DATS 8 0
ALLOC_NMBR Assignment Number DZUONR CHAR 18 0
LINE_SEL Boolean Variable (X=True, -=False, Space=Unknown) BOOLEAN CHAR 1 0
X true
- false
NULL unknown
BRANCH Account Number of the Branch FILKD CHAR 10 0
REVBELNR Reversal Document Number for Cash Journal Document CJREVBELNR CHAR 10 0
EXCH_RATE Exchange rate KURSF DEC 9 5
BUPLA Business Place BUPLA CHAR 4 0
SECCO Section Code SECCO CHAR 4 0
POSITION_NUMBER Number of Line Item within Cash Journal Document CJBUZEI NUMC 3 0
POSITION_TYPE Cash Journal Item Type CJPOSTYPE CHAR 2 0
P Means of payment item
O Offsetting posting item
T Tax item
P_RECEIPTS Cash Journal Amount Field with +/- Sign CJAMOUNT CURR 15 2
P_PAYMENTS Cash Journal Amount Field with +/- Sign CJAMOUNT CURR 15 2
P_NET_AMOUNT Cash Journal Document Net Amount - Document Currency CJNET_AMOUNT CURR 13 2
P_NET_PAYMENT_WT Net Payment Amount (Withholding Tax Deducted) CJNET_PAYMENT_WT CURR 15 2
P_TAX_AMOUNT Tax amount in document currency WMWST CURR 13 2
SPLIT Split Information for Cash Journal Document CJDOCSPLIT CHAR 1 0
NULL No split
X Normal Split
LZBKZ State Central Bank Indicator LZBKZ T015L CHAR 3 0
LANDL Supplying Country LANDL T005 CHAR 3 0
P_FWBAS Tax Base Amount in Document Currency FWBAS CURR 13 2
GL_ACCOUNT General Ledger Account HKONT SKB1 CHAR 10 0
SEGMENT Segment for Segmental Reporting FB_SEGMENT FAGL_SEGM CHAR 10 0
PSEGMENT Partner Segment for Segmental Reporting FB_PSEGMENT FAGL_SEGM CHAR 10 0
VATDATE Tax Reporting Date VATDATE DATS 8 0
MAN_TAX Boolean Variable (X=True, -=False, Space=Unknown) BOOLEAN CHAR 1 0
X true
- false
NULL unknown
STCEG VAT Registration Number STCEG CHAR 20 0
UMSKZ Special G/L Indicator UMSKZ CHAR 1 0

ISCJ_R_POSTINGS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ISCJ_R_POSTINGS BANK_CTRY SYST MANDT T005 Countries MANDT
ISCJ_R_POSTINGS BANK_CTRY ISCJ_R_POSTINGS BANK_CTRY T005 Countries LAND1
ISCJ_R_POSTINGS BANK_KEY ISCJ_R_POSTINGS BANK_KEY BNKA Bank master record BANKL
ISCJ_R_POSTINGS BANK_KEY SYST MANDT BNKA Bank master record MANDT
ISCJ_R_POSTINGS BANK_KEY ISCJ_R_POSTINGS BANK_CTRY BNKA Bank master record BANKS
ISCJ_R_POSTINGS CUSTOMER ISCJ_R_POSTINGS CUSTOMER KNA1 General Data in Customer Master KUNNR
ISCJ_R_POSTINGS CUSTOMER * KNA1 General Data in Customer Master MANDT
ISCJ_R_POSTINGS GL_ACCOUNT ISCJ_R_POSTINGS GL_ACCOUNT SKB1 G/L account master (company code) SAKNR
ISCJ_R_POSTINGS GL_ACCOUNT SYST MANDT SKB1 G/L account master (company code) MANDT
ISCJ_R_POSTINGS GL_ACCOUNT ISCJ_R_POSTINGS COMP_CODE SKB1 G/L account master (company code) BUKRS
ISCJ_R_POSTINGS LANDL SYST MANDT T005 Countries MANDT
ISCJ_R_POSTINGS LANDL ISCJ_R_POSTINGS LANDL T005 Countries LAND1
ISCJ_R_POSTINGS LZBKZ SYST MANDT T015L SCB Ratios MANDT
ISCJ_R_POSTINGS LZBKZ ISCJ_R_POSTINGS LZBKZ T015L SCB Ratios LZBKZ
ISCJ_R_POSTINGS PSEGMENT SYST MANDT FAGL_SEGM Master Data for Segments MANDT
ISCJ_R_POSTINGS PSEGMENT ISCJ_R_POSTINGS PSEGMENT FAGL_SEGM Master Data for Segments SEGMENT
ISCJ_R_POSTINGS SEGMENT SYST MANDT FAGL_SEGM Master Data for Segments MANDT
ISCJ_R_POSTINGS SEGMENT ISCJ_R_POSTINGS SEGMENT FAGL_SEGM Master Data for Segments SEGMENT
ISCJ_R_POSTINGS TAXJURCODE * TTXJ Check Table for Tax Jurisdiction MANDT
ISCJ_R_POSTINGS TAXJURCODE * TTXJ Check Table for Tax Jurisdiction KALSM
ISCJ_R_POSTINGS TAXJURCODE ISCJ_R_POSTINGS TAXJURCODE TTXJ Check Table for Tax Jurisdiction TXJCD
ISCJ_R_POSTINGS TAX_CODE SYST MANDT T007A Tax Keys MANDT
ISCJ_R_POSTINGS TAX_CODE * T007A Tax Keys KALSM
ISCJ_R_POSTINGS TAX_CODE ISCJ_R_POSTINGS TAX_CODE T007A Tax Keys MWSKZ
ISCJ_R_POSTINGS VENDOR_NO * LFA1 Vendor Master (General Section) MANDT
ISCJ_R_POSTINGS VENDOR_NO ISCJ_R_POSTINGS VENDOR_NO LFA1 Vendor Master (General Section) LIFNR
ISCJ_R_POSTINGS ZZREGION SYST MANDT ZREG User Defined Regions MANDT
ISCJ_R_POSTINGS ZZREGION ISCJ_R_POSTINGS ZZREGION ZREG User Defined Regions ZZREGION
ISCJ_R_POSTINGS ZZSPREG ISCJ_R_POSTINGS ZZSPREG ZZSPREG Check table for ZZSPREG = Special Region ZZSPREG
ISCJ_R_POSTINGS ZZSPREG SYST MANDT ZZSPREG Check table for ZZSPREG = Special Region MANDT
ISCJ_R_POSTINGS ZZSTATE SYST MANDT T005S Taxes: Region (Province) Key MANDT
ISCJ_R_POSTINGS ZZSTATE * T005S Taxes: Region (Province) Key LAND1
ISCJ_R_POSTINGS ZZSTATE ISCJ_R_POSTINGS ZZSTATE T005S Taxes: Region (Province) Key BLAND
ISCJ_R_POSTINGS ZZUSERFLD1 SYST MANDT ZFU1 Check Table for User Field 1 MANDT
ISCJ_R_POSTINGS ZZUSERFLD1 ISCJ_R_POSTINGS ZZUSERFLD1 ZFU1 Check Table for User Field 1 ZZUSERFLD1