Dear expert,
Can anyone please help me on below urgently.
I need to create Bex report using data in SAP R/3.
Business scenario: my client is having a software product package which they give to their customer on contract for a year or two these contracts are renewable and changeble so even deltas will be taken into account.
Its related to Contracts which are created using transaction VA41 in SAP R/3.
My interest of data is maily in below tables.
VBAK ( Contract header information )
VBAP ( Contract Item Information)
VEDA ( To get the Item level validity dates)
KOMV ( Item level pricing to catch perticular condition type value on item level)
VBPA ( Item level partner information so as to run the report on partner type like for one perticular partner how much amount of contracts are there e.g account manager, customer group based contract report)
Some text tables.
Kindly let me know the best way and method of extraction and modelling step by step.
Your help is really appreciated.
Thank you very much in advance.
Best regards,
Shan