Skip to Content
0
Former Member
Sep 13, 2007 at 02:28 PM

Problem with Transformation Routine

22 Views

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