Skip to Content
avatar image
Former Member

Report for Invoiced Documents

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Aug 16, 2007 at 10:34 AM

    Hi,

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

    Dhruba

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 16, 2007 at 10:33 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • avatar image
    Former Member
    Aug 16, 2007 at 11:41 AM

    Hi MK,

    RSEG- tem: Incoming Invoice

    RBKP- Header: Invoice Receipt

    RGDS

    Girish

    Add comment
    10|10000 characters needed characters exceeded