Hi I have a transactional load for Billing data and am at present looking up data from Customer P table based on the Payer. I now need to pick up a set of additional attributes based on the Sold_To party.
Is there a way that I can write a combined SELECT rather than having two seperate selects?
At present I have:
select CUSTOMER OBJVERS ACCNT_GRP
from /BI0/PCUSTOMER into table T_PAYER
for all entries in RESULT_PACKAGE
where CUSTOMER eq RESULT_PACKAGE-PAYER and
OBJVERS = 'A'.
The new attributes would be where CUSTOMER eq RESULT_PACKAGE-SOLD_TO
Thanks