topic Re: A question on SD in Application Development and Automation Discussions

A question on SD

Former Member — Mon, 24 Oct 2005 17:15:14 GMT

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

Re: A question on SD

RichHeilman — Mon, 24 Oct 2005 17:18:54 GMT

You will need to look at the following tables.

KNA1

KNVV

You also might need some fields from

KVNP

KNVK

Regards,

Rich Heilman

Re: A question on SD

Former Member — Mon, 24 Oct 2005 17:26:00 GMT

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

Re: A question on SD

Former Member — Mon, 24 Oct 2005 17:27:03 GMT

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

Re: A question on SD

Former Member — Mon, 24 Oct 2005 17:30:12 GMT

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.

Re: A question on SD

Former Member — Tue, 25 Oct 2005 15:14:11 GMT

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

Re: A question on SD

Former Member — Mon, 03 Mar 2008 10:40:23 GMT

Answered. Thanks everyone for the forum