Suoritettu

fix the error for abap code for join tables

REPORT ZSOIPQ.

TYPE-POOLS: slis.

TABLES: VBAK,

VBAP.

TYPES: BEGIN OF ty_vbak,

VBELN TYPE VBELN_VA, "Sales Document

AUART TYPE AUART, " Sales Document Type

END OF ty_vbak.

TYPES: BEGIN OF ty_vbap,

VBELN TYPE VBELN_VA, "Sales Document

POSNR TYPE POSNR_VA, " Sales Document Item

MATNR TYPE MATNR, "Material Number

END OF ty_vbap.

DATA : gt_vbak TYPE TABLE OF ty_vbak,

st_vbak TYPE ty_vbak.

DATA : gt_vbaP TYPE TABLE OF ty_vbaP,

st_vbaP TYPE ty_vbaP.

PARAMETERS: P_vbeln TYPE vbeln.

START-OF-SELECTION.

SELECT vbeln

posnr

matnr

FROM VBAP

INTO TABLE gt_vbap.

SELECT vbak~vbeln

VBAK~AUART

VBAP~vbeln

VBAP~posnr

VBAP~matnr

INTO TABLE gt_vbak

FROM VBAK

INNER JOIN VBAP

ON VBAK~vbeln = VBAP~vbeln

where auart eq 'ZQPC' AND VBAK~vbeln GE '0030000000'.

if sy-subrc = 0.

loop at gt_vbaK INTO st_vbaK.

APPEND st_vbaK to gt_vbak.

AT FIRST.

WRITE: /10'Sales Document',

35 'Sales Document Type',

65 'Sales Document Item',

100 'Material Number'.

ENDAT.

WRITE: /13 ST_VBAK-vbeln,

43 ST_VBAK-auart,

72 ST_VBAP-POSNR,

90 ST_VBAP-MATNR.

ENDLOOP.

SORT gt_vbap.

DELETE ADJACENT DUPLICATES FROM gt_vbap.

endif.

Taidot: SAP

Näytä lisää: rocket theme fix error, web development fix error 403, fix bad php code, oscommerce ups fatal error evald code line, fix error oading website, fix error script page, fix error 80004005 line, fix error 80004005, fix error line object expected, fix error object expected companys network, source code dynamic crystal report design using vb6, fix error image, can fix error loading page websites, code vb6 crystal report verion, freeware program fix error code 80004005, fix error code 80004005 works, code fix error sql injection php, fix error code authoize net, fix error code android

Tietoa työnantajasta:
( 5 arvostelua ) melaka, Malaysia

Projektin tunnus: #20322783

Myönnetty käyttäjälle:

catafeidi

Hi, I can fix it easily. Please check the profile to see my background in SAP ABAP. Thanks! BR, Cata

$15 USD 1 päivässä
(0 Arvostelua)
0.0