RSDB
Index of the RESB for the Direct Procurement Element
RSDB is an SAP database table in S/4HANA. Index of the RESB for the Direct Procurement Element. It contains 15 fields. 7 CDS views read from this table.
CDS Views using this table (7)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_FldLogsProcRcptMaintOrd | view | from | BASIC | Maintenance orders for process receipts FL |
| I_MaintenanceOrderComponent | view | left_outer | BASIC | Maintenance Order Component |
| I_MaintOrdCompResvnPurgDoc | view | from | BASIC | Purchasing Document for Reservation |
| P_MaintOrderCompForDrctProcmt | view | left_outer | BASIC | |
| P_Projmatcomponent | view | from | BASIC | |
| P_ProjMatCompPurDocItems | view | from | BASIC | |
| P_ProjMatCompPurDocItems | view | union_all | BASIC |
Fields (15)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | rsnum | rsnum | Reservation | |||
| KEY | rspos | rspos | Item no. | |||
| KEY | rsart | rsart | Record type | |||
| KEY | rsinz | rsinz | Index counter | |||
| plnum | plnum | Planned Order | ||||
| banfn | banfn | Purchase Req. | ||||
| bnfpo | bnfpo | Requisn. item | ||||
| ebeln | ebeln | Purchasing Doc. | ||||
| ebelp | ebelp | Item | ||||
| aufnr | aufnr | Order | ||||
| aufpo | co_posnr | Item Number | ||||
| aobar | aobar | Relations. type | ||||
| zeinh | aobdaueh | Rel. unit | ||||
| dauer | aobdauer | Time Interval |
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.
-- Index of the RESB for the Direct Procurement Element
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE RSDB (
MANDT, -- Client [mandt]
RSNUM, -- Reservation [rsnum]
RSPOS, -- Item no. [rspos]
RSART, -- Record type [rsart]
RSINZ, -- Index counter [rsinz]
PLNUM, -- Planned Order [plnum]
BANFN, -- Purchase Req. [banfn]
BNFPO, -- Requisn. item [bnfpo]
EBELN, -- Purchasing Doc. [ebeln]
EBELP, -- Item [ebelp]
AUFNR, -- Order [aufnr]
AUFPO, -- Item Number [co_posnr]
AOBAR, -- Relations. type [aobar]
ZEINH, -- Rel. unit [aobdaueh]
DAUER, -- Time Interval [aobdauer]
PRIMARY KEY (MANDT, RSNUM, RSPOS, RSART, RSINZ)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA