addint new field to the standard sapscript form.

[Former Member]

FOR SALES INVOICE DOCUMENT FORM PRINTING

TRANSACTION CODE: VF01

OUTPUT TYPE : FJCI

PROGRAM NAME: RVADAUS1

SAPSCRIPT FORM NAME: SD_EXPORT_FJCI

ENTRY ROUTINE: ENTRY_FJCI.

STRUCTURE USED FOR THIS OUTPUT TYPE = V55EFJCI

THE QUERY IS AS FOLLOWS:

I WANT TO ADD DATA MODE OF TRANSPORT FROM THE INVOICE DOCUMENT. THE TABLE AND FIELD IS T618-BEZEI.

SO I COPIED THE STANDARD FORM TO ZSD_EXPORT_FJCI AND THE STANDARD PROGRAM TO ZRVADAUS1.

I SUCCESSFULLY FETCHED THAT FIELD DATA.

I APPEND THE STRUCTURE 'ZAV55EFJCI' TO ADD THE ADDITIONAL T618-BEZEI FIELD.

AND WRITE MY SELECT QUERY IN THE ENTRY_FJCI FORM ROUTINE.

THE CODE IS AS FOLLOWS:

data: begin of it_mode_of_tp occurs 1,

bezei type t618t-bezei,

end of it_mode_of_tp.

select a~bezei as zzbezei into table it_mode_of_tp from t618t as a

inner join

eikp as b on a_{expvz = b}expvz and a_{land1 = b}aland inner join vbrk as

c on b_{exnum = c}exnum

where c_{vbeln = nast-objky and a}spras = nast-spras .

loop at it_mode_of_tp.

v55efjci-zzbezei = it_mode_of_tp-bezei.

endloop.

BUT THE DATA FOR THAT IS NOT GETTING DISPLAYED.

THIS WAS THE FIRST METHOD I FOLLOWD.

THE SECOND METHOD I DID WAS AS FOLLOWS:

FORM ENTRY_FJCI.

PERFORM PROCESSING.

ENDFORM

FORM PROCESSING.

PERFORM PRINT_DOCUMENT.

ENDFORM.

FORM PRINT_DOCUMENT.

CALL FUNCTION 'RV_EXPORT_DOCUMENT_PRINT'

ENDFORM.

IN THIS FUNCTION THE DATA IS GETTING FETCHED FROM THE DATABASE TABLES AND STORED IN THE STRUCURE V55EFJCI.

SO I COPIED THAT FUNCTION.

IN THIS FUNCTION , THEIR IS A INCLUDE PROGRAM 'LV55EF11' FOR FETCHING DATA FOR ENTRY_FJCI FORM ROUTINE.

I COPIED THAT PROGRAM CODE , AND CREATED MY OWN INCLUDE PROGRAM (WHICH I AM STORING IT IN ANOTHER Z PACKAGE.)

AND WRITTEN MY ABOVE CODE IN THAT PROGRAM. BUT WHEN I DO THIS, NOITHING GETS DISPLAYED , EVEN THE PREVIOUSLY COMING DATA ALSO NOT GETTING DISPLAYED.

HOW SHOULD I PROCEED.

[Former Member]

you said you copied layout(form) SD_EXPORT_FJCI to ZSD_EXPORT_FJCI,

you updated program to fetch datat & populate v55efjci-zzbezei field.

Now

- you need to modify layout(form) ZSD_EXPORT_FJCI via SE71 to insert your field in one of the windows where it has to be printed (sap script knowledge is required here).

- you need to either modify SAP output type FJCI to use your program/layout(form) or you need to create your own output type and assign your form/program to it, and in addition to that if you define your own output type - yo have to add it to output determination procedure, to access sequences, add condition records to condition table... so it's picked up by the invoice.