topic Re: Regarding Internal Table Manipulation in Application Development and Automation Discussions

Regarding Internal Table Manipulation

Former Member — Mon, 03 Apr 2006 12:55:09 GMT

Hi All,

1. While reading an internal table can't we check against 2 fields which are having Date & time.

The TD Part is as follows.

Read the internal table I_ZBE_RULES for the values of I_ZBE_RULES-LRNDT < I_EKBE_TAB-CPUDT and I_ZBE_RULES-LRNTM < I_EKBE_TAB-CPUTM

2. Also can anybody explain what TD i can write for following point that is in FD. What is the logic for below!

Read KONV table with the EKKI - KNUMV

Select records ONLY where KONV – KSCHL = ZBE_RULES - CR2. Read ZBE_Rules by Sr # = 02, FRICEID = ‘Zxxx’, CR2= ’select all CR2 (Values can be more than one record’ .)

If anybody knows the solution please give reply.

Your answer will be appreciated.

Thanks in advance.

Thanks & Regards,

Rayeez.

Re: Regarding Internal Table Manipulation

suresh_datti — Mon, 03 Apr 2006 12:58:21 GMT

Hi Shaik,

First off, you can use the READ statement only for equality & not > or <.

try the following..


 1.loop at I_ZBE_RULES where LRNDT < I_EKBE_TAB-CPUDT     and LRNTM < I_EKBE_TAB-CPUTM.
* do your processing
endloop.

Regards,

Suresh Datti

Re: Regarding Internal Table Manipulation

athavanraja — Mon, 03 Apr 2006 13:02:47 GMT

1. read table itab into itab_wa with key fielda = '123' fieldb = '345' .

(note there is no and)

Regards

Raja

Re: Regarding Internal Table Manipulation

Former Member — Mon, 03 Apr 2006 13:07:03 GMT

Hi,

loop at I_ZBE_RULES where LRNDT < I_EKBE_TAB-CPUDT and  LRNTM < I_EKBE_TAB-CPUTM.
"do all processing..
exit.
ENDLOOP.

Regards

vijay

Re: Regarding Internal Table Manipulation

Former Member — Mon, 03 Apr 2006 13:18:34 GMT

Hi,

Can anybody tell me the code for below FD part!

Thanks for prevoius replies.

Read KONV table with the EKKI - KNUMV

Select records ONLY where KONV – KSCHL = ZBE_RULES - CR2. Read ZBE_Rules by Sr # = 02, FRICEID = ‘Zxxx’, CR2= ’select all CR2 (Values can be more than one record’ .)

How we can write code for above statements.

Just tell me the code part.

Thanks & Regards,

Rayeez.

Re: Regarding Internal Table Manipulation

Former Member — Mon, 03 Apr 2006 13:24:31 GMT

Hi,

nead some clarification, it is some what confusing. can you make it clear. KNOV are you doing normal select, or internal table.

Regards

vijay

Re: Regarding Internal Table Manipulation

Former Member — Mon, 03 Apr 2006 13:30:38 GMT

Hi,

As per your reply i am posting entire step.

Actually KONV will also be filled in this into I_KONV.

Read EKPO where EKPO-EBELN & EKPO-EBELP like records from itab-EBELN & itab EBELP

Read EKKI – KNUMV to get the Doc condition # for the P.O/LI in itab

Append itab with the EKKI-KNUMV

Read KONV table with the EKKI - KNUMV

Select records ONLY where KONV – KSCHL = ZBE_RULES - CR2. Read ZBE_Rules by Sr # = 02, FRICEID = ‘Zxxx’, CR2= ’select all CR2 (Values can be more than one record’ .)

***Note KONV table also will have more than 1 record for one P.O/Line item.

Not all P.O/LI stored in itab after all the above reads may have records in KONV. Estimated 10% of the P.O will have Spl Cghs Cond Types.

Append itab with KONV– KWERT, KONV-LIFNR per each KONV-KSCHL (Due to one to many situation here replcate other data in itab)

I had posted entire step.

the itab here will be filled before this step from EKBE table.

Please try to solve my issue.

Thanks & Regards,

Rayeez.

Re: Regarding Internal Table Manipulation

