Extract data from domain-value range

[Former Member]

Hi,

I have a requirement to extract data from Domain-Value range.

I am using MDM generic extractor(mdmgx)

in 'Maintain ports and check tables' i can create a port but i should mention a table name.

I have a 'DOMAIN'

with a specific value range:

01 text1

02 text2

03 text3

so on...

i need to get these entries as a part of extracted data.

Could you please tell me how to do this?

Thanks a lot in advance.

Regards,

Rashmi

[Former Member · Accepted solution]

Hi Rashmi,

Try to find out the data element and cosequently the table of the domain using the where used list.

As far as I know,you need to feed the table name only, domains are not allowed.

Alternatively if it is an indicator type of domain with a handful of values, no need to extract them.

Directly input the values manually using the data manager.That seems to be a better and and easy way out.

Hope it helps.

Thanks,

Minaz

[michael_theis · Accepted solution]

Hey guys,

you're making things much to complicated. For extracting Domains with MDMGX, the TABLE NAME equals the DOMAIN NAME. Example for domain XFELD that is a common Yes/No Flag:

CLIENT 000

SYSTEM TYPE R3

OBJECT TYPE Vendor

MDM PORTCODE LT_YesNoIndicator

TABLE NAME XFELD

NONLANG FIELDS KEY=Key

LANG FIELDS LANGKEY=LANGKEY,VALUE=Name

WHERE CLAUSE

LINK INFO

FUNC XML

FUNC XSD

PROCESS LEVEL 0

TABLE NAME equals the domain name.

NONLANG FIELDS and LANG FIELDS use default entries as defined above.

If you check your system for "table" XFELD, you'll clearly see that it's a domain.

Cheers

Michael

[Former Member · Accepted solution]

Thanks a lot Michael. The issue is solved now.

[Former Member]

Hi Rashmi

Put the domain name as table in 'Maintain ports and check tables'.

best regards

Ravi