Adım adım SAP Query oluşturma (Hızlı ALV raporu)

Adım adım SAP Query oluşturma (Hızlı ALV raporu)

Adım SAP Query adımı kullanılması.

amaç

Adım SAP Query adımı kullanarak hızlı bir şekilde basit bir rapor yapmak.

1. Create Infoset

Go to transaction code: SQ02 >> Choose Tab Environment >> Choose Query Areas >> Choose Standard Client ( Client Specific ) – If you want test on current client and then transport to others client.

SAP Query step by step

SAP Query step by step

If you don’t choose Query Areas is Standard client ( Client – Specific ). System defaults all infoset will existing on Global Client ( Cross Client )

Fill infoset field name: ZPP_R001 >> Click Create

SAP Query step by step

Fill Title of Infoset, authorization group (if it’s necessary)

  • Choose Direct read of table (if data of report need only from single table)
  • or choose Table join using basis table (if data of report need join from multiple tables)

>> Enter

SAP Query step by step

Choose Include all table fields (Recommend)

SAP Query step by step

2. Editor Infoset

Select necessary field for report by double – click on field. >> Editor information of field. Example: Long text, Header text, … etc … Remove unnecessary field by hold on Ctrl and Left-Click then Right-Click to choose Delete Field (s) from Field Group

Or Additional ABAP code into infoset by Click on Extras >> Choose Tab Code 

SAP Query step by step

In this screen is position of ABAP code in program generate. (Ignore if you don’t want insert ABAP code)

Hakan AK

Son Yazılar