Former Member — Mon, 03 Apr 2006 13:46:16 GMT

Hi,

READ table it_ekko with key eblen = itab-ebeln

ebelp = itab-ebelp.

if sy-subrc = 0.

read table it_ekki with key ebeln = it_ekko-ebeln

ebelp = it_ekko-ebelp.

if sy-subrc = 0.

itab-knumv = it_ekki-knumv.

modify itab exporting knumv. "not sure is this you want

loop at it_konv where knumv = it_ekki-knumv.

...

read ZBE_RULES table here...

endloop.

endif.

Regards

Vijay

Re: Regarding Internal Table Manipulation

Former Member — Mon, 03 Apr 2006 14:04:06 GMT

Hi,

There will be multiple records in itab.

IN that case will the below logic work!

Thanks & Regards,

Rayeez.

Re: Regarding Internal Table Manipulation

Former Member — Mon, 03 Apr 2006 14:10:28 GMT

Then in that case you need to use this logic inside loop of itab.

i.e

loop at itab.
"the above logic.

endloop.

Regards

vijay

Re: Regarding Internal Table Manipulation

Former Member — Mon, 03 Apr 2006 14:33:46 GMT

Hi,

For the above FD part i am posting TD part.

Please correct me if anything is wrong!

Process 3 – Fetch Special charges from Purchase orders

3.1a) - Check if P.O’s have Special charges

 For all records of internal table I_EKBE_TAB, Retrieve EBELN and EBELP from table EKPO for values of EKPO-EBELN = I_EKBE_TAB-EBELN and EKPO-EBELP = I_EKBE_TAB-EBELP and then store in internal table I_EKPO. If successful, perform below point

 For all records of internal table I_EKBE_TAB, Retrieve KNUMV from table EKKI for values of EKKI-EBELN = I_EKBE_TAB-EBELN and EKKI-EBELP = I_EKBE_TAB-EBELP and then store in internal table I_EKKI. Then Modify I_EKBE_TAB-KNUMV with I_EKKI-KNUMV based on EBELN,EBELP of I_EKKI.

 For all records of table I_EKKI, Retrieve KNUMV, KSCHL, LIFNR and KWERT from table KONV for values of KONV-KNUMV = I_EKKI-KNUMV and then store in internal table I_KONV.

 Retrieve FRICEID, SEQNUM, SEQITEMNUM, VAR, CR1, CR2, CR3, LRNDT, LRNTM from ZBE_RULES for values of SEQNUM = 02, FRICEID = ‘ZFFIE1908_INVOICE_PARK’ and then append into internal table I_ZBE_RULES.

 Then build a range for CR1 from internal table values I_ZBE_RULES.

 Then build a range for CR2 from internal table values I_ZBE_RULES.

 Then build a range for CR3 from internal table values I_ZBE_RULES.

 Looping at all the records in I_ZBE_RULES, read the internal table I_KONV for I_KONV-KSCHL equal to I_ZBE_RULES-CR2, If the condition satisfied then keep the record otherwise delete the entry from I_KONV.

 Then Modify I_EKBE_TAB-KSCHL, I_EKBE_TAB-LIFNR, I_EKBE_TAB-KWERT with I_KONV-KSCHL, I_KONV-LIFNR, I_KONV-KWERT based on KNUMV of I_KONV.

PLease sujjest if anything wrong in above!

Thanks & Regards,

Rayeez.

Re: Regarding Internal Table Manipulation

Former Member — Mon, 03 Apr 2006 14:39:24 GMT

Hi,

Also after that process in next 2 process i need to perform following FD.

Process 4 : Delete records from itab for all P.O’s for which no data from KONV was read.

Preocess 5 : Read EKBE-EBELN & EKBE-EBELP with itab-EBELN&EBELP Where the date & time stored from Process 1are less than EKBE – CPUDT - Accounting Document Entry Date, EKBE --CPUTM - Time of Entry and EKBE-MBLNR <> (NE) to ‘BLANK’

If records found, delete records from itab for all P.O’s where GR already posted to avoid duplicate postings. (partial GR might have received earlier and processed for Spl chg Invoice for full amount)

Can anybody say what can be the logic[TD] for above process(s).

Thanks & Regards,

Rayeez.