RBDRSEG

Transparent Table Application Table
139 Fields 4 CDS Views

Batch IV: Invoice Document Items

RBDRSEG is an SAP database table in S/4HANA. Batch IV: Invoice Document Items. It contains 139 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
E_BatchSupplierInvoiceItem view from EXTENSION Ext view E_BatchSupplierInvoiceItem
P_ITEM_BATCH view from BASIC
P_SuplrInvcItmUnionInSetlMgmt view union BASIC
V_WB2_RSEG_RBDRSEG_UNION view union_all

Fields (139)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY rblnr RE_BELNR Inv. Doc. No.
KEY rjahr GJAHR Fiscal Year
KEY rblgp RBLGP Item
bpmng BPMNG Qty in OPUn
bprem BPREM IR quantity
bprme BPRME PO Price Unit
bpumn BPUMN Qty Conversion
bpumz BPUMZ Qty Conversion
bpwem BPWEM GR Qty in OPUn
bsmng BSMNG Order quantity
budat BUDAT Posting Date
bukrs BUKRS Company Code
bwtar BWTAR_D Valuation Type
dmbtr DMBTR_CS Amount in LC
ebeln BSTNR Purchase order
ebelp EBELP Item
eindt EINDT Delivery Date
erekz EREKZ Final Invoice
frbnr FRBNR1 Bill of Lading
gjahr GJAHR Fiscal Year
hswae HSWAE Local currency
lfbnr LFBNR Reference Doc.
lfgja LFGJA Year Cur.Period
lfpos LFPOS Ref. Doc. Item
knttp KNTTP Acct Assgmt Cat
kschl KSCHL Condition Type
matnr MATNR Material
meins BSTME Order Unit
menge MENGE_D Quantity
meprf MEPRF Pr. Date Cat.
mwskz MWSKZ Tax Code
netpr NETPR Net Price
netwr BSTWR Net order value
pstyp PSTYP Item Category
refwr REFWR Inv.Value in FC
remng REMNG Invoice qty
retpo RETPO Returns Item
schpr SCHPR Estimated Price
selkz SELKZ Selection
shkzg SHKZG Debit/Credit
spgrc SPGRC Block: Quality
spgrg SPGRG Block.Reas: OPQ
spgrm SPGRM Block.Reas.:Qty
spgrp SPGRP Block.Reas.:Prc
spgrq SPGRQ Man.Block.Reasn
spgrs SPGRS Blkg Reas. Amount
spgrt SPGRT Bl. Reason Date
spgrv SPGRV Block.Reas:Proj
stunr STUNR Step Number
tbtkz TBTKZ Subseq. Dr/Cr
txjcd TXJCD Tax Jur.
txz01 TXZ01 Short Text
waers WAERS Currency
webre WEBRE GR-Based IV
wemng WEMNG Received
wepos WEPOS Goods Receipt
werks WERKS_D Plant
wrbtr WRBTR_CS Amount
wmwst WMWST_CS Tax Amount
xblnr LFSNR1 Delivery Note
xekbe XEKBE Ind.:upd.PO his
xekbz XEKBZ Ind.: Upd. DC
zaehk DZAEHK Counter
zekkn DZEKKN Account Assgmt No.
lsmng LSMNG Del. Note Qty
lsmeh LSMEH Del. Note Unit
basme F_MEINS Unit of measure
xubnkr XUBNKR No UDelCosts
gricd J_1AGICD_D Activity Code
grirg REGIO Region
gityp J_1ADTYP_D Distr. Type
mblnr MBLNR Material Doc.
mjahr MJAHR Mat. Doc. Year
mblpo MBLPO Mat. Doc.Item
knumvk KNUMV Doc. Condition
knumv KNUMV Doc. Condition
knumvr KNUMV Doc. Condition
satnr SATNR Cross-plant CM
ean11 EAN11 EAN/UPC
idnlf IDNLF Supp. Mat. No.
aktnr WAKTION Promotion
upvor UPVOR Sub-items
uptyp UPTYP Subitem Cat.
uebpo UEBPO H-Lev. Item
srvpos SRVPOS Service
packno PACKNO_EKBE Package Number
introw INTROW_EKBE Service line
lebre LEBRE Srv.-Based Inv. Ver.
bekkn BEKKN SeqNo.PO AccAss
pln_packno PLN_PACKNO P
pln_introw PLN_INTROW I
lieffn LIEFFN Supp.Error(net)
rbwwr RBWWR Inv.Amnt DC
rbmng RBMNG Inv. Doc. Qty
bprbm BPRBM InvQty POunit
kzmek KZMEKORR Correction ID
mengealt MENGE_D Quantity
bpmngalt BPMNG Qty in OPUn
wrbtralt WRBTR_CS Amount
xupda MARKE Select
efkor EFKOR Own error
lfkor LFEHL Supplier Error
ok MRMOK OK
complaint_reason COMPLAINT_REASON Complaints Reason
weunb WEUNB GR Non-Valuated
sgtxt SGTXT Text
rewwr REWWR_CS FC Invoice Amt
werec MMWEREC GR/IR Clearing
kzbws KZBWS Valuation
xskrl XSKRL W/o CashDsc.
vrtkz VRTKZ Distribution
rettp RETTP Retention
retamt_fc RET_AMT_FC Retent. in Doc. Crcy
retpc RETPZ Retention %
retduedt RET_DUE_DATE Due Date
xrettaxnet RET_TAXNET Tax Reduction
xdinv XDINV Ind.Diff.Invoicing
inv_itm_origin INV_ITM_ORIGIN Item Origin
invrel INVREL Grouping
diff_amount DIFFERENCE_AMOUNT Difference Amt
charg CHARG_D Batch
xcprf XCPRF Comm. Repricing
txdat TXDAT Tax Date
txdat_from FOT_TXDAT_FROM Tax Rate Valid-From
producttype PRODUCT_TYPE Product Type Group
tax_country FOT_TAX_COUNTRY Tax Ctry/Reg.
vcm_chain_category VCM_CHAIN_CATEGORY Value Chain Category
posint_vcm RBLGP Item
perop_beg_mm FM_PEROP_FI_LOW Per. of Perf. Start
perop_end_mm FM_PEROP_FI_HIGH Per. of Perf. End
xhistma XHISTMA Update MultiAcctAsmt
node_key MRM_SI_GUID GUID
parent_key MRM_SI_GUID GUID
root_key MRM_SI_GUID GUID
dummy_mmiv_si_s_item_eew_ps MMIV_SI_S_ITEM_INCL_EEW Dummy
gr_by_ses MMPUR_GR_BY_SES GR By SES
hsn_sac J_1IG_HSN_SAC HSN/SAC Code
customs_val J_1IG_VALASS Assessable Val.

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.

