Category Archives: SAP SD

Functional Specification Documents

Interviewer in hashtagTCS asked me about Functional Specification Document Contents

A Functional Specification (FS) document in SAP is a detailed description of the RICEFW requirements penned down in document. It connects what the business needs with the technical details, making sure the development team knows what to build and how it should function.

Here are the main contents of a Functional Specification document:
📍 Title and Version Control
📍 Introduction
📍 Business Requirements
📍 Functional Requirements
📍 System Requirements
📍 Screen Layouts and Prototypes
📍 Validation and Error Handling
📍 Reporting Requirements
📍 Security and Authorization
📍 Dependencies and Constraints
📍 Testing Requirements
📍 Glossary

A well-written Functional Specification document helps ensure that everyone involved in the project understands what needs to be done and how to achieve it, leading to successful project outcomes.

SAP SD REAL TIME TICKETS

 

**We had an issue, like not to print invoice for some select customers.

We create invoices through billing due list and spools are generated there after which are again printed at a later stage. Running billing due list VF04 and printing spools is all done by batch job and this happens for more than 2000 customers.

Now the issue how to identify those few customers who do not require invoice the regular way. We bill them through their websites.

solution was, in the customer master data, we have additional data in the menu, there you have freely definable fields. Here i have maintained an indicator NP (not to print invoice). The driver program of invoice, checks this indicator before it creates a spool, so it does create a spool. Others who dont have this are processed the regular way.

But i have a small suggestion, pl do not prepare for interviews in a hurried manner. Understand the subject by concept and try to simulate the issues discussed in this forum which gives you an idea of real time scenarios. All the best.

==================================================================================

**Examples of Tickets, 1) Billing Document not released to accounting / Accounts determination:

To resolve the error, you can analyze account determination in the billing doc.

Process:

Go to T.Code: VF02 & Enter Invoice number

Next (On the top most strip) go to Environment

Next (Select Environment) go to Account determination

Next (In Account Determination) select Revenue Account Determination (first option)

 

This will list all the condition types in the Billing document & analyze each condition & check for which G/L accounts is not determined.

 

 

Possible errors:

  1. VKOA not maintained for required combination

Solution: Maintain the combination in VKOA.

 

  1. Account Assignment of Customer / material not maintained in Customer / Material Master (If maintained in combination in VKOA).

Solution:

Option 1 (Standard solution): step 1: Cancel Billing Document –> Reverse PGI –> cancel Delivery –> Cancel Sales Order

step 2: Maintain Customer master / Material Master correctly.

step 3: Recreate sales order –> Delivery –> PGI –> Invoicing.

Option 2:

Force the Account Assignment Group of Customer / Material through Debug in change mode of Billing document, which will release Billing Document to Accounting.

 

================================================================

2) Account Key not maintained in Pricing Procedure:

Impact: This may create accounting document, but if condition type, which are to be posted to account, but do not have account key maintained in pricing procedure, it will not be post the relevant condition type to G/L account.

FI consultant requires to take corrective action.

================================================================

 

 

***Billing Document not being released to accounting:

In Material Master, there is some link between Profit Centre & MRP Type. If one of it is not maintained, erratically few documents get stuck while releasing Billing Document to accounting. Few of course get posted.

Solution1:

Cancel Billing Document –> Reverse PGI –> Cancel Delivery –> Block the sales Order & Create new sales Cycle all over again after rectifying Material master.

Solution 2:

(Temporary Solution) In Debug mode in Billing, force the Profit Center in Billing Document with the help of ABAP-er. But ensure Material master is rectified.

From FI Side, you require to check that all the G/L account has been maintained through T.Code: FS00.

G/L account being Master data has to be created in each client to upload through LSMW / SCATT / BDC.

In Billing Document in change mode (in the first screen where we enter Billing Document number), on the top most left hand corner, take a dropdown on Billing Document & select Release to accounting. Here you can get the under mentioned possible message:

 

  1. G/L account not found
  2. Cost Element not maintained for G/L account.

 

FI consultant requires to take corrective action.

=================================================================

4) Issue: End user not able to create sales order:

End user is not able to create Sales order for a customer from a new plant, since shipping point determination is not happened. (Without Shipping point the document becomes INCOMPLETE and he will not be able to proceed further like DELIVERY, BILLING).

Possible errors:

SP configuration not done for the new plant.

=============================================================

 

5) Issue: Pricing not determined

Possible cause: Customer pricing procedure left blank in customer master –> sales area data –> sales tab.

=============================================================

 

6) Issue: Data not flowing to standard reports

Possible cause: Customer statistic group left blank in customer master –> sales area data –> sales tab.

 

=================================================================

7) Issue: Unable to select Sales Area for Customer Master Creation

Possible cause: Most Probably either sales area is not defined or customization not done for common Sales Org & Common Distribution Channel.

To maintain this configuration: SPRO –> Sales & Distribution –> Master Data –> Define Common Distribution Channels / Define Common Divisions.

 

=============================================================

