Need to fetch data of PRCD_COND table from corresponding transparent table

[Former Member]

Hello,

The requirement is to fetch the data of PRCD_COND table from the corresponding transparent table.

Do we extract the PRCD_COND table's data from any transparent table or by joining transparent tables?

Regards,

Yogesh Verma

[spencer_liang · Accepted solution]

To select from PRCD_COND for a document.

assuming we have the document in iv_document_id.

data: lv_header_guid type raw.

data: lv_pricset_guid type raw.

data: lt_prc_cond type PRCD_COND.

FIELD-SYMBOLS: <fs_prc_cond> like line of PRCD_COND.

select GUID into lv_header_guid from crmd_orderadm_h where OBJECT_ID = iv_document_id.

* retrieve prc condtion set with header guid. the type 18 means prc condition. type of set is stored in table crmc_objects

select GUID_SET into lv_pricset_guid from crmd_link where GUID_HI = lv_header_guid and objtype_set = "18" and objtype_hi = "05".

select * into  lt_prc_cond from prcd_cond where KNUMV = lv_pricset_guid

loop at lt_prc_cond into <fs_prc_cond>.

* your logic.

endloop.

Spencer

[Former Member · Accepted solution]

Thanks Spencer,

The data of PRCD_COND table which is a clustered pool table and I want to fetch the data in the Data Services. This is causing performance issue because of ABAP program. Are there any alternative table or tables at the database to extract the data?

Regards,

Yogesh