******************Table name Required******************************

[Former Member]

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****************

[Former Member]

Check out VBAK table.

[Former Member]

I am just adding a point to Abinav's reply...

U can find the contrats in VBAK table, with VBTYP = 'G'.

Hope it helps.

[Former Member]

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

[Former Member]

Vijay,

is it the table name SMOVBAK? I dont think so.

let me know whats ur exact requirement.

[Former Member]

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

[Former Member]

sales order custom fields are not stored in one single database table,

they can be stored in different database tables, besed on the type.

[Former Member]

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

[Former Member]

pls check tables -

TVAK,

VBAK,

VBKD,

VBUK,

VBFA