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
thanks in advance.