HANA SQL or Graphical Calculation View for Sales Order Schedule Line against Delivery?

[sajithr]

Hi HANA Gurus,

My basic requirement is to track deliveries (delivery documents) against each confirmed SO schedule line in HANA either through graphical calculation model or via a SQL-Script. Has anyone tried that already in HANA and able to share the code / model?

I already tried this and have partial success. As shown below, I can get all deliveries for all schedule lines but picking only the relevant ones (the ones colored in red should not come) is bit challenging according the way data comes.

Have you got a different idea or has anyone implemented this as a HANA graphical model (or as a SQL script)?

Thank you in advanced

[jpfriends079]

To achieve this requirement of yours, "you need to have your own logic".
This simply because your logic needs to get derived not only based on confirmed date & quantities in sales order schedule.
But also this need to consider business process involved along with Item Categories & Schedule Lines.

Moreover, there is NO Standard / General logic derived in ECC to link confirmed schedule line (VBEP) and delivery doc (LIKP/LIPS).
As you don't have schedule line in Delivery Docs.

Generally, we use Table VBFA to establish a relationship between Sales Doc Type and subsequent Delivery Doc.
And there no field for sales order - schedule categories.

Thanks,
JP

[sajithr]

Hi Jyoti,

As you can see from the column headers, I have already gone through that process and just a matter of handling the duplicates for improved accuracy. I wanted to know and wondering whether someone has created / gone through this sort of a thing already.

Thanks
SR

[jpfriends079]

Yes, I did observe that while responding to you.
Even I understand you have concerns based on "Duplicate Entries".

Say, if your logistics user is creating delivery by using VL01N, then, in that case, deriving a rule is difficult.

You can refer below discussion, where there is a code given for a similar requirement.
SAP Community Discussion - Link between delivery line item and sales order item schedule line

Thanks,
JP