About MuhammadBilal

MuhammadBilal

Try the below query, Replace or Remove the item code as required.Select x."ItemCode", x."BatchID", x."BatchNumber", x."ExpDate", x."BinLocation", x."Qty"From(Select a."ItemCode", a."SnBMDAbs" as "BatchID", c."DistNumber" as "BatchNumber", c."ExpDate"...

MuhammadBilal

Use the following Query.Select x."ItemCode", x."BatchID", x."BatchNumber", x."ExpDate", x."BinLocation", x."Qty"From(Select a."ItemCode", a."SnBMDAbs" as "BatchID", c."DistNumber" as "BatchNumber", c."ExpDate", b."BinCode" as "BinLocation",Sum(a."OnH...

Re: User Defined Windows Authorization

Thanks a lot. It worked as a Charm.

User Statistics

User Activity

Re: Query report of Bin location and Batch SAP Business One

Re: Item list Batch wise bin location wise sbo HANA repor...

Re: User Defined Windows Authorization