Field name for Bill to party

[Former Member]

Hi friends,

can any body tell me the field name for bill to party in CRM.When i go to t-code CRMD_ORDER and when click F1 on field bill to party it is giveing field name as PARTNER_NUMBER and structure name as COM_DYNP_PARTNER_UI.

i want to know exactly the field PARTNER_NUMBER in which table..

or i want the tables that are storing bill to party info.

i am sure of reward points

thanks in advace.

[Former Member]

Hi,

when u go CRMD_ORDER.

1) go to Tab Partners

2) in the Function Column --- select bill to party from the dropdown

3) in partner column -

---

select ur partner u want has bill to party.

if u want to find out the bill to party partner for ur contract use function crm_order_read.

go to et_partner tab.

select partner number or guid based on ur requirement.

but the partner function should be 00000003.

Imp u can select more than one partner function in the partner tab.

like ship to party, Bill to party, employee responsible eetc innthe same tab.

Regards.

[Former Member]

Hi Friends,

Thank You all.I have given the reward points.

I have one more strange requirement.

we have standard FM in CRM:CRM_ISA_SHIPTO_ADD_TO_BASKET.

This FM is for Internet sales.

using this FM it will take the ship to addresses from front end(from portal) and save to the basket.The same functionality is not available for Bill to.So we have to create FM for Bill to in the same way as ship to.SAP not provided this for BIll to.

Can any body give me some valuable suggessions for this?

Thanks in Advance.

[former_member927251]

Hi Jak,

Alternatively, without bothering about the table that stores the business partner for bill to party what you can do is call CRM_ORDER_READ function module by providing the Header GUID of the sales transaction to get the <b>et_partner</b> table which contains all the partners for the transaction with all the partner functions i.e. sold to party, bill to party etc.

Note : You can get the Header GUID for the transaction number from the table CRMD_ORDERADM_H.

You can read this table with partner_fct = '00000003' to get the Bill To Party for the transaction.

For testing purpose you can use the report CRM_ORDER_READ. Just enter the Transaction Number in the Object_Id field and check out the et_partner table.

<b>Reward points if it helps.</b>

Regards,

Amit Mishra

[KaushalShah]

For a particular sales order, bill-to-party info will be stored in table CRMD_PARTNER.

crmd_orderadm_h - guid = crmd_link = ghid_hi

get entry from crmd_link where objtype_set = 07

pick up ghid_set

pass this ghid_set as guid in crmd_partner

this should give you all partners.

Pick up bill-to-party where partner_fct = 00000003.

Hope this helps.

Regards,

Kaushal

[Former Member]

Hi Jak,

After passing CRMD_LINK-GUID_SET as GUID to table CRMD_PARTNER for CRMD_PARTNER-PARTNER_FCT = 00000003, pick up CRMD_PARTNER-PARTNER_NO and pass it on to BUT000 as BUT000-PARTNER_GUID and get the BP Number. Hope this helps.

Thanks.