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

[eralper_yilmaz]

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

[jpfriends079]

Hello ERALPER,

I assuming that you know how material listing and exclusions actually works. Means standard functionally/feature in SAP ECC.

It is unclear from your post, whether you want to enhance the existing functionality or you want to develop a report?

Thanks,
JP

[eralper_yilmaz]

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

[jpfriends079]

Can you check Table KOTG001, where KAPPL = V?

Thanks,
JP

[eralper_yilmaz]

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?