SAP SD BUSINESS WORK FLOW PROCESS.

  1. Define the Material in ECC system and push the material from ECC TO HYBRIS system ( E- commerce system ).
  2. Here the HYBRIS team perform some enrichment and mapping process, they define the price, surcharge, discount, tax and freight on product at HYBRIS system.
  3. Mapping is done through PIPO SAP that is work as a middle ware between two system.
  4. Order is created first in HYBRIS system & flow in ECC using Inbound IDOC with the help of ALE, EDI Tools.
  5.   Once the order is Submitted to ECC system by HYBRIS system then IDOC is converted into order through various process like:
  6.  Automatic order creation and background batch job to create order in ECC System.
  7. when we have a fully automated system in ECC, once order is completed & then another background batch job create the delivery document.
  8. from delivery order, system automatically create the outbound IDOC number in background that is send to 3 PL ( Third party logistics , external warehouse management system).
  9. They perform picking and PGI Process through IDOC , this IDOC is send to ECC system where it is updated into delivery IDOC in SAP with picking quantity & PGI date.
  10. Then we have a another background batch job in our ECC system that is fully automated, they perform the all delivery process in the background.
  11. Then finally billing is created also through background batch job.

Find IDOC Number from Sales Order Document in SAP

In case sales orders are created automatically using IDOC documents via ABAP programs in your SAP system, you may want to get IDOC number from SAP sales order. Normally, using Relationships menu option on Services for Object icon on VA02 and VA03 sales document screen will let the SAP professionals to reach the related IDOC documents. But if you cannot display Services for Object on your sales document transaction screen, you can use one of the methods to find IDOC number using Sales Order number in your SAP system.

WE57 transaction can provide information about business object type, message types, etc in case you don’t know existing information about the IDOC structures in your company.

Although it is not so handy, if you can filter IDOC list to a limited number on WE02 transaction code screen, you can check each IDOC for their status 53 record and control if it has the IDOC containing the sales order number you are looking for. By using filtering criteria Created On and Created At date time selections, processing Direction, Current Status (status 53 includes the sales document number so use 53 for filtering), Basic Type and if possible Partner Number you can limit your search results for a manual check on IDOC status documents.

 

Services for Object

If you can see the Services for Object icon next to SAP VA02 or VA03 transaction title as seen in below screenshot, then you can easily display the IDOC which created the current sales order.

Services for Object function on SAP Sales Order document transaction

Click on the right-side of the icon, a dropdown menu will be displayed. Choose Relationships.

Sales Order Relationships to list IDocs for a given sales document

This option will lead you to the IDOC list related with this sales document. You can easily open Idoc by double click on the item and display its segments.

On the other hand, if you do not see the Services for Object icon on the VA02 and VA03 screen menu, if you can modify your User Profile Parameters add SD_SWU_ACTIVE parameter (Activate Workflow Box in VA02 & VA03) with “X” value to enable this function on Sales Order display and change screens.

 

On main screen, by menu options apply following selections:
System > User Profile > Own Data

Add parameter SD_SWU_ACTIVE with value X to Activate Workflow Box in VA02 & VA03

activate workflow box on sales order transactions

Now follow the above method to reach Sales Order related Idoc list.

BD87

To find the IDOC number used to create sales order, ABAP developer or SAP professional can use BD87 SAP transaction.
Launch BD87 tcode.

When Select IDocs selection screen is displayed, for sales orders enter BUS2032 for Business Object and sales order number (VBELN) you are interested in Object Key field.
You can also limit the results by entering the Message Type as ORDERS.

 

An other selection parameter that you can use is the IDoc Status field with value 53 (Application document posted).
Also you can provide date range for created on or changed on fields.
Then execute the report.

SAP BD87 transaction for IDoc from Sales Order document

Drill down IDOCs in inbound processing node. Under ORDERS, you can see an information message that sales order document with given number is saved.

get Idoc number using Sales document in SAP

Double click on the leaf item.
This will display the IDOC number as seen in below screenshot.

IDoc document created specific sales order in SAP

Launch SAP transaction WE02 and using IDOC number you found from BD87 tcode, you can display the IDOC details which is used to create the referred sales order document.

SAP transaction WE02 for IDoc segments in detail

SREL_GET_NEXT_NEIGHBORS Function Module for IDoc Document

Executing ABAP function module SREL_GET_NEXT_NEIGHBORS with IDoc number and business object type developers can get a short list of IDoc documents.

The Object input structure values could be set as follows:
OBJKEY is the Sales Order document number with leading zeros if any.
OBJTYPE is BUS2032 for sales orders.
And you can provide or choose not to enter your SAP system id in LOGSYS field.

 

When you execute the ABAP function module SREL_GET_NEXT_NEIGHBORS with accurately provided OBJECT parameter, you will get the IDoc list in Result table.

ABAP function module SREL_GET_NEXT_NEIGHBORS

Query EDIDS IDoc Status Record Table for IDoc Number

For ABAP programmers, another option to find IDOC number using the Sales Order document number is filtering EDIDS (IDoc) Status Record ABAP table using SE11 or SE16 transactions.

First of all, again most important parameter is log date LOGDAT selection parameter. Keep it as limited as you can.
Then STATUS should be 53.
STAPA2 parameter 2 has the sales order number. So enter your sales document number here without preceeding zeros.
STATYP status type will be successful, so enter S for this parameter.

SAP EDIDS IDoc Status Record Table for IDoc Number from Sales Order

WE09 Transaction to Find IDoc Number from Sales Order Document

Using WE09 transaction is another method for searching IDOC number, if you have specific values about the order that take place in the IDOC segment fields.

IDoc search for business content

By entering especially create date and time, processing direction, IDoc status, basic type etc. you can limit the search results of your query.

With related to IDOC document, provide an additional criteria with a segment name and field name which can have a specific value related with the sales order.

Search in IDoc segments using WE09 transaction

ABAP developer or SAP user can also use this section to search IDOCs for a spesific value in a certain IDOC segment field.

Result will be as follows. Please note that the search can take long time especially for wide search criteria.

IDoc search using ABAP WE09 transaction screen