SAP ABAP Table CMAC_SFKKOP (Enhanced Data for displaying items in FI-CA document)

Hierarchy

☛ IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
   ⤷ IS-HER-CM-AC (Application Component) Student Accounting
     ⤷ CMAC_E (Package) Campus Management: Student Account

Basic Data

Table Category	INTTAB	Structure
Structure	CMAC_SFKKOP	Table Relationship Diagram
Short Description	Enhanced Data for displaying items in FI-CA document

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

Foreign Keys

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

History

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