1. Home
  2. Resources
  3. SAP Tables
  4. RECP_RA_INVOICE_C - RE Invoice

SAP Table RECP_RA_INVOICE_C

RE Invoice

RECP_RA_INVOICE_C (RE Invoice) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link RECP_RA_INVOICE_C to other SAP tables.

RECP_RA_INVOICE_C table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
INVGUID GUID: Unique Internal Key for RE Invoice RERAINVGUID RAW 16 0
BUKRS Company Code BUKRS CHAR 4 0
INVNO Invoice Number RERAINVNO NUMC 10 0
FISC_YEAR Fiscal Year GJAHR NUMC 4 0
PROCESSGUID Generic Key of Process RECAPROCESSGUID VICAPROCESSID RAW 16 0
PARTNER Business Partner Number BU_PARTNER CHAR 10 0
ADDRTYPE Address Type REBPADDRTYPE CHAR 10 0
ROLE Business Partner: Role REBPROLE CHAR 6 0
ITEMSELIND Type of Selection of Invoice Items RERAINVITEMSELIND CHAR 1 0
NULL Only Items from FI Documents
P Only Planned Items from Cash Flow
B From FI Documents and Cash Flow
DUEDATEFROM Start Date of Due Period of the Items RERADUEDATEFROM DATS 8 0
DUEDATETO End Date of Due Period of the Items RERADUEDATETO DATS 8 0
INCLCLEAREDITEMS Also Consider Cleared Items? RERAINVINCLCLEAREDITEMS CHAR 1 0
X Yes
NULL No
CLEARCREDITITEMS Also Consider Credit Memo Items? RERAINVCLEARCREDITITEMS CHAR 1 0
X Yes
NULL No
ALLOPENITEMS Also Consider Items Already Invoiced? RERAINVALLOPENITEMS CHAR 1 0
X Yes
NULL No
COLLECTIND Grouping Option: Summarize Invoices RERAINVCOLLECTIND CHAR 1 0
1 Per Recipient (Might Include Multiple Contracts)
4 Per Contract
CUSTOMER Customer Number RERACUSTOMERNO CHAR 10 0
OBJNR Object Number of Only Contract of Invoice, Otherwise Blank RERAINVOBJNRSINGLE CHAR 22 0
OBJCOUNT Number of Contracts in This Invoice RERAINVOBJCOUNT INT4 10 0
ISCREDITMEMO Credit Memo? RERAINVISCREDITMEMO CHAR 1 0
X Yes
NULL No
ISMINORAMOUNT Trivial Amount? RERAINVISMINORAMOUNT CHAR 1 0
X Yes
NULL No
CURRENCY Currency Key WAERS CUKY 5 0
TOTALGROSSAMOUNT Full Amount of Invoice RERAINVTOTALAMOUNT CURR 15 2
TOTALNETAMOUNT Net Amount of Invoice RERAINVTOTALNETAMOUNT CURR 15 2
TOTALTAXAMOUNT Tax Amount of Invoice RERAINVTOTALTAXAMOUNT CURR 15 2
RERF Entered by RERF CHAR 12 0
DERF First Entered on DERF DATS 8 0
TERF Time of Initial Entry TERF TIMS 6 0
REHER Source of initial entry REHER CHAR 10 0
RBEAR Employee ID RBEAR CHAR 12 0
DBEAR Last Edited on DBEAR DATS 8 0
TBEAR Last Edited at TBEAR TIMS 6 0
RBHER Editing Source RBHER CHAR 10 0
CANCELED Invoice Reversed? RERAINVCANCELED CHAR 1 0
X Yes
NULL No
SFDOCGUID GUID for Document to be Output RECPSFDOCGUID RAW 16 0
PRINTEDON Invoice Last Printed On RERAINVPRINTEDON DATS 8 0
PRINTEDBY Invoice Last Printed By RERAINVPRINTEDBY CHAR 12 0
PROCESSID Invoicing Run ID RERAINVPROCESSID CHAR 16 0
XNAME Short Name of Business Partner REBPXNAME CHAR 50 0
XPARTNER Name/Address of Business Partner REBPXPARTNER CHAR 80 0
IDENTKEY External ID of Contract, for Example, 1000/123 RERAINVIDENTKEYSINGLE CHAR 45 0
PARTNER_BD Business Partner Number BU_PARTNER BUT000 CHAR 10 0
BKVID_BD Bank details ID BU_BKVID CHAR 4 0
BANKS_BD Bank Country Key BU_BANKS T005 CHAR 3 0
BANKL_BD Bank Key BU_BANKK CHAR 15 0
BANKN_BD Bank Account Number BU_BANKN CHAR 18 0
BKONT_BD Bank Control Key BU_BKONT CHAR 2 0
BKREF_BD Reference Details for Bank Details BU_BKREF CHAR 20 0
KOINH_BD Account Holder Name BU_KOINH CHAR 60 0
BKEXT_BD Bank details ID in external system BU_BKEXT CHAR 20 0
XEZER_BD Indicator: Collection Authorization BU_XEZER CHAR 1 0
X Yes
NULL No
ACCNAME_BD Name of Bank Account BU_BANKACCNAME CHAR 40 0
MOVE_BKVID_BD ID of Target Details for Change of Bank Details (BP) BU_MOVE_BKVID CHAR 4 0
BK_VALID_FROM_BD Validity Start of Business Partner Bank Details BU_BK_VALID_FROM DEC 15 0
BK_VALID_TO_BD Validity End of Business Partner Bank Details BU_BK_VALID_TO DEC 15 0
BK_MOVE_DATE_BD Date of Change to Bank Details (BP) BU_BK_MOVE_DATE DEC 15 0
IBAN_BD IBAN (International Bank Account Number) BU_IBAN CHAR 34 0
BANK_GUID_BD Bank GUID BU_BANK_GUID RAW 16 0
ACCOUNT_ID_BD Bank Account Number (New) BU_ACCOUNT_ID CHAR 35 0
CHECK_DIGIT_BD Bank Account Check Digit BU_ACCOUNT_CHECK CHAR 2 0
ACCOUNT_TYPE_BD Bank Account Type BU_ACCOUNT_TYPE CHAR 3 0
MANDT_BK_BD Client MANDT T000 CLNT 3 0
BANKS_BK_BD Bank country key BANKS T005 CHAR 3 0
BANKL_BK_BD Bank Keys BANKK CHAR 15 0
ERDAT_BK_BD Date on which the record was created ERDAT_BF DATS 8 0
ERNAM_BK_BD Name of person who created the object ERNAM_BF CHAR 12 0
BANKA_BK_BD Name of bank BANKA CHAR 60 0
PROVZ_BK_BD Region (State, Province, County) REGIO T005S CHAR 3 0
STRAS_BK_BD House number and street STRAS_GP CHAR 35 0
ORT01_BK_BD City ORT01_GP CHAR 35 0
SWIFT_BK_BD SWIFT/BIC for International Payments SWIFT CHAR 11 0
BGRUP_BK_BD Bank group (bank network) BGRUP CHAR 2 0
XPGRO_BK_BD Post Office Bank Current Account XPGRO CHAR 1 0
X Yes
NULL No
LOEVM_BK_BD Deletion Indicator LOEVM CHAR 1 0
X Yes
NULL No
BNKLZ_BK_BD Bank number BANKL CHAR 15 0
PSKTO_BK_BD Post office bank current account number PSKTO_CH CHAR 16 0
ADRNR_BK_BD Address number AD_ADDRNUM CHAR 10 0
BRNCH_BK_BD Bank Branch BRNCH CHAR 40 0
CHKME_BK_BD Check digit calculation method CHECKMETH CHAR 4 0
VERS_BK_BD Format of File with Bank Data VERS_BF CHAR 3 0
BICKY_BK_BD Key of a BIC+ data record (Swift) PRQ_BICKY CHAR 12 0
RCCODE_BK_BD Routing control code PRQ_RCC CHAR 15 0
TESTMODE Test Mode (Invoice Not Yet Saved) RERAINVTESTMODE CHAR 1 0
X Yes
NULL No
XDATERANGEDUEDATE Time Period (Text) RECAXDATERANGE CHAR 23 0
TOTALGROSSAMOUNT_ABS Full Amount of Invoice RERAINVTOTALAMOUNT CURR 15 2
TOTALNETAMOUNT_ABS Net Amount of Invoice RERAINVTOTALNETAMOUNT CURR 15 2
TOTALTAXAMOUNT_ABS Tax Amount of Invoice RERAINVTOTALTAXAMOUNT CURR 15 2
CUKY2ND Second Currency for Correspondence RECPCUKY2ND CUKY 5 0
TOTALGROSSAMOUNT_2ND Amount in 2nd Currency RECACURR2ND CURR 15 2
TOTALNETAMOUNT_2ND Amount in 2nd Currency RECACURR2ND CURR 15 2
TOTALTAXAMOUNT_2ND Amount in 2nd Currency RECACURR2ND CURR 15 2
TOTALGROSSAMOUNT_ABS_2ND Amount in 2nd Currency RECACURR2ND CURR 15 2
TOTALNETAMOUNT_ABS_2ND Amount in 2nd Currency RECACURR2ND CURR 15 2
TOTALTAXAMOUNT_ABS_2ND Amount in 2nd Currency RECACURR2ND CURR 15 2
ISPOSTCDCURR Invoice Contains Items Posted in Condition Currency RERAINVISPOSTCDCURR CHAR 1 0
X Yes
NULL No

