please solve this spec in report

[Former Member]

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

[Former Member]

You really expect someone do write this code for you.

[Former Member]

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

[former_member583013]

Funny....We're supposed to be <b>SAP Developer Network</b> and not <b>Rent a SAP Developer for free</b>....Sorry....Post some code or otherwise...no one is going to help you -:)

Greetings,

Blag.

[Former Member]

Hi Alvaro,

belongs your reply to me or to arun?

regards, Dieter

[former_member583013]

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