Shulou(Shulou.com)05/31 Report--

This article will explain in detail the calculation logic of how to analyze the quantity of orders in the SAP CRM Interactive Report interface. The content of the article is of high quality, so the editor will share it with you for reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

I first tried to implement this small and simple function:

How does it work now?

I use the CRM_BW_READ_DATA report in QHD/504 to demonstrate.

Check these two SAT trace records:

In local RFC execution, most of the time (0. 7 seconds) is spent.

From SAP help:

The data displayed in the interactive report depends on the location of the user in the organizational model.

For example, a sales employee's report contains only data on the opportunities for which he or she is responsible.

However, the manager can view data on all opportunities for which the sales employee in the manager's organizational unit is responsible.

Check whether the current user is a manager:

The first two options are fleshed out as: 2 original fields + 85 fields from other BP=87 fields, and finally:

Some hard-coded filters continue to enrich the selection fields:

Finally, this interactive report reading still consists of two steps:

Read GUID from crmd_order_index:

CRMD_ORDER_INDEX~PARTNER_NO IN ('0000400105', '0000415143', '0000415872', '0000415893', '0000415961', '0000416631', '0000416721', '0000416746', '0000417016', '0000417054', '0000417058', '0000417093', '0000417672', '0000417681',' 0000417740', '0000417865', '0000418050', '00004185977', '000041881212', '000042039112', '000042044112,' 0000420058, '0000417093,' 0000417681', '00004178740', '00004178505', '00004180505,' 000041859712, '00004188812,' 00004188812, '00004203911200,' 0000475420058, '0000417093', '0000417681',' 0000417740', '00004178505', '00004180505,' 000041859712, '00004188812,' 00004188812, '00004203911212,' 000042039112', '00004204411',' 0000475417058, '000041709333,' 0000417681', '0000417740', '0000417865', '00004180505,' 000041859712, '00004188812,' 00004188812, '00004 '0000420882', '0000420925', '0000420932', '0000420935', '0000420955', '0000421094',' 0000421094', '0000421094',' 0000421316', '0000421721', '0000421722', '0000422264', '0000422404', '000042419', '0000424883', '0000422765', '000042289333', '000043049', '000043023059', '00004302306', '0040023061',' 000042302302, '0000422264',' 0000424042419, '0000424424833,' 000042765', '000042289333', '000043043049', '000043023059', '00004302306', '00004306301',' 000042302302, '00004634303', '00004240224019',' 000042419,000042483', '000042276593',' 00004304304993', '000043023059',' 00004302306', '00004306301',' 000042302302', '0000422264',' 00004224042419, '00004241919,' 00004248833, '000042765500428933',' 000043049043059, '000043059,' 0000 '0000423142,' 0000423555, '0000424451,' 0000424467, '0000424840,' 0000700364, '0000703460,' ARPANA', 'BAKER',' BOUWHUIS', 'BUSCHC',' CRMAUTOTST', 'CRMSUPPORT',' D019666, 'D031132,' D032824, 'DIGGS',' DUMANN', 'FREEMAN',' KING', 'KRATZN',' KRUSE', 'LONDON',' LUCKINSE', 'MILLER',' MYERS' 'PORTALCHM',' RYZHOVA', 'SCHULZ',' SCHUPPM', 'SHRAMASUM',' WANGJ', 'WANGJ',' WHITE', 'WILSON',' ZELLERSU') AND

Use the GUID of these queries to read additional report data from the corresponding buffer table:

Then I searched SD Analytic Package for the keyword "Number of Open":

And find out how they did it:

So I created a view accordingly:

And this is our cube view:

Tested in QGS/300:

Read: CRMS4_BW_PRINT_ORDER_NUMBERS by opening SQL.

In traditional ABAP reports, we cannot get the number of orders and outstanding orders through an OPEN SQL statement.

On how to analyze the SAP CRM Interactive Report interface order quantity calculation logic is shared here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.