Skip to Content
0
Sep 17, 2014 at 07:02 AM

migo-101 document

112 Views

HI,

I want to show 101 document (not obtained for 543), with subcontracting po (pstyp = 3) .....so i am fetching value from

SELECT A~MBLNR " Number of Material Document

A~MJAHR " Material Document Year

A~ZEILE_I " Item in Material Document

A~BLART " Document Type

A~BLDAT " Document Date in Document

A~BUDAT " Posting Date in the Document

A~CPUDT " Day On Which Accounting Document Was Entered

A~TCODE " Not More Closely Defined Area, Possibly Used for Patchlevels

A~BWART_I " Movement Type (Inventory Management)

A~WERKS_I " Plant

A~BKTXT " DOC HEADER TXT

A~XAUTO_I " CREATED ON

A~ERFMG_I " QTY

A~MEINS_I " UNIT OF MEASURE

A~USNAM "CREATED BY

A~MATNR_I

A~EBELN_I

A~EBELP_I

B~EBELN "PO NUMBER

B~EBELP "LINE ITEM

B~PSTYP "ITEM CATEGORY

FROM WB2_V_MKPF_MSEG2 AS A INNER JOIN EKPO AS B ON

A~EBELN_I = B~EBELN AND

A~EBELP_I = B~EBELP AND

A~MATNR_I = B~MATNR

*

INTO CORRESPONDING FIELDS OF TABLE IT_MKPF

WHERE BUDAT IN SO_BUDAT AND

BWART_I IN ('101', '543') AND

PSTYP EQ '3'.



but here am getting mblnr having both (101) and (-543) document.

i want 101 document with pstyp = 3.


Any one suggest???????