cancel
Showing results for 
Search instead for 
Did you mean: 

Get all Contract which are allready assiganed to a certain category

alexander_gahr
Explorer
0 Kudos

Dear SDN,

we are running on SRM 5.0 and we want to check when a shopping card is created if there is allready a contract assigned to this category.

Does anybody know an easy way without reading all the contracts in the system?

Best would be a function module where i can give the SRM category id and it returns the contracts which are allready assaigned to it.

Best regards

Accepted Solutions (0)

Answers (3)

Answers (3)

alexander_gahr
Explorer
0 Kudos

Thank you for your answers.

I can do BBP_PD_CTR_GETLIST which return the header of the contracts .

If i also need the ITEMS in a most perfomant way what shoud i do. I want to avoid calling BBP_PD_CTR_GETDETAIL in a loop.

Best regards

Edited by: Alexander Gahr on Oct 9, 2009 3:27 PM

former_member183819
Active Contributor
0 Kudos

BBP_PDIGP THIS TABLE HAs all contract entry for each item.

however you need to check only PO against contract.

from the contract releases you can easily findout what are PO s are released.

for eg. since contract assigned in source of supply PO will be created immediately

if the contract assigned via propose source of supply , you may not find a log in srm.

Am i correct.

so better find out Contract vs PO .

br

muthu

Former Member
0 Kudos

Hi Alexander,

I understand you want to find a list of contracts that are available for a particular product category when you create a SC.

BBP_PD_SOS_FIND is a FM which will find the possible sources of supply based on search criteria. It basically finds contracts, AVLs etc. but you can choose to find only contracts. It will provide you a list of all contracts available if you provide the category id in the search criteria.

Let me know if your query was different.

Regards

Saravanan.

Former Member
0 Kudos

FM BBP_PD_CTR_GETLIST, lots of selection parameters, probably what you are looking for.

former_member183819
Active Contributor
0 Kudos

Hi

contract can mix with material as well product category - value contracts.

one think you can do.

crmd_orderadm_i TABLE

item_type = COCO

MEAND PRODUCT CATEGORY CONTRACT.

BUSINES OBJECT = BUS2000136

so you can pull all contratcs releted product category contract.

BR

MUTHU

Former Member
0 Kudos

Hi Alexander,

to clarify: do you want to inform the user about available contracts and/or directly assign a category contract to the SC in case of a match of the category? You are talking indirect material, esp. free text reqs?

Cheers,

Claudia