SAP table RBWS (Withholding Tax Data, Incoming Invoice)

SAP table RBWS has 5 primary key fields being MANDT,BELNR,GJAHR,SPLIT_KEY,WITHT.

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 RBVS SPLIT_KEY
WITHT Indicator for Withholding Tax Type CHAR 2 0 T059P WITHT
WT_WITHCD Withholding Tax Code CHAR 2 0 T059Z WT_WITHCD
WT_QSSHB Withholding Tax Base Amount in Document Currency CURR 15 2 WT_BS1_CS
WT_QBUIHB Withholding Tax Amount Entered Manually in Document Currency CURR 15 2 WT_QBUIHB_CS
WT_WWRBTR Withholding Tax Amount Already Withheld in Document Currency CURR 15 2 WT_AWT1_CS
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

RBWS foreign key relationships

Table Field Check Table Check Field
0 RBWS SPLIT_KEY RBVS Invoice Verification: Split Invoice Amount .INCLUDE
0 RBWS SPLIT_KEY RBVS Invoice Verification: Split Invoice Amount MANDT
0 RBWS SPLIT_KEY RBVS Invoice Verification: Split Invoice Amount BELNR
0 RBWS SPLIT_KEY RBVS Invoice Verification: Split Invoice Amount GJAHR
1 RBWS WITHT T059P Withholding tax types MANDT
1 RBWS WITHT T059P Withholding tax types LAND1
1 RBWS WITHT T059P Withholding tax types WITHT
0 RBWS WT_WITHCD T059Z Withholding tax code (enhanced functions) MANDT
0 RBWS WT_WITHCD T059Z Withholding tax code (enhanced functions) LAND1
0 RBWS WT_WITHCD T059Z Withholding tax code (enhanced functions) WITHT