cancel
Showing results for 
Search instead for 
Did you mean: 

Reports in SD

Former Member
0 Kudos

Hi all,

I need a report which has the order quantity, delivery quantity and billling quantity for a particular sales order along with the reasons for rejection in case of partially delivered sales order being rejected. Is something available in SAP. Can it be done using SQ01 ?? Please provide some documents for sq01.

Thanks and Regards

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Yes, it can be done through SQ01. You will have to identify the table & field names & table link for the same. You can take some clue from the SD report developed by us as per our requirement in project & use for SQ01.

<b>Initial Screen:</b>

Fields | Table-Field | Remark | Table Joint

Sales Organization | VBAK-WAERK | Single Selection

Distribution Channel | VBAK-VTWEG | Multiple Selection

Division | VBAK-SPART | Multiple Selection

Sales office | VBAK-VKBUR | Multiple Selection

Sold to Party | VBPA-KUNNR | Multiple Selection | VBAK-VBELN=VBPA-VBELN

Material | VBAP-MATNR | Multiple Selection | VBAK-VBELN=VBAP-VBELN

WBS Element | VBAP-PS PSP PNR | Multiple Selection | VBAK-VBELN=VBAP-VBELN

Sales Order Type | VBAK-AUART | Multiple Selection

Billing Type | VBRK-FKART | Multiple Selection | VBAK-VBELN=VBFA-VBELV & VBRK-VBELN=VBFA-VBELN

Period

<b>Main Screen:</b>

Header

Sales Organization | VBAK-VKORG

Period

Item Level:

Sold-to-Party | VBPA-KUNNR where VBPA-PARVW = AG

Distribution Channel | VBAK-VKWEG

Division | VBAK-SPART

WBS Element | VBAP-PS_PSP_PNR

Sales Office | VBAK-VKBUR

Sales Doc type | VBAK-AUART

Sales Doc No | VBAK-VBELN

Material | VBAP-MATNR

Mat Desc | VBAP-ARKTX

Qty | VBAP-KWMENG

UOM | VBAP-MEINS

Doc Currency | VBAK-WAERK

Delivery No | LIKP-VBELN

Billing Document Type | VBRK-FKART

Billing Document No | VBRK-VBELN

Billing Document Line No | VBRP-POSNR

Quantity | VBRP-FKIMG

Price - Base Price

Price - Service Tax

Price - Education Cess

Price - VAT

Price - Other taxes

Price - Total

Accounting Document Number | BKPF-BELNR

Table Joints at Item Level:

VBAK-VBELN = VBPA-VBELN

VBAK-VBELN = VBAP-VBELN

VBAK-VBELN = VBFA-VBELV (For Delivery)

VBAK-VBELN = VBFA-VBELV

LIKP-VBELN = VBFA-VBELV

VBRK-VBELN = VBRP-VBELN

VBRK-XBLNR = BKPF-XBLNR

  • some details are missing, please try to identify & use it as per your requirement.

Regards,

Rajesh Banka

Reward Points if Helpful

Former Member
0 Kudos

Hi,

No standard report in SAP.

Better to generate a Z report for this requirement.

Reward points if useful

Regards,

Amrish Purohit

Former Member
0 Kudos

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

Regards,

Rajesh Banka

Reward points if helpful.

Former Member
0 Kudos

Hi Rajesh,

To run the standard SD reports,

In logistics information sysytem, What is the ideal statistics group to be assigned in customer master record, material master record and sales document type.

Can u please tell me where do v maintain statistics group for sales documents.

Thanks & regards,

Praveen.