on 02-28-2007 10:34 AM
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
Correction: Item Object Type is BUS2000135
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.