How to extract data from structures or create a datasource using structures

[Former Member]

Hello Friends , I have a requirement to extract data from ECC fields, but when i go look the table i found only "structures" REBD_CONTRACT_REL_L and i confirmed with ecc team that there are no table available with these fields so how do i now extract the data in BI using the fields in ecc that exist only in these Structures.

Please help me to resolve this

Thanks

Regards

Soniya

[Former Member · Accepted solution]

check tables

VIOBOV

(VIBDPLANOCC certainly not)

VICNCN table of the contrat

VIOROF table of the offers

VIBDOBJASS affectation of objects.

VICAINTRENO Affectation INTRENO / OBJNR / IMKEY

that will be a good start but ask again your functional persons.

If you want to upload data to BI you have to know the tables

bye

by the way a structure do not hold data.

[former_member205352]

Hey can you tell what data you want.

Where are you able to see the data which you want to fetch into BI.

[Former Member]

Hello,

Check this function module.

REBD_GUI_CNREL_PBO

Thanks,

@ KC

[former_member205352]

Write a function module to populate values to this struture.

Meaning use this struture fields and populate values to it from the tables you want to in function module.

Create a generic datasource based on function module.

Hence this will become a datasource.

Hope this helps.

[Former Member]

Hello Praveen. I appreciate your suggestion but problem is that these fields does not exist in any Table as you can also see in your system . That this structure has a assigned information field which is not there in any tables.

Thanks