Skip to Content

MATNR FIELD ADD IN 0FI_AR_04 DATASOURCE

Hi All,

I have created an Aging Report, and it works fine. Now client wants to view the outstanding report on behalf of

Materialwise Customers based on Balance. The issue i am facing is.. how to add MATNR in 0FI_AR_04 datasource as this has structure of DTFIAR_3 which contains the fields from BSID and BSAD(these tables don't have the matnr field)

please help me

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Nov 06, 2019 at 12:58 AM

    Hi, the simple answer is you can you can use SAP customer enhancements to write your custom logic where you can find the materials on the offsetting entries on the P+L accounts (query table BSEG with the key fields provided by BSID/BSAD, excluding line item number BUZEI).

    However, you may want to recheck your requirements as there's a good reason as to why the "Material" (MATNR field) is not included in customer line items (tables BSID and BSAD): in general terms, the Material is not always unique for each customer line item. Consider the case where a single customer invoice has two or more materials (should be quite common); this would would render a non-unique material number for the Customer line item (unless you have configured "Document Splitting" based on MATNR field in the New GL).

    Hope this helps

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 05, 2019 at 09:33 AM
    Add a comment
    10|10000 characters needed characters exceeded