topic RM07DOCS_GENERATED giving error in Application Development and Automation Discussions

RM07DOCS_GENERATED giving error

Former Member — Tue, 30 Nov 2010 05:53:21 GMT

Hi Experts ,

select (g_t_fields)

into corresponding fields of table itab

from mkpf inner join mseg

on mkpf_{mandt = mseg}mandt

and mkpf_{mblnr = mseg}mblnr

and mkpf_{mjahr = mseg}mjahr

WHERE MSEG~AUFNR in AUFNR

and MSEG~BPMNG in BPMNG

and MSEG~BPRME in BPRME

and MSEG~BSTMG in BSTMG

and MKPF~BUDAT in BUDAT

and MSEG~BWART in BWART

and MSEG~BWTAR in BWTAR

and MSEG~CHARG in CHARG

and MKPF~CPUDT in CPUDT

and MKPF~CPUTM in CPUTM

and MSEG~EBELN in EBELN

and MSEG~GRUND in GRUND

and MSEG~KDAUF in KDAUF

and MSEG~KOSTL in KOSTL

and MSEG~KUNNR in KUNNR

and MSEG~LGORT in LGORT

and MSEG~LIFNR in LIFNR

and MSEG~MATNR in MATNR

and MKPF~MBLNR in MBLNR

and MSEG~MEINS in MEINS

and MSEG~MENGE in MENGE

and MKPF~MJAHR in MJAHR

and MSEG~SOBKZ in SOBKZ

and MKPF~USNAM in USNAM

and MKPF~VGART in VGART

and LIKP~VSBED in VSBED

and LIKP~VSTEL in VSTEL

and MSEG~WERKS in WERKS

and MKPF~XBLNR in XBLNR

and MSEG~ZEILE in ZEILE

Because of these two fields (LIKP_{VSBED , LIKP}VSTEL) I am getting Dump .Wrong Alias Name.I know INNer join is wrong Here But How Can i Carrect It in (RM07DOCS_GENERATED ) in standard Program.

Thanks.

Regards: Hemant Gulati (A1).

Re: RM07DOCS_GENERATED giving error

Former Member — Tue, 30 Nov 2010 06:21:17 GMT

Dont change any thing in the above program. You need to check the view V_MMIM_REP_CUST. If there are any changes in that view will automatically reflect into tjhe above program RM07DOCS_GENERATED.

Thanks and Regards,

Chandra

Re: RM07DOCS_GENERATED giving error

Former Member — Tue, 30 Nov 2010 06:41:03 GMT

Hi Chandra,

I Checked view V_MMIM_REP_CUST does not Contains any Extra Fields(LIKP_{VSBED , LIKP}VSTEL).

Thanks.

Hemant Gulati(A1) .

Re: RM07DOCS_GENERATED giving error

Former Member — Tue, 30 Nov 2010 06:53:00 GMT

Have u checked entries in the view V_MMIM_REP_CUST and also check change history of that view using cheange logs.

It is not a technical issue. V_MMIM_REP_CUST is a table maintains the tables and fields to genarate the reports for Inventory Mgmt Reporting. Please find who changed the above table entries. If the table entries are not relevent then the generated reports also.

Thanks and Regards