cancel
Showing results for 
Search instead for 
Did you mean: 

Customer Master_Tables

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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..

Former Member
0 Kudos

hi

Thanks all,

Naren i am trying out the way you have suggested. seems to be pretty impressive. hope it turns out good for me.

Thanks

Swapna

Former Member
0 Kudos

hi Naren,

i tried the way you suggested me, and was really helpful.

Thank you

Swapna

Answers (4)

Answers (4)

Manoj_Mahajan78
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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