on 03-27-2009 12:32 PM
Hello SAP gurus
I want a report in which there should be purchase order no ,Accounting document which is created during GR & Invoice.
Please suggest me the T code if any or if i hav to write a query for that which tabled shuld i use?
You can check with the many reports like MB5B, MB51 , MB52...
Or for custom development
You can develop a report based on following table & fields.
MSEG-BWART-Movement type
MSEG-MBLNR -Material document
MSEG-BELNR -Accounting document
MSEG-DMBTR -Amount in lical currency
MSEG-MENGE -Qty
MM Table PDF Link http://www.sapcustomization.com/document/sap_tables.pdf
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks mohamed,
But still i m not getting the output
I have joined the tables EKBE & MSEG & BKPF
I want the document creation date,posting date,fiscal year,Doc type(RE for invoice doc type) as input
& In o/p parameter i want PO no.,PO item,Invoicing accounting document & Vendor if possible & other data
Please help me guys...
Dear Desai,
Tables in SAP MM for Purchasing Point of View
EKKO - Purchasing document header
EKPO - Purchasing Document: Item
EKET - Purchasing Document: Delivery Schedules
MDBS - Material View of Order Item/Schedule Line (good to find open PO's)
EKKN - Account assignment in purchasing document
EORD - Purchasing Source List
EIPA - Order price history record
EKAB - Release documentation
EKBE - Purchasing document history
EKBZ - Purchasing document history: delivery costs
MKPF - Material document: Header
MSEG - Material document: item
Invoice Verification
BSIM - Secondary index: documents for material
MYMFT - FIFO results table
MYML - LIFO material layer
MYMLM - LIFO material layer (monthly)
MYMP - LIFO period stocks, single material
MYMP1 - Receipt data LIFO/FIFO valuation
MYPL - LIFO pool layer
MYPLM - LIFO pool layer (monthly)
RBCO - Document item, incoming invoice account assignment
RBDIFFKO - Invoice Verification: conditions
RBDIFFME - Invoice Verification: quantity differences
RBDRSEG - Invoice Verification batch: invoice document items
RBKP - Document header: incoming invoice
RBKPB - Invoice document header (batch invoice verification)
RBTX - Taxes:incoming invoice
RBVD - Invoice document: summarization data
RBVDMAT - Invoice Verification: summarization data, material
this may help u !
Regards,
Pardeep Malik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
MR51 will solve your problem.
AMIT
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
MR51
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.