2lis_11_vahdr and extraction in PSA

[Former Member]

Hi experts,

I'm finding some problems in a delta extraction with 2lis_11_vahdr datasource ito PSA in BW 7.0

The delta extracted the same orders many times, although their fields never change.

There are many records deleting (with the ROCANCEL field set to 'X') and writing the same order with the same values.

Ex.

DP PART RECORD ROCANC VBELN BESTK SPSTG TRSTA UVALL UVALS

1 1 9.246 X 2008422760 B A C C

1 1 9.247 2008422760 B C A C C

1 1 9.248 X 2008422760 B C A C C

1 1 9.249 2008422760 B C A C C

1 1 9.252 X 2008422760 B C A C C

1 1 9.253 2008422760 B C A C C

1 1 9.254 X 2008422760 B C A C C

1 1 9.255 2008422760 B C A C C

1 1 9.256 X 2008422760 B C A C C

1 1 9.257 2008422760 B C A C C

1 1 9.258 X 2008422760 B C A C C

1 1 9.259 2008422760 B C A C C

1 1 9.260 X 2008422760 B C A C C

1 1 9.261 2008422760 B C A C C

1 1 9.262 X 2008422760 B C A C C

1 1 9.263 2008422760 B C A C C

1 1 9.264 X 2008422760 B C A C C

1 1 9.265 2008422760 B C A C C

The problem is that the PSA table contains may unuseful records, wasting disk space.

Any suggestions ?

thanks in advance,

Mirco

[former_member205352 · Accepted solution]

There might be so many changes happened in R3.

Check the table CDHDR and see how many changes were done.

"X" is before image and not delete.

Hope this helps.

[Former Member · Accepted solution]

Praveen,

thanks for your answer, I'm looking in table CDHDR.

My next question is: admitting that a modification has been done on that order, is it normal that the datasource extracts it also if none of its fields have been modified ?

thanks,

Mirco