Sap Sd Enterprise Structure Assignment To Non-Structure

Purpose

This wiki page will discuss about the various table involved/related to ERP SD.

These can very handy while you are:

  • preparing a Functional Specification
  • looking for transaction data
  • want to know about the respective fields in the table
  • when you want to create a SAP query

1 Enterprise structure

1.1 Definition

FI - Finance

Tables

Description

T880

Company

T001

Company code

CO - Controlling

Tables

Description

TKA01

Controlling area

LO - Logistics Operation

Tables

Description

T001W

Plant / sales organization

T499S

Locations

TSPA

Division

SD - Sales and Distribution

Tables

Description

TVKO

Sales organization / company code

TVTW

Distribution channel

TVBUR

Sales office

TVKBT

Sales office text

TVKGR

Sales group

TVGRT

Sales group text

T171T

Sales district text

MM - Material Management

Tables

Description

T001L

Storage locations

T024E

Purchasing organization

T3001

Warehouse number

TVST

Shipping point

TVLA

Loading point

TTDS

Transportation

T156

Movement Type

T023

Material Group

1.2 Assignment

CO - Controlling

Tables

Description

TKA02

Assign company code to controlling area

LO - Logistics Operation

Tables

Description

T001K

Assign plant (valuation area) to company code

SD - Sales and Distribution

Tables

Description

TVKO

Sales organization / company code

TVKOV

Distribution channel / sales organization

TVKOS

Division to sales organization

TVTA

Sales area

TVKBZ

Sales office to sales area

TVBVK

Sales group to sales office

TVKWZ

Plants to sales organization

MM - Material Management

Tables

Description

T024E

Purchasing organization / company code

T024W

Plant to Purchase organization

T001K

Link plant (= valuation area) / company code

TVSWZ

Shipping point to plant

T320

Assignment MM Storage Location to WM Warehouse

2 Master Data

2.1 Material master

Tables

Description

MARA

Material Master

MAKT

Material Description

MLAH

Material Tax Classification

MARC

Material per plant / stock

MVKE

Sales data - Material Master

MARD

Storage location / stock

MSKA

Sales order stock

MSPR

Project stock

MARM

Units of measure

MEAN

International article number

PROP

Forecast parameters

MAPR

Link MARC <=> PROP

MBEW

Material valuation

MVER

Material consumption

MLGN

Material / Warehouse number

MLGT

Material / Storage type

MPRP

Forecast profiles

MDTB

MRP table

MDKP

Header data for MRP document

MLAN

Tax data material master

MTQSS

Material master view: QM

MKPF

Material Document: Header

MSEG

Material Document: Item

MOFF

List of views not created for the material

PGMI

Planning material

T179

Material Product Hierarchy

2.2 Batches

Tables

Description

MCHA

Batches

MCH1

Batches

MCHB

Stock:Batches

2.3 Customer master data

Tables

Description

KNA1

Customer master - General data

KNB1

Customer master - Company data

KNB4

Customer Payment History

KNVV

Customer master - Sales data

KNBK

Bank details

KNB6

Customer master - Dunning data

KNVH

Customer hierarchy

KNVP

Customer partners function

KNVD

Customer Master Record Sales Request Form

KNVS

Shipment data for customer

KNVK

Contact persons

KNVI

Customer master tax indicator

3 Sales and Distribution (SD)

Tables

Description

VBFA

Document flow (alg.)

VTFA

Flow shipping documents

3.1 Sales order

Tables

Description

VBAK

Header data

VBAP

Item data

VBPA

Partners in sales order

VBKD

Sales Business Data

VBEP

Sales Doc - Schedule Line

VBEH

Schedule Line History

VBUK

Sales document : Header status

VBUP

Sales document : Item status

VBBE

Sales Requirement

VBLB

Release Order Data

FPLA

Billing Plan

FPLT

Billing Plan - Date

3.2 Pricing

Tables

Description

KONH

Conditions header

KONP

Conditions items

KONV

Procedure (billing doc or sales order)

KOND

Condition (data)

KOMK

Pricing Communication Header

3.3 Delivery & Shipping

Tables

Description

LIKP

Delivery header

LIPS

Delivery item

VTTK

Shipment header

VTTP

Shipment item

VTTS

Stage in transport

VTSP

Stage in transport per shipment item

VTPA

Shipment partners

VBUK

Sales Document: Header Status and Administrative Data

VBUP

Sales Document: Item Status

VEKP

Handling Unit - Header Table

VEPO

Packing: Handling Unit Item (Contents)

VEPVG

Delivery Due Index

3.4 Billing document

Tables

Description

VBRK

Header data

VBRP

Item data

3.5 contracts

Tables

Description

VEDA

Contract data

3.6 Output

Tables

Description

NAST

Message Status

3.7 Accounting Document

Tables

Description

BKPF

FI document Header

BSEG

FI document Item

BSET

Tax Data

BSID

Open Items

BSAD

Clear Items

3.8 Text

Tables

Description

STXH

