Document History

...

About This Guide

This document describes User transactions in 3Keys Kazakhstan CEDM connector MPT in SAP ATTP system.

...

Solution overview

SAP ATTP delivers a solution to generate the reporting messages for Russian ISMT Kazakhstan CEDM system. The 3Keys Kazakhstan Connector MPT CEDM connector automate the communication and message transfer to Kazakhstan MPT CEDM system, visualize the message processing status with monitoring transaction, download and process the electronical document and receipts in ATTP 

...

CEDM cockpit transaction /K3TKZ/

...

EDO_MONITOR

The MPT CEDM cockpit transaction /K3TKZ/DOCEDO_MONITOR is used for the monitoring of Kazakhstan reporting to CEDM (Includes all messages going from SAP ATTP to MPT CEDM through 3Keys Kazakhstan connector) to MPT .

After executing transaction /K3TKZ/DOCEDO_MONITOR, the screen will be displayed with following selection parameters:

Document Selection section

• MPT CEDM Document Type: internal document type represents MPT CEDM document type

• Industry Identifier: Industry assigned to the report

• Participant Tax Code: Sender tax number assigned to the report

• Object code (EPC): SGTINs or SSCC can be entered

• Original Document Number (XMLJSON): Document number in the MPT XML CEDM JSON document

• Configuration ID: Configuration ID assigned to the report

• Material Number: Material number assigned to Trade item

• GS1 Global Trade Item Number: GTIN

• Lot Number: Lot/Batch number

• Document Number (Bus.trans.): Linked business transaction document number to the report

• Document Year (Bus.trans.): Linked business transaction document year to the report

• Global Location Number: GLN from EPCIS message

• GLN extension: GLN extension from EPCIS message

...

• Processing status: Report processing status of the MPT CEDM report

• MPT CEDM document Status: This status has been received from MPT CEDM system for report

GUID Selection section:

• Document Internal ID: Document header GUID, generates by SAP ATTP on report creation

• MPT CEDM Document GUID: This GUID has been assigned by MPT CEDM to the report, user can enter document GUID (a unique number assigned to report) to search the report

• Request Order ID: Crypto Code Order Reference from OMS

...

• Buttons Today, Last 2 Weeks, Current Month, Current Year, All to simplify date time selection

• Date From: Report creation interval from

• Date To: Report creation interval to

• Sending Date(XMLJSON) From: Report operation date from

• Sending Date (XMLJSON) To: Report operation date to

• Received Date From: Report response received interval from

• Received Date To: Report response received interval to

Additional Parameters section:

• Maximum Hits: Maximum amount messages Inbound messages: Select inbound messages

• Outbound messages: Select outbound messages

• Maximum Hits: Maximum amount messages to be selected

After executing the transaction, a new screen (MPT CEDM reporting cockpit) will be displayed, and report information will be shown based on the search criteria

...

• Direction: Document direction as icon

• Status: Report processing status as icon

• Status: Report processing status as code

• Status: Report processing status as text

• MPT CEDM Document Type: MPT CEDM document type internal codeMPT

• CEDM Document Type: MPT CEDM document type textfrom CEDM system

• Industry Identifier: Report industry

• Global Trade Item Number: GTIN or word Multiple in case multiple GTINs included in the message

• Lot Number: Lot/Batch number or word Multiple in case multiple Lots included in the message

• Material Number: Material number assigned to GTIN from report or word Multiple in case multiple GTINs included in the report

• Configuration ID: Configuration ID from system for MPT CEDM account

• MPT CEDM Document Type Description: MPT CEDM document type text

• Rule Type: Rule triggered based on this rule type from rule configuration

• Created On: Report header creation time converted into user time zone

• Change Changed On: Report header last changing time converted into user time zone

• Sending Date (user): Report event date time converted into user time zone

• Participant Tax code: Sender tax code from report

• Participant Name: Sender name from reportXML

• Counterparty code: Partner tax code

• Counterparty name: Partner name

• Document Number: Document number from XMLJSON

• XML Document Date: Document date from XMLJSON

• Document Number: Document number business transaction

• Document Year: Document year business transaction

• Counterparty Tax code: Receiver tax number from report

• Counterparty Name: Receiver name from system found by tax number

• Document Internal Identifier: Report header GUID

• Event Internal Identifier: Event GUID

• Created by: Report creation user

• Changed by: Report changed user

• Report Type: Report type code (1 - Notification / 2 - OMS)

