FM: ZBAPI_PRICES_CONDITIONS
Tables
TI_BAPICONDCT
TI_BAPICONDHD
TI_BAPICONDIT
TI_BAPICONDQS
TI_BAPICONDVS
TO_BAPIRET2
TO_BAPIKNUMHS
TO_MEM_INITIAL
.
---------------------------
輸入參數1(結構)
TI_BAPICONDCT: 條件表的BAPI 結構(與COND_RECS一致);
OPERATION: 功能;
COND_USAGE: 條件表的用途;
TABLE_NO: 條件表;
APPLICATIO: 應用程式;
COND_TYPE: 條件類型;
VARKEY: 字元 100; 銷售組織+ 配銷通路 + [客戶] + 物料
VALID_TO: 條件記錄的有效期限;
AGREE_COND: 協議(不同條件組合一起);
VALID_FROM: 條件記錄的生效日期;
COND_NO: 條件記錄號碼;
VADAT: 字元 100;
--------------------------
輸入參數2(結構)
TI_BAPICONDHD: 帶有英文欄位名的 KONH的BAPI結構;
OPERATION: 功能;
SD_DOC: 銷售與配銷文件號碼;
ITM_NUMBER: SD 文件的項目號碼;
COND_NO: 條件記錄號碼;
CREATED_BY: 建立者;
CREAT_DATE: 記錄建立的日期;
COND_USAGE: 條件表的用途;
TABLE_NO: 條件表;
APPLICATIO: 應用程式;
COND_TYPE: 條件類型;
VARKEY: 字元 100;
VALID_FROM: 生效日期;
VALID_TO: 有效期限;
SEARCHTERM: 條件的搜尋條件;
RESPONS: 在SD中負責條件/物料;
PROMOT_NO: 促銷;
SALES_DEAL: 銷售交易;
SALESQUOTE: 銷售報價;
STD_AGRMNT: 標準協議;
PROMOTION: 促銷;
REBAGREEMT: 協議(後續結算);
LIC_NO: 免稅許可證號碼;
LIC_DATE: 許可證的許可日期;
VARDATE: 字元 100;
----------------------------
輸入參數3(結構)
TI_BAPICONDIT: 帶有英文欄位名的KONP的BAPI結構;
OPERATION: 功能;
SD_DOC: 銷售與配銷文件號碼;
ITM_NUMBER: SD文件的項目號碼
COND_NO: 條件記錄號碼;
COND_COUNT: 條件的序號;
APPLICATIO: 應用程式;
COND_TYPE: 條件類型;
TEXT_NO: 內文號碼;
SCALETYPE: 等級類型;
SCALEBASIN: 等級基礎指示碼;
SCALE_QTY: 條件等級數量;
UNITMEASUR: 條件等級計量單位;
MEASUR_ISO: ISO代碼內目標數量計量單位;
SCALE_VAL: BAPIs 的幣別金額(含九個小數位);
CURRENCKEY: 等級貨幣;
CURREN_ISO: ISO幣別代碼;
CALCTYPCON: 條件的計算類型;
COND_VALUE: BAPIs 的幣別金額(含九個小數位);
CONDCURR: 比率單位(貨幣或百分比);
COND_ISO: ISO幣別代碼;
COND_P_UNT: 條件定價單位;
COND_UNIT: 條件單位;
CONUNITISO: ISO代碼內目標數量計量單位;
PRICELEVEL: 價格層次;
NUMCONVERT: 將條件單位轉換到基本單位的指標;
DENOMINATO: 用於轉換條件單位為基礎單位的分母;
BASE_UOM: 基礎計量單位;
BASEQTYISO: ISO代碼內目標數量計量單位;
LOWERLIMIT: BAPIs 的幣別金額(含九個小數位);
UPPERLIMIT: BAPIs 的幣別金額(含九個小數位);
PLCONDVAL: BAPIs 的幣別金額(含九個小數位);
CUM_VALUE: BAPIs 的幣別金額(含九個小數位);
CUMM_ACCR: BAPIs 的幣別金額(含九個小數位);
CURRENCY: 幣別碼;
CURR_ISO: ISO 幣別代碼;
CONDCURREN: 條件貨幣(針對累計欄位);
ISOCURRENC: ISO 幣別代碼;
PLAN_BASIS: BAPIs 的幣別金額(含九個小數位);
RATE_UNIT: 計價單位(貨幣、銷售單位或%);
EXCLUSION: 條件排斥指示碼;
CUSTOMER: 客戶編號1;
VENDOR_NO: 供應商或貸方的帳號;
TAX_CODE: 銷售稅碼;
INDIDELETE: 條件項目的刪除指示碼;
CONDITIDX: 條件項目索引;
MATLSETTL: 用於回扣結算的物料;
ACCRUALS: BAPIs 的幣別金額(含九個小數位);
REB_RETROA: 回扣是以追溯的方式設立;
STATOFAGRE: 協議狀態;
PROMOT_NO: 促銷;
SALES_DEAL: 銷售交易;
SALESQUOTE: 銷售報價;
ADD_VAL_DY: 附加銀行入帳日期;
FIX_VAL_DY: 固定生效日;
PMNTTRMS: 付款條件碼;
NUMBORDERS: 每一條件記錄的銷售訂單最大數;
MINCONBAVA: 最小條件基值;
MAXCONBAVA: 最大條件基值;
MAXCONVAL: BAPIs 的幣別金額(含九個小數位);
INCR_SCALE: 增量等級的號碼;
PRICSCALE: 定價等級號碼;
RELPRCG: 售價計算: 關於定價;
PROMOTION: 促銷;
REBAGREEMT: 協議(後續結算);
WITHTAXCOD: 扣繳稅代碼;
CONTRACT: 契約類型;
CONTRACTNO: 契約號碼;
FLOW_TYPE: 流量類型;
INDIMATMAI: 指示碼: 矩陣維護;
STATUS: 核發狀態;
UMSABST: 條件業務量比較的狀態;
MATLSETTL_EXTERNAL: MATLSETTL欄位的長物料號碼;
MATLSETTL_GUID: MATLSETTL欄位的外部GUID;
MATLSETTL_VERSION: MATLSETTL欄位的版本號碼;
-------------------------
TI_BAPICONDQS: 帶有英文欄位名的KONM 的BAPI 結構;
--------------------------
TI_BAPICONDVS: 帶有英文欄位名的 KONW 的BAPI 結構;
---------------------------
輸出參數(結構)
TO_BAPIRET2: 傳回參數;
TYPE: 訊息類型: S成功, E錯誤, W警告, I資訊, A取消;
ID: 訊息, 訊息類別;
NUMBER: 訊息, 訊息號碼;
MESSAGE: 訊息內文;
LOG_NO: 應用程式日誌: 日誌號碼;
LOG_MSG_NO: 應用程式記錄: 內部訊息序號;
MESSAGE_V1: 訊息, 訊息變數;
MESSAGE_V2: 訊息, 訊息變數;
MESSAGE_V3: 訊息, 訊息變數;
MESSAGE_V4: 訊息, 訊息變數;
PARAMETER: 參數名稱;
ROW: 參數內的行;
FIELD: 參數內的欄位;
SYSTEM: 訊息起源的邏輯系統;
------------------------
TO_BAPIKNUMHS: KNUMH 指派的 BAPI 結構;
------------------------------
TO_MEM_INITIAL: 條件：初始上傳的緩衝.
說明:
TABLE_NO: 物料: 304; 客+物料: 305;
VARKEY: 銷售組織(4字元) + 配銷通路(2字元) + [客戶(10字元)] + 物料;
其余欄位參照以下范例.
范例:
101Dev報表: ZBAPI_PRICES_CONDITIONS.
*&---------------------------------------------------------------------*
*& Sample code of using the Fm:'BAPI_PRICES_CONDITIONS'
*&---------------------------------------------------------------------*
report zbapi_prices_conditions.
*******************************************
data: wtable1 type bapicondct,
wtable2 type bapicondhd,
wtable3 type bapicondit,
wtable4 type bapicondqs,
wtable5 type bapicondvs,
ret type bapiret2, "wtable6
wtable7 type bapiknumhs,
wtable8 type cnd_mem_initial.
data: table1 like table of bapicondct,
table2 like table of bapicondhd,
table3 like table of bapicondit,
table4 like table of bapicondqs,
table5 like table of bapicondvs,
table6 like table of bapiret2,
table7 like table of bapiknumhs,
table8 like table of cnd_mem_initial.
***********************************************
initialization.
start-of-selection.
perform add_data.
perform process_data.
*&---------------------------------------------------------------------*
*& Form add_data
*&---------------------------------------------------------------------*
form add_data.
wtable1-cond_usage = 'A'. "條件表的用途
wtable1-table_no = '305'. "304物料;客+物料305 "條件表
wtable1-applicatio = 'V'. "應用程式
wtable1-cond_type = 'PR01'. "條件類型
wtable1-operation = '009'. "功能
wtable1-varkey = '6000010000060021CD7102Z-C04-53'. "字元 100
wtable1-valid_to = '99991231'. "條件記錄的有效期限
wtable1-valid_from = sy-datum. "條件記錄的生效日期
wtable1-cond_no = '$000000001'. "條件記錄號碼
wtable1-vadat = 'Y'. "處理狀態: 待審批N; 已審批Y
append wtable1 to table1.
*-----------------------------------------------
wtable2-operation = '009'. "功能
wtable2-cond_no = '$000000001'. "條件記錄號碼
wtable2-created_by = sy-uname. "物件建立者的姓名
wtable2-creat_date = sy-datum. "記錄建立的日期
wtable2-cond_usage = 'A'. "條件表的用途
wtable2-table_no = '305'. "條件表
wtable2-applicatio = 'V'. "應用程式
wtable2-cond_type = 'PR01'. "條件類型
wtable2-varkey = '6000010000060021CD7102Z-C04-53'. "字元 100
wtable2-valid_from = sy-datum. "生效日期
wtable2-valid_to = '99991231'. "有效期限
append wtable2 to table2.
*-----------------------------------------------------
wtable3-operation = '009'. "功能
wtable3-cond_no = '$000000001'. "條件記錄號碼
wtable3-cond_count = '01'. "條件的序號
wtable3-applicatio = 'V'. "應用程式
wtable3-cond_type = 'PR01'. "條件類型
wtable3-scaletype = 'A'. "等級類型
wtable3-scalebasin = 'C'. "等級基礎指示碼
wtable3-scale_qty = '1'. "條件等級數量
wtable3-cond_p_unt = '1'. "條件定價單位
wtable3-cond_unit = 'PCS'. "條件單位
wtable3-calctypcon = 'C'. "條件的計算類型
wtable3-cond_value = '501'. "BAPIs 的幣別金額﹝含九個小數位
wtable3-condcurr = 'USD'. "比率單位（貨幣或百分比）
wtable3-condcurren = 'USD'.
append wtable3 to table3.
*--------------------------------------------------------
endform. "add_data
*&---------------------------------------------------------------------*
*& Form process_data
*&---------------------------------------------------------------------*
form process_data.
call function 'ZBAPI_PRICES_CONDITIONS'
* call function 'BAPI_PRICES_CONDITIONS'
* EXPORTING
* PI_initialmode = 'X'
* PI_BLOCKNUMBER =
tables
ti_bapicondct = table1
ti_bapicondhd = table2
ti_bapicondit = table3
ti_bapicondqs = table4
ti_bapicondvs = table5
to_bapiret2 = table6
to_bapiknumhs = table7
to_mem_initial = table8
exceptions
update_error = 1
others = 2.
if sy-subrc <> 0.
message id sy-msgid type sy-msgty number sy-msgno
with sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
endif.
read table table6 with key type = 'E' transporting no fields.
if sy-subrc = 0.
loop at table6 into ret.
write: / ret-type, ret-message, ret-id, ret-log_no, ret-log_msg_no,
ret-message_v1, ret-message_v2, ret-message_v3, ret-message_v4,
ret-parameter,ret-row,ret-field.
endloop.
else.
call function 'BAPI_TRANSACTION_COMMIT'
*EXPORTING
* WAIT =
importing
return = ret.
endif.
endform. "process_data
【文章来自于百度文库，此处仅作记录和学习交流，版权归原作者所有】
1651
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
