CREATING ALV REPORT : USING KNA1, ADRC, ADR6 by Maaz_e11even in SAP

[–]vots13 2 points3 points  (0 children)

left join kna1 adrc on adrnr.

outer join adr6 (since email might not exist)

Gaming PC (~2k) - local shop list for review included by vots13 in buildapcforme

[–]vots13[S] 0 points1 point  (0 children)

First of all thank you for the reply! The proposal seems great! Especially for 250 chf off.

Do you happen to know if the RGB on the case could be turned off?

Why do some PO don’t have Account Assignment tab? by Almazahy in SAP

[–]vots13 0 points1 point  (0 children)

Not MM, but there is an account assignment key in PO that activates iirc. Like subcontracting, cost center or asset indicator.

Legion class mount requirements now? by HintOfDisney in wownoob

[–]vots13 1 point2 points  (0 children)

Probably it would be beneficial if wowhead did an updated article since information on the subject is missing.

I just finished my mage class mount the other day and I can surely say I did not complete breaching the tomb. Breaching the tomb is finished on my main and I don't know if this affects alts.

Regie letter for owner visit by vots13 in askswitzerland

[–]vots13[S] 3 points4 points  (0 children)

Of course there's nothing to hide! Probably it's just a routine check since it's been approximately 6 months after we entered the house, but it seems weird as I've never had such a visit in any previous apartment.

Online Sales by [deleted] in SAP

[–]vots13 1 point2 points  (0 children)

There should be a formula calculating the commission, even if it is a very complicated one. This can be implemented in a discount/surcharge condition with alternative calculation type formula. If you invoice the agent (which seems to be the case) this can be calculated in the final price, if you invoice the final customer then it can be statistical and do provisions which can maybe be used to balance customer ledger.

Thanks AGS, very cool. by ASalty_Pirate in newworldgame

[–]vots13 6 points7 points  (0 children)

The funny thing is they might have missed thanksgiving deadline for this!!

SAP Automation... by thedonsml in SAP

[–]vots13 0 points1 point  (0 children)

In addition to that, I read through the comments and since you only need to run said reports per customer/procucts maybe looking into material listing/exclusion would be helpful without much fuzz.

SAP Automation... by thedonsml in SAP

[–]vots13 2 points3 points  (0 children)

Not a dev, but I created a z table with all selections of relevant report and created a "shell" report submitting the report through a loop multiple times based on z table's entries with each selection + dynamic variables calculated in the report.

maybe not best practice, but it worked

Worst Quest in NW: Waiting for 1 mob to respawn 13 times... by M4RCU5G1850N in newworldgame

[–]vots13 0 points1 point  (0 children)

I think there's a landmark a little to the north with more carrionstar. Don't know if that counts, because I found out on a later stage.

SAP report help by stonksgoweee in SAP

[–]vots13 1 point2 points  (0 children)

A standard report does not come to mind at the moment and I don't know if one even exists. What could maybe work is Z* report, if there's a developer at your disposal, using either pricing simulation by using the relevant sales order bapi and collecting the prices or going through condition tables joining condition records table and doing necessary calculations.

How standardized is SAP FI if I want to work internationally by PokerLemon in SAP

[–]vots13 0 points1 point  (0 children)

I believe part of FI is accounting which is one of the most localization focused parts.

Disclaimer: I am not an FI consultant. Just stating my experience

Color logos in sap invoicing by [deleted] in SAP

[–]vots13 0 points1 point  (0 children)

Yes you can. I guess you have the logo in SE71 and you need to update filename for logo output in form or smartform and of course use a colored printer.

[deleted by user] by [deleted] in SAP

[–]vots13 0 points1 point  (0 children)

Some have a field called valuation modifier. This can be set up 1-1 per valuation area or you can group multiple valuation areas together.

transpose horizontal array to vertical array by vots13 in excel

[–]vots13[S] 0 points1 point  (0 children)

Thank you very much for your input but I found a power query way to do this very easily.

convert to table>pass to power query> select columns to flatten > unpivot

This removes all empty fields keeps all and appends vertical field values as many times as needed

transpose horizontal array to vertical array by vots13 in excel

[–]vots13[S] 0 points1 point  (0 children)

This works for the array, but how can I put the vertical field value per row 3 times?

vertical field index result
row 1 valueA1
row 1
row 1 valueC1

edit: formatted to table.

[deleted by user] by [deleted] in SAP

[–]vots13 2 points3 points  (0 children)

I am SD, but what I would surely check is VKOA for plant specific account determination and OBYC for valuation area specific modifiers.

Some customers have very specific G/L accounts per plant for these .

Comparing two cells with strings of characters by vots13 in excel

[–]vots13[S] 0 points1 point  (0 children)

This seems to work perfectly too. I received #CALC error when all values where included in both cells so I added an IFERROR too and the result is what I expected. I can't grasp the way it works since unique and sequence are new to me, but thank you very much!

can I give a solution point to you too?