cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to get U_Lister and U_Seller Values

former_member722674
Discoverer
0 Kudos

Hi Kennedy,

Can please help me with this I am not getting the values of U_Seller and U_Lister with this code

Is any other way I can write?

SELECT T3.[GrpCode], T0.[ProfitCode], T3.[PrcName], T1.[TransId], T2.[AcctCode], T2.[AcctName], T0.[RefDate], Case T0.[FinncPriod] When 181 then '2020/001' When 182 then '2020/002' When 183 then '2020/003' When 184 then '2020/004' When 185 then '2020/005' When 186 then '2020/006' When 187 then '2020/007' When 188 then '2020/008' When 189 then '2020/009' When 190 then '2020/010' When 191 then '2020/011' When 192 then '2020/012' When 193 then '2021/001' End as 'Posting Period', case T1.[TransType] when 13 then 'A/R Invoice' when 14 then 'A/R Credit Note' when 18 then 'A/P Invoice' when 19 then 'A/P Credit Note' when 24 then 'Receipt' when 46 then 'Payment' when 30 then 'Journal Entry' else 'OTHER' end as 'Transaction Type', T0.[Ref1], T1.[Ref2], T0.[Ref3Line], T0.[LineMemo], T0.Credit - T0.Debit 'Balance', T8.Lister, T9.Dealer, T8.DocNum, T0.U_Seller as 'Lister Consultant_JE' , T0.U_Lister as 'Deal Consultant_JE' FROM JDT1 T0 INNER JOIN OJDT T1 ON T0.[TransId] = T1.[TransId] INNER JOIN OACT T2 ON T0.[Account] = T2.[AcctCode] INNER JOIN OPRC T3 ON T0.[ProfitCode] = T3.[PrcCode] LEFT JOIN (SELECT DISTINCT T6.U_Seller Lister, T6.AcctCode,T7.DocNum DocNum,T7.TransId TransId FROM INV1 T6 INNER JOIN OINV T7 ON T6.DocEntry=T7.DocEntry ) T8 On T8.TransId=T1.TransId and T1.BaseRef=T8.DocNum LEFT JOIN (SELECT DISTINCT T6.U_Lister Dealer, T6.AcctCode,T7.DocNum DocNum FROM INV1 T6 INNER JOIN OINV T7 ON T6.DocEntry=T7.DocEntry ) T9 On T9.TransId=T1.TransId and T1.BaseRef=T9.DocNum WHERE T0.[RefDate] >=[%0] AND T0.[RefDate] <=[%1] AND T2.[GroupMask] =[%2]

lenastodal
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi and welcome to the SAP Community!

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't already), as it provides tips for preparing questions that draw responses from our members. For example, you can outline what steps you took to find answers (and why they weren't helpful) and share screenshots of what you've seen/done. The more details you provide, the more likely it is that members will be able to assist you.
Should you wish, you can still edit your question.
Finally, if you're hoping to connect with readers, please consider adding a picture to your profile as it encourages readers to respond to you. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS.

Best,
Lena
SAP Community Moderator

Accepted Solutions (0)

Answers (0)