Line items

[Former Member]

Hi all,

In the table crmd_orderadm_h when will have object_id and guid fields.

Can a single PO have multiple guid values in the crmd_orderadm_h table?

I have found some POs have multiple guid's what that indicate? and

which guid should i take for multiple guids for single PO to get line

items from the table crmd_orderadm_I.

It is giving different values for multiple guids used in table

crmd_orderadm_I.

What multiple guids will signify?which guid shall i use to get correct

line items?

[Former Member · Accepted solution]

Hi

Each PO (or say for any document posted in SRM) will have header GUID and items GUID in crmd_orderadm_h & crmd_orderadm_i respectively. If you have multiple line items in the PO, each line item will have different GUID's tied to header GUID.

I dont think a document header(in your case PO) can have multiple GUID's.

The HEADER field in the crmd_orderadm_i is tied to the GUID field of crmd_orderadm_h.

Rgds

Reddy

[Former Member · Accepted solution]

Thanks for u reply..

The thing is will there be multiple guids in header table i.e, crmd_orderadm_h for single PO..

If so..can u explain it..

[Former Member · Accepted solution]

Hi Joseph,

GUID in CRMD_ORDERADM_H is unique and cannot be duplicated.

But if You have more than one client (mandant - MANDT column) this GUID may be duplicated.

For example I have two client: 200 and 210

I create following sql statement:

select * from crmd_orderadm_h -> 11424 rows

then

select guid from crmd_orderadm_h -> 11424 rows

select distinct guid from crmd_orderadm_h -> 11419 rows

select discinct client, guid from crmd_orderadm_h -> 11424 rows

I have 5 duplicated guids in crmd_orderadm_h table but this documents belongs to different clients.

Regards,

Marcin Gajewski

[Former Member · Accepted solution]

Hi Marcin,

Thanks for ur reply..

I am having only one client in the development server...Still some POs have multiple GUIDs for single POs..

So for this case which GUID shall i use in CRMD_ORDERADM_I table to get line items..

[Former Member · Accepted solution]

Hi Joseph,

There is only one single header GUID per SRM document in CRMD_ORDERADM_H. This header GUID can be linked to several GUIDs in item table CRMD_ORDERADM_I.

Look at transaction BBP_PD to get the data model and table relations.

If you have activated PO versionning, then you can have additional GUIDs: those are version GUIDs, linked to the header master GUID, created in version table and not in CRMD_ORDERADM_H.

Have you activated PO versionning ?

Rgds

Christophe

PS: please reward points for helpful answers

[former_member850518]

HI All ,

I am new in SAP SRM world , i have worked in ARIBA buyer module which is functionally same as SAP - SRM .

Can anyone help me how and where to run the query of a table .

1 . select * from CRMD_ORDERADM_H

2. select field1 , field2 from <table name > where <Field1> = 'xyz'

I am able to find the details of Shoping cart from Function module BBP_PD_SC_GETDETAIL .

[former_member191111]

Hi,

Could you tell about the scenario you are using in details? Are you using SUS too?

And also check whether in all GUID Process Type is different or not?

Regards,

Sachin

Message was edited by: Sachin S M