Text File : Header

STXL

Text File : Item

3.9 Change Log

Tables

Description

CDHDR

Change Document: Header

CDPOS

Change Document: Item

SD Configuration

Welcome to SD Configuration page.
EnterpriseStructure:

1 Edit, Copy, Delete, Check Company Code(T001)
Company is created by FI Consultant.
The company code is an organizational unit used in accounting. It is used to structure the business organization from a financial accounting perspective.
IMG -> Enterprise Structure -> Definition -> Financial Accounting -> Define, copy, delete, check Company Code

2 Define Credit Control Area(T014)
Company is created by FI Consultant.
The credit control area is an organizational unit that specifies and checks a credit limit for customers.A credit control area can include one or more company codes. It is not possible to assign a company code to more than one control area. Within a credit control area, the credit limits must be specified in the same currency.
IMG -> Enterprise Structure -> Definition -> Financial Accounting-> Define Credit Control Area

3. Maintaining Sales Organization(TVKO)
Sales Organization is an organizational unit responsible for the sale of certain products or services.
IMG -> Enterprise Structure -> Definition -> Sales and Distribution -> Define, copy, delete, check Sales organization

4. Assigning Sales Organization to Company Code(TVKO~BUKRS)
This assignment ensures all the sales made through this Sales Organization are accounted for in the assigned Company Code (Company Code is created by FI Consultant).
IMG -> Enterprise Structure -> Assignment -> Sales and Distribution -> Assign Sales Organziation to Company Code

5. Maintaining Distribution Channel(TVTW)
Distribution Channel is the way, in which Products or Services reach Customers.
IMG -> Enterprise Structure -> Definition -> Sales and Distribution -> Define, copy, delete, check distribution channel

6. Assigning Distribution Channel to Sales Organization(TVKOV)
This assignment ensures, a Sales Organization can supply Materials to Customers through this Distribution Channel.
IMG -> Enterprise Structure -> Assignment -> Sales and Distribution > Assign distribution channel to sales organization

7. Maintaining Division(TSPA)
Division is a way of grouping materials, products, or services.
IMG -> Enterprise Structure -> Definition -> Logistics - General -> Define, copy, delete, check division

8. Assigning Division to Sales Organization(TVKOS)
IMG -> Enterprise Structure -> Assignment -> Sales and Distribution -> Assign division to sales organization

9. Setting up Sales Area(TVTA)
All the sales are made from a particular sales Area. For creating a Sales Order Sales Area is compulsory.
IMG ->Enterprise Structure -> Assignment -> Sales and Distribution -> Set up sales area

10 Maintain sales office(TVBUR)
you define the sales offices in your company. The definition of sales offices is optional.
For each sales office, you can determine the printer for output based on the sales documents in different ways
IMG -> Enterprise Structure -> Definition -> Sales and Distribution -> Maintain Sales Office

11 Assign sales office to sales area(TVKBZ)
IMG -> Enterprise Structure -> Assignment -> Sales and Distribution -> Assign sales Office to Sales Area

12 Maintain sales Group(TVKGR)
company. The definition of sales groups is optional. You can use the SD system without creating sales groups.

13 Assign sales group to sales office(TVBVK)
you can assign as many sales groups as desired to the sales offices. Any one sales group can belong to several sales offices.
IMG -> Enterprise Structure -> Assignment -> Sales and Distribution -> Assign sales group to sales office

14. Define Shipping Points(TVST)
Shipping Point is the Organizational element, which is responsible for shipping the Materials to the Customers.
IMG -> Enterprise Structure -> Definition -> Logistics Execution -> Define, copy, delete, check shipping point

15 Define, copy, delete, check plant(T001W)
Plant is created by MM Consultant.
IMG -> Enterprise Structure -> Definition -> Logistics - General -> Define, copy, delete, check plant

16 Assigning Shipping Point to Plant(TVSWZ)
This assignment ensures that goods from different Plant can be dispatched from different Shipping Points.
IMG -> Enterprise Structure -> Assignment -> Logistics Execution -> Assign shipping point to plant

17. Assigning Sales Organization- Distribution Channel- Plant(TVKWZ)
Plant is created ny MM Consultant.
IMG -> Enterprise Structure -> Assignment -> Sales and Distribution -> Assign sales organization - distribution channel - plant

Note: Ensure to do the undermentioned configuration also though it is not in Customizing node of Enterprise Structure.

18. Defining Common Distribution Channels for Master Data(TVKOV-VKWKO TVKOV~VTWKU)
Use
The purpose of this activity is to define distribution channels which have common master data..

Procedure
Access the activity using one of the following navigation options:
IMG Menu -> Sales and Distribution -> Master Data -> Define Common Distribution Channels
Transaction Code: VOR1

19. Defining Common Divisions for Master Data(TVKOS-SPAKO TVKOS~SPAKU)
Use
The purpose of this activity is to define distribution channels which have common master data..

Procedure
Access the activity using one of the following navigation options:
IMG Menu -> Sales and Distribution -> Master Data -> Define Common Division
Transaction Code: VOR2

