SAP ABAP Table J_1IACCBAL (Structure for storing account no and balance)
Hierarchy
SAP_APPL (Software Component) Logistics and Accounting
   FI-LOC (Application Component) Localization
     J1I2 (Package) India, Phase II
Basic Data
Table Category INTTAB    Structure 
Structure J_1IACCBAL   Table Relationship Diagram
Short Description Structure for storing account no and balance    
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 J_1IACCNAM J_1IACCNAM J_1IACCNAM CHAR 10   0   Account Name  
2 J_1IACCTXT CHAR50 TEXT50 CHAR 50   0   Comment  
3 J_1IDCIND J_1IDCIND J_1IDCIND CHAR 2   0   Debit credit indicator  
4 J_1IACCNO SAKNR SAKNR CHAR 10   0   G/L Account Number *
5 J_1IGSBER GSBER GSBER CHAR 4   0   Business Area *
6 J_1IACCBAL J_1IACBALN CURR16 CURR 16   2   Total Account balance  
7 J_1IAMTALW J_1IALWAMT CURR16 CURR 16   2   Amount available for utilization  
8 J_1IPOSTAM J_1IPSTAMT WERT7 CURR 13   2   amount to be posted  
9 .INCLUDE       0   0   Coding Block  
10 .INCLUDE       0   0   Coding Block for External Applications (Not CO/FI)  
11 GLVOR GLVOR CHAR4 CHAR 4   0   Business Transaction  
12 VORGN VORGN VORGN CHAR 4   0   Transaction Type for General Ledger  
13 AWTYP AWTYP AWTYP CHAR 5   0   Reference procedure *
14 AWKEY AWKEY AWKEY CHAR 20   0   Object key  
15 AWSYS AWSYS LOGSYS CHAR 10   0   Logical system of source document *
16 AWPOS AWPOS AWPOS CHAR 10   0   Reference line item  
17 AWID AWID AWID CHAR 10   0   Reference document: Current identification  
18 BUDAT BUDAT DATUM DATS 8   0   Posting Date in the Document  
19 BLDAT BLDAT DATUM DATS 8   0   Document Date in Document  
20 BUKRS BUKRS BUKRS CHAR 4   0   Company Code *
21 GSBER GSBER GSBER CHAR 4   0   Business Area *
22 PARGB PARGB GSBER CHAR 4   0   Trading partner's business area *
23 VBUND RASSC RCOMP CHAR 6   0   Company ID of trading partner *
24 HKONT HKONT SAKNR CHAR 10   0   General Ledger Account *
25 KOART KOART KOART CHAR 1   0   Account type  
26 RMVCT RMVCT RMVCT CHAR 3   0   Transaction type *
27 KUNNR KUNNR KUNNR CHAR 10   0   Customer Number KNA1
28 LIFNR LIFNR LIFNR CHAR 10   0   Account Number of Vendor or Creditor LFA1
29 FKBER FKBER FKBER CHAR 16   0   Functional Area *
30 PFKBER SFKBER FKBER CHAR 16   0   Partner Functional Area *
31 KOKRS KOKRS CACCD CHAR 4   0   Controlling Area *
32 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center *
33 LSTAR LSTAR LSTAR CHAR 6   0   Activity Type *
34 AUFNR AUFNR AUFNR CHAR 12   0   Order Number *
35 AFPOS CO_POSNR CO_POSNR NUMC 4   0   Order item number  
36 BEMOT BEMOT BEMOT CHAR 2   0   Accounting Indicator *
37 KSTRG KSTRG KSTRG CHAR 12   0   Cost Object *
38 PRZNR CO_PRZNR CO_PRZNR CHAR 12   0   Business Process *
39 PRCTR PRCTR PRCTR CHAR 10   0   Profit Center *
40 PPRCTR PPRCTR PRCTR CHAR 10   0   Partner Profit Center *
41 PS_POSID PS_POSID PS_POSID CHAR 24   0   Work Breakdown Structure Element (WBS Element)  
42 NPLNR NPLNR AUFNR CHAR 12   0   Network Number for Account Assignment *
43 VORNR VORNR VORNR CHAR 4   0   Operation/Activity Number  
44 ANLN1 BF_ANLN1 BF_ANLN1 CHAR 12   0   Main Asset Number *
45 ANLN2 BF_ANLN2 BF_ANLN2 CHAR 4   0   Asset Subnumber *
46 BZDAT BF_BZDAT DATUM DATS 8   0   Reference date  
47 ANBWA BF_ANBWA CHAR3 CHAR 3   0   Asset transaction type *
48 WERKS WERKS_D WERKS CHAR 4   0   Plant *
49 BWTAR BWTAR_D BWTAR CHAR 10   0   Valuation type *
50 BWKEY BWKEY BWKEY CHAR 4   0   Valuation area T001K
51 MATNR MATNR MATNR CHAR 18   0   Material Number *
52 HRKFT HRKFT HRKFT CHAR 4   0   Origin Group as Subdivision of Cost Element *
53 HKMAT HKMAT HKMAT CHAR 1   0   Material-related origin  
54 WEUNB WEUNB XFELD CHAR 1   0   Goods Receipt, Non-Valuated  
55 KDAUF KDAUF VBELN CHAR 10   0   Sales Order Number *
56 KDEIN KDEIN NUM04 NUMC 4   0   Delivery schedule for sales order  
57 KDPOS KDPOS NUM06 NUMC 6   0   Item number in Sales Order  
58 EBELN EBELN EBELN CHAR 10   0   Purchasing Document Number *
59 EBELP EBELP EBELP NUMC 5   0   Item Number of Purchasing Document *
60 XNOGL XNOGL XFELD CHAR 1   0   Indicator:Business Transaction Does Not Create Posting in GL  
61 VNAME JV_NAME JV_NAME CHAR 6   0   Joint venture T8JV
62 RECID JV_RECIND JV_RECIND CHAR 2   0   Recovery Indicator T8JJ
63 RECID_MAN JV_RECID_M XFELD CHAR 1   0   Indicator: Recovery Indicator Set Manually.  
64 EGRUP JV_EGROUP JV_EGROUP CHAR 3   0   Equity group T8JF
65 ETYPE JV_ETYPE JV_ETYPE CHAR 3   0   Equity type T8JE
66 VPTNR JV_PART KUNNR CHAR 10   0   Partner account number KNA1
67 CONDI JV_CONDCOD JV_CONDCOD CHAR 2   0   Joint Venture Indicator (Condition Key) T8JX
68 CRPCAL JV_CRPCAL XFELD CHAR 1   0   Flag CRP Calculation: Yes or NO  
69 PRODPER JVA_PROD_DATE DATS DATS 8   0   Joint Venture Production Date  
70 FIKRS FIKRS FIKRS CHAR 4   0   Financial Management Area *
71 FISTL FISTL FISTL CHAR 16   0   Funds Center *
72 FIPEX FM_FIPEX FM_FIPEX CHAR 24   0   Commitment item *
73 FIPOS FIPOS FIPOS CHAR 14   0   Commitment Item *
74 GEBER BP_GEBER BP_GEBER CHAR 10   0   Fund *
75 KBLNR KBLNR_FI KBLNR CHAR 10   0   Document number for earmarked funds *
76 KBLPOS KBLPOS KBLPOS NUMC 3   0   Earmarked Funds: Document Item *
77 ERLKZ REFSETERLK CHAR1_X CHAR 1   0   Used earmarked funds set to "Complete"  
78 XAUTO XAUTO XFELD CHAR 1   0   Indicator: Line item automatically created  
79 XNETB XNETB XFELD CHAR 1   0   Indicator: Document posted net ?  
80 XNEKO XNEKO XFELD CHAR 1   0   Indicator: 'Auxiliary account assignment'  
81 KZBEW KZBEW KZBEW CHAR 1   0   Movement Indicator  
82 KZVBR KZVBR KZVBR CHAR 1   0   Consumption posting  
83 VBTYP VBTYP_BV TEXT1 CHAR 1   0   SD document category  
84 AUTYP AUFTYP AUFTYP NUMC 2   0   Order category  
85 PERNR PERNR_D PERNR NUMC 8   0   Personnel Number  
86 MAT_POSID PS_POSID PS_POSID CHAR 24   0   Work Breakdown Structure Element (WBS Element)  
87 MAT_KDAUF KDAUF VBELN CHAR 10   0   Sales Order Number *
88 MAT_KDPOS KDPOS NUM06 NUMC 6   0   Item number in Sales Order  
89 GRANT_NBR GM_GRANT_NBR GM_GRANT_NBR CHAR 20   0   Grant  
90 SEGMENT FB_SEGMENT FB_SEGMENT CHAR 10   0   Segment for Segmental Reporting *
91 PSEGMENT FB_PSEGMENT FB_SEGMENT CHAR 10   0   Partner Segment for Segmental Reporting *
92 XSEGM XSEGM XFELD CHAR 1   0   Segment Updated in Component  
93 XSEG_DER XSEG_DERIVE XFELD CHAR 1   0   Coding Block: Segment Derived  
94 XPSEG_DER XPSEG_DERIVE XFELD CHAR 1   0   Coding Block: Partner Segment Derived  
95 FM_SPLIT FMSP_SPLIT_RESULT_FLAG FLAG CHAR 1   0   Line is Result of Account Assignment Distribution  
96 FASTPAY FMFG_FASTPAY_FLG XFELD CHAR 1   0   PPA Fast Pay Indicator  
97 PPA_EX_IND EXCLUDE_FLG XFELD CHAR 1   0   PPA Exclude Indicator  
98 PEROP_BEG FM_PEROP_FI_LOW DATUM DATS 8   0   Billing Period of Performance Start Date  
99 PEROP_END FM_PEROP_FI_HIGH DATUM DATS 8   0   Billing Period of Performance End Date  
100 PGEBER FM_PFUND BP_GEBER CHAR 10   0   Partner Fund *
101 PGRANT_NBR GM_GRANT_PARTNER GM_GRANT_NBR CHAR 20   0   Partner Grant  
102 BUDGET_PD FM_BUDGET_PERIOD FM_BUDGET_PERIOD CHAR 10   0   FM: Budget Period *
103 PBUDGET_PD FM_PBUDGET_PERIOD FM_BUDGET_PERIOD CHAR 10   0   FM: Partner Budget Period *
104 VORNR_AUF VORNR_AUF VORNR CHAR 4   0   Operation Number  
105 CRM_PAYMENT_TYPE GTR_CRM_PAYMENT_TYPE GTR_CRM_PAYMENT_TYPE CHAR 4   0   Payment Type for Grantor  
106 CRM_EXPENSE_TYPE GTR_CRM_EXPENSE_CAT GTR_CRM_EXPENSE_CAT CHAR 4   0   Expense Type for Grantor  
107 PROG_PROFILE GTR_CRM_PROG_PROFILE   CHAR 10   0   Grantor Program Profile  
108 .INCLUDE       0   0    
109 .INCLUDE       0   0   Coding Block - Special Fields for RW / LO  
110 PROCESS PROCE CHAR8 CHAR 8   0   Transaction for which CO interface is accessed  
111 EVENT EVENT CHAR8 CHAR 8   0   Time at which the RW interface is called up  
112 GJAHR GJAHR GJAHR NUMC 4   0   Fiscal Year  
113 MONAT MONAT MONAT NUMC 2   0   Fiscal period  
114 BUZEI BUZEI BUZEI NUMC 3   0   Number of Line Item Within Accounting Document  
115 BLART BLART BLART CHAR 2   0   Document type T003
116 BSCHL BSCHL BSCHL CHAR 2   0   Posting Key TBSL
117 SAKNR SAKNR SAKNR CHAR 10   0   G/L Account Number SKA1
118 BWART BWART BWART CHAR 3   0   Movement type (inventory management) T156
119 BKLAS BKLAS BKLAS CHAR 4   0   Valuation Class T025
120 MENGE MENGE_D MENG13 QUAN 13   3   Quantity  
121 MEINS MEINS MEINS UNIT 3   0   Base Unit of Measure T006
122 WWERT WWERT_D DATUM DATS 8   0   Translation date  
123 WAERS WAERS WAERS CUKY 5   0   Currency Key TCURC
124 DMBTR DMBTR WERT7 CURR 13   2   Amount in local currency  
125 BUDST BUDST BUDST CHAR 16   0   Budget center  
126 BUPOS BUPOS BUPOS CHAR 14   0   Budget item  
127 RANL RANL RANL CHAR 13   0   Contract Number  
128 RANTYP RANTYP RANTYP CHAR 1   0   Contract Type  
129 IMKEY IMKEY IMKEY CHAR 8   0   Internal Key for Real Estate Object  
130 INTRENO VVINTRENO VVINTRENO CHAR 13   0   Internal Real Estate Master Data Code  
131 ZEKKN DZEKKN NUM02 NUMC 2   0   Sequential Number of Account Assignment  
132 PAOBJNR RKEOBJNR RKEOBJNR NUMC 10   0   Profitability Segment Number (CO-PA)  
133 PASUBNR RKESUBNR RKESUBNR NUMC 4   0   Profitability Segment Changes (CO-PA)  
134 AUFPL CO_AUFPL AUFPL NUMC 10   0   Routing number of operations in the order  
135 APLZL CIM_COUNT CIM_COUNT NUMC 8   0   Internal counter  
136 STAGR STAGR STAGR CHAR 6   0   Statistical key figure *
137 TXJCD TXJCD TXJCD CHAR 15   0   Tax Jurisdiction TTXJ
138 EKOPI EKOPI YNFLG CHAR 1   0   Indicator: Commitment management for acct assgn. obj. active  
139 FKART FKART FKART CHAR 4   0   Billing Type TVFK
140 VKORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
141 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVTW
142 SPART SPART SPART CHAR 2   0   Division TSPA
143 VALUSER VALUSER VALUSER CHAR 2   0   Validation/substitution application area GB03
144 SUBSTID SUBST_ID SUBSTID CHAR 7   0   Substitution name GB92
145 VALID VALID VALIDATION CHAR 7   0   Validation GB93
146 XMEFO XMEFO XFELD CHAR 1   0   Do Not Update Quantity  
147 SHKZG SHKZG SHKZG CHAR 1   0   Debit/Credit Indicator  
148 BEKNZ BEKNZ BEKNZ CHAR 1   0   Debit/credit indicator  
149 WRBTR WRBTR WERT7 CURR 13   2   Amount in document currency  
150 LNRAN LNRAN LNRAN NUMC 5   0   Sequence Number of Asset Line Items in Fiscal Year ANEK
151 REBZG REBZG BELNR CHAR 10   0   Number of the Invoice the Transaction Belongs to  
152 AUGBL AUGBL BELNR CHAR 10   0   Document Number of the Clearing Document  
153 KZBWS KZBWS KZBWS CHAR 1   0   Valuation of Special Stock  
154 SOBKZ SOBKZ SOBKZ CHAR 1   0   Special Stock Indicator T148
155 BELTP BP_INOUT BP_INOUT NUMC 1   0   Debit type  
156 MWSTS MWSTS WERT7 CURR 13   2   Tax Amount in Local Currency  
157 WMWST WMWST WERT7 CURR 13   2   Tax amount in document currency  
158 PRVRG_SV PRVRG_SV J_VORGANG CHAR 4   0   Business transaction for status management TJ01
159 XANET XANET XFELD CHAR 1   0   Indicator: Down Payment in Net Procedure?  
160 REBZJ REBZJ GJAHR NUMC 4   0   Fiscal Year of the Relevant Invoice (for Credit Memo)  
161 REBZZ REBZZ BUZEI NUMC 3   0   Line Item in the Relevant Invoice  
162 DMBE2 DMBE2 WERT7 CURR 13   2   Amount in Second Local Currency  
163 DMBE3 DMBE3 WERT7 CURR 13   2   Amount in Third Local Currency  
164 MWST2 MWST2 WERT7 CURR 13   2   Tax Amount in Second Local Currency  
165 MWST3 MWST3 WERT7 CURR 13   2   Tax Amount in Third Local Currency  
166 DABRZ DABRBEZ DDAT DATS 8   0   Reference date for settlement  
167 UMSKS UMSKS UMSKS CHAR 1   0   Special G/L Transaction Type  
168 BUZID BUZID CHAR1 CHAR 1   0   Identification of the Line Item  
169 XVALE XVALE XFELD CHAR 1   0   Indicator: Sent by ALE for distributed systems  
170 XAKON XAKON CHAR1 CHAR 1   0   Indicator: CO account assignment field filled automatically  
171 XBLNR XBLNR1 XBLNR1 CHAR 16   0   Reference Document Number  
172 KTOSL KTOSL CHAR3 CHAR 3   0   Transaction Key  
173 VERID VERID VERID CHAR 4   0   Production Version *
174 KONTT KONTT_FI KONTT_FI CHAR 2   0   Account Assignment Category for Industry Solution  
175 KONTL KONTL_FI CHAR50 CHAR 50   0   Acct assignment string for industry-specific acct assignmnts  
176 SCOPE SCOPE_CV SCOPE_CV CHAR 2   0   Object Class  
177 BVALTNR CKML_ALPROCNR CK_KALNR NUMC 12   0   Procurement alternative/process *
178 KALN1 CK_KALNR1 CK_KALNR NUMC 12   0   Cost Estimate Number - Product Costing *
179 AUFNR_ORG CK_AUFNR_ORG AUFNR CHAR 12   0   Original Order Number AUFK
180 OBJNR_REAL J_OBJNR_REAL J_OBJNR CHAR 22   0   Object number of real CO account assignment *
181 RLDNR RLDNR RLDNR CHAR 2   0   Ledger *
182 LDGRP FAGL_LDGRP FAGL_LDGRP CHAR 4   0   Ledger Group *
183 .INCLUDE       0   0   Assignment types for CO account assignments  
184 CO_KAKST CO_KAKST CO_KONTKZ NUMC 1   0   Account Assignment Type: Cost Center  
185 CO_KAAUF CO_KAAUF CO_KONTKZ NUMC 1   0   Account assignment type: Order  
186 CO_KAPRO CO_KAPRO CO_KONTKZ NUMC 1   0   Project account assignment type  
187 CO_KAKTR CO_KAKTR CO_KONTKZ NUMC 1   0   Account Assignment Type: Cost Object  
188 CO_KANPL CO_KANPL CO_KONTKZ NUMC 1   0   Account Assignment Type: Network  
189 CO_KAIMO CO_KAIMO CO_KONTKZ NUMC 1   0   Account Assignment Type: Real Estate Object  
190 CO_KAKDA CO_KAKDA CO_KONTKZ NUMC 1   0   Account Assignment Type: Sales Order  
191 CO_KAERG CO_KAERG CO_KONTKZ NUMC 1   0   Business segment account assignment type  
192 CO_KAABS CO_KAABS CO_KONTKZ NUMC 1   0   Account assignment type: reconciliation object  
193 CO_KAPRZ CO_KAPRZ CO_KONTKZ NUMC 1   0   Account Assignment Type: Business Process  
194 CO_KASAT CO_KASAT CO_KONTKZ NUMC 1   0   Account Assignment Type Not Used  
195 STFLG CO_STFLG FLAG CHAR 1   0   Identifier for reversal document  
196 PS_PSP_PNR PS_PSP_PNR PS_POSNR NUMC 8   0   Work Breakdown Structure Element (WBS Element) *
197 MAT_PSPNR PS_PSP_PNR PS_POSNR NUMC 8   0   Work Breakdown Structure Element (WBS Element) *
198 .INCLU--AP       0   0   Additional Fields for FM  
199 GLUPM GLUPM GLUPM CHAR 1   0   Update Method for FM - FI-CA Integration  
200 MEASURE FM_MEASURE FM_MEASURE CHAR 24   0   Funded Program *
201 .INCLU--AP       0   0   COBL Append for FM Federal Goberment  
202 FMFGUS_KEY FMFG_US_KEY SYSUUID_22 CHAR 22   0   United States Federal Government Fields  
203 .INCLU--AP       0   0   Funds Management Actual Data Reference Document (COBL)  
204 FMXDOCNR FM_XDOCNR BELNR CHAR 10   0   FM Reference Document Number  
205 FMXYEAR FM_XYEAR GJAHR NUMC 4   0   FM Reference Year  
206 FMXDOCLN FM_XDOCLN NUMC6 NUMC 6   0   FM Reference Line Item  
207 FMXZEKKN FM_XZEKKN NUMC5 NUMC 5   0   FM Reference Sequence Account Assignment  
208 .INCLU--AP       0   0   VstBerichtigung: Zusatzfelder  
209 .INCLUDE       0   0   VstBerichtigung: Zusatzfelder  
210 TCOBJNR J_OBJNR J_OBJNR CHAR 22   0   Object number *
211 DATEOFSERVICE VVBEACTDATE DATUM DATS 8   0   Date of Service  
212 NOTAXCORR VVREITNOTAXCORR BOOLE CHAR 1   0   Do Not Consider Item in Input Tax Correction  
213 DIFFOPTRATE POPTSATZ POPTSATZ DEC 9   6   Real Estate Option Rate  
214 HASDIFFOPTRATE VVREITUSEDIFFOPTRATE BOOLE CHAR 1   0   Use Different Option Rate  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 J_1IACCBAL AUFNR_ORG AUFK AUFNR REF 1 CN
2 J_1IACCBAL BKLAS T025 BKLAS    
3 J_1IACCBAL BLART T003 BLART    
4 J_1IACCBAL BSCHL TBSL BSCHL    
5 J_1IACCBAL BWART T156 BWART    
6 J_1IACCBAL BWKEY T001K BWKEY    
7 J_1IACCBAL CONDI T8JX CONDCODE REF 1 CN
8 J_1IACCBAL EGRUP T8JF EGRUP    
9 J_1IACCBAL ETYPE T8JE ETYPE    
10 J_1IACCBAL FKART TVFK FKART    
11 J_1IACCBAL KUNNR KNA1 KUNNR    
12 J_1IACCBAL LIFNR LFA1 LIFNR    
13 J_1IACCBAL LNRAN ANEK LNRAN    
14 J_1IACCBAL MEINS T006 MSEHI    
15 J_1IACCBAL PRVRG_SV TJ01 VRGNG REF C CN
16 J_1IACCBAL RECID T8JJ RECID    
17 J_1IACCBAL SAKNR SKA1 SAKNR    
18 J_1IACCBAL SOBKZ T148 SOBKZ    
19 J_1IACCBAL SPART TSPA SPART    
20 J_1IACCBAL SUBSTID GB92 SUBSTID    
21 J_1IACCBAL TXJCD TTXJ TXJCD    
22 J_1IACCBAL VALID GB93 VALID    
23 J_1IACCBAL VALUSER GB03 VALUSER    
24 J_1IACCBAL VKORG TVKO VKORG    
25 J_1IACCBAL VNAME T8JV VNAME    
26 J_1IACCBAL VPTNR KNA1 KUNNR    
27 J_1IACCBAL VTWEG TVTW VTWEG    
28 J_1IACCBAL WAERS TCURC WAERS    
History
Last changed by/on SAP  20140121 
SAP Release Created in