TCODE to display the list of Service Entry that has the GL account and Activity number

[Former Member]

Hi!

Good day!

Is there a mapping between the service code and GL account? Upon checking there is a table that provides the Service Entry Sheet and GL account (Table ESKN where Service Entry Sheet Number = ESKN-PACKNO).

Also, is there a standard tcode that contains the following information found in corresponding tables:

     1. Service Entry Sheet Number (ESSR-LBLNI)

     2. Activity Number  (ESSL-SRVPOS)

     3. GL Account (ESKN-SAKTO) - Service Entry Sheet = ESKN-PACKNO

Best Regards,

[Former Member]

Hi Rila,

There is no standard report with these fields.

Check report - MSRV6 Reporting on Service, But no GL accinfo.

You can build SQVI report since there is a linkage between below tables

ESSR> ESLL> ESKN

Please find the below screen shot,

Regards,

Pallavi

[Former Member]

Hi Pallavi,

Thanks for your reply. However, in table ESSKN, the package number corresponds to the entry sheet number. Linking those two fields in SQVI is not possible. Does this mean that we need an ABAP report for this requirement?

Regards,

RILA

[Former Member]

Hi Rila,

We built an Z-report for similar requirement.

Regards,

Pallavi