topic Re: Table and function modules in Application Development and Automation Discussions

Table and function modules

Former Member — Fri, 24 Apr 2009 05:29:33 GMT

Xperts,

i have matnr,vkorg,vtweg,spart ,kunnr

i need to get the sales details

suggest some table and function modules plz..

Re: Table and function modules

GauthamV — Fri, 24 Apr 2009 05:30:51 GMT

Tables : VBAK,VBAP.

Re: Table and function modules

Former Member — Fri, 24 Apr 2009 05:31:33 GMT

Hi,

Try this FM-

SD_SALES_DOCUMENT_READ.

Or you can check FM 'SD_SALES_DOCUMENT_PREFETCH'.

Pass 'X' to all fields in structure I_SALES_VIEW.

Pass SD number to I_VBAK_KEYTAB table.

Re: Table and function modules

Former Member — Fri, 24 Apr 2009 05:34:56 GMT

Check the below tables and function modules/BAPI

Tables are VBAK,VBAP,

Function modules are SD_SALES_DOCUMENT_READ

BAPI_SALESORDER_GETLIST or BAPISDORDER_GETDETAILEDLIST

Re: Table and function modules

Former Member — Fri, 24 Apr 2009 05:36:04 GMT

Hello Anoop,

U start with VBRK,VBRP and for Basic Price and other taxes fetch data from KONV based on 'kschl'.

If u want Excise doc number use table j_1iexchdr.

For ur help refer sample code

SELECT DISTINCT a_{vbeln a}fkart a_{vkorg a}vtweg a_{fkdat b}netwr a_{knumv b}werks b_{mwsbp a}fksto

c_{kunnr a}kunag d_{name1 d}stras d_{ort01 d}regio e~spart

f_{trntyp f}exgrp f_{exnum f}exdat b_{vgbel b}aubel b_{matnr b}posnr b_{fkimg b}gsber b_{erdat b}lgort b_{kursk_dat a}kdgrp a_{rfbsk a}bukrs

INTO CORRESPONDING FIELDS OF TABLE vvk

FROM ( vbrk AS a

INNER JOIN vbrp AS b

ON a_{vbeln = b}vbeln

JOIN likp AS c

ON b_{vgbel = c}vbeln

JOIN kna1 AS d

ON c_{kunnr = d}kunnr

JOIN tspa AS e

ON b_{spara = e}spart

LEFT OUTER JOIN j_1iexchdr AS f

ON a_{vbeln = f}rdoc

and f~trntyp = 'DLFC')

WHERE ( a~vbeln IN s_bill )

AND a~fkart IN s_fkart

AND a~vkorg IN s_vkorg

AND a~vtweg IN s_vtweg

AND ( a~fkdat IN s_bdate )

AND a~kdgrp IN s_kdgrp

AND ( a~kunag IN s_kunag )

AND b~gsber IN s_gsber

AND b~matnr IN s_matnr

AND ( b~spara IN s_spart )

AND b~werks IN s_werks

AND ( b~lgort IN s_lgort )

AND ( c~kunnr IN s_kunnr ).

********************************Basic Price

IF vvk[] IS NOT INITIAL.

SELECT knumv kschl kwert ksteu kbetr kposn FROM konv

INTO (i_konv2-knumv,i_konv2-kschl,i_konv2-basic,i_konv2-ksteu,

i_konv2-kbetr,i_konv2-kposn)

FOR ALL ENTRIES IN vvk WHERE

knumv = vvk-knumv

AND ksteu IN ('C','D','A','F')

AND kschl EQ 'PR00'.

COLLECT i_konv2.

CLEAR i_konv2.

ENDSELECT.

ENDIF.

Like wise for other taxes u can proceed.

Aastha

Re: Table and function modules

Former Member — Fri, 24 Apr 2009 05:36:30 GMT

VBRK and VBRP are sales invoice tables.for check numbers use PAYR

hope this helps

regards

Aakash Banga

Re: Table and function modules

Former Member — Fri, 24 Apr 2009 05:39:37 GMT

Hi,

To check the sales related table,

in SE11 you can write VB* and

then press F4, it will fetch you all sales

related tables.

Hope it helps

Regards

Mansi

Re: Table and function modules

Former Member — Fri, 24 Apr 2009 06:47:06 GMT

hi u will get all Sales order details from

VBAK -- HEADER

VBAP --ITEM

KONV -- PRICING CONDITION pass vbak-knumv and vbap-posnr.

VBEP-- SCHEDULE LINE

VBPA -- PARTNER FUNCTIONS

Re: Table and function modules

Former Member — Fri, 24 Apr 2009 07:15:56 GMT

Hi,

Try with tables KNVV and MVKE (Customer and material sales data).

Regards,

Raju.