Enhancment to Sales Document line item data source (2LIS_11_VAITM)

[Former Member]

HI EXPERTS

As per my requirement i need to enhance the content data source (2LIS_11_VAITM) EXTRACT structure to inculde a field from change log tables (CDHDR)

Is there any date field avaliable in the datasource based on which i can make my search..as i had to do a re initilization...as to populate the ZZ field with the historical changes as well

Thanks

[Former Member · Accepted solution]

Hi,

Please specify your requirement clearly.

What do you mean by Search based on date filed?

Regards,

Ramesh

[Former Member · Accepted solution]

Hi

My requirement is to get Changer id from CDHRD for 2LIS_11_VAITM

But i need a date field to look CDHDR for historical data

Thanks

[Former Member · Accepted solution]

Hi,

For the SD module, the CDHDR table have the UDAT which is changed date for the sales document. Please verify before doing so.

AEDAT from the data source is last changed date.

ERDAT is created on date

Regards,

Ramesh

Edited by: ramesh kumar on Dec 1, 2009 8:36 AM

[Former Member · Accepted solution]

Thanks for the update

For a change at the line item level can i compare AEDAT IN DATASOURCE with UDAT in CDHDR

[Former Member · Accepted solution]

Hi,

CDPOS is the line item data.

Please take an example document and chk the base tables and the change log tables.

Ramesh

[Former Member · Accepted solution]

Hi,

I think for this requirement first you may need to compare the item details with CDPOS table to get the OBJECTID information. By using CDPOS-OBJECTID you will get the UDATE from CDHDR(CDHDR-OBJECTID = CDPOS-OBJECTID) .But in the first select statement try to restrict with all the key fields,because it may affect the performance of the extractor.

Thanks.

[Former Member]

Hi,

Yes you can search by follow bellow steps:

1. Goto RSOSFILEDMAP.

2. Give the Field name(CDHDR) and Click on Execute.

3. It will Display the relavent Datasource.

4. Find the Datasouce.

5. Goto RSA6.

6. Select your Datasouce--> Click on Display .

then you can find the table name.

Regards,

Suman.