Hi all
I am using a DSO 0FIGL_O02 taking data from the DataSource 0FI_GL_4 . I have a field 0Customer to the DSO & for that i´m taking data from the another DSO ZPCA_EC3 .
The folllowing is the Tranformation Routine i have tried
-
-
Routine 1,
Data : zcustomer type /BIC/AZPCA_EC300-CUSTOMER.
select single customer
from /BIC/AZPCA_EC300
into ZCUSTOMER
where AC_DOC_NO = SOURCE_FIELDS-BELNR.
RESULT = zcustomer.
-
-
Routine 2.
Data : zcustomer type /BIC/AZPCA_EC300-CUSTOMER.
select single customer
from /BIC/AZPCA_EC300
into ZCUSTOMER
where AC_DOC_NO = SOURCE_FIELDS-BELNR
and COMP_CODE = SOURCE_FIELDS-bukrs
and FISCYEAR = SOURCE_FIELDS-gjahr.
RESULT = zcustomer.
-
-
I dont get any errors for this Routine , But when i run the DTP it is going on Running & Running for hours, with no results , But again no errors also.
What could be the problem ?
Could anyone help me write a better routine .here is my requirement
I want to pick up 0Customer field data from ZPCA_EC3 based on 0AC_DOC_NO in both ZPCA_EC3 & 0FI_GL_4 DataSource.
Regards
Ramesh