SAP ABAP Table RFWERE00_COLLECT_INF (Information from Table BKPF/BSEG/EKKo/EKPO/LFA1/LFB1)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FREP (Package) RF reporting

Basic Data

Table Category	INTTAB	Structure
Structure	RFWERE00_COLLECT_INF	Table Relationship Diagram
Short Description	Information from Table BKPF/BSEG/EKKo/EKPO/LFA1/LFB1

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	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
2	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
3	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
4	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
5	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
6	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
7	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
8	BUZEI	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
9	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
10	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
11	BLART	☐	BLART	BLART	CHAR	2	0	Document type	*
12	DMBTR	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
13	WRBTR	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
14	DMBE2	☐	DMBE2	WERT7	CURR	13	2	Amount in Second Local Currency
15	DMBE3	☐	DMBE3	WERT7	CURR	13	2	Amount in Third Local Currency
16	AUGDT	☐	AUGDT	DATUM	DATS	8	0	Clearing Date
17	XOPVW	☐	XOPVW	XFELD	CHAR	1	0	Indicator: Open Item Management?
18	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
19	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
20	EKKO_EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
21	EKKO_LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
22	EKKO_WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
23	EKPO_EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
24	EKPO_MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
25	EKPO_RETPO	☐	RETPO	XFELD	CHAR	1	0	Returns Item
26	LFA1_LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
27	LFA1_VBUND	☐	VBUND	RCOMP	CHAR	6	0	Company ID	*
28	LFB1_BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
29	LFB1_AKONT	☐	AKONT	SAKNR	CHAR	10	0	Reconciliation Account in General Ledger	*
30	.INCLUDE	☐				0	0	Name in GL - Required for Postings
31	.INCLUDE	☐				0	0
32	NIX	☐	XFELD	XFELD	CHAR	1	0	Checkbox

History

Last changed by/on	SAP	20130529
SAP Release Created in