Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from CWK on Apr 17 at 8:22 AM Falchion86 -
Lou is correct. If you use SQVI to go directly after the change data in the CDHDR and CDPOS tables, then you'll need Object Class EINKBELEG (CDHDR-OBJECTCLAS and CDPOS-OBJECTCLAS) in your query. This is the object class for PO changes. You will get poor performance otherwise.
As another response noted, you need to join CDHDR and CDPOS using the change number of the document (CDHDR-CHANGENR and CDPOS-CHANGENR). Join on both OBJECTCLAS and CHANGENR.
We've tried SQL queries to analyze changes and found that custom reports are worth the effort if you repeatedly have a need to analyze changes across multiple documents.
If you go the custom report route, then the functions mentioned below are extremely useful. Take a look at the other functions in the same function group (SCD1), too.
Good luck,
Carl
| | | ---------------Original Message---------------
From: Louis Corato
Sent: Sunday, April 16, 2017 2:40 PM
Subject: SAP QUERY TABLE
You're going to need an object class, which for POs in EINKBELEG. Without that, it will run about a month.
If you want function modules, try CHANGEDOCUMENT_READ_HEADERS and
CHANGEDOCUMENT_READ_POSITIONS. If you're allowed code in SQVI, you can code the change functions into the process.
Lou |
| Reply to this email to post your response. __.____._ |   _.____.__ |
