Skip to Content
0
Former Member
Sep 08, 2010 at 06:45 AM

copy po price from ztable

15 Views

We have a Ztable with below structure where the approved purchase prices are stored. We have created a routine which checks whether the PO price is matching to the prices in this table w.r.t. the validity date.

Can we copy the price from this table to PO directly. i.e, no user will enter the price in PO or info record but the PO will adopt the price from below table.

MANDT MANDT CLNT 3 0 Client

KSCHL KSCHA CHAR 4 0 Condition type

LIFNR ELIFN CHAR 10 0 Vendor Account Number

MATNR MATNR CHAR 18 0 Material Number

EKORG EKORG CHAR 4 0 Purchasing Organization

WERKS WERKS_D CHAR 4 0 Plant

SEQU NUMC 13 0 Sequence Number

DATAB KODATAB DATS 8 0 Validity start date of the condition record

DATBI KODATBI DATS 8 0 Validity end date of the condition record

KBETR KBETR_KOND CURR 11 2 Rate (condition amount or percentage) where no scale exists

KONWA KONWA CUKY 5 0 Rate unit (currency or percentage)

KPEIN KPEIN DEC 5 0 Condition pricing unit

kindly revert.

thanks in advance.