Skip to Content
0
Sep 12, 2023 at 10:00 AM

Reproduce "Invoice Report" in cic0 - printed document line items with net amount

155 Views Last edit Sep 11, 2023 at 12:09 PM 2 rev

Dear experts,

I'm having a hard time trying to re-create a table that resembles the "invoice report" on cic0 from SAP ISU (Utilities) and will be used to show all the printed line charge names with its amounts that are also present in the printed invoice document.

I know that the tables ERDK - DBERDL - DBERDLB shall be used (and presumably also Dberchz1 - dberchz3 - erch - zqcr_ageing_cust) but I was not able to match it with the "invoice report".

Could anyone kindly provide me with the related SQL code or if not possible what should I filter out/join/union so I will be able to reconstruct it?

Many thanks in advance and I'm sorry if my question violates any policy.