• Global Location Number: GLN from triggering rule event

• Global Location Number Extension GLN extension from triggering rule event

• Location Name: Location name text

...

• Refresh: Refresh shown entries based on selection screen values

• ALV Grid standard buttons to filter, to sort, to search displayed data, changing layout, printing

• Cancel: The message header with all related messages will be canceled

• Approval: The message header with all related messages will be checked for sequence, approved, and sendSequence Check

• : The Maintain Missing Data: The Popup window appears to input additional message fields and process notification with additional details

• Sequence Check: The log of the sequence check for selected message

• Change Log: The log of actions and field changes for the selected message

• Navigate: Menu of functions for the selected message includes:

  • Display events: Navigation to the event in ATTP Cockpit

  • Display business transactions:  Navigation to the business transactions in ATTP Cockpit

  • Display reporting events: Navigation to the reporting event in ATTP Cockpit

• Reset No response: Reset status “No response” for selected reports to get response again (visible only if there is at least 1 message with status “No response”)

• Software Version: Display installed Release and Notes for MPT CEDM Connector

The click on GTIN or Lot Number will show Popup with calculated quantities.

...

• Status: Report item processing status as icon

• MPT CEDM Document Status: Status received from MPT CEDM system for report

• MPT CEDM Document EDI Status: EDI Status received from MPT CEDM system for reportCreated on: Message creation time converted into

• Send status: Current sending status (Sending process is document type depended and includes several steps)

• Created on: Message creation time converted into user time zone

• Changed on: Message last changing time converted into user time zone

• Event Internal Identifier: Event GUID

• Received on: Message last response received time converted into user time zone

• Send on: Message last send time converted into user time zone

• File ID: Unique File ID for XML generated by SAP ATTP

• Error text: Error text received on sending / response (Double click available to receive full error text)

• CEDM Document EDI Status: EDI status from MPT systemMPT Document EDI ID: EDI ID from MPT CEDM system

• Document Internal Item Identifier Report item GUID

• MPT CEDM Document GUID: GUID assigned by MPT CEDM to the report

• Event Internal Identifier: Event GUID

• AIF Message AIF Message ID: Reporting event AIF GUID

• Created by: Report creation user

• Changed by: Report changed user

• Processing status: Report item processing status

• Document Internal Identifier: Report header GUID

• Configuration ID: Configuration ID from system for MPT CEDM account

• Report Type: Report type code (1 - Notification / 2 - OMS)

• MPT CEDM Document Type: MPT CEDM document type internal code

• Rule Type: Rule type report has been triggered

...

• ALV Grid standard buttons to filter, to sort, to search displayed data, changing layout, printing

• Refresh: Refresh messages related to the selected header

• MPT CEDM Message: Menu of functions for the selected message includes:

  • Display Document Summary JSON: Request document summary JSON online from MPT CEDM and display to the user

  • Download Document Summary JSON: Request document summary JSON online from MPT CEDM and store as file

  • Display Document Details JSON: Request document details JSON online from MPT CEDM and display to the user

  • Download Document Details JSON: Request document details JSON online from MPT CEDM and store as file

  • Display Msg XML: Request XML online from MPT CEDM and display to the user

  • Download Msg XML: Request XML online from MPT CEDM and store as file

  • Reset processing status: Remove processing status to request processing status again from ISMTCEDM

  • Repeat message sending: Send message again to MPTCEDM

  • Get response now: Get response for report immediately

• Message AIF: Menu of functions for the selected message includes:

  • Display Message XMLJSON: Display AIF message

  • Download Message XMLJSON: Download AIF message

  • Message AIF: Show AIF transaction

  • Display processing log: Display application log

• Special functions: extra functions

  • Update Objects MPT CEDM status: Update MPT CEDM status for message objects

  • Update token: Request new token from MPT system

...

• • Accept document: Accept inbound CEDM document at CEDM system

  • Reject document: Reject inbound CEDM document at CEDM system

  • Reset Event Extensions: Delete Event additional properties to Retrigger message and fill data using Missing Data function

  • Delete Draft at CEDM: Delete document Draft at CEDM system and cancel message

CEDM message processing status

The MPT CEDM message processing status defined allowed actions for the message in 3Keys Kazakhstan Connector MPTCEDM:

• 01-init: Outbound message created.

• 05-missing_data: Message processing stop and waiting of user to maintain the missing message data to generate the reporting

