Wednesday, February 11, 2015

SAP: Firefighter ID locked

Issue: I had my FireFighter ID got locked and I was unable to logon. The partial screen is show below with the Logon as “Greyed Out” and the Status would show up with a RED Traffic light stating user still logged in. I checked SM04 to view the list of users with my regular user id and could not find my FireFighter ID in the list and then it struck to me that the server my user id was connected to was different to that of my FireFighter.




Reason: I happened to execute SE16 to extract data and my internet got disconnected. This caused an abrupt closing of the session keeping the SE16 still in execution mode on the server.

Solution: 

1. Execute AL08 to check the list of all users logged onto all the servers.
2. Search for the FireFighter ID the server where the user id has been locked.
3. Execute SM51 to view the list of the SAP Servers.
4. Select the appropriate server name from step 2 and click on the ‘User’ icon to display the users.

This actually calls TCode SM04 to display the list of users of that particular SAP Server (the server which my firefighter was logged on)and select the user id and kill the sessions.

Friday, January 16, 2015

SAP : Error in external tax system: Line: 0 - 0440 TxJCdSTIO The fleximap module / FS861

The error is caused in the sales orders due to a change in the customer jurisdiction code and sets the sales document to an  incompletion log for pricing. Changing the Jurisdiction code in the Sales order does not undo the incompletion. The customer ship-to jurisdiction code (If Ship-to is different from Sold-to) has to be changed appropriately and later the order has to be re-priced with price type 'G'.


Regards,
[V]

Tuesday, November 11, 2014

SAP : Difference between VF04 and VF06


As we are aware VF06 uses the program RV60SBAT, but internally the RV60SBAT program calls the SDBILLDL program which represents transaction code VF04, when processed in background.

So the RV60SBAT is like a master program and creates multiple jobs to process in parallel incases where we have high volume of data for invoicing or mainly month end closing.

If we have noticed, when VF06 is executed in the background, you have multiple jobs with something like INVOICE_141111_074352_01_ESSDEV0. This naming rule is within the master program for VF06 which basically is represented as  INVOICE_DATE_TIME_JOB#_APPSERVER. See screen 3.

 Screen 1 : Parallel Processing

a. Number of Jobs: Defines the jobs to be created for background processing.

b. Target Computer: Allows to specify the Application server name to process the jobs 

Screen 2 : SM37 log 


Screen 3 : Calling SDBILLDL within RV60SBAT.


Screen 4 : Naming Convention of the Background job


Screen 5 : List output

a. If the “List Display” is checked, the output log written for each individual job.
b. Else the output log is written to the master program only with the total number of documents processed
 

Other functions of VF06 are like

1. Filter out blocked documents
2. Execute in Test mode
3. Schedule the invoice printing with required date and time for the configuration of the output type.

VF04 can also be processed in background but has be set using SM36 and as usual provide the program name and variant.



Regards,
[V]

Tuesday, November 4, 2014

SAP : Findings on Sales Order BAPI

  1. When trying to create a subsequent order with respect to a preceding sales document (Contract - Order or Quote - Order) using BAPI (BAPI_SALESORDER_CREATEFROMDAT2) the standard SAP Copy control routines will not be triggered.
  2. The contract reference and item reference have to be passed for document flow.
  3. Any logic necessary for copy controls needs to be re-coded before calling the BAPI.
  4. In cases where there are manual item categories are to be determined, the item categories have to be passed to the BAPI based on a pre-determined logic.
  5. The BAPI's determine the Item Categories based on the standard configuration maintained via TCode VOV4 (Table T184).
  6. The BAPI's would call the user-exits, enhancements and pricing routines during the order processing.


 
P.S. : I would add to the list based on my future findings

 
Regards,
[V]

Wednesday, April 16, 2014

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]

Wednesday, April 9, 2014

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".