Intrastat and service purshasing

[Former Member]

Hello

In our excel intrastat report for import made in ENGR, we get now and then purshased services which does not correspond to any goods movement. Sorting them out is quite a nightmare and are time cosuming. Is there any way to sort them out automatically before creating the excel report?

What is the prerequisite of a purshased row in order to be included in the ENGR report?

BR

Magnus

[former_member215181]

Hi Magnus,

This is not really a GTS question, since it relates to Intrastat collection in ERP; however...

MM Intrastat does not have the same sophistication as SD Intrastat, so there is no configuration to assist you.  Instead, you will need to code the User-Exit EXIT_SAPLV50G_001, as described in the IMG under Foreign Trade/Customs > Periodic Declarations > Control Data > Data Selection Control.

I don't know what services look like in your system, but if, for example, they use Item Category 'D' ("Service"), your code might look like this:

  * Arrivals - Purchasing

  IF I_REPORTING_TYPE = 'I'

    AND I_DIRECTION = '1'.

  * No reporting for services

    IF C_MM_PURCH_ORDER_LINE_ITEM-pstyp = '9'.

      E_EXCLUDE_FROM_SELECTION = 'X'.

    ENDIF.

  ENDIF.

[Conversion from technical to displayed Item Category values are held in table T163Y)

Hope that helps.

Regards,

Dave