topic Re: Need Select Query in Application Development and Automation Discussions

Need Select Query

Former Member — Thu, 01 Feb 2007 12:02:38 GMT

hi,

Need Select Query for this...

12. Check if the document category TVLK-VBTYP = ‘7’ where TVLK-LFART = LIKP-LFART (Delivery Type) then this is and Inbound Delivery for a purchase order.

13. Check the value of field Shipment External ID#1 (VTTK-EXTI1) is not initial then check the BOL Data Format. If not VICSBOL then set the variable LI_INBVICS = ‘N’. and assign Shipment External ID#1 to Shipment External ID#2 i. e VTTK-EXTI2 = VTTK-EXTI1. and Check the TMS BOL Format. If VICSBOL then set LI_INBVICS = ‘Y’ .

Re: Need Select Query

Former Member — Thu, 01 Feb 2007 12:08:44 GMT

select data from tvlk into it_tvlk for all entries in it_likp

where lfart = it_likp-lfart.

loop at it_tvlk where vbtyp = '7'.

<write ur code>.

endloop.

Re: Need Select Query

Former Member — Thu, 01 Feb 2007 12:18:02 GMT

Hi,

IF TVLK-VBTYP = ‘7’ and TVLK-LFART = LIKP-LFART.

Inbound Is for a Purchase order.

ELSE.

Inbound Is not for a Purchase order.

Endif.

IF not VTTK-EXTI1 is initial.

IF BOL DATA <> VICSBOL.

LI_INBVICS = ‘N’.

VTTK-EXTI2 = VTTK-EXTI1

else if BOL DATA <> VICSBOL.

LI_INBVICS = ‘Y’

Endif.

endif.