Skip to Content

Material Listing and Exclusion using SQLScript on SAP S/4HANA

Hello experts,

I would like to know if you had ever built a solution for checking material listing and exclusion for a specific customer and sales document type using SQL on SAP S/4HANA systems?

I know that VBAP_MATNR_LIST_EXCL perform checks in ABAP using FM PRODUCT_LIST_EXCLUSION


But instead of execution FM for each material I'ld like to check this for multiple materials on database level

Thanks for your comments

Add comment
10|10000 characters needed characters exceeded

  • Hello Jyoti,

    On ABAP side, I see that I can use function module PRODUCT_LIST_EXCLUSION, is it correct? Is there an other way for getting listing/exclusion information?

    What I actually want to do is fetching this data for a customer and product data in a CDS view, by running a SELECT statement on HANA database. Is it possible? If so how?

    Thank you,

    Best Regards,

    Eralper

  • Can you check Table KOTG001, where KAPPL = V?

    Thanks,
    JP

  • Thank you for KOTG001.

    But I'm not sure that this is enough. Should I check somehow customizing tables and identify any other KOTG* tables are used or not?

    I ask because KOTG001 stores only Customer-Material access. If customizers define other accesses including other fields, then I should check other KOTG* tables, should not I?

    Also I read the excluding or listing condition type dynamically, but how can I related these with sales document type, or customer, etc?

  • Get RSS Feed

0 Answers