How can I get all contracts/orders for a business agreement? (CRM)

[former_member641477]

Hi,

I've been searching for a long while now, but I can't seem to find any tables that could map the contracts created for a specific Business Agreement(BA) in CRM. I have the mapping between Business Partners(BP) and BA, in table CRMM_BUAG_L_FICA. And then with table CRMD_ORDER_INDEX I can map between the BP and the contracts/orders created. However the BP contains differente BAs, so I need to know for whom(BA) was a contract created.

To sum up in a purely technical way, I need to map entries in CRM_ORDERADM_H with entries in CRMM_BUAG. This is easily achievable in the Web UI(tcode WUI_SSO), if I open a Business Agreement there is a section that shows me all of the contracts for it.

[spencer_liang]

BA and contracts are linked by document flow. you may use crm_doc_flow_read_ow/ec to read the a contract's docflow among which you may find who is the BA.