Need tables and Fields to get data for Customer 360 in CI

[jagadheeswar_raju]

Dear Friends,

I have a requirement to get the data based on BP number:

Below mentioned data is required. Please provide the tables and fields.

Invoices will be collective invoices. We are not using individual/normal invoices for this requirement.

Fields / data required based on BP:

1. Collective Invoices Nos

2. Invoice Dates

3. Invoice Periods

4. Invoice Amount ( total Invoice amount including current)

5. Inovice Clearing status

6. Payment Amount ( total amount paid)

7. Payment Date ( last payment date)

Thanks,

Raju

[faisal_pc]

Hi...Tables like DFKKOP and DFK*INV*H should give these details.