3 weeks ago
Hi expert,
We need to schedule a job to make automate process to move 311 movement type to 261 movement type by using BAPI_PRODORDCONF_CREATE_TT.
We have to take input to BAPI_PRODORDCONF_CREATE_TT from below logic which contains 311 movement type data.
DATA lt_matkl TYPE tt_matkl.
DATA lv_plant TYPE werks_d.
DATA lv_project TYPE xblnr.
CONSTANTS : lc_m10 TYPE werks_d VALUE 'M10',
lc_m14 TYPE werks_d VALUE 'M14'.
IF iv_key = 'M14CPMAT'.
lv_plant = lc_m14.
ELSEIF iv_key = 'M10CPMAT'.
lv_plant = lc_m10.
ENDIF.
SELECT project,
concat( concat( site, '-' ), project ) AS title
FROM zct_project
WHERE site = @LV_plant
AND job = 1
INTO TABLE @DATA(lt_project).
READ TABLE lt_project INTO DATA(ls_project) INDEX 1.
lv_project = ls_project-project.
ev_title = ls_project-title.
SELECT marc~matnr,
makt~maktx,
t023t~matkl,
t023t~wgbez,
t023t~wgbez60,
mard~lgort,
mseg~erfmg,
CASE
WHEN mbew~vprsv = 'V' THEN mseg~erfmg * mbew~verpr
WHEN mbew~vprsv = 'S' THEN mseg~erfmg * mbew~stprs
END AS Amount,
mkpf~mblnr,
mkpf~bktxt,
mkpf~budat
FROM marc
INNER JOIN makt ON marc~matnr = makt~matnr
INNER JOIN mard ON makt~matnr = mard~matnr
INNER JOIN mbew ON mard~matnr = mbew~matnr
INNER JOIN mara ON mara~matnr = mbew~matnr
INNER JOIN t023t ON mara~matkl = t023t~matkl
INNER JOIN mseg ON marc~matnr = mseg~matnr
INNER JOIN mkpf ON mseg~mblnr = mkpf~mblnr
WHERE mseg~erfmg IS NOT INITIAL
AND mard~lgort = '600'
AND mseg~lgort = mard~lgort
AND mseg~bwart = '311'
AND mkpf~bktxt = @LV_project
AND marc~werks = @LV_plant
AND mseg~werks = marc~werks
AND marc~werks = mard~werks
AND marc~werks = mbew~bwkey ORDER BY t023t~matkl ASCENDING
INTO TABLE @ET_cpmat.
We checked and found that order number and plant is mandatory for mentioned Bapi.
Order number is created by a person in plant, and we are not able find out table name of this order number.
Where to find the table against the order number.
Kindly advise.
User | Count |
---|---|
81 | |
11 | |
10 | |
8 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.