Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT numzaj, sc~ZZSRM2_DOCUM_EXT, sc~ZZSRM2_NPPNUM
- FROM crmd_orderadm_h AS h
- JOIN crmd_order_i AS I
- ON h~guid = i~parent
- JOIN bbp_pdisc AS sc
- ON sc~guid = i~guid
- JOIN ZTSRM2_SC_EXT AS ext
- ON ext~ZSRM2_OBJECT_ID = h~object_id
- FOR ALL ENTRIES IN lt_cart
- WHERE h~guid = lt_cart~guid.
- 3. SELECT tline
- FROM crmd_link AS lk
- JOIN crmd_partner AS r
- ON r~guid = lk~guid_set
- JOIN but000 AS bt
- ON bt~partner_guid = r~partner_no
- JOIN hrp1002 AS p
- ON p~objid = bt~pernod
- JOIN hrt1002 AS t
- ON t~tabnr = p~tabnr
- FOR ALL ENTRIES IN lt_rpz
- WHERE lk~guid_hi = lt_rpz-guid
- r~partner_fct = 'Z060'
- AND r~del_ind = SPACE.
- 4. SELECT object_id
- FROM crmd_orderadm_h AS h
- FOR ALL ENTRIES IN lt_ilot
- WHERE h~guid = lt_ilot~guid.
- 5. SELECT erp_slot
- FROM ZTSRM2_ERP_SLOT AS sl
- FOR ALL ENTRIES IN lt_ilot
- WHERE sl~guid = lt_ilot~guid
- 6. SELECT gp~guid, ct~CATEGORY_TEXT
- FROM bbp_pdhgp AS hp
- JOIN bbp_pdigp AS gp
- ON gp~src_guid = hp~guid
- JOIN COMM_CATEGORYT AS ct
- ON ct~CATEGORY_GUID = gp~category
- FOR ALL ENTRIES IN lt_rpz
- WHERE gp~guid = lt_rpz-guid.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement