cancel
Showing results for 
Search instead for 
Did you mean: 

Query report of Bin location and Batch SAP Business One

former_member681067
Discoverer
0 Kudos
3,084

Hello all,

Please help me on query report for item wise batch details with it's bin location.

SAP Business One HANA

Regards,

Nikunj Mehta

View Entire Topic
PierreBrothier
Contributor

Hi,

take a look at the following tables :

  1. OBBQ - Item - Serial/Batch - Bin Accumulator
  2. OBTN -Batch Numbers Master Data
  3. OBIN - Bin Location

former_member681067
Discoverer
0 Kudos

Can you help me on query generation.

I am getting error like

1). [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;260 invalid column name: T0.BINABS: line 1 col 47 'Backend scheduling job' (OBSJ) (at pos 46).

PierreBrothier
Contributor
0 Kudos

Hi,

when writing HANA SQL Query, you'll need to enclosed field name with double quote,

Like T0."BinAbs" as it is case sensitive.