cancel
Showing results for 
Search instead for 
Did you mean: 

Report for Invoiced Documents

Former Member
0 Kudos

Hi Experts,

We got a new requirement from Finance department for a report.They got a requirement like this.

1.Invoice Document 2.Invoice amount 3.Invoice date 4.All Taxes in detail for each invoice 5.Vendor Name and Vendor Number 6.Reference Document Details

7.If excise tax exists then Excise document Number.

So,please anyone tell me, what information i must give to my ABAP Consultant.

Please guide me how to prepare this report,step by step.

Thanks and Regards

Accepted Solutions (1)

Accepted Solutions (1)

dhrubacharan_behera
Active Contributor
0 Kudos

Hi,

Look into Table RSEG, I think the required info will be available.

Dhruba

Former Member
0 Kudos

Hi Dhruba

Thank you for your reply...

Thanks and Regards

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi MK,

RSEG- tem: Incoming Invoice

RBKP- Header: Invoice Receipt

RGDS

Girish

Former Member
0 Kudos

Dear MK,

Here's some fields that may help :

EBELN LIKE EKPO-EBELN, " PO#

EBELP LIKE EKPO-EBELP, " PO item

ELIKZ LIKE EKPO-ELIKZ, " Complete

BEDAT LIKE EKKO-BEDAT, " PO creation date

AEDAT LIKE EKKO-AEDAT, " PO date

EKGRP LIKE EKKO-EKGRP, " Purchasing Grp

LIFNR LIKE LFA1-LIFNR, " Vendor#

NAME1 LIKE LFA1-NAME1, " Vendor name

MATNR LIKE EKPO-MATNR, " Material#

TXZ01 LIKE EKPO-TXZ01, " Description

NETPR LIKE EKPO-NETPR, " Unit price

WAERNT LIKE EKKO-WAERS, " Unit Price Curr

MENGE1 LIKE EKPO-MENGE, " Quantity in EKPO

ZTERM LIKE EKKO-ZTERM, " PayTerm

INCO1 LIKE EKKO-INCO1, " Incoterm 1

BEWTP LIKE EKBE-BEWTP, " Category Code

BEWTK LIKE T163C-BEWTK, " Category

BEWTL LIKE T163C-BEWTL, " Category Text

BELNR LIKE EKBE-BELNR, " Doc#

XBLNR LIKE RBKP-XBLNR, " Reference

BUZEI LIKE EKBE-BUZEI, " Item

BWART LIKE EKBE-BWART, " Mvt

BUDAT LIKE EKBE-BUDAT, " Posting Date

MENGE LIKE EKBE-MENGE, " Quantity

MEINS LIKE EKPO-MEINS, " Uom

SHKZG LIKE EKBE-SHKZG, " Indicator (+)/(-)

AUGDT LIKE BSEG-AUGDT, " Clearing Date

AUGBL LIKE BSEG-AUGBL, " Clearing Doc

GJAHR LIKE EKBE-GJAHR, " Fiscal Year

BKLAS LIKE MBEW-BKLAS, " VClass

BKBEZ LIKE T025T-BKBEZ, " VClass Desc

BEDNR LIKE EKPO-BEDNR, "XTracking No

CPUDT LIKE EKBE-CPUDT, "XArrival Date

AFNAM LIKE EBAN-AFNAM, "XDivision Name

EINDT LIKE EKET-EINDT, "XGoods Delivery

WRBTR LIKE EKBE-WRBTR, " Value in DCurr

REWRT LIKE BSEG-REWRT, " Gross Amt in DCurr

WAERS1 LIKE EKKO-WAERS, " DCurr

DMBTR LIKE EKBE-DMBTR, " Value in LCurr

REWWR LIKE BSEG-REWWR, " Gross Amt in LCurr

WAERS LIKE T001-WAERS, " LCurr

DMBE2 LIKE BSEG-DMBE2, " Value in GCurr

BONFB LIKE BSEG-BONFB, " Gross Amt in GCurr

WAERS3 LIKE EKBE-WAERS, " GCurr

ZUONR LIKE BSEG-ZUONR, " Allocation

BLART LIKE BKPF-BLART, " DType

BKTXT LIKE BKPF-BKTXT, " Doc Header Text

FIDOC LIKE BSEG-BELNR, " FI Doc#

ZBD1T LIKE BSEG-ZBD1T, " PTerm (days)

ZFBDT LIKE BSEG-ZFBDT, " EstPmtDt

MATKL LIKE EKPO-MATKL, " MatGrp

WERKS LIKE EKPO-WERKS, " Plant

BSART LIKE EKKO-BSART, " PODocTyp

BUKRS LIKE RBKP-BUKRS, " InvCoCd

NETPRQ LIKE EKPO-NETWR, " PO Amount

WRBTRA LIKE BSEG-WRBTR, " Inv Amnt in PO Curr

STATUS LIKE EKPO-BSTAE, " Status

VGABE LIKE EKBE-VGABE, "XHistory

TKNUM like VTTK-TKNUM, "XShipment#

BEZEI like TVKNT-BEZEI, "XPOD

DPTEN like VTTK-DPTEN, "XETA

CMILL like VTTK-HANDLE, "XCargo to Mill

VERKF like EKKO-VERKF, "XSales Person

INCO2 like EKKO-INCO2, "XIncoTerm 2

POACT like BKPF-BLDAT, "XPO from Acct

IVACT like BKPF-BLDAT, "XInv to Acct

ACPIV like BKPF-BLDAT, "XAcct process Inv

IVTPC like BKPF-BLDAT, "XInv to Pymt Ctrl

DATEN like VTTK-DATEN, "XATA

Regards,

w1n

Former Member
0 Kudos

HI W1n,

I really appreciate for your reply.

Tomorrow i will sit with my ABAP team member and try to work accordingly...

Thanks and Regards