topic Re: Urgent select statements in Application Development and Automation Discussions

Urgent select statements

Former Member — Mon, 15 Jan 2007 05:52:36 GMT

Hi iam developing the smartform.In this smartform iam using the tables like ADRC,

VBAK,VEKP,VTTK,VTTS,MAKT,VEPO.

From ADRC table iam using fields NAME1,STREET,CITY1,REGION,POST_CODE1.

From VBAK table iam using the fields BSTNK,

From VEKP table VPOBJ,

From VTTK table TKKNUM,

From VTTS table TSRFO,

From MAKT table material description,

From VEPO table VPOBJKEY.

Please send me select stataments and data declartion.Very urgent.

Thanks & Regards,

sairam

Re: Urgent select statements

Former Member — Mon, 15 Jan 2007 06:13:03 GMT

Hi,

TYPES : BEGIN OF TY_ADRC,

NAME1 TYPE AD_NAME1,

STREET TYPE AD_STREET,

CITY1 TYPE AD_CITY1,

POST_CODE1 TYPE AD_PSTCD1,

REGION TYPE REGIO,

END OF TY_ADRC.

TYPES: BEGIN OF TY_VBAK,

BSTNK TYPE BSTNK,

END OF TY_VBAK.

TYPES: BEGIN OF TY_VEKP,

VPOBJ TYPE VPOBJ,

END OF TY_VEKP.

TYPES: BEGIN OF TY_VTTK,

TKNUM TYPE TKNUM,

END OF TY_VTTK.

TYPES: BEGIN OF TY_VTTS,

TSRFO TYPE TSRFO,

END OF TY_VTTS.

TYPES: BEGIN OF TY_MAKT,

MAKTX TYPE MAKTX,

END OF TY_MAKT.

TYPES: BEGIN OF TY_VEPO,

VPOBJKEY TYPE VPOBJKEY,

END OF TY_VEPO.

DATA : LIT_ARDC TYPE TABLE OF TY_ADRC,

LIT_VBAK TYPE TABLE OF TY_VBAK,

LIT_VEKP TYPE TABLE OF TY_VEKP,

LIT_VTTK TYPE TABLE OF TY_VTTK,

LIT_VTTS TYPE TABLE OF TY_VTTS,

LIT_MAKT TYPE TABLE OF TY_MAKT,

LIT_VEPO TYPE TABLE OF TY_VEPO.

SELECT NAME1

STREET

CITY1

POST_CODE1

REGION

FROM ADRC

INTO TABLE LIT_ADRC.

SELECT BSTNK

FROM VBAK

INTO TABLE LIT_VBAK.

SELECT VPOBJ

FROM VEKP

INTO TABLE LIT_VEKP.

SELECT TKNUM

FROM VTTK

INTO TABLE LIT_VTTK.

SELECT TSRFO

FROM VTTS

INTO TABLE LIT_VTTS.

SELECT MAKTX

FROM MAKT

INTO TABLE LIT_MAKT.

SELECT VPOBJKEY

FROM VEPO

INTO TABLE LIT_VEPO.

Rgds,

Prakash

Re: Urgent select statements

Former Member — Mon, 15 Jan 2007 06:26:58 GMT

declare ur internbal tables like this -

data: begin of itab occurs 0,

field1 like adrc-field1, "field1 n field 2 shud be fieldname from ADRC

field2 like adrc-field2,

end of itab.

fetch data -

select field1 field2 from adrc into table itab.

"declare ur all internal tabels like tht

Re: Urgent select statements

Former Member — Mon, 15 Jan 2007 06:53:19 GMT

Hi Prakesh,

Is it possiable to write any joins or for all entries for this tables.

Thanks & Regards,

Sairam

Re: Urgent select statements

Former Member — Mon, 15 Jan 2007 06:59:24 GMT

Hi Prakesh,

Iam using smartform.Please give me detail code and smartform function modules.Please it is very urgent.

Regards,

Sairam