RESB

Transparent Table Application Table
199 Fields 48 CDS Views

Reservation/dependent requirements

RESB is an SAP database table in S/4HANA. Reservation/dependent requirements. It contains 199 fields. 48 CDS views read from this table.

CDS Views using this table (48)

ViewTypeJoinVDMDescription
/merp/pm_Wo_Component view from CDS View: Maintenance Order Components
/MERP/PP_PO_COMPONENT view from Production Order Component
/MERP/PP_PO_COMPONENT_C view from Production Order Component
/MERP/PP_PO_MissingComponents view from Production Order Missing Components
ARUN_PROD_REQMT view inner Production order components
Arun_Spo_Reqmt view inner Subcontracting PO Requirement
ATPC_CDS_AFPO_QTY_DIST view left_outer CDS View on AFPO,RESB,AFKO for Qty. Dist for ATP
Atpc_Cds_Mdur view inner CDS View on MDUR Table for ATP
Atpc_Cds_Resb view from CDS View on RESB Table for ATP
Atpc_Cds_Resb_D view from CDS View on RESB for Reading of Own Deltas in ATP
atpc_dvol_peak_creation_tstmp view union Data Volume for Peaks with Creation Timestamp
E_ProcessOrderComponent view_entity from EXTENSION Process Order Component - Extension
E_ProductionOrderComponent view_entity from EXTENSION Production Order Component - Extension
E_ReservationDocumentItem view_entity from EXTENSION Reservation Document Item Extension
I_DependentRequirementItem view_entity from BASIC Dependent Requirement Item
I_FldLogsProcRcptMaintOrd view inner BASIC Maintenance orders for process receipts FL
I_FldLogsProductsInResvn view from BASIC Base Product view for Field Logistics WO
I_FldLogsRefWorkOrder view inner BASIC FL - Ref Work Order value help
I_FldLogsReservationItemDetail view_entity from BASIC Reservation details
I_MaintenanceOrderComponent view from BASIC Maintenance Order Component
I_MaintenanceOrderComponent_2 view_entity from BASIC Maintenance Order Component
I_MaintOrdOpComponentMaterial view_entity from BASIC Fetching Operation Material Data
I_MaintOrdOpComponentServices view_entity from BASIC Fetching Operation Services Data
I_MRPReservation view_entity from BASIC MRP Reservations
I_OpActyInstanceComponent view_entity inner BASIC Component of an Operation Activity Instance
I_PlannedOrderComponent view from BASIC Planned Order Component
I_ProjectMaterialCompBasicData view from BASIC Basic Data for Proj Material Component
I_ProjectMaterialComponent view from BASIC Project Material Component Details
I_ReservationItem view_entity from BASIC Reservation Item
I_SubcontractingComponent view from BASIC Subcontracting Component
I_SupDmndAllDocPlndOrdComp view from BASIC View for Planned Order Components
I_SupDmndAllDocProdnOrdCompBsc view from BASIC Basic View for Production Order Components
I_SupDmndAllDocPurOrdCompBsc view from BASIC Basic View for Sub Contracting Purchase Order Components
I_SupDmndAllDocPurReqnComp view from BASIC View for Sub Contracting Purchase Requisition Components
I_SupDmndComponentBasic view from BASIC Basic View for Components
I_SupDmndReservationBasic view from BASIC Basic View for Reservations
P_MaintOrderCompForDrctProcmt view from BASIC Maintenance Order Component for Direct Procurement
P_MfgOrderOpReservationItem view from BASIC Manufacturing Order Operation Reservation Item
P_ProcOrdOpReservationItem view from BASIC Process Order Reservation Item
P_Projmatcomponent view inner BASIC View to fetch Purchase Requisition & Purchase Order
pp_mrp_read_mfg_order_comp view inner Read Manufacturing Order Components
pp_mrp_read_planned_order_comp view inner Read Planned Order Components
PPH_E_MDUR view from read MDUR
PPH_E_MRBED_1 view union_all read MRBED
PPH_E_MRBED_1 view from read MRBED
pph_e_Resb_agg_1 view from read RESB AGG
PPH_E_RESB_FLEX view from read RESB FLEX
SHSM_RESB view from CDS View replacing RESB in search help

