Skip to Content
avatar image
Former Member

How to enhance the datasource 0SRM_TD_PO using table BBP_PDIHP

In R3 when any PO is deleted at the header/item level the field LOEKZ is populated in tables EKKO(Header)/EKPO(item level).

Similarly in SRM when any PO is deleted at the header/item level the field DEL_IND is populated in tables BBP_PDHGP(Header)/BBP_PDIHP(item level). In current situation we have standard datasource 0SRM_TD_PO, this has a field as ITM_DEL_IND which is coming from table BBP_PDIHP(item level) and its always blank and its not getting populated , so we are not able to eliminate the deleted PO's in BW.

To overcome this, I have a following approach :

=====================================

Enhance the datasource 0SRM_TD_PO to include a "ZZDELIND" field and populate this field via CMOD from tables BBP_PDHGP(Header)/BBP_PDIHP(item level). The issue is I'm not able to determine the relation/join/data model between the datasource and the tables. The datasource 0SRM_TD_PO has a PO#(OBJECT_ID) but the tables BBP_PDHGP(Header)/BBP_PDIHP(item level) dont have a PO# instead these tables have a key as "GUID"which is HEXA decimal.

Can someone please help me out.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jan 26, 2012 at 01:51 PM

    two ways:

    1. call FM bapi_po_getdetail and pass the PO number, you will get all your details

    2. pass PO number to CRMD_ORDERADM_H to get the the GUID and use this GUID on BBP_PDHGP(if version control is active then you need to consider the active version only)

    and for item guid, pass the GUID picked from CRMD_ORDERADM_H to CRMD_ORDERADM_I-HEADER, you will get all the item guids as CRMD_ORDERADM_I.

    this can be passed to BBP_PDIGP.

    there are beautiful views as well joining these tables(BBP_PDVIEW*).. which you can use as well

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 26, 2012 at 04:45 PM

    There is no table called CRMD_ORDERADM_I-HEADER. Can you please be ellaborative on the option 1. ?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      There is no table called CRMD_ORDERADM_I-HEADER. Can you please be ellaborative on the option 1. ?

      table name: CRMD_ORDERADM_I

      field name : HEADER