SAP table RBVS (Invoice Verification: Split Invoice Amount)
SAP table RBVS has 4 primary key fields being MANDT,BELNR,GJAHR,SPLIT_KEY.
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 | |
| BELNR | Document Number of an Invoice Document | CHAR | 10 | 0 | RE_BELNR | ||
| GJAHR | Fiscal Year | NUMC | 4 | 0 | GJAHR | ||
| SPLIT_KEY | Grouping Key for Splitting Supplier Line Item | NUMC | 6 | 0 | SPLIT_KEY | ||
| SRMWWR | Partial gross invoice amount in document currency | CURR | 13 | 2 | SRMWWR | ||
| ZLSCH | Payment Method | CHAR | 1 | 0 | T042Z | DZLSCH | |
| MWSKZ | Tax on sales/purchases code | CHAR | 2 | 0 | T007A | MWSKZ | |
| UZAWE | Payment method supplement | CHAR | 2 | 0 | UZAWE | ||
| ZTERM | Terms of payment key | CHAR | 4 | 0 | DZTERM | ||
| NODE_KEY | GUID: MM Supplier Invoice in S-Innovations | RAW | 16 | 0 | MRM_SI_GUID | ||
| PARENT_KEY | GUID: MM Supplier Invoice in S-Innovations | RAW | 16 | 0 | MRM_SI_GUID | ||
| ROOT_KEY | GUID: MM Supplier Invoice in S-Innovations | RAW | 16 | 0 | MRM_SI_GUID | ||
| BVTYP | Partner bank type | CHAR | 4 | 0 | BVTYP |
RBVS foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 RBVS | MWSKZ | T007A | Tax Keys | KALSM |
| 0 RBVS | MWSKZ | T007A | Tax Keys | MWSKZ |
| 1 RBVS | ZLSCH | T042Z | Payment Methods for Automatic Payment | MANDT |
| 1 RBVS | ZLSCH | T042Z | Payment Methods for Automatic Payment | LAND1 |
| 1 RBVS | ZLSCH | T042Z | Payment Methods for Automatic Payment | ZLSCH |