-
Products and Technology
By Category
-
Groups
Activity Groups
Industry Groups
Influence and Feedback Groups
Interest Groups
Location Groups
Customer Only Groups
- Developers
- Partners
- Events
- Help Center
- Topic Pages
-
Explore SAP
Products
Learning and Support
-
- Products and Technology
- Groups
- Developers
- Partners
- Events
- Help Center
- Topic Pages
-
Explore SAP
- Explore SAP
-
Products
- Products
- SAP Business Suite
- Artificial Intelligence
- Business applications
- Data and analytics
- Technology Platform
- Financial Management
- Spend Management
- Supply Chain Management
- Human Capital Management
- Customer Experience
- SAP Business Network
- View products A-Z
- View industries
- Try SAP
- Partners
- Services
- Learning and Support
- About
- SAP Community
- Groups
- Interest Groups
- Application Development and Automation
- Discussions
- subtract two internal tables
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
subtract two internal tables
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2006 Jul 03 11:17 AM
- SAP Managed Tags
- ABAP Development
Hi All!
I have two int tables as below with the same columns and field names and values below..
Item quan
mfg03 50
mfg04 100
mfg05 20.
second IT have the same item numbers but different values.Now my requirement is to <u><b>SUBTRACT</b></u> the quantities into 3rd IT item wise.Please advise.
Regards
Pavan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2006 Jul 03 11:26 AM
- SAP Managed Tags
- ABAP Development
Hi Kumar,
Take third interna table and do as follows.
<b>1)If you sure that you dont have more than one entry for each material in ITAB2 then do as follows.</b>
DATA ITAB3 TYPE ITAB OCCURS 0 WITH HEAEERLINE.
loop at itab1.
read table itab2 with key item = itab1-item.
wa_itab3-quan = itab1-quan - itab2-quan.
wa_itab3-item = itab1-item.
append wa_itab3 to itab3
endloop.
<b>2)If you more than one entry for each material in ITAB2 then do as follows.</b>
loop at itab1.
loop at itab2 where item = itab1-item.
wa_itab3-quan = itab1-quan - itab2-quan.
wa_itab3-item = itab1-item.
endloop.
append wa_itab3 to itab3
endloop.
Thanks,
Vinay
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2006 Jul 03 11:20 AM
- SAP Managed Tags
- ABAP Development
Loop at itab1.
Read table itab2 with key item = itab1-item.
If sy-subrc eq 0.
itab1-qty = itab1-qty - itab2-qty.
Modify itab1.
Endif.
Endloop.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2006 Jul 03 11:21 AM
- SAP Managed Tags
- ABAP Development
loop at itab1.
read table itab2 with key item = itab-item.
wa_itab3-quan = itab1-quan - itab2-quan.
wa_itab3-item = itab1-item.
append wa_itab3 to itab3
endloop.
Regards,
Ravi
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2006 Jul 03 11:21 AM
- SAP Managed Tags
- ABAP Development
loop at itab1 into wa_itab1
read table itab2 into wa_itab2 with key item = wa_itabl-item.
wa_itab3-item = wa_itab1-item.
wa_itab3-quan = wa_itab1-quan - wa_itab2-quan.
append wa_itab3 to itab3.
clear wa_itab3.
endloop.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2006 Jul 03 11:24 AM
- SAP Managed Tags
- ABAP Development
Hi,
sort itab2 by item.
loop at itab1 into wa_itab1
read table itab2
into wa_itab2
with key item = wa_itab1-item
binary search.
wa_itab3-item = wa_itab1-item.
wa_itab3-quan = wa_itab1-quan - wa_itab2-quan.
append wa_itab3 to itab3.
clear wa_itab3.
endloop.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2006 Jul 03 11:26 AM
- SAP Managed Tags
- ABAP Development
Hi Kumar,
Take third interna table and do as follows.
<b>1)If you sure that you dont have more than one entry for each material in ITAB2 then do as follows.</b>
DATA ITAB3 TYPE ITAB OCCURS 0 WITH HEAEERLINE.
loop at itab1.
read table itab2 with key item = itab1-item.
wa_itab3-quan = itab1-quan - itab2-quan.
wa_itab3-item = itab1-item.
append wa_itab3 to itab3
endloop.
<b>2)If you more than one entry for each material in ITAB2 then do as follows.</b>
loop at itab1.
loop at itab2 where item = itab1-item.
wa_itab3-quan = itab1-quan - itab2-quan.
wa_itab3-item = itab1-item.
endloop.
append wa_itab3 to itab3
endloop.
Thanks,
Vinay
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2006 Jul 03 11:49 AM
- SAP Managed Tags
- ABAP Development
Hi,
You can subtract the field which you don't want like this here itab2 is that internal table where you move data form itab1 and sort itab2 by key and if there is any duplicate entry is there use delete adjacent.
LOOP AT itab1.
MOVE-CORRESPONDING itab1 TO itab2.
APPEND itab2.
Endloop .
SORT itab2 BY key.
DELETE ADJACENT DUPLICATES FROM itab2.
Bluesky