question on CDPOS table

[Former Member]

Hello,

I have a question on some data that is in the CDPOS table. If the chngind field = I, there is a table name and no data in the value_new or value_old fields. does this mean that for the objectid, there was no data in the table and the user added data to the table? example objectid = vendor number. I have a record with a chngind = I and the table is LFBW. Does this that there was no data for the vendor in the atble LFBW and the user added data to this table? on the header record (CDHDR), the chng_ind is = to U.

thanks in advance for te help

[Former Member]

Hi,

If the indicator is 'I', it means the record is created...for that record the old_value and new_value will not be updated..

I believe only if the indicator is 'U', the old_value and the new_value will be updated...

Thanks,

Naren

[Former Member]

thanks for the info.

in the vendor example that I gave, if the change indc on the cdhdr record is a U and the change indc on the cdpos is a I, does this mean that the record was updated and the data for the table LFBW was inserted?

[Former Member]

Hi,

the Change Indicator (chngind) "I" for CDPOS means that there is a new record in the table. As there were no changes in data of that specific row of table, the data are "original" until there is a change record CDPOS with Change indicator "U" (or better not "I").

By this meaning, values in the fields value_* are not necessary because there are no changes in this row of table LFBW.

In spite, the whole table LFBW has now a new row; therefore, there is an Change Indicator "U" in CDHDR for whole table.

Hope that helps you,

regards Christian

[Former Member]

Christian,

this clears it all up.

thanks for the quick reply

[Former Member]

Hi,

Yes..You are correct..The header is changed which means the indicator will be U..But actually there new lines added for the table LFBW..Then the indicator will be I.

Example.

-

---

If a sales order is created with line item 1..Then the quantity is changed for that line item..Then the indicator will be U in the table CDHDR and CDPOS..

Then if you try to add a new line item to the sales order...The table cdhdr will still have the indicator as U..But since there is a new line item added..For that record the indicator will be I..

Hope this is clear..

Thanks,

Naren