09-29-2008 7:34 AM
Hi,
I have to update some fields(Start,finish dates) and change status of AUFFX,STLFX in the Standard Table PLAF..for a particular planned order(PLNUM)
what is the BAPI I should be using through which I can do this?
Transaction Used - MD12
Please let me know if have to provide any further information..
09-29-2008 7:37 AM
Hi
As u know the fields and the table u need to update, U can write an ABAP program and update/modify that particular table instead of doing the whole BAPI.
Just put all the values into an flat file,bring it into SAP using GUI_UPload or ALSM_EXCEL_INTERNAL_TABLE(if excel) and then take it into internal table...
Loop the internal table and then update/modify the master table.
Regards,
Vishwa.
09-29-2008 7:50 AM
this is a standard sap table... you cannot modify/ update it directly.........
09-29-2008 7:40 AM
09-29-2008 7:41 AM
09-29-2008 7:57 AM
Ya.. in the mean while I'm exploring all the bapis related to planned order... I found it.... thank you
09-29-2008 7:58 AM
Ya.. in the mean while I'm exploring all the bapis related to planned order... I found it.... thank you
09-29-2008 7:58 AM
hi
using the foll statement in ABAP program, we can update as it is a Transparent table:
I am pasting example code here:
tables:skat.
types: begin of acc,
mandt type skat-mandt,
ktopl type skat-ktopl,
saknr type skat-saknr,
txt20 type skat-txt20,
txt50 type skat-txt50,
mcod1 type skat-mcod1,
end of acc.
data: glmaster type skat,
saknr type ska1-saknr,
bilkt type ska1-bilkt.
data: acc1 type standard table of acc,
acc2 type acc.
data: conv type acc.
data: xl_acc1 type alsmex_tabline occurs 1 with header line.
CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'
EXPORTING
FILENAME = 'C:\Documents and Settings\pri\Desktop\gltext1.xls'
I_BEGIN_COL = 1
I_BEGIN_ROW = 3
I_END_COL = 5
I_END_ROW = 182
TABLES
INTERN = xl_acc1.
* EXCEPTIONS
* INCONSISTENT_PARAMETERS = 1
* UPLOAD_OLE = 2
* OTHERS = 3
.
IF SY-SUBRC <> 0.
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
* WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.
loop at xl_acc1.
case xl_acc1-col.
when '1'.
acc2-ktopl = xl_acc1-value.
when '2'.
acc2-saknr = xl_acc1-value.
when '3'.
acc2-txt20 = xl_acc1-value.
when '4'.
acc2-txt50 = xl_acc1-value.
when '5'.
acc2-mcod1 = xl_acc1-value.
append acc2 to acc1.
endcase.
endloop.
*delete from skat.
loop at acc1 into acc2.
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
EXPORTING
INPUT = acc2-saknr
IMPORTING
OUTPUT = saknr.
.
move saknr to acc2-saknr.
move sy-mandt to acc2-mandt.
.
move-corresponding acc2 to glmaster.
.
update skat from glmaster. " here the master table is getting updated.
endloop.
Edited by: vishwa sri hari on Sep 29, 2008 8:58 AM