cancel
Showing results for 
Search instead for 
Did you mean: 

Need info regarding Contracts

former_member184390
Participant
0 Kudos

Hi All,

Please provide me information regarding the standard database tables that store the details of contracts at Header level and Item level created using the transaction crmd_order.

All helpful answers will be rewarded.

Regards,

Udaya

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Correction: Item Object Type is BUS2000135

Answers (1)

Answers (1)

Former Member
0 Kudos

Udaya,

Try the database trace under Performance Analysis (TCode ST05) and execute the desired processing in a second session under your user name.

You can deactivate the trace and review it for the details.

Here's what we find:

Contracts created as sales transactions are stored as follows -

Header: CRMD_ORDERADM_H

The fields OBJECT_TYPE and PROCESS_TYPE can differentiate Contracts from other activities. Standard Sales Contracts have OBJECT_TYPE = BUS2000121.

Item: CRMD_ORDERADM_I

The item level table holds the item details and is referenced using the header GUID in the Header table.

OBJECT_TYPE of standard Sales Contract items is = BUS2000136.

From the Item you can get your PRODUCT field (guid) for using in product and pricing details etc. under the subsequent pricing, product and activity details.

Brad