tax audit

[Former Member]

Hi gurus,

1) Accounting Year: GJAHR-(GJAHR+1)

Assessment Year GJAHR1) – (GJAHR2)

2) Get the following details from BSIS/BSAS

BSIS/BSAS – BELNR -

---

Accounting Document Number

BSIS/BSAS – DMBTR -

---

Amount in local currency

BSIS/BSAS – SHKZG -

---

Debit/Credit Indicator

BSIS -

---

Accounting: Secondary Index for G/L Accounts.

BSAS -

---

Accounting: Secondary Index for G/L Accounts (Cleared Items).

HKONT -

---

General Ledger Account.

XREF3 -

---

Reference key for line item

Where

BSIS/BSAS – GJAHR = P_GJAHR

BSIS/BSAS – HKONT = (334551, 499001, 402001, 402002, 403000) and store them in an internal table INTAB1

Summate the BSIS/BSAS –DMBTR and depict it in the first line of the table

3) For the documents contained in the INTAB1 table check whether there are any line items posted to HKONT’s =(260501,260502,260503) and store them in an internal table INTAB2

If yes then get the following fields from BSIS/BSAS table

BSIS/BSAS – BELNR

BSIS/BSAS – DMBTR

BSIS/BSAS – SHKZG

Where

BELNR = INTAB2-BELNR

GJAHR = P_GJAHR

HKONT = (260501, 260502 and, 260503)

SHKZG = “H”.

Summate the BSIS/BSAS – DMBTR and depict against second line item and fourth line.

4) Subtract line1 and line2 and depict against the 3 line.

5) Subtract the DMBTR of 4th line from the 2nd line DMBTR and depict against the 5th line item.

<b>How to make tachnical spec or tell me the logic.</b>

[laxmanakumar_appana]

Hi Amit,

follow the points to prepare technical spec:

1) Accounting Year: GJAHR-(GJAHR+1)

Assessment Year GJAHR1) – (GJAHR2)

<b>these two are selection screen parameters</b>

2) Get the following details from BSIS/BSAS

BSIS/BSAS – BELNR -

---

Accounting Document Number

BSIS/BSAS – DMBTR -

---

Amount in local currency

BSIS/BSAS – SHKZG -

---

Debit/Credit Indicator

BSIS -

---

Accounting: Secondary Index for G/L Accounts.

BSAS -

---

Accounting: Secondary Index for G/L Accounts (Cleared Items).

HKONT -

---

General Ledger Account.

XREF3 -

---

Reference key for line item

Where

BSIS/BSAS – GJAHR = P_GJAHR

BSIS/BSAS – HKONT = (334551, 499001, 402001, 402002, 403000) and store them in an internal table INTAB1

Summate the BSIS/BSAS –DMBTR and depict it in the first line of the table

<b>get the above fields from BSIS and BSAS tables with inner join on below fields</b>

BSIS/BSAS – BELNR -

---

Accounting Document Number

BSIS/BSAS – DMBTR -

---

Amount in local currency

BSIS/BSAS – SHKZG -

---

Debit/Credit Indicator

<b>with where condition</b>

BSIS/BSAS – GJAHR = P_GJAHR

BSIS/BSAS – HKONT = (334551, 499001, 402001, 402002, 403000) and store them in an internal table INTAB1

<b>into internal table INTAB1</b>

and do the remaining calculations.

Laxman

[Former Member]

Hi gurus ,

Urgent please high priority

[Former Member]

Hi Amit ,

what we have get out this ?

[Former Member]

hI,

Give me a Sample code.