on 06-28-2007 10:51 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
No standard report in SAP.
Better to generate a Z report for this requirement.
Reward points if useful
Regards,
Amrish Purohit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
101 | |
14 | |
10 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.