
Go to tcode “SQVI” Quick Viewer.
Give your query a name and press “Create” button.
Enter a "Title", select "Table Join" from the dropdown, and then press the green checkmark.
When it goes to the next screen, press the "Insert Table" button.
Enter table "CDHDR" first and press the green checkmark.
Table will appear on the screen. Now repeat and insert for table "CDPOS". It will automatically link to CDHDR.
Now press the green arrow on the top tool bar of SAP window to go back. You will see your tables in the left pane under "Table Join" folder.
Expand down the tables and select these fields. (Start with minimum fields to get results)
A check in the "List" column comes out in the report. A check in the "Selection" column is where you enter criteria and also comes out in the report. Now press the "Execute" button.
You will be at the selection screen now. Enter the table name and field name from the material master. Enter a date range and enter your material number in the Object Value field. DO NOT RUN THIS WIDE OPEN.
I suggest creating a variant to load each time, so you don’t forget. Then change up table/field names, material number, etc.
Now press the "Execute" button. You will see your results of the query with the change value(s) for your material. (This is for a Total Shelf Life change that was made.)
Results without a date:
Just use caution to not run wide open. I hope this helps and turns up in google searches since I spent too much time looking for answers myself.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |