expertsask994@gmail.com
My Account
  • Home
  • Blog
  • eBooks
  • SAP FICO Course
  • About
  • Contact Us
  • My account

No products in the cart.

  • Home
  • Blog
  • eBooks
  • SAP FICO Course
  • About
  • Contact Us
  • My account

No products in the cart.

  • Home
  • Blog
  • eBooks
  • SAP FICO Course
  • About
  • Contact Us
  • My account

No products in the cart.

  • Home
  • Blog
  • eBooks
  • SAP FICO Course
  • About
  • Contact Us
  • My account
General SAP
Home General SAP Page 4

Category: General SAP

General SAP

What is SAP Co-Pilot?

Imagine you are sitting on your couch, scrolling through Instagram, it’s 21:00 o’clock, you are done with dinner and planning to go to bed… almost all of the items in your to do list is checked…

And suddenly you realize that you forgot to punch a Purchase order against the purchase requisition raised by IT department. The requirement is for procurement of headsets and it is urgent, the PO should have punched today itself. So you decide to create purchase order…

Now imagine the pain of getting up and reaching to your home office desk/laptop, logging in, connecting through all of VPN and then follow all of the necessary steps to create purchase order without getting distracted by the emails or the messages you may have received.

Now, instead of doing all of this, what if someone do it for you. Like you ask google assistance/Siri/Alexa to set an alarm for you, like you ask them to call xyz person. What if you get a similar bot and you ask that bot to ‘show me all of the purchase requisition created for headset requirement’ and the bot replies you with the appropriate requisition number and a soft copy of that requisition on your smartphone. You check the details of the requisition and then you ask bot to create a purchase order for this xyz requisition… and within few seconds the bot replies you with the created purchase order and soft copy of it….

Wouldn’t it be amazing? If you think it is, then it’s here the bot name is SAP Co-pilot and it can do many more things than what we imagined in above example. Explore more about co-pilot in below video..

Read More
ERP College June 11, 2021 0 Comments
General SAP

What is Rise with SAP?

Basically it’s an offer, SAP has launched after pandemic. SAP has offered a package of components along with S4HANA.

Rise with SAP is a movement where SAP wants to help customers to move on to the latest technologies with the most efficient and faster way. SAP has divided customers into three categories:

  1. ECC customers
  2. S4HANA customers
  3. New customers

Now there are just so many things out there for new customers as well as ECC customers to choose from and also there are S4HANA customers but all are on different level, some have opted in 2015 some have in 2018 and all of the customers are wondering what should be the next step… this is where Rise with SAP comes into the picture

SAP wants to build an Intelligent enterprise to run and streamline complex innovative scenarios. To help businesses streamline their processes differently with the help of Intelligent suite (i.e. S4HANA) and Industry cloud. It helps businesses to not only became profitable but to be sustainable in long run.

Below slide provides an idea about how SAP will help implementing the Intelligent enterprise:

  1. Help businesses to Redesign business process
  2. Provide necessary Tools & services for smooth migration
  3. Provide Infrastructure, Platforms, Required Application and Network

What SAP is offering in Rise with SAP offer:

Packages included in this offer and how customers can buy this:

S4HANA private cloud edition:

for more information about Rise with SAP watch this webinar.

If you have any suggestions or questions do let us know in the comment section or you can also write us directly. 

Sign up with us to get an update of a new blog post.

Till then you can have look at our ebooks.

Read More
ERP College February 9, 2021 0 Comments
General SAP

How to keep portable and uploadable copy from your SAP configuration

Describe using BCset functionality to download SAP configuration and upload it in any other SAP system with specific limitation.

In this blog post we are going to explain:

1- The business cases that we may need to keep our configuration

2- Demo for how to use BC sets and upload and activate BC set files

3- Some limitations related to BC sets used

by End of this video you can use BCsets and keep a copy from your configuration

Read More
Ayman Mohmed December 11, 2020 0 Comments
ABAPGeneral SAP

How to find the Table that stores multiple Field values? That’s what ABAPER and Functional does :) in WRICEFF development

Introduction

After working with SAP for more than 15 years and travelling across the Globe for SAP Projects one issue I always use to have how can I keep track of all the SAP Tables associated with different Modules. If you are working as a SAP ABAP Consultant you need to keep the name of tables in your Fingertips. Sometimes this you know from other Experts and sometimes you have to dig it out.

After exploring I found a very easy way to know the Tables that contains all the four fields or Data Element in the same table and has data in it.

SAP is just like an ocean and every droplet is like one SAP Table. This is one of the first program I create in any Project.

I have one request the .1% time you saved while implementing this Blog, help someone in need by doing Service. It can be as simple as playing with a Kid also.

This solution only does Table. I will do another blog  for Views also.

Solution

Go to SE38-> Create a Program and Paste this Code.

Here is the Execution. Just to let you know I have Excluded the Table Beginning with ‘/’. If you want to add it just tweak the code.

In the Below example I am looking for tables with these 2 fields/Data Element. EBELN and EBELP

And here is the Result

Lets be adventurous and try with 4 fields

Before this I never knew EKPO has all the above 4 Fields/Data Element.

Below is the Code that probably can fetch some serious Fun Time to learn something more.

TABLES: DD03L,

        BOOLE.

DATA:DREF TYPE REF TO DATA.

FIELD-SYMBOLS:<TABLE> TYPE STANDARD TABLE.

TYPE-POOLS: SLIS, ICON.

* Internal Tables

TYPES: BEGIN OF T_IALV,

         TABNAME TYPE DD03L-TABNAME,

         FIELD1  TYPE DD03L-FIELDNAME,

         FIELD2  TYPE DD03L-FIELDNAME,

         FIELD3  TYPE DD03L-FIELDNAME,

         FIELD4  TYPE DD03L-FIELDNAME,

       END OF T_IALV .

DATA: IALV   TYPE STANDARD TABLE OF T_IALV,

      WA_ALV TYPE T_IALV.

DATA: ALV_CONTAINER TYPE REF TO CL_GUI_CUSTOM_CONTAINER,

      ALV_GRID      TYPE REF TO CL_GUI_ALV_GRID,

      OK_CODE       LIKE SY-UCOMM,

      FIELDCAT      TYPE SLIS_T_FIELDCAT_ALV WITH HEADER LINE.

SELECT-OPTIONS:S_FIELD1 FOR DD03L-FIELDNAME NO-EXTENSION,

S_FIELD2 FOR DD03L-FIELDNAME NO-EXTENSION,

S_FIELD3 FOR DD03L-FIELDNAME NO-EXTENSION,

S_FIELD4 FOR DD03L-FIELDNAME NO-EXTENSION,

S_EXC FOR BOOLE-BOOLE.

FIELD-SYMBOLS:<FS-TAB13> TYPE MANDT.

DATA:WA_DD1      TYPE DD03L,

     WA_DD2      TYPE DD03L,

     WA_DD3      TYPE DD03L,

     WA_DD4      TYPE DD03L,

     LV_TAB      TYPE DD03L-TABNAME,

     WA_DD_FINAL TYPE DD03L.

IF S_EXC-LOW IS NOT INITIAL.

  LV_TAB = ‘/%’.

ENDIF.

IF S_FIELD1-LOW IS NOT INITIAL.

  SELECT C~TABNAME

    FROM ( ( DD03L AS C

         INNER JOIN DD02V AS P ON P~TABNAME  = C~TABNAME

                              AND P~TABCLASS = ‘TRANSP’)

*                              AND p~cityto   = @cityto )

         INNER JOIN DD09L AS F ON F~TABNAME = P~TABNAME )

    WHERE ( ( C~ROLLNAME EQ @S_FIELD1-LOW )

    OR ( C~FIELDNAME EQ @S_FIELD1-LOW  ) )

    AND P~TABNAME NOT LIKE @LV_TAB

       INTO TABLE @DATA(ITAB13).

ENDIF.

IF S_FIELD2-LOW IS NOT INITIAL.

  SELECT C~TABNAME

  FROM ( ( DD03L AS C

       INNER JOIN DD02V AS P ON P~TABNAME  = C~TABNAME

                            AND P~TABCLASS = ‘TRANSP’)

*                              AND p~cityto   = @cityto )

       INNER JOIN DD09L AS F ON F~TABNAME = P~TABNAME )

  WHERE ( ( C~ROLLNAME EQ @S_FIELD2-LOW )

  OR ( C~FIELDNAME EQ @S_FIELD2-LOW  )    )

  AND P~TABNAME NOT LIKE @LV_TAB

     INTO TABLE @DATA(ITAB14).

ENDIF.

IF S_FIELD3-LOW IS NOT INITIAL.

  SELECT C~TABNAME

  FROM ( ( DD03L AS C

       INNER JOIN DD02V AS P ON P~TABNAME  = C~TABNAME

                            AND P~TABCLASS = ‘TRANSP’)

       INNER JOIN DD09L AS F ON F~TABNAME = P~TABNAME )

  WHERE ( ( C~ROLLNAME EQ @S_FIELD3-LOW )

  OR ( C~FIELDNAME EQ @S_FIELD3-LOW  )    )

  AND P~TABNAME NOT LIKE @LV_TAB

     INTO TABLE @DATA(ITAB15).

ENDIF.

IF S_FIELD4-LOW IS NOT INITIAL.

  SELECT C~TABNAME

FROM ( ( DD03L AS C

     INNER JOIN DD02V AS P ON P~TABNAME  = C~TABNAME

                          AND P~TABCLASS = ‘TRANSP’)

*                              AND p~cityto   = @cityto )

     INNER JOIN DD09L AS F ON F~TABNAME = P~TABNAME )

WHERE ( ( C~ROLLNAME EQ @S_FIELD4-LOW )

OR ( C~FIELDNAME EQ @S_FIELD4-LOW  )

)

AND P~TABNAME NOT LIKE @LV_TAB

*                                AND f~connid = p~connid )

*       ORDER BY c~carrname, p~connid, f~fldate

   INTO TABLE @DATA(ITAB16).

ENDIF.

SORT ITAB13 BY TABNAME.

DELETE ADJACENT DUPLICATES FROM ITAB13 COMPARING TABNAME..

SORT ITAB14 BY TABNAME.

DELETE ADJACENT DUPLICATES FROM ITAB14 COMPARING TABNAME..

SORT ITAB15 BY TABNAME.

DELETE ADJACENT DUPLICATES FROM ITAB15 COMPARING TABNAME..

SORT ITAB16 BY TABNAME.

DELETE ADJACENT DUPLICATES FROM ITAB16 COMPARING TABNAME.

IF S_FIELD1-LOW IS NOT INITIAL.

  LOOP AT ITAB13 INTO DATA(WA_TAB133).

    IF ITAB14[] IS NOT INITIAL.

      READ TABLE ITAB14  INTO DATA(WA_TAB134) WITH KEY TABNAME = WA_TAB133-TABNAME.

      IF SY-SUBRC = 0.

        CREATE DATA DREF TYPE TABLE OF (WA_TAB134-TABNAME).

        IF ITAB15[] IS NOT INITIAL.

          READ TABLE ITAB15  INTO DATA(WA_TAB135) WITH KEY TABNAME = WA_TAB133-TABNAME.

          IF SY-SUBRC = 0.

            IF ITAB16[] IS NOT INITIAL.

              READ TABLE ITAB16  INTO DATA(WA_TAB136) WITH KEY TABNAME = WA_TAB133-TABNAME.

              IF SY-SUBRC = 0.

                ASSIGN DREF->* TO <TABLE>.

SELECT  *

              FROM (WA_TAB134-TABNAME)

                  INTO TABLE @<TABLE>.

                IF <TABLE> IS NOT INITIAL.

                  WA_ALV-TABNAME =  WA_TAB134-TABNAME.

                  WA_ALV-FIELD1 =  S_FIELD1-LOW.

                  WA_ALV-FIELD2 =  S_FIELD2-LOW.

                  WA_ALV-FIELD3 =  S_FIELD3-LOW.

                  WA_ALV-FIELD4 =  S_FIELD4-LOW.

                  APPEND WA_ALV TO IALV.

                  CLEAR WA_ALV.

*      exit.

                ENDIF.

              ELSE.

                ASSIGN DREF->* TO <TABLE>.

SELECT  *

              FROM (WA_TAB134-TABNAME)

                  INTO TABLE @<TABLE>.

                IF <TABLE> IS NOT INITIAL.

                  WA_ALV-TABNAME =  WA_TAB134-TABNAME.

                  WA_ALV-FIELD1 =  S_FIELD1-LOW.

                  WA_ALV-FIELD2 =  S_FIELD2-LOW.

                  WA_ALV-FIELD3 =  S_FIELD3-LOW.

*                  WA_ALV-FIELD4 =  S_FIELD4-LOW.

                  APPEND WA_ALV TO IALV.

                  CLEAR WA_ALV.

*      exit.

                ENDIF.

              ENDIF.

            ELSE.

              ASSIGN DREF->* TO <TABLE>.

SELECT  *

            FROM (WA_TAB134-TABNAME)

                INTO TABLE @<TABLE>.

              IF <TABLE> IS NOT INITIAL.

                WA_ALV-TABNAME =  WA_TAB134-TABNAME.

                WA_ALV-FIELD1 =  S_FIELD1-LOW.

                WA_ALV-FIELD2 =  S_FIELD2-LOW.

                WA_ALV-FIELD3 =  S_FIELD3-LOW.

                APPEND WA_ALV TO IALV.

                CLEAR WA_ALV.

              ENDIF.

            ENDIF.

          ELSE.

            ASSIGN DREF->* TO <TABLE>.

SELECT  *

          FROM (WA_TAB134-TABNAME)

              INTO TABLE @<TABLE>.

            IF <TABLE> IS NOT INITIAL.

              WA_ALV-TABNAME =  WA_TAB134-TABNAME.

              WA_ALV-FIELD1 =  S_FIELD1-LOW.

              WA_ALV-FIELD2 =  S_FIELD2-LOW.

              APPEND WA_ALV TO IALV.

              CLEAR WA_ALV.

            ENDIF.

          ENDIF.

        ELSE.

          ASSIGN DREF->* TO <TABLE>.

SELECT  *

        FROM (WA_TAB134-TABNAME)

            INTO TABLE @<TABLE>.

          IF <TABLE> IS NOT INITIAL.

            WA_ALV-TABNAME =  WA_TAB134-TABNAME.

            WA_ALV-FIELD1 =  S_FIELD1-LOW.

            WA_ALV-FIELD2 =  S_FIELD2-LOW.

            APPEND WA_ALV TO IALV.

            CLEAR WA_TAB134.

          ENDIF.

        ENDIF.

      ENDIF.

    ENDIF.

*  endif.

  ENDLOOP.

ENDIF.

*  Populate Field Catalog

PERFORM GET_FIELDCATALOG.

CALL FUNCTION ‘REUSE_ALV_GRID_DISPLAY’

  EXPORTING

    I_CALLBACK_PROGRAM = SY-REPID

*   is_layout          = w_layout

    IT_FIELDCAT        = FIELDCAT[]

*   it_events          = i_events

  TABLES

    T_OUTTAB           = IALV

  EXCEPTIONS

    PROGRAM_ERROR      = 1

    OTHERS             = 2.

IF SY-SUBRC <> 0.

* Implement suitable error handling here

ENDIF.

************************************************************************

*      Form  Get_Fieldcatalog – Set Up Columns/Headers

************************************************************************

FORM GET_FIELDCATALOG.

  CLEAR: FIELDCAT.

  FIELDCAT-SELTEXT_M    = ‘Tablename’.

  FIELDCAT-FIELDNAME  = ‘TABNAME’.

  FIELDCAT-OUTPUTLEN  = ’36’.

  APPEND FIELDCAT TO FIELDCAT.

  CLEAR: FIELDCAT.

  FIELDCAT-SELTEXT_M   = ‘Field1’.

  FIELDCAT-FIELDNAME  = ‘FIELD1’.

  FIELDCAT-OUTPUTLEN  = ’12’.

  APPEND FIELDCAT TO FIELDCAT.

  CLEAR: FIELDCAT.

  FIELDCAT-SELTEXT_M   = ‘Field2’.

  FIELDCAT-FIELDNAME  = ‘FIELD2’.

  FIELDCAT-OUTPUTLEN  = ’12’.

  APPEND FIELDCAT TO FIELDCAT.

  CLEAR: FIELDCAT.

  FIELDCAT-SELTEXT_M   = ‘Field3’.

  FIELDCAT-FIELDNAME  = ‘FIELD3’.

  FIELDCAT-OUTPUTLEN  = ’12’.

  APPEND FIELDCAT TO FIELDCAT.

  CLEAR: FIELDCAT.

  FIELDCAT-SELTEXT_M    = ‘Field4’.

  FIELDCAT-FIELDNAME  = ‘FIELD4’.

  FIELDCAT-OUTPUTLEN  = ’12’.

  APPEND FIELDCAT TO FIELDCAT.

ENDFORM.

Here is the Selection Screen Parameter label

Conclusion

This will work for both SAP ECC and SAP S/4 HANA

Below is the video version

Read More
Arghadip Kar December 11, 2020 0 Comments
General SAP

How to Display Attachment List in Custom Report in SAP in one click?

Introduction

After working with SAP for more than 15 years and travelling across the Globe for SAP Projects one requirement I always use to get is Build me a Report that will show all the Attachment List. This blog will make your life easier as well as the Customers as they will have to click Less. This blog will save you at least 2 clicks per document which is equivalent to 2 less chances of making Mistakes..

Current Process for Display Attachment List.

In this scenario we want to Display Attachment List for an Invoice in FB03 Tcode which has 2 Clicks.

FB03

2 Clicks below

Attachment List

Solution

Use Function Module GOS_EXECUTE_SERVICE by Going to Tcode SE37 and HIT Execute

SE37

Now enter value as mentioned below

Special Mention of IS_OBJECT

Now execute

Conclusion

This can be used both in SAP ECC and SAP S/4HANA

Below is the video version.

Read More
Arghadip Kar December 11, 2020 0 Comments
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • Home
  • About
  • Contact
Categories
  • ABAP 8
  • FICO 23
  • General SAP 29
  • MM 1
  • SD 2
Products
  • SAP FICO (Finance and Controlling) Comprehensive Training
    Rated 4.50 out of 5
    ₹7,999.00 ₹6,999.00
  • What has been changed in New Asset Accounting
    Rated 4.00 out of 5
    ₹151.06 ₹119.00
  • SAP Classic Vs New GL Accounting
    Rated 5.00 out of 5
    ₹999.00 ₹799.00
  • SAP Sales and Purchase Tax Training
    Rated 4.50 out of 5
    ₹899.00 ₹699.00
Sign Up to get update of latest Blogs

Find Us

Address
123 Main Street
New York, NY 10001

Hours
Monday–Friday: 9:00AM–5:00PM
Saturday & Sunday: 11:00AM–3:00PM

About This Site

This may be a good place to introduce yourself and your site or include some credits.

Contacts
Website: https://erpcollege.co/
Email: expertsask994@gmail.com
Terms & Condition

Copyright © 2020 ERP College by Smarksys Technologies. All Rights Reserved.