-- Batch IV: Invoice Document Items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE RBDRSEG (
    MANDT,                        -- Client [MANDT]
    RBLNR,                        -- Inv. Doc. No. [RE_BELNR]
    RJAHR,                        -- Fiscal Year [GJAHR]
    RBLGP,                        -- Item [RBLGP]
    BPMNG,                        -- Qty in OPUn [BPMNG]
    BPREM,                        -- IR quantity [BPREM]
    BPRME,                        -- PO Price Unit [BPRME]
    BPUMN,                        -- Qty Conversion [BPUMN]
    BPUMZ,                        -- Qty Conversion [BPUMZ]
    BPWEM,                        -- GR Qty in OPUn [BPWEM]
    BSMNG,                        -- Order quantity [BSMNG]
    BUDAT,                        -- Posting Date [BUDAT]
    BUKRS,                        -- Company Code [BUKRS]
    BWTAR,                        -- Valuation Type [BWTAR_D]
    DMBTR,                        -- Amount in LC [DMBTR_CS]
    EBELN,                        -- Purchase order [BSTNR]
    EBELP,                        -- Item [EBELP]
    EINDT,                        -- Delivery Date [EINDT]
    EREKZ,                        -- Final Invoice [EREKZ]
    FRBNR,                        -- Bill of Lading [FRBNR1]
    GJAHR,                        -- Fiscal Year [GJAHR]
    HSWAE,                        -- Local currency [HSWAE]
    LFBNR,                        -- Reference Doc. [LFBNR]
    LFGJA,                        -- Year Cur.Period [LFGJA]
    LFPOS,                        -- Ref. Doc. Item [LFPOS]
    KNTTP,                        -- Acct Assgmt Cat [KNTTP]
    KSCHL,                        -- Condition Type [KSCHL]
    MATNR,                        -- Material [MATNR]
    MEINS,                        -- Order Unit [BSTME]
    MENGE,                        -- Quantity [MENGE_D]
    MEPRF,                        -- Pr. Date Cat. [MEPRF]
    MWSKZ,                        -- Tax Code [MWSKZ]
    NETPR,                        -- Net Price [NETPR]
    NETWR,                        -- Net order value [BSTWR]
    PSTYP,                        -- Item Category [PSTYP]
    REFWR,                        -- Inv.Value in FC [REFWR]
    REMNG,                        -- Invoice qty [REMNG]
    RETPO,                        -- Returns Item [RETPO]
    SCHPR,                        -- Estimated Price [SCHPR]
    SELKZ,                        -- Selection [SELKZ]
    SHKZG,                        -- Debit/Credit [SHKZG]
    SPGRC,                        -- Block: Quality [SPGRC]
    SPGRG,                        -- Block.Reas: OPQ [SPGRG]
    SPGRM,                        -- Block.Reas.:Qty [SPGRM]
    SPGRP,                        -- Block.Reas.:Prc [SPGRP]
    SPGRQ,                        -- Man.Block.Reasn [SPGRQ]
    SPGRS,                        -- Blkg Reas. Amount [SPGRS]
    SPGRT,                        -- Bl. Reason Date [SPGRT]
    SPGRV,                        -- Block.Reas:Proj [SPGRV]
    STUNR,                        -- Step Number [STUNR]
    TBTKZ,                        -- Subseq. Dr/Cr [TBTKZ]
    TXJCD,                        -- Tax Jur. [TXJCD]
    TXZ01,                        -- Short Text [TXZ01]
    WAERS,                        -- Currency [WAERS]
    WEBRE,                        -- GR-Based IV [WEBRE]
    WEMNG,                        -- Received [WEMNG]
    WEPOS,                        -- Goods Receipt [WEPOS]
    WERKS,                        -- Plant [WERKS_D]
    WRBTR,                        -- Amount [WRBTR_CS]
    WMWST,                        -- Tax Amount [WMWST_CS]
    XBLNR,                        -- Delivery Note [LFSNR1]
    XEKBE,                        -- Ind.:upd.PO his [XEKBE]
    XEKBZ,                        -- Ind.: Upd. DC [XEKBZ]
    ZAEHK,                        -- Counter [DZAEHK]
    ZEKKN,                        -- Account Assgmt No. [DZEKKN]
    LSMNG,                        -- Del. Note Qty [LSMNG]
    LSMEH,                        -- Del. Note Unit [LSMEH]
    BASME,                        -- Unit of measure [F_MEINS]
    XUBNKR,                       -- No UDelCosts [XUBNKR]
    GRICD,                        -- Activity Code [J_1AGICD_D]
    GRIRG,                        -- Region [REGIO]
    GITYP,                        -- Distr. Type [J_1ADTYP_D]
    MBLNR,                        -- Material Doc. [MBLNR]
    MJAHR,                        -- Mat. Doc. Year [MJAHR]
    MBLPO,                        -- Mat. Doc.Item [MBLPO]
    KNUMVK,                       -- Doc. Condition [KNUMV]
    KNUMV,                        -- Doc. Condition [KNUMV]
    KNUMVR,                       -- Doc. Condition [KNUMV]
    SATNR,                        -- Cross-plant CM [SATNR]
    EAN11,                        -- EAN/UPC [EAN11]
    IDNLF,                        -- Supp. Mat. No. [IDNLF]
    AKTNR,                        -- Promotion [WAKTION]
    UPVOR,                        -- Sub-items [UPVOR]
    UPTYP,                        -- Subitem Cat. [UPTYP]
    UEBPO,                        -- H-Lev. Item [UEBPO]
    SRVPOS,                       -- Service [SRVPOS]
    PACKNO,                       -- Package Number [PACKNO_EKBE]
    INTROW,                       -- Service line [INTROW_EKBE]
    LEBRE,                        -- Srv.-Based Inv. Ver. [LEBRE]
    BEKKN,                        -- SeqNo.PO AccAss [BEKKN]
    PLN_PACKNO,                   -- P [PLN_PACKNO]
    PLN_INTROW,                   -- I [PLN_INTROW]
    LIEFFN,                       -- Supp.Error(net) [LIEFFN]
    RBWWR,                        -- Inv.Amnt DC [RBWWR]
    RBMNG,                        -- Inv. Doc. Qty [RBMNG]
    BPRBM,                        -- InvQty POunit [BPRBM]
    KZMEK,                        -- Correction ID [KZMEKORR]
    MENGEALT,                     -- Quantity [MENGE_D]
    BPMNGALT,                     -- Qty in OPUn [BPMNG]
    WRBTRALT,                     -- Amount [WRBTR_CS]
    XUPDA,                        -- Select [MARKE]
    EFKOR,                        -- Own error [EFKOR]
    LFKOR,                        -- Supplier Error [LFEHL]
    OK,                           -- OK [MRMOK]
    COMPLAINT_REASON,             -- Complaints Reason [COMPLAINT_REASON]
    WEUNB,                        -- GR Non-Valuated [WEUNB]
    SGTXT,                        -- Text [SGTXT]
    REWWR,                        -- FC Invoice Amt [REWWR_CS]
    WEREC,                        -- GR/IR Clearing [MMWEREC]
    KZBWS,                        -- Valuation [KZBWS]
    XSKRL,                        -- W/o CashDsc. [XSKRL]
    VRTKZ,                        -- Distribution [VRTKZ]
    RETTP,                        -- Retention [RETTP]
    RETAMT_FC,                    -- Retent. in Doc. Crcy [RET_AMT_FC]
    RETPC,                        -- Retention % [RETPZ]
    RETDUEDT,                     -- Due Date [RET_DUE_DATE]
    XRETTAXNET,                   -- Tax Reduction [RET_TAXNET]
    XDINV,                        -- Ind.Diff.Invoicing [XDINV]
    INV_ITM_ORIGIN,               -- Item Origin [INV_ITM_ORIGIN]
    INVREL,                       -- Grouping [INVREL]
    DIFF_AMOUNT,                  -- Difference Amt [DIFFERENCE_AMOUNT]
    CHARG,                        -- Batch [CHARG_D]
    XCPRF,                        -- Comm. Repricing [XCPRF]
    TXDAT,                        -- Tax Date [TXDAT]
    TXDAT_FROM,                   -- Tax Rate Valid-From [FOT_TXDAT_FROM]
    PRODUCTTYPE,                  -- Product Type Group [PRODUCT_TYPE]
    TAX_COUNTRY,                  -- Tax Ctry/Reg. [FOT_TAX_COUNTRY]
    VCM_CHAIN_CATEGORY,           -- Value Chain Category [VCM_CHAIN_CATEGORY]
    POSINT_VCM,                   -- Item [RBLGP]
    PEROP_BEG_MM,                 -- Per. of Perf. Start [FM_PEROP_FI_LOW]
    PEROP_END_MM,                 -- Per. of Perf. End [FM_PEROP_FI_HIGH]
    XHISTMA,                      -- Update MultiAcctAsmt [XHISTMA]
    NODE_KEY,                     -- GUID [MRM_SI_GUID]
    PARENT_KEY,                   -- GUID [MRM_SI_GUID]
    ROOT_KEY,                     -- GUID [MRM_SI_GUID]
    DUMMY_MMIV_SI_S_ITEM_EEW_PS,  -- Dummy [MMIV_SI_S_ITEM_INCL_EEW]
    GR_BY_SES,                    -- GR By SES [MMPUR_GR_BY_SES]
    HSN_SAC,                      -- HSN/SAC Code [J_1IG_HSN_SAC]
    CUSTOMS_VAL,                  -- Assessable Val. [J_1IG_VALASS]
    PRIMARY KEY (MANDT, RBLNR, RJAHR, RBLGP)
);

Learn More