Experts' voice on SAP SD
Ask your doubts. Post an Article. Play variety of SD quiz and test your skills. Check real time scenarios. Comment on Posts. Give valuable suggestions. Increase your reachability and be a Master in SD.
Tuesday, September 10, 2013
Free SAP SD Certification questions
Sunday, May 19, 2013
Saturday, January 23, 2010
Friday, December 25, 2009
Recent Tickets posted on sapexplore
Saturday, December 12, 2009
Sunday, January 4, 2009
All SD issues on sapexplore
- Items not copying from Sales Order to Return Order
- Automatic PR Generation from Sales Order
- Incompletion Log working even when its not assigned to an order type
- User exits
- Grouping Deliveries
Saturday, June 14, 2008
www.sapexplore.com
www.sapexplore.com : Your search for SAP Solutions ends here
Stock transfer Purchase order to delivery creation
Question
Users create Stock Transfer Purchase Order from PR in MD04.
Once POs are created deliveries are created from VL10B Transaction code.
The requirement is, if the due date of the POs are same in MD04 system should create one delivery for the all these POs. On the contrary system is creating separate deliveries.
Please let me know why is it happening and what could be the reason for the creation of separate delivery documents।
Answer
“For stock transport Order it gets set from (Customer master sales area --shipping tab).
1 The Customer was NOT set for order Combination
2 The order Combination tick in Purchase order Item Level should be set (For all the POs which needs to be combined)
For stock transport Order it gets set from (Customer master sales area --shipping tab), so the customers should be set for Order Combination “
PLease log your SD issues on http://www.sapexplore.com/
Tuesday, June 10, 2008
www.sapexplore.com (Currently for SD consultants)
1 You can track your Issues and monitor the status.
2 You can raise tickets/calls as per the priroty and get it solved by Experts
Please log on to www.sapexplore.com
Regards
Faraz Mohsin
Friday, May 2, 2008
Items blocked in a Sales Order
A Sales order is made for certain items whose stock is available. Then the few materials are deleted from this sales order and the remaining ones are delivered and invoiced.
On creating another sales order for those deleted items, system prompts a message that these items are blocked against a sales order. How to release the stock and do the delivery. ?
Answer
In SE38 execute the program SDRQCR21 . Enter the line item which is blocked for sales order in MD04 and enter plant then check the data
Wednesday, February 20, 2008
Regression Testing
Common methods of regression testing include re-running previously run tests and checking whether previously fixed faults have re-emerged. Although this may be done through manual testing procedures using programming techniques, it is often done using automated testing tools. Such a 'test suite' contains software tools that allow the testing environment to execute all the regression test cases automatically; some projects even set up automated systems to automatically re-run all regression tests at specified intervals and report any regressions.
Types of regression
Local - changes introduce new bugs.
Unmasked - changes unmask previously existing bugs.
Remote - Changing one part breaks another part of the program. For example, Module A writes to a database. Module B reads from the database. If changes to what Module A writes to the database break Module B, it is remote regression.
There's another way to classify regression.
New feature regression - changes to code that is new to release 1.1 break other code that is new to release 1.1.
Existing feature regression - changes to code that is new to release 1.1 break code that existed in release 1.0.
Thursday, February 7, 2008
Tax Determination- A doubt
Now for some some states tax is calculated on the net price i.e. $100 , and for some some states it is on gross i.e 120$. How would this configuration be done.
We can use two tax codes to pick different tax percentage value, but how do we configure on what base price the tax percent is applied i.e. on net or on gross.
Thursday, January 24, 2008
A complex Pricing Scenario.
There are six items in a Sales order X,Y,Z in one group and A,B,C in another group. Groups are divided by the routes.
X,Y,Z belong to one route Z0001 and
A,B,C belong to another route Z0002
Now Price is is calculated not by the quantity but by the weight of each material.
The logic is
If the total weight of all the materials in a group is less than equal to 100gm, the price would be 10000 Rs.
If the total weight of all the materials in a group is more than 100gm then sum of the material weight should be multiplied by a fix price 150 to get the price i.e. if X+Y+Z= 200 then 200*150= 30000 Rs.
Same Logic applies for the another group of materials.
The story does not end here. When both the group prices are calculated system should sum both the group prices and give this as the final price of the Sales order.
Please do not tell me that use a routine. I'll appreciate if you can explain the routine logic in detail.
Monday, January 14, 2008
Transportation- Case Study (Real Time Scenario)
In SAP SD Transportation Module do we have an option to measure the transportation costs involved amongst many transportation modes available.
Here is an example
Transp Agent Total Cost during Transportation(Transportation + Inventory )
FA Rails 186900$ annual
Golden Agent 154320$ annual
Blue Star 176820$ annual
The issue here is can the SAP system choose the lowest total cost model offered by various Forwarding Agents.
Friday, January 4, 2008
Please post your questions/doubts(www.sapexplore.com)
Your doubt/s may need detail explanation so drop in your email id also.
Now post your doubts at www.sapexplore.com
Monday, December 31, 2007
Friday, December 28, 2007
SD Billing
1 Billing create billing documents for orders and deliveries
2 Billing update the document flow and billing status
3 Billing do not update the credit account
4 Billing create documents in FI and forward data to Profitability analysis
Friday, December 21, 2007
What skills can take you to become a Project Manager
1 Communication Skills
2 Relevant Expereince
3 Technical ability
4 Convincing ability
5 Team Managment skills
Its obvious that all of the above are important but how would your rank it.
Tuesday, November 27, 2007
Which of the following about Pricing Procedure Determination is correct
(b) Prices cannot be changed in the condition procedure of a sales document but you can add prices manually to a sales document
(c) You cannot prevent manual changes to condition types in the condition procedure of a sales document
(d) Header conditions can be entered manually at header level and is valid for all items
(e) Header conditions will be automatically distributed proportionally across the items based on net value. The basis of the distribution cannot be changed in the pricing procedure.
Answer thru your comments.
Saturday, November 17, 2007
Tuesday, November 13, 2007
Release Strategy-Pricing
Monday, November 12, 2007
Pricing: Real Time Scenario
Field contents :
Routes, delivery priorities, transportation zones, and transportation planning point.
We have to create a table ZCustom with the above fields and add this field into the Field catalog.
Access Sequence would be
0001: Routes/deliverypriority
0002: tzone/Tpoint/route/delivery priority
Pricing Routine Requirements
A pricing routine is required to calculate the pricing condition value.
Routine -911: If a condition type Pr00 = 0 then move the condition value of PR01 into Pro0 . Both these condition types will use the above access sequence and both are Basic Prices.
Questions:
1 How would you proceed to add fields in the field catalog after creating the custom table
2 Where would you encapsulate the above routine i.e. in Alctype, Req or Cndbase value and against which condition type Proo or Pro1
Its a real time case scenario, please assist .
Wednesday, November 7, 2007
GAP Analysis
Actual gap analysis is time consuming and it plays vital role in blue print stage.
The Gaps can differ from company to company. Most commonly, however, missing functionality is industry-specific.
Examples
In customer master data the client requirement needs legacy customer number which can be solved with User exit.
In sales order we need customer Phone number, we can use user exit
If client want new field in customer master like nearest fire station.
GAP analysis is done in Blue Print stage. It aims to understand what can be done with the standard SAP and how the client actually wants a particular scenario to be processed.
It’s an understanding of the GAP between the actual & required scenarios.
E.g.: To Fill This Gap, We Use The Enhancements,These Enhancements Divided Into Exits, Like User exits, Field Exits Screen Exits & Menu Exits.These Enhancements are used to update the standard program in its Respective Business Transactions, Used as a Gateway to Meet the Client Requirements.
User Exits
Go to SE81 and select the relevant module find the enhancement.
Go to the program or transaction and search for “CALL CUSTOMER-FUCTION” or “EXIT_
For screen exits go to screen in SE51/SE80 search for- “CALL CUSTOMER-SUBSCREEN..”
User Exits: These are subroutines used in the SAP namespace 'hard-coded' at various points within SAP Repository objects.
Customer Exits :
1. Menu Exits: Menu exits add items to the pull down menus in standard SAP applications. You can use these menu items to call up your own screens or to trigger entire add-on applications. These special entries have function codes that begin with "+" (a plus sign).
2. Screen Exits: Screen exits add fields to screens in R/3 applications. SAP creates screen exits by placing special sub screen areas on a standard R/3 screen and calling a customer sub screen from the standard screen’s flow logic. It is called by call customer- sub screen
3.Function Module Exits :Function module exits add functions to R/3 applications. Function module exits play a role in both menu and screen exits. When you add a new menu item to a standard pulldown menu, you use a function module exit to define the actions that should take place once your menu is activated. Function module exits also control the data flow between standard programs and screen exit fields.
It is called by Call Customer- function
Tuesday, November 6, 2007
Some basic questions
2 What is the difference between itemcatgory group and general item category group?
3 Under what business scenarios do we have to use condition types for both header and item level.
Thursday, September 27, 2007
Meaning of "FORM KOBED_002" and "FORM KOBEV_002
FORM KOBED and FORM KOBEV are just the two FORMs under which the formula is encapsulated for picking the price which I have already explained in http://sapdude-sapsd.blogspot.com/2007/06/pricing-procedure-under-requiremnt.html
Whenever a coding is done or a formula is written we do it by using FORMS. The purpose of encapsulating the code under a FORM is because we should have an option to call the same Form in the some other requirement. So instead of writing the program all over again we justcall the Form with its name.
KOBED_002 and KOBEV_002 are just the name given under which the Formula is written.
Being a Functional consultant we do not have to worry about the coding part but these FORMand ENDFORM contains the relevant formulaes for the specific business requirement.
In the above case FORM KOBED_002 the formula written under it means that system would first check whether the item category attached for an item in that condition item number in SO is relevant for pricing or not.
Do revert for further clarifications.
Friday, September 21, 2007
Alternative Calcultation Type
When a material is sold, it should not be sold for a price below the predefined minimum price. When pricing is done for a sales document line item, if the net price of the item falls below the minimum, the system should automatically compute a surcharge to bring the price up to the minimum price. To accomplish this, the user would define the minimum prices using the condition type PMIN. PMIN would be defined in the pricing procedure and condition value formula '15' would be assigned. Using the formula, the system compares the minimum price with the net price calculated to that point in the pricing procedure. If the minimum price is not met, the system computes the necessary surcharge and assigns it to the PMIN condition line.
Routine /Formula :- 48
Formula '48' was delivered to ensure that the down payment amount the user offsets in a billing document does not exceed the actual down payment value. Condition value formula '48' is assigned to the condition type in the pricing procedure representing down payments (R/3 delivered condition type AZWR).
Let me know for any further clarifications.
Note: All, please do not copy and paste my posts into your blogs to avoid blog frauds and legal actions.
Friday, September 14, 2007
Interview Question (Pricing)
1. What is condition supplement and why is it used , also how is it configured.
2. If there are two customers, for one customer 10 condition types are mandatory and for the other only two. How would we configure this if we have to map it with one pricing procedure.
3. Order types, why do we need to create our order types and not use the standard ones during implementation.
4. What is group conditions used in condition type/s
5. What is the pricing header and item table name
If you know the answers post them through the form of comments.
Saturday, September 8, 2007
Picking option in display
I am trying to create delivery but the picking option is in display" why?
Hi Mandeep,
The probablity says that you must be trying to create the delivery with standard data, the picking option is greyed out because the delivery needs shipment and picking would happen through creation of shipments (VT01N) or through transfer order (LT01). The standalone delivery document would not allow you to create picking.
IF you do not have idea bout shipments and transfer order let me know , will post it later.
Thursday, August 23, 2007
Standard Pricing Procedure
Availability Check
AC is determined by checking group and checking rule
Checking Group = A check+ Total Sales + Total Dlv Requirement + Block QtyRq + No Check + Accum
Av Check is defined in MRP3 in Material Master (Discussed below)
Total Sales = Single Records or Total Records per day or Total records per week
Total Dlv Rqs = Single Records or Total Records per day or Total records per week
Block QtyRq = This block is used if several users are able to process the material simultaneously in different transactions without blocking each other.
No Check = This indicator switches off the availability check according to ATP logic for the checking group concerned
Schedule Line and Requirement Type is determined by Item category and MRP Type
Following are the relevant fields required from Material Master to run Availability Check.
MRP1
MRP Type –PD
VB - We have to define, re-order point, safety stock etc. In manual reorder point, you must define the reorder point (and eventually the safety stock) according to your criteria. For automatic, these values are estimated by SAP as a function of the forecast (coming from historical data), so the base-quantities for the calculation of the reorder are not fixed but dynamic.
Lot Size – 10
MRP 3
Strategy Group-
10 – Make to Stock
20 – Make to Order
70 – Planning at Assembly Level
30 – Production only with Sales order (Demand Management entry ignored during MRP run)
Availability Check
1 Daily Requirement
2 Individual Requirement
3 Rep- Lead Time
4 Current Stock
KP No Check
Sales/General Plant
A/Check Availability check field (on the MRP screen and the Sales: General/Plant screen) so that you can perform an availability check with replenishment lead times (01 in the standard system).Item category group (for example, NORM) on the Sales organization screen
Friday, July 27, 2007
Accounting Entries generated during Sales cycle
Cost of goods sold account Dr
Inventory account Cr
(This entry is passed by the cost of the item delivered)
b) During generation of Invoice
Customer / Debtors account Dr
Sales/Revenue account Cr
Taxes Cr
(This entry is passed by the selling price)
c) During collection of Payment
Bank account Dr
Discount Dr
Customer/ Debtors account Cr
(This entry is passed by the amount collected and discount given to customer)
If we are using the clearing system then istead of bank account, clearing account will be debited.
Thanks Rajesh for letting us know the absolute accounting entries
Thursday, July 26, 2007
Deletion of Sales Documents
Is it possible to delete the sales orders, if no subsequent document is created. I have tried it, but unable to delete it. Again for the delivery document, if there is no subsequent document, then can we delete the delivery document ?
Hi Bala,
You can no doubt delete the sales order using transaction VA02, but there should not be any subsequent document is created against it. Please let me know the error message you are still getting unable to delete so.
Deletion /cancellation can only happen even if the subsequent documents are NOT created. As sudhir might have rightly said Sales Order with subsequent documents cannot be deleted. After cancelling the invoice and deleting the delivery document, we can set the reason for rejection at the Sales Order Header Level.
Steps:
1. Cancel the invoice through T code VF11
2. Reverse the Goods Issue using VL09, turn the pick quantity ‘zero’ in the delivery document
3. Delete the delivery document using VL02n.
4. Finally set the reason for rejection at the Sales Order Header Level. (So Bala, just check the SO you want to delete ever had any subsequent document? )
SAP FI department needs to reverse the accounting doc on a real-time scenario. Only after the accounting doc is reversed invoice can be canceled. Tax documents generated through the Invoice (Tax is maintained on a separate account) also need to be reversed but this is a part of FI so an SD consultant just needs to request the FICO guy to do the reversal.
Let me know through your valuable comment/s if the question is still left unanswered. Thanks Sudhir for your inputs.
Tuesday, July 24, 2007
SAP SD demand graph in UK
Credit/Debit Memo Request
Definition: A credit memo request is a sales document used in complaints processing to request credit for a customer.
Use: If the price calculated for the customer was too high (for example, with the wrong scaled prices or because a discount was forgotten), you can create a credit memo request. The credit memo request can be automatically blocked for checking. Once it has been approved, you can remove the block.
The system uses the credit memo request to create a credit memo.
Structure: A credit memo request is another type of sales document like a standard order. For more information on sales documents, see Working with Sales Documents.
A credit memo request starts the billing process.
Debit Memo Request
Definition: A debit memo request is a sales document used in complaints processing to request debit for a customer.
Use: You can create a debit memo request if the prices calculated for the customer were too low (for example, if the wrong scale prices were calculated). The debit memo request can be automatically blocked for checking. Once it has been approved, you can remove the block.
The system uses the debit memo request to create a debit memo.
Structure: A debit memo request is another type of sales document like a standard order. For more information on sales documents, see Working With Documents.
Integration: A debit memo request starts the billing process.
Creating Credit or Debit Memo Requests
Purpose: Creating a credit or debit memo request enables you to create credit or debit memos based on a complaint.
Process Flow:
Create a sales document with the order type for a credit or debit memo request. You can create the debit or credit memo requests in the following ways:
– Without reference to an order
– With reference to an existing order
Here you enter which order the complaint refers to.
– With reference to an invoice
Here you enter which invoice the complaint refers to.
In all cases, you specify the value or quantity that should be in the credit or debit memo.
You can block the credit or debit memo request from being billed in Customizing. Go to Sales --Sales Documents -- Sales document header --Define sales document type and select the billing block field in the billing section.
This request can later be reviewed along with similar ones, - if necessary, by another department. The request for a credit or debit memo can then be approved or rejected.
The following graphic shows the document flow for creating a credit memo or debit memo request. The broken line means that the request does not necessarily have to refer to a preceding document.
Result: Once the credit or debit memo request has been approved, you can create a credit or debit memo.
Creating Credit and Debit Memo Requests
Prerequisites: You can enter a credit or debit memo request in one of the following ways:
Without reference to a preceding document
With reference to a preceding document, such as:
Sales orders
Contracts
Contract release orders
Billing documents
CR for credit memo requests
DR for debit memo request
The following entries are important for creating a request:
Customer number of the business partner who requests a credit memo or to whom a debit memo is to be forwarded
Order reason (why the request is necessary)
Material and the quantity in the request
If the credit memo request refers only to part of the billed or ordered quantity, you can adjust the target quantity in the credit memo request accordingly. If you enter another credit memo request with reference to the billing document or the underlying sales order, the system informs you of the quantity which has already been credited.
Result: After you have released a credit or memo debit request, you can create a credit or debit memo.
Wednesday, July 18, 2007
Partner Determination
Wednesday, July 11, 2007
Questions July'07
Please post the questions under this link for the month of July in the form of comments. My aim here is to answer a question in a single response via separate topic at the left of the blog, covering all the aspects of the question asked.
Thanks for posting questions.
Tuesday, July 10, 2007
Payment Terms
Answer
In the above scenario, we can choose payment terms as one of the fields in the condition table: Payment terms can be defined as follows:
NT21 Within 21 days Due net (For NT21 the customer would get 10% discount)
NT30 Within 30 days Due net (For NT25 the customer would get 5% discount)
Upon selecting the relevant payment terms system would determine the percentage discount in the document.
------------------------------------------------------------------------------------------------
Now If the scenario is 'unless the customer pays the amount, payment date is not known hence we don't know which payment term to use and which discount to apply' as u mentioned. e.g.
e.g. payment terms => 21 days 10% cash discount; 30 days 5% cash discount
The condition category E cash (in V/06) discount tells the system to go get the payment terms and calculate the potential/actual value i.e. 10% within 21 days and 5% within 30 days.
Based on the differing payment terms while payment, Invoice value will not change and would be the same, but SKTO will correct the value and discount is calculated in A/R instead.
Sunday, July 8, 2007
Delivery Group (Complete delivery)
Complete delivery: e.g SO has two lines, for first item 'ABC' delivery date is 01-Jul and for sec item 'DEF' delivery date is 11-Jul. And del job VL04 runs daily. So my req is when VL04 runs on 01-Jul, del should not be created, but it should create a complete delivery on 11-Jul.
Hi Deepak,
In the above question we have to use the logic of delivery group under shipping tab in the sales order. The system uses delivery groups to check the availability of items that should be delivered together. The delivery date of the latest schedule line in the delivery group is taken as the general date for the whole group.
So in your case if you give a common delivery goup e.g. '01' to both of your line items system will deliver them together on 11-July. As far as my knowledge goes there is no automatic determination of delivery group, we have to enter the delivery group manually in the sales order. In case you find any alternative solution please do let me know.
Note
If an item has more than one schedule line with a confirmed quantity, then the system deletes all undelivered schedule lines up to the last one. The system automatically carries over the quantities from the deleted schedule lines into the last one. If necessary, the system changes the delivery date of the last schedule line to that of the delivery group.
Friday, June 29, 2007
Storage Location Determination
Mat 'ABC' is stored in plant 'PLA' in two different storage locations 'STR1' and 'STR2'. On creating a SO which storage location, will it pick and why??
Hi Deepak,
Let me explain you first how the storage location is determined
Storage location is determined at the delivery document by storage location rules viz MALA, RETA or MARE
The most commonly used one is MALA.
One rule is defined against a Delivery type (ref: check in TC : 0VLK - Delivery type LF)
MALA is determined as below:
STORAGE LOCATION = SHIPPING POINT + PLANT + STORAGE CONDITION
RETA = PLANT + SITUATION + STORAGE CONDITION
MARE = MALA then RETA (First MALA will be applicable failing to find this rule, system will trace for RETA)
Check which rule is applied to the delivery type.
So if MALA is used for storage location determination then based on the parameters defined for shipping point, plant and storage condition system will pick the storage location.
We set Storage location determination under Shipping -->Picking-->Determine Picking Location-->Assign Picking Locations
But COPY CONTROL also plays its role in copying the storage location in the delivery document if it is created w.r.t. the SO. (Ref: TC: VTLA under Item data one routine is defined viz. “101”)
Please have look at the below portion of “Routine 101”
IF CVBAP-LGORT NE SPACE. (LGORT = Storage location)
LIPS-LGORT = CVBAP-LGORT.
ENDIF
IF NOT CVBAP-CHARG IS INITIAL.
LIPS-CHARG = CVBAP-CHARG.
ENDIF.
Coming back to your question, above portion of SAP standard routine 101, explains us if in a SO, storage location is blank, storage location will be picked determining the rule e.g. MALA, and if SO has a value for storage location then LIPS-LGORT = CVBAP-LGORT. (LIPS is delivery at item level and VBAP is SO at item level)
* SO = Sales Order
Thursday, June 28, 2007
Routine "2" : Requiremnt colum in Pricing Procedure
Requirement: Denoted by numbers and maintained in VOFM, this is a condition required for a particular condition type.
E.g. PR00: req. 2 i.e. item relevant for pricing or not.
* Pricing is turned on in item category configuration
FORM KOBED_002.
SY-SUBRC = 4.
IF KOMP-KPOSN NE 0 (KOMP- Pricing Communication Item KPOSN -Condition item no. in SO)
CHECK: KOMP-PRSFD CA 'BX'. (PRSFD - PRSFD Carry out pricing)
CHECK: KOMP-KZNEP = SPACE. (KZNEP -Condition exclusion indicator)
ENDIF
SY-SUBRC = 0.
ENDFORM.
* Prestep
FORM KOBEV_002.
SY-SUBRC = 0.
ENDFORM.
For techi’s above program is self explanatory
Explanation:
The above routine “2” is included under Req column in Pricing Procedure. It means that system would first check whether the item category attached for an item in that condition item number in SO is relevant for pricing or not.
If the Item category is pricing relevant only then system will go to VK11 and fetch the price. On the contrary if req. column does not contain 2 as routine against a condition type system will not consider this parameter and would directly jump to VK11.
This routine improves system performance
Note: If an item category marked as NOT relevant for pricing system will not fetch price in the Sales order even if the condition records for the condition types are maintained.
Please let me know in the form of comments should you have any query.
Friday, June 22, 2007
Support Environment
• Taking Ownership of the call coming in the form of ticket
• Resolving a call
• How to reassign a logged call to the next support level
• Interaction with the next Level support.
Tuesday, June 19, 2007
Please post your questions here
Pl post your questions in SAP SD in the form of comments under this subtitle and I'll get back with an answer as a different post asap.
Faraz