Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Quantity invoiced

former_member383741
Participant
0 Kudos

Hi,

i want the table name of both Quantity invoiced and Quantity of goods received.

can you help me.

Regards,

karthikeyan.K

1 ACCEPTED SOLUTION

GauthamV
Active Contributor
0 Kudos

Check these tables.

RSEG,MSEG.

9 REPLIES 9

Former Member
0 Kudos

hi,

EKBE

mseg

thanks

Former Member
0 Kudos

hi,

for invoice details

VBRK --BILLING HEADER

VBRP-BILLING ITEM

FOR DELIVERY DETAILS

LIKP- DELIVERY HEADER

LIPS- DELIVERY ITEM

Former Member
0 Kudos

Hi,

Use EKET - wemng for GR.

Regards,

Bathrinath

GauthamV
Active Contributor
0 Kudos

Check these tables.

RSEG,MSEG.

0 Kudos

Hi,

i want field name for *gr quantity * and ir quantity

Former Member
0 Kudos

hi,

You can get the GR/ GI quantity for a PO from EKBE table.

please see this

tahnks

Former Member
0 Kudos

Hello,

Refer this code.

SELECT DISTINCT avbeln afkart avkorg avtweg afkdat bnetwr aknumv bwerks bmwsbp afksto

ckunnr akunag dname1 dstras dort01 dregio e~spart

ftrntyp fexgrp fexnum fexdat bvgbel baubel bmatnr bposnr bfkimg bgsber berdat blgort bkursk_dat akdgrp arfbsk abukrs

INTO CORRESPONDING FIELDS OF TABLE vvk

FROM ( vbrk AS a

INNER JOIN vbrp AS b

ON avbeln = bvbeln

JOIN likp AS c

ON bvgbel = cvbeln LEFT OUTER JOIN j_1iexchdr AS f

JOIN kna1 AS d

ON ckunnr = dkunnr

JOIN tspa AS e

ON bspara = espart

ON avbeln = frdoc )

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 ).

Performance wise no issue.

Aastha

former_member383741
Participant
0 Kudos

Hi,

i want the table name and field name for.

GR QUANTITY AND GR AMOUNT

IR QUANTITY AND IR AMOUNT

Regards,

K.Karthikeyan

0 Kudos

MSEG-BSTMG --Goods receipt quantity in order unit

PLEASE Try std report MB51 FIRST , if not meet your requirement then go for custom reports

Tables: MSEG, MKPF