Field Level Routine

1744 Views

Hi Experts,

I am trying to bring fields from 1 dso into another dso in transformation 7.0. Appending is my scenario

DSO A - /BIC/AZFC_DS0500

DSO B - /BIC/AZCS_DNGD00 - /BIC/ZZAMT , /BIC/ZG_DATE

DSO C - /BIC/AZFC_DS1000

I have created C over A and have to bring above stated fields from B into C with all records to apply below stated logic

Amount Paid (Invoice):

For CD:- Consider amount (ZCSTR_DEMANDNOTE-DOC_AMT) where all documents in table ZCSTR_DEMANDNOTE is having Main Transaction (DFKKOP-HVORG): ZBILL and Sub Transaction (DFKKOP – TVORG) = 0021 and posting date is greater than and equal to ZCSTR_DEMANDNOTE -G_Date having Clearing Status (DFKKOP- AUGST) = 9 and Clearing reason (DFKKOP- AUGRD) <> 5 and 6

I have declared start routine code as:

*$*$ begin of global - insert your declaration only below this line *-*

data : /BIC/AZCS_DNGD00,/BIC/AZFC_DS1000.

TYPES: BEGIN OF ts_dso2,

/BIC/ZZAMT TYPE /BIC/OIZZAMT,

/BIC/ZG_DATE TYPE /BIC/OIZG_DATE,

END OF ts_dso2.

DATA: it_dso2 TYPE STANDARD TABLE OF ts_dso2,

Wa_dso2 type ts_dso2.

*$*$ begin of routine - insert your code only below this line

IF SOURCE_PACKAGE[] IS NOT INITIAL.

SELECT /BIC/ZZAMT /BIC/ZG_DATE

FROM /BIC/AZCS_DNGD00 INTO TABLE it_dso2

FOR ALL ENTRIES IN SOURCE_PACKAGE

WHERE /BIC/ZZDOC = SOURCE_PACKAGE-FC_OPBEL.

ENDIF.

When I execute the C, I see that the fields are added but no data has filled.

Do I have to write a routine at field level also? What m I missing here? Request you to provide the exact code if required.

Would appreciate if snapshots can be shared.

rgds

Imran