topic Re: Searching for structures in Application Development and Automation Discussions

Searching for structures

Former Member — Tue, 15 May 2007 10:02:56 GMT

Hi everybody,

is there any simple possibility to search for structures which contains for example the fields KUNNR, MATNR and VKORG?

Because I need a structure which contains at least these three fields, I know I could create an own structure but if such a structure exists how could I find this?

I also could look in table DD03L but I wonder if there is a SAP standard program which I could use?

Thanks for any help

Chris

Re: Searching for structures

Former Member — Tue, 15 May 2007 10:04:44 GMT

hii david

go to se11

go to the data types of KUNNR, MATNR and VKORG

press where used list

you will get it

please reward if helpful

vikaas

Re: Searching for structures

Former Member — Tue, 15 May 2007 10:07:10 GMT

I know the function for the where used list, but here the disadvantage is that I only could search for one field. I nee to search structures which contains all three fiels at once!

Regs

Chris

Re: Searching for structures

Former Member — Tue, 15 May 2007 10:08:43 GMT

Try GLPCA

U should check where the data element KUNNR or VKORG is used and then check if all fields you need are in that structure.

For example the table GLPCA (for Special Ledger) has all fields you need.

I suppose severals tables of CO, CO-PA and GL should have those fields, but you can find the tables for the princing (AXXX) too.

Max

Re: Searching for structures

Former Member — Tue, 15 May 2007 10:09:40 GMT

I think the easiest way is thru DD03L table

Give the Fieldnames as KUNNR, XXXXX , XXXXX at a time, then you will get the table names or structures where these 3 fields are used

Re: Searching for structures

Former Member — Tue, 15 May 2007 10:12:07 GMT

GLPCA is a table which contains "EC-PCA: Actual Line Items". What exactly did you mean?

Regs

Chris

Re: Searching for structures

Former Member — Tue, 15 May 2007 10:13:07 GMT

Yes, I also prefer this method. So there no other standard program or function module which could I use?

Regs

Chris

Re: Searching for structures

Former Member — Tue, 15 May 2007 10:14:51 GMT

Just as I said, this table are the items generated for the Special Ledger, it's a particular FI module (like CO) used to analyze the data.

I can't understand why you needs those fields in the same structure.

Customer (KUNNR) and sales org. (VKORG) are header data, material is item data, so I think you can finds them in the tables of SAP modules (like CO, CO-PA, GL) used to consolidate the data

Max

Re: Searching for structures

Former Member — Tue, 15 May 2007 10:17:02 GMT

thanks, but my question was a general question. How could I search for structures with SAP standard tools.

Regs

Chris

Re: Searching for structures

Former Member — Tue, 15 May 2007 10:20:45 GMT

Just a query on DD03L table

Max

Re: Searching for structures

Former Member — Tue, 15 May 2007 10:22:20 GMT

Thanks for your help, but no other possibilities?

Regs

Chris

Re: Searching for structures

Former Member — Tue, 15 May 2007 10:39:39 GMT

I don't believe because all fms (I know of course) work knowing the table and they return the structure or other chararcteristics.

Anyway you can check all fm with the name begins with DD_

Max