SAP table RSDB (Index of the RESB for the Direct Procurement Element)
SAP table RSDB has 5 primary key fields being MANDT,RSNUM,RSPOS,RSART,RSINZ.
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 | |
| RSNUM | Number of reservation/dependent requirements | NUMC | 10 | 0 | RSNUM | ||
| RSPOS | Item Number of Reservation / Dependent Requirements | NUMC | 4 | 0 | RSPOS | ||
| RSART | Record type | CHAR | 1 | 0 | RSART | ||
| RSINZ | Index counter for direct procurement elements | NUMC | 2 | 0 | RSINZ | ||
| PLNUM | Planned Order | CHAR | 10 | 0 | PLNUM | ||
| BANFN | Purchase Requisition Number | CHAR | 10 | 0 | BANFN | ||
| BNFPO | Item number of purchase requisition | NUMC | 5 | 0 | EBAN | BNFPO | |
| EBELN | Purchasing Document Number | CHAR | 10 | 0 | EKKO | EBELN | |
| EBELP | Item Number of Purchasing Document | NUMC | 5 | 0 | EBELP | ||
| AUFNR | Order Number | CHAR | 12 | 0 | AUFNR | ||
| AUFPO | Order item number | NUMC | 4 | 0 | CO_POSNR | ||
| AOBAR | Type of relationship | CHAR | 2 | 0 | AOBAR | ||
| ZEINH | Unit for the time interval between relationships | UNIT | 3 | 0 | T006 | AOBDAUEH | |
| DAUER | Time Interval Between Relationships | QUAN | 5 | 1 | AOBDAUER |
RSDB foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 RSDB | BNFPO | EBAN | Purchase Requisition | BANFN |
| 0 RSDB | BNFPO | EBAN | Purchase Requisition | BNFPO |
| 1 RSDB | EBELN | EKKO | Purchasing Document Header | EBELN |
| 0 RSDB | ZEINH | T006 | Units of Measurement | MANDT |