ISCJ_E_SPLIT_POSTINGS SAP (Structure for Split Cash Journal Expenses) Structure details

Dictionary Type: Structure
Description: Structure for Split Cash Journal Expenses




ABAP Code to SELECT data from ISCJ_E_SPLIT_POSTINGS
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_NUMBERCash Journal Number CJNRCHAR4Assigned to domainCJNRCJCAJONRH_CAJO_NUMBER
COMP_CODECompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
FISC_YEARFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
POSTING_NUMBERCash Journal Document Number CJBELNRCHAR10ALPHABELNR
H_RECEIPTSCash Journal Amount Field with +/- Sign CJAMOUNTCURR15(2) CJAMT
H_PAYMENTSCash Journal Amount Field with +/- Sign CJAMOUNTCURR15(2) CJAMT
H_NET_AMOUNTCash Journal Document Net Amount - Document Currency CJNET_AMOUNTCURR13(2) WERTV7
H_NET_PAYMENT_WTNet Payment Amount (Withholding Tax Deducted) CJNET_PAYMENT_WTCURR15(2) CJAMT
H_TOTAL_AMOUNTCash Journal Amount Field with +/- Sign CJAMOUNTCURR15(2) CJAMT
H_TAX_AMOUNTTax Amount in Document Currency FWSTECURR13(2) WERT7
BP_NAMEName of Receipt Recipient CJBPNAMECHAR35NAME
DOCUMENT_DATEDocument Date in Document BLDATDATS8DATUM
DOCUMENT_NUMBERReference Document Number XBLNR1CHAR16XBLNR1
POSTING_DATEPosting Date in the Document BUDATDATS8DATUM
DOCUMENT_STATUSCash Journal Entry Document Status CJDOCSTATCHAR2CJDOCSTAT
ACCOUNTANTUser name USNAMCHAR12Assigned to domainXUBNAMEUSR
PRINT_INDCash Journal Print Indicator CJPRINTINDCHAR1BOOLEAN
TAX_CODETax on sales/purchases code MWSKZCHAR2T007AMWSKZ
TAX_PERCENTTax rate MSATZ_F05LDEC7(3) PRZ43V
TRANSACT_NAMECash Journal Business Transaction CJTRANSTXTCHAR25CHAR_25
POSITION_TEXTCash Journal Line Item Text CJPOSTEXTCHAR50TEXT50
PROCESS_STATUSCash Journal Entry Document Status CJDOCSTATCHAR2CJDOCSTAT
VENDOR_NOAccount Number of Vendor or Creditor LIFNRCHAR10LFA1ALPHALIFNRLIFKRED_C
CUSTOMERCustomer Numbers KUNNRCHAR10KNA1ALPHAKUNNRKUNC_KUNNR
D_POSTING_NUMBCash Journal Document Number for Display CJBELNR_DISPCHAR10ALPHABELNR
TEMP_POSTING_NUMBTemporary Number for Cash Journal Document CJBELNR_TEMPCHAR10ALPHABELNR
GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
PARGBTrading partner's business area PARGBCHAR4Assigned to domainGSBERGSB
VBUNDCompany ID of trading partner RASSCCHAR6Assigned to domainALPHARCOMPPGS
RMVCTTransaction Type RMVCTCHAR3Assigned to domainRMVCT
FKBERFunctional Area FKBERCHAR16Assigned to domainFKBERFBE
KOKRSControlling Area KOKRSCHAR4Assigned to domainCACCDCAC
KOSTLCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
LSTARActivity Type LSTARCHAR6Assigned to domainLSTARLARLART_EMPTY
AUFNROrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
AFPOSOrder Item Number CO_POSNRNUMC4CO_POSNR
BEMOTAccounting Indicator BEMOTCHAR2Assigned to domainBEMOT
KSTRGCost Object KSTRGCHAR12Assigned to domainKSTRGKTR
PRZNRBusiness Process CO_PRZNRCHAR12Assigned to domainALPHACO_PRZNRKWP
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
PPRCTRPartner Profit Center PPRCTRCHAR10Assigned to domainALPHAPRCTRPPC
PS_PSP_PNRWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8Assigned to domainKONPRPS_POSNR
NPLNRNetwork Number for Account Assignment NPLNRCHAR12Assigned to domainALPHAAUFNRNET
VORNROperation/Activity Number VORNRCHAR4NUMCVVORNRVGN
ANLN1Main Asset Number BF_ANLN1CHAR12ALPHABF_ANLN1AN1
ANLN2Asset Subnumber BF_ANLN2CHAR4ALPHABF_ANLN2AN2
BZDATReference Date BF_BZDATDATS8DATUM
ANBWAAsset Transaction Type BF_ANBWACHAR3CHAR3SSH_TABW
WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
BWTARValuation Type BWTAR_DCHAR10Assigned to domainBWTARBWT
BWKEYValuation Area BWKEYCHAR4Assigned to domainBWKEYBWK
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
HRKFTOrigin Group as Subdivision of Cost Element HRKFTCHAR4Assigned to domainHRKFT
HKMATMaterial-related origin HKMATCHAR1HKMAT
KDAUFSales Order Number KDAUFCHAR10Assigned to domainALPHAVBELNAUN
KDEINDelivery Schedule for Sales Order KDEINNUMC4NUM04
KDPOSItem Number in Sales Order KDPOSNUMC6NUM06KPO
VNAMEJoint Venture JV_NAMECHAR6Assigned to domainALPHAJV_NAMEJVV
RECIDRecovery Indicator JV_RECINDCHAR2Assigned to domainALPHAJV_RECIND
RECID_MANIndicator: Recovery Indicator Set Manually. JV_RECID_MCHAR1XFELD
EGRUPEquity group JV_EGROUPCHAR3Assigned to domainALPHAJV_EGROUPGJE
ETYPEEquity type JV_ETYPECHAR3Assigned to domainALPHAJV_ETYPE
VPTNRPartner account number JV_PARTCHAR10Assigned to domainALPHAKUNNR
CONDIJoint Venture Indicator (Condition Key) JV_CONDCODCHAR2Assigned to domainALPHAJV_CONDCOD
CRPCALFlag CRP Calculation: Yes or NO JV_CRPCALCHAR1XFELD
FIKRSFinancial Management Area FIKRSCHAR4Assigned to domainFIKRSFIK
FISTLFunds Center FISTLCHAR16Assigned to domainFISTLFIS
FIPOSCommitment Item FIPOSCHAR14Assigned to domainFIPOSFIP
FIPEXCommitment Item FM_FIPEXCHAR24Assigned to domainFM_FIPEXFPS
GEBERFund BP_GEBERCHAR10Assigned to domainBP_GEBERFIC
KBLNRDocument Number for Earmarked Funds KBLNR_FICHAR10Assigned to domainALPHAKBLNRKBL
KBLPOSEarmarked Funds: Document Item KBLPOSNUMC3Assigned to domainKBLPOSKBP
ERLKZUsed earmarked funds set to 'Complete' REFSETERLKCHAR1CHAR1_X
PERNRPersonnel Number PERNR_DNUMC8PERNRPER
PAOBJNRProfitability Segment Number (CO-PA) RKEOBJNRNUMC10RKEOBJNR
IMKEYInternal Key for Real Estate Object IMKEYCHAR8IMKEY
KONTTAccount Assignment Category for Industry Solution KONTT_FICHAR2KONTT_FI
KONTLAcct assignment string for industry-specific acct assignmnts KONTL_FICHAR50CHAR50
SMIVELease-Out Number SMIVECHAR13ALPHAVVSMIVEMIVMRTA
GRANT_NBRGrant GM_GRANT_NBRCHAR20ALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERIC
DABRZReference Date for Settlement DABRBEZDATS8DDAT
BUDGET_PDFM: Budget Period FM_BUDGET_PERIODCHAR10Assigned to domainFM_BUDGET_PERIODBUDPER
TAXJURCODETax Jurisdiction TXJCDCHAR15TTXJTXJCDTXJ
TEXT1Additional Field 1 for Cash Journal Document Header CJDOCTEXT100CHAR100TEXT100
TEXT2Additional Field 2 for Cash Journal Document Header CJDOCTEXT30CHAR30TEXT30
LINE_NUMBERLine Number in Cash Journal Document Table CJLINENUMBINT410TABIX
MEANS_OF_PAYMENTCash Journal Means of Payment CJMOFPAYMCHAR1CJMOP
CHECK_NUMBER13-digit check number SCKNR_EBNUMC13NUMC13
CHECK_ISSUERCheck Issuer (Cash Journal) CJCHECKISSUERCHAR14TEXT14
BANK_KEYBank Keys BANKKCHAR15BNKABANKKBNK
BANK_ACCTBank account number BANKNCHAR18BANKN
BANK_CTRYBank country key BANKSCHAR3T005LAND1BKL
CHECK_STACKNumber of Check Lot in Cash Journal CJCHECKSTACKCHAR8CHAR8
CHECK_STATUSPosting Status for Checks in Cash Journal CJCHECKSTATUSCHAR1CJCHSTAT
CHECK_FYFiscal Year of Check Deposit CJCHECKSTACKFYNUMC4GJAHRGJAHR
TEXTAdditional Field for Cash Journal CJCJTEXT30CHAR30TEXT30
VALUTA_DATEValue date VALUTDATS8DATUM
ALLOC_NMBRAssignment Number DZUONRCHAR18ZUONR
LINE_SELBoolean Variable (X=True, -=False, Space=Unknown) BOOLEANCHAR1BOOLEAN
BRANCHAccount Number of the Branch FILKDCHAR10ALPHAMAXKK
REVBELNRReversal Document Number for Cash Journal Document CJREVBELNRCHAR10ALPHABELNR
EXCH_RATEExchange rate KURSFDEC9(5) EXCRTKURSF
BUPLABusiness Place BUPLACHAR4Assigned to domainJ_1BBRANCH
SECCOSection Code SECCOCHAR4Assigned to domainSECCOSECCO_ABA
POSITION_NUMBERNumber of Line Item within Cash Journal Document CJBUZEINUMC3BUZEI
POSITION_TYPECash Journal Item Type CJPOSTYPECHAR2CJPOSTYPE
P_RECEIPTSCash Journal Amount Field with +/- Sign CJAMOUNTCURR15(2) CJAMT
P_PAYMENTSCash Journal Amount Field with +/- Sign CJAMOUNTCURR15(2) CJAMT
P_NET_AMOUNTCash Journal Document Net Amount - Document Currency CJNET_AMOUNTCURR13(2) WERTV7
P_NET_PAYMENT_WTNet Payment Amount (Withholding Tax Deducted) CJNET_PAYMENT_WTCURR15(2) CJAMT
P_TAX_AMOUNTTax amount in document currency WMWSTCURR13(2) WERT7
SPLITSplit Information for Cash Journal Document CJDOCSPLITCHAR1CJDSPLIT
LZBKZState Central Bank Indicator LZBKZCHAR3T015LLZBKZ
LANDLSupplying Country LANDLCHAR3T005LAND1
P_FWBASTax Base Amount in Document Currency FWBASCURR13(2) WERT7
GL_ACCOUNTGeneral Ledger Account HKONTCHAR10SKB1ALPHASAKNR
SEGMENTSegment for Segmental Reporting FB_SEGMENTCHAR10FAGL_SEGMALPHAFB_SEGMENT
PSEGMENTPartner Segment for Segmental Reporting FB_PSEGMENTCHAR10FAGL_SEGMALPHAFB_SEGMENT
VATDATETax Reporting Date VATDATEDATS8DATUM
MAN_TAXBoolean Variable (X=True, -=False, Space=Unknown) BOOLEANCHAR1BOOLEAN
STCEGVAT Registration Number STCEGCHAR20STCEG
UMSKZSpecial G/L Indicator UMSKZCHAR1Assigned to domainUMSKZ

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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!