SAP ABAP Table FKKORDERALV (Requests: Structure for ALV Grid)

Hierarchy

☛ FI-CA (Software Component) FI-CA
   ⤷ FI-CA (Application Component) Contract Accounts Receivable and Payable
     ⤷ FKK_ORDER (Package) Requests

Basic Data

Table Category	INTTAB	Structure
Structure	FKKORDERALV	Table Relationship Diagram
Short Description	Requests: Structure for ALV Grid

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	LINENR	☐	LINENR_KK	LINENR_KK	NUMC	4	0	Line Number
2	BUKRS_BP	☐	BUKRS_BP_KK	BUKRS	CHAR	4	0	Company Code of Business Partner Item	T001
3	GPART	☐	GPART_KK	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
4	BU_DESCRIP	☐	BUSPARTNER_DESCRIP	CHAR50	CHAR	50	0	Short Description of Business Partner
5	VKONT	☐	VKONT_KK	VKONT_KK	CHAR	12	0	Contract Account Number	FKKVK
6	VKBEZ	☐	VKBEZ_KK	TEXT35	CHAR	35	0	Contract account name
7	VTREF	☐	VTREF_KK	VTREF_KK	CHAR	20	0	Reference Specifications from Contract
8	VTREF_TXT	☐	VTREF_TXT_KK	TEXT35	CHAR	35	0	Contract Name
9	SUBAP	☐	SUBAP_KK	SUBAP_KK	CHAR	1	0	Subapplication in Contract Accounts Receivable and Payable
10	HVORG	☐	HVORG_KK	HVORG_KK	CHAR	4	0	Main Transaction for Line Item	TFKHVO
11	TVORG	☐	TVORG_KK	TVORG_KK	CHAR	4	0	Subtransaction for Document Item	TFKTVO
12	BETRW	☐	BETRW_KK	WRTV7	CURR	13	2	Amount in Transaction Currency with +/- Sign
13	FAEDN	☐	FAEDN_KK	DATUM	DATS	8	0	Due date for net payment
14	VALDAT	☐	VALDAT_KK	DATUM	DATS	8	0	Validity Date
15	.INCLUDE	☐				0	0	FM Account Assignments for FI-CA Including Type
16	FMTYP	☐	FMTYP_KK	FMTYP_KK	CHAR	2	0	Update Method for FM - FI-CA Integration
17	.INCLUDE	☐				0	0	Funds Management Account Assignments for FI-CA
18	ORIGFIKRS	☐	ORIGFIKRS_KK	FIKRS	CHAR	4	0	Original FM Area for FM Account Assignment	*
19	FIPEX	☐	FM_FIPEX	FM_FIPEX	CHAR	24	0	Commitment item	*
20	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
21	FONDS	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
22	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
23	MEASURE	☐	FM_MEASURE	FM_MEASURE	CHAR	24	0	Funded Program	*
24	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
25	BUDGETYEAR	☐	FM_START_OF_CHAIN	GJAHR	NUMC	4	0	Original Year for FM Account Assignment
26	BUDGET_PD	☐	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period	*
27	KOFIZ	☐	KOFIZ_KK	KOFIZ_KK	CHAR	2	0	Account Determination ID
28	HKONT_BP	☐	HKONT_BP_KK	SAKNR	CHAR	10	0	Reconciliation Account	SKA1
29	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
30	SEGMENT	☐	SEGMT_KK	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	FAGL_SEGM
31	SPART	☐	SPART_KK	SPART	CHAR	2	0	Division	TSPA
32	TEXTPOS	☐	TEXTPOS_KK	TEXTPOS_KK	CHAR	50	0	Item Text for Request
33	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
34	STPRZ	☐	STRPZ_KK_1	PRZ33_KK	DEC	6	0	Tax rate
35	SBASW	☐	SBASW_KK	WRTV7	CURR	13	2	Amount Subject to Tax in Transaction Currency (Tax Base Amt)
36	SBETW	☐	SBETW_KK	WRTV7	CURR	13	2	Tax Amount in Transaction Currency with +/- Sign
37	KTOSL	☐	KTOSL	CHAR3	CHAR	3	0	Transaction Key
38	KSCHL	☐	KSCHL	KSCHL	CHAR	4	0	Condition Type	*
39	FAEDS	☐	FAEDS_KK	DATUM	DATS	8	0	Due Date for Cash Discount
40	DISC_DAYS	☐	DISC_DAYS_KK	DISC_DAYS_KK	NUMC	3	0	Cash Discount Days
41	SKTPZ	☐	SKTPZ_KK	PRZ23	DEC	5	3	Cash discount rate
42	BETRH	☐	BETRH_KK	WRTV7	CURR	13	2	Amount In Local Currency With +/- Signs
43	KURSF	☐	KURSF_KK	KURSF	DEC	9	5	Exchange rate
44	SPZAH	☐	SPZAH_KK	SPZAH_KK	CHAR	1	0	Lock Reason for Automatic Payment	TFK008
45	SPZAH_FDATE	☐	SPZAH_FDATE_KK	DATUM	DATS	8	0	Payment Block Valid from
46	SPZAH_TDATE	☐	SPZAH_TDATE_KK	DATUM	DATS	8	0	Payment Block Valid Until
47	PYMET	☐	PYMET_KK	PYMET_KK	CHAR	1	0	Payment Method	*
48	GRKEY	☐	GRKEY_KK	CHAR3	CHAR	3	0	Grouping Key for Displaying Open Items
49	MAHNV	☐	MAHNV_KK	MAHNV_KK	CHAR	2	0	Dunning Procedure	TFK047A
50	IKEY	☐	IKEY_KK	IKEY_KK	CHAR	2	0	Interest Key	TFK056A
51	MANSP	☐	MANSP_KK	MANSP_KK	CHAR	1	0	Dunning Lock Reason	TFK047S
52	MANSP_FDATE	☐	MANSP_FDATE_KK	DATUM	DATS	8	0	Dunning Block Valid Until
53	MANSP_TDATE	☐	MANSP_TDATE_KK	DATUM	DATS	8	0	Dunning Block Valid Until
54	SPERZ	☐	SPERZ_KK	SPERZ_KK	CHAR	1	0	Interest Lock Reason	TFK056S
55	SPERZ_FDATE	☐	SPERZ_FDATE_KK	DATUM	DATS	8	0	Interest Block from
56	SPERZ_TDATE	☐	SPERZ_TDATE_KK	DATUM	DATS	8	0	Interest Block Valid Until
57	CLRLO	☐	CLRLO_KK	SPPOS_KK	CHAR	1	0	Clearing Lock Reason	TFK000S
58	CLRLO_FDATE	☐	CLRLO_FDATE_KK	DATUM	DATS	8	0	Clearing Block Valid from
59	CLRLO_TDATE	☐	CLRLO_TDATE_KK	DATUM	DATS	8	0	Clearing Block Valid Until
60	EMGPA	☐	EMGPA_KK	BU_PARTNER	CHAR	10	0	Alternative business partner for payments	BUT000
61	EMBVT	☐	EMBVT_KK	CHAR4	CHAR	4	0	Bank Details ID of Payee
62	MNDID	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
63	EMCRD	☐	EMCRD_KK	CHAR6	CHAR	6	0	Alternative Payment Card ID in Document
64	FINRE	☐	FINRE_KK	VKONT_KK	CHAR	12	0	Contract Account of Final Recipient	*
65	RDSTA	☐	RDSTA_KK	RDSTAT_KK	CHAR	1	0	Current Distribution Status
66	RDSTB	☐	RDSTB_KK	RDSTAT_KK	CHAR	1	0	Last Distribution Status Reported
67	PERSL	☐	PERSL_KK	PERSL_KK	CHAR	4	0	Key for Period Assignment	TFK001P
68	ABRZU	☐	ABRZU_KK	DATUM	DATS	8	0	Lower Limit of Settlement Period
69	ABRZO	☐	ABRZO_KK	DATUM	DATS	8	0	Upper Limit of the Billing Period
70	BUKRS	☐	BUKRS_AC_KK	BUKRS	CHAR	4	0	Company Code of G/L Account Item	T001
71	HKONT	☐	HKONT_AC_KK	SAKNR	CHAR	10	0	G/L Account	SKA1
72	HKONT_TAX	☐	HKONT_TAX_KK	SAKNR	CHAR	10	0	Tax G/L Account	*
73	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
74	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
75	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
76	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
77	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
78	KDEIN	☐	KDEIN	NUM04	NUMC	4	0	Delivery schedule for sales order
79	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
80	PAOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
81	PASUBNR	☐	RKESUBNR	RKESUBNR	NUMC	4	0	Profitability Segment Changes (CO-PA)
82	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
83	TXDAT	☐	TXDAT_KK	DATUM	DATS	8	0	Decisive Date for Calculating Taxes
84	CURR_LOCAL	☐	CURR_LOCAL_KK	WAERS	CUKY	5	0	Local Currency	*
85	.INCLUDE	☐				0	0
86	.INCLUDE	☐				0	0	Include FKKORDERALV for IS-U/T/M
87	FDGRP	☐	FDGRP_KK	FDGRP	CHAR	10	0	Planning Group	T035
88	FDLEV	☐	FDLEV_KK	FDLEV	CHAR	2	0	Planning level	T036
89	FDZTG	☐	FDZTG_KK	NUM2	NUMC	2	0	Additional Days for Cash Management
90	OPORD	☐	OPORD_KK	CHAR35	CHAR	35	0	Classification Key
91	XRLITCO	☐	XRLITCO_KK	XFELD	CHAR	1	0	Request Item Complete
92	KONTT_BP	☐	KONTT_BP_KK	KONTT_KK	CHAR	2	0	Category for Additional Acct Assnmt for Bus. Partner Line	*
93	KONTL_BP	☐	KONTL_BP_KK	CHAR50	CHAR	50	0	Acct Assgnt Toolbar for Appl-Specific Act Assts for BP Lines
94	KONTT_AC	☐	KONTT_AC_KK	KONTT_KK	CHAR	2	0	Cat. of Additional Acct Assnmt for G/L Account Lines	*
95	KONTL_AC	☐	KONTL_AC_KK	CHAR50	CHAR	50	0	Acct Assgt Toolbar for Appl-Spec.AcctAssgmts for G/L A-Lines
96	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
97	ANLN2	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
98	ANBWA	☐	ANBWA	BWASL	CHAR	3	0	Asset Transaction Type	TABW
99	BZDAT	☐	BZDAT	DATUM	DATS	8	0	Asset Value Date
100	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*
101	XEIBH	☐	XEIBH_KK	XFELD	CHAR	1	0	Create Separate Document in General Ledger
102	XEIPH	☐	XEIPH_KK	XFELD	CHAR	1	0	Create Line Item in General Ledger
103	.INCLUDE	☐				0	0	Include for Funds Commitment (OPK)
104	EFFLG	☐	FKK_EFFLG	XFELD	CHAR	1	0	Create Earmarked Funds
105	EFCIR	☐	FKK_EFCIR	XFELD	CHAR	1	0	Indicator: Earmarked Funds Created from Request
106	EFLC	☐	FKK_EFLC	XFELD	CHAR	1	0	Indicator: Last Request Line for Earmarked Funds
107	.INCLUDE	☐				0	0	Public Sector: Fields for Business Partner Items
108	DOCCR	☐	DOCCR_KK	DOCCR_KK	CHAR	1	0	Document can be created
109	PSGRP	☐	PSGRP_KK	CHAR4	CHAR	4	0	Grouping Key for Document Items
110	STAKZ	☐	STAKZ_KK	STAKZ_KK	CHAR	1	0	Type of statistical item
111	XANZA	☐	XANZA_KK	XFELD	CHAR	1	0	Item is a Down Payment/Down Payment Request

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FKKORDERALV	ANBWA	TABW	BWASL
2	FKKORDERALV	ANLN1	ANLH	ANLN1
3	FKKORDERALV	ANLN2	ANLA	ANLN2
4	FKKORDERALV	AUFNR	AUFK	AUFNR
5	FKKORDERALV	BUKRS	T001	BUKRS
6	FKKORDERALV	BUKRS_BP	T001	BUKRS
7	FKKORDERALV	CLRLO	TFK000S	SPPOS
8	FKKORDERALV	EMGPA	BUT000	PARTNER
9	FKKORDERALV	FDGRP	T035	GRUPP
10	FKKORDERALV	FDLEV	T036	EBENE
11	FKKORDERALV	GPART	BUT000	PARTNER
12	FKKORDERALV	GSBER	TGSB	GSBER
13	FKKORDERALV	HKONT	SKA1	SAKNR
14	FKKORDERALV	HKONT_BP	SKA1	SAKNR
15	FKKORDERALV	HVORG	TFKHVO	HVORG		1	CN
16	FKKORDERALV	IKEY	TFK056A	IKEY
17	FKKORDERALV	KDAUF	VBUK	VBELN
18	FKKORDERALV	KOSTL	CSKS	KOSTL
19	FKKORDERALV	MAHNV	TFK047A	MAHNV
20	FKKORDERALV	MANSP	TFK047S	MANSP
21	FKKORDERALV	MWSKZ	T007A	MWSKZ		1	CN
22	FKKORDERALV	PERSL	TFK001P	PERSL
23	FKKORDERALV	PRCTR	CEPC	PRCTR
24	FKKORDERALV	PS_PSP_PNR	PRPS	PSPNR
25	FKKORDERALV	SEGMENT	FAGL_SEGM	SEGMENT
26	FKKORDERALV	SPART	TSPA	SPART
27	FKKORDERALV	SPERZ	TFK056S	SPERZ
28	FKKORDERALV	SPZAH	TFK008	ZAHLS
29	FKKORDERALV	TVORG	TFKTVO	TVORG		1	CN
30	FKKORDERALV	TXJCD	TTXJ	TXJCD
31	FKKORDERALV	VKONT	FKKVK	VKONT

History

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