topic Re: I'm using the EXIT_SAPLV56U_004 for my user exit of transaction VT02N in Application Development and Automation Discussions

I'm using the EXIT_SAPLV56U_004 for my user exit of transaction VT02N

Former Member — Mon, 10 Sep 2007 11:18:14 GMT

Hi All,

I'm unable to start my coding in the include ZXV56U11.Whether to fetch data with select statements or with read statements?

My requirement is as follows I hav created my table with the specification given Yloxxx..

The function exit performs three actions:

1. Removes deliveries that are completely unloaded from shipment

2. Prevents entering a shipment completion for partially loaded deliveries

3. Removes fully loaded deliveries from phantom shipment

Exit is called when entering the shipment completion

- Shipment completion is entered via transaction VT02N, VT06, VT12….

- Call is performed when the program updates the field VTTK-STABF (completion status / flag)

In include ZXV56U11 following tasks must be performed,

Initial check

All treatments must be conditioned to the existence of an authorized combination record shipment type / plant stored in a specific table YLOxxx

 if no entry exist in this table -> end treatment: exit transaction without saving shipment completion

Check is performed as follows:

- Select shipment number (field TKNUM) from table VTTK

o get shipment type (field SHTYP) and store it in a buffer table

- Select shipment number (field TKNUM) from table VTTP

o get first delivery number (VBELN) in case several deliveries are linked to the shipment

 select delivery number as per previous step from LIPS

• get plant (WERKS ) related to first delivery item and store it in buffer table

- Check existence of combined record (plant /shipment type),stored as buffer, in custom table YLOxxx (see specification of table below)

o If combined record exits, continue execution of user exit

o If combined record does not exist, end treatment: exit transaction without saving shipment completion

 Display error message: “shipment not managed with profile #2, no shipment completion required”

Please help me out........

Thanks,

santosh

Re: I'm using the EXIT_SAPLV56U_004 for my user exit of transaction VT02N

RaymondGiuseppi — Mon, 10 Sep 2007 11:25:02 GMT

You have to read the internal tables provided to the exit : look at the Function Module documentation and parameters. (Of course you must select from database the tables not provided)

+Désign.

Shipment Processing: Prepare New Objects for Saving

Functionality

This function is called up when shipments are saved and the shipment

table has been prepared for the update in the database (for example,

number assignment, person who last made changes, the time changes wer

made).

In this function, you can make changes to the shipment tables.

If you want to update your own objects together with the shipment

tables, you have to prepare them here for the update.

Example

If you want to update objects that are to contain the shipment number

the objects must have the assigned shipment number when a shipment is

created.

Newly created shipments are indicated by:

XVTTK-UPDKZ = UPDKZ_NEW.

They contain the old provisional '$nnn' in field

XVTTK-TKNUM_OLD.

The new number is in field

XVTTK-TKNUM.

Notes

Sorting the shipment table

The shipment processing tables are always sorted according to the

database keys so that 'READ TABLE ... BINARY SEARCH' can be used to

access them quickly.

These tables contain entries for several shipments so that the entries

of a shipment are grouped together.

The tables are as follows:

o XVTTK, YVTTK Shipment headers Sort: MANDT,TKNUM

o XVTTP, YVTTP Shipment items Sort: MANDT,TKNUM,TPNUM,VBELN

o XVTTS, YVTTS Shipment stages Sort: MANDT,TKNUM,TSNUM

o XVTSP, YVTSP Assignment stages/items Sort: MANDT,TKNUM,TSNUM,TPNUM

o XVBPA, YVBPA Partner Sort: MANDT,VBELN,POSNR,PARVW

o XVTFA, YVTFA Document flow Sort: Database

o XVBADR,YVBADR Addresses Not sorted

Contents of the shipment tables

Table Xtttt is most current after the change. Table Ytttt stays the same

as it was on the database before the changes were made.

The content of the indicator UPDKZ show the change status. In INCLUDE

RVDIREKT the constants are defined for the indicator:

o updkz_old(1) value ' ' - No change

o updkz_new(1) value 'I' - New entry

o updkz_update(1) value 'U' - Changed entry

o updkz_delete(1) value 'D' - Delete entry

Table XVTTP contains both entries of deliveries belonging to a shipment

(TKNUM, TPNUM have entries), as well as entries for deliveries that do

not belong to a shipment (TKNUM, TPNUM are blank).

Changes

If you make changes or create new entries, you must take the sorting

into account.

If you want to access entries of a shipment in one of the tables, select

the first entry and read the corresponding segment for this shipment per

'LOOP':

read table xvttp with key mandt = sy-mandt

tknum = i_tknum

binary search.

if sy-subrc = 0.

loop at xvttp from sy-tabix.

if xvttp-tknum ne i_tknum. exit. endif.

...

endloop.

endif. +

Regards

Re: I'm using the EXIT_SAPLV56U_004 for my user exit of transaction VT02N

Former Member — Mon, 10 Sep 2007 11:30:55 GMT

Hi Raymond,

The answer you have given is usefull but my probelm over here is

when comparing with key in READ statement

for example

Read table i_xvttk with key tknum = ? with what value shall i compare

Thanks,

Santhu.

Re: I'm using the EXIT_SAPLV56U_004 for my user exit of transaction VT02N

RaymondGiuseppi — Mon, 10 Sep 2007 11:35:48 GMT

I_VTTK is the header table, LOOP AT it, then READ for dependant tables

Regards