on 09-19-2007 11:21 AM
hi all,
i am working on a data migration project using sql server and sap, and i need tables information for customers to migrate data.
Thank you
Swapna
hi
As ur workng with sql server and sap on data migration the one thing u can keep in mind is that u have lot of tables for customers as given below but wht i sugst u is that u dont maintain all the tables in sql server, it will be a big mess rather u can segregate the customer master data as Sales Area Data, Company Code Data, General Data as here 1 or more tables make up one segment>> maintain single table for each Segment ie, Sales Area Data, Compny Code Data, General Data by copying all the necessary fields from the respective tables of each segment, that way it will be easy for u to push and pull data from different environments..
below i have segmented and listed out the tables.. and also i hav listed all the tables related to customer, but for creating a customer the Sales Arae Data, General Data, Compny Code Data are just enough if its a migration projct
Sales Area Data :
KNVI - Customer Master Tax Indicator
KNVD - Customer Master Record Sales
KNVP - Customer Master Partner Functions
KNVV - Customer Master Sales Data
General Data :
KNA1 - Customer Master General Data
Company Code Data :
KNB1 - Customer Master Company Code Data
KNB5 - Customer Master Dunning Data
Customer Related Tables
KNA1 General Data in Customer Master
KNAS Customer master (VAT registration numbers General Section)
KNAT Customer Master Record (Tax Groupings)
KNB1 Customer Master (Company Code)
KNB4 Customer Payment History
KNB5 Customer master (dunning data)
KNBK Customer Master (Bank Details)
KNBW Customer master record (withholding tax types) X
KNC1 Customer master (transaction figures)
KNC3 Customer master (special G/L transaction figures)
KNEX Customer Master: Legal Control - Sanctioned Party List
KNKA Customer master credit management: Central Data
KNKK Customer master credit management: Control Area Data
KNMT Customer-Material Info Record Data Table
KNMTK Customer-Material Info Record Header Table
KNVA Customer Master Loading Points
KNVD Customer master record sales request form
KNVH Customer Hierarchies
KNVI Customer Master Tax Indicator
KNVK Customer Master Contact Partner
KNVL Customer Master Licenses
KNVP Customer Master Partner Functions
KNVS Customer Master Shipping Data
KNVT Customer Master Record Texts for Sales
KNVV Customer Master Sales Data
KNZA Permitted Alternative Payer
Reward if USeful
Thanx & regards
Naren..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Swapna,
KNA1 General Data in Customer Master
KNAS Customer master (VAT registration numbers general section)
KNAT Customer Master Record (Tax Groupings)
KNB1 Customer Master (Company Code)
KNB4 Customer Payment History
KNB5 Customer master (dunning data)
KNBK Customer Master (Bank Details)
KNBW Customer master record (withholding tax types) X
KNC1 Customer master (transaction figures)
KNC3 Customer master (special G/L transaction figures)
KNEX Customer Master: Legal Control - Sanctioned Party List
KNKA Customer master credit management: Central data
KNKK Customer master credit management: Control area data
KNMT Customer-Material Info Record Data Table
KNMTK Customer-Material Info Record Header Table
KNOB Assignment of Cost Est. Number to Config. Object
KNVA Customer Master Loading Points
KNVD Customer master record sales request form
KNVH Customer Hierarchies
KNVI Customer Master Tax Indicator
KNVK Customer Master Contact Partner
KNVL Customer Master Licenses
KNVP Customer Master Partner Functions
KNVS Customer Master Shipping Data
KNVT Customer Master Record Texts for Sales
KNVV Customer Master Sales Data
AWARD IF U FINDS THIS AS USEFUL....
Regds
MM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
Hope this helps you
LSMW data migration for sales order VA01 / XD01 customer
LSMW using session method for data migration as follows
E.g. for XD01 (create customer)
initially there will be 20 steps but after processing 1 step it will reduced to 14 for session method.
1. T-Code: LSMW.
2. ENTER PROJECT NAME
Sub project name
Object name.
Execute.
3. MAINTAIN OBJECT ATTRIBUTES.
Execute
Select Batch Input recording
go to->recording overview
create
Recording name.
Enter transaction code.
Start recording
do recording as per your Requirement.
Save à Back.
Enter recording name in LSMW screen.
Save à Back
Now there will be 14 steps.
2. MAINTAIN SOURCE STRUCTURES.
Enter the name of internal table.
Display change
Create
Save Back
3. MAINTAIN SOURCE FIELDS.
Display change
Select structure
Source_fieldsàCopy fields. (a dialogue window will pop out )
Select à From data file
Apply source fields
a. Enter No. of field's
b. Length of fields
c. Attach file
Save à Back.
4. MAINTAIN STRUCTURE RELATIONS
Display change
Save à Back.
5. MAINTAN FIELD MAPPING & CONVERSION RULE
Display change
Click on source field, select exact field from structure and Enter
***repeat these steps for all fields.
Save à Back.
6. MAINTAIN FIXED VALUES, TRANSACTION, USER DEFINED
Execute
Save à Back.
7. SPECIFY FILES.
Display change
Click on legacy data
Attach flat file
Give description
Select tabulators
Enter
Save à Back.
8. ASSIGN FILE
Execute
Display change
Save à Back.
9. IMPORT DATA.
Execute
Display change
Save à Back.
10. DISPLAY IMPORTED DATA
Enter ok ***it will show records only.
Back
11. CONVERT DATA
Execute
Display change
Save à Back.
12. DISPLAY CONVERTED DATA
Execute
Display change
Save à Back.
13. CREATE BATCH INPUT SESSION
Tick keep batch input folder
F8
Back
14. RUN BATCH INPUT SESSION.
SM35 will come
Object name will be shown here
Select object & process
regards,
Arun prasad
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi
KNA1 General Data in Customer Master
KNAS Customer master (VAT registration numbers general section)
KNAT Customer Master Record (Tax Groupings)
KNB1 Customer Master (Company Code)
KNB4 Customer Payment History
KNB5 Customer master (dunning data)
KNBK Customer Master (Bank Details)
KNBW Customer master record (withholding tax types) X
KNC1 Customer master (transaction figures)
KNC3 Customer master (special G/L transaction figures)
KNEX Customer Master: Legal Control - Sanctioned Party List
KNKA Customer master credit management: Central data
KNKK Customer master credit management: Control area data
KNMT Customer-Material Info Record Data Table
KNMTK Customer-Material Info Record Header Table
KNOB Assignment of Cost Est. Number to Config. Object
KNVA Customer Master Loading Points
KNVD Customer master record sales request form
KNVH Customer Hierarchies
KNVI Customer Master Tax Indicator
KNVK Customer Master Contact Partner
KNVL Customer Master Licenses
KNVP Customer Master Partner Functions
KNVS Customer Master Shipping Data
KNVT Customer Master Record Texts for Sales
KNVV Customer Master Sales Data
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.