Skip to Content
Feb 08, 2022 at 06:57 PM

Creating a Query to Mimic FBL1N Problems with Negative Amount in DC


The SAP report FBL1N displays a Name field however, when you export it the Supplier number is all that gets populated. I have created a Query to mimic this report but includes the Name 1 Field. FBL1N uses the RFPOSXEXT-WRSHB field and it is also available on the BSEG table however this can not be used when creating a query and joining tables. I am using BSAK-WRBTR for the Amount in Document Currency however, the query won't pull in negative entries.

Am I missing something in the query set up or do I need to use a different table and field to get both positive and negative entries?