SAP table RSEG (Document Item: Incoming Invoice)

SAP table RSEG has 4 primary key fields being MANDT,BELNR,GJAHR,BUZEI.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
BELNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
GJAHR Fiscal Year NUMC 4 0 GJAHR
BUZEI Document Item in Invoice Document NUMC 6 0 RBLGP
EBELN Purchasing Document Number CHAR 10 0 EKKO EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 EKPO EBELP
ZEKKN Sequential Number of Account Assignment NUMC 2 0 DZEKKN
MATNR Material Number CHAR 40 0 MARA MATNR
BWKEY Valuation area CHAR 4 0 T001K BWKEY
BWTAR Valuation Type CHAR 10 0 T149D BWTAR_D
BUKRS Company Code CHAR 4 0 T001 BUKRS
WERKS Plant CHAR 4 0 T001W WERKS_D
WRBTR Amount in Document Currency CURR 13 2 WRBTR_CS
SHKZG Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
MWSKZ Tax on sales/purchases code CHAR 2 0 T007A MWSKZ
TXJCD Tax Jurisdiction CHAR 15 0 TTXJ TXJCD
MENGE Quantity QUAN 13 3 MENGE_D
BSTME Purchase Order Unit of Measure UNIT 3 0 T006 BSTME
BPMNG Quantity in Purchase Order Price Unit QUAN 13 3 BPMNG
BPRME Order Price Unit (Purchasing) UNIT 3 0 T006 BPRME
LBKUM Total Valuated Stock QUAN 13 3 LBKUM
VRKUM Total valuated stock in the previous posting period QUAN 13 3 VRKUM
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
PSTYP Item category in purchasing document CHAR 1 0 T163 PSTYP
KNTTP Account Assignment Category CHAR 1 0 T163K KNTTP
BKLAS Valuation Class CHAR 4 0 T025 BKLAS
EREKZ Final Invoice Indicator CHAR 1 0 EREKZ
EXKBE Indicator: update purchase order history CHAR 1 0 XEKBE
XEKBZ Indicator: Update Purchase Order Delivery Costs CHAR 1 0 XEKBZ
TBTKZ Indicator: Subsequent Debit/Credit CHAR 1 0 TBTKZ
SPGRP Blocking Reason: Price CHAR 1 0 SPGRP
SPGRM Blocking Reason: Quantity CHAR 1 0 SPGRM
SPGRT Blocking Reason: Date CHAR 1 0 SPGRT
SPGRG Blocking Reason: Order Price Quantity CHAR 1 0 SPGRG
SPGRV Blocking Reason: Project Budget CHAR 1 0 SPGRV
SPGRQ Manual Blocking Reason CHAR 1 0 SPGRQ
SPGRS Blocking Reason: Item Amount CHAR 1 0 SPGRS
SPGRC Blocking Reason: Quality CHAR 1 0 SPGRC
SPGREXT Blocking Reason Enhancement Fields CHAR 1 0 SPGREXT
BUSTW Posting String for Values CHAR 4 0 BUSTW
XBLNR Reference Document Number CHAR 16 0 XBLNR1
XRUEB Indicator: Document Is Posted to a Previous Period CHAR 1 0 XRUEB
BNKAN Delivery costs' share of item value CURR 13 2 BNK_ANTEIL
KSCHL Condition Type CHAR 4 0 KSCHL
SALK3 Value of Total Valuated Stock CURR 13 2 SALK3
VMSAL Value of total valuated stock in previous period CURR 13 2 VMSAL
XLIFO LIFO/FIFO-Relevant CHAR 1 0 XLIFO
LFBNR Document No. of a Reference Document CHAR 10 0 LFBNR
LFGJA Fiscal Year of Current Period NUMC 4 0 LFGJA
LFPOS Item of a Reference Document NUMC 4 0 LFPOS
MATBF Material in Respect of Which Stock is Managed CHAR 40 0 MATBF
RBMNG Quantity Invoiced in Supplier Invoice in PO Order Units QUAN 13 3 RBMNG
BPRBM Quantity Invoiced in Supplier Invoice in PO Price Units QUAN 13 3 BPRBM
RBWWR Invoice Amount in Document Currency of Supplier Invoice CURR 13 2 RBWWR
LFEHL Type of Supplier Error CHAR 1 0 LFEHL
No supplier error
1 Price error
2 Conditions error
3 Quantity error
4 Quantity error + price error
5 Quantity error + condition error
GRICD Activity Code for Gross Income Tax CHAR 2 0 J_1AGICD J_1AGICD_D
GRIRG Region (State, Province, County) CHAR 3 0 T005S REGIO
GITYP Distribution Type for Employment Tax CHAR 2 0 J_1ADTYP J_1ADTYP_D
PACKNO Package Number of Service NUMC 10 0 PACKNO_EKBE
INTROW Line Number of Service NUMC 10 0 INTROW_EKBE
SGTXT Item Text CHAR 50 0 SGTXT
XSKRL Indicator: Line Item Not Liable to Cash Discount? CHAR 1 0 XSKRL
KZMEK Correction indicator CHAR 1 0 KZMEKORR
No error
1 Unclarified error: park invoice
2 Supplier error: reduce invoice
MRMOK Indicator: Invoice Item Processed CHAR 1 0 MRMOK
STUNR Step Number NUMC 3 0 STUNR
ZAEHK Condition Counter NUMC 3 0 DZAEHK
STOCK_POSTING Stock Posting of Line from an Incoming Invoice CURR 13 2 STOCK_POSTING
STOCK_POSTING_PP Stock Posting of Line from an Incoming Invoice, Prev. Period CURR 13 2 STOCK_POSTING_PP
STOCK_POSTING_PY Stock Posting of Line from an Incoming Invoice, Prev. Year CURR 13 2 STOCK_POSTING_PY
WEREC Clearing Indicator for GR/IR Posting for External Services CHAR 1 0 MMWEREC
LIFNR Account Number of Supplier CHAR 10 0 LIFNR
FRBNR Number of Bill of Lading at Time of Goods Receipt CHAR 16 0 FRBNR1
XHISTMA Update Multiple Account Assignment EKBE_MA, EKBZ_MA CHAR 1 0 XHISTMA
COMPLAINT_REASON Complaints Reason in an Invoice CHAR 2 0 COMPLAINT_REASON
RETAMT_FC Retention Amount in Document Currency CURR 13 2 RET_AMT_FC
RETPC Retention in Percent DEC 5 2 RETPZ
RETDUEDT Due Date for Retention DATS 8 0 RET_DUE_DATE
XRETTAXNET Tax Reduction for Retention CHAR 1 0 RET_TAXNET
RE_ACCOUNT Cash Ledger: Expense or Revenue Account CHAR 10 0 FAGL_RE_ACCOUNT
ERP_CONTRACT_ID Number of principal purchase agreement CHAR 10 0 KONNR
ERP_CONTRACT_ITM Item number of principal purchase agreement NUMC 5 0 KTPNR
SRM_CONTRACT_ID Central Contract CHAR 10 0 SRM_CONTRACT_ID
SRM_CONTRACT_ITM Central Contract Item Number NUMC 10 0 SRM_CONTRACT_ITEM
CONT_PSTYP Item category in purchasing document CHAR 1 0 PSTYP
SRVMAPKEY Item Key for eSOA Messages NUMC 10 0 SRVMAPKEY
CHARG Batch Number CHAR 10 0 CHARG_D
INV_ITM_ORIGIN Origin of an Invoice Item CHAR 1 0 INV_ITM_ORIGIN
Inv.Ver.: Item Newly Created
A Diff.Inv.: Item Newly Created
B Diff.Inv.: Item Copied from Preceding Invoice
INVREL Grouping Characteristic for Invoice Verification NUMC 6 0 INVREL
XDINV Indicator for Differential Invoicing CHAR 1 0 XDINV
DIFF_AMOUNT Difference Amount (in Document Currency) CURR 13 2 DIFFERENCE_AMOUNT
XCPRF Checkbox for Commodity Repricing in Invoice Verification CHAR 1 0 XCPRF
PRODUCTTYPE Product Type Group CHAR 2 0 PRODUCT_TYPE
GR_BY_SES Are GRs posted by using Service Entry Sheet CHAR 1 0 MMPUR_GR_BY_SES
NODE_KEY GUID: MM Supplier Invoice in S-Innovations RAW 16 0 MRM_SI_GUID
PARENT_KEY GUID: MM Supplier Invoice in S-Innovations RAW 16 0 MRM_SI_GUID
ROOT_KEY GUID: MM Supplier Invoice in S-Innovations RAW 16 0 MRM_SI_GUID
DUMMY_MMIV_SI_S_ITEM_EEW_PS MMIV_SI_S_ITEM_INCL_EEW CHAR 1 0 MMIV_SI_S_ITEM_INCL_EEW
ENH_DATE1 Start date of WKA working period DATS 8 0 WKA_DATE1
ENH_DATE2 End date of WKA working period DATS 8 0 WKA_DATE2
ENH_CHAR1 Chain Liability work description CHAR 20 0 WKA_DESCR
ENH_CHAR2 Chain Liability description of construction site CHAR 20 0 WKA_DESPL
ENH_PERCENT WKA: Percentage of wages DEC 5 2 WKA_PERCENT
ENH_NUMC1 Working time in hours NUMC 10 0 WKA_HOURS
/CWM/MENGE Quantity in Parallel Unit of Measure QUAN 13 3 /CWM/MENGE
/CWM/WEMNG Goods Receipt Quantity in Base or Parallel Unit of Measure QUAN 13 3 /CWM/WEMNG
/CWM/REMNG Invoice Receipt Quantity in Base or Parallel UoM QUAN 13 3 /CWM/REMNG
/CWM/BAMNG Quantity in Parallel Unit of Measure QUAN 13 3 /CWM/BAMNG
/CWM/VALUM Valuation Unit of Measure UNIT 3 0 * /CWM/VALUM
TXDAT Date for Determining Tax Rates DATS 8 0 TXDAT
TXDAT_FROM Valid-From Date of the Tax Rate DATS 8 0 FOT_TXDAT_FROM
TAX_COUNTRY Tax Reporting Country/Region CHAR 3 0 FOT_TAX_COUNTRY
VCM_CHAIN_CATEGORY Value Chain Category CHAR 4 0 * VCM_CHAIN_CATEGORY
T2CCODE_CRCY_CONV_FACTOR Factor for calculating Amount in company code currency DEC 31 14 FINS_T2CCODE_CRCY_CONV_FACTOR
T2CNTRY_CRCY_CONV_FACTOR Factor for calculating Tax Amount in reporting currency DEC 31 14 FINS_T2CNTRY_CRCY_CONV_FACTOR
/NFM/SPGRK NF Processing, Rate Blocking Reason CHAR 1 0 /NFM/SPGRK
EFKOR Type of correction to own error CHAR 1 0 EFKOR
No error correction
1 Price correction
2 Condition correction
3 Price and condition correction
FSH_SEASON_YEAR Season Year CHAR 4 0 FSH_SAISJ
FSH_SEASON Season CHAR 10 0 FSH_SAISO
FSH_COLLECTION Fashion Collection CHAR 10 0 * FSH_COLLECTION
FSH_THEME Fashion Theme CHAR 10 0 FSH_THEME
HSN_SAC HSN or SAC Code CHAR 16 0 J_1IG_HSN_SAC
CUSTOMS_VAL Assessable Value CURR 13 2 J_1IG_VALASS
LICNO Internal License Number NUMC 10 0 J_1ILICNO
ZEILE Item Number NUMC 4 0 J_1IZEILE
SGT_SCAT Stock Segment CHAR 40 0 SGT_SCAT
WRF_CHARSTC1 Characteristic Value 1 CHAR 18 0 WRF_CHARSTC1
WRF_CHARSTC2 Characteristic Value 2 CHAR 18 0 WRF_CHARSTC2
WRF_CHARSTC3 Characteristic Value 3 CHAR 18 0 WRF_CHARSTC3

