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...