Advertisement
Suncatcher

Untitled

Mar 31st, 2019
194
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.10 KB | None | 0 0
  1. SELECT numzaj, sc~ZZSRM2_DOCUM_EXT, sc~ZZSRM2_NPPNUM
  2. FROM crmd_orderadm_h AS h
  3. JOIN crmd_order_i AS I
  4. ON h~guid = i~parent
  5. JOIN bbp_pdisc AS sc
  6. ON sc~guid = i~guid
  7. JOIN ZTSRM2_SC_EXT AS ext
  8. ON ext~ZSRM2_OBJECT_ID = h~object_id
  9. FOR ALL ENTRIES IN lt_cart
  10. WHERE h~guid = lt_cart~guid.
  11.  
  12. 3. SELECT tline
  13. FROM crmd_link AS lk
  14. JOIN crmd_partner AS r
  15. ON r~guid = lk~guid_set
  16. JOIN but000 AS bt
  17. ON bt~partner_guid = r~partner_no
  18. JOIN hrp1002 AS p
  19. ON p~objid = bt~pernod
  20. JOIN hrt1002 AS t
  21. ON t~tabnr = p~tabnr
  22. FOR ALL ENTRIES IN lt_rpz
  23. WHERE lk~guid_hi = lt_rpz-guid
  24. r~partner_fct = 'Z060'
  25. AND r~del_ind = SPACE.
  26.  
  27. 4. SELECT object_id
  28. FROM crmd_orderadm_h AS h
  29. FOR ALL ENTRIES IN lt_ilot
  30. WHERE h~guid = lt_ilot~guid.
  31.  
  32.  
  33. 5. SELECT erp_slot
  34. FROM ZTSRM2_ERP_SLOT AS sl
  35. FOR ALL ENTRIES IN lt_ilot
  36. WHERE sl~guid = lt_ilot~guid
  37.  
  38. 6. SELECT gp~guid, ct~CATEGORY_TEXT
  39. FROM bbp_pdhgp AS hp
  40. JOIN bbp_pdigp AS gp
  41. ON gp~src_guid = hp~guid
  42. JOIN COMM_CATEGORYT AS ct
  43. ON ct~CATEGORY_GUID = gp~category
  44. FOR ALL ENTRIES IN lt_rpz
  45. WHERE gp~guid = lt_rpz-guid.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement