SAP ABAP Table RECP_RA_INVOICE_C (RE Invoice)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX-CP (Application Component) Correspondence
     ⤷ RE_CP_SD (Package) RE: Data Retrieval (for Mass Print)

Basic Data

Table Category	INTTAB	Structure
Structure	RECP_RA_INVOICE_C	Table Relationship Diagram
Short Description	RE Invoice

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	RE Invoice Header and Additional Fields
2	.INCLUDE	☐				0	0	RE Invoice Header
3	.INCLUDE	☐				0	0	RE Invoice Header
4	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
5	INVGUID	☐	RERAINVGUID	RECAGUID	RAW	16	0	GUID: Unique Internal Key for RE Invoice
6	.INCLUDE	☐				0	0	RE Invoice Header: Key Fields
7	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
8	INVNO	☐	RERAINVNO	RERAINVNO	NUMC	10	0	Invoice Number
9	FISC_YEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
10	.INCLUDE	☐				0	0	RE Invoice Header: Non-Key Fields
11	PROCESSGUID	☐	RECAPROCESSGUID	RECAGUID	RAW	16	0	Generic Key of Process	VICAPROCESSID
12	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
13	ADDRTYPE	☐	REBPADDRTYPE	BU_ADRKIND	CHAR	10	0	Address Type	*
14	ROLE	☐	REBPROLE	BU_ROLE	CHAR	6	0	Business Partner: Role	*
15	.INCLUDE	☐				0	0	Options That Are Saved in Invoice Header
16	ITEMSELIND	☐	RERAINVITEMSELIND	RERAINVITEMSELIND	CHAR	1	0	Type of Selection of Invoice Items
17	DUEDATEFROM	☐	RERADUEDATEFROM	RECADATEBEG	DATS	8	0	Start Date of Due Period of the Items
18	DUEDATETO	☐	RERADUEDATETO	RECADATEEND	DATS	8	0	End Date of Due Period of the Items
19	INCLCLEAREDITEMS	☐	RERAINVINCLCLEAREDITEMS	RECABOOL	CHAR	1	0	Also Consider Cleared Items?
20	CLEARCREDITITEMS	☐	RERAINVCLEARCREDITITEMS	RECABOOL	CHAR	1	0	Also Consider Credit Memo Items?
21	ALLOPENITEMS	☐	RERAINVALLOPENITEMS	RECABOOL	CHAR	1	0	Also Consider Items Already Invoiced?
22	COLLECTIND	☐	RERAINVCOLLECTIND	RERAINVCOLLECTIND	CHAR	1	0	Grouping Option: Summarize Invoices
23	CUSTOMER	☐	RERACUSTOMERNO	RERAPARTNERNO	CHAR	10	0	Customer Number
24	OBJNR	☐	RERAINVOBJNRSINGLE	J_OBJNR	CHAR	22	0	Object Number of Only Contract of Invoice, Otherwise Blank	*
25	OBJCOUNT	☐	RERAINVOBJCOUNT	INT4	INT4	10	0	Number of Contracts in This Invoice
26	ISCREDITMEMO	☐	RERAINVISCREDITMEMO	RECABOOL	CHAR	1	0	Credit Memo?
27	ISMINORAMOUNT	☐	RERAINVISMINORAMOUNT	RECABOOL	CHAR	1	0	Trivial Amount?
28	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
29	TOTALGROSSAMOUNT	☐	RERAINVTOTALAMOUNT	RECACURR	CURR	15	2	Full Amount of Invoice
30	TOTALNETAMOUNT	☐	RERAINVTOTALNETAMOUNT	RECACURR	CURR	15	2	Net Amount of Invoice
31	TOTALTAXAMOUNT	☐	RERAINVTOTALTAXAMOUNT	RECACURR	CURR	15	2	Tax Amount of Invoice
32	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
33	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
34	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
35	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
36	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
37	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
38	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
39	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
40	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
41	CANCELED	☐	RERAINVCANCELED	RECABOOL	CHAR	1	0	Invoice Reversed?
42	SFDOCGUID	☐	RECPSFDOCGUID	RECAGUID	RAW	16	0	GUID for Document to be Output
43	PRINTEDON	☐	RERAINVPRINTEDON	RECADATE	DATS	8	0	Invoice Last Printed On
44	PRINTEDBY	☐	RERAINVPRINTEDBY	SYCHAR12	CHAR	12	0	Invoice Last Printed By
45	PROCESSID	☐	RERAINVPROCESSID	RECAPROCESSID	CHAR	16	0	Invoicing Run ID
46	XNAME	☐	REBPXNAME	BU_TEXT50	CHAR	50	0	Short Name of Business Partner
47	XPARTNER	☐	REBPXPARTNER	TEXT80	CHAR	80	0	Name/Address of Business Partner
48	IDENTKEY	☐	RERAINVIDENTKEYSINGLE	CHAR45	CHAR	45	0	External ID of Contract, for Example, 1000/123
49	.INCLU-_BD	☐				0	0	Bank Details of Business Partner
50	.INCLUDE	☐				0	0	BP: Bank details (Read)
51	PARTNER_BD	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
52	BKVID_BD	☐	BU_BKVID	CHAR4	CHAR	4	0	Bank details ID
53	.INCLUDE	☐				0	0	BP: Bank Details (Data Fields - External)
54	.INCLUDE	☐				0	0	BP: Bank Details (CHAR Data Fields External)
55	BANKS_BD	☐	BU_BANKS	LAND1	CHAR	3	0	Bank Country Key	T005
56	BANKL_BD	☐	BU_BANKK	CHAR15	CHAR	15	0	Bank Key
57	BANKN_BD	☐	BU_BANKN	CHAR18	CHAR	18	0	Bank Account Number
58	BKONT_BD	☐	BU_BKONT	CHAR2	CHAR	2	0	Bank Control Key
59	BKREF_BD	☐	BU_BKREF	CHAR20	CHAR	20	0	Reference Details for Bank Details
60	KOINH_BD	☐	BU_KOINH	BU_KOINH	CHAR	60	0	Account Holder Name
61	BKEXT_BD	☐	BU_BKEXT	CHAR20	CHAR	20	0	Bank details ID in external system
62	XEZER_BD	☐	BU_XEZER	XFELD	CHAR	1	0	Indicator: Collection Authorization
63	ACCNAME_BD	☐	BU_BANKACCNAME	BU_BKCCNAME	CHAR	40	0	Name of Bank Account
64	MOVE_BKVID_BD	☐	BU_MOVE_BKVID	CHAR4	CHAR	4	0	ID of Target Details for Change of Bank Details (BP)
65	.INCLUDE	☐				0	0	BP: Bank Details (Non-CHAR Data Fields External)
66	BK_VALID_FROM_BD	☐	BU_BK_VALID_FROM	TZNTSTMPS	DEC	15	0	Validity Start of Business Partner Bank Details
67	BK_VALID_TO_BD	☐	BU_BK_VALID_TO	TZNTSTMPS	DEC	15	0	Validity End of Business Partner Bank Details
68	BK_MOVE_DATE_BD	☐	BU_BK_MOVE_DATE	TZNTSTMPS	DEC	15	0	Date of Change to Bank Details (BP)
69	.INCLUDE	☐				0	0	BP: Bank Details (External Bank Data)
70	IBAN_BD	☐	BU_IBAN	CHAR34	CHAR	34	0	IBAN (International Bank Account Number)
71	BANK_GUID_BD	☐	BU_BANK_GUID	UUID	RAW	16	0	Bank GUID
72	ACCOUNT_ID_BD	☐	BU_ACCOUNT_ID	CHAR35	CHAR	35	0	Bank Account Number (New)
73	CHECK_DIGIT_BD	☐	BU_ACCOUNT_CHECK	CHAR2	CHAR	2	0	Bank Account Check Digit
74	ACCOUNT_TYPE_BD	☐	BU_ACCOUNT_TYPE	CHAR3	CHAR	3	0	Bank Account Type
75	.INCLU-_BK	☐				0	0	Bank master record
76	MANDT_BK_BD	☐	MANDT	MANDT	CLNT	3	0	Client	T000
77	BANKS_BK_BD	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
78	BANKL_BK_BD	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
79	ERDAT_BK_BD	☐	ERDAT_BF	DATUM	DATS	8	0	Date on which the record was created
80	ERNAM_BK_BD	☐	ERNAM_BF	USNAM	CHAR	12	0	Name of person who created the object
81	BANKA_BK_BD	☐	BANKA	TEXT60	CHAR	60	0	Name of bank
82	PROVZ_BK_BD	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
83	STRAS_BK_BD	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
84	ORT01_BK_BD	☐	ORT01_GP	TEXT35	CHAR	35	0	City
85	SWIFT_BK_BD	☐	SWIFT	SWIFT	CHAR	11	0	SWIFT/BIC for International Payments
86	BGRUP_BK_BD	☐	BGRUP	BGRUP	CHAR	2	0	Bank group (bank network)
87	XPGRO_BK_BD	☐	XPGRO	XFELD	CHAR	1	0	Post Office Bank Current Account
88	LOEVM_BK_BD	☐	LOEVM	XFELD	CHAR	1	0	Deletion Indicator
89	BNKLZ_BK_BD	☐	BANKL	BANKL	CHAR	15	0	Bank number
90	PSKTO_BK_BD	☐	PSKTO_CH	PSKTO	CHAR	16	0	Post office bank current account number
91	ADRNR_BK_BD	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
92	BRNCH_BK_BD	☐	BRNCH	TEXT40	CHAR	40	0	Bank Branch
93	CHKME_BK_BD	☐	CHECKMETH	CHECKMETH	CHAR	4	0	Check digit calculation method
94	VERS_BK_BD	☐	VERS_BF	VERS_BF	CHAR	3	0	Format of File with Bank Data	*
95	.INCLUDE	☐				0	0	Bank Master Data (Additional Fields for SEPA)
96	IBAN_RULE_BK_BD	☐	IBAN_RULE	IBAN_RULE	CHAR	6	0	IBAN Rule
97	SDD_B2B_BK_BD	☐	SDD_B2B	SDD_B2B	NUMC	1	0	Support of SEPA B2B Direct Debit
98	SDD_COR1_BK_BD	☐	SDD_COR1	SDD_COR1	NUMC	1	0	Support of SEPA COR1 Direct Debit
99	SDD_RTRANS_BK_BD	☐	SDD_RTRANS	SDD_RTRANS	NUMC	1	0	Support of SEPA Returned Debits (R Transactions)
100	.INCLU--AP	☐				0	0	Appendix to Table BNKA
101	BICKY_BK_BD	☐	PRQ_BICKY	PRQ_BICKY	CHAR	12	0	Key of a BIC+ data record (Swift)
102	RCCODE_BK_BD	☐	PRQ_RCC	CHAR15	CHAR	15	0	Routing control code
103	TESTMODE	☐	RERAINVTESTMODE	RECABOOL	CHAR	1	0	Test Mode (Invoice Not Yet Saved)
104	XDATERANGEDUEDATE	☐	RECAXDATERANGE	CHAR23	CHAR	23	0	Time Period (Text)
105	TOTALGROSSAMOUNT_ABS	☐	RERAINVTOTALAMOUNT	RECACURR	CURR	15	2	Full Amount of Invoice
106	TOTALNETAMOUNT_ABS	☐	RERAINVTOTALNETAMOUNT	RECACURR	CURR	15	2	Net Amount of Invoice
107	TOTALTAXAMOUNT_ABS	☐	RERAINVTOTALTAXAMOUNT	RECACURR	CURR	15	2	Tax Amount of Invoice
108	CUKY2ND	☐	RECPCUKY2ND	WAERS	CUKY	5	0	Second Currency for Correspondence	*
109	TOTALGROSSAMOUNT_2ND	☐	RECACURR2ND	RECACURR	CURR	15	2	Amount in 2nd Currency
110	TOTALNETAMOUNT_2ND	☐	RECACURR2ND	RECACURR	CURR	15	2	Amount in 2nd Currency
111	TOTALTAXAMOUNT_2ND	☐	RECACURR2ND	RECACURR	CURR	15	2	Amount in 2nd Currency
112	TOTALGROSSAMOUNT_ABS_2ND	☐	RECACURR2ND	RECACURR	CURR	15	2	Amount in 2nd Currency
113	TOTALNETAMOUNT_ABS_2ND	☐	RECACURR2ND	RECACURR	CURR	15	2	Amount in 2nd Currency
114	TOTALTAXAMOUNT_ABS_2ND	☐	RECACURR2ND	RECACURR	CURR	15	2	Amount in 2nd Currency
115	ISPOSTCDCURR	☐	RERAINVISPOSTCDCURR	RECABOOL	CHAR	1	0	Invoice Contains Items Posted in Condition Currency

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RECP_RA_INVOICE_C	BANKS_BD	T005	LAND1	REF	1	CN
2	RECP_RA_INVOICE_C	BANKS_BK_BD	T005	LAND1	KEY	1	CN
3	RECP_RA_INVOICE_C	MANDT_BK_BD	T000	MANDT	KEY	1	CN
4	RECP_RA_INVOICE_C	PARTNER_BD	BUT000	PARTNER	KEY	1	CN
5	RECP_RA_INVOICE_C	PROVZ_BK_BD	T005S	BLAND

History

Last changed by/on	SAP	20140121
SAP Release Created in	500