Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

CDHDR and CDPOS tables

Former Member
0 Kudos

Hi Guru's,

I have a requirement where in, when a change in assignment of a Ship-to and Sold-to happens, i need to generate a report. Table KNVP gives the relation between Sold-to's and Ship-to's.

I was checking the entries made in CDHDR and CDPOS. When an assigned Ship-to is deleted from the partner functions tab, the CDPOS table contain records with Change ID 'E' (delete) and table KNVP is listed along with the value that was deleted. (In my case, the partner number was listed in Old Value).

But when i check CDPOS, when a new Ship-to is added to a Sold-to in partner functions tab, only one entry is created in CDPOS indicating an 'Insert' of record, but does not specify the value that was added. The Old Value and New Value fields remain blank.

Is there any configuration setting to update the Insert records as well? Am I missing something here. Any help will be greatly appreciated.

Thanks,

Kumar.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Kumar,

I don't know the answer to your specific question, but you can obtain the values from KNVP table using the key you find in CDPOS table.

Define a structure just like the primary key of the KNVP table and copy the value from CDPOS-TABKEY field into the structure and then you can use the key to query KNVP table and find the values you are looking for.

1 REPLY 1

Former Member
0 Kudos

Kumar,

I don't know the answer to your specific question, but you can obtain the values from KNVP table using the key you find in CDPOS table.

Define a structure just like the primary key of the KNVP table and copy the value from CDPOS-TABKEY field into the structure and then you can use the key to query KNVP table and find the values you are looking for.