|
Hola, yo le agregaría un campo más... con lo que quedaría así:
SELECT d~kunnr d~land1 d~name1 d~mcod1 d~pstlz d~regio d~stras d~telf1 d~adrnr d~fiskn d~ktokd d~kukla d~stcd1 d~stcd2 d~lzone m~bukrs m~zuawa m~busab m~akont m~zterm m~webtr m~togru
FROM kna1 AS d INNER JOIN knb1 AS m
ON d~kunnr = m~kunnr
INNER JOIN knvv AS j
ON m~kunnr = j~kunnr and
m~bukrs = j~bukrs
INTO CORRESPONDING FIELDS OF TABLE gt_data
WHERE d~kunnr IN s_kunnr.
Slds,
|