2007 Oct 23 12:43 PM
HI
I WANT TO KNOW ABT ALL THE TBALES RELATED TO CUSTOMER MASTER (XD01 )APPLICATION.. WHEN EVER WE CREATE A CUSTOMER THROGH THIS SCREEN THAT DATA WILL STORE INTO SOME TABLES.. WHAT ARE THOSE TABLES..(FOR EXAMPLE: KNA1 ,ect..) like this.. what are the other tables...
thanks
babu
2007 Oct 23 12:47 PM
hi Babu,
in SE11 check all tables start with KN.
On the other hand do an SQL trace (ST05) while creating a customer and you'll have lots of tables.
ec
2007 Oct 23 12:45 PM
KNA1 : customer master
KNB1 : Customer Master (Company Code)
KNVV : Customer Master Sales Data
KNVP: customer master partners
2007 Oct 23 12:45 PM
KNA1 General Data in Customer Master
KNAS Customer master (VAT registration numbers
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 ty
KNC1 Customer master (transaction figures)
KNC3 Customer master (special G/L transaction f
KNEA Assign Bank Details and Payment Methods to
KNEX Customer Master: Legal Control - Sanctione
KNKA Customer master credit management: Central
KNKK Customer master credit management: Control
KNKKF1 Credit Management: FI Status Data
KNKKF2 Credit Management: Open Items by Days in A
KNKO Assignment of Cost Est. Number to Config.
KNMT Customer-Material Info Record Data Table
KNMTK Customer-Material Info Record Header Table
KNOB Assignment of Cost Est. Number to Config.
KNVA Customer Master Unloading 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
2007 Oct 23 12:47 PM
hi Babu,
in SE11 check all tables start with KN.
On the other hand do an SQL trace (ST05) while creating a customer and you'll have lots of tables.
ec
2007 Oct 23 1:02 PM