SAP ABAP Table REXA_GUI_DOC_PLAIN_L (FI-CA Document: Flat Display)

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_PLAIN_L	Table Relationship Diagram
Short Description	FI-CA Document: Flat Display

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

Foreign Keys

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

History

Last changed by/on	SAP	20131127
SAP Release Created in