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

[lakshminarasimhan_n4]

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)

[Former Member]

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

[lakshminarasimhan_n4]

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.

[Former Member]

HI lakshminarasimhan,

you can use an outer join to achieve that.

THanks,

naveen

[lakshminarasimhan_n4]

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.

[RaymondGiuseppi]

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

[lakshminarasimhan_n4]

Any answers available gurus ?