Skip to Content

Fields to create a revenue per unit sold report in S4HANA

In a scenario for S4HANA 1709 with FI-CA also enabled, I can get revenue using the GL account hierarchy and ACDOCA but I need to combine it with units sold information to calculate Revenue per unit sold.

Where do I get units sold?

I considered going using DFKKOP instead of ACDOCA to start but not sure of the rest.

Please advise.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • Best Answer
    Jun 04 at 08:35 AM

    Hello Shyam,

    If you're really worried about the values posted to G/L, you can do a further check as well using Reconciliation Key Transfer. Get Reconciliation Key from same table and check if it is transferred to G/L completely using table DFKKSUMC.

    If you want to do this on the fly, then find some events during the transfer to get the revenues part.

    The Document Type is available in table TFK003 in FICA.

    Br, Arun

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 03 at 09:24 AM

    Hello Shyam,

    You can't combine DFKKOPK and ACDOCA. Because it is grouped and summarized within FICA and totals are sent to ACDOCA. We need to do multiple things to achieve this.

    Why can't you take revenues from DFKKOPK and if you need document type, you can take it from DFKKKO for the same Document number.

    This will be within sub ledger FICA and doesn't have any link with ACDOCA. The revenues can be taken at this level itself.

    Br, Arun

    Add comment
    10|10000 characters needed characters exceeded

    • Thanks Arun. I got the document type in this table that you mentioned but strangely, the document type here is IN (probably for invoice) but this does not exist in the document type master data table T003T. Why can't I find the text for this document type.

      Also, as a separate question, I am picking up quantities and amounts from dfkkinvdoc_i - the invoice item table and linking them to their G account in DFKKOPK. Now, filtering on only revenue accounts here, I am deriving the revenue per unit.

      What I fear would be a flaw in this logic is that I don't know here if these revenues are posted to G/L. Just because an invoice is linked to a revenue G/L account, is it safe to assume there's actual revenue posted?

      We have the RAR component also in S4. Just to let you know. Not sure if that changes anything.

      Please let me know. Thanks.

  • May 28 at 03:30 PM

    Hello Shyam,

    If you have Convergent Invoicing enabled, you can really make use of standard COPA functionality. This helps you to get revenues based on units and also at a product level. Further, it can be imported into BI for analysis.

    The standalone FICA doesn't capture these details at unit level. But, it is only DFKKOP and DFKKOP table from which you can pull in data for revenues and receivables in FICA.

    Br, Arun

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Arun,

      Thank you for your reply. Yes we have CI.

      Can you elaborate on "make use of standard COPA functionality"?

      Is this a TCODE, Fiori app or a standard report somewhere?

      Regards,

      Shyam

  • May 29 at 12:36 PM

    Hello Shyam,

    You can have a look at the below link.

    https://blogs.sap.com/2018/01/16/sap-co-pa-profitability-analysis/ This way the Profitability can be captured for the quantity level. This requires some efforts in terms of implementation.

    But you could see if DFKKOPK-MENGE and MEINS will suffice your requirement to get details of how many quantities/units sold. If CI is used, you can check DFKKINVDOC_I.

    Kindly check and comment.

    Br, Arun

    Add comment
    10|10000 characters needed characters exceeded

    • Just found out that I can't traverse from dfkkopk to acdoca using dfkkopk-opbel = acdoca-belnr . opbel is a string of length 12 but belnr in acdoca is a string of length 10. Plus acdoca has multiple ledger values (leading ledger , local ledger ) - how would i join?

      How do I get this document type in ?

  • Jun 07 at 04:42 AM

    Hello Shyam,

    Did it work? Kindly share your updates and if it worked "Mark the Question as Answered".

    Br, Arun

    Add comment
    10|10000 characters needed characters exceeded