SAP table T046S (Exceptions from cashed bills of exchange paid to vendors)

SAP table T046S has 4 primary key fields being MANDT,BUKRS,HBKID,MOTIF.

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
BUKRS Company Code CHAR 4 0 T001 BUKRS
HBKID Short Key for a House Bank CHAR 5 0 T012 HBKID
MOTIF Reason for Refusal to Pay a Bill of Exchange CHAR 2 0 MOTIF_046S
RTYPE Reason for Refusal to Pay Bill/Exch. Returned to House Bank CHAR 2 0 RTYPE_046S
01 Payable bill of exchange does not exist
02 Incorrect due date
03 Incorrect issue date
04 Bill of exchange amount is incorrect
05 Incorrect acceptance indicator
06 The account holder is not the drawee
07 Other bank in bill of exchange
08 Bill of exchange receivable has already been paid
09 Only accepted bills of exchange should be paid
10 Renewal of bill of exchange applied for
11 Partial payment
DEFAU Default Value for Returned Bills of Exchange via DME CHAR 1 0 DEFAU_046S
Not as default while checking external data
X Default value for checking external data
DTAKZ Indicator for Notification via DME CHAR 10 0 DTAKZ_046S

T046S foreign key relationships

Table Field Check Table Check Field
0 T046S BUKRS T001 Company Codes BUKRS
1 T046S HBKID T012 House Banks BUKRS
0 T046S MANDT T000 Clients MANDT