Create a report using queries (sq01, sq02, and sq03)

Query Requirement Description

Query (sq01, sq02, and sq03) is used to query various information in the sales order according to the sales organization, including materials, amount, cost, and gross profit.

The authority check is performed on the sales organization. The gross profit of the field is calculated based on the amount minus the cost.

Directory

1.1 information collection maintenance... 1

1.1.1 create an information set (infoset)... 1

1.1.2 create information set-add permission check fields... 2

1.1.3 add additional fields in the information set... 4

1.2 maintain the user group and user and information set included in the user group... 7

1.3 maintenance query... 8

1.3.1 query and user group... 8

1.3.2 maintenance query... 8

1.4 user permissions and operations... 10

1.4.1 assign permissions to users... 10

1.4.2 user query related information... 11

 

 

1.1 information collection maintenance

1.1.1 create an information set (infoset)

TransactionsCodeSq02 create an information set zsaleorder. The information set contains two tables of the sales order (vabk/vbap)

Add Table vbap to information set

Click the button to generate the information set

Click the button to generate a set of contained information

1.1.2 create information set-add permission check Fields

In the information set, add the selection screen field "sales organization s_vkorg" and set the permission check for the sales organization.

Set Properties for selection screen field s_vkorg: reference table as VBAK-VKORG (sales organization of the sales order)

Added the code for permission check on the sales organization, and set that the Code will not continue if the permission check fails.

1.1.3 add additional fields in the information set

In the information set, add the field zvalue (sales gross profit), set this field to equal the tax-free amount of the sales order (VBAP-NETWR) minus the cost of the sales order (VBAP-WAVER)

Set field attributes

Set Field Calculation Formula

Add the Custom Field zvalue to field group Z1.

1.2 maintain the user group and user and information set included in the user group

The transaction code sq03 enables the user zztest to have the permission to query the zsalesorder information set through the following three operations:

1) create a user group zsd01

2) Assign user zztest to user group zztest

3) Assign the information set zsalesorder to the user group zztest.

1.3 maintenance Query

1.3.1 query and user group

When the transaction code sq01 is used to maintain, maintain, and execute queries, select the corresponding user group.

1.3.2 maintenance Query

Transaction code sq01 creates a query for zsalevalue for the information set zsalesorder under zsd01 of the user group, and adds the fields in the table of the sales order: sales order number, amount, cost, and materials to the query.

1.4 user permissions and operations

1.4.1 assign permissions to users

The transaction code pfcg creates the role z001, which has 1000 of the sales organization permissions.

Assign this role to the user zztest so that the user zztest has 1000 of the sales organization permissions.

1.4.2 user query related information

The user zztest queries query by using the transaction code sq01: zsalevalue. The sales organization 1000 has permissions, and the sales organization 2000 has no permissions.