Member since ‎04-03-2022

User Statistics

  • 9 Posts
  • 0 Solutions
  • 2 Kudos given
  • 0 Kudos received

User Activity

when i use this query SELECT T1."ItemCode", T1."Dscription", T1."Quantity", T3."OnHand" , t0."DocDate" FROM OWTQ T0 INNER JOIN WTQ1 T1 ON T0."DocEntry" = T1."DocEntry" INNER JOIN OITM T2 ON T1."ItemCode" = T2."...
i don't no why sap b1 query generator give error in this query SELECT * from (select to_number(SUBSTR(T0."U_TR_REF" , 5, 6 )) AS "REF_NUMBER" , t1."ItemCode" , t1."Dscription", T1."FromWhsCod" , t1."Quantity" , T0."DocDa...
I want generate by query a list of dates between two dates , i mean if i have two dates 01-01-2022 and 05-01-2022 i want query get this result 01-01-2022 02-01-2022 03-01-2022 04-01-2022 05-01-2022
Is there a table in the database "SAP B1" that contains a list of names of the tables and their object types
Kudos given to