Sangeeta, this depends on the configuration, so you'd have to check in your own system. There are statuses available in VBUK (header) and VBUP (item) tables. Unfortunately, the order statuses are pretty much not updated anymore after delivery is created. So fo the purposes of such report, a developer would need to get the data from different places.
Assuming the report is at item level, I'd start checking the VBUP-GBSTK (Overall) status. (I'm typing field names from memory, sorry if I'm off a bit.) If it'a 'A' then there is no delivery created yet. If it's 'B' or 'C' then delivery # will need to be read from VBFA table. For delivery there should be Goods Issue status and Billing status again in VBUP table (assuming you have a delivery-related billing scenario).
Again, there is no "one size fits all" answer, there will be some research needed based on the specific requirements for the report and your configuration.
As a side note - I wish there was something like that in standard SAP because we have a very similar report. It would be great if statuses were updated in the sales order instead of having to dig for information in other tables. Perhaps we should put it on Idea Place...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.