Regarding flows

[Former Member]

hi

what are the selection screen fields and tables used in ::

1. purchasing data analysis report

2. material master extraction report

[Former Member]

Hi

Be more clear with your requirement.

Just few words doesn't make to understand the things correctly.

1. purchasing data analysis report:

use EKKO,EKPO,EKET and other EK* tables you can use.

2. material master extraction report

MARA,MARC,MARD tables can be use.

selection screen fields are your will and wish what to use, it depnds on the user requirement

Regards

Anji

[Former Member]

no!!! actually i need the flow for these two topics that... and what are the feilds and tables used.. and in selection screen also!!!!

for generating a report....

[Former Member]

Please post some relevamt questions which are sensible.

This forum is neither for Chokers, freshers nor for teaching basics..

Seems that these people get trained some where in India at hyderabad and pose all the interview questions here. It sucks a lot

Anji Reddy reply was the most sensible answer you get here for your question.

Now please do not ask us teach abap

thanks

Sonali

[Former Member]

hi sonali

i need the flow for...

purchasing data analysis and material master extraction report

and by-the-way.. i think this site is to help others, without learning v can't do anything so i got a opportunity to learn what i'm lacking if u can help just help

thanks for ur comments.

i just want to know the flows with tables and fields

let me get a clear picture of this....

i've posted same thread but for vendor perfomance just c the below

this one is been posted by Anji Reddy Only

==================================================

(Q)what are the selection screen fields and table for vendor performance report?

(A)We ask for Quotations from different Vendors and Vendors will submit the quotations

all their data is stored in EKKO and EKPO tables (for RFQ) and their pricing related data in KONV and KONP tables

use the EKKO-BSTYP = 'A' for RFQ's

take all such RFQ's and fetch the data from EKPO,KONV,KONP and have to compare the different vendors prices, conditions etc and to finalise the Vendor

so we have to display the different Vendors data for the same Materials

in a table like thing and to display

Use MATNR field as selection screen and Material TYPE (MTART) also

You can use WERKS(PLANT) also on selection screen.

for these parameters fetch the data from EKKO,EKPO and display

=====================================================

Thanks & Regards,

Sowjanya. M.

[Former Member]

hi

good

SD REPORTS

Reports: Reports consist of data, which is expected to be reveiwed or checked the transaction taken in said period. Reports are useful for analysis of decision taking for future activities.

Some of the standard reports for SD & its configuration guide is as under:

Standard SAP SD Reports:=

Statistic Group:

Purpose – To capture data for Standard Reports, we require to activate Statistic Group as under:

--> Item category (Configuration)

--> Sales document type (Configuration)

--> Customer (Maintain in Master data)

--> Material (Maintain in Master data)

When you generate statistics in the logistics information system, the system uses the combination of specified statistics groups to determine the appropriate update sequence. The update sequence in turn determines for exactly which fields the statistics are generated.

Configuration:

IMG --> Logistics Information System (LIS) --> Logistics Data Warehouse --> Updating --> Updating Control --> Settings: Sales --> Statistics Groups -->

1. Maintain Statistics Groups for Customers

2. Maintain Statistics Groups for Material

3. Maintain Statistics Groups for Sales Documents

4. Assign Statistics Groups for Each Sales Document Type

5. Assign Statistics Groups for each Sales Document Item Type.....

All Standard Reports which are available are as under:

SAP Easy Access: Information Systems -> Logistics -> Sales and distribution ->

1. Customer -> Incoming orders / Returns / Sales / Credit memos / Sales activities / Customer master / Conditions / Credit Master Sheet

2. Material -> Incoming orders / Returns / Sales / Credit memos / Material master / ...

3. Sales organization -> Sales organization / Sales office / Sales employee

4. Shipping point -> Deliveries / Returns

5. SD documents -> Orders / Deliveries / Billing documents ...

& so on.

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

Shipment List Planning - VT11

List of Incomplete Shipments -Try VT04/VT11/VT32

Delivery without Shipments -Use VL06O

MM REPORTS->

Check the below sap standard transactions :

You can see bold one ( You can implement same logic in case you want to create new transaction)

Material list - MM60

Material Analysis(SIS) - MCTC

Material Analysis-Incoming orders - MC(E

Material Returns-Analysis - MC+M

Material Analysis- Invoiced Sales - MC+Q

reward point if helpful

thanks

mrutyun^