Skip to main content

Posts

Showing posts from 2017

Material Master Fields - Basic Data

Base Unit of Measure It is the smallest unit of measure in which stocks of the material are managed. Ex. Each, Piece etc.. Alternate unit of Measure It is the unit of measure which can be available besides base unit of measure. For instance: If the sales unit of measure is different than that of the base of the unit of measure then an alternate unit of measure is being used. Gross / Net Weight  The weight of the material maintained in this field will be carried over to the sales document item-level data. Old Material Number Legacy system Material Number will be maintained in this field.We can use the old material number to systematically search for material master records via match codes (Search Help) General Item Category Group This helps the system to determine item categories during the Inbound delivery process. This field is used as one of the parameters during item type determination at sales document or inbound delivery level. Material Group  Ideally

Schedule Line Category

A schedule line consists of confirmed delivery quantities and corresponding confirmed delivery dates. This provides us info regarding when the delivery can take place. Delivery Block : A delivery block can be maintained at Sales Document level and Schedule line Category level. Delivery block maintained at schedule line category level will be proposed at schedule line level of the sales order. Movement Type  Any movement of goods both physical or logical will be captured in the form of movement type in This controls the inventory update and generation of accounting document. The SD module uses goods movement from 601 to 699. All goods issues to customer from unrestricted stock will be performed through Movement type '601' All customer returns will be captured through 651 601 GD goods issue:delvy 651 GD ret.del.  returns 653 GD returns unrestr. 655 GD returns QI 657 GD returns blocked 641 TF to stck in trans. 643 TF to cross company 645 TF cross co

Sales Item Category Controls - Part 2

Pricing Indicates whether the system automatically carries out pricing at the item level. Blank No pricing This is used for Text items and Items not relevant for pricing scenarios X         Pricing standard The system carries out pricing for standard items in a sales order. A         Pricing for empties B         Pricing for free goods (100% discount) This is used for free Goods Items Schedule Lines Allowed Schedule lines determines the delivery date and quantity. Enabling this check box, Will display schedule lines at sales order item level else schedule lines tab will not be displayed  For standard item, schedules lines exists but where as for text or service items this is not required to be enabled as schedule lines are not required. Item Relevant for Delivery This checkbox is enabled for the items which don't have schedule lines and require delivery processing. Ideally, this is used for text items and Value Items. It serves only fo

Sales Item Category Controls - Part 1

An item category controls the behavior of an item and below are the controls which defines the item category. Item Type : A way of classifying items that require different kinds of processing by the system. The system processes items that refer to a specific material differently than items that do not refer to a material. For example, text items do not require processing for pricing, taxes, and weight calculations Below are the common item types used in SAP. Blank Standard Item Business generally uses standard items in SAP. The pricing for a standard item takes into consideration the change in quantity, weight, volume, and time units associated with the material. A         Value Item SAP provides value items for scenarios where you bill your customer for the goods or services rendered. B         Text item Text items are generally used for sending print materials such as flyers, catalogs, and so on, to the customer. These items are generally not billable to th

Interview Questions - SD Enterprise Structure

1.What is a Sales Organisation? 2.What is a sales office in SD Module? 3.What is a division in SD Module? 4 What is a shipping point? 5. What is a distribution Channel? 6. What is a Division? 7. What is the highest level Org. Unit in SD Module? 8.What is a Sales area? 9. What is a Sales Line? 10.What is a Distribution Chain? 11. What is the relationship between Company and Company Code? 12. What is the relationship between Company Code and Plant? 13. What is the relationship between Plant and Sales Organisation? 14. What is the relationship between Company Code and Sales Organisation? 15. What is the relationship between Sales Organisation and Distribution Channel? 16. What is the relationship between Sales Organisation and Division? 17.What is the relationship between Sales Line and Plant? 18.What is the relationship between Sales area and Sales Office? 19.What is a Sales Group? 20.What is a relationship between Sales Office and Sales Group?

Sales Document type field control - Part 2 General Control

Reference Mandatory If the business requires to create a sales document only by copying it from an existing document then leverage this field. For instance, if the business requires creating sales order only with reference to a quotation document or Inquiry document then we can select either choose 'B' or 'A'  here for quotation or inquiry restrict sales document from getting created standalone. You can set up the SAP system to create a new sales document with reference to the following: A: inquiry B: quotation C: sales order E:  scheduling agreement G:  contract M:  billing document Remember that a selection in this field will only make it compulsory for the document to refer to an existing document.  Copy Control Settings : This will have a dependency on the copy controls as the actual flow of data between the two documents will happen once it is maintained. Item Division :  When selected, it allows the item division t

Status Profile - Sales Documents

