on 09-18-2007 6:08 PM
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
Hi Sri,
Try this ...
To get existing fields from the communication structure
 go to the customizing cockpit (TCode LBWE)
 click structure maintenance (2LIS_11_VAITM)
 change to MCVBAP in the selection criteria
 look for the fields from the right hand side
 move the fields to the extract-structure on the left hand side
 save your settings
 system automatically creates an append to the delivered extract-structure which contains the selected fields
 Generate DataSource again
 Reactivate Extract-Structure
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
.
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.
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
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
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.