05-15-2007 11:02 AM
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
05-15-2007 11:04 AM
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
05-15-2007 11:07 AM
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
05-15-2007 11:09 AM
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
05-15-2007 11:13 AM
Yes, I also prefer this method. So there no other standard program or function module which could I use?
Regs
Chris
05-15-2007 11:08 AM
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
05-15-2007 11:12 AM
GLPCA is a table which contains "EC-PCA: Actual Line Items". What exactly did you mean?
Regs
Chris
05-15-2007 11:14 AM
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
05-15-2007 11:17 AM
thanks, but my question was a general question. How could I search for structures with SAP standard tools.
Regs
Chris
05-15-2007 11:20 AM
05-15-2007 11:22 AM
05-15-2007 11:39 AM
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