Need Material Description in SAPscript Export Packing list

[Former Member]

Hi Friends,

I copied standard SAPscript form SD_EXPORT_FUEP for Export packing list. I need a Material description in main window but not able to get. Please tell me how to get the material description.

Thanks,

Ziad

[Former Member · Accepted solution]

hi

in the script the structure V55ENAFT has field

MAKTX MAKTX CHAR 40 0 Material Description (Short Text)

U can use this &V55ENAFT-MAKTX&

surya

[Former Member · Accepted solution]

Hi Surya,

I already tried V55ENAFT-MAKTX but not getting description. Is there any other option to get it?

Thanks,

Ziad

[Former Member · Accepted solution]

hi

Actually the field MAKTX should contain it or else Check VBELN_VL_TEXT also or else

u have Delivery ---VBELN_VL_ITEM

line item POSNR then goto LIPS get the Matnr and MAKT get the Description..

U need to write the Perform ENDPERFORM .

surya

Edited by: suryareddy on Aug 19, 2009 12:16 PM

[Former Member · Accepted solution]

Dear Zaid,

You can get it from MARA table by using select statement.

Select single maktx into v_maktx from mara where matnr = V55ENAFT-matnr.

hope your problem will be solved.

Syed Tayab Shah

[Former Member · Accepted solution]

Hi Surya,

I am using this SAPscript for Export packing list for billing. I tried to fetch material description from VBRP table using Invoice number and item number by writing subroutine but not able to getting it. Please give me any idea how to fetch desc.

Thanks,

Ziad

[Former Member · Accepted solution]

Hi Tayab,

I tried with Material Number also from V55EPACK-MATNR but not able to get it. Give me any idea how to fetch it.

Thanks,

Ziad

[Former Member · Accepted solution]

HI Ziad,

CHeck in debugging the Script waht u r getting a Billing Document if so use VBRP-ARKTX ...

or else if u get SALES ORDER then VBAP or else Delivery go to LIPS..

DID u write PERFORM ENDPERFORM and pass the correct fields i.e either the Billing Document or Delivery # and posnr or else Sales order and POsnr and get back the MAKTX ..

Check even the V55EPACK-matnr ..or else check for V55ENAFT-BSTNK_HEADER which is the Purchase Order

VBELN--Sales Order VBELN_VL_HEADER -Delivery#

Check the Structure V55ENAFT what it has

surya

[Former Member · Accepted solution]

Hi Surya,

Here is my subroutine,please check it. Still I am not getting description.

PROGRAM ZSD_EXPORT.

tables: VBRP, VBRK, V55ENAFT.

********form routine to fetch the material description

form GET_DESC tables in_par structure itcsy

out_par structure itcsy.

DATA: BEGIN OF S_MAT.

• VBELN TYPE VBRP-VBELN,

• POSNR type VBRP-POSNR,

• ARKTX type VBRP-ARKTX,

include structure vbrp.

data: END OF S_MAT.

data: it_line like V55ENAFT-POSNR,

inv_no like V55ENAFT-VBELN.

data: mat_desc type VBRP-ARKTX.

read table in_par with key 'ITLINE'.

check sy-subrc = 0.

it_line = in_par-value.

read table in_par with key 'INV'.

check sy-subrc = 0.

INV_NO = in_par-value.

*SELECT SINGLE VBELN POSNR ARKTX FROM VBRP INTO S_MAT where vbeln = inv_no and posnr = it_line.

select single * from vbrk

where vbeln = inv_no.

SELECT SINGLE * FROM VBRP

WHERE VBELN = vbrk-vbeln AND POSNR = IT_LINE.

move vbrp-arktx to mat_desc.

read table out_par with key 'DESC'.

check sy-subrc = 0.

out_par-value = mat_desc.

modify out_par index sy-tabix.

*

endform. "get_desc

Thanks,

Ziad

[Former Member · Accepted solution]

Hi Ziad

use CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'...

as the VBELN will not be in the correct format in the Script so

read table in_par with key 'INV'.

check sy-subrc = 0.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

input = in_par-value

IMPORTING

output = INV_NO.

and use this value in the query forVBRP table and use select single arktx fromVBRP where vbeln = inv_no and posnr = it_line.

surya

[Former Member · Accepted solution]

Hi Surya,

Problem solved. Thanks a lot.

Ziad Khan.