Service Order Report

former_member515644 · ‎07-05-2023

Hi,

Kindly I am creating a report on Service Sales order. I have certain queries listed below:.

1. How I can get BSEG-SGTXT on the basis of aufk-aufnr or sales order (vbeln). Any other logic you may determine.

where I may WIP details.

2. Get the Document Date either from BKPF or AUAK.

Thanks & Regards,

Lakashey Pajnee

Eduardo-CE · ‎07-05-2023

Hello,

Heres a blog on the relationship between MM and FI Tables:

Regards.

Replacing values in SQL Query