Skip to Content

How do I get custom fields in standard reports?

Hello experts,

We have a few custom fields which we have brought into some standard transactions, for instance, the billing document item. One of the most useful billing reports is the 'Manage Customer Line Items' app. However, we are unable, at this time, to extend this field from the 'Custom Logic and Fields' app to the 'Manage Customer Line Items' report. Why is that? Is there a step we're missing? Is the only option to see these fields in reporting to create new custom reports?

Thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

9 Answers

  • Best Answer
    Posted on Oct 16, 2019 at 02:46 AM

    Hello Rahul Shah

    Here is my suggestion: You could create your custom field relevant to your business context and associate with the underlining CDS view for the corresponding App to build your custom Report. here is an example: I used business context: Custom Core view to create my Custom Field- 'Test Data1' and then I use the underlining CDS view for 'Manage Customer Line Items' which is I_OperationalAcctgDocCube. Now, since my custom Field 'TestData1' will be available in Business Partner and Customer reports( that I had enabled while building the custom Field) I will associate this with I_OperationalAcctgDocCube and make a custom CDS view report to match my requirement. Make sure you have the custom field populated on the respective customer App and have some value populated, that way the same values reflect in your custom report.

    Here is a snippet attached. Good Luck!


    60055-Testing.docx (561.1 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 01, 2019 at 12:08 PM

    Hi Rahul,

    Experts have already provided the answer, I would like to add a link to the blog that might be helpful

    https://blogs.sap.com/2019/08/28/output-management-customize-content-form-with-additional-fields/

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 15, 2019 at 10:17 AM

    Hi Rahul Shah ,

    Thank you for reaching out to the community.

    What business scenario/context have you created your custom field in? Under the UI/Forms tab of the app 'custom fields and logic', to which views has the custom field been extended? The answers to these questions would first help in determining to which CDS views and applications the custom field has been enabled for.

    Accordingly, the data source extension scenario you are referring to 'manage customer line items' relies on the FAR_CUSTOMER_LINE_ITEMS0001 (restricted view) which is probably why your custom field does not appear as available.

    That said, to your point, creating a custom report may be the way forward. I would suggest you leverage the released data sources for custom analytical scenarios in the app "custom analytical queries." In the absence of your reporting requirements, I cannot make further comments on the specific data source to be used.

    Hope this helps,

    Thank you,

    Feras

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 11, 2019 at 11:52 AM

    Just to update you on where we landed, it looks like if we copy the custom field data from the billing document to the JE, we can get it in the JE. Either in the Display Line Items at General Ledger Report or the Journal Entry Analyzer. Not ideal, but got us most of the way there.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 14, 2019 at 02:15 AM

    When creating custom fields a list of available UIs and reports to which the custom field could be extended to is listed in the 'custom fields and logic' app. Simply activate the custom field to the available view that would fulfill your requirement.

    Please see the following documentation on [Custom Fields and Logic](https://help.sap.com/viewer/f544846954f24b9183eddadcc41bdc3b/1905.500/en-US/57909455bf7c4fdd8bcf48d76c1eae33.html?q=custom%20fields%20and%20logic)

    In addition, please have a look into this [thread] (https://answers.sap.com/questions/13242103/view.html

    ) on the community.

    I hope this answered your question! If it did, please mark it as the 'Best Answer' so I can continue learning and answering questions in the community.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 14, 2019 at 02:15 AM

    Here are some SAP resources you may review based on your topic "extend | custom fields | manage customer line items | item | billing document | billing | transactions | app"

    Best Practices for SAP S/4HANA Cloud

    Support Services ... It provides ledger-specific transactions and reports for IFRS. .... SAP Fiori Analytical Apps for Asset Accounting in Finance - This scope item .... for resolving customer invoice disputes and managing overdue receivables. ...... create custom fields and tables, create and extend analytical reports and forms,?...

    https://support.sap.com/en/product/best-practices-s4hana-cloud.html

    Fiori Apps Library

    Analytical List Page for Technical Object Breakdown Analysis. Approve ... Classify Products - Commodity Codes. Closing ... Manage Billing Document Requests.

    https://fioriappslibrary.hana.ondemand.com/sap/fix/externalViewer/#/home

    Manage Journal Entries

    You use this app to analyze your journal entries and create reversals in order to make adjustments. Filtering and ... Display journal entries and their line items.

    https://fioriappslibrary.hana.ondemand.com/sap/fix/externalViewer/#/detail/Apps%28'F0717'%29/S11OP

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 11, 2019 at 11:46 AM

    Hi Amir,

    Thank you so much for the response and apologies for my delay. My client really didn't want to do development to create a custom report.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 08, 2020 at 06:28 AM

    Hi Amith,

    i have done the extension to the manage customer line item app to add custom fields. i did extension for cds, in dpc_Ext - added code to update custom data to the et_entityset. fiori extension for the view where i added 3 columns, the data all come in good place.

    challenge is sort, order is failing for the custom fields.

    smart filter - supplier, company code, etc giving error - resource not found for segment. i added annotation file, but failed to load and value help failing to load.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 21, 2020 at 11:28 AM

    thanks Amith Nair do you know what's the equivalent field I_OperationalAcctgDocCube to the GL line item type?


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.