How to create a Quickviewer for Billing doc.

[Former Member]

Hi, Experts.

I wanna create a Quickviewer including following information:

1. Billling doc. No.

2. SP/SH/BP/PY linked to this billing doc.

3. Delivery notes linked to this billing doc.

4. PGI qty of each del. note

Besides, we have container rental billing doc., and there is prepayment and freedays for this container rental, thus, for container rental, should include following info.

5. Free days for each item

6. Prepaid days for each item

7. Billable days before deduct Free days&prepaid days

8. Net days

9. Start holdings

10. End holdings

Is it possible to create a Quickviewer including above information?

Or please tell where can I find these info.

Thanks a lot~~~~~~~~

[Former Member · Accepted solution]

You will have to get a 'Z' Report developed. Please find below a logic, which isrecommended to put into excel sheet for better understanding & get a report developed as per your requirement from Abaper. Below is only Indicative, which includes link between Project Systems, Sales Order, Delivery, Billing & Accounting.

<b><u>Initial Screen</u></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

<u><b>Main Screen</b></u>:

<b>Header</b>

Sales Organization | VBAK-VKORG

Period

<b>Item Level</b>:

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 suitable points.

• 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).

[Former Member · Accepted solution]

Thanks a lot~~