- Article Type: General
- Product: Aleph
- Product Version: 18.01
If a record DOES NOT have an ADM linked to it, then does this positively mean that an order record is not attached?
Though a z68 record could theoretically exist without an ADM record, that would be an error and such a record would not be usable.
You can do this to see if such cases exist:
SQL-abc50> select substr (z68_rec_key,1,9) from z68 minus select z00_doc_number from z00;
If the ADM record exists but is deleted ("DEL Y" field), the record will not be found by the preceding SQL. The following SQL will find it:
SQL-abc50> select to_number(substr(z68_rec_key,1,9)) from z68 minus select Z103_LKR_DOC_NUMBER from z103 where Z103_LKR_LIBRARY='ABC50';
And the following SQL can be done to locate Z601 records whose ADM doc record does not exist or is deleted:
SQL-abc50> select /*+ DYNAMIC_SAMPLING(2) ALL_ROWS */ substr(Z601_REC_KEY_3,1,9) from z601 where substr(Z601_REC_KEY_3,1,9) ^= '000000000' minus select substr (z103_rec_key,6,9) from z103 where Z103_LKR_LIBRARY='ABC50';
Note: As described in KB 8192-3738, this condition can cause z13 errors in running p_acq_06.
order, adm, faq
- Article last edited: 10/8/2013