SAP ABAP Table EPIC_S_BRS_ITEM (EPIC: Bank Reconciliation Statement Detail Item)

Hierarchy

☛

SAP_FIN (Software Component) SAP_FIN
⤷

FI-LOC (Application Component) Localization
⤷

ID-FI-EPIC-BRS (Package) Globalization: E-Payment Integration Bank Recon. Statement

Basic Data

Table Category	INTTAB	Structure
Structure	EPIC_S_BRS_ITEM	Table Relationship Diagram
Short Description	EPIC: Bank Reconciliation Statement Detail Item

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	ITEM_DATE	EPIC_BRS_ITEM_DATE		DATS	8	0	Doucument Item Date
2	DOCUMENT_NUM	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
3	DOCUMENT_ITEM_NUM	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
4	EBS_NUM	KUKEY_EB	KUKEY_EB	NUMC	8	0	Short key (surrogate)
5	EBS_ITEM_NUM	ESNUM_EB	NUM5	NUMC	5	0	Memo record number (line item number in bank statement)
6	SUBACCOUNT	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
7	SGTXT	SGTXT	TEXT50	CHAR	50	0	Item Text
8	BREM_AMOUNT	EPIC_BRS_DEBIT_ENTERPRISE	WERT7	CURR	13	2	Debit Amount of Bank Ledger for EPIC BRS
9	BPEM_AMOUNT	EPIC_BRS_CREDIT_ENTERPRISE	WERT7	CURR	13	2	Credit Amount of Enterprise Ledger for EPIC BRS
10	ERBM_AMOUNT	EPIC_BRS_DEBIT_BANK	WERT7	CURR	13	2	Debit Amount of Enterprise Ledger for EPIC BRS
11	EPBM_AMOUNT	EPIC_BRS_CREDIT_BANK	WERT7	CURR	13	2	Credit Amount of Bank Ledger for EPIC BRS
12	LOCAL_CURRENCY	WAERS	WAERS	CUKY	5	0	Currency Key	*
13	REMARK	EPIC_BRS_REMARK	EPIC_BRS_REMARK	CHAR	255	0	Remark
14	SOURCE	EPIC_BRS_SOURCE	EPIC_BRS_SOURCE	CHAR	1	0	Data Source
15	CATEGORY	EPIC_BRS_CATEGORY	EPIC_BRS_CATEGORY	CHAR	4	0	Bank Reconcilation Statement Category
16	DELETED	EPIC_BRS_BOOLEAN	EPIC_BRS_BOOLEAN	CHAR	1	0	EPIC: Bank Reconciliation Statement Boolean
17	BKTXT	BKTXT	TEXT25	CHAR	25	0	Document Header Text
18	DOCUMENT_FISCALYEAR	EPIC_BRS_DOC_YEAR	GJAHR	NUMC	4	0	Posting Year of Document for EPIC BRS
19	DOCUMENT_PERIOD	EPIC_BRS_DOC_PERIOD	MONAT	NUMC	2	0	Posting Period of Document for EPIC BRS
20	BUKRS	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
21	CLOSED	EPIC_BRS_BOOLEAN	EPIC_BRS_BOOLEAN	CHAR	1	0	EPIC: Bank Reconciliation Statement Boolean
22	GJAHR	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
23	MONAT	MONAT	MONAT	NUMC	2	0	Fiscal period
24	STMTNUMBER	EPIC_BRS_STATEMENT_NUMBER	NUM5	NUMC	5	0	Electronic Bank Statement Number
25	AUTO_CLEARED	EPIC_BRS_BOOLEAN	EPIC_BRS_BOOLEAN	CHAR	1	0	EPIC: Bank Reconciliation Statement Boolean
26	MANUAL_CLEARED	EPIC_BRS_BOOLEAN	EPIC_BRS_BOOLEAN	CHAR	1	0	EPIC: Bank Reconciliation Statement Boolean
27	MANUAL_CLEARED_TEMP	EPIC_BRS_CLEAR_CHECKBOX	EPIC_BRS_BOOLEAN	CHAR	1	0	Open Item Cleared or To Be Cleared
28	MANUAL_CLEAR_OPERATIONABLE	EPIC_BRS_BOOLEAN	EPIC_BRS_BOOLEAN	CHAR	1	0	EPIC: Bank Reconciliation Statement Boolean
29	FLD_STYL	LVC_T_STYL		TTYP	0	0
30	.INCLUDE				0	0	Structure for BSIS and BSAS
31	HKONT	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
32	AUGDT	AUGDT	DATUM	DATS	8	0	Clearing Date
33	AUGBL	AUGBL	BELNR	CHAR	10	0	Document Number of the Clearing Document
34	ZUONR	DZUONR	ZUONR	CHAR	18	0	Assignment number
35	BUDAT	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
36	BLDAT	BLDAT	DATUM	DATS	8	0	Document Date in Document
37	WAERS	WAERS	WAERS	CUKY	5	0	Currency Key	*
38	XBLNR	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
39	BLART	BLART	BLART	CHAR	2	0	Document type	*
40	BSCHL	BSCHL	BSCHL	CHAR	2	0	Posting Key	*
41	SHKZG	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
42	GSBER	GSBER	GSBER	CHAR	4	0	Business Area	*
43	MWSKZ	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
44	FKONT	FIPLS	FIPLS	NUMC	3	0	Financial Budget Item
45	DMBTR	DMBTR	WERT7	CURR	13	2	Amount in local currency
46	WRBTR	WRBTR	WERT7	CURR	13	2	Amount in document currency
47	MWSTS	MWSTS	WERT7	CURR	13	2	Tax Amount in Local Currency
48	WMWST	WMWST	WERT7	CURR	13	2	Tax amount in document currency
49	PROJN	PROJN	PROJN	CHAR	16	0	Old: Project number : No longer used --> PS_POSNR
50	AUFNR	AUFNR_NEU	AUFNR	CHAR	12	0	Order Number	*
51	WERKS	WERKS_D	WERKS	CHAR	4	0	Plant	*
52	KOSTL	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
53	ZFBDT	DZFBDT	DATUM	DATS	8	0	Baseline date for due date calculation
54	XOPVW	XOPVW	XFELD	CHAR	1	0	Indicator: Open Item Management?
55	VALUT	VALUT	DATUM	DATS	8	0	Fixed Value Date
56	BSTAT	BSTAT_D	BSTAT	CHAR	1	0	Document Status
57	BDIFF	BDIFF	WRTV7	CURR	13	2	Valuation Difference
58	BDIF2	BDIF2	WRTV7	CURR	13	2	Valuation Difference for the Second Local Currency
59	VBUND	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*
60	PSWSL	PSWSL	WAERS	CUKY	5	0	Update Currency for General Ledger Transaction Figures	*
61	WVERW	WVERW	WVERW	CHAR	1	0	Bill of Exchange Usage Type
62	DMBE2	DMBE2	WERT7	CURR	13	2	Amount in Second Local Currency
63	DMBE3	DMBE3	WERT7	CURR	13	2	Amount in Third Local Currency
64	MWST2	MWST2	WERT7	CURR	13	2	Tax Amount in Second Local Currency
65	MWST3	MWST3	WERT7	CURR	13	2	Tax Amount in Third Local Currency
66	BDIF3	BDIF3	WRTV7	CURR	13	2	Valuation Difference for the Third Local Currency
67	RDIF3	RDIF3	WRTV7	CURR	13	2	Exchange Rate Difference Realized for Third Local Currency
68	XRAGL	XRAGL	XFELD	CHAR	1	0	Indicator: Clearing was Reversed
69	PROJK	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
70	PRCTR	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
71	XSTOV	XSTOV	XFELD	CHAR	1	0	Indicator: Document is flagged for reversal
72	XARCH	XARCH	XFELD	CHAR	1	0	Indicator: Document already archived ?
73	PSWBT	PSWBT	WERT7	CURR	13	2	Amount for Updating in General Ledger
74	XNEGP	XNEGP	XFELD	CHAR	1	0	Indicator: Negative posting
75	RFZEI	RFZEI_CC	NUM03	NUMC	3	0	Payment Card Item
76	CCBTC	CCBTC	CCBTC	CHAR	10	0	Payment cards: Settlement run
77	XREF3	XREF3	CHAR20	CHAR	20	0	Reference key for line item
78	BUPLA	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place	*
79	PPDIFF	PPDIFF	WRTV7	CURR	13	2	Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments)
80	PPDIF2	PPDIF2	WRTV7	CURR	13	2	Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments)
81	PPDIF3	PPDIF3	WRTV7	CURR	13	2	Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments)
82	BEWAR	RMVCT	RMVCT	CHAR	3	0	Transaction type	*
83	IMKEY	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
84	DABRZ	DABRBEZ	DDAT	DATS	8	0	Reference date for settlement
85	INTRENO	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
86	GRANT_NBR	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
87	FKBER	FKBER	FKBER	CHAR	16	0	Functional Area	*
88	FIPOS	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
89	FISTL	FISTL	FISTL	CHAR	16	0	Funds Center	*
90	GEBER	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
91	PPRCT	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	*
92	BUZID	BUZID	CHAR1	CHAR	1	0	Identification of the Line Item
93	AUGGJ	AUGGJ	GJAHR	NUMC	4	0	Fiscal Year of Clearing Document
94	UZAWE	UZAWE	UZAWE	CHAR	2	0	Payment method supplement	*
95	SEGMENT	FB_SEGMENT	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	*
96	PSEGMENT	FB_PSEGMENT	FB_SEGMENT	CHAR	10	0	Partner Segment for Segmental Reporting	*
97	PGEBER	FM_PFUND	BP_GEBER	CHAR	10	0	Partner Fund	*
98	PGRANT_NBR	GM_GRANT_PARTNER	GM_GRANT_NBR	CHAR	20	0	Partner Grant
99	MEASURE	FM_MEASURE	FM_MEASURE	CHAR	24	0	Funded Program	*
100	BUDGET_PD	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period	*
101	PBUDGET_PD	FM_PBUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Partner Budget Period	*
102	.INCLUDE				0	0	EPIC: For ALV EBS Line Item Display
103	KWBTR	KWBTR_EB	WRTV7	CURR	13	2	Amount in account currency
104	KWAER	KWAER_EB	WAERS	CUKY	5	0	Account Currency Key	*
105	VALUT_EBS	VALUT	DATUM	DATS	8	0	Fixed Value Date
106	VB1OK	VB1OK_EB	CHAR1	CHAR	1	0	Update 1 OK
107	VB2OK	VB2OK_EB	CHAR1	CHAR	1	0	2nd update OK
108	VGINT	VGINT_EB	VGINT_EB	CHAR	4	0	Posting rule	*
109	VWEZW	VWEZW_EB	CHAR65	CHAR	65	0	Payment Notes
110	AVKON	KTONR_AV	KTONR	CHAR	10	0	Account Number
111	AVKOA	KOART_AV	KOART_AV	CHAR	1	0	Payment Advice Account Type
112	BUTXT	BUTXT_EB	CHAR50	CHAR	50	0	Bank posting text
113	FWBTR	FWBTR_EB	WRTV7	CURR	13	2	Foreign currency amount (different from account cuurency)
114	FWAER	FWAER_EB	WAERS	CUKY	5	0	Foreign currency key (unequal to account currency)	*
115	SPESK	SPESK_EB	WERT7	CURR	13	2	Fees in account currency
116	SPESF	SPESF_EB	WERT7	CURR	13	2	Fees in foreign currency (not same as account currency)
117	SGTXT_EBS	SGTXT	TEXT50	CHAR	50	0	Item Text
118	CHECT	CHECT	CHCKN	CHAR	13	0	Check number
119	GRPNR	GRPNR_EB	CHAR2	CHAR	2	0	Bundle number for grouping line items
120	BELNR	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
121	NBBLN	NBBLN_EB	BELNR	CHAR	10	0	Subledger document number
122	FNAM1	BDC_FNAM	DYNFNAM	CHAR	132	0	BDC field name
123	FVAL1	BDC_FVAL	F4CHAR132	CHAR	132	0	BDC field value
124	FKOA1	KOART_AV	KOART_AV	CHAR	1	0	Payment Advice Account Type
125	FNAM2	BDC_FNAM	DYNFNAM	CHAR	132	0	BDC field name
126	FVAL2	BDC_FVAL	F4CHAR132	CHAR	132	0	BDC field value
127	FKOA2	KOART_AV	KOART_AV	CHAR	1	0	Payment Advice Account Type
128	FNAM3	BDC_FNAM	DYNFNAM	CHAR	132	0	BDC field name
129	FVAL3	BDC_FVAL	F4CHAR132	CHAR	132	0	BDC field value
130	FKOA3	KOART_AV	KOART_AV	CHAR	1	0	Payment Advice Account Type
131	BVDAT	BVDAT_EB	DATE_EB	DATS	8	0	Posting date at the bank
132	BUTIM	BUTIM_EB	TIME6	CHAR	6	0	Value date time
133	VORGC	VORGC_EB	CHAR3	CHAR	3	0	Business transaction code
134	TEXTS	TEXTS_EB	CHAR4	CHAR	4	0	Text key
135	VGEXT	VGEXT_EB	VGEXT_EB	CHAR	27	0	External business transaction	*
136	VGMAN	VGMAN_EB	VGMAN_EB	CHAR	4	0	Transaction	*
137	KFMOD	KFMOD_EB	KFMOD_EB	CHAR	10	0	Account modification
138	XBLNR_EBS	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
139	ZUONR_EBS	DZUONR	ZUONR	CHAR	18	0	Assignment number
140	PABKS	PABKS_EB	LAND1	CHAR	3	0	Country key of partner bank	*
141	PABLZ	PABLZ_EB	BANKK	CHAR	15	0	Bank number of partner bank
142	PASWI	PASWI_EB	SWIFT	CHAR	11	0	SWIFT code of partner bank
143	PAKTO	PAKTO_EB	BANKN	CHAR	18	0	Account number at the partner bank
144	PIBAN	PIBAN_EB	IBAN	CHAR	34	0	Partner Bank Account: IBAN
145	PARTN	PARTN_EB	CHAR55	CHAR	55	0	Business Partner
146	GSBER_EBS	GSBER_EB	CHAR4	CHAR	4	0	Business area
147	PRCTR_EBS	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
148	KOSTL_EBS	KOSTL_EB	CHAR10	CHAR	10	0	Cost center
149	VERTN	RANL	RANL	CHAR	13	0	Contract Number
150	VERTT	RANTYP	RANTYP	CHAR	1	0	Contract Type
151	PNOTA	PNOTA_EB	CHAR10	CHAR	10	0	Daybook number
152	INFO1	INFO1_EB	CHAR30	CHAR	30	0	Additional information 1
153	INFO2	INFO2_EB	CHAR30	CHAR	30	0	Additional information 2
154	INTAG	INTAG_EB	INTAG_EB	NUMC	3	0	Interpretation algorithm
155	KURSF	KURSF_EB	KURSF	DEC	9	5	Exchange rate (different from local currency)
156	VGREF	REFBK	CHAR35	CHAR	35	0	Bank Reference Number
157	ARRSK	ARRSK_EB	WERT7	CURR	13	2	Overdue charges from/to partners in account currency
158	PFORM	PFORM_EB	PFORM	NUMC	2	0	Processing Type
159	KIDNO	KIDNO	CHAR30	CHAR	30	0	Payment Reference
160	MANSP	MANSP	MANSP	CHAR	1	0	Dunning block	*
161	IDENR	IDENR	IDENR	NUMC	10	0	ID number for cash management and forecast
162	B1APP	APPLK_BF	APPLK_BF	CHAR	6	0	Application Indicator	*
163	B1STD	ADDST_EB	XFELD	CHAR	1	0	X - Standard (FI) posting should be suppressed
164	B1DOC	DOC_NUMBER	CHAR70	CHAR	70	0	Doc. no. (IDoc number, application document no., etc.)
165	B2APP	APPLK_BF	APPLK_BF	CHAR	6	0	Application Indicator	*
166	B2STD	ADDST_EB	XFELD	CHAR	1	0	X - Standard (FI) posting should be suppressed
167	B2DOC	DOC_NUMBER	CHAR70	CHAR	70	0	Doc. no. (IDoc number, application document no., etc.)
168	NAME1	FELDN_F05A	CHAR5	CHAR	5	0	Field Name from the Document Index
169	VALUE1	SEL01_F05A	CHAR20	CHAR	20	0	Input Field for Search Criterion for Selecting Open Items
170	NAME2	FELDN_F05A	CHAR5	CHAR	5	0	Field Name from the Document Index
171	VALUE2	SEL01_F05A	CHAR20	CHAR	20	0	Input Field for Search Criterion for Selecting Open Items
172	NAME3	FELDN_F05A	CHAR5	CHAR	5	0	Field Name from the Document Index
173	VALUE3	SEL01_F05A	CHAR20	CHAR	20	0	Input Field for Search Criterion for Selecting Open Items
174	COLOR_ROW			CHAR	4	0
175	COLOR_CELLS	LVC_T_SCOL		TTYP	0	0