How to enhance the datasource 0SRM_TD_PO using table BBP_PDIHP

[Former Member]

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.

[Former Member]

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

[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

[Former Member]

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