Inputs or tables required for customizing purchase register

[Former Member]

Hi,

I have encountered a problem regarding Purchase Register.

The requirement of the Client is that, he wants to have the Tax Details populated in the Purchase Register with reference to Tax Code in the Invoice Screen.

This should happen, once the Client enters the Details related to Invoice Document in the Selection Screen.

I searched for Table and Field related to Tax code.

I found the Field for Tax Code and it is MWSKZ.

But, the Table is a Structure.

So, please guide me how to find the link so as to fetch the Tax Details with respect to Tax Code in the Invoice Screen?

Please reply as soon as possible.

Waiting for your responsw,

Thanks in advance.

Thanks & Regards

Srinivasa M.S

+91-9910077829

Edited by: Jeyakanthan A on Jul 4, 2011 4:36 PM

[pankaj_singh9 · Accepted solution]

Hi,

For tax calculation based on tax code, use following function modules;

CALCULATE_TAX_FROM_GROSSAMOUNT

CALCULATE_TAX_FROM_NET_AMOUNT

And table for Tax Data Document is BSET.

[Former Member]

Hi,

To create Purchase tax register use below tables

TABLES: BKPF , BSEG , EKBE , EKBZ , BSET , MSEG , LFA1.

Thanks & Regards,

Sandesh Sawant

[Former Member]

Hi,

I also has the same requirement where I need to fetch the tax and excise details of the PO at item level. I searched the forum (from past 2 days) and tried all the stuff which the users have posted. But at the end no result.

As you people suggested, I tried to fetch the data from BSET table also. As it is a cluster table the program is taking too much time. Anyway I didnt get the output as I ran the report(for 40mins) using this logic. Is there any other logic to get the tax details and excise details of the PO items.

Regards,

Praveen

[former_member192897]

Use BSET table for Vendor invoice tax details.

[kailas_ugale]

hi

Logic For tax register

Table

EKBE

1) BELNR=MATERIAL DOC= HERE MOVEMENT TYPE BWART=101

2) GJAHR=MATERIAL DOC YEAR=2011

3) BUZEI=ITEM OF MATERIAL DOC=1 and 2

4) BUDAT=posting date of material doc=28.2.2011

5) MENGE=GRN QTY=1 FOR LINE ITEM 1,1 FOR LINE ITEM 2

FOR ABOVE COMBINATION IN TABLE EKBE

WE WILL GET FOLLOWING FIELDS

1) Po number= =EBELN

2) Po line item=10 and 20=EBELP

TABLE

EKPO

NOW PASS THIS FIELD EBELN AND EBELP INTO TABLE EKPO AND GET FOLLOWING FIELDS

1) MATERIAL CODE=MATNR

2) MATERIAL DICRIPTION=EMATN

3) MATERIAL GROUP=MATKL

4) ITEM CATEGORY=PSTYP

5) ACCOUNT ASSIGEMENT=KNTTP

6) TAX CODE=MWSKZ

7) PLANT=WERS

8) COMPANY CODE=BUKRS

TABLE

EKKO

NOW PASS EBELN FROM EKPO INTO TABLE EKKO AND GET FOLLOWINGS

1) VENDOR CODE=LIFNR

2) PURCHASING GROUP=EKGRP

TABLE

LFA1

NOW PASS LIFNR FROM TABLE EKKO INTO TABLE LFA1 AND GET FOLLOWINGS

1) VENDOR NAME=NAME1

2) CITY=ORT01

TABLE

MSEG

NOW PASS MATERIAL DOCBELNR=

MATERIAL DOC YEAR=GJAHR=2011

MATERIAL DOC ITEM= BUZEI=1 AND 2

PO NUMBER =EBELN=

PO ITEM NUMBER=EBELP=10 AND 20

ALL FROM TABLE EKBE AND GET FOLLOWING FIELDS

1) PROFIT CENTER=PRCTR

2) WBS ELEMNT=PS_PSP+PNR

TABLE

RSEG

PASS FROM TABLE EKPO

PO NUMBER =EBELN

PO ITEM =EBELP

INTO TBALE RSEG AND GET FOLLOWING FIELDS

1) INVOICE DOC NUMBER=BELNR=

2) FISCAL YEAR=GJAHR=2010

3) INVOICE ITEM=BUZEI

4) VALUVATION CLASS=BKLAS=7900

5) REFERNCE =XBLNR=156

TABLE

T025T

PASS VALUVATION CALSS FROM TABLE RSEG INTO TABLE T025T ,USE LANUAGE KEY EN AND GET FOLLOWINGFIELD

1) VALUVATION CALSS DISCRIPTION=BKBEZ=SEMIFINISH PRODUCT

TABLE

BKPF

NOW PASS BELNR+GHJAR ( 51056016262010) ,FIELD AWKEY OF TABLE BKPF

FISCAL YEAR=GHJAR INTO TABLE BKPF FROM TABLE RSEG AND GET FOLLOWING FIELDS

1) FI DOC NUMBER=5100001482

2) FISCAL YEAR=GHJAR=2010

3) DOC TYPE=BLART=RE

4) DOC DATE=BLDAT=23.2.2011

5) POSTING DATE=BUDAT=28.2.2011

