For more information, please refer to this announcement explaining best practices for getting answers to questions.
what is the table name to link agreements and agreement lines assigned in the catalog
Summary:
1) Report 1:- Display the agreement (assigned to the catalog), Excluded Line number (line number of the agreement which is not a part of the catalog. Get this by matching the agreement line category with the category mentioned in the catalog. If there is no match then return that row), Item name, Supplier Name, Category in Agreement line, Catalog Name, Catalog Type, Categories which are part of the catalog (display all the categories separated by comma)
2) Report 2 - Items present in BPA which does not have any image, Categories present in BPA line which does not have any image, BPA lines which have description as deleted/cancelled (BPA No, BPA line no, BPA line Item, BPA Item description, BPA Category). Display the lines if either of the three conditions are met:-