RBKP SAP (Document Header: Invoice Receipt) Table details
Dictionary Type: Table
Description: Document Header: Invoice Receipt
Description: Document Header: Invoice Receipt
Table field list including key, data, relationships and ABAP select examples
RBKP is a standard SAP Table which is used to store Document Header: Invoice Receipt data and is available within R/3 SAP systems depending on the version and release level.
The RBKP table consists of various fields, each holding specific information or linking keys about Document Header: Invoice Receipt data available in SAP. These include BELNR (Document Number of an Invoice Document), GJAHR (Fiscal Year), BLART (Document Type), BLDAT (Document Date in Document).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP RBKP table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
BELNR | Document Number of an Invoice Document | RE_BELNR | CHAR | 10 | ALPHA | BELNR | RBN | ||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
BLART | Document Type | BLART | CHAR | 2 | T003 | BLART | BAR | ||
BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
USNAM | User name | USNAM | CHAR | 12 | Assigned to domain | XUBNAME | USR | ||
TCODE | Transaction Code | TCODE | CHAR | 20 | TSTC | TCODE | TCD | ||
CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATS | 8 | DATUM | ||||
CPUTM | Time of Entry | CPUTM | TIMS | 6 | UZEIT | ||||
VGART | Transaction Type in AG08 (Internal Document Type) | M8VGA | CHAR | 2 | M8VGA | ||||
XBLNR | Reference Document Number | XBLNR1 | CHAR | 16 | XBLNR1 | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
LIFNR | Different Invoicing Party | LIFRE | CHAR | 10 | LFA1 | ALPHA | LIFNR | LRE | |
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
KURSF | Exchange rate | KURSF | DEC | 9(5) | EXCRT | KURSF | |||
RMWWR | Gross invoice amount in document currency | RMWWR | CURR | 13(2) | WERT7 | ||||
BEZNK | Unplanned delivery costs | BEZNK | CURR | 13(2) | ANLKWERT | ||||
WMWST1 | Tax Amount in Document Currency with +/- Sign | FWSTEV | CURR | 13(2) | WERTV7 | ||||
MWSKZ1 | Tax code | MWSKZ_MRM1 | CHAR | 2 | TMRM007A | MRM_MWSKZ | |||
WMWST2 | Obsolete: tax amount in document currency - do NOT use! | FWSTEV_OLD | CURR | 13(2) | WERTV7 | ||||
MWSKZ2 | Obsolete: sales tax code | MWSKZ_MRMO | CHAR | 2 | T007A | MWSKZ | |||
ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
ZBD1T | Cash discount days 1 | DZBD1T | DEC | 3 | ZBDXT | ||||
ZBD1P | Cash Discount Percentage 1 | DZBD1P | DEC | 5(3) | PRZ23 | ||||
ZBD2T | Cash discount days 2 | DZBD2T | DEC | 3 | ZBDXT | ||||
ZBD2P | Cash Discount Percentage 2 | DZBD2P | DEC | 5(3) | PRZ23 | ||||
ZBD3T | Net Payment Terms Period | DZBD3T | DEC | 3 | ZBDXT | ||||
WSKTO | Cash discount amount in document currency | WSKTO | CURR | 13(2) | WERT7 | ||||
XRECH | Indicator: post invoice | XRECH | CHAR | 1 | XRADI | ||||
BKTXT | Document Header Text | BKTXT | CHAR | 25 | TEXT25 | ||||
SAPRL | SAP Release | SAPRL | CHAR | 4 | SAPRL | ||||
LOGSYS | Logical system | LOGSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
XMWST | Calculate tax automatically | XMWST | CHAR | 1 | XFELD | XTX | |||
STBLG | Reversal document number | RE_STBLG | CHAR | 10 | ALPHA | BELNR | |||
STJAH | Fiscal year of reversal document | RE_STJAH | NUMC | 4 | GJAHR | GJAHR | |||
MWSKZ_BNK | Tax Code | MWSKZ_MRM | CHAR | 2 | T007A | MWSKZ | |||
TXJCD_BNK | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
IVTYP | Origin of a Logistics Invoice Verification Document | IVTYP | CHAR | 1 | IVTYP | ||||
XRBTX | Indicator: more than one tax code | XRBTX | CHAR | 1 | XFELD | ||||
REPART | Indicator: Invoice Verification Type | REPART | CHAR | 1 | REPART | ||||
RBSTAT | Invoice document status | RBSTAT | CHAR | 1 | RBSTAT | ||||
KNUMVE | Document condition - own conditions | KNUMVE | CHAR | 10 | KNUMV | ||||
KNUMVL | Document condition - vendor error | KNUMVL | CHAR | 10 | KNUMV | ||||
ARKUEN | Automatic Invoice Reduction Amount (Net) | ARKUEN | CURR | 13(2) | WERTV7 | ||||
ARKUEMW | Sales Tax Portion of Automatic Invoice Reduction Amount | ARKUEMW | CURR | 13(2) | WERTV7 | ||||
MAKZN | Manually accepted net difference amount | MAKZN | CURR | 13(2) | WERTV7 | ||||
MAKZMW | Tax Amount Accepted Manually | MAKZMW | CURR | 13(2) | WERTV7 | ||||
LIEFFN | Vendor error (exclusive of tax) | LIEFFN | CURR | 13(2) | WERTV7 | ||||
LIEFFMW | Tax in vendor error | LIEFFMW | CURR | 13(2) | WERTV7 | ||||
XAUTAKZ | Indicates automatically accepted invoices | XAUTAKZ | CHAR | 1 | XFELD | ||||
ESRNR | ISR Subscriber Number | ESRNR | CHAR | 11 | ESRNR | ||||
ESRPZ | ISR Check Digit | ESRPZ | CHAR | 2 | CHAR2 | ||||
ESRRE | ISR Reference Number | ESRRE | CHAR | 27 | ALPHA | ESRRE | |||
QSSHB | Withholding Tax Base Amount | QSSHB | CURR | 13(2) | WERT7 | ||||
QSFBT | Withholding Tax-Exempt Amount (in Document Currency) | QSFBT | CURR | 13(2) | WERT7 | ||||
QSSKZ | Withholding Tax Code | QSSKZ | CHAR | 2 | T059Q | QSSKZ | |||
DIEKZ | Service Indicator (Foreign Payment) | DIEKZ | CHAR | 1 | DIEKZ | ||||
LANDL | Supplying Country | LANDL | CHAR | 3 | T005 | LAND1 | |||
LZBKZ | State Central Bank Indicator | LZBKZ | CHAR | 3 | T015L | LZBKZ | |||
TXKRS | Exchange Rate for Taxes | TXKRS_BKPF | DEC | 9(5) | KURSF | ||||
EMPFB | Payee/Payer | EMPFB | CHAR | 10 | ALPHA | MAXKK | |||
BVTYP | Partner Bank Type | BVTYP | CHAR | 4 | BVTYP | ||||
HBKID | Short Key for a House Bank | HBKID | CHAR | 5 | T012 | HBKID | |||
ZUONR | Assignment Number | DZUONR | CHAR | 18 | ZUONR | ||||
ZLSPR | Payment Block Key | DZLSPR | CHAR | 1 | T008 | ZAHLS | SPE | ||
ZLSCH | Payment Method | DZLSCH | CHAR | 1 | T042Z | ZLSCH | |||
ZFBDT | Baseline Date for Due Date Calculation | DZFBDT | DATS | 8 | DATUM | ||||
KIDNO | Payment Reference | KIDNO | CHAR | 30 | CHAR30 | ||||
REBZG | Invoice Reference: Document Number for Invoice Reference | AWREF_REB | CHAR | 10 | ALPHA | AWREF | |||
REBZJ | Fiscal Year of the Relevant Invoice (for Credit Memo) | REBZJ | NUMC | 4 | GJAHR | GJAHR | |||
XINVE | Indicator: Capital Goods Affected? | XINVE | CHAR | 1 | XFELD | ||||
EGMLD | Reporting Country for Delivery of Goods within the EU | EGMLD_BSEZ | CHAR | 3 | Assigned to domain | LAND1 | |||
XEGDR | Indicator: Triangular deal within the EU ? | XEGDR | CHAR | 1 | XFELD | ||||
VATDATE | Tax Reporting Date | VATDATE | DATS | 8 | DATUM | ||||
HKONT | General Ledger Account | HKONT | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
J_1BNFTYPE | Nota Fiscal Type | J_1BNFTYPE | CHAR | 2 | J_1BAA | J_1BNFTYPE | |||
BRNCH | Branch Number | J_1ABRNCH | CHAR | 4 | J_1BBRANCH | J_1BBRANCH | JEA | ||
ERFPR | Entry profile: Logistics Invoice Verification | ERFPR | CHAR | 12 | T169H | ERFPR | RPR | ||
SECCO | Section Code | SECCO | CHAR | 4 | SECCODE | SECCO | SECCO_ABA | ||
NAME1 | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
NAME2 | Name 2 | NAME2_GP | CHAR | 35 | NAME | ||||
NAME3 | Name 3 | NAME3_GP | CHAR | 35 | NAME | ||||
NAME4 | Name 4 | NAME4_GP | CHAR | 35 | NAME | ||||
PSTLZ | Postal Code | PSTLZ | CHAR | 10 | PSTLZ | ||||
ORT01 | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
LAND1 | Country Key | LAND1_GP | CHAR | 3 | Assigned to domain | LAND1 | C_LAND1 | ||
STRAS | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
PFACH | PO Box | PFACH | CHAR | 10 | PFACH | ||||
PSTL2 | P.O. Box Postal Code | PSTL2 | CHAR | 10 | PSTLZ | ||||
PSKTO | Account Number of Bank Account At Post Office | PSKTO | CHAR | 16 | PSKTO | ||||
BANKN | Bank account number | BANKN | CHAR | 18 | BANKN | ||||
BANKL | Bank number | BANKL | CHAR | 15 | BANKL | BLZ | |||
BANKS | Bank country key | BANKS | CHAR | 3 | Assigned to domain | LAND1 | BKL | ||
STCD1 | Tax Number 1 | STCD1 | CHAR | 16 | STCD1 | ||||
STCD2 | Tax Number 2 | STCD2 | CHAR | 11 | STCD2 | ||||
STKZU | Liable for VAT | STKZU | CHAR | 1 | XFELD | ||||
STKZA | Indicator: Business Partner Subject to Equalization Tax? | STKZA | CHAR | 1 | STKZA | ||||
REGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
BKONT | Bank Control Key | BKONT | CHAR | 2 | BKONT | ||||
DTAWS | Instruction key for data medium exchange | DTAWS | CHAR | 2 | Assigned to domain | DTAWS | |||
DTAMS | Indicator for Data Medium Exchange | DTAMS | CHAR | 1 | DTAMS | ||||
SPRAS | Character field of length 1 | CHAR_LG_01 | CHAR | 1 | CHAR_LG_01 | ||||
XCPDK | Indicator: Is the account a one-time account? | XCPDK | CHAR | 1 | XFELD | ||||
EMPFG | Payee code | EMPFG | CHAR | 16 | EMPFG | ||||
FITYP | Tax type | J_1AFITP_D | CHAR | 2 | Assigned to domain | J_1AFITP | |||
STCDT | Tax Number Type | J_1ATOID | CHAR | 2 | Assigned to domain | J_1ATOID | |||
STKZN | Natural Person | STKZN | CHAR | 1 | STKZN | ||||
STCD3 | Tax Number 3 | STCD3 | CHAR | 18 | CHAR18 | ||||
STCD4 | Tax Number 4 | STCD4 | CHAR | 18 | CHAR18 | ||||
BKREF | Reference specifications for bank details | BKREF | CHAR | 20 | CHAR20 | ||||
J_1KFREPRE | Name of Representative | REPRES | CHAR | 10 | REPRES | ||||
J_1KFTBUS | Type of Business | GESTYP | CHAR | 30 | Assigned to domain | GESTYP | |||
J_1KFTIND | Type of Industry | INDTYP | CHAR | 30 | Assigned to domain | INDTYP | |||
ANRED | Title | ANRED | CHAR | 15 | TEXT15 | ||||
STCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
ERNAME | Entered by external system user | ERNAME | CHAR | 12 | SBNAM | ||||
REINDAT | Invoice Receipt Date | REINDAT | DATS | 8 | DATUM | ||||
UZAWE | Payment Method Supplement | UZAWE | CHAR | 2 | Assigned to domain | UZAWE | |||
FDLEV | Planning level | FDLEV | CHAR | 2 | Assigned to domain | FDLEV | FFE | ||
FDTAG | Planning date | FDTAG | DATS | 8 | DATUM | FDT | |||
ZBFIX | Fixed Payment Terms | DZBFIX | CHAR | 1 | ZBFIX | ||||
FRGKZ | Indicator: Release Required | DFRGKZ | CHAR | 1 | XFELD | ||||
ERFNAM | Name of the Processor Who Entered the Object | ERFNAM | CHAR | 12 | USNAM | ||||
BUPLA | Business Place | BUPLA | CHAR | 4 | Assigned to domain | J_1BBRANCH | |||
FILKD | Account Number of the Branch | FILKD | CHAR | 10 | ALPHA | MAXKK | |||
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
LOTKZ | Lot Number for Documents | LOTKZ | CHAR | 10 | ALPHA | LOTKZ | LOT | ||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
INV_TRAN | Transaction in Logistics Invoice Verification | INV_TRAN | CHAR | 1 | MRM_VORGANG | ||||
PREPAY_STATUS | Prepayment Status | WRF_PREPAY_STATUS | CHAR | 1 | WRF_PREPAY_STATUS | ||||
PREPAY_AWKEY | Invoice Document Number Created for Prepayment | WRF_PREPAY_AWKEY | CHAR | 20 | AWKEY | ||||
ASSIGN_STATUS | Is the invoice in the assignment test process? | WRF_MRM_ASSIGN_STATUS | CHAR | 1 | WRF_MRM_ASSIGN_STATUS | ||||
ASSIGN_NEXT_DATE | Date of Next Assignment Test | WRF_MRM_ASSIGN_NEXT_DATE | DATS | 8 | |||||
ASSIGN_END_DATE | End Date of Assignment Test Period | WRF_MRM_ASSIGN_END_DATE | DATS | 8 | |||||
COPY_BY_BELNR | Invoice Document Number of Original Invoice | COPY_BY_BELNR | CHAR | 10 | ALPHA | BELNR | |||
COPY_BY_YEAR | Fiscal Year of Original Invoice | COPY_BY_YEAR | NUMC | 4 | GJAHR | GJAHR | |||
COPY_TO_BELNR | Invoice Document Number of Copied Invoice | COPY_TO_BELNR | CHAR | 10 | ALPHA | BELNR | |||
COPY_TO_YEAR | Fiscal Year of Copied Invoice | COPY_TO_YEAR | NUMC | 4 | GJAHR | GJAHR | |||
COPY_USER | User That Reversed and Copied the Invoice | COPY_USER | CHAR | 12 | USNAM | ||||
KURSX | Market Data Exchange Rate | GLE_FXR_DTE_RATEX28 | DEC | 28(14) | EXCRX | GLE_FXR_RATEX28 | |||
WWERT | Translation Date | WWERT_D | DATS | 8 | DATUM | ||||
XREF3 | Reference key for line item | XREF3 | CHAR | 20 | CHAR20 |
Key field | Non-key field |
How do I retrieve data from SAP table RBKP using ABAP code
The following ABAP code Example will allow you to do a basic selection on RBKP to SELECT all data from the tableDATA: WA_RBKP TYPE RBKP.
SELECT SINGLE *
FROM RBKP
INTO CORRESPONDING FIELDS OF WA_RBKP
WHERE...
How to access SAP table RBKP
Within an ECC or HANA version of SAP you can also view further information about RBKP and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects