cancel
Showing results for 
Search instead for 
Did you mean: 

Purchase requsition nr column in sourcing cockpit

Former Member
0 Kudos

Dear Al,

Can you please advise how to add purchase requsition nr(external requirements) to "Overview of requirements" screen in sourcing cockpit? I will reward with points usefull answers.

kind regards,

Robert

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

hi,

At our place we have modified the ITS template to display the Purchase requisistion no in one of the present columns(Like Manufacturer etc).

You can do it with Screen variant but it is not displayed as discussed with Vani on the same requirement in this Forum.

Refer the foll link for details:

BR,

Disha.

Pls reward points for useful answers.

Former Member
0 Kudos

Hi Disha,

Thanks.

We also put it into Manufacturer part nr but it's not very nice solution but quick, at least Did you change the column header so it doesn't show Manufacturer Part nr but i.e. 'Purchase req.' or you left it as it was? We want to change it but do not know how...

I rewarded you with points.

regards,

Robert

Former Member
0 Kudos

hi,

From your reply i understand you are not familiar with ITS template modification

The link i have given in the prev reply contains the source code modification to be done.

You need to modify the template SAPLBBP_SOCO_UI_ITS_300 of the service BBPSOCO01.

At our place,instead of the INFO RECORD column(You could display the PR no in place of any other column which you intend to hide),the PR no was displayed.

The code for INFO RECORD was changed as follows:

`if(ci_mfr_no_ext_WL != "" && TC_ITEMLIST-column[ci_mfr_no_ext_WL].title != "")`

`TD(active="")`

`GS_ITEMLIST-EXT_DEMID[j].value`

`end`

Also ,all the places where the INFO RECORD field code is present,it needs to replaced with "EXT_DEMID".(EXT_DEMID stores the PR no).

So you need to Modify the COLUMN HEADER also to display the required text i.e. <b>Purchase requisition</b>.

Please mail me at disha_1008@yahoo.co.in for sample source code.

BR,

Disha.

Pls reward full points for useful answers.

Former Member
0 Kudos

Hi Disha,

I knew most of the things you wrote but it's good to have a confirmation.

I was able to change the column name and now I have what I needed.

I rewarded you with the points.

many thanks,

Robert

Former Member
0 Kudos

Hi Robert,

I have simillar requirement and I done that like this:

in program SAPLBBP_SOCO_UI_ITS in screen 300 add following code:


	`TD()`
            `if(GS_ITEMLIST-OBJECT_ID[j].value == "")`
               
	      `GS_ITEMLIST-EXT_DEMID[j].value` / `GS_ITEMLIST-EXT_DEM_POSID[j].value`
            `end`

Regards,

Marcin Gajewski

Former Member
0 Kudos

Hi Marcin,

Can you tell me where exactly to add it? Does it show a new column or replaces contents of some current not used?

regards,

Robert

Former Member
0 Kudos

Hi,

If you are using ITS go to transaction SE80 and choose internet service BBPSOCO01.

go to Theme 99 and open SAPLBBP_SOCO_UI_ITS_300 template.

Search for something like that:


          `TD()`
            `if(GS_ITEMLIST-OBJECT_ID[j].value == "")`
               
            `else`
              <a href="JavaScript:callItemlistService('`CALL_SC_ITEM_BUTTON.okcode`','`GS_ITEMLIST-ITM_GUID[j].value`')" onmouseover="status=' ';return true;"  onmouseout="status=' ';"
                alt="`#DETAIL``CreateSeperator()``GS_ITEMLIST-OBJECT_ID[j].value`/`GS_ITEMLIST-NUMBER_INT[j].value`"  title="`#DETAIL``CreateSeperator()``GS_ITEMLIST-OBJECT_ID[j].value`/`GS_ITEMLIST-NUMBER_INT[j].value`">
                `GS_ITEMLIST-OBJECT_ID[j].value`/`GS_ITEMLIST-NUMBER_INT[j].value`</a>
            `end`

This is the row with SC number.

below this code add another row:


	`TD()`
            `if(GS_ITEMLIST-OBJECT_ID[j].value == "")`
               
            `else`
 `GS_ITEMLIST-OBJECT_ID[j].value` / `GS_ITEMLIST-NUMBER_INT[j].value`</a><br/>
	      R/3: `GS_ITEMLIST-EXT_DEMID[j].value` / `GS_ITEMLIST-EXT_DEM_POSID[j].value`
            `end`

When you do this - activate and transport the service.

You must remember that this is only a row. You must add a header too.

Search in this template following code:


    `TD()`
        `if(GS_SOCO_ITEMLIST-SORT_INFO-COLUMN_NAME == "OBJECT_ID")`
          `if(GS_SOCO_ITEMLIST-SORT_INFO-SORT_ORDER == "D")`
            <a href="JavaScript:sortItemlistColumn('OBJECT_ID','A');" onmouseover="status=' ';return true;"  onmouseout="status=' ';" alt="`TC_ITEMLIST-column[15].title` `#SORT_UP`" title="`TC_ITEMLIST-column[15].title` `#SORT_UP`">
            `TC_ITEMLIST-column[15].title`</a>...

and add a TD column like this:


`TD()`

Regards,

Marcin Gajewski

Answers (4)

Answers (4)

khan_voyalpadusman
Active Contributor
0 Kudos

there is one note with number 902112 , which solves the issue

but this note is pilot note and not available for all customers

Former Member
0 Kudos

Hi Marcin,

It did not work for me - I get syntax error. Would you be so kind and send the whole screen code to my email: robiik_pl@yahoo.com?

regards,

Robert

Former Member
0 Kudos

Hi,

If you try to add a new column by changing the Template then it will not be possible.(The column no in the array is fixed..so probably you will not be able t change it only through the template).

There are many unwanted columns whcih you can replace to display the Purchase requisition no.

BR,

Disha.

Pls reward points for useful asnwers.

former_member195032
Active Contributor
0 Kudos

Hi Robert,

Make standard setting in SPRO in R/3 side to transfer Requisition to SRM system.

SPRO->Integration with other SAP components->SRM->Plan Driven procurement.

Just see text to make entries.

Schedule the report BBP_EXTREQ_TRANSFER in the back end and the requisitions transfer to the Enterprise Buyer system.

In SRM system,in Organization plan

-Make Entry Channel for RFC user

-Define local purchasing group

-Set up resposibility for entry channel and product category.

See SRM 210 config guide material,it contains some useful information in addition to what Mahesh has suggested.

regards,Nishant

Former Member
0 Kudos

Dear Both,

You misunderstood me. I have purchase reqs in my sourcing cockpit but I would like to see the pur. req. nr in on of the columns. In standard it's not showing, you have to go into details and choose "follow-on documents".

regards,

Robert

former_member195032
Active Contributor
0 Kudos

Hi Robert,

I have a custom report which gives me backend requsition number of requirement number from sourcing application.

Create a Z report using that if you want to use it in SRM easy access menu.Otherwise look for option to enhance the template using this logic.

regards,Nishant

REPORT Z_SHOPCART_REQUISITION.

DATA : lw_sc_header TYPE bbp_pds_sc_header_d.

DATA : lt_item_rel TYPE STANDARD TABLE OF BBP_PDS_ILREL,

lw_item_rel Type BBP_PDS_ILREL.

DATA : lt_sc_item TYPE STANDARD TABLE OF bbp_pds_sc_item_d,

lw_sc_item Type bbp_pds_sc_item_d,

lt_sc_header TYPE STANDARD TABLE OF bbp_pds_sc_header_d.

DATA: Begin of lt_extract occurs 0,

lw_sc_number Type BBP_PDS_SC_HEADER_D-OBJECT_ID,

lw_sc_req_no Type BBP_PDS_ILREL-OBJTYPE_A,

lw_sc_req_li Type BBP_PDS_ILREL-OBJ_ITEM_A,

End of lt_extract.

DATA: l_repid like sy-repid.

TYPE-POOLS: SLIS.

DATA: GT_FIELDCAT TYPE SLIS_T_FIELDCAT_ALV.

DATA: G_REPID LIKE SY-REPID.

DATA: LS_FIELDCAT TYPE SLIS_FIELDCAT_ALV.

DATA: POS TYPE I VALUE 1.

PARAMETERS : SC_Num LIKE BBP_PDS_SC_HEADER_D-OBJECT_ID OBLIGATORY.

  • Calling Shopping Cart.

G_REPID = SY-REPID.

clear ls_fieldcat.

LS_FIELDCAT-COL_POS = POS.

LS_FIELDCAT-FIELDNAME = 'LW_SC_NUMBER'.

LS_FIELDCAT-text_fieldname = text-001.

ls_fieldcat-ref_fieldname = 'OBJECT_ID'.

LS_FIELDCAT-REF_TABNAME = 'BBP_PDS_SC_HEADER_D'.

APPEND LS_FIELDCAT TO GT_FIELDCAT.

clear ls_fieldcat.

POS = POS + 1.

LS_FIELDCAT-COL_POS = POS.

LS_FIELDCAT-FIELDNAME = 'LW_SC_REQ_NO'.

LS_FIELDCAT-text_fieldname = text-002.

ls_fieldcat-ref_fieldname = 'OBJTYPE_A'.

LS_FIELDCAT-REF_TABNAME = 'BBP_PDS_ILREL'.

APPEND LS_FIELDCAT TO GT_FIELDCAT.

clear ls_fieldcat.

POS = POS + 1.

LS_FIELDCAT-COL_POS = POS.

LS_FIELDCAT-FIELDNAME = 'LW_SC_REQ_LI'.

LS_FIELDCAT-text_fieldname = text-003.

ls_fieldcat-ref_fieldname = 'OBJ_ITEM_A'.

LS_FIELDCAT-REF_TABNAME = 'BBP_PDS_ILREL'.

APPEND LS_FIELDCAT TO GT_FIELDCAT.

  • SubRoutine to get the data for display.

Perform get_data.

sort lt_extract by LW_SC_REQ_LI.

CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY'

EXPORTING

I_CALLBACK_PROGRAM = G_REPID

IT_FIELDCAT = GT_FIELDCAT[]

TABLES

T_OUTTAB = lt_extract.

  • Data fetch logic.

form get_data .

lw_sc_header-object_id = SC_Num.

CALL FUNCTION 'BBP_PD_SC_GETDETAIL'

EXPORTING

i_object_id = lw_sc_header-object_id

TABLES

e_item = lt_sc_item

e_itmlim_rel = lt_item_rel.

LOOP AT lt_sc_item INTO lw_sc_item.

READ TABLE lt_item_rel into lw_item_rel

WITH KEY ITM_GUID_B = lw_sc_item-guid.

if sy-subrc = 0.

lt_extract-lw_sc_req_no = lw_item_rel-OBJECT_ID_A.

lt_extract-lw_sc_req_li = lw_item_rel-OBJ_ITEM_A.

endif.

lt_extract-lw_sc_number = lw_sc_header-object_id.

Append lt_extract.

ENDLOOP.

endform. " get_data

Former Member
0 Kudos

Hi Nishant,

Thanks for the report but it's no use for us. We need the pur. req. nr to bo visible in the sourcing cockpit.

regards,

Robert

Former Member
0 Kudos

Hi Robert,

you have to maintain a reponsible purchasing group for the respective product categories in the organisation structure.

It is not possible to add Purchase Requistions individually in ot Overview of requirements.

This scenario is normally considered as Plan driven Procurement in SRM .

For more information how to bring External Requirements into SRM as Purchase Requisions see help.sap.com

and check the docs in Service Market Place.

with regards,

mahesh