Skip to Content
author's profile photo Former Member
Former Member

Enhancing Datasource - URGENT

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Sep 18, 2007 at 07:17 PM

    Hi Sri,

    Try this ...

    To get existing fields from the communication structure

    &#61656; go to the customizing cockpit (TCode LBWE)

    &#61656; click structure maintenance (2LIS_11_VAITM)

    &#61656; change to MCVBAP in the selection criteria

    &#61656; look for the fields from the right hand side

    &#61656; move the fields to the extract-structure on the left hand side

    &#61656; save your settings

    &#61656; system automatically creates an append to the delivered extract-structure which contains the selected fields

    &#61656; Generate DataSource again

    &#61656; Reactivate Extract-Structure

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.