6) TRASNCTION CODE=TCODE=MIRO

7) REFERNCE=XBELNR=156

TABLE

BSET

NOW PASS

FI DOC NUMBER=BELNR

FISCAL YEAR=GHJAR=2010

AND GET FOLLOWING VALUES

1) CONDITION TYPE =KSCHL

A) VAT=JVRD=12127.29

B) JVRN=CST

C) SERVICE TAX=JSRT

D) ECESS ON SERVICE=JEC3

E) HECESS ON SERVICE=JES3

HERE APPLY LOGIC TAXPS FIELD =1=ONE LINE ITEM FOR BELNR

Table

BSAK

NOW PASS BELNR,GHJAR ,BEART FROM TABLE BKPF AND VENDOR NUMBER LIFNR FROM TABLE EKKO

AND PASS THIS INTO TABLE BSAK

AND GET FOLLOWING FIELDS

1) CLEARING DOC NUMBER=AUGBAL

2) CLEARING DATE=AUGDT

I)Logic For excise values flow

B.E.D,=

A.E.D=

S.E.D. =

ECESS=

HECESS=

Pass GRN number From EKBE field MBLNR ,material doc year= MJAHR ,AND BUZEI=ITEM OF MATERIAL DOC=1 and 2

into table J_1IPART1 and get

Following

a) Excise group=field EXGRP=30

b) EXCISE REGISTER TYPE=REGTYP=A

c) INTERNAL DOC NUMBER=DOCNO=8100000013

d) Year=DOCYR=2011

e) ITEM=ZEILE

TABLE

J_1IEXCDTL

PASS DOCNO, EXGRP, RGTYP,DOCYR,ZEILE INTO TABLE J_1IEXCDTL AND GET values

B.E.D, =field EXBED =8772

A.E.D=field EXAED

S.E.D. =field EXSED

ECESS=field ECS=175.44

HECESS=field EXADDTAX1=87.72

TABLE J_1IEXCHDR

NOW PASS EXGRP AND DOCNO,DOCYR FROM TABLE J_1IPART2 AND VENDOR CODE LIFNR FROM TABLE EKKO INTO TABLE J_1IEXCHDR AND GET FOLLOWING VALUES

VENDOR ECC NUMBER=EXCCD

CST NNUMBER=CST NO

TABLE

J_1IMTCHID

CHAPTER ID LOGIC FOR MATERIAL

From table EKPO

Pass material number=MATNER and Plant=WERS into table J_1IMTCHID and get following field

Chapter id=J_1ICHID

Selection parameter for tax registers

1) Company code( mandatory)

2) Plant

3) Fi doc fiscal year( mandatory=GHJAR)

4) Fi doc posting date( mandatory=BUDAT from table BKPF)

5) Doc type from table BKPF( Mandatory field BLART)

6) Excise group

7) Vendor number

8) Fi doc number ( BELNR FROM TABLE BKPF)

9) Purchasing group

10) Material doc =BELNR from ekbe

11) Tax code

HERE

FISCAL YEAR=2010

FI DOC PSOTING DATE=28.2.2011

FI DOC TYPE =BLART=RE

COMPANY CODE=

Regards

kailas

Edited by: kailasugale on Jul 4, 2011 5:47 PM

[Former Member]

HI,

Use below code

Tax:

wa_taxcom-bukrs = i_cekko-bukrs. "Required

wa_taxcom-budat = i_cekko-bedat. "Required

wa_taxcom-bldat = i_cekko-bedat. "Not required

wa_taxcom-waers = i_cekko-waers. "Not required

wa_taxcom-hwaer = i_cekko-waers. "Not required

wa_taxcom-kposn = wa_bekpo-ebelp. "00010 Required

wa_taxcom-mwskz = wa_bekpo-mwskz. "UC (Tax code) Required

wa_taxcom-wrbtr = wa_bekpo-brtwr. "24,000/- required, total value on which tax can count

wa_taxcom-xmwst = 'X'. "required

CALL FUNCTION 'CALCULATE_TAX_ITEM'

EXPORTING

• ANZAHLUNG = ' '

• DIALOG = ' '

• DISPLAY_ONLY = ' '

• INKLUSIVE = ' '

• I_ANWTYP = ' '

• I_DMBTR = '0'

• I_MWSTS = '0'

i_taxcom = wa_taxcom

• PRUEFEN = ' '

• RESET = ' '

• IMPORTING

• E_NAVFW =

• E_TAXCOM =

• E_XSTVR =

• nav_anteil = v_taxval

TABLES

T_XKOMV = i_komv

EXCEPTIONS

mwskz_not_defined = 1

mwskz_not_found = 2

mwskz_not_valid = 3

steuerbetrag_falsch = 4

country_not_found = 5

OTHERS = 6

.

IF sy-subrc <> 0.

• MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

• WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

Regards,

Rajesh

Edited by: Rajesh Koladiya on Jul 4, 2011 5:40 PM

[BijayKumarBarik]

Hi,

In Standard there is nothing report on Purchase Register but you can cross check report with t.codes: J2I9 & J1I2

Also you can go ahead with develpement of Purchase Register with report in MIR5 t.code in addition of taxes .

Regards,

Biju K