Transfer additional fields from ECC TO GTS

[former_member188671]

Hi All,

Which user exit is used to transfer additional fields from ECC To GTS?

What is the significance of document types to transfer additional fields?I have to transfer RMA(Return,repair,replenishment) Specific sales order additional fields from ecc, but i am not able to these fields in sales order ? How can i find these fields:- refurbished indicator, defective/delivery indicator, serial no. of defective order.Is there any way to find these fields in ecc?

suppose i find these fields than how can i check whether the 2nd user exit that you have suggested is transferring data to GTS?

Which parameter of User exit is used to do so?

Is there any transaction to check in ECC(to transfer fields of sales order) & GTS ?

Is there any limitation of .Includes structures in GTS in /SAPS//CUHD & /SAPSLL//CUIT?

Thanks in advance.

Regards,

Pratibha Aggarwal

[former_member215181]

Hi Pratibha,

WHY do you have to transfer those fields to GTS - for what purpose?

There are technical workarounds for the transfer of additional fields to GTS, but let's make sure that there is some valid business reason for doing so.

Regards,

Dave

[former_member188671]

Hi Dave,

Yes it is my client requirement to do so...Please help me by providing some documents doing so for sales order data transfer (PDF /Sample code)..

Thanks in advance..!!!

Regards,

Pratibha Aggarwal

[thomasrausch]

Hello Pratibha,

you use the user exit FM EXIT_SAPLSLL_LEG_CDPIR3_002 on the ECC side?

In the transfer structure CS_API6800 TYPE  SLLR3_API6800_R3_S you find the structure header   type sllr3_api6800_header_s and here you find the structure gen like /sapsll/api6800_hdr_r3_s and here you find the following additional fields for the header data:

ADD_DATA1 CHAR10 CHAR 10 0 Character Field Length = 10

ADD_DATA2 CHAR15 CHAR 15 0 Char 15

ADD_DATA3 DD_STRUC CHAR 30 0 Name of DDIC transfer structure.

For the structure item type sllr3_api6800_item_s you will find the same in the structure gen type sllr3_api6800_itm_r3_t and sllr3_api6800_itm_r3_t like /sapsll/api6800_itm_r3_s.

These are additional fields for the Position data.

On the GTS side they will be stored in the table /SAPSLL/CHUD: ADDDA1,ADDDA2 and ADDDA3 and also in the table /SAPSLL/CUIT: ADDDA1, ADDDA2 and ADDDA3.

This is the SAP standard.

If you want to Transfer more information, you must extend the Standard structures by append structures.

Hope that helps...

Regards,

Thomas

[former_member188671]

Hi,

Can i enhance my .INCLUDE /SAPSLL/CUHD_CUST_S  in /sapsll/cuhd

                            .INCLUDE /SAPSLL/CUIT_CUST_S    in /sapsll/cuit

in GTS by doing .append

or is there any other way to do so in GTS?

The fields that i add to these .Include structures are visible under EXIT_SAPLSLL_LEG_CDPIR3_002?

Regards,

Pratibha Aggarwal

[former_member188671]

Hi,

As i have to append 7 new fields to these structure ?

Regards,

Pratibha Aggarwal

[thomasrausch]

Hello Pratibha,

the user Exit EXIT_SAPLSLL_LEG_CDPIR3_002 is a functionmodule in ECC where you can modify the data that are send to GTS. The fields I mentioned are fields in the ECC structure /sapsll/api6800_hdr_r3_s and /sapsll/api6800_itm_r3_s. If you fill them they will be automaitcally stored in the corresponding fields of the table /SAPSLL/CUHD and /SAPSLL/CUIT.

In your custom declaration you will find the fields under the tab Administration.

If you want to add new fields you must extend the transferstructure in ECC and the corresponding structures in GTS and, of course do some programming in GTS to fill /SAPSLL/CUHD and CUIT correct.

Regards,

Thomas

[former_member215181]

Hi Pratibha,

No, I don't doubt that someone is asking you to do it.  What I'm asking is; what are the functional requirements?  For what reason, and with what intentions, is your client asking you to transfer the extra data?

For example, will you really meet the client's requirements just by transferring the extra data to GTS?  Surely they have something more in mind than just duplicating data in tables?

Regards,

Dave

[former_member188671]

Hi Dave,

This is my requirement ...

**************************

1. I. OVERVIEW

A. Business Driver