This concept is similar to release strategy concept at purchasing level. At times, the business user requires approval to proceed with the next activity of the sales process upon approval from senior executive or manager. This approval process can be set up to status profile concept. The status profile can be used in the various component such as Sales, QM, PP etc. In the below case, We will discuss the application of the status profile in sales and distribution module at sales document type level. This is ideally used during complaints processing such as returns, Credit Memo Request etc.. In Sales documents, we can maintain the status profile at Sales document header and Item level. Here we will discuss regarding the maintenance of the sales document at Header level. Below is the config setting need to be maintained : Goto T.Code BS02 and click on create Based on the approval levels maintain the statuses. In the below instance I have taken two levels of approval to

Incompletion Log functionality

This is used to instruct system, On how to respond in case of any sales document, delivery document or Billing document should be regarded as incomplete. Below are the areas in which we can maintain incompleteness procedure. Sales document header data Sales document item data Sales document schedule line data Sales activity data Partner data in sales documents, deliveries and sales activities Delivery header data Delivery item data Configuration settings : Define Status Group Define Incompleteness procedure Assign incompleteness procedure to document type Status Group: This states the function at which we can block a document like delivery, pricing, billing, picking, and packing. if we enable delivery field in the status group then in case of an incomplete document then the system will restrict business from the creation of delivery document until the sales document is complete. Likewise, we can maintain block at different levels as mentioned above

Sales Document type field control - Part 1

Sales Document Type:  This field represents the identifier and description for the sales document type. We can define our own sales document type starting with characters 'Y' or 'Z'. As a best practice, it is always good to copy the existing document type and create a new one referencing it. Sales Document Category : This classifies different types of sales documents that we can process in the SD module such as Inquiry ,Quotations, sales orders, deliveries, and invoices. The document category determines how the system stores and keeps track of document data. It enables the system to provide you with status information about delivery processing, billing of the sales document. When you create your sales document via the copy with reference option, this category field enables the SAP system to provide the status information about th

Text Determination functionality

Ideally, whenever business requires communicating internally to other teams regarding special packaging for a customer, Shiping instructions, Delivery terms etc. in this situation text determination functionality is used. For instance : if the business user of sales team requires communicating to dispatch department then the text will be maintained at sales document level and this text determination assists in setting up on how texts are copied from one document to another. Ideally, text can be maintained at customer master data ( General data, Company Code & Sales Area data), Material master data level ( Sales Text View), Customer Material Info record, Sales document, delivery, shipment, billing etc. Text determination follows condition technique to fetch text maintained from the Master data or Preceding documents. Text activation In Master data text determination will be activated by assigning text procedure to Account group  In Transaction data level, Te

Billing Document Type Controls

Number Range:  Internal Number Assignment : Number ranges will be maintained in the T.Code VN01 and assign the Number range interval over here . SAP allows only internal number range assignments for billing document types. SD Document Category : Billing documents will be differentiated based on the sales document category Posting Block If you select this check box, the billing document is blocked from posting to accounting. Business user need to go to VFX3 and release the document manually. Transaction Group This field is used for document control in SAP. For billing documents, the transaction group is 7. For pro-forma invoices, it is 8. Document Type You can specify an accounting document type that will be linked to this billing type. Ideally accounting document ‘RV’ will be maintained over here. Negative Posting This field is used to control whether negative values are permitted in the document. Branch/Head Office This fie

Introduction to Sales and Distribution Enterprise Structure

Organisation structure of a company is termed as Enterprise Structure in SAP. This represents the skeleton of an organisation. Each functional department  of a company is represented by an individual organisational element or Unit in SAP. Enterprise structure need to be designed from reporting perspective and this would be basis for the creation of the master data. SAP recommends to keep organisational structure as lean as possible and this will have an impact during master data maintenance. Enterprise structure is divided into two parts : 1. Definition 2. Assignment  Individual Org. elements will be created stand alone in the definition Relationship between independent Org. elements will be done in Assignment process. Below is the mapping of Organisational structure to that of SAP Functional Terminology                                    SAP Terminology Group of Companies  -------------------- ----------->  Company Each Industry Vert

Functionality of Report SDVBUK00

Consultants usually misunderstand that this program is used to perform mass changes for the document status but this is usually used only if the status of the document is inconsistent with the status of the document at database level Only those inconsistent documents will be corrected using this report. In case, if the status of the document and database is same this report will not correct the document As the status of the documents gets changed regularly at times there might be documents with this inconsistent behaviour only in this case you can use this report. This should not be scheduled daily and can be used to fixed individual sales documents

Identify customizing path through screen fields

At times, we are unsure of the path to find the required field for data maintenance . In this situation click on 'F1' button of your keyboard, this will give you a pop up. In the below example, I am trying to find the path for 'Nelson ID' and below is the process steps followed to identify the path. Select the 'Nelson ID' field and click on F1 button.

Customer Account Group Creation

