RBDRSEG SAP (Batch IV: Invoice Document Items) Table details
Dictionary Type: Table
Description: Batch IV: Invoice Document Items
Description: Batch IV: Invoice Document Items
Table field list including key, data, relationships and ABAP select examples
RBDRSEG is a standard SAP Table which is used to store Batch IV: Invoice Document Items data and is available within R/3 SAP systems depending on the version and release level.
The RBDRSEG table consists of various fields, each holding specific information or linking keys about Batch IV: Invoice Document Items data available in SAP. These include RBLNR (Document Number of an Invoice Document), RJAHR (Fiscal Year), RBLGP (Document Item in Invoice Document), BPMNG (Quantity in Purchase Order Price Unit).. 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 RBDRSEG 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 | |||
RBLNR | Document Number of an Invoice Document | RE_BELNR | CHAR | 10 | ALPHA | BELNR | RBN | ||
RJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
RBLGP | Document Item in Invoice Document | RBLGP | NUMC | 6 | NUMC6 | ||||
BPMNG | Quantity in Purchase Order Price Unit | BPMNG | QUAN | 13(3) | MENG13 | ||||
BPREM | Invoice receipt quantity in order price unit | BPREM | QUAN | 13(3) | MENG13 | ||||
BPRME | Order Price Unit (Purchasing) | BPRME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
BPUMN | Denominator for Conv. of Order Price Unit into Order Unit | BPUMN | DEC | 5 | UMBSN | ||||
BPUMZ | Numerator for Conversion of Order Price Unit into Order Unit | BPUMZ | DEC | 5 | UMBSZ | ||||
BPWEM | Goods Receipt Quantity in Purchase Order Price Unit | BPWEM | QUAN | 13(3) | MENG13 | ||||
BSMNG | Quantity Ordered Against this Purchase Requisition | BSMNG | QUAN | 13(3) | MENG13 | ||||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
BWTAR | Valuation Type | BWTAR_D | CHAR | 10 | Assigned to domain | BWTAR | BWT | ||
DMBTR | Amount in Local Currency | DMBTR | CURR | 13(2) | WERT7 | ||||
EBELN | Purchase Order Number | BSTNR | CHAR | 10 | Assigned to domain | ALPHA | EBELN | BES | |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | Assigned to domain | EBELP | BSP | ||
EINDT | Item Delivery Date | EINDT | DATS | 8 | DATUM | ||||
EREKZ | Final Invoice Indicator | EREKZ | CHAR | 1 | XFELD | ||||
FRBNR | Number of Bill of Lading at Time of Goods Receipt | FRBNR1 | CHAR | 16 | XBLNR1 | ||||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
HSWAE | Local currency key | HSWAE | CUKY | 5 | Assigned to domain | WAERS | |||
LFBNR | Document No. of a Reference Document | LFBNR | CHAR | 10 | ALPHA | BELNR | |||
LFGJA | Fiscal Year of Current Period | LFGJA | NUMC | 4 | GJAHR | GJAHR | |||
LFPOS | Item of a Reference Document | LFPOS | NUMC | 4 | MBLPO | ||||
KNTTP | Account Assignment Category | KNTTP | CHAR | 1 | Assigned to domain | KNTTP | KNT | ||
KSCHL | Condition Type | KSCHL | CHAR | 4 | Assigned to domain | KSCHL | VKS | ||
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
MEINS | Purchase Order Unit of Measure | BSTME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
MENGE | Quantity | MENGE_D | QUAN | 13(3) | MENG13 | ||||
MEPRF | Price Determination (Pricing) Date Control | MEPRF | CHAR | 1 | MEPRF | ||||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
NETPR | Net price | NETPR | CURR | 11(2) | WERTV6 | ||||
NETWR | Net order value in document currency | BSTWR | CURR | 13(2) | WERT7 | ||||
PSTYP | Item Category in Purchasing Document | PSTYP | CHAR | 1 | Assigned to domain | PSTYP | |||
REFWR | Invoice value in foreign currency | REFWR | CURR | 13(2) | WRTV7 | ||||
REMNG | Quantity invoiced | REMNG | QUAN | 13(3) | MENG13 | ||||
RETPO | Returns Item | RETPO | CHAR | 1 | XFELD | ||||
SCHPR | Indicator: Estimated Price | SCHPR | CHAR | 1 | XFELD | ||||
SELKZ | Selection flag | SELKZ | CHAR | 1 | SELKZ | ||||
SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
SPGRC | Block.reason: quality | SPGRC | CHAR | 1 | XFELD | ||||
SPGRG | Blocking reason: order price quantity | SPGRG | CHAR | 1 | XFELD | ||||
SPGRM | Blocking reason: quantity | SPGRM | CHAR | 1 | XFELD | ||||
SPGRP | Blocking reason: price | SPGRP | CHAR | 1 | XFELD | ||||
SPGRQ | Manual Blocking Reason | SPGRQ | CHAR | 1 | XFELD | ||||
SPGRS | Blocking Reason: Item Amount | SPGRS | CHAR | 1 | XFELD | ||||
SPGRT | Blocking Reason: Date | SPGRT | CHAR | 1 | XFELD | ||||
SPGRV | Blocking reason: project budget | SPGRV | CHAR | 1 | XFELD | ||||
STUNR | Step number | STUNR | NUMC | 3 | Assigned to domain | STUNR | |||
TBTKZ | Indicator: subsequent debit/credit | TBTKZ | CHAR | 1 | TBTKZ | ||||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
TXZ01 | Short Text | TXZ01 | CHAR | 40 | TEXT40 | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
WEBRE | Indicator: GR-Based Invoice Verification | WEBRE | CHAR | 1 | XFELD | ||||
WEMNG | Quantity of Goods Received | WEMNG | QUAN | 13(3) | MENG13 | ||||
WEPOS | Goods Receipt Indicator | WEPOS | CHAR | 1 | XFELD | ||||
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
WRBTR | Amount in document currency | WRBTR | CURR | 13(2) | WERT7 | ||||
WMWST | Tax amount in document currency | WMWST | CURR | 13(2) | WERT7 | ||||
XBLNR | Number of External Delivery Note | LFSNR1 | CHAR | 16 | XBLNR1 | ||||
XEKBE | Indicator: update purchase order history | XEKBE | CHAR | 1 | XFELD | ||||
XEKBZ | Indicator: Update Purchase Order Delivery Costs | XEKBZ | CHAR | 1 | XFELD | ||||
ZAEHK | Condition counter | DZAEHK | NUMC | 2 | ZAEHK | ||||
ZEKKN | Sequential Number of Account Assignment | DZEKKN | NUMC | 2 | NUM02 | ||||
LSMNG | Quantity in Unit of Measure from Delivery Note | LSMNG | QUAN | 13(3) | MENG13 | ||||
LSMEH | Unit of Measure From Delivery Note | LSMEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
BASME | Base unit of measure | F_MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
XUBNKR | Indicates: Not relevant for unplanned delivery costs? | XUBNKR | CHAR | 1 | XFELD | ||||
GRICD | Activity Code for Gross Income Tax | J_1AGICD_D | CHAR | 2 | J_1AGICD | J_1AGICD2 | |||
GRIRG | STATE (State, Province, County) | REGIO | CHAR | 3 | T005S | REGIO | |||
GITYP | Distribution Type for Employment Tax | J_1ADTYP_D | CHAR | 2 | J_1ADTYP | J_1ADTYP | |||
MBLNR | Number of Material Document | MBLNR | CHAR | 10 | ALPHA | BELNR | MBN | ||
MJAHR | Material Document Year | MJAHR | NUMC | 4 | GJAHR | GJAHR | MJA | ||
MBLPO | Item in Material Document | MBLPO | NUMC | 4 | MBLPO | POS | |||
KNUMVK | Number of the document condition | KNUMV | CHAR | 10 | KNUMV | ||||
KNUMV | Number of the document condition | KNUMV | CHAR | 10 | KNUMV | ||||
KNUMVR | Number of the document condition | KNUMV | CHAR | 10 | KNUMV | ||||
SATNR | Cross-Plant Configurable Material | SATNR | CHAR | 18 | MARA | MATN1 | MATNR | ||
EAN11 | International Article Number (EAN/UPC) | EAN11 | CHAR | 18 | EAN11 | EAN11 | EAN | ||
IDNLF | Material Number Used by Vendor | IDNLF | CHAR | 35 | IDNEX | ||||
AKTNR | COUPON | WAKTION | CHAR | 10 | WAKH | ALPHA | WAKTION | WAK | |
UPVOR | Subitems Exist | UPVOR | CHAR | 1 | CHAR1 | ||||
UPTYP | Subitem Category, Purchasing Document | UPTYP | CHAR | 1 | TMSI1 | UPTYP | |||
UEBPO | Higher-Level Item in Purchasing Documents | UEBPO | NUMC | 5 | EKPO | EBELP | |||
SRVPOS | Service number | SRVPOS | CHAR | 18 | Assigned to domain | ALPHA | ASNUM | ||
PACKNO | Package Number of Service | PACKNO_EKBE | NUMC | 10 | Assigned to domain | PACKNO | |||
INTROW | Line Number of Service | INTROW_EKBE | NUMC | 10 | INTROW | ||||
LEBRE | Indicator for Service-Based Invoice Verification | LEBRE | CHAR | 1 | XFELD | ||||
BEKKN | Number of PO Account Assignment | BEKKN | NUMC | 2 | NUM02 | ||||
PLN_PACKNO | Source package number | PLN_PACKNO | NUMC | 10 | Assigned to domain | PACKNO | |||
PLN_INTROW | Entry: Planned package line | PLN_INTROW | NUMC | 10 | Assigned to domain | PACKNO | |||
LIEFFN | Vendor error (exclusive of tax) | LIEFFN | CURR | 13(2) | WERTV7 | ||||
RBWWR | Invoice amount in document currency of vendor invoice | RBWWR | CURR | 13(2) | WERT7 | ||||
RBMNG | Qty invoiced in vendor invoice in PO order units | RBMNG | QUAN | 13(3) | MENG13V | ||||
BPRBM | Qty invoiced in vendor invoice in PO price units | BPRBM | QUAN | 13(3) | MENG13V | ||||
KZMEK | Correction indicator | KZMEKORR | CHAR | 1 | KZMEKORR | ||||
MENGEALT | Quantity | MENGE_D | QUAN | 13(3) | MENG13 | ||||
BPMNGALT | Quantity in Purchase Order Price Unit | BPMNG | QUAN | 13(3) | MENG13 | ||||
WRBTRALT | Amount in document currency | WRBTR | CURR | 13(2) | WERT7 | ||||
XUPDA | Select | MARKE | CHAR | 1 | CHAR1 | ||||
EFKOR | Type of correction to own error | EFKOR | CHAR | 1 | EFKOR | ||||
LFKOR | Type of vendor error | LFEHL | CHAR | 1 | LFEHL | ||||
OK | Indicator: invoice item processed | MRMOK | CHAR | 1 | XFELD | ||||
COMPLAINT_REASON | Complaints Reason in an Invoice | COMPLAINT_REASON | CHAR | 2 | Assigned to domain | COMPLAINT_REASON | |||
WEUNB | Goods Receipt, Non-Valuated | WEUNB | CHAR | 1 | XFELD | ||||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
REWWR | Invoice Amount in Foreign Currency | REWWR | CURR | 13(2) | WERT7 | ||||
WEREC | Clearing Indicator for GR/IR Posting for External Services | MMWEREC | CHAR | 1 | XFELD | ||||
KZBWS | Valuation of Special Stock | KZBWS | CHAR | 1 | KZBWS | ||||
XSKRL | Indicator: Line item not liable to cash discount? | XSKRL | CHAR | 1 | XFELD | ||||
VRTKZ | Distribution indicator for multiple account assignment | VRTKZ | CHAR | 1 | VRTKZ | ||||
RETTP | Retention Indicator | RETTP | CHAR | 1 | RET_TYPE | ||||
RETAMT_FC | Retention Amount in Document Currency | RET_AMT_FC | CURR | 13(2) | WERT7 | ||||
RETPC | Retention in Percent | RETPZ | DEC | 5(2) | PRZ32 | ||||
RETDUEDT | Due Date for Retention | RET_DUE_DATE | DATS | 8 | DATUM | ||||
XRETTAXNET | Tax Reduction for Retention | RET_TAXNET | CHAR | 1 | XFELD | ||||
XDINV | Indicator for Differential Invoicing | XDINV | CHAR | 1 | CHAR1 | ||||
INV_ITM_ORIGIN | Origin of an Invoice Item | INV_ITM_ORIGIN | CHAR | 1 | INV_ITM_ORIGIN | ||||
INVREL | Grouping Characteristic for Invoice Verification | INVREL | NUMC | 6 | NUMC6 | ||||
DIFF_AMOUNT | Difference Amount (in Document Currency) | DIFFERENCE_AMOUNT | CURR | 13(2) | ANLKWERT | ||||
CHARG | Batch Number | CHARG_D | CHAR | 10 | Assigned to domain | CHARG | CHA | ||
XCPRF | Checkbox for Commodity Repricing in Invoice Verification | XCPRF | CHAR | 1 | CHAR1 | ||||
XHISTMA | Update Multiple Account Assignment EKBE_MA, EKBZ_MA | XHISTMA | CHAR | 1 | CHAR1 |
Key field | Non-key field |
How do I retrieve data from SAP table RBDRSEG using ABAP code
The following ABAP code Example will allow you to do a basic selection on RBDRSEG to SELECT all data from the tableDATA: WA_RBDRSEG TYPE RBDRSEG.
SELECT SINGLE *
FROM RBDRSEG
INTO CORRESPONDING FIELDS OF WA_RBDRSEG
WHERE...
How to access SAP table RBDRSEG
Within an ECC or HANA version of SAP you can also view further information about RBDRSEG 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