Skip to Content
author's profile photo Former Member
Former Member

please solve this spec in report

can anyone able to solve this spec

Purchase Register

Company code _______ to ______ (Mandatory) BUKRS

Plant _______ to ______ (Optional) WERKS

Posting date _______ to ______ (Mandatory) BUDAT

From April 2006, The posting date should start with 01.04.2007

Selection Buttons:

1. Invoice Posted (RE document type)

2. Invoice Cancelled (RD document type)

Incase plant is entered, the system should give message * With the plant, the report is not meant for legal reporting*

Processing Logic

[Required : Describe the detail flow of process may be supported by a flow diagram]

1. Vendor Bill No and Vendor Bill Date:

List out the Accounting Document Numbers (BELNR), Reference Document No (XBLNR), Document Date (BLDAT), Fiscal Year (GJAHR) and Period (MONAT) having the combination of company code (BUKRS), Posting Date in the Document (BUDAT) and Document type (BLART = RE and RD) from the table BKPF

Vendor Bill No = XBLNR

Vendor Bill Date = BLDAT

Report Period = MONAT

Company Code = BUKRS

2. Invoice Document Number:

List the corresponding invoice document no IDN (BELNR), Invoice year IY (GJAHR), invoicing party (LIFNR), Invoicing Currency (WAERS), Gross Invoice Amount (RMWWR), Exchange Rate (KURSF), Tax Amount (WMWST1), from the table RBKP for the condition

XBLNR = Vendor Bill No

BLDAT = Vendor Bill Date

BUKRS = Company Code

The main output in the reports are

Vendor Code = LIFNR

Invoice Amount = RMWWR

Invoice Total (Invoice Total in INR) = RMWWR * KURSF

Foreign Currency = WAERS

Exchange Rate = KURSF

3. Material Cost and Purchase Voucher Number Per Month:

Goto the table EKBE for the condition

BEWTP = Q

BELNR = IDN

GJAHR = IY

WERKS = Input Parameter,

List all the records from the table,

Get the PO number EBELN and Item Number EBELN for each records of the list.

Tax code = MWSKZ (It will be unique for all the records of each BELNR)

For the tax code, the descriptions are as follows

V1 Import 0%

V2 Branch Transfer 0%

V3 Delivery to Customer 0%

W1 CST 0%

W2 CST 0% against Form H

W3 CST 4% against Form C

W4 CST 4% against Form D

W5 CST 10%

W6 CST 12.5%

Y1 VAT 0%

Y2 VAT 0% against Form

Y3 VAT 4%

Y4 VAT 8%

Y5 VAT 12.5%

Y6 VAT 20%

Y7 VAT 12.5% (Non Recoverable)

Y8 VAT 20.0% (Non Recoverable)

Z1 Nil Tax

4. Delivery costs document

Goto the table EKBZ for the condition

BEWTP = M

BELNR = IDN

GJAHR = IY

WERKS = Input Plant

List all the records from the table. Assign this list of document to the main EKBE document by comparing the EBELP and EBELN

5. Material Cost and Purchase Voucher Number Per Month:

Goto the table BSEG, Enter all the accounting document number listed from BKPF table.

For Each accounting document list out the following informations and add

Amount in Local Currency = DMBTR

Amount in Foriegn Currency = WRBTR

GL Currency = PSWSL

Transaction = KTOSL

Assignment = ZUONR (equal to XBLNR of RBKP)

Tax code = MWSKZ

If the transaction is = KBS (Vendor Total Amount)

= WRX - BSX (Material Cost or Service Cost) If tax code is S1 = Service, Z1 or V1 Delivery costs, other than this material costs.

= VS7 (Service Charge)

= VS8 (Ecess on Service Charge)

= ZS1 (CENVAT)

= JEC (ECS on CENVAT)

= JP5 (VAT depends on the Tax code)

= ZAG (Agency Clearing Charges)

= ZIN (Cenvat Custom Duties)

= ZF1 (Freight Charges)

= ZCD (Custom Duties)

= JP4 (CST Inventory)

= JP5 (VAT)

= JP6 (VAT Inventory)

= JP7 (VAT on Capital Goods)

= JP8 (VAT Inventory)

For the tax code, the descriptions are as follows

S1 Service 12.24%

V1 Import 0%

V2 Branch Transfer 0%

V3 Delivery to Customer 0%

W1 CST 0%

W2 CST 0% against Form H

W3 CST 4% against Form C

W4 CST 4% against Form D

W5 CST 10%

W6 CST 12.5%

Y1 VAT 0%

Y2 VAT 0% against Form

Y3 VAT 4%

Y4 VAT 8%

Y5 VAT 12.5%

Y6 VAT 20%

Y7 VAT 12.5% (Non Recoverable)

Y8 VAT 20.0% (Non Recoverable)

Z1 Nil Tax

The output will have format like this

Purcahse Voucher No – Vendor Bill No – Vendor Bill Date – Currency – Foreign Exchange Rate – Foreign Rate – Material Cost (WRX – BSX + JP6 + JP8 ) – Custom Duties (ZCD) – Freight Charges (ZF1)– Cenvat (ZIN and ZS1) – ECS on Cenvat (JEC) - Service Tax (VS7) – Ecs on Service Tax (VS8) – VAT (JP5 and JP7) – Tax code description as above

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2007 at 12:29 PM

    You really expect someone do write this code for you.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2007 at 12:34 PM

    Hi arun,

    sorry, but try it by yourselve.

    If you have problem with your abap than you it post here and i think

    you will get help.

    Regards, Dieter

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Dear Dieter:

      My reply belong to Arun of course -;) After all...He's the one who wants a complete report without doing any effort -:)

      P.S: I forget that this new forums tells "In response to..." Gonna keep an eye on that next time -:) Sorry for the misunderstanding Dieter -;)

      Greetings,

      Blag.

      Message was edited by:

      Alvaro Tejada Galindo

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.