cancel
Showing results for 
Search instead for 
Did you mean: 

Tales for data like PO, Invoice and confirmation

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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.

Former Member
0 Kudos

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

former_member183819
Active Contributor
0 Kudos

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

former_member183819
Active Contributor
0 Kudos

Hi

refer the below link on SRM tables

Go BBP_PD select the Business Object and click details -It leads you what are the tables are available.

Regards

Muthu

Former Member
0 Kudos

Thanks you very much.

However, I do not find the information I'm loooking for.

The information i'm interested in is the details found in the "Follow-on Documents" section of the shopping card.

Thanks in advance,

Thomas

former_member183819
Active Contributor
0 Kudos

Hi Thomas,

In SRM all the transaction type( like PO,CONF) are storing in CRMD_ORDER_H and CRMD_ORDER_I .You can check it up. All docs are storing based on GUID.

Regards

Muthu

Former Member
0 Kudos

Hi Muthu,

We are running a classic scenario.

How do i find the GUID for PO and Invoice when they are stored in back-end.

For the confirmation I do not find a link to that in BBP_PD?

Any ideas?

Thanks in advance,

Thomas

former_member183819
Active Contributor
0 Kudos

Hi

As you aware EKPO, EKKO....etc. Do you find one tracking number in the header data in the PO . Check It related to your PO.From here you can go...

Regrads

Muthu

Edited by: Muthuraman Govindasamy on Aug 25, 2008 1:27 PM

Former Member
0 Kudos

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

former_member183819
Active Contributor
0 Kudos

Hi

In the item overview TRACKING NUMBER of PO (field :- BEDNR -EKPO) .From PO you can trace GR/IV.

Regards

Muthu

Former Member
0 Kudos

Hi,

BEDNR is emty!

Thomas

former_member183819
Active Contributor
0 Kudos

Hi Thomas

Please see this link

regards

Muthu

Former Member
0 Kudos

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

former_member183819
Active Contributor
0 Kudos

Hi Thomas,

Note 676016 - SRM: Requirement Tracking Number not available

Please refer the above note.

regards

Muthu

Former Member
0 Kudos

I'm not interested in the tracking number!

Read my previous reply.

Thanks in advance,

Thomas

former_member183819
Active Contributor
0 Kudos

Hi Thomas

As far I know,You can map the SC number into the tracking number in PO so it helps you track the SC on the follow on document.

You must do development for this.

regards

Muthu

Former Member
0 Kudos

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

former_member183819
Active Contributor
0 Kudos

Hi Thomas

learnt that you are classic scenario .Did you define your transaction type for GR as well as IV right ?

or your business allows only for PO creation in backend remaining posting GR /IV in the back end only.

regards

Muthu

Former Member
0 Kudos

We do all postings in backend. PO, GR and IR.

However GR is possible in SRM also.

It is the GR and IR posting in backend I cannot find in SRM, even though that they are listed in the "Follow-on Documents" tab in the Shopping Cart.

/Thomas

former_member183819
Active Contributor
0 Kudos

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

Former Member
0 Kudos

I can find my ERP PO in table BBP_PDBEI

I can find my EBP GR in table BBP_PDVIEW_BIH with reference to the PO in field BE_REFOBJ

But I cannot locate my ERP GR and IR

/Thomas

former_member183819
Active Contributor
0 Kudos

Hi

You can not see r/3 documents in ebp . You have to check in back end only.

regards

Muthu

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Dinesh,

I do not find any entries in table BBP_PDBEI for the confirmations done in ECC.

However, the document number is listed in the "Follow-on Documents" tab in the SC.

/Thomas

Former Member
0 Kudos

then to find our answer we will have to debug

programme BBP_GET_STATUS_2

but i am not that expert in debugging

BR

Dinesh

Former Member
0 Kudos

That's my problem too 🐵

Any one that can help out on this 🐵

former_member183819
Active Contributor
0 Kudos

Hi Thomas

As advised by Dinesh ,try to give back end business object ( like BUS2081 for invoice) in the field(BE_OBJECT_ID) in table BBP_PDBEI .

regards

Muthu

Former Member
0 Kudos

Hi Muthu,

What I was proposing is

programme BBP_GET_STATUS_2 is responcible to update the SC for the ECC follow-on docs.

so if we can correctly debug this programme

it can tell us which tables in SRM are updated with the required info

i.e. GR and IV

Hope it is clear now.

BR

Dinesh