on 08-25-2008 11:29 AM
Dear Guru's
Do any of you know the tables in SRM, where data/reference til PO and Invoices posted in back-end are store.
Also where cinformations are store both for back-end and SRM posted.
Thansk in advance,
Thomas
customer has the right to expect receipt of an accurate invoice consistent with contract in a way that facilitates easy processing for payment.
The timeliness and quality of your [invoice |http://www.taurusquest.com/invoicing-accounts-receivable.aspx]document and statements of account are part of the u201Cbrand experienceu201D you provide your customer.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Why do you want to do the heavy lifting yourself when SRM has enough tools to help you get it ;).
Just use the BBP_PD_SC_GETDETAIL/BBP_PD_SC_GETLIST function module or something with HISTORY in the name and I think you'll have enough to get you going. I think there was another one with OBJLINK in the name, but I don't know for sure (don't have a SRM system at the moment).
The way I most of the time develop programs is to first start looking at BAPI's, then normal Function Modules and after that I go for tables if I can't get what I want using the former 2 methods.
Most of the time the BBP_PD* function modules can accomplish whatever you want in SRM for documents.
Regards,
Robin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Thomas,
Hope this link clarify your doubts on follow on document tales and history too...
better late than never.
Step1:- get header GUID of Confirmation number
Step2:- BBP_PD_CONF_GETDETAIL Function Module
In Put => Guid of Confirmation Number
Output => Purchase Order number with respect to Confirmation
Step 3:- Pass the Purchase Order number into BBP_PDBEI table.
Step 4:- Now we might get the Item GUID of Shopping cart
Step 5:- pass the Item GUID of Shopping cart into CRMD_ORDERADM_H table to get the Shopping cart number.
regards
Muthu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Muthu,
I'm am aware of EKKO, EKPO etc. tables in back-end.
However, I do not understand what you are talking about.
I do not have a tracking number i the header of the PO in back-end.
I do see the reference i table BBP_PDBEI to the PO in the back-end, but where du I find the reference to ther confirmation of goods, both if it's done in SRM or in back-end.
Thnaks in advance,
Thomas
Hi Muthi,
I think we are out talking by each other.
What I need has nothng to do with tracking number!
What I need to know is where I find the tables that stores the information that is displayed in the "Follow-on Documents" section in the Shopping Card in SRM.
The PO-data I know is stored in BBP_PDBEI table in SRM.
However, the data that is displayed for confirmations and invoices I do not find. The confirmation can either originate from back-end or SRM, and the invoice will allways originate from back-end in our case, since we are running an classic scenario.
Thanks in advance,
Thomas
OK, I'll try again.
What I want to do is write a report that list each shopping cart, with all their PO, confirmations and invoices listed along.
This info is listen in the shopping card detail in the "follow-on documents" tab.
I asume that SRM is not consulting ERP every time it shows this information!
Do any of you know in what tables these informations are store in SRM?
Thanks in advance,
Thomas
Hi Thomas,
You must do development to link SC and PO via tracking number .I aware if you know po . you can catch GR/ IV too.
Please see this thread
MBGMCR idoc transmits your EBP GR to R/3 .
BBPIV idoc transfer your EBP to R/3.
check your distribution model to know more.
if you posted your GR in EBP , you can back track via SC ...
I have shared whatever i know.
Still do you have any query?
regards
Muthu
Edited by: Muthuraman Govindasamy on Aug 26, 2008 12:13 PM
Hi,
I do not want to see the document itself, but I would like to make a report that list the different document numbers.
I think they are store in EBP, since they are displayed in the "Follow-on Documents" tab in the Shopping Cart. I do not believe that EBP is looking in ERP every time it display the document flow.
/Thomas
as far as I know the 'tracking no' in PO is used to give direct visibility of SC in ECC, which is otherwise not available.
In SC the PO no is as it is available in BBP_PDBEI
so tracking no may not be required.
Can you check in yr system for a SC
for which GR/IV has been created in ECC
whether any of the follow fields in table BBP_PDBEI
are filled
BE_REFOBJ
BE_REFOBJ_ITEM
BE_REFOBJ_SBITM
BE_REFOBJ2
BE_REFOBJ_ITEM2
don't have the sys fully up
hence can not check
programme BBP_GET_STATUS_2 is responcible for updating the follow-on info in SC.
BR
Dinesh
Sorry, missed the last 2 remarks
Edited by: Dinesh Powale on Aug 26, 2008 6:53 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.