on 09-16-2017 5:48 AM
Dear All,
I have requirement of Quality info records change history in respect to creation date, Release date,quantity,Block reason.The standard report QI06 serves the purpose but not completely as per my requirement Because my requirement is to fetch the data for change records of QM- Info as per first release until date & changes in that if any on later stage,I am unable to find link of the change number with reference to vendor in CDHDR & CDPOS table.
Regards
Rakesh Sehgal
I'm not sure what you are using to search on. You have to build the key to do the search in CDHDR.
The easiest way to find this stuff is first, make a change to a Q-info record. (in a development box of course).
Go to SE16 and enter in CDHDR. Make selection on current date, execute. You should have limited records, sort in descending order by change time. The most recent ones are at top. Find the one related to your object. Shouldn't be that hard. Object = QINF for Q-info records.
Use the Object value key and document number then to link to records in CDPOS.
I suspect you'll be selecting records from CDHDR based on a date range and an object of QINF. Then getting all matching CHPOS records. Then doing whatever your development is to do.
Should be pretty straight forward.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.