RECP_RA_INVOICE_C foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
RECP_RA_INVOICE_C BANKS_BD RECP_RA_INVOICE_C BANKS_BD T005 Countries LAND1
RECP_RA_INVOICE_C BANKS_BD BUT0BK MANDT T005 Countries MANDT
RECP_RA_INVOICE_C BANKS_BK_BD RECP_RA_INVOICE_C MANDT_BK_BD T005 Countries MANDT
RECP_RA_INVOICE_C BANKS_BK_BD RECP_RA_INVOICE_C BANKS_BK_BD T005 Countries LAND1
RECP_RA_INVOICE_C MANDT_BK_BD RECP_RA_INVOICE_C MANDT_BK_BD T000 Clients MANDT
RECP_RA_INVOICE_C PARTNER_BD SYST MANDT BUT000 BP: General data I CLIENT
RECP_RA_INVOICE_C PARTNER_BD RECP_RA_INVOICE_C PARTNER_BD BUT000 BP: General data I PARTNER
RECP_RA_INVOICE_C PROCESSGUID SYST MANDT VICAPROCESSID Process MANDT
RECP_RA_INVOICE_C PROCESSGUID RECP_RA_INVOICE_C PROCESSGUID VICAPROCESSID Process .INCLUDE
RECP_RA_INVOICE_C PROCESSGUID ' ' VICAPROCESSID Process PROCESSGUID
RECP_RA_INVOICE_C PROVZ_BK_BD RECP_RA_INVOICE_C MANDT_BK_BD T005S Taxes: Region (Province) Key MANDT
RECP_RA_INVOICE_C PROVZ_BK_BD RECP_RA_INVOICE_C BANKS_BK_BD T005S Taxes: Region (Province) Key LAND1
RECP_RA_INVOICE_C PROVZ_BK_BD RECP_RA_INVOICE_C PROVZ_BK_BD T005S Taxes: Region (Province) Key BLAND