Fields (199)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY rsnum rsnum Reservation
KEY rspos rspos Item no.
KEY rsart rsart Record type
bdart bdart RequirementType
rssta rssta Reserv. status
xloek xloek Deleted
xwaok xwaok Mvt Allowed
kzear kzear Final Issue
xfehl xfehl Missing Part
matnr matnr Material
werks werks_d Plant
lgort lgort_d Location
prvbe prvbe Supply Area
charg charg_d Batch
plpla plpla Distribution
sobkz sobkz Special Stock
bdter bdter Reqmts date
bdmng bdmng Requirement qty
meins meins Base Unit
shkzg shkzg Debit/Credit
fmeng fmeng Qty. is fixed
enmng enmng Withdrawal Qty
enwrt enwrt Withdr. Value
waers waers Currency
erfmg erfmg Quantity in UnE
erfme erfme Unit of Entry
plnum plnum Planned Order
banfn banfn Purchase Req.
bnfpo bnfpo Requisn. item
aufnr aufnr Order
baugr baugr Pegged Reqmt
sernr sernr BOM expl.number
kdauf kdauf Sales Order
kdpos kdpos Sales Ord. Item
kdein kdein SOrder schedule
projn projn not in use
bwart bwart Movement Type
saknr saknr G/L Account
gsber gsber Business Area
umwrk umwrk Receiving plant
umlgo umlgo Receiving SLoc.
nafkz nafkz FollowUp MatInd
nomat nomat FollUp/OrigMat.
nomng nomng Input Quantity
postp postp Item Category
posnr aposn BOM item
roms1 roms1 Size 1
roms2 roms2 Size 2
roms3 roms3 Size 3
romei romei Size unit
romen romen VSI Quantity
sgtxt sgtxt Text
lmeng lmeng Required Qty
rohps rohps Var-Sized Item
rform rform VSI Formula
roanz roanz Number Required
flmng flmng Missing Qty
stlty stlty BOM category
stlnr stnum BOM
stlkn stlkn Item node
stpoz cim_count Counter
ltxsp ltxsp Long text lang
potx1 potx1 Item Text
potx2 potx2 Item Text
sanka ck_selkz CostingRelevncy
alpos altps Altern. Item
ewahr ewahr Usage Prob.
ausch kausf Component Scrap
avoau avoau Operation Scrap
netau netau Net Indicator
nlfzt nlfzt Lead-tm offset
aennr aennr Change Number
umrez umrez Numerator
umren umren Denominator
sortf sortp Sort String
sbter sbter Latest req.date
verti sa_vertl Distribution
schgt schgt Bulk material
upskz upskz Sub-item ID
dbskz dbskz Direct procure.
txtps txtps Text Item
dumps dumps Phantom item
beikz beikz Mat. Prov. Ind.
erskz erskz Spare Part ID
aufst aufst Order level
aufwg aufwg Order path
baust baust Assbly Ord. Lvl
bauwg bauwg Assbly Ord.Path
aufps aufps Order item no.
ebeln ebeln Purchasing Doc.
ebelp ebelp Item
ebele eeten Schedule Line
knttp knttp Acct Assgmt Cat
kzvbr kzvbr Consumption
pspel ps_posnr WBS Element
aufpl co_aufpl Plan No.f.Oper.
plnfl plnfolge Sequence
vornr vornr Activity
aplzl cim_count Counter
objnr j_objnr Object number
flgat folgenart Sequence Category
gpreis ppcomp Price/currency
fpreis opreifx FxdPrcForgnCrcy
peinh peinh Price unit
rgekz rgekz Backflush
ekgrp ekgrp Purch. Group
rokme rokme VSI UoM
zumei dzumei Unit
zums1 dzums1 Cutting meas. 1
zums2 dzums2 Cutting meas. 2
zums3 dzums3 Cutting meas. 3
zudiv dzudiv Divisor
vmeng vmeng Qty.f.avail.chk
prreg prreg Checking rule
lifzt lifzt Del time (days)
cuobj cuobj Int. object no.
kfpos kfpos Configur. Item
revlv revlv Revision Level
berkz berkz Staging Ind.
lgnum lgnum Warehouse No.
lgtyp lgtyp Storage Type
lgpla lgpla Storage Bin
tbmng tbmng TR quantity
nptxtky txtky Text number
kbnkz kbnkz Kanban Indicat.
kzkup kzkup Co-product
afpos co_posnr Item Number
no_disp no_disp_plus Eff. mat. plng
bdztp bdztp Time qty req'd
esmng esmng Usage qty - UoM
alpgr cs_alpgr AltItemGroup
alprf cs_alprf Priority
alpst cs_alpst Strategy
kzaus auslf Discontin.Type
nfeag cs_nfeag Discont. group
nfpkz cs_kznfp Follow-Up Item
nfgrp cs_nfgrp Follow-up group
nfuml nfuml Transfer factor
adrnr cadnr Address number
chobj cuobj_ch Int.object no.
splkz chsplit Batch key
splrv rspos Item no.
knumh knumh_ch NoCondRec.Batch
wempf wempf Recipient
ablad ablad Unloading Point
hkmat hkmat Material origin
hrkft hrkft Origin Group
vorab vorabkz Prelim. order
matkl matkl Material Group
frunv frunv Ext.dat.incompl
clakz clakz Classification
inpos inpos Intra Material
webaz webaz GR proc. time
lifnr lifnr Supplier
flgex flgex External procurement
funct cy_funct Function
gpreis_2 ppgxxx Price/LCurrency
fpreis_2 ppfxxx Fixed Price/LC
peinh_2 peinh Price unit
infnr infnr Info Record
kzech kzech Enter batch
kzmpf kzmpf Man. Reqmt Date
stlal stalt Alternative
pbdnr pbdnr Requirements Plan
stvkn stvkn Item node
ktoma ktoma Acct manually
vrpla vrpla W/o final assy
kzbws kzbws Valuation
nlfzv cs_nlfzv Oper. LT offset
nlfmv cs_nlfmv Oper. LTO unit
techs techs StandardVariant
objtype ocm_obj_type ChangeInd
ch_proc ocm_ch_proc ChangeProcType
fxpru ck_fixprku Fixed-Price Co-Prod.
umsok umsok Sp.ind.st.tfr.
vorab_sm vorab_sm Adv. shipt
fipos fipos Commitment item
fipex fm_fipex Commitment Item
fistl fistl Funds Center
geber bp_geber Fund
grant_nbr gm_grant_nbr Grant
fkber fkber Functional Area
prio_urg prio_urg Reqmt Urgency
prio_req prio_req Reqmt Priority
kblnr kblnr Earmarked Funds
kblpos kblpos Document Item
budget_pd fm_budget_period Budget Period
sc_object_id /srmerp/object_id Object ID
sc_itm_no /srmerp/sc_itm_no Int. SC Itm No.
sgt_scat sgt_scat Stock Segment
sgt_rcat sgt_rcat Req. Segment
fmfgus_key fmfg_us_key US Govt
_dataaging data_temperature Data Aging
bom_versn cs_versn BOM Version
service_doc_type fco_srvdoc_type Service Doc. Type
service_doc_id fco_srvdoc_id Service Document
service_doc_item_id fco_srvdoc_item_id Service Doc. Item
maintordcompcmtdqtyiskept maintordcompcmtdqtyiskept Keep Committed Qties

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.

