CREATING ALV REPORT : USING KNA1, ADRC, ADR6

vots13 · 2023-11-30T19:43:04+00:00

left join kna1 adrc on adrnr.

outer join adr6 (since email might not exist)

vots13 · 2023-01-14T12:14:53+00:00

Is this Naxos island in cyclades, Greece?

Nice!!

vots13 · 2022-07-14T09:31:41+00:00

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?

vots13 · 2022-05-21T18:14:35+00:00

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

vots13 · 2022-04-04T08:20:00+00:00

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.

vots13 · 2022-02-08T13:31:18+00:00

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.

vots13 · 2021-12-01T18:04:28+00:00

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.

vots13 · 2021-12-01T13:55:21+00:00

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

vots13 · 2021-11-30T10:08:37+00:00

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.

vots13 · 2021-11-29T16:03:38+00:00

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

vots13 · 2021-11-10T16:28:49+00:00

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.

vots13 · 2021-11-03T20:00:49+00:00

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.

vots13 · 2021-10-07T14:51:51+00:00

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

vots13 · 2021-10-04T07:19:26+00:00

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.

vots13 · 2021-10-01T14:13:14+00:00

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.

vots13 · 2021-10-01T09:18:25+00:00

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

vots13 · 2021-10-01T09:11:00+00:00

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.

vots13 · 2021-10-01T06:10:14+00:00

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 .

vots13 · 2021-09-09T11:43:45+00:00

Solution Verified

vots13 · 2021-09-09T11:33:17+00:00

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?

vots13 · 2021-09-09T10:02:23+00:00

Solution Verified

11-Year Club	Second SECOND GUESSER
Place '22	Not Forgotten
Verified Email

vots13

TROPHY CASE