SAP : Query Simple Tips

Default Query Area in SQ01
-Execute TCode SU3 to set default parameters
-Enter parameter AQW and level the value as blank

Default User Group for Query
- From SQ01 - Use the first toggle icon on the screen
- From SU3 - Enter the parameter ID (AQB) and your user group

Convert Quick Viewer qeury to query
- Create the table joins using TCode SQVI
- Execute the Tcode SQ01 and from menu Environment-Query Areas change Query area to "Standard area-Client Specific" .
- Check the current user group (Appears as title in SQ01), to change the user group use the first toggle icon on the screen and change user group
- Execute the Tcode SQ01 and from menu: "Query- Convert to Quick view", enter the name of the quick view created from SQVI
- Enter the Query name and the infoset name, the user group is defaulted to current.
- If you needed to default the selection fields, create a Variant for the Quick View
- Execute the Tcode SQ01 and enter query name created.
- Click the change button and enter the variant in Special Attributes tab

Change infoset Description
- Execute TCode SQ02
- Enter the infoset name and click Change
- In the change screen, from menu - Goto - Global Properties
- Save and this ask for program regeneration.

Regards
[V]

SAP : Maximum number of items in FI reached

Issue

Although you can maintain the max 999 line items in billing document, and we are aware that each line item of billing document must generate two line items (D&C) in the accounting document, the max line items of billing document is less than 500 lines. Considering taxes etc the number of billing lines could be less than 400.
The cause of this issue is because the line item number (BSEG-BUZEI) field  length is defined as (3) numeric positions, and hence can accomodate 999 line items.
Unable to create more than 999 FI line items is a standard restriction due its field length.
          
Solution

1. IMG -> SD -> Billing -> Billing Document -> Country Specific Features -> Maintain Maximum Number of Billing Items.
2. This is where you can define a maximum number of items allowed for all billing documents within a given sales organization.
3. Also in the copying control for order/delivery to billing document at item level under "Data VBRK/VBRP" and maintain routine 006 "Single inv. limited".