Hello Expert !
I need a query to give a user possibility to choose only few value in UDT in Query Generator.
Example : I have UDT that contains 4 Sales Order Type : 1. Dupak Grosir 2. Dupak Megah 3. E-Commerce 4. Services
but i just wanna sh...
Hi Expert, please help me,
i have a script SPN and running well on transaction Receipt From Production, but cause error on Trans. Good Receipt
then show error like this : "1). [SAP AG][LIBODBCHDB32 DLL][HDBODBC32] Syntax error or access violatio...
Try this ...CREATE PROCEDURE HR_INFO_USR_LOGIN
LANGUAGE SQLSCRIPT
SQL SECURITY INVOKER AS
BEGIN
SELECT X."CardCode", Y."PrintBy", Y."Client"
FROM DUMMY
LEFT JOIN
( SELECT "CardCode"
FROM OCRD
WHERE LEFT("CardCode",2) = 'CJ'
) X ON 1 = 1
LEFT...
if (:object_type = '18') and (:transaction_type='A')
then
select count(*) into cnt from
(
select * from "PCH1" T0
INNER JOIN "OPCH" T1 ON T0."DocEntry" = T1."DocEntry"
INNER JOIN "OITM" T2 ON T0."ItemCode" = T2."ItemCode"
...
SELECT
T0."AcctCode", T0."AcctName",
CASE WHEN T1."TransType" = 13 THEN 'IN - A/R Invoice'
WHEN T1."TransType" = 14 THEN 'CN - A/R Credit Memo'
WHEN T1."TransType" = 15 THEN 'DN - Delivery'
WHEN T1."TransType" = 16 ...
Thank Danish for your reply "Declare variable" is already at above my SPTN just now i have idea, adding this script and ... YES DONE without Error in Good Receipt and also Receipt from Productionif (:object_type = '59') and (:transaction_type='A' o...
