2014 Mar 27 2:06 PM
HI ,
I have a requirement based on ISU source, we require Table/ Datasource for reporting for Energy providers.
Service order, IHD reason not installed, Installation date, customer number, Cust name, address, ward, smart energy expert PAY, District etc.
I find this really difficult to make out from the table or datasource which is relevant to the requirement.
Any fields you may think relevant. Please mention.
Thanks
Vasanth Rajagopal
2014 Mar 27 3:22 PM
Hi Vasanth,
your requirement to fetch the business details , can not be cater by single table. These data fetched with different tables like business partner details get from, BUT000, Address: ADRC, installation : EANL.
Discuss with abaper to make the report.
Regards,
AnUrAg.
2014 Mar 28 6:50 AM
Hi Anurag,
Thanks for the info.,
Few doubts..
1. Business partner number and Customer Account number are same? ( QMEL-KUNUM and
BUT000-PARTNER )
2. Any idea which table/ fields can be mapped for IHD Reason, SEE PAY and Ward? Can it be from any of the table you mentioned?
I believe, there could not be any datasource available for this.
The requirement to be implemented in BW / BI system and goes on to BO reports.
~ Vasanth
2014 Mar 28 8:43 AM
Hi Vasanth,
This is regarding your first question only .
Yes, When a BP ( BUT000-PARTNER) is created at that time customer(KNA1-KUNNR) is created in background with the same no. range due to customization in SPRO for Setting for creating standard Customer.
Regards,
AnUrAg
.