topic Re: Table name Required************ in Application Development and Automation Discussions

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

Former Member — Tue, 02 Jan 2007 06:53:14 GMT

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

Re: Table name Required************

Former Member — Tue, 02 Jan 2007 06:56:20 GMT

Check out VBAK table.

Re: Table name Required************

Former Member — Tue, 02 Jan 2007 07:26:55 GMT

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

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

Hope it helps.

Re: Table name Required************

Former Member — Tue, 02 Jan 2007 08:16:09 GMT

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

Re: Table name Required************

Former Member — Tue, 02 Jan 2007 08:21:25 GMT

Vijay,

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

let me know whats ur exact requirement.

Re: Table name Required************

Former Member — Tue, 02 Jan 2007 08:26:59 GMT

pls check tables -

TVAK,

VBAK,

VBKD,

VBUK,

VBFA

Re: Table name Required************

Former Member — Tue, 02 Jan 2007 08:49:58 GMT

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

Re: Table name Required************

Former Member — Tue, 02 Jan 2007 09:26:10 GMT

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

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

Re: Table name Required************

Former Member — Tue, 02 Jan 2007 10:07:38 GMT

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.

CALL FUNCTION 'RS_PROGRAM_TABLES'
  EXPORTING
    OBJECT_TYPE            = 'FUNC'
    OBJECT_NAME            = 'CRM_ORDER_READ'.

Hope this helps.

Kind Regards

Eswar

topic Re: ******************Table name Required****************************** in Application Development and Automation Discussions

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

Re: ******************Table name Required******************************

Re: ******************Table name Required******************************

Re: ******************Table name Required******************************

Re: ******************Table name Required******************************

Re: ******************Table name Required******************************

Re: ******************Table name Required******************************

Re: ******************Table name Required******************************

Re: ******************Table name Required******************************

topic Re: Table name Required************ in Application Development and Automation Discussions

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

Re: Table name Required************

Re: Table name Required************

Re: Table name Required************

Re: Table name Required************

Re: Table name Required************

Re: Table name Required************

Re: Table name Required************

Re: Table name Required************