topic Re: PO net value in Application Development and Automation Discussions

PO net value

Former Member — Mon, 02 Jun 2008 17:18:57 GMT

Hi,

I am trying to get the PO net value . me23n - header section - tab 'Conditions' - field 'Net'

on reading old threads i got some function modules

ME_FILL_KOMK_PO

ME_FILL_KOMP_PO

ME_DETERMINE_NET_PRICE

MM_NET_PRICE_CALCULATE

ME_GET_PRICE_CONDITION

ME_DETERMINE_SALES_PRICE

ME_PRICING_MARKET_PRICE

ME_SELECT_SOURCE_BY_PRICE

CALCULATE_TAX_ITEM

I am stil trying to figure out how to use these to get the PO Net value.

I am not MM functional, I am an ABAPer

Could you please give any guidance ?

thank you in advance

dipti

Re: PO net value

Former Member — Mon, 02 Jun 2008 17:28:42 GMT

Hi,Select KNUMV from EKKO by passing the Purchase Order No.

With the retrieved KNUMV, go to KONV and get the KBETR, which should give you the Net Amount.

Regards,

Faheem

Re: PO net value

Former Member — Mon, 02 Jun 2008 17:40:37 GMT

Hi Dipti,

Please check this

ME_DETERMINE_NET_PRICE

  DATA:    BEGIN OF xa068 OCCURS 10.
          INCLUDE STRUCTURE a068.
  DATA:    END OF xa068.
CALL FUNCTION 'ME_DETERMINE_NET_PRICE'
        EXPORTING
          i_kotabnr = '068'
          i_komg    = komg
          i_komk    = komk
          i_komp    = komp
          i_kappl   = 'M'
          i_date    = sy-datlo
          i_kschl   = xa068-kschl
        IMPORTING
          e_komp    = komp.

MM_NET_PRICE_CALCULATE

 DATA: T_KONP LIKE KONP OCCURS 0 WITH HEADER LINE.
CALL FUNCTION 'MM_NET_PRICE_CALCULATE'
    EXPORTING
      I_KOMK = KOMK
      I_KOMP = KOMP
    IMPORTING
      E_KOMP = KOMP
    TABLES
      T_KONP = T_KONP
    EXCEPTIONS
      OTHERS = 0.

ME_DETERMINE_SALES_PRICE

DATA: gtkomp TYPE t_stab_gtkomp WITH HEADER LINE.
CALL FUNCTION 'ME_DETERMINE_SALES_PRICE'
         EXPORTING
              I_EKKO                = EKKO
              I_EKPO                = EKPO
              I_T001                = T001
              I_BUDAT               = PREISDATUM  "= Buchungsdatum
              I_ONLY_LOCAL_CURRENCY = 'X'
         IMPORTING
              E_VKWRT               = GTKOMP-VKWRT
              E_VKWRA               = GTKOMP-VKWRA
         TABLES
              I_TKOMV               = TKOMV.

Best regards,

raam

Re: PO net value

Former Member — Mon, 02 Jun 2008 18:16:11 GMT

Hi Faheem,

If there are multiple records in KONV for the KNUMV, should I add them up ?

I did the same method as you said for one of the POs. But I got another value.

I pickd EKKO-KNUMV for the purchase order and then added KONV-KBETR for the entriesfor this KNUMV

but the total is 20,000 which the net value should in me23n is 100,000,000

is there any further calculation with EKPO values also ?

Re: PO net value

Former Member — Mon, 02 Jun 2008 18:18:03 GMT

Hi Raam,

what should I give in all those structures ?

where should I give the PO number ?

what else do i need apart from PO number ? do i need all those values of so many structures komg , komk, komp ?

thanks

Re: PO net value

Former Member — Mon, 02 Jun 2008 18:24:13 GMT

Hello Dipti,

Use the BAPI "BAPI_PO_GETDETAIL" to get the net price of the PO. Pass the Po number in the import parameter.

Hope this answers your question.

Re: PO net value

Former Member — Mon, 02 Jun 2008 18:36:28 GMT

hi Greetson,

thanks for the BAPI

but it doesnt give net value. the output structure PO_HEADER doesnt have the field.

thanks

Re: PO net value

Former Member — Mon, 02 Jun 2008 18:43:26 GMT

Hello Depti,

Check the table parameters:

POCONDHEADER

POCOND

POITEM

Two options you have :

1) Retrieve the net value from the pricing Condition values table parameter or

2) use the PO Items table parameter and sum all the item net values.

Hope this helps.

Thanks,

Greetson

Re: PO net value

ritesh_dugad2 — Tue, 03 Jun 2008 07:41:11 GMT

Once you get the conditionss pricing, you also have to add to it the net price for each PO line Item. You can use EKPO-NETWR or EKPO-BRTWR for this.

The conditions table KONV stores pricing condtion data for both line items as well as for header. So you have to know if your conditions are maintained at header level or at item level in the PO. You can ask this to your MM consultant. If it is maintained at header level then only select rows where konv-kposn is '000000' or space. If pricing conditions are maintained at item level then select rows where konv-kposn NE '000000' or space.

Hope this way you will get the net price of PO.

Re: PO net value

Former Member — Tue, 03 Jun 2008 13:01:18 GMT

Hi Ritesh,

Which field should I take from KONV ? KAWRT or KBETR ?

-thnx

Re: PO net value

Former Member — Tue, 03 Jun 2008 13:46:31 GMT

Hi,

Faheem is correct.

Select KNUMV from EKKO by passing the Purchase Order No.

With the retrieved KNUMV, go to KONV and get the KWERT field, which should give you the Net Amount.

Thanks

Ramesh

Re: PO net value

Former Member — Tue, 03 Jun 2008 17:32:20 GMT

hi,

if i add all the EKPO-NETWRs and KONV-KWERTs then the figure doesnt match the Net value

if i add only the EKPO-NETWRs then it does match

are the condition values not considered in the EKPO-NETWR for the items ?

why do I have to visit the KONV table at all ?

if yes, how should I calculate ?

in the KONV table,

KWERT = KAWRT*KBETR. (condition base value * conditon rate)

KAWRT = EKPO-NETWR for condition types NAVS and SKTO whereas

KAWRT = some other value for condition types PB00 and WOTB

i dont know if these condition types are standard or custom

is it that both the tables EKPO and KONV shudnt be used together and any one of the two EKPO or KONV should be chosen to get the Net value (as given in the BAPI example above)

thanks.

Re: PO net value

ritesh_dugad2 — Wed, 04 Jun 2008 04:31:40 GMT

Hi Dipti,

You should take KONV-KBETR field for calculations.

Thanks

Re: PO net value

Former Member — Thu, 05 Jun 2008 12:20:06 GMT

i have only added EKPO-NETWRs

i still dont know KONV calculation

closing the thrd.