-- Reservation/dependent requirements
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE RESB (
    MANDT,                      -- Client [mandt]
    RSNUM,                      -- Reservation [rsnum]
    RSPOS,                      -- Item no. [rspos]
    RSART,                      -- Record type [rsart]
    BDART,                      -- RequirementType [bdart]
    RSSTA,                      -- Reserv. status [rssta]
    XLOEK,                      -- Deleted [xloek]
    XWAOK,                      -- Mvt Allowed [xwaok]
    KZEAR,                      -- Final Issue [kzear]
    XFEHL,                      -- Missing Part [xfehl]
    MATNR,                      -- Material [matnr]
    WERKS,                      -- Plant [werks_d]
    LGORT,                      -- Location [lgort_d]
    PRVBE,                      -- Supply Area [prvbe]
    CHARG,                      -- Batch [charg_d]
    PLPLA,                      -- Distribution [plpla]
    SOBKZ,                      -- Special Stock [sobkz]
    BDTER,                      -- Reqmts date [bdter]
    BDMNG,                      -- Requirement qty [bdmng]
    MEINS,                      -- Base Unit [meins]
    SHKZG,                      -- Debit/Credit [shkzg]
    FMENG,                      -- Qty. is fixed [fmeng]
    ENMNG,                      -- Withdrawal Qty [enmng]
    ENWRT,                      -- Withdr. Value [enwrt]
    WAERS,                      -- Currency [waers]
    ERFMG,                      -- Quantity in UnE [erfmg]
    ERFME,                      -- Unit of Entry [erfme]
    PLNUM,                      -- Planned Order [plnum]
    BANFN,                      -- Purchase Req. [banfn]
    BNFPO,                      -- Requisn. item [bnfpo]
    AUFNR,                      -- Order [aufnr]
    BAUGR,                      -- Pegged Reqmt [baugr]
    SERNR,                      -- BOM expl.number [sernr]
    KDAUF,                      -- Sales Order [kdauf]
    KDPOS,                      -- Sales Ord. Item [kdpos]
    KDEIN,                      -- SOrder schedule [kdein]
    PROJN,                      -- not in use [projn]
    BWART,                      -- Movement Type [bwart]
    SAKNR,                      -- G/L Account [saknr]
    GSBER,                      -- Business Area [gsber]
    UMWRK,                      -- Receiving plant [umwrk]
    UMLGO,                      -- Receiving SLoc. [umlgo]
    NAFKZ,                      -- FollowUp MatInd [nafkz]
    NOMAT,                      -- FollUp/OrigMat. [nomat]
    NOMNG,                      -- Input Quantity [nomng]
    POSTP,                      -- Item Category [postp]
    POSNR,                      -- BOM item [aposn]
    ROMS1,                      -- Size 1 [roms1]
    ROMS2,                      -- Size 2 [roms2]
    ROMS3,                      -- Size 3 [roms3]
    ROMEI,                      -- Size unit [romei]
    ROMEN,                      -- VSI Quantity [romen]
    SGTXT,                      -- Text [sgtxt]
    LMENG,                      -- Required Qty [lmeng]
    ROHPS,                      -- Var-Sized Item [rohps]
    RFORM,                      -- VSI Formula [rform]
    ROANZ,                      -- Number Required [roanz]
    FLMNG,                      -- Missing Qty [flmng]
    STLTY,                      -- BOM category [stlty]
    STLNR,                      -- BOM [stnum]
    STLKN,                      -- Item node [stlkn]
    STPOZ,                      -- Counter [cim_count]
    LTXSP,                      -- Long text lang [ltxsp]
    POTX1,                      -- Item Text [potx1]
    POTX2,                      -- Item Text [potx2]
    SANKA,                      -- CostingRelevncy [ck_selkz]
    ALPOS,                      -- Altern. Item [altps]
    EWAHR,                      -- Usage Prob. [ewahr]
    AUSCH,                      -- Component Scrap [kausf]
    AVOAU,                      -- Operation Scrap [avoau]
    NETAU,                      -- Net Indicator [netau]
    NLFZT,                      -- Lead-tm offset [nlfzt]
    AENNR,                      -- Change Number [aennr]
    UMREZ,                      -- Numerator [umrez]
    UMREN,                      -- Denominator [umren]
    SORTF,                      -- Sort String [sortp]
    SBTER,                      -- Latest req.date [sbter]
    VERTI,                      -- Distribution [sa_vertl]
    SCHGT,                      -- Bulk material [schgt]
    UPSKZ,                      -- Sub-item ID [upskz]
    DBSKZ,                      -- Direct procure. [dbskz]
    TXTPS,                      -- Text Item [txtps]
    DUMPS,                      -- Phantom item [dumps]
    BEIKZ,                      -- Mat. Prov. Ind. [beikz]
    ERSKZ,                      -- Spare Part ID [erskz]
    AUFST,                      -- Order level [aufst]
    AUFWG,                      -- Order path [aufwg]
    BAUST,                      -- Assbly Ord. Lvl [baust]
    BAUWG,                      -- Assbly Ord.Path [bauwg]
    AUFPS,                      -- Order item no. [aufps]
    EBELN,                      -- Purchasing Doc. [ebeln]
    EBELP,                      -- Item [ebelp]
    EBELE,                      -- Schedule Line [eeten]
    KNTTP,                      -- Acct Assgmt Cat [knttp]
    KZVBR,                      -- Consumption [kzvbr]
    PSPEL,                      -- WBS Element [ps_posnr]
    AUFPL,                      -- Plan No.f.Oper. [co_aufpl]
    PLNFL,                      -- Sequence [plnfolge]
    VORNR,                      -- Activity [vornr]
    APLZL,                      -- Counter [cim_count]
    OBJNR,                      -- Object number [j_objnr]
    FLGAT,                      -- Sequence Category [folgenart]
    GPREIS,                     -- Price/currency [ppcomp]
    FPREIS,                     -- FxdPrcForgnCrcy [opreifx]
    PEINH,                      -- Price unit [peinh]
    RGEKZ,                      -- Backflush [rgekz]
    EKGRP,                      -- Purch. Group [ekgrp]
    ROKME,                      -- VSI UoM [rokme]
    ZUMEI,                      -- Unit [dzumei]
    ZUMS1,                      -- Cutting meas. 1 [dzums1]
    ZUMS2,                      -- Cutting meas. 2 [dzums2]
    ZUMS3,                      -- Cutting meas. 3 [dzums3]
    ZUDIV,                      -- Divisor [dzudiv]
    VMENG,                      -- Qty.f.avail.chk [vmeng]
    PRREG,                      -- Checking rule [prreg]
    LIFZT,                      -- Del time (days) [lifzt]
    CUOBJ,                      -- Int. object no. [cuobj]
    KFPOS,                      -- Configur. Item [kfpos]
    REVLV,                      -- Revision Level [revlv]
    BERKZ,                      -- Staging Ind. [berkz]
    LGNUM,                      -- Warehouse No. [lgnum]
    LGTYP,                      -- Storage Type [lgtyp]
    LGPLA,                      -- Storage Bin [lgpla]
    TBMNG,                      -- TR quantity [tbmng]
    NPTXTKY,                    -- Text number [txtky]
    KBNKZ,                      -- Kanban Indicat. [kbnkz]
    KZKUP,                      -- Co-product [kzkup]
    AFPOS,                      -- Item Number [co_posnr]
    NO_DISP,                    -- Eff. mat. plng [no_disp_plus]
    BDZTP,                      -- Time qty req'd [bdztp]
    ESMNG,                      -- Usage qty - UoM [esmng]
    ALPGR,                      -- AltItemGroup [cs_alpgr]
    ALPRF,                      -- Priority [cs_alprf]
    ALPST,                      -- Strategy [cs_alpst]
    KZAUS,                      -- Discontin.Type [auslf]
    NFEAG,                      -- Discont. group [cs_nfeag]
    NFPKZ,                      -- Follow-Up Item [cs_kznfp]
    NFGRP,                      -- Follow-up group [cs_nfgrp]
    NFUML,                      -- Transfer factor [nfuml]
    ADRNR,                      -- Address number [cadnr]
    CHOBJ,                      -- Int.object no. [cuobj_ch]
    SPLKZ,                      -- Batch key [chsplit]
    SPLRV,                      -- Item no. [rspos]
    KNUMH,                      -- NoCondRec.Batch [knumh_ch]
    WEMPF,                      -- Recipient [wempf]
    ABLAD,                      -- Unloading Point [ablad]
    HKMAT,                      -- Material origin [hkmat]
    HRKFT,                      -- Origin Group [hrkft]
    VORAB,                      -- Prelim. order [vorabkz]
    MATKL,                      -- Material Group [matkl]
    FRUNV,                      -- Ext.dat.incompl [frunv]
    CLAKZ,                      -- Classification [clakz]
    INPOS,                      -- Intra Material [inpos]
    WEBAZ,                      -- GR proc. time [webaz]
    LIFNR,                      -- Supplier [lifnr]
    FLGEX,                      -- External procurement [flgex]
    FUNCT,                      -- Function [cy_funct]
    GPREIS_2,                   -- Price/LCurrency [ppgxxx]
    FPREIS_2,                   -- Fixed Price/LC [ppfxxx]
    PEINH_2,                    -- Price unit [peinh]
    INFNR,                      -- Info Record [infnr]
    KZECH,                      -- Enter batch [kzech]
    KZMPF,                      -- Man. Reqmt Date [kzmpf]
    STLAL,                      -- Alternative [stalt]
    PBDNR,                      -- Requirements Plan [pbdnr]
    STVKN,                      -- Item node [stvkn]
    KTOMA,                      -- Acct manually [ktoma]
    VRPLA,                      -- W/o final assy [vrpla]
    KZBWS,                      -- Valuation [kzbws]
    NLFZV,                      -- Oper. LT offset [cs_nlfzv]
    NLFMV,                      -- Oper. LTO unit [cs_nlfmv]
    TECHS,                      -- StandardVariant [techs]
    OBJTYPE,                    -- ChangeInd [ocm_obj_type]
    CH_PROC,                    -- ChangeProcType [ocm_ch_proc]
    FXPRU,                      -- Fixed-Price Co-Prod. [ck_fixprku]
    UMSOK,                      -- Sp.ind.st.tfr. [umsok]
    VORAB_SM,                   -- Adv. shipt [vorab_sm]
    FIPOS,                      -- Commitment item [fipos]
    FIPEX,                      -- Commitment Item [fm_fipex]
    FISTL,                      -- Funds Center [fistl]
    GEBER,                      -- Fund [bp_geber]
    GRANT_NBR,                  -- Grant [gm_grant_nbr]
    FKBER,                      -- Functional Area [fkber]
    PRIO_URG,                   -- Reqmt Urgency [prio_urg]
    PRIO_REQ,                   -- Reqmt Priority [prio_req]
    KBLNR,                      -- Earmarked Funds [kblnr]
    KBLPOS,                     -- Document Item [kblpos]
    BUDGET_PD,                  -- Budget Period [fm_budget_period]
    SC_OBJECT_ID,               -- Object ID [/srmerp/object_id]
    SC_ITM_NO,                  -- Int. SC Itm No. [/srmerp/sc_itm_no]
    SGT_SCAT,                   -- Stock Segment [sgt_scat]
    SGT_RCAT,                   -- Req. Segment [sgt_rcat]
    FMFGUS_KEY,                 -- US Govt [fmfg_us_key]
    _DATAAGING,                 -- Data Aging [data_temperature]
    BOM_VERSN,                  -- BOM Version [cs_versn]
    SERVICE_DOC_TYPE,           -- Service Doc. Type [fco_srvdoc_type]
    SERVICE_DOC_ID,             -- Service Document [fco_srvdoc_id]
    SERVICE_DOC_ITEM_ID,        -- Service Doc. Item [fco_srvdoc_item_id]
    MAINTORDCOMPCMTDQTYISKEPT,  -- Keep Committed Qties [maintordcompcmtdqtyiskept]
    PRIMARY KEY (MANDT, RSNUM, RSPOS, RSART)
);

Learn More