RMA (Returns, Replacement and Repair) specific fields are not part of standard interface during transfer of Document from ECC to GTS. Annex A in PDD identifies Fields are that are required to be transferred to SAP GTS. Certain fields are available when RMA specific Order is created in ECC.

B. Key business requirements

Compliance Team during review of Blocked Documents, require visibility to additional data to make informed decision whether Document under GTS Block can be released or not. Certain documents have to be released on priority and priority can be determined by SLA, Region, Customer etc.

C. High level Process overview

Documents (Sales Order Types and Delivery Order Types) are created in ECC. Upon creation, they are replicated in GTS as Customs Sales Order and Customs Delivery Order. The documents upon replication undergo various Compliance checks such as Sanction Party List Screening, Embargo Screening and Export License Screening.

The Documents can fail to pass such checks and will be blocked in GTS. Subsequent functions such as Delivery Creation with Reference to such Blocked Sales Orders or PGI (Post Goods Issue) with Reference to Blocked Delivery Orders cannot be performed in ECC till the referenced Blocked Documents are released in GTS.

1. II.   DETAILS

A. Detail Processing Logic:

To transfer additional Data during Sales Order creation (RMA specific Documents), SAP provides required user exits to influence Data Transfer.

Additional Data Field Mapping in ECC created specifically for RMA Orders

Required Data	Data Source	Source System
Refurbished Indicator	Sales Order - Item Level	ECC
Defective/Returns Indicator	Sales Order - Item Level	ECC
Sr.No. of Defective Material	Sales Order - Item Level	ECC
Sr.No. of Replacement Unit	Sales Order - Item Level	ECC
Agreement / Contract No.	Sales Order - Item Level	ECC (Conditional)
Service Level Agreement - SLA	Sales Order - Item Level	ECC
Address Change Flag	Sales Order - Header Level Sales Order - Item Level	GTS (Partner Address Change)

This user exit is available in the plug-in to to influence Sales & Distribution document data you transfer to SAP Global Trade Services(SAP GTS).

• /SAPSLL/GTS_CMOD_DOC - Transfer of MM and SD Documents (Enhancement Project SLLLEG01)
• Multiple user exists are available under this enhancement Project
• User Exits - EXIT_SAPLSLL_LEG_CDPIR3_001
• User Exits - EXIT_SAPLSLL_LEG_CDPIR3_002
• User Exits - EXIT_SAPLSLL_LEG_CDPIR3_003

This Data in GTS will be mapped in Additional Data Tab. Both Header and Item Level has includes that will hold the Data transferred.

• Header Table - /SAPSLL/CUHD
  • Include - /SAPSLL/CUHD_CUST_S 
• Item Table - /SAPSLL/CUIT
  • Include - /SAPSLL/CUIT_CUST_S

There are limitations to how many Data Elements can be stored in the structures mentioned above. Before writing the TDD, the ABAP Team should investigate the possibility of implementation. The other alternative can be storing the Data in Z Table in GTS.

Address Change Flag (Additional Processing Logic)

This flag will be determined based on presence of New and Old Installed at site Address Partner Function in RMA Sales Order. A Z Field will capture the Flag if the Address changes occur and will be blank if the Address hasn’t changed.

B. Business Logic and Rules Definition 

• By utilizing standard delivered enhancement spots, the interface that is responsible for replicating Orders in GTS.

• Restrict the replication of Data for specific Order Types. This would require a Z Table to be created in ECC to store the relevant Document Types.

• Original Installed at Site and Requested Installed at Site Address will be defined as Partner Functions and will be part of FS created to address Partner Function address changes at Transaction Level.

***************************

Regards,

Pratibha Aggarwal

[former_member188671]

Hi Thomas,

In your custom declaration you will find the fields under the tab Administration.

How can i go to custom declaration & tab administration in GTS ..?

Please tell me which transaction in GTS which i can enhance for my requirement ??

& how can i debug the same in ECC & GTS at the same time ..where i need to put debugger?

Regards,

Pratibha Aggarwal

[thomasrausch]

Hello Pratibha,

for Debugging look at

http://scn.sap.com/message/16183362#16183362

Use Transaction /n/SAPSLL/CL_CP_CUS_EX to view the custom declarations. If you have picked up one go to the "tap collection" Icon on the right side of the Tabs and you find the Administration tab.

Here you find the additional fields

Hope that helps

Regards,

Thomas

[thomasrausch]

Hello Pratibha,

you want to Transfer additional data for your orders, not for you custom declaration. Okay. First pick Transaction SPRO and go to:

