mockup_loader icon indicating copy to clipboard operation
mockup_loader copied to clipboard

something for data joins

Open sbcgua opened this issue 5 years ago • 0 comments

e.g. data preaparion is more convenient table by table, but maybe real select would a join (LIKP+LIPS ...). Either a tool to join on the fly, or a deep-like feature to "continue loading corresponsing field from another tab joined by field X"

UPD Something like excel data model

'head-kunnr -> kna1-kunnr'  - select one rec from kna1
'head-vbeln -* lines-vbeln' - join with all recs from lines (opposite of ->)

Then select from lines,head,kna1 and the logic auto-joins all 3 tables, starting with lines. Maybe needs a param to keep the fields from prev tables (e.g. field that is in lines and head - which has the prio ?)

sbcgua avatar Dec 20 '20 16:12 sbcgua