SAP ABAP Table FKKOP_R402 (Open Item Structure for New Items of Event R402)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-IN (Application Component) Invoicing
     ⤷ EE21 (Package) IS-U: Invoicing

Basic Data

Table Category	INTTAB	Structure
Structure	FKKOP_R402	Table Relationship Diagram
Short Description	Open Item Structure for New Items of Event R402

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	Business Partner Items in Contract Account Document
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	OPBEL	☐	OPBEL_KK	OPBEL_KK	CHAR	12	0	Number of Contract Accts Rec. & Payable Doc.	*
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	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
8	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
9	BUPLA	☐	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place	J_1BBRANCH
10	SEGMENT	☐	SEGMT_KK	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	FAGL_SEGM
11	AUGST	☐	AUGST_KK	AUGST_KK	CHAR	1	0	Clearing status
12	GPART	☐	GPART_KK	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
13	VTREF	☐	VTREF_KK	VTREF_KK	CHAR	20	0	Reference Specifications from Contract
14	VTRE2	☐	VTRE2_KK	VTREF_KK	CHAR	20	0	Additional Reference Information
15	VKONT	☐	VKONT_KK	VKONT_KK	CHAR	12	0	Contract Account Number	FKKVK
16	ABWBL	☐	ABWBL_KK	ABWBL_KK	CHAR	12	0	Number of the substitute FI-CA document
17	ABWTP	☐	ABWTP_KK	ABWTP_KK	CHAR	1	0	Category of substitute document in FI-CA
18	ABWKT	☐	ABWVK_KK	VKONT_KK	CHAR	12	0	Alternative contract account for collective bills	*
19	APPLK	☐	APPLK_KK	APPLK_KK	CHAR	1	0	Application area
20	HVORG	☐	HVORG_KK	HVORG_KK	CHAR	4	0	Main Transaction for Line Item	TFKHVO
21	TVORG	☐	TVORG_KK	TVORG_KK	CHAR	4	0	Subtransaction for Document Item	TFKTVO
22	KOFIZ	☐	KOFIZ_KK	KOFIZ_KK	CHAR	2	0	Account Determination ID
23	SPART	☐	SPART_KK	SPART	CHAR	2	0	Division	TSPA
24	HKONT	☐	HKONT_KK	SAKNR	CHAR	10	0	General ledger account	SKA1
25	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
26	MWSZKZ	☐	MWSZKZ_KK	MWSKZ	CHAR	2	0	Supplementary Tax	*
27	XANZA	☐	XANZA_KK	XFELD	CHAR	1	0	Item is a Down Payment/Down Payment Request
28	STAKZ	☐	STAKZ_KK	STAKZ_KK	CHAR	1	0	Type of statistical item
29	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
30	BUDAT	☐	BUDAT_KK	DATUM	DATS	8	0	Posting Date in the Document
31	OPTXT	☐	OPTXT_KK	TEXT50	CHAR	50	0	Item text
32	WAERS	☐	BLWAE_KK	WAERS	CUKY	5	0	Transaction Currency	TCURC
33	FAEDN	☐	FAEDN_KK	DATUM	DATS	8	0	Due date for net payment
34	FAEDS	☐	FAEDS_KK	DATUM	DATS	8	0	Due Date for Cash Discount
35	VERKZ	☐	VERKZ_KK	VERKZ_KK	CHAR	1	0	Item Can Only Be Cleared
36	STUDT	☐	STUDT_KK	DATUM	DATS	8	0	Deferral to
37	SKTPZ	☐	SKTPZ_KK	PRZ23	DEC	5	3	Cash discount rate
38	XMANL	☐	XMANL_KK	XFELD	CHAR	1	0	Exclude Item from Dunning Run
39	KURSF	☐	KURSF_KK	KURSF	DEC	9	5	Exchange rate
40	BETRH	☐	BETRH_KK	WRTV7	CURR	13	2	Amount In Local Currency With +/- Signs
41	BETRW	☐	BETRW_KK	WRTV7	CURR	13	2	Amount in Transaction Currency with +/- Sign
42	BETR2	☐	BETR2_KK	WRTV7	CURR	13	2	Amount in second parallel currency with +/- sign
43	BETR3	☐	BETR3_KK	WRTV7	CURR	13	2	Amount in third parallel currency with +/- sign
44	SKFBT	☐	SKFBT_KK	WRTV7	CURR	13	2	Amount eligible for cash discount in document currency
45	SBETH	☐	SBETH_KK	WRTV7	CURR	13	2	Tax Amount in Local Currency With +/- Sign
46	SBETW	☐	SBETW_KK	WRTV7	CURR	13	2	Tax Amount in Transaction Currency with +/- Sign
47	SBET2	☐	SBET2_KK	WRTV7	CURR	13	2	Tax amount in second parallel currency
48	SBET3	☐	SBET3_KK	WRTV7	CURR	13	2	Tax amount in third parallel currency
49	MWSKO	☐	MWSKO_KK	SAKNR	CHAR	10	0	Account for posting taxes for down payments	SKA1
50	MWVKO	☐	MWVKO_KK	SAKNR	CHAR	10	0	Account for offsetting tax posting in down payments	SKA1
51	TXRUL	☐	TXRUL_KK	TXRUL_KK	CHAR	1	0	Update Rule for Tax and Tax Clearing
52	SPZAH	☐	SPZAH_KK	SPZAH_KK	CHAR	1	0	Lock Reason for Automatic Payment	TFK008
53	PYMET	☐	PYMET_KK	PYMET_KK	CHAR	1	0	Payment Method	*
54	PYBUK	☐	PYBUK_KK	BUKRS	CHAR	4	0	Company Code for Automatic Payment Transactions	T001
55	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
56	GRKEY	☐	GRKEY_KK	CHAR3	CHAR	3	0	Grouping Key for Displaying Open Items
57	PERSL	☐	PERSL_KK	PERSL_KK	CHAR	4	0	Key for Period Assignment	TFK001P
58	XAESP	☐	XAESP_KK	XFELD	CHAR	1	0	Printing - No Changes Possible
59	AUGDT	☐	AUGDT_KK	DATUM	DATS	8	0	Clearing date
60	AUGBL	☐	AUGBL_KK	AUGBL_KK	CHAR	12	0	Clearing Document or Printed Document
61	AUGBD	☐	AUGBD_KK	DATUM	DATS	8	0	Clearing document posting date
62	AUGRD	☐	AUGRD_KK	AUGRD_KK	CHAR	2	0	Clearing Reason	TFK001A
63	AUGWA	☐	AUGWA_KK	WAERS	CUKY	5	0	Clearing currency	*
64	AUGBT	☐	AUGBT_KK	WRTV7	CURR	13	2	Clearing amount in clearing currency
65	AUGBS	☐	AUGBS_KK	WRTV7	CURR	13	2	Tax amount in clearing currency
66	AUGSK	☐	AUGSK_KK	WRTV7	CURR	13	2	Cash Discount Granted/Surcharge Levied in Clearing Currency
67	AUGVD	☐	AUGVD_KK	DATUM	DATS	8	0	Value date for clearing
68	AUGOB	☐	AUGOB_KK	XFELD	CHAR	1	0	Item Canceled
69	WHANG	☐	WHANG_KK	NUM03	NUMC	3	0	Number of repetition items
70	WHGRP	☐	WHGRP_KK	WHGRP_KK	NUMC	3	0	Repetition group	*
71	XEIPH	☐	XEIPH_KK	XFELD	CHAR	1	0	Create Line Item in General Ledger
72	MAHNV	☐	MAHNV_KK	MAHNV_KK	CHAR	2	0	Dunning Procedure	TFK047A
73	MANSP	☐	MANSP_KK	MANSP_KK	CHAR	1	0	Dunning Lock Reason	TFK047S
74	XAUGP	☐	XAUGP_KK	XFELD	CHAR	1	0	Check Sample Record Clearing
75	ABRZU	☐	ABRZU_KK	DATUM	DATS	8	0	Lower Limit of Settlement Period
76	ABRZO	☐	ABRZO_KK	DATUM	DATS	8	0	Upper Limit of the Billing Period
77	FDGRP	☐	FDGRP_KK	FDGRP	CHAR	10	0	Planning Group	T035
78	FDLEV	☐	FDLEV_KK	FDLEV	CHAR	2	0	Planning level	T036
79	FDZTG	☐	FDZTG_KK	NUM2	NUMC	2	0	Additional Days for Cash Management
80	FDWBT	☐	FDWBT	WERTV7	CURR	13	2	Planned Amount in Document or G/L Account Currency
81	XTAUS	☐	XTAUS_KK	XFELD	CHAR	1	0	Item Split
82	AUGRS	☐	AUGRS_KK	AUGRS_KK	CHAR	1	0	Clearing restriction
83	PYGRP	☐	PYGRP_KK	CHAR10	CHAR	10	0	Grouping field for automatic payments
84	PDTYP	☐	PDTYP_KK	PDTYP_KK	CHAR	1	0	Category of Payment Specification
85	SPERZ	☐	SPERZ_KK	SPERZ_KK	CHAR	1	0	Interest Lock Reason	TFK056S
86	INFOZ	☐	INFOZ_KK	INFOZ_KK	NUMC	3	0	Doubtful Item Entry/Individual Value Adjustment
87	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
88	TXDAT	☐	TXDAT_KK	DATUM	DATS	8	0	Decisive Date for Calculating Taxes
89	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
90	KONTT	☐	KONTT_KK	KONTT_KK	CHAR	2	0	Account Assignment Category	TFK000K
91	KONTL	☐	KONTL_KK	CHAR50	CHAR	50	0	Acct assnmnt string for industry-specific account assngments
92	OPSTA	☐	OPSTA_KK	OPSTA_KK	CHAR	3	0	Dunning indicator
93	BLART	☐	BLART_KK	BLART_KK	CHAR	2	0	Document Type	TFK003
94	EMGPA	☐	EMGPA_KK	BU_PARTNER	CHAR	10	0	Alternative business partner for payments	BUT000
95	EMBVT	☐	EMBVT_KK	CHAR4	CHAR	4	0	Bank Details ID of Payee	BUT0BK
96	EMADR	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
97	IKEY	☐	IKEY_KK	IKEY_KK	CHAR	2	0	Interest Key	TFK056A
98	EUROU	☐	EUROU_KK	EUROU_KK	CHAR	1	0	Status of Euro Conversion
99	XRAGL	☐	XRAGL_KK	XFELD	CHAR	1	0	Clearing posting reversed
100	XWHPO	☐	XWHPO_KK	XFELD	CHAR	1	0	Expanded Repetition Item
101	ASTKZ	☐	ASTKZ_KK	ASTKZ_KK	CHAR	1	0	Statistical Key of the Initiating Item
102	ASBLG	☐	ASBLG_KK	OPBEL_KK	CHAR	12	0	Number of Triggering Document	*
103	XBLNR	☐	XBLNR_KK	XBLNR_KK	CHAR	16	0	Reference document number
104	INKPS	☐	INKPS_KK	NUM03	NUMC	3	0	Collection Item
105	RNDPS	☐	RNDPS_KK	RNDPS_KK	CHAR	1	0	Type of Rounding Item
106	QSSKZ	☐	QSSKZ	QSSKZ	CHAR	2	0	Withholding Tax Code	T059Q
107	QSSEW	☐	QSSEW_KK	QSSEW_KK	CHAR	2	0	Withholding Tax Supplement	*
108	QSPTP	☐	QSPTP_KK	QSPTP_KK	CHAR	1	0	Line Item Category From Withholding Tax View
109	QSSHB	☐	QSSHB_KK	WRTV7	CURR	13	2	Tax Base Amount
110	QBSHB	☐	QBSHB_KK	WRTV7	CURR	13	2	Withholding Tax Amount (in Document Currency)
111	QSZNR	☐	QSZNR	CHAR10	CHAR	10	0	Certificate Number of the Withholding Tax Exemption
112	RFUPK	☐	RFUPK_KK	OPUPK_KK	NUMC	4	0	Reference Item In FI-CA Document
113	STRKZ	☐	STRKZ_KK	STRKZ_KK	CHAR	2	0	Tax Code for Other Taxes	TFK007F
114	FITPR	☐	J_1AFITP_D	J_1AFITP	CHAR	2	0	Tax type	*
115	XPYOR	☐	XPYOR_KK	XPYOR_KK	CHAR	1	0	Item Included in a Payment Order
116	LANDL	☐	LANDL_KK	LAND1	CHAR	3	0	Country Supplied (for Tax Notifications)	T005
117	INTBU	☐	INTBU_KK	INTBU_KK	CHAR	1	0	Reason for Automatic Creation of Posting
118	EMCRD	☐	EMCRD_KK	CHAR6	CHAR	6	0	Alternative Payment Card ID in Document
119	C4EYE	☐	C4EYE_KK	C4EYE_KK	CHAR	2	0	Check Reason for Workflows Acc. to Dual Control Principle	*
120	CFOPN	☐	J_1BCFOP	J_1BCFOP	CHAR	10	0	CFOP code and extension	*
121	C4EYP	☐	C4EYP_KK	C4EYP_KK	CHAR	1	0	Editing Process To Be Confirmed
122	SCTAX	☐	SCTAX_KK	WRTV7	CURR	13	2	Tax Portion in FI-CA Local Currency
123	STTAX	☐	STTAX_KK	WRTV7	CURR	13	2	Tax Amount as Statistical Information in Document Currency
124	STZAL	☐	STZAL_KK	STZAL_KK	CHAR	1	0	Status of Payment Processing
125	ORUPZ	☐	ORUPZ_KK	CHAR3	CHAR	3	0	Subitem Number before Item Split
126	NEGBU	☐	NEGBU_KK	NEGBU_KK	NUMC	1	0	Control Field for Negative Posting
127	SUBAP	☐	SUBAP_KK	SUBAP_KK	CHAR	1	0	Subapplication in Contract Accounts Receivable and Payable
128	PSWSL	☐	PSWSL_KK	WAERS	CUKY	5	0	Update Currency for General Ledger Transaction Figures	*
129	PSWBT	☐	PSWBT_KK	WRTV7	CURR	13	2	Amount for Updating in General Ledger
130	PSWTX	☐	PSWTX_KK	WRTV7	CURR	13	2	Tax Amount for Update in General Ledger
131	PSGRP	☐	PSGRP_KK	CHAR4	CHAR	4	0	Grouping Key for Document Items
132	EMMND	☐	EMMND_KK	NUM06	NUMC	6	0	SEPA Mandate Identification
133	.INCLUDE	☐				0	0	Direct Debit Pre-Notification in Document Item
134	PNNUM	☐	PNNUM_KK	PNNUM_KK	CHAR	16	0	SEPA: Number of Direct Debit Pre-Notification
135	PNHKF	☐	PNHKF_KK	PNHKF_KK	CHAR	2	0	SEPA: Origin of Direct Debit Pre-Notification
136	PNEXD	☐	PNEXD_KK	DATUM	DATS	8	0	SEPA: Date of Execution of Direct Debit Pre-Notifcation
137	PNCTR	☐	PNCTR_KK	PNCTR_KK	CHAR	1	0	SEPA: Requirement for a Pre-Notification
138	.INCLUDE	☐				0	0	Structure for Revenue Distribution
139	FINRE	☐	FINRE_KK	VKONT_KK	CHAR	12	0	Contract Account of Final Recipient	*
140	RDSTA	☐	RDSTA_KK	RDSTAT_KK	CHAR	1	0	Current Distribution Status
141	RDSTB	☐	RDSTB_KK	RDSTAT_KK	CHAR	1	0	Last Distribution Status Reported
142	.INCLUDE	☐				0	0	FM Account Assignments for FI-CA Including Type
143	FMTYP	☐	FMTYP_KK	FMTYP_KK	CHAR	2	0	Update Method for FM - FI-CA Integration
144	.INCLUDE	☐				0	0	Funds Management Account Assignments for FI-CA
145	ORIGFIKRS	☐	ORIGFIKRS_KK	FIKRS	CHAR	4	0	Original FM Area for FM Account Assignment	*
146	FIPEX	☐	FM_FIPEX	FM_FIPEX	CHAR	24	0	Commitment item	*
147	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
148	FONDS	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
149	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
150	MEASURE	☐	FM_MEASURE	FM_MEASURE	CHAR	24	0	Funded Program	*
151	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
152	BUDGETYEAR	☐	FM_START_OF_CHAIN	GJAHR	NUMC	4	0	Original Year for FM Account Assignment
153	BUDGET_PD	☐	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period	*
154	.INCLUDE	☐				0	0	Include: OI for Utility Companies: IS-U
155	.INCLUDE	☐				0	0	Include OI for Insurance
156	.INCLUDE	☐				0	0	IS-T: Include open items for telecommunications companies
157	.INCLUDE	☐				0	0	Public Sector: Fields for Business Partner Items
158	.INCLUDE	☐				0	0
159	.INCLUDE	☐				0	0	Include OI for IS-Media
160	.INCLUDE	☐				0	0	FI-CA Extended: Include OI
161	X_NOT_TOTAL_AMNT	☐	X_NOT_TOTAL_AMNT	E_XTOTAL_AMNT	CHAR	1	0	Do Not Include Items in Final Bill Amount
162	X_NOT_PRINTREL	☐	E_NOT_PRINTREL	KENNZX	CHAR	1	0	Bill Line Is Not Relevant for Printing
163	BELZART	☐	BELZART	BELZART	CHAR	6	0	Line Item Type	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FKKOP_R402	AUGRD	TFK001A	AUGRD		1	CN
2	FKKOP_R402	BLART	TFK003	BLART		1	N
3	FKKOP_R402	BUKRS	T001	BUKRS
4	FKKOP_R402	BUPLA	J_1BBRANCH	BRANCH
5	FKKOP_R402	EMBVT	BUT0BK	BKVID
6	FKKOP_R402	EMGPA	BUT000	PARTNER		1	CN
7	FKKOP_R402	FDGRP	T035	GRUPP		1	CN
8	FKKOP_R402	FDLEV	T036	EBENE		1	CN
9	FKKOP_R402	GPART	BUT000	PARTNER		1	N
10	FKKOP_R402	GSBER	TGSB	GSBER		1	CN
11	FKKOP_R402	HKONT	SKA1	SAKNR		1	CN
12	FKKOP_R402	HVORG	TFKHVO	HVORG		1	CN
13	FKKOP_R402	IKEY	TFK056A	IKEY		1	1
14	FKKOP_R402	KONTT	TFK000K	KONTT		1	CN
15	FKKOP_R402	LANDL	T005	LAND1
16	FKKOP_R402	MAHNV	TFK047A	MAHNV
17	FKKOP_R402	MANSP	TFK047S	MANSP		1	CN
18	FKKOP_R402	MWSKO	SKA1	SAKNR		1	CN
19	FKKOP_R402	MWSKZ	T007A	MWSKZ		1	CN
20	FKKOP_R402	MWVKO	SKA1	SAKNR		1	CN
21	FKKOP_R402	PERSL	TFK001P	PERSL		1	CN
22	FKKOP_R402	PYBUK	T001	BUKRS
23	FKKOP_R402	QSSKZ	T059Q	QSSKZ
24	FKKOP_R402	SEGMENT	FAGL_SEGM	SEGMENT
25	FKKOP_R402	SPART	TSPA	SPART		1	CN
26	FKKOP_R402	SPERZ	TFK056S	SPERZ		1	CN
27	FKKOP_R402	SPZAH	TFK008	ZAHLS		1	CN
28	FKKOP_R402	STRKZ	TFK007F	STRKZ
29	FKKOP_R402	TVORG	TFKTVO	TVORG		1	CN
30	FKKOP_R402	TXJCD	TTXJ	TXJCD		1	CN
31	FKKOP_R402	VBUND	T880	RCOMP		1	CN
32	FKKOP_R402	VKONT	FKKVK	VKONT		1	N
33	FKKOP_R402	WAERS	TCURC	WAERS		1	N

History

Last changed by/on	SAP	20131127
SAP Release Created in	472