Searching for structures

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

Regs

Chris

[Former Member]

Hi

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

[Former Member]

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

Regs

Chris

[Former Member]

Hi

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

[Former Member]

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

Regs

Chris

[Former Member]

Hi

Just a query on DD03L table

Max

[Former Member]

Thanks for your help, but no other possibilities?

Regs

Chris

[Former Member]

Hi

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