sd reports abap

[Former Member]

i want some sample sd reports in sd so please help me.

[Former Member · Accepted solution]

<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>

<i>Header</i>

Sales Organization | VBAK-VKORG

Period

<i>Item Level:</i>

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]

Hi refer below

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/SDISREP/SDISREP.pdf

[Former Member]

Dear Surinder,

there are many SAP standard reports in SD, which you can use as an example. For example, report SDBANF02 or SDVBUK00. You can check them in the transaction SE38 and consider as the first template by creating your own reports.

I hope, this information helps you a little bi further.

Kind regards,

Akmal Vakhidov

Development Support SD, SAP, Walldorf/Germany

[Former Member]

• How to give points: Mark your thread as a question while creating it. In the answers you get, you can assign the points by clicking on the stars to the left. You also get a point yourself for rewarding (one per thread).