Table fetch tips

-
1) How to get Vendor/Plant combination data?
Ans: Inner join between tables LFM1 and T024W


Comments

Post a Comment

Popular posts from this blog

EWM PPF Trigger the existing PPF Action through Custom Program

-
Aim: Same as title Description: An Action has been scheduled for the Handling Unit in the EWM Monitor and we need to execute it in a Custom Program without executing it from the Monitor. What to do? Use the below code accordingly. Code: *&---------------------------------------------------------------------* *& Report ZAG_TEST_HU_PRINTING *&---------------------------------------------------------------------* *& *&---------------------------------------------------------------------* REPORT zag_test_hu_printing. PARAMETERS: p_hu TYPE /scwm/huident DEFAULT '154118660000024802'. DATA: lt_huhdr     TYPE /scwm/tt_huhdr_int,       lt_protocol  TYPE bal_t_logh,       lt_contexts  TYPE ppftcntxts,       lo_hu_ppf    TYPE REF TO /scwm/cl_hu_ppf,       lo_manager   TYPE REF TO cl_manager_ppf,       lt_trigger   TYPE ppfttr...
Read more

ABAP 7.5 - FILTER Statement

-
There are two internal tables, say, itab1 and itab2. Both are of the same definition. If the entries in itab2 should not be present in itab1, we use FILTER function along with 'EXCEPT IN'. There are two internal tables, say, itab1 and itab2. Both are of the same definition. If only the entries in itab2 should be present in itab1, we use FILTER function along with 'IN'. FILTER required SORTED / HASHED internal tables. Example program is below. REPORT  zag_75_filter1 . TYPES :  BEGIN  OF  lty_filter ,          field1  TYPE  i ,          field2  TYPE  i ,         END  OF  lty_filter ,        ltt_filter  TYPE  SORTED  TABLE  OF  lty_filter  WITH  NON-UNIQUE  KEY  field1 field2 . DATA :  lt_main   ...
Read more

Useful Transaction Codes / Tools in OData ABAP Service / SAP UI5/ SAP Fiori

-
Tips:   1) FND stands for 'Front End' 2) GW stands for Gate Way / Gateway S. No. Transaction Code Description 1 SEGW SAP Service Gateway Builder 2 /IWFND/ERROR_LOG SAP Gateway Error Log 3 /IWFND/APPS_LOG SAP Gateway Application Log Viewer 4 /IWFND/VIEW_LOG SAP Gateway Application Log Viewer 5 /IWFND/CACHE_CLEANUP Cleanup of GW Model Cache - GW stands for Gateway 6 /IWFND/TRACES SAP Gateway Traces 7 /IWFND/SRV_VALIDATE This transaction exists only on SAP Gateway 2.0 (Netweaver 7.31 and below) systems 8 /IWFND/REG_SERVICE Activate Services (Unavailable in latest releases) 9 /IWFND/MAINT_SERVICE Activate and Maintain Services 10 /IWFND/VIRUS_SCAN Configuration of SAP GW Virus Scan 11 SICF Edit HTTP Service Hierarchy 12 ...
Read more