A question on SD

[Former Member]

Dear SAP Experts,

<b>I have a  question in SD.</b> 
Currently, I need to get all details[fields] as per the transaction in XD03[customer master data in the display mode].For example, in XD03 transaction, based on the selction criterion of <b>Customer, Sales org, Distribution Channel and Divison,</b> 
you get the rest of the fields. 
I would like to get all these fields from the SAP tables and not the structure. 
When I see the F1 help on these fields they are displayed from a structure <b>RF02D,</b> but I need to get these data from SAP Tables, how do I get them ?

Please advise.

Thanks in Advance

[RichHeilman]

You will need to look at the following tables.

KNA1

KNVV

You also might need some fields from

KVNP

KNVK

Regards,

Rich Heilman

[Former Member]

and KNB1 and KNBK, KNVA, KNVI and many more. Is there some specific information you are looking for?

[Former Member]

A few more..

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.

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

[Former Member]

For any object you can find all DB tables in tcode SARA.

For customer put object as FI_ACCRECV and click on DB tables . It will give you all the tables for the Object Customer.

Cheers.

[Former Member]

Dear Sinha,

Thanks for the response. Indeed its very helpful.

Besides, could you also list of objects related to Sales?

I checked the values for these objects using F4, but was not successful. It would be great if you can help me in this regard.

Cheers

[Former Member]

Answered. Thanks everyone for the forum