SAP ABAP Table FKKJOURNAL_ALV (Document Journal: ALV List)

Hierarchy

☛

FI-CA (Software Component) FI-CA
⤷

FI-CA (Application Component) Contract Accounts Receivable and Payable
⤷

FKKB (Package) Contract A/R & A/P: Central Objects

Basic Data

Table Category	INTTAB	Structure
Structure	FKKJOURNAL_ALV	Table Relationship Diagram
Short Description	Document Journal: ALV List

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	FIKEY	FIKEY_KK	FIKEY_KK	CHAR	12	0	Reconciliation Key for General Ledger	*
2	OPBEL	OPBEL_KK	OPBEL_KK	CHAR	12	0	Number of Contract Accts Rec. & Payable Doc.	*
3	OPPOS	OPPOS_KK	OPPOS_KK	CHAR	2	0	Item Category
4	OPUPW	OPUPW_KK	OPUPW_KK	NUMC	3	0	Repetition Item in Contract Account Document
5	OPUPK	OPUPK_KK	OPUPK_KK	NUMC	4	0	Item number in contract account document
6	OPUPZ	OPUPZ_KK	OPUPZ_KK	NUMC	3	0	Subitem for a Partial Clearing in Document
7	OPAUG	OPAUG_KK	OPAUG_KK	CHAR	1	0	Clearing Status
8	FIKST	FIKST_KK	FIKST_KK	CHAR	1	0	Status of Summary Records for Reconciliation Key
9	SUMSZ	SUMSZ_KK	INT4	INT4	10	0	Number of Summary Records for Reconciliation Key
10	CPUDT	CPUDT_KK	DATUM	DATS	8	0	Date of entry (CPU date)
11	XERRO	XERRO_KK	XFELD	CHAR	1	0	Table DFKKSUM Not Completely Updated
12	KORLV	KORLV_KK	NUM02	NUMC	2	0	Highest assigned correction level
13	UEBIS	UEBIS_KK	DATUM	DATS	8	0	Posting Date Up To Which Data Was Transferred To G/L
14	UEKLV	UEKLV_KK	NUM02	NUMC	2	0	Transferred Up To Correction Level
15	XUEVO	XUEVO_KK	XFELD	CHAR	1	0	Transfer all data to general ledger
16	XCLOS	XCLOS_KK	XFELD	CHAR	1	0	No Further Postings Allowed
17	RESOB	RESOB_KK	RESOB_KK	CHAR	3	0	Object for Which the Reconciliation Key is Reserved
18	RESKY	RESKY_KK	CHAR30	CHAR	30	0	Object for Which the Reconciliation Key is Reserved
19	XARCH	XARCH_KK	XFELD	CHAR	1	0	Documents Already Archived
20	USNAM	USNAM_KK	USNAM	CHAR	12	0	Name of the User who Created the Reconciliation Key
21	CLDAT	CLDAT_KK	DATUM	DATS	8	0	Date on which the Reconciliation Key was Closed
22	CLTIM	CLTIM_KK	UZEIT	TIMS	6	0	Time at which the Reconciliation Key was Closed
23	CLNAM	CLNAM_KK	UNAME	CHAR	12	0	User who Closed the Reconciliation Key
24	UECPU	UECPU_KK	DATUM	DATS	8	0	CPU date of the last transfer run
25	BLCNT	BLCNT_KK	NUM07	NUMC	7	0	Counter for documents transferred to G/L
26	COCNT	COCNT_KK	NUM07	NUMC	7	0	Number of Accounting Calls for CO-PA
27	XUECOPA	XUECOPA_KK	XUECOPA_KK	CHAR	1	0	Data Transferred to Profitability Analysis (CO-PA)
28	XMISS	XMISS_KK	XFELD	CHAR	1	0	Not all documents are contained in the totals
29	COMPLETE	COMPLETE_KK	COMPLETE_KK	CHAR	1	0	Status Of Detail Structures For Reconciliation Key
30	XEXTKONT	XEXTKONT_KK	BOOLE	CHAR	1	0	Adjustments Allowed When Transferring To General Ledger
31	XKORR	XKORR_KK	XFELD	CHAR	1	0	Reconciliation Key Corrected with RFKKGL20
32	UEBPANR	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
33	UEBPADAT	DATUM	DATUM	DATS	8	0	Date
34	STATI	STATI_KK	ICON	CHAR	4	0	Status Icon	*
35	APPLK	APPLK_KK	APPLK_KK	CHAR	1	0	Application area
36	BLART	BLART_KK	BLART_KK	CHAR	2	0	Document Type	*
37	HERKF	HERKF_KK	HERKF_KK	CHAR	2	0	Document Origin Key	*
38	CPUTM	CPUTM	UZEIT	TIMS	6	0	Time of data entry
39	ERNAM	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
40	WAERS	BLWAE_KK	WAERS	CUKY	5	0	Transaction Currency	*
41	WWERT	WWERT_D	DATUM	DATS	8	0	Translation date
42	XBLNR	XBLNR_KK	XBLNR_KK	CHAR	16	0	Reference document number
43	RLGRD	RLGRD_KK	RLGRD_KK	CHAR	3	0	Return reason	*
44	ABGRD	BUGRD_KK	BUGRD_KK	CHAR	2	0	Posting Reason (For Write-Offs And Transfer Postings)
45	XEIBH	XEIBH_KK	XFELD	CHAR	1	0	Create Separate Document in General Ledger
46	XBWER	XBWER_KK	XBWER_KK	CHAR	1	0	Document Created by Foreign Currency Valuation or Reclass.
47	AWTYP	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
48	AWKEY	AWKEY	AWKEY	CHAR	20	0	Object key
49	STBEL	STBEL_KK	OPBEL_KK	CHAR	12	0	Number of Reversed Document	*
50	STMET	STMET_INT_KK	STMET_INT_KK	CHAR	1	0	Reversal Method Selected Internally
51	BLTYP	BLTYP_KK	BLTYP_KK	CHAR	1	0	Document Class
52	AGINF	AGINF_KK	AGINF_KK	CHAR	1	0	Clearing Information
53	STBUK	STBUK_KK	BUKRS	CHAR	4	0	Tax Company Code	*
54	STORB	STORB_KK	OPBEL_KK	CHAR	12	0	Number of Reversal Document	*
55	APPDX	APPDX_KK	APPDX_KK	CHAR	1	0	Existing document supplements
56	XMBEL	XMBEL_KK	XFELD	CHAR	1	0	Sample document
57	AWSYS	AWSYS	LOGSYS	CHAR	10	0	Logical system of source document	*
58	VERSN	VERSN_KK	CHAR3	CHAR	3	0	Version Number
59	BRANCH	J_1BBRANC_	J_1BBRANCH	CHAR	4	0	Business Place	*
60	C4EYE	C4EYE_KK	C4EYE_KK	CHAR	2	0	Check Reason for Workflows Acc. to Dual Control Principle	*
61	C4EYP	C4EYP_KK	C4EYP_KK	CHAR	1	0	Editing Process To Be Confirmed
62	TATYP	TATYP_KK	TATYP_KK	CHAR	1	0	Transaction Class of Document
63	HBBLA	HBBLA_KK	BLART	CHAR	2	0	Document Type for Transfer to General Ledger	*
64	BUKRS	BUKRS	BUKRS	CHAR	4	0	Company Code	*
65	GSBER	GSBER	GSBER	CHAR	4	0	Business Area	*
66	BUPLA	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place	*
67	SEGMENT	SEGMT_KK	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	*
68	AUGST	AUGST_KK	AUGST_KK	CHAR	1	0	Clearing status
69	GPART	GPART_KK	BU_PARTNER	CHAR	10	0	Business Partner Number	*
70	GPARTT	GPTXT_KK	GPTXT_KK	CHAR	55	0	Text for business partner
71	VTREF	VTREF_KK	VTREF_KK	CHAR	20	0	Reference Specifications from Contract
72	VTRE2	VTRE2_KK	VTREF_KK	CHAR	20	0	Additional Reference Information
73	VKONT	VKONT_KK	VKONT_KK	CHAR	12	0	Contract Account Number	*
74	ABWBL	ABWBL_KK	ABWBL_KK	CHAR	12	0	Number of the substitute FI-CA document
75	ABWTP	ABWTP_KK	ABWTP_KK	CHAR	1	0	Category of substitute document in FI-CA
76	ABWKT	ABWVK_KK	VKONT_KK	CHAR	12	0	Alternative contract account for collective bills	*
77	HVORG	HVORG_KK	HVORG_KK	CHAR	4	0	Main Transaction for Line Item	*
78	TVORG	TVORG_KK	TVORG_KK	CHAR	4	0	Subtransaction for Document Item	*
79	KOFIZ	KOFIZ_KK	KOFIZ_KK	CHAR	2	0	Account Determination ID
80	SPART	SPART_KK	SPART	CHAR	2	0	Division	*
81	HKONT	HKONT_KK	SAKNR	CHAR	10	0	General ledger account	*
82	MWSKZ	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
83	MWSZKZ	MWSZKZ_KK	MWSKZ	CHAR	2	0	Supplementary Tax	*
84	XANZA	XANZA_KK	XFELD	CHAR	1	0	Item is a Down Payment/Down Payment Request
85	STAKZ	STAKZ_KK	STAKZ_KK	CHAR	1	0	Type of statistical item
86	BLDAT	BLDAT	DATUM	DATS	8	0	Document Date in Document
87	BUDAT	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
88	OPTXT	OPTXT_KK	TEXT50	CHAR	50	0	Item text
89	FAEDN	FAEDN_KK	DATUM	DATS	8	0	Due date for net payment
90	FAEDS	FAEDS_KK	DATUM	DATS	8	0	Due Date for Cash Discount
91	VERKZ	VERKZ_KK	VERKZ_KK	CHAR	1	0	Item Can Only Be Cleared
92	STUDT	STUDT_KK	DATUM	DATS	8	0	Deferral to
93	SKTPZ	SKTPZ_KK	PRZ23	DEC	5	3	Cash discount rate
94	XMANL	XMANL_KK	XFELD	CHAR	1	0	Exclude Item from Dunning Run
95	KURSF	KURSF_KK	KURSF	DEC	9	5	Exchange rate
96	BETRH	BETRH_KK	WRTV7	CURR	13	2	Amount In Local Currency With +/- Signs
97	WAERH	WAERH	WAERS	CUKY	5	0	Local currency	*
98	BETRW	BETRW_KK	WRTV7	CURR	13	2	Amount in Transaction Currency with +/- Sign
99	BETR2	BETR2_KK	WRTV7	CURR	13	2	Amount in second parallel currency with +/- sign
100	BETR3	BETR3_KK	WRTV7	CURR	13	2	Amount in third parallel currency with +/- sign
101	SKFBT	SKFBT_KK	WRTV7	CURR	13	2	Amount eligible for cash discount in document currency
102	SBETH	SBETH_KK	WRTV7	CURR	13	2	Tax Amount in Local Currency With +/- Sign
103	SBETW	SBETW_KK	WRTV7	CURR	13	2	Tax Amount in Transaction Currency with +/- Sign
104	SBET2	SBET2_KK	WRTV7	CURR	13	2	Tax amount in second parallel currency
105	SBET3	SBET3_KK	WRTV7	CURR	13	2	Tax amount in third parallel currency
106	MWSKO	MWSKO_KK	SAKNR	CHAR	10	0	Account for posting taxes for down payments	*
107	MWVKO	MWVKO_KK	SAKNR	CHAR	10	0	Account for offsetting tax posting in down payments	*
108	TXRUL	TXRUL_KK	TXRUL_KK	CHAR	1	0	Update Rule for Tax and Tax Clearing
109	SPZAH	SPZAH_KK	SPZAH_KK	CHAR	1	0	Lock Reason for Automatic Payment	*
110	PYMET	PYMET_KK	PYMET_KK	CHAR	1	0	Payment Method	*
111	PYBUK	PYBUK_KK	BUKRS	CHAR	4	0	Company Code for Automatic Payment Transactions	*
112	PERNR	PERNR_D	PERNR	NUMC	8	0	Personnel Number
113	GRKEY	GRKEY_KK	CHAR3	CHAR	3	0	Grouping Key for Displaying Open Items
114	PERSL	PERSL_KK	PERSL_KK	CHAR	4	0	Key for Period Assignment	*
115	XAESP	XAESP_KK	XFELD	CHAR	1	0	Printing - No Changes Possible
116	AUGDT	AUGDT_KK	DATUM	DATS	8	0	Clearing date
117	AUGBL	AUGBL_KK	AUGBL_KK	CHAR	12	0	Clearing Document or Printed Document
118	AUGBD	AUGBD_KK	DATUM	DATS	8	0	Clearing document posting date
119	AUGRD	AUGRD_KK	AUGRD_KK	CHAR	2	0	Clearing Reason	*
120	AUGWA	AUGWA_KK	WAERS	CUKY	5	0	Clearing currency	*
121	AUGBT	AUGBT_KK	WRTV7	CURR	13	2	Clearing amount in clearing currency
122	AUGBS	AUGBS_KK	WRTV7	CURR	13	2	Tax amount in clearing currency
123	AUGSK	AUGSK_KK	WRTV7	CURR	13	2	Cash Discount Granted/Surcharge Levied in Clearing Currency
124	AUGVD	AUGVD_KK	DATUM	DATS	8	0	Value date for clearing
125	AUGOB	AUGOB_KK	XFELD	CHAR	1	0	Item Canceled
126	WHANG	WHANG_KK	NUM03	NUMC	3	0	Number of repetition items
127	WHGRP	WHGRP_KK	WHGRP_KK	NUMC	3	0	Repetition group	*
128	XEIPH	XEIPH_KK	XFELD	CHAR	1	0	Create Line Item in General Ledger
129	MAHNV	MAHNV_KK	MAHNV_KK	CHAR	2	0	Dunning Procedure	*
130	MANSP	MANSP_KK	MANSP_KK	CHAR	1	0	Dunning Lock Reason	*
131	XAUGP	XAUGP_KK	XFELD	CHAR	1	0	Check Sample Record Clearing
132	ABRZU	ABRZU_KK	DATUM	DATS	8	0	Lower Limit of Settlement Period
133	ABRZO	ABRZO_KK	DATUM	DATS	8	0	Upper Limit of the Billing Period
134	FDGRP	FDGRP_KK	FDGRP	CHAR	10	0	Planning Group	*
135	FDLEV	FDLEV_KK	FDLEV	CHAR	2	0	Planning level	*
136	FDZTG	FDZTG_KK	NUM2	NUMC	2	0	Additional Days for Cash Management
137	FDWBT	FDWBT	WERTV7	CURR	13	2	Planned Amount in Document or G/L Account Currency
138	XTAUS	XTAUS_KK	XFELD	CHAR	1	0	Item Split
139	AUGRS	AUGRS_KK	AUGRS_KK	CHAR	1	0	Clearing restriction
140	PYGRP	PYGRP_KK	CHAR10	CHAR	10	0	Grouping field for automatic payments
141	PDTYP	PDTYP_KK	PDTYP_KK	CHAR	1	0	Category of Payment Specification
142	SPERZ	SPERZ_KK	SPERZ_KK	CHAR	1	0	Interest Lock Reason	*
143	INFOZ	INFOZ_KK	INFOZ_KK	NUMC	3	0	Doubtful Item Entry/Individual Value Adjustment
144	TXJCD	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
145	TXDAT	TXDAT_KK	DATUM	DATS	8	0	Decisive Date for Calculating Taxes
146	VBUND	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*
147	KONTT	KONTT_KK	KONTT_KK	CHAR	2	0	Account Assignment Category	*
148	KONTL	KONTL_KK	CHAR50	CHAR	50	0	Acct assnmnt string for industry-specific account assngments
149	OPSTA	OPSTA_KK	OPSTA_KK	CHAR	3	0	Dunning indicator
150	EMGPA	EMGPA_KK	BU_PARTNER	CHAR	10	0	Alternative business partner for payments	*
151	EMBVT	EMBVT_KK	CHAR4	CHAR	4	0	Bank Details ID of Payee
152	EMADR	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
153	IKEY	IKEY_KK	IKEY_KK	CHAR	2	0	Interest Key	*
154	EUROU	EUROU_KK	EUROU_KK	CHAR	1	0	Status of Euro Conversion
155	XRAGL	XRAGL_KK	XFELD	CHAR	1	0	Clearing posting reversed
156	ASTKZ	ASTKZ_KK	ASTKZ_KK	CHAR	1	0	Statistical Key of the Initiating Item
157	ASBLG	ASBLG_KK	OPBEL_KK	CHAR	12	0	Number of Triggering Document	*
158	INKPS	INKPS_KK	NUM03	NUMC	3	0	Collection Item
159	RNDPS	RNDPS_KK	RNDPS_KK	CHAR	1	0	Type of Rounding Item
160	QSSKZ	QSSKZ	QSSKZ	CHAR	2	0	Withholding Tax Code	*
161	QSSEW	QSSEW_KK	QSSEW_KK	CHAR	2	0	Withholding Tax Supplement	*
162	QSPTP	QSPTP_KK	QSPTP_KK	CHAR	1	0	Line Item Category From Withholding Tax View
163	QSSHB	QSSHB_KK	WRTV7	CURR	13	2	Tax Base Amount
164	QBSHB	QBSHB_KK	WRTV7	CURR	13	2	Withholding Tax Amount (in Document Currency)
165	QSZNR	QSZNR	CHAR10	CHAR	10	0	Certificate Number of the Withholding Tax Exemption
166	RFUPK	RFUPK_KK	OPUPK_KK	NUMC	4	0	Reference Item In FI-CA Document
167	STRKZ	STRKZ_KK	STRKZ_KK	CHAR	2	0	Tax Code for Other Taxes	*
168	FITPR	J_1AFITP_D	J_1AFITP	CHAR	2	0	Tax type	*
169	XPYOR	XPYOR_KK	XPYOR_KK	CHAR	1	0	Item Included in a Payment Order
170	LANDL	LANDL_KK	LAND1	CHAR	3	0	Country Supplied (for Tax Notifications)	*
171	INTBU	INTBU_KK	INTBU_KK	CHAR	1	0	Reason for Automatic Creation of Posting
172	EMCRD	EMCRD_KK	CHAR6	CHAR	6	0	Alternative Payment Card ID in Document
173	SCTAX	SCTAX_KK	WRTV7	CURR	13	2	Tax Portion in FI-CA Local Currency
174	STTAX	STTAX_KK	WRTV7	CURR	13	2	Tax Amount as Statistical Information in Document Currency
175	STZAL	STZAL_KK	STZAL_KK	CHAR	1	0	Status of Payment Processing
176	ORUPZ	ORUPZ_KK	CHAR3	CHAR	3	0	Subitem Number before Item Split
177	NEGBU	NEGBU_KK	NEGBU_KK	NUMC	1	0	Control Field for Negative Posting
178	SUBAP	SUBAP_KK	SUBAP_KK	CHAR	1	0	Subapplication in Contract Accounts Receivable and Payable
179	PSWSL	PSWSL_KK	WAERS	CUKY	5	0	Update Currency for General Ledger Transaction Figures	*
180	PSWBT	PSWBT_KK	WRTV7	CURR	13	2	Amount for Updating in General Ledger
181	PSWTX	PSWTX_KK	WRTV7	CURR	13	2	Tax Amount for Update in General Ledger
182	PSGRP	PSGRP_KK	CHAR4	CHAR	4	0	Grouping Key for Document Items
183	PRCTR	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
184	KOSTL	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
185	KDAUF	KDAUF	VBELN	CHAR	10	0	Sales Order Number	*
186	KDPOS	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
187	KDEIN	KDEIN	NUM04	NUMC	4	0	Delivery schedule for sales order
188	PS_PSP_PNR	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
189	PAOBJNR	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
190	PASUBNR	RKESUBNR	RKESUBNR	NUMC	4	0	Profitability Segment Changes (CO-PA)
191	VALUT	VALUT	DATUM	DATS	8	0	Fixed Value Date
192	TXJCO	TXJCO_KK	TXJCD	CHAR	15	0	Jurisdiction code (specified value)	*
193	TXCNT	TXCNT_KK	NUM01	NUMC	1	0	Level Counter for Multi-Level Taxes in Tax Jurisdiction
194	TXEXK	TXEXK_KK	CHAR16	CHAR	16	0	Key for tax exception
195	SBASH	SBASH_KK	WRTV7	CURR	13	2	Amount Subject to Tax in Local Currency (Tax Base Amount)
196	SBASW	SBASW_KK	WRTV7	CURR	13	2	Amount Subject to Tax in Transaction Currency (Tax Base Amt)
197	KTOSL	KTOSL_KK	CHAR3	CHAR	3	0	Transaction key for account determination
198	STPRZ	STPRZ_KK	STPRZ_KK	NUMC	6	0	Tax rate
199	KSCHL	KSCHL	KSCHL	CHAR	4	0	Condition Type	*
200	AUFNR	AUFNR	AUFNR	CHAR	12	0	Order Number	*
201	XINTB	XINTB_KK	XFELD	CHAR	1	0	Item Created by Posting Interface
202	XCOPA	XCOPA_KK	XFELD	CHAR	1	0	CO-PA update done directly
203	MENGE	MENGE_D	MENG13	QUAN	13	3	Quantity
204	MEINS	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
205	REGIO	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
206	COUNC	COUNC	COUNC	CHAR	3	0	County Code	*
207	GRICD	J_1AGICD_D	J_1AGICD2	CHAR	2	0	Activity Code for Gross Income Tax	*
208	GITYP	J_1ADTYP_D	J_1ADTYP	CHAR	2	0	Distribution Type for Employment Tax	*
209	INVGR	INVGR_KK	CHAR4	CHAR	4	0	Grouping Key for Invoicing
210	.INCLUDE				0	0	Structure for Revenue Distribution
211	FINRE	FINRE_KK	VKONT_KK	CHAR	12	0	Contract Account of Final Recipient	*
212	RDSTA	RDSTA_KK	RDSTAT_KK	CHAR	1	0	Current Distribution Status
213	RDSTB	RDSTB_KK	RDSTAT_KK	CHAR	1	0	Last Distribution Status Reported
214	.INCLUDE				0	0
215	.INCLUDE				0	0
216	.INCLUDE				0	0
217	.INCLUDE				0	0
218	.INCLUDE				0	0	Document Journal: Fields for FM Integration
219	.INCLUDE				0	0
220	.INCLUDE				0	0
221	.INCLUDE				0	0
222	.INCLUDE				0	0