SAP ABAP Table ISCJ_R_POSTINGS (Structure for Cash Journal receipts)
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 | INTTAB | Structure |
Structure | ISCJ_R_POSTINGS | Table Relationship Diagram |
Short Description | Structure for Cash Journal receipts |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
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 | .INCLUDE | 0 | 0 | Cash Journal Structure Screen 0100 SAPMFCJ0 | |||||
2 | CAJO_NUMBER | CJNR | CJNR | CHAR | 4 | 0 | Cash Journal Number | * | |
3 | COMP_CODE | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
4 | FISC_YEAR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
5 | POSTING_NUMBER | CJBELNR | BELNR | CHAR | 10 | 0 | Cash Journal Document Number | ||
6 | H_RECEIPTS | CJAMOUNT | CJAMT | CURR | 15 | 2 | Cash Journal Amount Field with +/- Sign | ||
7 | H_PAYMENTS | CJAMOUNT | CJAMT | CURR | 15 | 2 | Cash Journal Amount Field with +/- Sign | ||
8 | H_NET_AMOUNT | CJNET_AMOUNT | WERTV7 | CURR | 13 | 2 | Cash Journal Document Net Amount - Document Currency | ||
9 | H_NET_PAYMENT_WT | CJNET_PAYMENT_WT | CJAMT | CURR | 15 | 2 | Net Payment Amount (Withholding Tax Deducted) | ||
10 | H_TOTAL_AMOUNT | CJAMOUNT | CJAMT | CURR | 15 | 2 | Cash Journal Amount Field with +/- Sign | ||
11 | H_TAX_AMOUNT | FWSTE | 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_CODE | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | T007A | |
20 | TAX_PERCENT | MSATZ_F05L | PRZ43V | DEC | 7 | 3 | Tax rate | ||
21 | TRANSACT_NAME | CJTRANSTXT | CHAR_25 | CHAR | 25 | 0 | Cash Journal Business Transaction | ||
22 | POSITION_TEXT | CJPOSTEXT | TEXT50 | CHAR | 50 | 0 | Cash Journal Line Item Text | ||
23 | PROCESS_STATUS | CJDOCSTAT | CJDOCSTAT | CHAR | 2 | 0 | Cash Journal Entry Document Status | ||
24 | VENDOR_NO | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | LFA1 | |
25 | CUSTOMER | KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | KNA1 | |
26 | D_POSTING_NUMB | CJBELNR_DISP | BELNR | CHAR | 10 | 0 | Cash Journal Document Number for Display | ||
27 | TEMP_POSTING_NUMB | CJBELNR_TEMP | BELNR | CHAR | 10 | 0 | Temporary Number for Cash Journal Document | ||
28 | .INCLUDE | 0 | 0 | Include with Additional Account Assignments for DB Tables | |||||
29 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
30 | PARGB | PARGB | GSBER | CHAR | 4 | 0 | Trading partner's business area | * | |
31 | VBUND | RASSC | RCOMP | CHAR | 6 | 0 | Company ID of trading partner | * | |
32 | RMVCT | RMVCT | RMVCT | CHAR | 3 | 0 | Transaction type | * | |
33 | FKBER | FKBER | FKBER | CHAR | 16 | 0 | Functional Area | * | |
34 | KOKRS | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | * | |
35 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
36 | LSTAR | LSTAR | LSTAR | CHAR | 6 | 0 | Activity Type | * | |
37 | AUFNR | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
38 | AFPOS | CO_POSNR | CO_POSNR | NUMC | 4 | 0 | Order item number | ||
39 | BEMOT | BEMOT | BEMOT | CHAR | 2 | 0 | Accounting Indicator | * | |
40 | KSTRG | KSTRG | KSTRG | CHAR | 12 | 0 | Cost Object | * | |
41 | PRZNR | CO_PRZNR | CO_PRZNR | CHAR | 12 | 0 | Business Process | * | |
42 | PRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | * | |
43 | PPRCTR | PPRCTR | PRCTR | CHAR | 10 | 0 | Partner Profit Center | * | |
44 | PS_PSP_PNR | PS_PSP_PNR | PS_POSNR | NUMC | 8 | 0 | Work Breakdown Structure Element (WBS Element) | * | |
45 | NPLNR | NPLNR | AUFNR | CHAR | 12 | 0 | Network Number for Account Assignment | * | |
46 | VORNR | VORNR | VORNR | CHAR | 4 | 0 | Operation/Activity Number | ||
47 | ANLN1 | BF_ANLN1 | BF_ANLN1 | CHAR | 12 | 0 | Main Asset Number | ||
48 | ANLN2 | BF_ANLN2 | BF_ANLN2 | CHAR | 4 | 0 | Asset Subnumber | ||
49 | BZDAT | BF_BZDAT | DATUM | DATS | 8 | 0 | Reference date | ||
50 | ANBWA | BF_ANBWA | CHAR3 | CHAR | 3 | 0 | Asset transaction type | ||
51 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
52 | BWTAR | BWTAR_D | BWTAR | CHAR | 10 | 0 | Valuation type | * | |
53 | BWKEY | BWKEY | BWKEY | CHAR | 4 | 0 | Valuation area | * | |
54 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
55 | HRKFT | HRKFT | HRKFT | CHAR | 4 | 0 | Origin Group as Subdivision of Cost Element | * | |
56 | HKMAT | HKMAT | HKMAT | CHAR | 1 | 0 | Material-related origin | ||
57 | KDAUF | KDAUF | VBELN | CHAR | 10 | 0 | Sales Order Number | * | |
58 | KDEIN | KDEIN | NUM04 | NUMC | 4 | 0 | Delivery schedule for sales order | ||
59 | KDPOS | KDPOS | NUM06 | NUMC | 6 | 0 | Item number in Sales Order | ||
60 | VNAME | JV_NAME | JV_NAME | CHAR | 6 | 0 | Joint venture | * | |
61 | RECID | JV_RECIND | JV_RECIND | CHAR | 2 | 0 | Recovery Indicator | * | |
62 | RECID_MAN | JV_RECID_M | XFELD | CHAR | 1 | 0 | Indicator: Recovery Indicator Set Manually. | ||
63 | EGRUP | JV_EGROUP | JV_EGROUP | CHAR | 3 | 0 | Equity group | * | |
64 | ETYPE | JV_ETYPE | JV_ETYPE | CHAR | 3 | 0 | Equity type | * | |
65 | VPTNR | JV_PART | KUNNR | CHAR | 10 | 0 | Partner account number | * | |
66 | CONDI | JV_CONDCOD | JV_CONDCOD | CHAR | 2 | 0 | Joint Venture Indicator (Condition Key) | * | |
67 | CRPCAL | JV_CRPCAL | XFELD | CHAR | 1 | 0 | Flag CRP Calculation: Yes or NO | ||
68 | FIKRS | FIKRS | FIKRS | CHAR | 4 | 0 | Financial Management Area | * | |
69 | FISTL | FISTL | FISTL | CHAR | 16 | 0 | Funds Center | * | |
70 | FIPOS | FIPOS | FIPOS | CHAR | 14 | 0 | Commitment Item | * | |
71 | FIPEX | FM_FIPEX | FM_FIPEX | CHAR | 24 | 0 | Commitment item | * | |
72 | GEBER | BP_GEBER | BP_GEBER | CHAR | 10 | 0 | Fund | * | |
73 | KBLNR | KBLNR_FI | KBLNR | CHAR | 10 | 0 | Document number for earmarked funds | * | |
74 | KBLPOS | KBLPOS | KBLPOS | NUMC | 3 | 0 | Earmarked Funds: Document Item | * | |
75 | ERLKZ | REFSETERLK | CHAR1_X | CHAR | 1 | 0 | Used earmarked funds set to "Complete" | ||
76 | PERNR | PERNR_D | PERNR | NUMC | 8 | 0 | Personnel Number | ||
77 | PAOBJNR | RKEOBJNR | RKEOBJNR | NUMC | 10 | 0 | Profitability Segment Number (CO-PA) | ||
78 | IMKEY | IMKEY | IMKEY | CHAR | 8 | 0 | Internal Key for Real Estate Object | ||
79 | KONTT | KONTT_FI | KONTT_FI | CHAR | 2 | 0 | Account Assignment Category for Industry Solution | ||
80 | KONTL | KONTL_FI | CHAR50 | CHAR | 50 | 0 | Acct assignment string for industry-specific acct assignmnts | ||
81 | .INCLUDE | 0 | 0 | ||||||
82 | SMIVE | SMIVE | VVSMIVE | CHAR | 13 | 0 | Lease-Out Number | ||
83 | GRANT_NBR | GM_GRANT_NBR | GM_GRANT_NBR | CHAR | 20 | 0 | Grant | ||
84 | DABRZ | DABRBEZ | DDAT | DATS | 8 | 0 | Reference date for settlement | ||
85 | BUDGET_PD | FM_BUDGET_PERIOD | FM_BUDGET_PERIOD | CHAR | 10 | 0 | FM: Budget Period | * | |
86 | TAXJURCODE | TXJCD | TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | TTXJ | |
87 | TEXT1 | CJDOCTEXT100 | TEXT100 | CHAR | 100 | 0 | Additional Field 1 for Cash Journal Document Header | ||
88 | TEXT2 | CJDOCTEXT30 | TEXT30 | CHAR | 30 | 0 | Additional Field 2 for Cash Journal Document Header | ||
89 | LINE_NUMBER | CJLINENUMB | TABIX | INT4 | 10 | 0 | Line Number in Cash Journal Document Table | ||
90 | MEANS_OF_PAYMENT | CJMOFPAYM | CJMOP | CHAR | 1 | 0 | Cash Journal Means of Payment | ||
91 | CHECK_NUMBER | SCKNR_EB | NUMC13 | NUMC | 13 | 0 | 13-digit check number | ||
92 | CHECK_ISSUER | CJCHECKISSUER | TEXT14 | CHAR | 14 | 0 | Check Issuer (Cash Journal) | ||
93 | BANK_KEY | BANKK | BANKK | CHAR | 15 | 0 | Bank Keys | BNKA | |
94 | BANK_ACCT | BANKN | BANKN | CHAR | 18 | 0 | Bank account number | ||
95 | BANK_CTRY | BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | T005 | |
96 | CHECK_STACK | CJCHECKSTACK | CHAR8 | CHAR | 8 | 0 | Number of Check Lot in Cash Journal | ||
97 | CHECK_STATUS | CJCHECKSTATUS | CJCHSTAT | CHAR | 1 | 0 | Posting Status for Checks in Cash Journal | ||
98 | CHECK_FY | CJCHECKSTACKFY | GJAHR | NUMC | 4 | 0 | Fiscal Year of Check Deposit | ||
99 | TEXT | CJCJTEXT30 | TEXT30 | CHAR | 30 | 0 | Additional Field for Cash Journal | ||
100 | VALUTA_DATE | VALUT | DATUM | DATS | 8 | 0 | Fixed Value Date | ||
101 | ALLOC_NMBR | DZUONR | ZUONR | CHAR | 18 | 0 | Assignment number | ||
102 | LINE_SEL | BOOLEAN | BOOLEAN | CHAR | 1 | 0 | Boolean Variable (X=True, -=False, Space=Unknown) | ||
103 | BRANCH | FILKD | MAXKK | CHAR | 10 | 0 | Account Number of the Branch | ||
104 | REVBELNR | CJREVBELNR | BELNR | CHAR | 10 | 0 | Reversal Document Number for Cash Journal Document | ||
105 | EXCH_RATE | KURSF | KURSF | DEC | 9 | 5 | Exchange rate | ||
106 | BUPLA | BUPLA | J_1BBRANCH | CHAR | 4 | 0 | Business Place | * | |
107 | SECCO | SECCO | SECCO | CHAR | 4 | 0 | Section Code | * | |
108 | POSITION_NUMBER | CJBUZEI | BUZEI | NUMC | 3 | 0 | Number of Line Item within Cash Journal Document | ||
109 | POSITION_TYPE | CJPOSTYPE | CJPOSTYPE | CHAR | 2 | 0 | Cash Journal Item Type | ||
110 | P_RECEIPTS | CJAMOUNT | CJAMT | CURR | 15 | 2 | Cash Journal Amount Field with +/- Sign | ||
111 | P_PAYMENTS | CJAMOUNT | CJAMT | CURR | 15 | 2 | Cash Journal Amount Field with +/- Sign | ||
112 | P_NET_AMOUNT | CJNET_AMOUNT | WERTV7 | CURR | 13 | 2 | Cash Journal Document Net Amount - Document Currency | ||
113 | P_NET_PAYMENT_WT | CJNET_PAYMENT_WT | CJAMT | CURR | 15 | 2 | Net Payment Amount (Withholding Tax Deducted) | ||
114 | P_TAX_AMOUNT | WMWST | WERT7 | CURR | 13 | 2 | Tax amount in document currency | ||
115 | SPLIT | CJDOCSPLIT | CJDSPLIT | CHAR | 1 | 0 | Split Information for Cash Journal Document | ||
116 | LZBKZ | LZBKZ | LZBKZ | CHAR | 3 | 0 | State central bank indicator | T015L | |
117 | LANDL | LANDL | LAND1 | CHAR | 3 | 0 | Supplying Country | T005 | |
118 | P_FWBAS | FWBAS | WERT7 | CURR | 13 | 2 | Tax Base Amount in Document Currency | ||
119 | GL_ACCOUNT | HKONT | SAKNR | CHAR | 10 | 0 | General Ledger Account | SKB1 | |
120 | SEGMENT | FB_SEGMENT | FB_SEGMENT | CHAR | 10 | 0 | Segment for Segmental Reporting | FAGL_SEGM | |
121 | PSEGMENT | FB_PSEGMENT | FB_SEGMENT | CHAR | 10 | 0 | Partner Segment for Segmental Reporting | FAGL_SEGM | |
122 | VATDATE | VATDATE | DATUM | DATS | 8 | 0 | Tax Reporting Date | ||
123 | MAN_TAX | BOOLEAN | BOOLEAN | CHAR | 1 | 0 | Boolean Variable (X=True, -=False, Space=Unknown) | ||
124 | STCEG | STCEG | STCEG | CHAR | 20 | 0 | VAT Registration Number | ||
125 | UMSKZ | UMSKZ | UMSKZ | CHAR | 1 | 0 | Special G/L Indicator | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ISCJ_R_POSTINGS | BANK_CTRY | T005 | LAND1 | |||
2 | ISCJ_R_POSTINGS | BANK_KEY | BNKA | BANKL | |||
3 | ISCJ_R_POSTINGS | CUSTOMER | KNA1 | KUNNR | |||
4 | ISCJ_R_POSTINGS | GL_ACCOUNT | SKB1 | SAKNR | |||
5 | ISCJ_R_POSTINGS | LANDL | T005 | LAND1 | |||
6 | ISCJ_R_POSTINGS | LZBKZ | T015L | LZBKZ | |||
7 | ISCJ_R_POSTINGS | PSEGMENT | FAGL_SEGM | SEGMENT | |||
8 | ISCJ_R_POSTINGS | SEGMENT | FAGL_SEGM | SEGMENT | |||
9 | ISCJ_R_POSTINGS | TAXJURCODE | TTXJ | TXJCD | |||
10 | ISCJ_R_POSTINGS | TAX_CODE | T007A | MWSKZ | |||
11 | ISCJ_R_POSTINGS | VENDOR_NO | LFA1 | LIFNR |
History
Last changed by/on | SAP | 20131127 |
SAP Release Created in |