SAP ABAP Table REXA_GUI_DOC_ITEM_L (FI-CA: Document Item)

Hierarchy

☛ FI-CA (Software Component) FI-CA
   ⤷ FI-CA (Application Component) Contract Accounts Receivable and Payable
     ⤷ RE_XA_FC (Package) Real Estate Master Data/Customizing in Contract AP/AR

Basic Data

Table Category	INTTAB	Structure
Structure	REXA_GUI_DOC_ITEM_L	Table Relationship Diagram
Short Description	FI-CA: Document Item

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	DOCGUID	☐	RERADOCGUID	RECAGUID	RAW	16	0	GUID: Unique Internal Key for RE Document
2	.INCLUDE	☐				0	0	BAPI: Business Partner Items for Open Item Account Document
3	DOC_NO	☐	OPBEL_KK	OPBEL_KK	CHAR	12	0	Number of Contract Accts Rec. & Payable Doc.	*
4	REP_ITEM	☐	OPUPW_KK	OPUPW_KK	NUMC	3	0	Repetition Item in Contract Account Document
5	ITEM	☐	OPUPK_KK	OPUPK_KK	NUMC	4	0	Item number in contract account document
6	SUB_ITEM	☐	OPUPZ_KK	OPUPZ_KK	NUMC	3	0	Subitem for a Partial Clearing in Document
7	COMP_CODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
8	BUS_AREA	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
9	STATUS	☐	AUGST_KK	AUGST_KK	CHAR	1	0	Clearing status
10	BUSPARTNER	☐	GPART_KK	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
11	CONTRACT	☐	VTREF_KK	VTREF_KK	CHAR	20	0	Reference Specifications from Contract
12	CONTRACT2	☐	VTRE2_KK	VTREF_KK	CHAR	20	0	Additional Reference Information
13	CONT_ACCT	☐	VKONT_KK	VKONT_KK	CHAR	12	0	Contract Account Number	FKKVK
14	SUB_DOC	☐	ABWBL_KK	ABWBL_KK	CHAR	12	0	Number of the substitute FI-CA document
15	DOC_CAT	☐	ABWTP_KK	ABWTP_KK	CHAR	1	0	Category of substitute document in FI-CA
16	APPL_AREA	☐	APPLK_KK	APPLK_KK	CHAR	1	0	Application area
17	MAIN_TRANS	☐	HVORG_KK	HVORG_KK	CHAR	4	0	Main Transaction for Line Item	TFKHVO
18	SUB_TRANS	☐	TVORG_KK	TVORG_KK	CHAR	4	0	Subtransaction for Document Item	TFKTVO
19	ACTDETERID	☐	KOFIZ_KK	KOFIZ_KK	CHAR	2	0	Account Determination ID
20	DIVISION	☐	SPART_KK	SPART	CHAR	2	0	Division	TSPA
21	G_L_ACCT	☐	HKONT_KK	SAKNR	CHAR	10	0	General ledger account	SKA1
22	TAX_CODE	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
23	DOWN_PMNT	☐	XANZA_KK	XFELD	CHAR	1	0	Item is a Down Payment/Down Payment Request
24	STAT_KEY	☐	STAKZ_KK	STAKZ_KK	CHAR	1	0	Type of statistical item
25	DOC_DATE	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
26	POST_DATE	☐	BUDAT_KK	DATUM	DATS	8	0	Posting Date in the Document
27	TEXT	☐	OPTXT_KK	TEXT50	CHAR	50	0	Item text
28	NET_DATE	☐	FAEDN_KK	DATUM	DATS	8	0	Due date for net payment
29	DISC_DUE	☐	FAEDS_KK	DATUM	DATS	8	0	Due Date for Cash Discount
30	ONLY_OFF	☐	VERKZ_KK	VERKZ_KK	CHAR	1	0	Item Can Only Be Cleared
31	DEFERRAL	☐	STUDT_KK	DATUM	DATS	8	0	Deferral to
32	DISC_RATE	☐	SKTPZ_KK	PRZ23	DEC	5	3	Cash discount rate
33	NO_DUNNING	☐	XMANL_KK	XFELD	CHAR	1	0	Exclude Item from Dunning Run
34	TRAN_RATE	☐	KURSF_KK	KURSF	DEC	9	5	Exchange rate
35	CURRENCY	☐	BLWAE_KK	WAERS	CUKY	5	0	Transaction Currency	TCURC
36	CURRENCY_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
37	AMOUNT_LOC_CURR	☐	BP_BETRH_KK	BAPICURR	DEC	23	4	Amount in Local Currency with +/- Signs
38	AMOUNT	☐	BP_BETRW_KK	BAPICURR	DEC	23	4	Amount in Transaction Currency with +/- Sign
39	AMOUNT_PAR2_CURR	☐	BP_BETR2_KK	BAPICURR	DEC	23	4	Amount in second parallel currency with +/- sign
40	AMOUNT_PAR3_CURR	☐	BP_BETR3_KK	BAPICURR	DEC	23	4	Amount in third parallel currency with +/- sign
41	DISCOUNT_BASE	☐	BP_SKFBT_KK	BAPICURR	DEC	23	4	Amount eligible for cash discount in document currency
42	TAX_AMOUNT_LOC_CURR	☐	BP_SBETH_KK	BAPICURR	DEC	23	4	Tax Amount in Local Currency with +/- Sign
43	TAX_AMOUNT	☐	BP_SBETW_KK	BAPICURR	DEC	23	4	Tax amount in transaction currency with +/- sign
44	TAX_AMOUNT_PAR2_CURR	☐	BP_SBET2_KK	BAPICURR	DEC	23	4	Tax amount in second parallel currency
45	TAX_AMOUNT_PAR3_CURR	☐	BP_SBET3_KK	BAPICURR	DEC	23	4	Tax amount in third parallel currency
46	TAX_ACCT	☐	MWSKO_KK	SAKNR	CHAR	10	0	Account for posting taxes for down payments	SKA1
47	OFFSET_TAX	☐	MWVKO_KK	SAKNR	CHAR	10	0	Account for offsetting tax posting in down payments	SKA1
48	PMNT_BLOCK	☐	SPZAH_KK	SPZAH_KK	CHAR	1	0	Lock Reason for Automatic Payment	TFK008
49	PMNT_METH	☐	PYMET_KK	PYMET_KK	CHAR	1	0	Payment Method	TFK042Z
50	PERSON_NO	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
51	GROUPING	☐	GRKEY_KK	CHAR3	CHAR	3	0	Grouping Key for Displaying Open Items
52	PERIOD_KEY	☐	PERSL_KK	PERSL_KK	CHAR	4	0	Key for Period Assignment	TFK001P
53	CHG_BLOCK	☐	XAESP_KK	XFELD	CHAR	1	0	Printing - No Changes Possible
54	CLEARDATE	☐	AUGDT_KK	DATUM	DATS	8	0	Clearing date
55	CLEARDOCNO	☐	AUGBL_KK	AUGBL_KK	CHAR	12	0	Clearing Document or Printed Document
56	CL_POSTDTE	☐	AUGBD_KK	DATUM	DATS	8	0	Clearing document posting date
57	CLEAR_REAS	☐	AUGRD_KK	AUGRD_KK	CHAR	2	0	Clearing Reason	TFK001A
58	CLRG_CURR	☐	AUGWA_KK	WAERS	CUKY	5	0	Clearing currency	TCURC
59	CLRG_CURR_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
60	AMOUNT_CLEAR	☐	BP_AUGBT_KK	BAPICURR	DEC	23	4	Clearing amount in clearing currency
61	TAX_AMOUNT_CLEAR	☐	BP_AUGBS_KK	BAPICURR	DEC	23	4	Tax Amount in Clearing Currency
62	VAL_DATE	☐	AUGVD_KK	DATUM	DATS	8	0	Value date for clearing
63	CANCELED	☐	AUGOB_KK	XFELD	CHAR	1	0	Item Canceled
64	NO_REPS	☐	WHANG_KK	NUM03	NUMC	3	0	Number of repetition items
65	REPET_GRP	☐	WHGRP_KK	WHGRP_KK	NUMC	3	0	Repetition group	*
66	LINE_ITEM	☐	XEIPH_KK	XFELD	CHAR	1	0	Create Line Item in General Ledger
67	DUNN_PROC	☐	MAHNV_KK	MAHNV_KK	CHAR	2	0	Dunning Procedure	TFK047A
68	DUNN_BLOCK	☐	MANSP_KK	MANSP_KK	CHAR	1	0	Dunning Lock Reason	TFK047S
69	CHECK_CLNG	☐	XAUGP_KK	XFELD	CHAR	1	0	Check Sample Record Clearing
70	CALC_PERLO	☐	ABRZU_KK	DATUM	DATS	8	0	Lower Limit of Settlement Period
71	CALC_PERHI	☐	ABRZO_KK	DATUM	DATS	8	0	Upper Limit of the Billing Period
72	PLAN_GRP	☐	FDGRP_KK	FDGRP	CHAR	10	0	Planning Group	T035
73	PLAN_LEVEL	☐	FDLEV_KK	FDLEV	CHAR	2	0	Planning level	T036
74	CM_EX_DAYS	☐	FDZTG_KK	NUM2	NUMC	2	0	Additional Days for Cash Management
75	AMOUNT_PLANNED	☐	BAPICURR_D	BAPICURR	DEC	23	4	Currency amount in BAPI interfaces
76	PART_CLRG	☐	XTAUS_KK	XFELD	CHAR	1	0	Item Split
77	RESTRICT	☐	AUGRS_KK	AUGRS_KK	CHAR	1	0	Clearing restriction
78	PAYMNT_GRP	☐	PYGRP_KK	CHAR10	CHAR	10	0	Grouping field for automatic payments
79	INT_BLOCK	☐	SPERZ_KK	SPERZ_KK	CHAR	1	0	Interest Lock Reason	TFK056S
80	INT_INFO	☐	INFOZ_KK	INFOZ_KK	NUMC	3	0	Doubtful Item Entry/Individual Value Adjustment
81	TAXJURCODE	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
82	TAX_DATE	☐	TXDAT_KK	DATUM	DATS	8	0	Decisive Date for Calculating Taxes
83	TRADE_ID	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
84	ACCTASSCAT	☐	KONTT_KK	KONTT_KK	CHAR	2	0	Account Assignment Category	TFK000K
85	ACCT_ASSGT	☐	KONTL_KK	CHAR50	CHAR	50	0	Acct assnmnt string for industry-specific account assngments
86	DUN_INDIC	☐	OPSTA_KK	OPSTA_KK	CHAR	3	0	Dunning indicator
87	DOC_TYPE	☐	BLART_KK	BLART_KK	CHAR	2	0	Document Type	TFK003
88	PARTNER	☐	EMGPA_KK	BU_PARTNER	CHAR	10	0	Alternative business partner for payments	BUT000
89	BK_DETAILS	☐	EMBVT_KK	CHAR4	CHAR	4	0	Bank Details ID of Payee
90	ADDR_NO	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
91	INT_KEY	☐	IKEY_KK	IKEY_KK	CHAR	2	0	Interest Key	TFK056A
92	EURO_STAT	☐	EUROU_KK	EUROU_KK	CHAR	1	0	Status of Euro Conversion
93	REVERSECLG	☐	XRAGL_KK	XFELD	CHAR	1	0	Clearing posting reversed
94	XREPETPOS	☐	XWHPO_KK	XFELD	CHAR	1	0	Expanded Repetition Item
95	STAT_KEY_SRC	☐	ASTKZ_KK	ASTKZ_KK	CHAR	1	0	Statistical Key of the Initiating Item
96	REF_DOC_NO	☐	XBLNR_KK	XBLNR_KK	CHAR	16	0	Reference document number
97	COLLECTION_POS	☐	INKPS_KK	NUM03	NUMC	3	0	Collection Item
98	REFERENCE_ITEM	☐	RFUPK_KK	OPUPK_KK	NUMC	4	0	Reference Item In FI-CA Document
99	OTHER_TAX_CODE	☐	STRKZ_KK	STRKZ_KK	CHAR	2	0	Tax Code for Other Taxes	*
100	TAX_CATEGORY	☐	J_1AFITP_D	J_1AFITP	CHAR	2	0	Tax type	*
101	CRD_DETAILS	☐	EMCRD_KK	CHAR6	CHAR	6	0	Alternative Payment Card ID in Document
102	FM_CATEGORY	☐	FMTYP_KK	FMTYP_KK	CHAR	2	0	Update Method for FM - FI-CA Integration
103	FM_ORIG_AREA	☐	ORIGFIKRS_KK	FIKRS	CHAR	4	0	Original FM Area for FM Account Assignment	*
104	CMMT_ITEM	☐	FM_FIPEX	FM_FIPEX	CHAR	24	0	Commitment item	*
105	FUNDS_CTR	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
106	FUND	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
107	FUNC_AREA	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
108	W_TAX_CODE	☐	QSSKZ	QSSKZ	CHAR	2	0	Withholding Tax Code	*
109	W_TAX_SUPPL	☐	QSSEW_KK	QSSEW_KK	CHAR	2	0	Withholding Tax Supplement	*
110	W_TAX_LICAT	☐	QSPTP_KK	QSPTP_KK	CHAR	1	0	Line Item Category From Withholding Tax View
111	W_TAX_BASE	☐	BP_QSSHB_KK	BAPICURR	DEC	23	4	Tax Base Amount
112	W_TAX_AMOUNT	☐	BP_QBSHB_KK	BAPICURR	DEC	23	4	Withholding Tax Amount in Document Currency
113	EXEMPT_NO	☐	QSZNR	CHAR10	CHAR	10	0	Certificate Number of the Withholding Tax Exemption
114	MEASURE	☐	FM_MEASURE	FM_MEASURE	CHAR	24	0	Funded Program	*
115	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
116	FISC_YEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
117	CLASS_KEY	☐	OPORD_KK	CHAR35	CHAR	35	0	Classification Key
118	SUB_APPLICATION	☐	SUBAP_KK	SUBAP_KK	CHAR	1	0	Subapplication in Contract Accounts Receivable and Payable
119	AMOUNT_GL	☐	BP_PSWBT_KK	BAPICURR	DEC	23	4	Amount for Updating in General Ledger
120	TAX_AMOUNT_GL	☐	BP_PSWTX_KK	BAPICURR	DEC	23	4	Tax Amount for Update in General Ledger
121	CURRENCY_GL	☐	PSWSL_KK	WAERS	CUKY	5	0	Update Currency for General Ledger Transaction Figures	*
122	CURRENCY_GL_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
123	FINAL_RECIPIENT	☐	FINRE_KK	VKONT_KK	CHAR	12	0	Contract Account of Final Recipient	*
124	SENDER_ID	☐	SENDR_KK	SENDR_KK	CHAR	3	0	Sender ID of Systems Connected to FI-CA
125	REFERENCE_POSITION	☐	REFKY_KK	CHAR35	CHAR	35	0	Reference Item for External Billing System
126	SEGMENT	☐	SEGMT_KK	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	*
127	STAT_TAX_AMOUNT	☐	BP_STTAX_KK	BAPICURR	DEC	23	4	Tax Amount as Statistical Information in Document Currency
128	EXTERNAL_SYSTEM	☐	REFSY_KK	REFSY_KK	CHAR	3	0	ID of External System
129	PORTION_TAX_AMOUNT_LOC	☐	BP_SCTAX_KK	BAPICURR	DEC	23	4	Tax Portion in FI-CA Local Currency
130	SEPA_MANDATE_ID	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
131	REFGUID	☐	RERAREFGUID	RECAGUID	RAW	16	0	Reference GUID
132	FLOW_TYPE	☐	RECDFLOWTYPE	RECDFLOWTYPE	CHAR	4	0	Flow Type	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	REXA_GUI_DOC_ITEM_L	ACCTASSCAT	TFK000K	KONTT		1	CN
2	REXA_GUI_DOC_ITEM_L	BUSPARTNER	BUT000	PARTNER		1	N
3	REXA_GUI_DOC_ITEM_L	BUS_AREA	TGSB	GSBER		1	CN
4	REXA_GUI_DOC_ITEM_L	CLEAR_REAS	TFK001A	AUGRD		1	CN
5	REXA_GUI_DOC_ITEM_L	CLRG_CURR	TCURC	WAERS
6	REXA_GUI_DOC_ITEM_L	COMP_CODE	T001	BUKRS
7	REXA_GUI_DOC_ITEM_L	CONT_ACCT	FKKVK	VKONT		1	N
8	REXA_GUI_DOC_ITEM_L	CURRENCY	TCURC	WAERS		1	N
9	REXA_GUI_DOC_ITEM_L	DIVISION	TSPA	SPART		1	CN
10	REXA_GUI_DOC_ITEM_L	DOC_TYPE	TFK003	BLART		1	N
11	REXA_GUI_DOC_ITEM_L	DUNN_BLOCK	TFK047S	MANSP		1	CN
12	REXA_GUI_DOC_ITEM_L	DUNN_PROC	TFK047A	MAHNV
13	REXA_GUI_DOC_ITEM_L	G_L_ACCT	SKA1	SAKNR		1	CN
14	REXA_GUI_DOC_ITEM_L	INT_BLOCK	TFK056S	SPERZ		1	CN
15	REXA_GUI_DOC_ITEM_L	INT_KEY	TFK056A	IKEY		1	1
16	REXA_GUI_DOC_ITEM_L	MAIN_TRANS	TFKHVO	HVORG		1	CN
17	REXA_GUI_DOC_ITEM_L	OFFSET_TAX	SKA1	SAKNR		1	CN
18	REXA_GUI_DOC_ITEM_L	PARTNER	BUT000	PARTNER		1	CN
19	REXA_GUI_DOC_ITEM_L	PERIOD_KEY	TFK001P	PERSL		1	CN
20	REXA_GUI_DOC_ITEM_L	PLAN_GRP	T035	GRUPP		1	CN
21	REXA_GUI_DOC_ITEM_L	PLAN_LEVEL	T036	EBENE		1	CN
22	REXA_GUI_DOC_ITEM_L	PMNT_BLOCK	TFK008	ZAHLS		1	CN
23	REXA_GUI_DOC_ITEM_L	PMNT_METH	TFK042Z	ZLSCH
24	REXA_GUI_DOC_ITEM_L	SUB_TRANS	TFKTVO	TVORG		1	CN
25	REXA_GUI_DOC_ITEM_L	TAXJURCODE	TTXJ	TXJCD		1	CN
26	REXA_GUI_DOC_ITEM_L	TAX_ACCT	SKA1	SAKNR		1	CN
27	REXA_GUI_DOC_ITEM_L	TAX_CODE	T007A	MWSKZ		1	CN
28	REXA_GUI_DOC_ITEM_L	TRADE_ID	T880	RCOMP		1	CN

History

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