topic Re: RESB(Reservation/dependent requirements) table (Reference table & Ref. Field) in Application Development and Automation Discussions

RESB(Reservation/dependent requirements) table (Reference table & Ref. Field)

lakshminarasimhan_n4 — Mon, 01 Dec 2014 02:37:59 GMT

Hi Gurus,

We have RESB table in ECC system.

RESB table has many reference fields, for example RESB table has field NOMNG(Quantity) and its reference field is MARA-MEINS.

Now when i display the data in RESB table, it does not show the MARA-MEINS.

In the table display we have NOMNG(Quantity) field but not its unit (MARA-MEINS).

I need to take the data in this table to BW system, but i am not able identify the unit of this NOMNG(Quantity) field.

Please share the inputs.

Note - We have MEINS field present in the RESB table, but i don't know why this field is not being used as reference field for

NOMNG(Quantity)

Re: RESB(Reservation/dependent requirements) table (Reference table & Ref. Field)

Former Member — Mon, 01 Dec 2014 03:43:59 GMT

Hi Lakshminarasimhan N

Reference fields are something like unit for qty fields, currency unit for currency fields and etc. It need not be physically available in table for display. If you want you can join RESB and MARA table and get MEINS if you really want to show the unit or you can also use the dependent unit in tbale RESB if it exists.

Thanks,

Naveen

Re: RESB(Reservation/dependent requirements) table (Reference table & Ref. Field)

lakshminarasimhan_n4 — Mon, 01 Dec 2014 06:34:18 GMT

Hi Naveen,

Thanks. I will not be able to link RESB & MARA because say RESB has 500 records, for some records "MATNR" is blank, if i join RESB-MATNR = MARA-MATNR i will miss out the records in RESB, as all records in RESB will not be fetched because of blank MATNR in RESB.

NOMNG(Quantity) field can be made to refer MEINS in RESB, but i am not sure if its the right way or if i am linking the right MEINS to NOMNG(Quantity) field.

Re: RESB(Reservation/dependent requirements) table (Reference table & Ref. Field)

Former Member — Mon, 01 Dec 2014 07:00:51 GMT

HI lakshminarasimhan,

you can use an outer join to achieve that.

THanks,

naveen

Re: RESB(Reservation/dependent requirements) table (Reference table & Ref. Field)

lakshminarasimhan_n4 — Mon, 01 Dec 2014 07:52:59 GMT

Hi Naveen,

Thanks.

But going forward if you see there are fields in RESB like,

ROANZ -- This field references table RC29P and field ROAME.

There is no relationship between the two tables RESB & RC29P.

Re: RESB(Reservation/dependent requirements) table (Reference table & Ref. Field)

lakshminarasimhan_n4 — Mon, 01 Dec 2014 10:09:49 GMT

Any answers available gurus ?

Re: RESB(Reservation/dependent requirements) table (Reference table & Ref. Field)

RaymondGiuseppi — Mon, 01 Dec 2014 10:37:22 GMT

RC29P is a structure, so programmatically filled, don't expect a foreign relation key

Did you perform some where-used on this structure or its field from SE11, to identify form as GET_RC29P_VALUES in include MC29MF11 or FILL_IOOPCOMP_TAB_EXT in include DBIOCF03 (TCS03).

Regards,

Raymond