I am making report in BI which is PO report.
For that my different Fields are coming from different tables of SAP ECC.
My Selection Parameters are:Material, Material Group, Purchasing group, Vendor, Plant, Created By, Purchasing DOC.TYPE, Purchasing Doc (these all are Optional)
Current Date, To Date (Which are PO Pricing Date and that are Mandatory)
For 1 PO number I am getting NO. of line item data as per PO Item.
My Reports Fields I am getting From:
EKPO and EKKO : PO Number, Material Number, Vendor Code , Plant Code, PUrchase Organization, Purchasing Document Type, Material Group, Purchase Requisition Number, Purchasing Document Date, Purchasing Group, Po Item, Purchase order Quantity, Purchase Order UOM, Created By, Payment terms, Company Code, PO Gross Order Value in INR, PO Net order Value in INR
Here as a prompt I have passed PO number
EKET: Delivery Date(EINDT), Delivered Quantity(WEEMG) , .
EKBE: Tax Code(MWSKZ), GRN Date (BUDAT),
RSEG :Invoice (MENGE)
EBAN: PR Release Date (AEDAT)
I am confused about which Data Source to take or by which way I have to do minimum enhancement.
Please sugguest me any idea.
Thanks in advance,