Customer master list report

[former_member358181]

Hi,

1) How can I generate the customer master report?

2) How can I generate the blocking/deletion customer mater list report?

Can I get any standard report as mentioned above.

Thanks

Devendra

[Former Member · Accepted solution]

CUSTOMER MASTER DATA

Creating Partner Records XD01

Maintaining Customer Master Data XD02

Displaying Customer Master Data XD03

Blocking Customer Master XD05

Deactivating a Partner VD06

regards,

Rajesh Banka

Reward suitable points.

[former_member358181 · Accepted solution]

Hi,

Thanks for reply but I want a standard report Codet

I require as below details in vertical columns.

Customer code

Customer Name

Search term 1/2

Sreet Address details

Street 2

Street 3

Street/House number

District

Postal Code/City

Region

Telephone

Mobile Phone

Deletion/Blocking details etc

Thanks,

Devendra

[Former Member · Accepted solution]

Such report is not availble in Standard, but can be done through 'Z' development.

Regards,

Rajesh Banka

Reward suitable points.

[Former Member · Accepted solution]

Hi ,

For your required field create a simple query using SQ01, This is the solution.

Appreciate if you can reward points.

[Former Member]

Hi Devendra Pise

I am not sure, if such reports are available, but the simplest solution could be downloading table KNA1( as I see all the info what you are looking for is available in this table), or you can run simple querry SQV1, with table KNA1.

If you want more info you run the qurey by joining tables.

reward if useful

Regards,

sateesh

[former_member358181]

Thanks

[Former Member]

ND59 LIST CUSTOMER MATERIAL INFO

VC/1 CUSTOMER LIST

<a href="http://www.sap-img.com/financial/useful-reports-tcode-in-sap-financial-accounting.htm">REFER THE LINK</a>

[former_member358181]

Hi,

Thanks for reply but I want a standard report for customer list only. I require the customer code, Name, Address details, deletion/blocking details etc in vertical columns.

Thanks,

Devendra

[Former Member]

Hi,

Some of the Standard reports in SD are:

Sales summary - VC/2

Display Customer Hierarchy - VDH2

Display Condition record report - V/I6

Pricing Report - V/LD

Create Net Price List - V_NL

List customer material info - VD59

List of sales order - VA05

List of Billing documents - VF05

Inquiries list - VA15

Quotation List - VA25

Incomplete Sales orders - V.02

Backorders - V.15

Outbound Delivery Monitor - VL06o

Incomplete delivery - V_UC

Customer Returns-Analysis - MC+A

Customer Analysis- Sales - MC+E

Customer Analysis- Cr. Memo - MC+I

Deliveries-Due list - VL04

Billing due list - VF04

Incomplete Billing documents - MCV9

Customer Analysis-Basic List - MCTA

Material Analysis(SIS) - MCTC

Sales org analysis - MCTE

Sales org analysis-Invoiced sales - MC+2

Material Analysis-Incoming orders - MC(E

General- List of Outbound deliveries - VL06f

Material Returns-Analysis - MC+M

Material Analysis- Invoiced Sales - MC+Q

Variant configuration Analysis - MC(B

Sales org analysis-Incoming orders - MC(I

Sales org analysis-Returns - MC+Y

Sales office Analysis- Invoiced Sales - MC-E

Sales office Analysis- Returns - MC-A

Shipping point Analysis - MC(U

Shipping point Analysis-Returns - MC-O

Blocked orders - V.14

Order Within time period - SD01

Duplicate Sales orders in period - SDD1

Display Delivery Changes - VL22

Reward points if useful

Regards,

Amrish Purohit