on 08-16-2007 11:26 AM
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
Hi,
Look into Table RSEG, I think the required info will be available.
Dhruba
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi MK,
RSEG- tem: Incoming Invoice
RBKP- Header: Invoice Receipt
RGDS
Girish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.