Skip to Content
0
Former Member
Jan 06, 2012 at 02:24 PM

End Routine for transaction load

26 Views

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