01-02-2007 6:53 AM
Hi,
Can anyone tell the name of the database table which stores the custom dates in a sales contract.
I checked the table crmd_orderadm_h and crmd_orderadm_i but it does not contain the custom fields.
Regards,
Vijay
**************Replies to be surely rewarded****************
01-02-2007 6:56 AM
01-02-2007 7:26 AM
I am just adding a point to Abinav's reply...
U can find the contrats in VBAK table, with VBTYP = 'G'.
Hope it helps.
01-02-2007 8:16 AM
Hi Sujatha,
Thanks for your reply. but I find that there are no entries in the table SMOVBAK thought there are many sales orders in the system.
Kindly suggest how to proceed.
Thanks Once again for your reply!!!!
Regards,
Vijay
01-02-2007 8:21 AM
Vijay,
is it the table name SMOVBAK? I dont think so.
let me know whats ur exact requirement.
01-02-2007 8:49 AM
Hi Sujatha,
Thanks a lot for your reply. The table VBAK does not exist.So i checked using F4 help and I got a Table name similar to VBAK (i.eSMOVBAK).But I checked the Table . But there are no entries. I create a sales Order and there are about seventeen Custom Date fields . I want to know the database table in which these get updated.
I tried to find it out using the Function Module 'CRM_ORDER_READ" and searching for the database table which the Appointment structure(which gives us the dates when we give the sales order number as input for the Fumction Module) reads. But I could not find. Kindly suggest me the name of the database table which is upadted with the Custom fields of the Sales Order.
Thanks a lot once again for your reply!!!!
Regards,
Vijay
01-02-2007 9:26 AM
sales order custom fields are not stored in one single database table,
they can be stored in different database tables, besed on the type.
01-02-2007 10:07 AM
HI Vijay
I guess you are on CRM system.
Check if you have FM: <b>RS_PROGRAM_TABLES</b> in your system. If yes, execute this FM with the below values:
Object Type: 'TRAN'.
Object Name: 'VA01'. <--- The transaction you use to create Sales Order.
<b>OR</b>
CALL FUNCTION 'RS_PROGRAM_TABLES'
EXPORTING
OBJECT_TYPE = 'FUNC'
OBJECT_NAME = 'CRM_ORDER_READ'.
Hope this helps.
Kind Regards
Eswar
01-02-2007 8:26 AM