Skip to Content
0
Former Member
Sep 18, 2007 at 05:08 PM

Enhancing Datasource - URGENT

41 Views

Hello Experts,

I am working with datasource 2lis_11_vaitm.

My client enhanced the base table VBAP with few z fields (like zzoffer...). They want to extract these z fields into BW too.

I went through Robertos blog <a href="/people/sap.user72/blog/2005/02/14/logistic-cockpit--when-you-need-more--first-option-enhance-it's Blog for enhancing datasource</a> and understood that the z fields appended to base tables like vbap should be automatically available in LBWE (just drag the fields from right to left to add them to extract structure).

I doubt I might not have got it correct.

Text from Roberto's blog

<i><b>Getting to the root: enhance your application tables

The last resort of adding user-defined fields to extract structures is to directly enhance the document tables, in our example, VBAK, VBAP, VBEP (...).

The fields can then be filled in the general (sales) user exits for the applications and are also available in LBWE for enhancing the extract structures.

With this procedure, bear in mind that the fields added to the document tables must be saved at database level with the information they contain (with related space effort required), but, on the other side, there is no need for data retrieval in the LIS user exit.</b></i>

But these z fields added to VBAP are not showing up in LBWE for 2lis_11_vaitm (but i can see them available in comm structure mcvbap, they are added automatically to mcvbap when vbap is enhanced, not added manually by me)

Am i missing anything like the setting that should be made to see them in LBWE?

How can I see them in LBWE?

I can enhance the extract structure and write code in exit_saplrsap_001 to populate these fields, but i do not want to use this is I am looking for delta for these z fields.

Thanks for any help and I am bound to award points. Please help me it is urgent

Sri

.

Message was edited by:

Sri N