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.
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.