Skip to Content
0
Former Member
Dec 13, 2007 at 07:28 AM

Need help to check the code!

32 Views

In my program its not giving data for any value of VBELN.What is the reason !

I am only getting one record between 3000 and 5000 ! What is wrong here!

REPORT YINTERACTIVEPROGRAM01.

TABLES:VBAP,

VBPA,

vbak,

VBRP,

VBRK,

KNA1,

ADRC,

TPAR,

TVKGG,

TVM1T,

TVM2T,

TVM3T,

TVM4T,

VBKD,

SZA1_D0100,

TVLVT,

T002,

T178T.

Select-options S_VBELN for vbak-vbeln.

TYPES:BEGIN OF TY_TAB,

VBELN LIKE VBAK-VBELN,

VKORG LIKE VBAK-VKORG,

ERDAT LIKE VBAK-ERDAT,

AUGRU LIKE VBAK-AUGRU,

BSTDK LIKE VBKD-BSTDK,

BSTDK_E LIKE VBKD-BSTDK_E,

spart like vbap-spart,

kondm like vbap-kondm,

waerk like vbap-waerk,

netwr like vbap-netwr,

kwmeng like vbap-kwmeng,

vkaus like vbap-vkaus,

land1 like vbpa-land1,

nrart like tpar-nrart,

  • vtext like tpar-vtext,

parvw like tpar-parvw,

name1 like adrc-name1,

name2 like adrc-name2,

name3 like adrc-name3,

name4 like adrc-name4,

ort01 like kna1-ort01,

pstlz like kna1-pstlz,

vtext like t178t-vtext,

bezei1 like tvm1t-bezei,

bezei2 like tvm2t-bezei,

bezei3 like tvm3t-bezei,

bezei4 like tvm4t-bezei,

bezei5 like tvm5t-bezei,

BEZEI like tvlvt-bezei,

spras like t002-spras,

laspez like t002-laspez,

END OF TY_TAB.

DATA: ITAB TYPE STANDARD TABLE OF TY_TAB WITH HEADER LINE.

*parameters:salesno like itab-vbeln.

select s1~vbeln

s1~vkorg

s1~erdat

s1~augru

k1~BSTDK

k1~BSTDK_E

p1~spart

p1~kondm

p1~waerk

p1~netwr

p1~kwmeng

p1~vkaus

r1~land1

t1~nrart

  • t1~vtext

t1~parvw

n1~name1

n1~name2

n1~name3

n1~name4

c1~ort01

c1~pstlz

x1~vtext

t2~BEZEI

b1~bezei

b2~bezei

b3~bezei

b4~bezei

b5~bezei

t3~spras

t3~laspez

into corresponding fields of table itab

from vbak as s1

join VBKD as k1

on s1vbeln = k1VBELN

join vbap as p1

on k1vbeln = p1vbeln

join t178t as x1

on p1kondm = x1kondm

join vbpa as r1

on p1vbeln = r1vbeln

join tpar as t1

on r1parvw = t1parvw

join ADRC as n1

on r1adrnr = n1addrnumber

join kna1 as c1

on r1land1 = c1land1

join tvlvT as t2

on p1vkaus = t2abrvw

join t002 as t3

on c1spras = t3spras

join tvm1t as b1

on c1spras = b1spras

AND p1mvgr1 = b1mvgr1

join tvm2t as b2

on c1spras = b2spras

AND p1mvgr2 = b2mvgr2

join tvm3t as b3

on c1spras = b3spras

AND p1mvgr3 = b3mvgr3

join tvm4t as b4

on c1spras = b4spras

AND p1mvgr4 = b4mvgr4

join tvm5t as b5

on c1spras = b5spras

AND p1mvgr5 = b5mvgr5

up to 10 rows

WHERE S1~VBELN IN S_VBELN.

loop AT ITAB.

WRITE : /(30)'VBELN: ', ITAB-VBELN,

/(30)'VKORG: ', ITAB-VKORG,

/(30)'ERDAT: ', ITAB-ERDAT,

/(30)'AUGRU: ', ITAB-AUGRU,

/(30)'BSTDK: ', ITAB-BSTDK,

/(30)'BSTDK_E:', ITAB-BSTDK_E,

/(30)'SPART: ', itab-spart,

/(30)'KONDM: ', itab-kondm,

/(30)'WAERK: ', itab-waerk,

/(19)'NETWR: ' , itab-netwr,

/(17)'KWMENG: ', itab-kwmeng,

/(30)'VKAUS:', itab-vkaus,

/(30)'LAND1:', itab-land1,

/(30)'NRART:', itab-nrart,

/(30)'PARVW:', itab-parvw,

/(30)'ADDR1:', itab-name1,

/(30)'ADDR2:', itab-name2,

/(30)'ADDR3:', itab-name3,

/(30)'ADDR4:', itab-name4,

/(30)'PSTLZ:', itab-pstlz,

/(30)'ORT01:', itab-ort01,

/(30)'RUN TIME BAND DESC:', itab-BEZEI,

/(30)'Compiler desc:',itab-vtext,

/(30)'BEZEI:', itab-bezei,

/(30)'BEZEI1:', itab-BEZEI1,

/(30)'BEZEI2:', itab-BEZEI2,

/(30)'BEZEI3:', itab-BEZEI3,

/(30)'BEZEI4:', itab-BEZEI4,

/(30)'BEZEI5:', itab-bezei5,

/(30)'LASPEZ :', itab-LASPEZ,

/(30)'spras :', itab-spras.

uline.

ENDLOOP.

if sy-subrc <> 0.

write : / 'No data found'.

endif.