Customer Account Group acts like a backbone for customer master data and is pre-requisite for creation of customer master data. Ideally Individual account groups will be created based on the below parameters. Field Status Number Ranges Partner Functions Type of Customer I.e., Regular or One Time Customer For domestic customer GSTIN number is mandatory whereas for export customers it is not. further, We can  create individual account groups for 'One time account', 'Ship to Party', 'Bill to Party' and 'Payer'. So due to that individual account groups need to be created in this case for both export and domestic customers,  'One time account', 'Ship to Party', 'Bill to Party' and 'Payer'. Field Status Control Path: Goto SPRO - Financial Accounting New - Accounts receivable and Accounts Payable - Master data - Define Account Group with Screen Layout ( Customers) ( T.Code - OBD2) Create new acco

Mass display of changes for several material at once - Material master

Ideally, you might come across an issue with business users to display several materials list at once to display mass changes. As this will hit change document tables so if the material field is not maintained, mandatory then performance issue will come up due to that SAP has come up with material number as Mandatory in MM04 but if business users still insist for several materials then SAP has provided a note for the removal fo material number as Mandatory. OSS Note 336668 - Displaying change documents for several materials

Delivery Scheduling Calculation - SAP SD

Delivery scheduling calculates date in the delivery header roughly as described below: Delivery date minus Transit time   = Goods issue date Goods issue date - Loading time    = Loading date Loading date - Pick/pack time      = Picking date Loading date - Transportation lead time                                   = Transportation planning date

Pre-requisites for product allocation in SAP SD

Product allocation must be switched on in the requirement class (transaction OVZG) and in the schedule line (transaction VOV6). Transfer of requirement must be switched on in the requirement class and in the schedule line. Availability check must be switched on in the requirement class and in the schedule line. Product allocation determination procedure has been maintained in the Basic data 1 tab in Material Master. Check your update settings: Check the update setting of the info structure in transaction MC25. For standard info structure S140, you can use the standard formulas 141 – 144. Formula 140 is the standard formula, independent from the info structure, and must always be entered for characteristic Product allocation object. If you use your self-defined info structure, you can use formulas 141 - 144 as a copy reference and you must adjust them to your info structure. The key figure incoming orders quantity (AEMENGE) must be updated. Update must occu

Delivery Scheduling functionality in SAP SD

The aim of the scheduling is to determine the goods issue date, loading date, material availability date, the transportation planning date and when necessary a new delivery date. Customizing:  Sales documents: The delivery and transportation scheduling can be activated in transaction OVLY. Customizing path: Sales and Distribution -> Basic Functions -> Delivery Scheduling and Transportation Scheduling -> Define Scheduling By Sales Document Type It is controlled by the document type. Deliveries: For deliveries you have to consider the setting in transaction 0VLK. Field 'Rescheduling' controls whether a new scheduling is carried out. Stock transport documents: In stock transport documents you also have the possibility to use the SD scheduling functionality. If you do not activate it then an MM scheduling is carried out. Customizing path: Materials Management -> Purchasing -> Purchase Order -> Set up Stock Transport Order -&g

Pre-requisites to pick a delivery document during shipment processing

Is the delivery type marked as relevant for transportation in Customizing? (Customizing: Sales and Distribution -> Transportation -> Specify transportation relevance, here: Maintain transportation relevance for delivery types) Is a route entered in the delivery and is the route characterized as transportation relevant in Customizing? (Customizing: Sales and Distribution -> Transportation -> Specify transportation relevance, here: Maintain transportation relevance for routes) A transportation blocking reason must not be set in Customizing for the delivery type! (Customizing: Sales and Distribution -> Transportation -> Specify transportation relevance, here: Maintain transportation relevance for delivery types) A transportation locking reason must not be set in the delivery itself! (VL01, Change delivery: Header -> Transport.relev.info, where the field 'Transportation blocking reason').

BAPI to create different sales documents

BAPI_INQUIRY_CREATEFROMDATA      Create customer inquiry   BUS2030 BAPI_QUOTATION_CREATEFROMDATA    Create customer quotation BUS2031 BAPI_SALESORDER_CREATEFROMDAT1   Create sales order        BUS2032 You can use BAPI_SALESDOCU_CREATEFROMDATA to create the following sales document categories: BUS2034      Contracts BUS2094      Credit memo request BUS2096      Debit memo request BUS2102      Returns BUS2103      Subsequent delivery free of charge

User Exits available in purchasing for the IDoc output of purchase orders using ORDERS and ORDCHG?

You can use transaction CMOD with SAP enhancement MM06E001 to find the user exits (you can also find them in the object navigator in the function group XM06), for example, the following exits are relevant: EXIT_SAPLEINM_012 -> Customer enhancement for configuration (table APPL) EXIT_SAPLEINM_013 -> Customer enhancement for changing material configuration data EXIT_SAPLEINM_001 -> Customer enhancements for enhancing the control record EXIT_SAPLEINM_002 -> Customer enhancements for data segments EXIT_SAPLEINM_011 -> Final customer enhancement