Currently, we have installed above extractors in BW. Our functional team would like to add on 2 additional fields, which is Document type & Business Transactions. The problem is, what is the logic behind the above extractors and can we add on these 2 fields into the extractor?
Your feedback is much appreciated.
WBS_1 contains sum records instead of document lines so you should not be able to get a document type from this. WBS_6 contains the posting lines so you should be able to enhance it. I don't know where the business transactions field is located in the ERP so I cannot advice here.
Since the 0CO_OM_WBS_1 DataSource contains totals data and is sourced by R3/ECC tables COSS and COSP, then you should enahce this one with the Business Transactions data (COSP-VRGNG). Document Type, however, is a detail-level characteristic and therefore wouldn't be appropriate for the 0CO_OM_WBS_1 DataSource.
The 0CO_OM_WBS_6 DataSource is sourced by the COVP view. If, when you say Document Type, you're referring to the Reference Document Type, it's already on the DataSource and is sourced by COVP-REFBT. However, if you're talking about the FI Reference Document Type, your best bet would be to enhance the 0CO_OM_WBS_6 DataSource from COVP-BLART.
Enhance the DS. see the simple logic what I enhanced '0CO_OM_WBS_6'.
Add both fiedls to DataSources and then discuss with Functional/Business people and then find teh tables and write logic like below.
WHEN '0CO_OM_WBS_6'. LOOP AT c_t_data INTO i_s_data_wbs6. l_tabix = sy-tabix. SELECT SINGLE lifnr ebeln INTO (i_s_data_wbs6-lifnr,i_s_data_wbs6-zzebeln) FROM mseg WHERE mblnr = i_s_data_wbs6-refbn. IF sy-subrc = 0. MODIFY c_t_data FROM i_s_data_wbs6 INDEX l_tabix. ENDIF. ENDLOOP.