Saravanan

Saravanan

Wednesday, May 30, 2012

SD intergration with Other Modules

SD Integration points with other modules

Sales Order –
Integration Points                      Module
•Availability Check            -       MM
•Credit Check                   -       FI
•Costing                            -      CO/ MM
•Tax Determination            -       FI
•Transfer of Requirements  -       PP/ MM

Delivery & Goods Issue –
Integration Points                      Module
•Availability Check             -       MM
•Credit Check                    -       FI
•Reduces stock                  -       MM
•Reduces Inventory $         -       FI/ CO
•Requirement Eliminated     -       PP/ MM

Billing -
Integration Points                      Module

•Debit A/R                         -       FI/ CO
•Credit Revenue                 -       FI/ CO
•Updates G/ L                    -       FI/ CO
  (Tax, discounts, surcharges, etc.)
•Milestone Billing               -       PS

Return Delivery & Credit Memo -
Integration Points                      Module

•Increases Inventory             -       MM
•Updates G/ L                      -       FI
•Credit Memo                      -       FI
•Adjustment to A/R              -       FI
•Reduces Revenue               -       FI

SAP SD Tables


What is a Table? How can you view your Table?
A table is nothing but a matirx containing rows and columns which Show the database would handle the data. All tables can be viewed via the SAP data dictionary using transaction code SE11

Table :  Description

Customers:
KNA1 General Data
KNB1 Customer Master – Co. Code Data (payment method, reconciliation acct)
KNB4 Customer Payment History
KNB5 Customer Master – Dunning info
KNBK Customer Master Bank Data
KNKA Customer Master Credit Mgmt.
KNKK Customer Master Credit Control Area Data (credit limits)
KNVV Sales Area Data (terms, order probability)
KNVI Customer Master Tax Indicator
KNVP Partner Function key
KNVD Output type
KNVS Customer Master Ship Data
KLPA Customer/Vendor Link

Sales Documents:  VBAKUK VBAK + VBUK
VBUK Header Status and Administrative Data
VBAK Sales Document - Header Data
VBKD Sales Document - Business Data
VBUP Item Status
VBAP Sales Document - Item Data
VBPA Partners
VBFA Document Flow
VBEP Sales Document Schedule Line
VBBE Sales Requirements: Individual Records

SD Delivery Document :
LIPS Delivery Document item data, includes referencing PO
LIKP Delivery Document Header data

SD Billing Document:
VBRK Billing Document Header
VBRP Billing Document Item

SD: Shipping Unit
VEKP Shipping Unit Item (Content)
VEPO Shipping Unit Header
 -------------------------------------------------------------------------------------------------------------
SD Transaction Code Flow:

Inquiry / Document type IN
Tcode for creation VA11,VA12,VA13. tables VBAK, VBAP

Quotation / QT
Tcode for creation VA21,VA22,VA23. tables VBAK, VBAP

Purchase Order PO
Tcode for creation ME21,ME22,ME23. tables EKKO, EKPO.

Sales Order OR
Tcode for creation VA01,VA02,VA03. tables VBAK, VBAP

Delivery LF
Tcode for creation VL01,VL02,VL03. tables LIKP, LIPS

Billing MN
Tcode for creation VF01,VF02,VF03. tables VBRK, VBRP

To create a sales order we need purchase order number and custmer number
Before that, to create a purchase order we need to have material no, vendor no.

To create vendor tcode is
xk01(create), xk02(change) , xk03(display)
Tables are LFA1.

To create custmer tcode is xd01, xd02, xd03.
Table is KNA1. 

Tuesday, March 27, 2012

Master Data (Customer Master/ Material Master/cust-mat info record/ Condition Master/ Output Master))

Masterdata :



Customer Master:
The common data—such as the customer’s name and address—is used centrally.
The customer master data is divided into three areas:
  • The General Data section has common information such as the Address tab,which contains name and contact information details, control data (such as industry, transportation zone, and tax information), payment transaction (bank details and payment card details), marketing (Nielsen ID and other classification), and other tabs based on relevance to the business.

  • The Sales Area Data section has tabs called Sales (containing information on sales groups, pricing classifications, and so on), Shipping (which controls items such as delivery priority, shipping conditions, and so on), Billing (for tax classifications, Incoterms, and so on), and Partner Functions.

  • The Company Code Data section has tabs called Account Management (reconciliation account details) Payment Transactions, Correspondence, and Insurance. From the General Data and Sales Area Data sections, you can also branch out to Extras Additional Data to reach other fields.
 Material Master:
The material master contains all the information about the product or service being sold. This information is shared across the organization and maintained by different departments. Hence, it is structured in views according to the various functions such as Purchasing view, MRP view, Accounting view, and Sales view. SD-related data is structured in three views—Sales: Sales Org 1, Sales: Sales Org 2,and Sales:  General/Plant. These three views will be the focus of the following discussion.
 the following terms match the materials and products you manage in your organization:
  • FERT : Finished products
  • HALB : Semifinished products
  • ROH : Raw materials
  • DIEN: Services
  • KMAT : Configurable materials
  • H AWA : Trading goods

Customer Mateial Info Record :
Data on a material defined for a specific customer is stored in a Customer material info record.
Info Records contain:
-customer-specific material number
-customer-specific material description
-customer-specific data on deliveries and delivery tolerances

You can also maintain default text to appear on sales orders for that customer

 

Condition Master - Pricing  
Condition master data includes:
-Prices
-Surcharges
-Discounts
-Freights
-Taxes

You can define the condition master to be dependent on various data:
>Material specific
>Customer specific

Conditions can be dependent on any document field


 

Output Master:
Output is information that is sent  to the customer using various media, such as:
-E-mail
-Mail
-EDI
-Fax
-XML
-Output examples:
-Quotation
-Confirmation
-Invoice