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

Monday, March 31, 2014

SAP : The reference has already been completely copied or rejected

The above error message in my case occurred when trying to create a Contract with reference to a Quotation or Order from a Quote with a production order, meaning the Primary document is a Quotation

Even though if there is no completion rule specified in the item category of the quotation, the system sets it to A because it checks for the order type and Assembly type combination in the Program SAPFV45P.

IF vbak-vbtyp CA vbtyp_agan AND
NOT t459k-mntga IS INITIAL.
vbap-erlre = chara.
ENDIF.

The first check is for order document type, my case it’s B (Quote). Second check t459k-mntga, is to see if there is Production/Planned order.

Satisfying these conditions the VBAP-ERLRE (Completion rule) is set the CHARA (A) and the VBAP table is updated with completion rule A by default.

Regards,
[V]

Friday, March 28, 2014

SAP Requirement Type and Requirement Class determination

Generally speaking we are aware that SAP Make-to-order production is controlled by the requirements type, but what’s mystical in how the requirement type is determined during the sales order processing. I did a little research to understand this process, which seems tricky compared to the some other SD area determination process like item category or schedule line and below are my findings.

Until Release 3.0, the requirements type was determined on the basis of the item category. For this reason, special item categories weree used unti Release 3.0 for controlling make-to-order production. After Release 3.0 the requirements type is determined on the below sequence primarily in the configuration for Production-MRP and Sales and Distribution in secondary.

1. The Strategy group (MRP3 View) in the Material Master,
    a. A Strategy is assigned to the Strategy group, (Tcode OPPT)
    b. The requirement type is assigned to the Strategy, (Tcode OPPS) and if this fails.

2. MRP group (MRP1 View) in the material master record.
    a. If the Strategy group is not maintained in the MRP3 view, the Strategy group
        is determined based on the Plant + MRP group combination (Tcode: OPPR)
    b. Uses step 1 after step 2.b and this if this fails

3. Based on Material type (Tcode: OMIG)

4. Item category and the MRP type
    a. Determination Of Requirement Types Using Transaction (TCode OVZI)

5. Item category only.
    a. Determination Of Requirement Types Using Transaction (TCode OVZI)


Regards,
[V]