cancel
Showing results for 
Search instead for 
Did you mean: 

Enhancing Datasource - URGENT

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi,

Thank you for the reply.

I am not able to see these fields in the right hand side (extract structure maintainance of lbwe) to move them to left hand side.

My question is how can I see these custom fields in VBAP and MCVBAP in LBWE (right hand side of the extract structure maintainance to be able to move them to left hand side)

Sri

.

Former Member
0 Kudos

The extract structure should be with Green Traffic light then you can Maintain

Former Member
0 Kudos

Sri,

You will doubleclick on "structure maintainance" of the extract structure, you will then be prompted to create a workbench request, you will create your request, then, click continue and you should get to a selection criteria screen, this is where you will do the selection.

hope this helps.

Former Member
0 Kudos

Thank you for your replies.

I am sorry to say this, but I do know the procudure to enhance the datasource. Fortunately or unfortunately I am working in BW from 2 years and most of my experience is in MM and SD (i.e. LO).

Sorry for not being very clear... My question is there are some ZZ fields appended to table VBAP. As per Roberto's Blog these fields should be avialable in the right hand side of extract structure maintainance of LBWE to be able to enhance the datasource with these new zz fields added to VBAP.

Now my problem is these fields are not available in right hand side of extract structure maintianance. So i am not able to enhance the datasource with these ZZ fields from LBWE.

How can I get those fields in the right hand side of the extract structure maintainance in LBWE? Is there any setting to get these field available in the right hand side of the extract structure maintainance of LBWE?

Sri

Former Member
0 Kudos

Sri -

Check if the SAP Notes 328255 and 351214 apply to your situation. Good luck!

Former Member
0 Kudos

hi Sri

the fields are not in the maintainance of the extract structure in lbwe because they are certainly not in the communication structure even though they are appended to the table.

try the following

go to se11 enter the structure MCVBAP display and maintain append structure there.

after that activate.

Go back to lbwe extract structure maintainance and should find them.

if it is not working you will have to maintain the extract structure and populate the new fields in the exit for transaction data.

hope this could help you

regards

Boujema

To encourage people trying to help you assign them points a simple way to say thank for helping me in sdn

bye

0 Kudos

Hi,

can i have ur email id...will send u the document..

Former Member
0 Kudos

Thank you for all the replies

My mail id is

sapbwsri.n@gmail.com

Former Member
0 Kudos

Sri,

Take a look at SAP Notes 328534, it may help your situation.

good luck !

Former Member
0 Kudos

Sri,

More OSS notes 351214 & 375837