Pricing Procedure
In SD, Pricing Procedure is determined based on Sales Area (Sales Organization + Distribution Centre + Division) + Customer Pricing Procedure + Document Pricing Procedure. Sales Area is determined in Sales Order Header Level. Customer Pricing Procedure is determined from Customer Master. Document Pricing Procedure is determined from Sales Document Type / Billing Type (if configured). Once the pricing procedure is determined, Condition records are fetched. If appropriate condition records are found, the price is determined. If Mandatory pricing condition is missing, system will through an error message.

In SD, the steps to configure Pricing procedure are as under:
Step 1:
Condition table: If existing condition table meets the requirement, we need not create a new condition table. Considering the requirement for new condition table, the configuration will be done in spro as follows: IMG >> Sales and Distribution >> Basic Function >> Pricing Control >> Condition Table (select the required fields combination, which will store condition record).
Step 2:
Access Sequence: If existing access sequence meets the requirement, we need not create a new access sequence. Considering the requirement for new sequence, the configuration will be done in spro as follows: IMG >> Sales and Distribution >> Basic Function >> Pricing Control >>  Access Sequence (Access sequence is made up of Accesses (Tables) & the order of priority in which it is to be accessed. Here we assign the condition table to access sequence.
Step 3:
Condition Type: If existing condition type meets the requirement, we need not create a new condition type. Considering the requirement for new condition type, the configuration will be done in spro as follows: IMG >> Sales and Distribution >> Basic Function >> Pricing Control >> Condition Type. It is always recommended to copy an existing similar condition type & make the neccessary changes. Here we assign Access sequence to Condition type.
Step 4:
a. Pricing Procedure: It is recommended to copy a similar pricing procedure & make the neccesary changes in new pricing procedure. Pricing Procedure is a set of condition type & arranged in the sequence in which it has to perform the calculation. Considering the requirement for new Pricing Procedure, the configuration will be done in spro as follows: IMG >> Sales and Distribution >> Basic Function >> Pricing Control >> Pricing Procedure --> Maintain Pricing Procedure.
b. Pricing Procedure: After maintaining the pricing procedure the next step will be determination of pricing procedure. Configuration for determining pricing procedure in SPRO is as follows: IMG >> Sales and Distribution >> Basic Function >> Pricing Control >> Pricing Procedure --> Determine Pricing Procedure.
5. Condition record: Condition record is a master data, which is required to be maintained by Core team / person responsible from the client. During new implementation, the condition records can be uploaded using tools like SCAT, LSMW, etc.

Normal Sales Order Cycle:-

Step 1: Sales Document Type
IMG > Sales and Distribution > Sales > Sales Documents >
Sales Document Header:
1. Sales Document Type:The sales document types represent the different business transactions, such as Inquiry, Quotation, Sales Order, etc. To create new sales order type, always copy as with reference to similar sales order. If possible use standard sales order.
2. Define Number Ranges For Sales Documents: Maintain number range with discussion with core team.
3. Assign Sales Area To Sales Document Types:
A. Combine sales organizations / Combine distribution channels / Combine divisions: Ensure to maintain these, else Sales Order creation will give error.
B. Assign sales order types permitted for sales areas: Assign only required Sales Order Types to required Sales Area. This will minimize selection of Sales Order Type as per sales area.

Sales Document Item:
1. Define Item Categories: If possible use Standard Item Category. Incase if required to create new, copy as from standard & maintain New.
2. Assign Item Categories: If possible, use standard. Formula for deriving item category: Sales Document Type + Item Category Group + Usage + Higher Level Item Category = Item Category

Schedule Line:
1. Define Schedule Line Categories: If possible use Standard Schedule Lines. Incase if required to create new, copy as from standard & maintain New.
2. Assign Schedule Line Categories: If possible, use standard. Formula for deriving Schedule Line: Item Category + MRP Type / No MRP Type.

Step 2:
IMG > Logistic Execution > Shipping > Deliveries >
1. Define Delivery Types: If possible use Standard Delivery Type. Incase if required to create new, copy as from standard & maintain New.
2. Define Item Categories for Deliveries: If possible use Standard Item Categories for Delivery Type. Incase if required to create new, copy as from standard & maintain New.
3. Define Number Ranges for Deliveries: Ensure to maintain number range.

Step 3:
IMG > Sales and Distribution > Billing >
1. Define Billing Types: If possible use Standard Billing Type. Incase if required to create new, copy as from standard & maintain New.
2. Define Number Range For Billing Documents: Ensure to maintain number range.
3. Maintain Copying Control For Billing Documents: Maintain relevant copy controls such as Sales Order to Billing, Deliver to Billing, etc.

The configuration differs from scenario to scenario & requirement of the client.

0 Thoughts to “Sap Sd Enterprise Structure Assignment To Non-Structure

Leave a comment

L'indirizzo email non verrà pubblicato. I campi obbligatori sono contrassegnati *