Foreign Trade/Customs ---> SAP Global Trade Services - Plug- --->In Business Add-Ins for SAP Global Trade Services --->Change and Supplement Document Data for Transfer ---> BAdI for Mapping and Enrichment of Data from Sales Documents (SD0A).

Here you must implement your BAdI e.g.

and activate it

Then you can go to the Interface an pick up the coding for the Methode IF_EXTEND_CON_CDOC

Here you can use the following structures

In the structrue sllr3_api6800_con_hdr_s and sllr3_api6800_con_itm_s you'll find the same fields that I have described for the customs declaration .

You can now carry out the same for your deliveries by using the next customizing Point ---> BAdI for Mapping and Enrichment of Data from Outbound Deliveries (SD0B)

Hope that helps

Regards,

Thomas

[former_member188671]

Hi Thomas,

I have one doubt ..than what is the use of SLLLEG01 user exit ?

The badi that you  have told me contains bapi extension structures..?

please tell me ..

Regards,

Pratibha Aggarwal

[thomasrausch]

Hello Pratibha,

I don't think, that the exit SLLLEG01 will work as you want. Has you implemented the BAdi I mentioned? Please do it  I have done it and here are my result: I create an order and the system

stops at my break point

This is the Debugger view and here you can look at the local structures

and here you find the additional fields that can be filled by some coding...

By the way, if you look at your order in GTS the tab for the additional data is

I have debugged the "creation" of an order and pit some data in the additional field an the result is

  I hope you get an idea of how it might be done.

Regrads,

Thomas

[former_member215181]

Hi Pratibha,

Thanks.  It seems obvious that the transferred fields should be seen in the Customs Document (Sales Order replica).

You should use the BAdI described by Thomas, but you should use the Extension structures, rather than appending new fields to the ERP transfer structures - that's what I meant by "There are technical workarounds for the transfer of additional fields to GTS".  There are corresponding BAdIs (documented in the IMG) to copy the fields into the Customer appends in the standard structures.

And you will also need BAdI /SAPSLL/BADI_CDOC_EX_UI_CON to add new tabs in the document.

Good luck!

Dave

[former_member188671]

Hi Thomas,

What is transaction in GTS for custom documents ?

i have to add 7 fields both in ecc & gts ..so where i can append my fields both in GTS & ECC ?

Thanks in advance...

Regards,

Pratibha Aggarwal

[thomasrausch]

Hello Pratibha,

TC /SAPSLL/CL_CP_CUS_EX for custom declaration and TC /SAPSLL/CUOR04_EXP for other documents.

Pick up the FM /SAPSLL/CD_SD0C_R3 in ECC and search for api6800_csd_synchronize. Here you find the transferstructure gs_api6800. As an abaper you'll find the spot where you have to make the enhancements (a little bit of double clicking, you will find the structure /sapsll/api6800_hdr_r3_s). On the GTS side you have the FM /SAPSLL/API_6800_CSD_SYNCH. In GTS you must enhance the same structures as in ECC. E.g. : ECC is structure /SAPSLL/API6800_HDR_R3_S and the corresponding GTS structure is /SAPSLL/API6800_HDR_S.

As Dave mentioned go to customizing:

Customs Management --> Business Add-Ins for Customs Management -->Integrate External Applications with Documents.

Here you have read the documentation two thing

BAdI: UI Control When Connecting External Applications to Documents

BAdI: Data Backup from External Applications in Customer Tables

Read them and decide what to do.

Hope that helps

Regards,

Thomas

[Former Member]

Prathiba,

If it is a return sales order then don't you think it need to be mapped as inbound document in GTS?

User exit I have provided will bring all the data from the respective document and you can change the content for the structures whcih are getting mapped to GTS structures.

Best thing you could do in this situation is - Ask your Abapper to put a break point and show you the content being passed to GTS and you can figure out which fiedls you have to map additionaly into GTS structures.

Once the data reaches GTS, you can remove the newly mapped content and map them to the necessary fields i.e. document types into the declarations.

Regards

Raj

[former_member188671]

Hi Dave/Rajesh,

If possible do you have any sample pdf or code to do so ..?

after writing code in user exit 2 what transaction i have to run in ecc to check whether my user exit is getting triggered or not? & similar what i have to do in GTS ..whether i have to add these additional fields in cuhd & CHIT Tables under .Include ..& by which transaction i can test the same in GTS?

I am a abaper & totally new to gts.

Regards,

Pratibha Aggarwal