Hello everyone,
I am working in an intergration project and call BAPI BAPI_ACC_DOCUMENT_POST to create FI document.
Here comes a question, that some withholding tax code(For example,WA) are not calculated/posted when I use the BAPI.But the tax ba...
Hi.My name is Naomy and I'm an intern in SAP. Recently, I have used TPC-H benchmark(2.17.1) to run some tests on HANA database.Although all of the queries are written in the SQL-92 language, some queries still need to be rectified so that they can be...
Hi,I'd want to use "AS" to create a temp table for the result of a subquery. But the query can not be executed.How can I fix this error?Do I need to create a view ?select c_count, count(*) as custdistfrom ( select c_custkey, count(o_orderkey) fr...
Hi,The query counts the number of orders ordered in a given quarter of a given year in which at least one lineitem was received by the customer later than its committed date. And i used 'interval' to get the quarter.But the query can not be executed....
Hi Remi,I haven't measure the different partitionning strategy on large tables yet,but I 'm going to do it this month.I hope I can provide some valuable results later.BTW,does the 'flat files' you mention is the data generated by TPC-H DBGEN?
I still need c_count as an alias for count(o_orderkey).Based on Wenjun's solution,I correct the SQL statement and it work now. select c_count, count(*) as custdistfrom ( select c_custkey, count(o_orderkey) as c_count from customer left outer jo...
