Question:
we would like to display adressinformation in a BEx Quiery in the following form:
Surname Name
Street Streetnumber
PLZ Town
Has anyone a idear how to realise this with the standard BEx functionality (not using crystal) ? Thanks for any help.
Answer:
Do you intend to create a mailing list ? If yes, just use standard Excel functionality, by combining Visual Basic with your query.
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
Where do you want to get this from? Employee, Customer, or what?
If its Employee, I believe that is already available in a DS. If its customer, then it should be available as well (I don't know about surname, but address definately is.)
Or is this external to BW or SAP?
- Stephen
Answer:
Stephen,
thanks for the reply, but I think you misunderstood the question. The data is already available (attributes to 0BPARTNER), but we need to know how to display the attributes like this:
Name Surname
Adress
Postal Code City
Country
All this without using Crystal Reports (or anything like that) or Visual Basic. Any ideas?
Thanks
Katrin
Where do you want to get this from? Employee, Customer, or what?
If its Employee, I believe that is already available in a DS. If its customer, then it should be available as well (I don't know about surname, but address definately is.)
Or is this external to BW or SAP?
- Stephen
Answer:
BW/BEx is a query and OLAP analysis tool, not a formatted reporting tool.
Answer:
If you simply want to report on that information, as long as it is an attribute of an InfoObject you are reporting on then you can simply add in the attributes you want to display in a BEx query - which can either be run in Excel or on the web.
Or am I still missing something?
If you simply want to report JUST on the InfoObject and it's attributes - seperate from an ODS or Cube, just make it (the InfoObject) a data target and you can report against it and all its available attributes.
- Stephen
Answer:
I think BWTeam's issue is not whether the address information can be reported, but that each part of the name and address should appear immediately below the other, all in the same column, rather than side-by-side in different columns.
Special formatting is required for this display, and BEx workbooks can not accomodate this.
Answer:
Guest, thanks, I didn't catch that.
He is looking for address label type of output then. I am not sure how to handle this. I can't think of anyway to put together a query so that it display's like this.
You may look at the table API, but it would seem rather complicated to get to your end result.
- Stephen