• 07-wait_approval: Message processing stop and waiting for user approval via transaction /K3TKZ/DOCEDO_MONITOR

• 10-queued: Message is currently in processing by queue or sequence check failed. Wait until queue is processed or other message will be processed, and sequence check will be successful. The user can manually approve the message and skip the sequence check

• 15-ready_for_send: Message sequence check performed successfully, and message is waiting for sending

• 20-sent: Message sent to MPT CEDM system and waiting of processing status update

• 30-confirmed: Message successfully confirmed (end status)

• 40-error: Message processed with error. Message can be resent again.

• 45-error_missing_data: ATTP reporting error, message data can be corrected by user with function “Maintain missing data” and resent again

• 50-recalled: message has been recalled by initiator

• 85-no_response: MPT CEDM response error, maximum number of response error counter exceeded, status can be reset with function “Reset no response” and requested again

• 99-cancelled: Message is canceled by user (end status)

...

Request Serial number information transaction /K3TKZ/

...

EDO_SN_INFO

The Request Serial Number information transaction /K3TKZ/MPTEDO_SN_INFO is used to request information for serial number from MPT CEDM (using True CEDM API method through 3Keys Kazakhstan connector MPTCEDM).

After executing transaction /K3TKZ/MPTEDO_SN_INFO, the screen will be displayed with following selection parameters:

• Configuration ID: Configuration ID to execute True CEDM API request

• Update MPT CEDM status: execute MPT CEDM status update based on received information

• Object Code (EPC): SGTINs or SSCC can be entered, example 010048123456712321FMExgy3VznHVV

• Object Code (EPC): multiple SGTINs or SSCC can be entered

• Document Internal ID: GUID from report monitor for object selection

• Reporting event ID: GUID from reporting event for object selection

• Document Number (Bus.transaction): TRN document for object selection

• Document Year (Bus.transaction): TRN document for object selection

• ALV grid: Display ALV grid with object data from JSON response

• Display as JSON: Display response from MPT CEDM system

After executing the transaction, JSON file will be displayed or error message in case True CEDM API request failed with error

If Checkbox Update MPT CEDM status is activated SGTIN status is updated in the DB table /K3TKZ/OBJEDO_STA

...

Create OMS report program /K3TKZ/EDO_OMS_REP

The Create OMS report program /K3TMTK3TKZ/EDO_OMS_REP is used to create entries at /K3TMT/REP_MONITOR transaction with type OMS report (91) for created reporting events with type BR_CRYPTO_COMM.

After executing program /K3TKZ/EDO_OMS_REP, the screen will be displayed with following selection parameters:

• Event internal ID: reporting event ID for manual run

• Rule type: reporting event rule type, example BR_CRYPTO_COMM

• Reporting notification type: reporting event notification type, example RR_CC

• Number Report OMS, %: number of objects for MPT CEDM status check in %

• Min object number: number of objects in reporting event to check all objects instead of object number based on % calculation

• Configuration ID: Configuration ID to execute True CEDM API request

• Delay before first check: Delay after event creation before first MPT CEDM status check

• Max repeat number: Stop execution after specified number of errors

After executing the transaction, for each selected reporting event program calculates object number for status check based on selection screen values. For each object program check MPT CEDM status via True CEDM API request. If status for all objects is “Applied” the following actions performed:

• New header and report entry created at transaction /K3TKZ/DOCEDO_MONITOR with type OMS report and status “Confirmed”

• Initial MPT CEDM status creates for reporting event SGTINs

• Event of processed reporting events marked as processed.

...

If reporting event have objects with status “Applied” and other status program creates header and report entry at transaction /K3TKZ/DOCEDO_MONITOR with type OMS report and status “Error”

...

Change

...

CEDM document attributes program /K3TKZ/

...

EDO_CHANGE

The Change MPT CEDM document attributes transaction /K3TKZ/DOCEDO_CHANGE is used to correct data /K3TKZ/DOCEDO_MONITOR transaction if necessary.

After executing program /K3TKZ/DOCEDO_CHANGE, the screen will be displayed with following selection parameters:

• Document internal ID: Document monitor header GUID

• Document internal item ID: Document monitor item GUID

• Set Header Status: Execute header status field update

• Processing status: Processing status to be set

• Set Item Status: Execute item status field update

• Processing status: Processing status to be set

...

• Delete Draft at CEDM system: Execute API request to delete Draft from CEDM system

• RFC Destination: CEDM API RFC destination

