RSEG

Transparent Table Application Table
94 Fields 11 CDS Views

Document Item: Incoming Invoice

RSEG is an SAP database table in S/4HANA. Document Item: Incoming Invoice. It contains 94 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
C_PurDocListInvoiceDetails view inner CONSUMPTION Invoice Details
C_Purdoclistinvoiceitem view from CONSUMPTION Invoice Item
C_SuplrInvcItQty view_entity from Supplier Invoice Item Quantity
E_OnlineSupplierInvoiceItem view from EXTENSION Ext View E_OnlineSupplierInvoiceItem
E_SupplierInvoiceItemPurOrdRef view from EXTENSION Extension Supplier Invoice Item PO Ref
P_ITEM_ONLINE view from BASIC Items from table rseg
P_SuplrInvcItmUnionInSetlMgmt view from BASIC Provides batch and online data of a supplier invoice item
V_WB2_RBKP_RSEG_1 view inner Business Volume from Supplier Invoice
V_WB2_RBKP_RSEG_3 view inner Business Volume Supplier Invoice -RBCO
V_WB2_RSEG_RBDRSEG_UNION view from union of batch and online items in Supplier Invoice
view_iv_items_p view from Item Related Data of Invoice Verification Doc.

Fields (94)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY belnr belnr_d Document Number
KEY gjahr gjahr Fiscal Year
KEY buzei rblgp Item
ebeln ebeln Purchasing Doc.
ebelp ebelp Item
zekkn dzekkn Account Assgmt No.
matnr matnr Material
bwkey bwkey Valuation Area
bwtar bwtar_d Valuation Type
bukrs bukrs Company Code
werks werks_d Plant
wrbtr wrbtr_cs Amount
shkzg shkzg Debit/Credit
mwskz mwskz Tax Code
txjcd txjcd Tax Jur.
menge menge_d Quantity
bstme bstme Order Unit
bpmng bpmng Qty in OPUn
bprme bprme PO Price Unit
lbkum lbkum Total Stock
vrkum vrkum Stock prev. PP
meins meins Base Unit
pstyp pstyp Item Category
knttp knttp Acct Assgmt Cat
bklas bklas Valuation Class
erekz erekz Final Invoice
exkbe xekbe Ind.:upd.PO his
xekbz xekbz Ind.: Upd. DC
tbtkz tbtkz Subseq. Dr/Cr
spgrp spgrp Block.Reas.:Prc
spgrm spgrm Block.Reas.:Qty
spgrt spgrt Bl. Reason Date
spgrg spgrg Block.Reas: OPQ
spgrv spgrv Block.Reas:Proj
spgrq spgrq Man.Block.Reasn
spgrs spgrs Blkg Reas. Amount
spgrc spgrc Block: Quality
spgrext spgrext Block Reason
bustw bustw Value String
xblnr xblnr1 Reference
xrueb xrueb Back-Posting?
bnkan bnk_anteil DCs share
kschl kschl Condition Type
salk3 salk3 Total Value
vmsal vmsal Total value PP
xlifo xlifo LIFO/FIFO-Rel.
lfbnr lfbnr Reference Doc.
lfgja lfgja Year Cur.Period
lfpos lfpos Ref. Doc. Item
matbf matbf Stock Mat.
rbmng rbmng Inv. Doc. Qty
bprbm bprbm InvQty POunit
rbwwr rbwwr Inv.Amnt DC
lfehl lfehl Supplier Error
gricd j_1agicd_d Activity Code
grirg regio Region
gityp j_1adtyp_d Distr. Type
packno packno_ekbe Package Number
introw introw_ekbe Service line
sgtxt sgtxt Text
xskrl xskrl W/o CashDsc.
kzmek kzmekorr Correction ID
mrmok mrmok OK
stunr stunr Step Number
zaehk dzaehk Counter
stock_posting stock_posting Stock Posting
stock_posting_pp stock_posting_pp StkPstgPrevPerd
stock_posting_py stock_posting_py StkPstgPrevYear
werec mmwerec GR/IR Clearing
lifnr lifnr Supplier
frbnr frbnr1 Bill of Lading
xhistma xhistma Update MultiAcctAsmt
complaint_reason complaint_reason Complaints Reason
retamt_fc ret_amt_fc Retent. in Doc. Crcy
retpc retpz Retention %
retduedt ret_due_date Due Date
xrettaxnet ret_taxnet Tax Reduction
re_account fagl_re_account Ex/Rv A/c in CL
erp_contract_id konnr Agreement
erp_contract_itm ktpnr Agreement Item
srm_contract_id srm_contract_id Central Contract
srm_contract_itm srm_contract_item Cent. Contract Item
cont_pstyp pstyp Item Category
srvmapkey srvmapkey Item ID
charg charg_d Batch
inv_itm_origin inv_itm_origin Item Origin
invrel invrel Grouping
xdinv xdinv Ind.Diff.Invoicing
diff_amount difference_amount Difference Amt
xcprf xcprf Comm. Repricing
producttype product_type Product Type Group
gr_by_ses mmpur_gr_by_ses GR By SES
bupla bupla Business place

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Document Item: Incoming Invoice
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE RSEG (
    MANDT,             -- Client [mandt]
    BELNR,             -- Document Number [belnr_d]
    GJAHR,             -- Fiscal Year [gjahr]
    BUZEI,             -- Item [rblgp]
    EBELN,             -- Purchasing Doc. [ebeln]
    EBELP,             -- Item [ebelp]
    ZEKKN,             -- Account Assgmt No. [dzekkn]
    MATNR,             -- Material [matnr]
    BWKEY,             -- Valuation Area [bwkey]
    BWTAR,             -- Valuation Type [bwtar_d]
    BUKRS,             -- Company Code [bukrs]
    WERKS,             -- Plant [werks_d]
    WRBTR,             -- Amount [wrbtr_cs]
    SHKZG,             -- Debit/Credit [shkzg]
    MWSKZ,             -- Tax Code [mwskz]
    TXJCD,             -- Tax Jur. [txjcd]
    MENGE,             -- Quantity [menge_d]
    BSTME,             -- Order Unit [bstme]
    BPMNG,             -- Qty in OPUn [bpmng]
    BPRME,             -- PO Price Unit [bprme]
    LBKUM,             -- Total Stock [lbkum]
    VRKUM,             -- Stock prev. PP [vrkum]
    MEINS,             -- Base Unit [meins]
    PSTYP,             -- Item Category [pstyp]
    KNTTP,             -- Acct Assgmt Cat [knttp]
    BKLAS,             -- Valuation Class [bklas]
    EREKZ,             -- Final Invoice [erekz]
    EXKBE,             -- Ind.:upd.PO his [xekbe]
    XEKBZ,             -- Ind.: Upd. DC [xekbz]
    TBTKZ,             -- Subseq. Dr/Cr [tbtkz]
    SPGRP,             -- Block.Reas.:Prc [spgrp]
    SPGRM,             -- Block.Reas.:Qty [spgrm]
    SPGRT,             -- Bl. Reason Date [spgrt]
    SPGRG,             -- Block.Reas: OPQ [spgrg]
    SPGRV,             -- Block.Reas:Proj [spgrv]
    SPGRQ,             -- Man.Block.Reasn [spgrq]
    SPGRS,             -- Blkg Reas. Amount [spgrs]
    SPGRC,             -- Block: Quality [spgrc]
    SPGREXT,           -- Block Reason [spgrext]
    BUSTW,             -- Value String [bustw]
    XBLNR,             -- Reference [xblnr1]
    XRUEB,             -- Back-Posting? [xrueb]
    BNKAN,             -- DCs share [bnk_anteil]
    KSCHL,             -- Condition Type [kschl]
    SALK3,             -- Total Value [salk3]
    VMSAL,             -- Total value PP [vmsal]
    XLIFO,             -- LIFO/FIFO-Rel. [xlifo]
    LFBNR,             -- Reference Doc. [lfbnr]
    LFGJA,             -- Year Cur.Period [lfgja]
    LFPOS,             -- Ref. Doc. Item [lfpos]
    MATBF,             -- Stock Mat. [matbf]
    RBMNG,             -- Inv. Doc. Qty [rbmng]
    BPRBM,             -- InvQty POunit [bprbm]
    RBWWR,             -- Inv.Amnt DC [rbwwr]
    LFEHL,             -- Supplier Error [lfehl]
    GRICD,             -- Activity Code [j_1agicd_d]
    GRIRG,             -- Region [regio]
    GITYP,             -- Distr. Type [j_1adtyp_d]
    PACKNO,            -- Package Number [packno_ekbe]
    INTROW,            -- Service line [introw_ekbe]
    SGTXT,             -- Text [sgtxt]
    XSKRL,             -- W/o CashDsc. [xskrl]
    KZMEK,             -- Correction ID [kzmekorr]
    MRMOK,             -- OK [mrmok]
    STUNR,             -- Step Number [stunr]
    ZAEHK,             -- Counter [dzaehk]
    STOCK_POSTING,     -- Stock Posting [stock_posting]
    STOCK_POSTING_PP,  -- StkPstgPrevPerd [stock_posting_pp]
    STOCK_POSTING_PY,  -- StkPstgPrevYear [stock_posting_py]
    WEREC,             -- GR/IR Clearing [mmwerec]
    LIFNR,             -- Supplier [lifnr]
    FRBNR,             -- Bill of Lading [frbnr1]
    XHISTMA,           -- Update MultiAcctAsmt [xhistma]
    COMPLAINT_REASON,  -- Complaints Reason [complaint_reason]
    RETAMT_FC,         -- Retent. in Doc. Crcy [ret_amt_fc]
    RETPC,             -- Retention % [retpz]
    RETDUEDT,          -- Due Date [ret_due_date]
    XRETTAXNET,        -- Tax Reduction [ret_taxnet]
    RE_ACCOUNT,        -- Ex/Rv A/c in CL [fagl_re_account]
    ERP_CONTRACT_ID,   -- Agreement [konnr]
    ERP_CONTRACT_ITM,  -- Agreement Item [ktpnr]
    SRM_CONTRACT_ID,   -- Central Contract [srm_contract_id]
    SRM_CONTRACT_ITM,  -- Cent. Contract Item [srm_contract_item]
    CONT_PSTYP,        -- Item Category [pstyp]
    SRVMAPKEY,         -- Item ID [srvmapkey]
    CHARG,             -- Batch [charg_d]
    INV_ITM_ORIGIN,    -- Item Origin [inv_itm_origin]
    INVREL,            -- Grouping [invrel]
    XDINV,             -- Ind.Diff.Invoicing [xdinv]
    DIFF_AMOUNT,       -- Difference Amt [difference_amount]
    XCPRF,             -- Comm. Repricing [xcprf]
    PRODUCTTYPE,       -- Product Type Group [product_type]
    GR_BY_SES,         -- GR By SES [mmpur_gr_by_ses]
    BUPLA,             -- Business place [bupla]
    PRIMARY KEY (MANDT, BELNR, GJAHR, BUZEI)
);

Learn More