RSEG foreign key relationships

Table Field Check Table Check Field
0 RSEG BKLAS T025 Valuation Classes MANDT
0 RSEG BKLAS T025 Valuation Classes BKLAS
1 RSEG BPRME T006 Units of Measurement MANDT
0 RSEG BSTME T006 Units of Measurement MANDT
1 RSEG BUKRS T001 Company Codes BUKRS
0 RSEG BWTAR T149D Global Valuation Types MANDT
0 RSEG BWTAR T149D Global Valuation Types BWTAR
1 RSEG EBELN EKKO Purchasing Document Header EBELN
0 RSEG EBELP EKPO Purchasing Document Item MANDT
0 RSEG EBELP EKPO Purchasing Document Item EBELN
1 RSEG GITYP J_1ADTYP Distribution Types for Gross Income Tax MANDT
1 RSEG GITYP J_1ADTYP Distribution Types for Gross Income Tax BUKRS
0 RSEG GRICD J_1AGICD Activity codes for gross income tax declaration MANDT
0 RSEG GRICD J_1AGICD Activity codes for gross income tax declaration LAND1
1 RSEG GRIRG T005S Taxes: Region (Province) Key LAND1
0 RSEG KNTTP T163K Account Assignment Categories in Purchasing Document MANDT
0 RSEG KNTTP T163K Account Assignment Categories in Purchasing Document KNTTP
1 RSEG MATNR MARA General Material Data MANDT
1 RSEG MATNR MARA General Material Data MATNR
0 RSEG MEINS T006 Units of Measurement MANDT
0 RSEG MEINS T006 Units of Measurement MSEHI
1 RSEG MWSKZ T007A Tax Keys KALSM
1 RSEG MWSKZ T007A Tax Keys MWSKZ
0 RSEG PSTYP T163 Item Categories in Purchasing Document MANDT
0 RSEG PSTYP T163 Item Categories in Purchasing Document PSTYP
1 RSEG TXJCD TTXJ Check Table for Tax Jurisdiction MANDT
1 RSEG TXJCD TTXJ Check Table for Tax Jurisdiction KALSM
0 RSEG WERKS T001W Plants/Branches WERKS