topic Re: bapi_goodsmvt_create in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/bapi-goodsmvt-create/m-p/2780902#M648173 <HTML><HEAD></HEAD><BODY><P>Sudhir,</P><P>Once the goods movement is posted thru the function you will get the material document number from the export parameter of the bapi </P><P>"MATERIALDOCUMENT" you can use this in your select query</P></BODY></HTML> Wed, 05 Sep 2007 14:31:08 GMT Former Member 2007-09-05T14:31:08Z bapi_goodsmvt_create https://community.sap.com/t5/application-development-and-automation-discussions/bapi-goodsmvt-create/m-p/2780901#M648172 <HTML><HEAD></HEAD><BODY><P>hi from my bapi code i need to get the materialdocuemnt and i need to use it in select querry. please let me know how to get the material document from bapi, please correct my select querry, or i need to use internal table or loop...</P><P></P><P>loop at itab.</P><P></P><P>select ADUMMY from ZCORE_HEADER INTO table T_ADUMMY WHERE RMATNR =</P><P>ITAB-MATNR.</P><P></P><P></P><P></P><P> REFRESH: item, RETURN.</P><P> CLEAR: item, GOODSMVT_HEADER, RETURN,</P><P> MATERIALDOCUMENT, GOODSMVT_HEADRET.</P><P></P><P></P><P></P><P> MOVE '04' TO GOODSMVT_CODE.</P><P> MOVE SY-DATUM TO GOODSMVT_HEADER-PSTNG_DATE.</P><P> MOVE SY-DATUM TO GOODSMVT_HEADER-DOC_DATE.</P><P> item-MATERIAL = ITAB-MATNR.</P><P> item-PLANT = PLANT.</P><P> item-STGE_LOC = ITAB-LGORT.</P><P> item-ENTRY_UOM = ITAB-MEINS.</P><P> item-ENTRY_QNT = ITAB-VERME.</P><P> item-MOVE_TYPE = '919'.</P><P> READ TABLE T_ADUMMY INDEX 1.</P><P> item-MOVE_MAT = T_ADUMMY-ADUMMY.</P><P> item-MOVE_PLANT = PLANT.</P><P> item-MOVE_STLOC = ITAB-LGORT.</P><P> item-MOVE_REAS = ' '.</P><P> item-MVT_IND = ' '.</P><P> APPEND item.</P><P></P><P> CALL FUNCTION 'BAPI_GOODSMVT_CREATE'</P><P> EXPORTING</P><P> GOODSMVT_HEADER = GOODSMVT_HEADER</P><P> GOODSMVT_CODE = GOODSMVT_CODE</P><UL><LI level="1" type="ul"><P> TESTRUN = ' '</P></LI></UL><P> IMPORTING</P><P> GOODSMVT_HEADRET = GOODSMVT_HEADRET</P><P> MATERIALDOCUMENT = MATERIALDOCUMENT</P><P> MATDOCUMENTYEAR = MATDOCUMENTYEAR</P><P> TABLES</P><P> GOODSMVT_ITEM = item</P><UL><LI level="1" type="ul"><P> GOODSMVT_SERIALNUMBER = GOODSMVT_SERIALNUMBER</P></LI></UL><P> RETURN = RETURN</P><P> .</P><P> LOOP AT return WHERE type = 'E'.</P><P> MESSAGE ID return-id</P><P> TYPE return-type</P><P> NUMBER return-number</P><P> WITH return-message.</P><P> EXIT.</P><P> ENDLOOP.</P><P></P><P> CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'</P><P> EXPORTING</P><P> WAIT = 'X'</P><P> IMPORTING</P><P> RETURN = RETURN.</P><P> .</P><UL><LI level="1" type="ul"><P> CALL FUNCTION 'DEQUEUE_ALL'</P></LI><UL><LI level="2" type="ul"><P> EXPORTING</P></LI><LI level="2" type="ul"><P> _SYNCHRON = ' '</P></LI></UL><LI level="1" type="ul"><P> .</P></LI></UL><P>*</P><P></P><P></P><P></P><P></P><P></P><P> SELECT UBNUM FROM LUBU INTO TABLE T_UBNUM WHERE LGNUM = '0054'AND</P><P> MBLNR = MATERIALDOCUMENT AND BWART = '919'.</P><P></P><P>endloop.</P></BODY></HTML> Wed, 05 Sep 2007 14:14:24 GMT https://community.sap.com/t5/application-development-and-automation-discussions/bapi-goodsmvt-create/m-p/2780901#M648172 Former Member 2007-09-05T14:14:24Z Re: bapi_goodsmvt_create https://community.sap.com/t5/application-development-and-automation-discussions/bapi-goodsmvt-create/m-p/2780902#M648173 <HTML><HEAD></HEAD><BODY><P>Sudhir,</P><P>Once the goods movement is posted thru the function you will get the material document number from the export parameter of the bapi </P><P>"MATERIALDOCUMENT" you can use this in your select query</P></BODY></HTML> Wed, 05 Sep 2007 14:31:08 GMT https://community.sap.com/t5/application-development-and-automation-discussions/bapi-goodsmvt-create/m-p/2780902#M648173 Former Member 2007-09-05T14:31:08Z