customs export declaration screen fields - form mapping

[Former Member]

Friends,

I have to map data from customs export declaration document to a print form.

I am new to using GUID keys and do not know how to use them while selecting data from tables.

Further, I am not sure how to link the screen fields in the customs export declaration to table fields in the GTS system as i have to display data in the form based on the value in screen fields in the customs document.

Points will be rewarded for helpful answers.

Regards,

John.

[Former Member · Accepted solution]

John,

Double click on the /SAPSLL/PRN_IF_S deep structure which is assigned to IS_PRN in the section GLOBAL SETTINGS.

Have a look at the structures and tables embedded in the above deep structure.

It's Customs document header, item & other details so you do not have to write SELECT statements to read the data again.

It's all availabe in there.

Write the data to your parameters(as explained in my previous post) to print on the form output.

Hope this helps.

Thanks

[Former Member]

John,

Call the function module READ_TEXT and pass

the ID, LANGUAGE, NAME and OBJECT.

Pass IS_PRN-H_GEN-GUID_CUHD to NAME(THEAD-TDNAME).

Read the table LINES from the function module into a work area(WA_LINES) and output the data on the form.

ID and OBJECT are maintained in SPRO.

Goto SAP GTS ---> General Settings ---> Text Control ---> Define Text Determination Procedures for Customs Shipments and Declarations.

Hope this helps.

Thanks

[Former Member]

John,

I do not see component H_TXT.

I used function module READ_TEXT to read the texts and show them on the output.

Thanks

[Former Member]

RK,

I also used READ_TEXT function module to read data from STXH table, but that becomes sort of hard coded.

Please let me know how you used READ_TEXT function module to read the header texts from the customs document.

Your response will be greatly appreciated.

Regards,

John.

[Former Member]

John,

I do not see the structure IS_PRN-H_TXT in my system.

Anyhow, to read the data from table types ,you can refer to my earlier post(I pasted it below).

For the table types H_PAR, I_GEN etc...

read the table H_PAR into a workarea(WA_H_PAR) of TYPE /SAPSLL/PRN_H_PAR_S and move data.

Partner number variable = WA_H_PAR-PARNO.

Thanks

[Former Member]

RK,

Please check again. IS_PRN has a component H_TXT ( which is for Customs Document Header:Texts).

If not , do you know any component where the header texts might be stored.

Regards,

John.

[Former Member]

John,

Select data from the table /SAPSLL/CUHD

by passing the customs document to the field CORDER.

Get the GUID_CUHD from the above table and pass this to

the table /SAPSLL/CUIT and get all the item relevant data.

I guess you can also write a join.

As most of the data is in the parameter IS_PRN, I do not think you've to do lot of selects unless your requirement needs you to write.

For the structures H_GEN & H_REF, just pass the data

to the variables(output parameters on the form) as

Incoterms vairable = IS_PRN-H_GEN-INCOT.

Similarly, for the table types H_PAR, I_GEN etc...

read the table H_PAR into a workarea(WA_H_PAR) of TYPE /SAPSLL/PRN_H_PAR_S and move data.

Partner number variable = WA_H_PAR-PARNO.

Hope this helps.

Thanks

[Former Member]

Hi RK,

Thank you for your reply.

I have copied the standard interface /SAPSLL/PF_US_7525V. The IS_PRN parameter is present in the import parameters of the interface.

The form layout is a customized one that i created from scratch.

I would like to get clarified on one question: Is the data from customs export declaration document automatically transferred to the IS_PRN parameter WITHOUT the need for any selection statement from /SAPSLL/CUHD or /

SAPSLL/CUIT or any other tables?

This question may be a very basic question but i need to know if this is the case. Please clarify.

Regards,

John.

[Former Member]

Hi RK,

Thank You for your reply.

I am able to print data from is_prn-h_gen to the form.

I have to print some header text from the document. I checked out the IS_PRN structure and found out that IS_PRN-H_TXT of type (/SAPSLL/PRN_H_TXT_T) might contain the header text values from the document. Please let me know if this is true.

Further, the structure looks pretty complex as

/SAPSLL/PNT_H_TXT_S has an internal table TLINES that has the field TDLINE that, in my estimation, holds the text id value.

Please give me few hints on how to access the value of the header texts from IS_PRN structure.

Please reply.

Regards,

John.

[Former Member]

John,

You can use tables /SAPSLL/CUHD to read the

Customs document header details.

Pass the GUID_CUHD from this table to the table

/SAPSLL/CUIT(Customs document item details) to

get the item data.

You can use other tables like /SAPSLL/PNTPR, /SAPSLL/PR,

/SAPSLL/PRCON, /SAPSLL/BOPHD, /SAPSLL/BOPIT etc.

to fetch the Product and Bill of Product details.

To print the data using T5, T1, SAD smartforms you can use standard parameter IS_PRN(provided in the smartform) which contains all the customs document data.

Hope this helps.

Thanks

[Former Member]

Hi RK,

Thanks for your reply.

I am new to GUID concept and don't know how to pass the GUID_CUHD from /SAPSLL/CUHD table to the table

/SAPSLL/CUIT. I would greatly appreciate if you could provide more information or some sample code for the same.

My form interface has IS_PRN parameter as input parameter. Does this mean i dont have to write select statement to pass data from the customs declaration document to the form interface.

Please reply.

Regards,

John.