‎2019 Sep 17 9:09 AM
by using date and plant as input i need to produce output Billing Date. Type Reference. Date. Line Item
‎2019 Sep 17 10:16 AM
Hi Manoj requirement is not clear, as per your question hope you need to get Sales data of given date against a plant, assuming that you can get details in VBRK and VBRP table by filtering posting date in vbrk and followed by pass vbeln and plant in vbrp....
‎2019 Sep 17 10:38 AM
Hello You have to write a Join statement on VBRK and VBRP,
VBRK-FKDAT is the Billing Date Field
VBRP-WERKS is the plant field.
All the fields from these two tables can be taken by giving your input values to the fields(mentioned above) in the where condition.
‎2019 Sep 17 12:35 PM
Sorry Satish, i downvoted your reply not because it's wrong, but because i think spoon feeding isn't the best way to help 🙂
Manoj would have a better answer, imho, helping him to understand the requirement (exposing it fully) and being "hinted" and guided to the solution.
Again, no grudge.
Simone
‎2019 Sep 17 1:05 PM