on 02-15-2010 6:00 PM
Hi All,
I have all data from EBAN Table (Purchase Requisition), now I want to get detail of objects that attached with the purchase requisition, hence need to get data from DRAD table (Document-Object Link). How can I link EBAN and DRAD?
Thaks in advance
Roy
Hi Do like this...
IF wa_eban IS NOT INITIAL.
CONCATENATE wa_eban-BANFN wa_eban-BNFPO INTO wa_doc.
SELECT doknr
dokvr
objky FROM drad INTO TABLE it_drad
WHERE objky = wa_doc
AND dokob EQ 'EBAN.
SORT it_drad BY dokvr DESCENDING.
READ TABLE it_drad INTO wa_drad INDEX 1.
IF wa_drad IS NOT INITIAL.
SELECT SINGLE doknr
dokvr
dktxt FROM drat INTO wa_drat
WHERE doknr = wa_drad-doknr
AND dokvr = wa_drad-dokvr.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi
check these fields in in table DRAD:
DRAD-DOKOB = 'EBAN'.
DRAD-OBJKY = purchase_req_no_and_postion. "example: 100000028000010
regards,darek.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.