• Configuration ID: Configuration ID for CEDM API request

• CEDM Document GUID: CEDM Draft document ID to be deleted

After executing the transaction, for each selected document monitor entry program updates attributes based on selection screen values. Change log entry is created.

...

Upload configuration to SAAS transaction /K3TKZ/

...

EDO_API_SAAS

Transaction /K3TKZ/MPTEDO_API_SAAS is used to configure MPT CEDM Connector SAAS part.

Predefined RFC connection to connector with empty Path prefix is required. For example, if you have RFC connection “MPT“ “CEDM“ for sending notifications with Path prefix, please create new connection “MPT“CEDM_API“ with the same credentials without Path prefix.

Selection screen variant save is not allowed.

Available actions:

• Display certificate information: receive certificate information from connector

• Upload CertificateParticipant: upload file and send certificate file to connector (P12 file is expected)

• Upload Configuration: upload file and send configuration file to connector (YAML file is expected)

For each action authority check is performed with authorisation authorization object /K3TKZ/001 EDO field /K3TKZ/DAC EAС values 53-Display Certificate, 54-Upload Participant/Certificate, 55-Upload Configuration.

...

Test

...

CEDM API transaction /K3TKZ/

...

EDO_API_TEST

Transaction /K3TKZ/MPTEDO_API_TEST is used to test MPT CEDM API.

Predefined RFC connection to connector with empty Path prefix is required.

...

• Health Check: test connector status

• Display certificate information: receive certificate information from connector

• API Call: execute API call to MPT CEDM system

For each action authority check is performed with authorisation object /K3TKZ/001 EDO field /K3TKZ/DAC EAC values 53-Display Certificate, 56-Call API, 57-Health Check.

...

CEDM API Audit Log transaction /K3TKZ/

...

EDO_API_LOG

Transaction /K3TKZ/MPTEDO_API_LOG is used to display MPT CEDM API Audit Log.

Authority check is performed on transaction run with authorisation object /K3TKZ/001 EDO field /K3TKZ/DAC EAC value 58-Display MPT API Audit Log.

Transaction has selection screen to search specific entries at MPT CEDM API Audit Log database table. To restrict log selection log attributes can be specified.

Result data display with ALV grid. Due to technical reasons value of fields REQUEST, RESPONSE, PATH is shortened on display to get detail information double click is supported. To get full list export file option is available.

Process inbound documents from CEDM system program /K3TKZ/EDO_DOC_IN

The process inbound documents from CEDM system program /K3TKZ/EDO_DOC_IN is used to process inbound CEDM documents uploaded from CEDM to SAP ATTP.

After executing program /K3TKZ/EDO_DOC_IN, the screen will be displayed with following selection parameters:

• CEDM Document Type: CEDM document type (for example “0010” - Act of acceptance)

• CEDM Configuration ID: Configuration ID assigned to the CEDM document

• Document Internal item ID: CEDM document GUID assigned to the message by ATTP

• Server error response codes: Response codes to be parsed by program as server errors

• Stop after failed attempts: Stop program execution after server error series

After executing the transaction, depending on selection screen values:

• The program downloads inbound documents from last Run date till current date time and store message into inbound message table with status “02”-Initially received

• Program read inbound documents with status “02”-Initially received

• The program updates the status of the inbound message

• The program downloads header, detail and codes for each inbound document with status received and transfers this message to SAP AIF for further processing.

The following steps executed:

• create /K3TKZ/EDO_MONITOR entry

• run specific logic given in the customizing for inbound document processing

• create reporting events for inbound document

Change time for Kazakhstan CEDM inbound message check transaction /K3TKZ/EDO_CHG_RUN

The timestamp of the last successful inbound message download from CEDM stored in the SAP ATTP. This timestamp can be adjusted with transaction /K3TKZ/EDO_CHG_RUN.

After executing transaction /K3TKZ/EDO_CHG_RUN, the screen will be displayed with following selection parameters:

• CEDM Configuration ID: Configuration ID assigned to CEDM Run Date

• Set new time manually (radio button)

• Date: new date for inbound document check

• Time: new time for inbound document check

• Calculate new time (radio button): Calculate new date time based on current date time minus specified days

• Subtract days from today: Number of days to calculate new date for inbound document check

• Display actual values (radio button): Display current values of dates for inbound document check

• Test run (no update):

After executing the transaction, date for inbound document check is updated and execution log is displayed.

If Checkbox Test run is activated no update is performed.