Sef
VIP Member
This issue is driving me insane and I wonder if I am missing something or if this is an undocumented (or poorly documented) feature.
I am writing a UBE with a BSVW on a custom table and a custom UDC. The join is NOT defined via KY (because of the issue of spaces in front of these values in UDC table F0005). Instead the UBE contains a section where the trimmed KY field is copied into the program ID. The custom table is joined to this PID field in the BSVW.
Using this BSVW in the UBE is successfull and all records are retrieved correctly. The reason for the join is that I wish to sequence the report by the special handling code of the UDC. However which ever way I try, the sequencing is fully ignored!?!?. I have tried to use other sequences (eg TDAY). I have also tried to make F0005 the primary table, but all to no avail.
Is there a restriction I am not aware of. Eg that you can't sequence by an element of a control table?
Is this a tools bug?
Has anybody else seen this issue?
Any help in this area is greatly appriciated.
System specs: ERP8.0 Update 1, SP 23 on NT/Sequel
I am writing a UBE with a BSVW on a custom table and a custom UDC. The join is NOT defined via KY (because of the issue of spaces in front of these values in UDC table F0005). Instead the UBE contains a section where the trimmed KY field is copied into the program ID. The custom table is joined to this PID field in the BSVW.
Using this BSVW in the UBE is successfull and all records are retrieved correctly. The reason for the join is that I wish to sequence the report by the special handling code of the UDC. However which ever way I try, the sequencing is fully ignored!?!?. I have tried to use other sequences (eg TDAY). I have also tried to make F0005 the primary table, but all to no avail.
Is there a restriction I am not aware of. Eg that you can't sequence by an element of a control table?
Is this a tools bug?
Has anybody else seen this issue?
Any help in this area is greatly appriciated.
System specs: ERP8.0 Update 1, SP 23 on NT/Sequel