SAP ABAP Table EPIC_S_EBR_OPEN_ITEM_CLR (Clearing IO Processing Infomation)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-LOC (Application Component) Localization
     ⤷ ID-FI-EPIC-EBR (Package) Globalization: E-Payment Integration Bank Receipt

Basic Data

Table Category	INTTAB	Structure
Structure	EPIC_S_EBR_OPEN_ITEM_CLR	Table Relationship Diagram
Short Description	Clearing IO Processing Infomation

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	PART_ID	☐	EPIC_EBR_PART_ID	KTONR	CHAR	10	0	Account Involved in Bank Receipt Transaction
2	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
3	BLART	☐	BLART	BLART	CHAR	2	0	Document type	*
4	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
5	BUZEI	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
6	UMSKS	☐	UMSKS	UMSKS	CHAR	1	0	Special G/L Transaction Type
7	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
8	XBLNR	☐	XBLNR	XBLNR	CHAR	16	0	Reference Document Number
9	WRBTR	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
10	DMBTR	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
11	VAT_REMAINED_AMOUNT	☐	EPIC_EBR_VAT_AMT_SURPLUS	WERT7	CURR	13	2	Remaining Amount with VAT Added
12	VAT_CLAIMED_AMOUNT	☐	EPIC_EBR_VAT_AMT_CLAIMED	WERT7	CURR	13	2	Claimed Amount with VAT Added
13	TOTAL_AMT	☐	EPIC_EBR_TOTAL_AMT	WERT7	CURR	13	2	Total Amount of Claimed Bank Receipts
14	AMT_CLAIMED	☐	EPIC_EBR_AMT_CLAIMED	WERT7	CURR	13	2	Bank Receipt Amount That Has Been Claimed
15	REMAINED_AMOUNT	☐	EPIC_EBR_AMT_SURPLUS	WERT7	CURR	13	2	Remaining Amount on Bank Receipt
16	CLAIMED_DATE	☐	EPIC_EBR_CLAIMED_DATE	DATUM	DATS	8	0	Claimed On
17	CLR_TYPE	☐	EPIC_EBR_CLEAR_TYPE	CHAR1	CHAR	1	0	Clearing Type
18	.INCLUDE	☐				0	0	Key of Electronic Bank Receipt
19	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
20	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	T012
21	HKTID	☐	HKTID	HKTID	CHAR	5	0	ID for account details	T012K
22	EBR_ID	☐	EPIC_EBR_ID	SYSUUID	RAW	16	0	Bank Receipt Identifier
23	SGTXT	☐	TEXT50	TEXT50	CHAR	50	0	Text Field
24	SHZUZ	☐	SHZUZ	CHAR1	CHAR	1	0	Debit/Credit Addition for Cash Discount
25	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
26	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
27	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
28	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
29	ZUONR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
30	UMSKZ	☐	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator	*
31	XREF1	☐	XREF1	CHAR12	CHAR	12	0	Business partner reference key
32	XREF2	☐	XREF2	CHAR12	CHAR	12	0	Business partner reference key
33	XREF3	☐	XREF3	CHAR20	CHAR	20	0	Reference key for line item
34	PART_TYPE	☐	EPIC_EBR_PART_TYPE	KOART_AV	CHAR	1	0	Code for Account Type Involved in Bank Receipt Transaction
35	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EPIC_S_EBR_OPEN_ITEM_CLR	BUKRS	T001	BUKRS	KEY	1	CN
2	EPIC_S_EBR_OPEN_ITEM_CLR	HBKID	T012	HBKID	KEY	1	CN
3	EPIC_S_EBR_OPEN_ITEM_CLR	HKTID	T012K	HKTID	KEY	1	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in