Skip to Content

Been looking for a SAP Query Functional or/and technical Spec Template

Hello everyone,

Been looking for a SAP Query Functional or/and Technical Spec Template to enrich our knowledge base database without success, can't find any specific for SAP Query and we would like to include this objects in the Development Lifecycle Process, does anyone have one that would be able and willing to share?, thanks in advance.

Best regards,

Julio Cesar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Feb 20, 2018 at 10:50 PM

    In general, a spec for a query would be essentially the same as for an ABAP report. It'd need to show the business purpose and what fields are needed on the selection screen and in the report itself. It should also state what business logic is required and which users should have access. IMHO the functional specification should not dictate how it to be implemented. If business logic is too complex or if data look-up would be too complex / inefficient in a Query, an ABAPer would decide if it should be implemented more effectively as an ABAP report.

    We used queries a lot in my old job, even the functional folks got comfortable with them and were creating their own without very little to no help. Never wrote any specifications for them at all. Infoset/query name is usually sufficient to describe business purpose and the details are easily visible in SQ01/02. There is no need for ABAP code in a query and if any code is added it should be minimal and self-documenting.

    There is no unit etc. testing for query to speak of. Just run it, make sure it shows what expected and doesn't run too long. That's pretty much it. I feel you're over-complicating this.

    There are many good blogs about queries on SCN, this one is a good starting point. Others can be found in Google with "sap query".

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 19, 2018 at 06:29 AM

    Why not design your own? How hard can it be?

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Jelena,

      Thank you for your answer. Let me try to explain myself better.

      I did mentioned I need a spec template, a SAP Query Spec Template either functional and/or technical. I am not myself really familiar with SAP Query so it is not easy for me to create one, I will start to create SAP Queries so I will explore everything about it with online documentation and in the system. A spec template would help me understand what are the considerations to have when a SAP Query is designed and created, I can think of the basic details such as Query Area, User Group, Infoset, Tables/Views, Joining Fields and ABAP Code if any implemented but I am not sure if those are the only things you need to evaluate when designing and creating SAP Queries aside from the typical as Unit, Integration and Stress Test.

      I am not lazy or just trying to get everything as easy as possible, usually I create my own templates of the areas that I am familiar with, for sure after some work and time on it I will be able to come up the same but I don't think it is a bad thing to reach out to ask if maybe someone has one that can help me start with as a SAP Query Specification Template and it will help me identify specific details I might be loosing due my lack of knowledge with SAP Queries, so I can start designing and developing this objects the best way possible for me considering the lack of knowledge.

      Thank you.

      Best regards,