RE:[sap-acct] Table name and fields for vendor invoice in mm module
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by Anna Bosak (Senior SAP Consultant) on Feb 5 at 8:48 PM |  Mark as helpful |
Prior to SAP developing Logistics Invoice Verification the had Invoice Verification (earlier releases). With IV, the BKPF and BSEG etc. tables were used. When SAP introduced LIV, they began using RBKP and RSEG. So if you've been on SAP in earlier releases and posted IV documents, the results are stored in BKPF/BSEG. If you later upgraded and began using LIV to post PO invoices, your results are stored in RBKP/RSEG.
Another means of finding the tables is to double click on the program name while in the Technical Info screen. This will take you to the program code and/or includes. You can then look at the Data Declarations and see what tables are used. You can double click on the table which will take you to the data dictionary and display the table.
But you are correct, you can't always get to the table the data is stored in via the Technical Help.
If you go to display an LIV invoice (MIR4), position your cursor on the invoice doc number and press F1, technical info, you'll see table RBKP. Finding RSEG is a bit more difficult but if you position your cursor on the line item amount field, click F1, technical info...then double click on the table name DRSEG. When you get to the data dictionary click on the Display Object List open Data Dictionary and then tables and you'll see all the tables used.
________________________________
From: ha_tran via sap-acct [sap-acct@Groups.ITtoolbox.com]
Sent: Friday, February 05, 2010 7:54 PM
To: Bosak, Anna K
Subject: RE:[sap-acct] Table name and fields for vendor invoice in mm module
[http://userimages.toolbox.com/user/b_1819969.jpg] Posted by ha_tran (Senior SAP Supply Chain Business Analyst)
on Feb 5 at 8:02 PM [http://images.ittoolbox.com/vt/icons/vote.png] Mark as helpful<http://it.toolbox.com/api/ContentVote/3288365/1/1/>
Hi Anna,
With due respect, I, unfortunately, do not really share your point. The truth is there are many cases where "F1" Help does not give you the exact transparent tables such as RBKP/RSEG, EKKO/EKPO in Logistics/PO invoices. For instance, when you are checking the Invoice Header Amount field in MM invoice header, you can easily see from "F1" Help that the related table is INFVO which is a structure table. Similar to the case of PO header where another structure table was popped up in "F1" Help. Therefore, the solution is to learn it by heart as there won't have many main tables in MM-Purchasing and LIV.....
Cheers,
HT
---------------Original Message---------------
From: Anna Bosak
Sent: Friday, February 05, 2010 2:45 PM
Subject: Table name and fields for vendor invoice in mm module
> For Logistics/PO invoices via MIRO, you need to look at table RBKP, RSEG. I prefer to give you the knowledge on how to find this out yourself but apparently you haven't figured that out from my first response. You really need to learn how to use the SAP help at the field level. You can save yourself and the rest of us time by doing a bit of work on your own plus this info will help you in other areas.<br/>Position your cursor on the field you are interested in, press F1 (HELP), then select Technical. This will show you the program, field, table whether a field has a Parameter ID etc. Feel free to explore.<br/>Best of luck.
__.____._ Another means of finding the tables is to double click on the program name while in the Technical Info screen. This will take you to the program code and/or includes. You can then look at the Data Declarations and see what tables are used. You can double click on the table which will take you to the data dictionary and display the table.
But you are correct, you can't always get to the table the data is stored in via the Technical Help.
If you go to display an LIV invoice (MIR4), position your cursor on the invoice doc number and press F1, technical info, you'll see table RBKP. Finding RSEG is a bit more difficult but if you position your cursor on the line item amount field, click F1, technical info...then double click on the table name DRSEG. When you get to the data dictionary click on the Display Object List open Data Dictionary and then tables and you'll see all the tables used.
________________________________
From: ha_tran via sap-acct [sap-acct@Groups.ITtoolbox.com]
Sent: Friday, February 05, 2010 7:54 PM
To: Bosak, Anna K
Subject: RE:[sap-acct] Table name and fields for vendor invoice in mm module
[http://userimages.toolbox.com/user/b_1819969.jpg] Posted by ha_tran (Senior SAP Supply Chain Business Analyst)
on Feb 5 at 8:02 PM [http://images.ittoolbox.com/vt/icons/vote.png] Mark as helpful<http://it.toolbox.com/api/ContentVote/3288365/1/1/>
Hi Anna,
With due respect, I, unfortunately, do not really share your point. The truth is there are many cases where "F1" Help does not give you the exact transparent tables such as RBKP/RSEG, EKKO/EKPO in Logistics/PO invoices. For instance, when you are checking the Invoice Header Amount field in MM invoice header, you can easily see from "F1" Help that the related table is INFVO which is a structure table. Similar to the case of PO header where another structure table was popped up in "F1" Help. Therefore, the solution is to learn it by heart as there won't have many main tables in MM-Purchasing and LIV.....
Cheers,
HT
---------------Original Message---------------
From: Anna Bosak
Sent: Friday, February 05, 2010 2:45 PM
Subject: Table name and fields for vendor invoice in mm module
> For Logistics/PO invoices via MIRO, you need to look at table RBKP, RSEG. I prefer to give you the knowledge on how to find this out yourself but apparently you haven't figured that out from my first response. You really need to learn how to use the SAP help at the field level. You can save yourself and the rest of us time by doing a bit of work on your own plus this info will help you in other areas.<br/>Position your cursor on the field you are interested in, press F1 (HELP), then select Technical. This will show you the program, field, table whether a field has a Parameter ID etc. Feel free to explore.<br/>Best of luck.
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
In the Spotlight
Earn Recognition for Your Contributions at Toolbox for IT. Gain Points for Community Achievements
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
_.____.__ 
