Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Table relation for CDPOS with AUSP?

Former Member

‎2009 Dec 16 10:56 AM

0 Likes
1,531

Hi All,

I have CDPOS table entries for ABAUSP (i.e. AUSP table). Now i need to relate this CDPOS with AUSP.

For example, to relate CDPOS with ESTVH, i can use table relations CDPOS-OBJECTID = ESTRH-SUBID and get ESRTH-RECNROOT and ESTRH-RECNROOT = ESTVH-RECNROOT.


CDPOS              ESTRH                  ESTVH
OBJECTID------>SUBID                   
                          RECNROOT------->RECNROOT

Similarly, Please let me know the table relation for CDPOS with AUSP. Your help would be highly appreciated.

Thanks in advance,

Srilakshmi.

Edited by: Srilakshmi Moola Ram on Dec 16, 2009 11:57 AM

Hi All,

I have CDPOS table entries for ABAUSP (i.e. AUSP table). Now i need to relate this CDPOS with AUSP.

For example, to relate CDPOS with ESTVH, i can use table relations CDPOS-OBJECTID = ESTRH-SUBID and get ESRTH-RECNROOT and ESTRH-RECNROOT = ESTVH-RECNROOT.


CDPOS              ESTRH                  ESTVH
OBJECTID------>SUBID                   
                          RECNROOT------->RECNROOT

Similarly, Please let me know the table relation for CDPOS with AUSP. Your help would be highly appreciated.

Thanks in advance,

Srilakshmi.

Edited by: Srilakshmi Moola Ram on Dec 16, 2009 11:57 AM

Reply
1 REPLY 1
Read only

prasenjit_sharma
Active Contributor

‎2009 Dec 16 10:56 PM

0 Likes
960

Hi,

To find a relation you first get the change number from CDHDR table. The object ID is your AUSP-OBJEK and

OBJECTCLAS = 'CLASSIFY'

Also use TABNAME = 'ABAUSP' in your query. hope this helps

Regards

Prasenjit