|
y si intentas leer el de la cabecera? EKKO...
a mi me pasaba algo parecido por lo de las imputaciones...EKKN
cheka este query, chance y te da alguna idea
saludos!
select
ekko~ebeln
ekpo~ebelp
ekkn~zekkn
s2~packno
s2~introw
ekko~submi
s2~extrow
s2~srvpos
lfa1~lifnr
lfa1~name1
lfa1~name2
s2~ktext1
ekpo~txz01
s2~netwr
ekpo~menge
ekkn~nplnr
s2~tbtwr
s2~menge as srvmenge
prps~pspnr
prps~psphi
prps~POSID
proj~post1
into corresponding fields of table datos from ekkn
inner join ekko on ekko~ebeln = ekkn~ebeln
inner join lfa1 on lfa1~lifnr = ekko~lifnr
inner join ekpo on ekpo~mandt = ekkn~mandt and ekpo~ebeln = ekkn~ebeln and ekpo~ebelp = ekkn~ebelp and ekpo~loekz = ''
inner join esll as s1 on s1~mandt = ekpo~mandt and s1~packno = ekpo~packno and s1~del = ''
inner join esll as s2 on s2~mandt = s1~mandt and s2~packno = s1~sub_packno and s2~del = ''
inner join prps on prps~pspnr = ekkn~ps_psp_pnr
inner join proj on proj~pspnr = prps~psphi.
|