I think I need to make a new thread. Thanks for the help with my previous quesiton.
I have two DELETE statements showing in code inspector. Why would it be a performance issue?
Any suggestions?
SELECT ordid
FROM /bmw/ts_1143_log AS a
W...
DELETE statement for result of SELECT statement found
SELECT plnum,
rsnum,
meins,
' ' AS xdel
FROM plaf AS a
WHERE plnum IN @gt_wb
AND paart EQ @gc_pe
AND pstmp IN @gr_pstmp
AND
EXISTS ( SELECT...
Transaction Code: CV04N
Go to Object Links tab > Vendor > press F4
It will display search help KRED_C (then KRED_T). Elementary search help KREDI (Vendors by Country/Company Code) only allows one selection. My requirement is to enable multiple...
Hi Gurus,I am encountering problems with the initial display of Inbound delivery (VL33). The output does not appear in the header portion.Here's the scenario:1. Inbound delivery created using the PO with output details (VL31).2. But when I initially ...
Gurus,Need help in t-code MB0A (Goods Receipt - PO Unknown). My supplied data are the ff: 1. Movement type (101)2. Plant 3. SLOC4. Delivery (under Find POs for Preceding Document).The system does not display any error when saving. It will even give ...
Posted another two on the wrong thread. My apologies.I have remaining errors with the same concern.1.) SELECT ordid
FROM /bmw/ts_1143_log AS a
WHERE ordid IN @s_ordid
AND order_comp_flag EQ @space
AND
EXISTS ( SELECT *
...
There's 2 more and I'd really appreciate your inputs. 1.) LOOP AT lt_plaf
ASSIGNING FIELD-SYMBOL(<fs_plaf>).
READ TABLE lt_zmrp
INTO DATA(ls_zmrp)
WITH KEY cno_order = <fs_plaf>-plnum+3(7).
IF sy-subrc NE 0.
MOVE aba...
This is how I did it...TYPES:
BEGIN OF tv_plaf,
plnum TYPE plaf-plnum,
rsnum TYPE plaf-rsnum,
xdel TYPE flag,
END OF tv_plaf.
DATA:
lt_plaf_temp TYPE STANDARD TABLE OF tv_plaf
WITH NON-UNIQUE SORTED KEY xdel
COMPONENTS xdel.
*MOVE CORRESPONDING
lt_...
> > Logging only takes place if parameter rec/client in the system profile is set correctly. Setting the flag on its own does not cause the table changes to be logged.> Hi how do you set the rec/client in the system profile?Thanks
