topic Re: BAPI for MD12 in Application Development and Automation Discussions

BAPI for MD12

Former Member — Mon, 29 Sep 2008 06:34:08 GMT

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..

Re: BAPI for MD12

Former Member — Mon, 29 Sep 2008 06:37:19 GMT

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.

Re: BAPI for MD12

former_member585060 — Mon, 29 Sep 2008 06:40:54 GMT

Try this BAPI

BAPI_PLANNEDORDER_CHANGE

Re: BAPI for MD12

Former Member — Mon, 29 Sep 2008 06:41:07 GMT

Did you explore BAPI transaction?

BAPI_PLANNEDORDER_CHANGE??

Re: BAPI for MD12

Former Member — Mon, 29 Sep 2008 06:50:05 GMT

this is a standard sap table... you cannot modify/ update it directly.........

Re: BAPI for MD12

Former Member — Mon, 29 Sep 2008 06:57:17 GMT

Ya.. in the mean while I'm exploring all the bapis related to planned order... I found it.... thank you

Re: BAPI for MD12

Former Member — Mon, 29 Sep 2008 06:58:17 GMT

Ya.. in the mean while I'm exploring all the bapis related to planned order... I found it.... thank you

Re: BAPI for MD12

Former Member — Mon, 29 Sep 2008 06:58:27 GMT

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