Skip to Content
0
Former Member
Sep 13, 2007 at 03:15 PM

ERROR: The column name "BELNR" has two meanings. ABAP/4 Open SQL statement.

2474 Views

these are my selction parameters:

SELECT-OPTIONS: S_DATE FOR BKPF-BLDAT,

S_BELNR FOR BKPF-BELNR.

PARAMETERS: P_BLART LIKE BKPF-BLART DEFAULT 'WL/re' OBLIGATORY.

my table is :

TYPES: BEGIN OF TY_GET_PO_DETAILS,

BELNR LIKE RSEG-BELNR,"ACCOUNT DOCUMENT NUMBER

GJAHR LIKE RSEG-GJAHR,"FISCAL YEAR

EBELN LIKE RSEG-EBELN,"PO NUMBER

BUKRS LIKE RSEG-BUKRS,"COMPANY

MONAT LIKE BKPF-MONAT,"FISCAL PERIOD

END OF TY_GET_PO_DETAILS.

DATA: T_GET_PO_DETAILS TYPE STANDARD TABLE OF TY_GET_PO_DETAILS,

WA_GET_PO_DETAILS TYPE TY_GET_PO_DETAILS.

MY SELECT STATEMENT IS

IF NOT S_DATE IS INITIAL AND

NOT S_BELNR IS INITIAL.

SELECT A~BELNR "SELECTING THE PO NUMBER AND REFERENCE

A~GJAHR " AND ITEMMBER INTO TABLE

A~EBELN

A~BUKRS

B~MONAT

INTO CORRESPONDING FIELDS OF TABLE T_GET_PO_DETAILS

FROM RSEG AS A

INNER JOIN BKPF AS B

ON ABELNR = BBELNR

WHERE BELNR = S_BELNR

ENDIF.

NOW WHEN I DO SYNTAX CHECK ,IT IS THROWING AN ERROR MESSAGE ...

The column name "BELNR" has two meanings. ABAP/4 Open SQL statement.

CAN ANY ONE HELP ME WITH THIS PROBLEM...