Thanks everyone for the comments!
The code is in the start routine from 0BBP_CONF_TD_1 into 0BBP_CON.
-The select returns records when in debug
-I've tried running it open without the "for all entries" & it still fails in batch
-The select works during the delta but always fails on the initial load
The select is a join:
DATA: BEGIN of t_JOIN1 OCCURS 0,
CONNUM LIKE /BI0/ABBP_CON00-BBP_CON_ID,
CONITEM LIKE /BI0/ABBP_CON00-BBP_COITEM,
PONUM LIKE /BI0/ABBP_PO00-BBP_PO_ID,
POITEM LIKE /BI0/ABBP_PO00-BBP_POITEM,
ACGUID LIKE /BI0/ABBP_PO00-BBP_ACGUID,
SCNUM LIKE /BI0/ABBP_SC00-BBP_SC_ID,
SCITEM LIKE /BI0/ABBP_SC00-BBP_SCITEM,
REQSTR LIKE /BI0/ABBP_SC00-BBP_REQSTR.
DATA: END of t_JOIN1.
SELECT a~BBP_CON_ID
a~BBP_COITEM
a~BBP_PO_ID
a~BBP_POITEM
b~BBP_ACGUID
c~BBP_SC_ID
c~BBP_SCITEM
c~BBP_REQSTR
INTO TABLE t_JOIN1
FROM /BI0/ABBP_CON00 as a
INNER JOIN /BI0/ABBP_PO00 as b
ON aBBP_PO_ID = bBBP_PO_ID AND
aBBP_POITEM = bBBP_POITEM
INNER JOIN /BI0/ABBP_SC00 as c
ON bBBP_SC_ID = cBBP_SC_ID
FOR ALL ENTRIES IN DATA_PACKAGE
WHERE a~BBP_CON_ID = DATA_PACKAGE-BBP_CON_ID AND
a~BBP_COITEM = DATA_PACKAGE-BBP_COITEM AND
a~BBP_COITEM <> 0 AND
b~BBP_ACGUID <> '0000' AND
c~BBP_SCITEM <> 0.
Bluesky
